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