Field Listing for Table JOBLINEISSUES

Field:ORDERNUMBER Type: VARCHAR Length: 15
Field:COMPONENTTYPE Type: VARCHAR Length: 20
Field:COMPONENTCODE Type: VARCHAR Length: 50
Field:COMPONENTDESCRIPTION Type: VARCHAR Length: 255
Field:COMPONENTUNIT Type: VARCHAR Length: 15
Field:ISSUEQTY Type: DOUBLE
Field:ISSUEDATE Type: DATE
Field:ISSUEWAREHOUSE Type: VARCHAR Length: 20
Field:ISSUELOCATION Type: VARCHAR Length: 20
Field:SERIALNO Type: VARCHAR Length: 30
Field:EXPIRYDATE Type: DATE
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:ISSUEUNITCOST Type: DOUBLE
Field:NOINVENTORYTRANS Type: BOOLEAN
Field:CHARGESTYLE Type: VARCHAR Length: 20
Field:NONCHARGECODE Type: VARCHAR Length: 50
Field:EMPLOYEENAME Type: VARCHAR Length: 30
Field:EMPLOYEERATESCALE Type: VARCHAR Length: 20
Field:ISSUEREVERSAL Type: BOOLEAN
Field:ISSUESOURCE Type: VARCHAR Length: 10
Field:RECEIPTNUMBER Type: VARCHAR Length: 15
Field:RECEIPTDESCRIPTION Type: VARCHAR Length: 255
Field:RECORDEDNOTES Type: BLOB
Field:PICKEDSERVICEID Type: VARCHAR Length: 30
Field:ACTUALSYSUNIQUEID Type: DOUBLE
Field:JOBLINESYSUNIQUEID Type: DOUBLE
Field:POLINESYSUNIQUEID Type: DOUBLE
Field:PURCHASERECEIPTALLOCID Type: DOUBLE
Field:SOURCESYSUNIQUEID Type: DOUBLE
Field:HEADERSYSUNIQUEID Type: DOUBLE
Field:SYSDATECREATED Type: TIMESTAMP
Field:SYSDATEMODIFIED Type: TIMESTAMP
Field:SYSUNIQUEID Type: DOUBLE
Field:SYSUSERCREATED Type: VARCHAR Length: 30
Field:SYSUSERMODIFIED Type: VARCHAR Length: 30