Field Listing for Table CUSTASSETSCHEDULE
Field: | CUSTASSETNAME | Type: | VARCHAR Length: 90 |
Field: | CUSTOMER | Type: | VARCHAR Length: 50 |
Field: | SELECTED | Type: | BOOLEAN |
Field: | PLANNEDDATE | Type: | DATE |
Field: | JOBTYPE | Type: | VARCHAR Length: 20 |
Field: | SERVICEZONE | Type: | VARCHAR Length: 30 |
Field: | TEMPLATECODE | Type: | VARCHAR Length: 50 |
Field: | TEMPLATEDESCRIPTION | Type: | VARCHAR Length: 100 |
Field: | CONFIRMATIONSTATUS | Type: | VARCHAR Length: 20 |
Field: | REMINDERSTYLE | Type: | VARCHAR Length: 10 |
Field: | REMINDERSENT | Type: | BOOLEAN |
Field: | REMINDERDATE | Type: | DATE |
Field: | REMINDERCONTACTNAME | Type: | VARCHAR Length: 100 |
Field: | CONTACTFIRSTNAME | Type: | VARCHAR Length: 50 |
Field: | CONTACTLASTNAME | Type: | VARCHAR Length: 50 |
Field: | SERVICEDATE | Type: | DATE |
Field: | SERVICENOTES | Type: | BLOB |
Field: | CUSTASSETSTYLE | Type: | VARCHAR Length: 20 |
Field: | HEADERSYSUNIQUEID | Type: | DOUBLE |
Field: | RECURRINGID | Type: | DOUBLE |
Field: | DELETEDFROMRECURRING | Type: | BOOLEAN |
Field: | SCHEDULEGROUPKEY | Type: | VARCHAR Length: 122 |
Field: | SYSDATECREATED | Type: | TIMESTAMP |
Field: | SYSDATEMODIFIED | Type: | TIMESTAMP |
Field: | SYSUNIQUEID | Type: | DOUBLE |
Field: | SYSUSERCREATED | Type: | VARCHAR Length: 30 |
Field: | SYSUSERMODIFIED | Type: | VARCHAR Length: 30 |