Field Listing for Table NOTESHISTORYMASTER
Field: | HISTORYNOTETYPE | Type: | VARCHAR Length: 15 |
Field: | LINKEDTO | Type: | VARCHAR Length: 90 |
Field: | HISTORYNOTEDATE | Type: | DATE |
Field: | HISTORYNOTETIME | Type: | TIME |
Field: | HISTORYNOTEREFERENCE | Type: | VARCHAR Length: 100 |
Field: | HISTORYNOTECATEGORY | Type: | VARCHAR Length: 20 |
Field: | CALLCLASSIFICATION | Type: | VARCHAR Length: 50 |
Field: | CALLSUBCLASS | Type: | VARCHAR Length: 50 |
Field: | RECORDEDHISTORYNOTES | Type: | BLOB |
Field: | SOURCEOFNOTE | Type: | VARCHAR Length: 20 |
Field: | SOURCEREFERENCE | Type: | VARCHAR Length: 50 |
Field: | FOLLOWUPREQUIRED | Type: | BOOLEAN |
Field: | FOLLOWUPDATE | Type: | DATE |
Field: | FOLLOWUPUSER | Type: | VARCHAR Length: 30 |
Field: | FOLLOWUPACTIONED | Type: | BOOLEAN |
Field: | PRIORITYNOTE | Type: | BOOLEAN |
Field: | NOTECOMPANYTYPE | Type: | VARCHAR Length: 20 |
Field: | NOTECOMPANYNAME | Type: | VARCHAR Length: 100 |
Field: | LASTALERTDATE | Type: | DATE |
Field: | LASTEMAILDATE | Type: | DATE |
Field: | FOLLOWUPEMPLOYEENAME | Type: | VARCHAR Length: 30 |
Field: | SYSDATECREATED | Type: | TIMESTAMP |
Field: | SYSDATEMODIFIED | Type: | TIMESTAMP |
Field: | SYSUNIQUEID | Type: | DOUBLE |
Field: | SYSUSERCREATED | Type: | VARCHAR Length: 30 |
Field: | SYSUSERMODIFIED | Type: | VARCHAR Length: 30 |