Field Listing for Table SERVICESHEETLINESPICKED

Field:SERVICEID Type: VARCHAR Length: 30
Field:SUBJECTTYPE Type: VARCHAR Length: 50
Field:SUBJECTCAPTION Type: VARCHAR Length: 200
Field:SUBJECTSUBCAPTION Type: VARCHAR Length: 200
Field:SUBJECTRIGHT Type: VARCHAR Length: 200
Field:CODETYPE Type: VARCHAR Length: 20
Field:LINECODE Type: VARCHAR Length: 50
Field:LINEDESCRIPTION Type: VARCHAR Length: 200
Field:LINEUNIT Type: VARCHAR Length: 15
Field:LINEQTY Type: DOUBLE
Field:LINEDATE Type: DATE
Field:SERIALNO Type: VARCHAR Length: 30
Field:EXPIRYDATE Type: VARCHAR Length: 10
Field:BATCHNO Type: VARCHAR Length: 50
Field:REVISIONNO Type: VARCHAR Length: 10
Field:ITEMGRADE Type: VARCHAR Length: 50
Field:ITEMCOLOUR Type: VARCHAR Length: 50
Field:ITEMSIZE Type: VARCHAR Length: 50
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