Field Listing for Table ASSEMBLYBATCHRLINES

Field:RECEIPTBATCHNO Type: INTEGER
Field:RECEIPTDATE Type: DATE
Field:ORDERNUMBER Type: VARCHAR Length: 15
Field:ITEMCODE Type: VARCHAR Length: 50
Field:ITEMDESCRIPTION Type: VARCHAR Length: 255
Field:RECEIPTUNIT Type: VARCHAR Length: 15
Field:TOTALPLANNEDQTY Type: DOUBLE
Field:TOTALRECEIPTEDTODATE Type: DOUBLE
Field:TOTALSCRAPTODATE Type: DOUBLE
Field:RECEIPTQTY Type: DOUBLE
Field:SCRAPQTY Type: DOUBLE
Field:SCRAPCODE Type: VARCHAR Length: 20
Field:RECEIPTUNITCOST Type: DOUBLE
Field:RECEIPTWAREHOUSE Type: VARCHAR Length: 20
Field:RECEIPTLOCATION 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:SYSDATECREATED Type: TIMESTAMP
Field:SYSDATEMODIFIED Type: TIMESTAMP
Field:SYSUNIQUEID Type: DOUBLE
Field:SYSUSERCREATED Type: VARCHAR Length: 30
Field:SYSUSERMODIFIED Type: VARCHAR Length: 30
Field:TOCONTAINERID Type: VARCHAR Length: 20