Field Listing for Table ASSEMBLYISSUELINES

Field:ISSUEBATCHNO Type: INTEGER
Field:DATEISSUED Type: DATE
Field:ISSUEORCOMPLETION Type: VARCHAR Length: 10
Field:ORDERNUMBER Type: VARCHAR Length: 15
Field:STEPNAME Type: VARCHAR Length: 20
Field:LINENUMBER Type: INTEGER
Field:CODETYPE Type: VARCHAR Length: 20
Field:LINECODE Type: VARCHAR Length: 50
Field:LINEUNIT Type: VARCHAR Length: 15
Field:LINEDESCRIPTION Type: VARCHAR Length: 255
Field:TOTALISSUEQTYPLANNED Type: DOUBLE
Field:TOTALISSUEQTYTODATE Type: DOUBLE
Field:ISSUEQTY Type: DOUBLE
Field:WAREHOUSECODE Type: VARCHAR Length: 20
Field:LOCATIONCODE 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:RECORDEDNOTES Type: BLOB
Field:LINESTATUS Type: VARCHAR Length: 20
Field:SOURCESYSUNIQUEID 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