Field Listing for Table SERVICESHEETHEADER
Field: | SERVICEID | Type: | VARCHAR Length: 30 |
Field: | STYLENAME | Type: | VARCHAR Length: 50 |
Field: | SUBJECTCAPTION | Type: | VARCHAR Length: 200 |
Field: | SUBJECTSUBCAPTION | Type: | VARCHAR Length: 200 |
Field: | SUBJECTRIGHT | Type: | VARCHAR Length: 200 |
Field: | CUSTOMERORJOB | Type: | VARCHAR Length: 20 |
Field: | CUSTOMERORJOBVALUE | Type: | VARCHAR Length: 50 |
Field: | ASSETNAME | Type: | VARCHAR Length: 90 |
Field: | CUSTOMERADDRESS | Type: | VARCHAR Length: 250 |
Field: | EMPLOYEENAME | Type: | VARCHAR Length: 30 |
Field: | TASKORSTEP | Type: | VARCHAR Length: 20 |
Field: | COMPLETED | Type: | INTEGER |
Field: | INVOICEORJOBCREATED | Type: | BOOLEAN |
Field: | INVOICEORJOB | Type: | VARCHAR Length: 10 |
Field: | INVOICEORJOBREFERENCE | Type: | VARCHAR Length: 20 |
Field: | EXTENDEDNETTPRICE | Type: | DOUBLE |
Field: | EXTENDEDGROSSPRICE | Type: | DOUBLE |
Field: | PAYMENTHODMETHOD1 | Type: | VARCHAR Length: 20 |
Field: | PAYMENTREFERENCE1 | Type: | VARCHAR Length: 20 |
Field: | PAYMENTAMOUNT1 | Type: | DOUBLE |
Field: | PAYMENTHODMETHOD2 | Type: | VARCHAR Length: 20 |
Field: | PAYMENTREFERENCE2 | Type: | VARCHAR Length: 20 |
Field: | PAYMENTAMOUNT2 | Type: | DOUBLE |
Field: | TOTALBALANCE | Type: | DOUBLE |
Field: | PAYMENTORDEPOSITNUMBER | Type: | INTEGER |
Field: | DOCUMENTSAVED | Type: | BOOLEAN |
Field: | PICKWAREHOUSE | Type: | VARCHAR Length: 20 |
Field: | PICKLOCATION | Type: | VARCHAR Length: 20 |
Field: | RECORDID | Type: | INTEGER |
Field: | RECORDTIMESTAMP | Type: | TIMESTAMP |
Field: | SYSDATECREATED | Type: | TIMESTAMP |
Field: | SYSDATEMODIFIED | Type: | TIMESTAMP |
Field: | SYSUNIQUEID | Type: | DOUBLE |
Field: | SYSUSERCREATED | Type: | VARCHAR Length: 30 |
Field: | SYSUSERMODIFIED | Type: | VARCHAR Length: 30 |
Field: | ERRORMESSAGE | Type: | VARCHAR Length: 500 |