Field Listing for Table ASSEMBLYRECEIPTS

Field:ORDERNUMBER Type: VARCHAR Length: 15
Field:ITEMCODE Type: VARCHAR Length: 50
Field:RECEIPTQTY Type: DOUBLE
Field:RECEIPTUNIT Type: VARCHAR Length: 15
Field:RECEIPTDATE Type: DATE
Field:RECEIPTUNITCOST Type: DOUBLE
Field:RECEIPTWAREHOUSE Type: VARCHAR Length: 20
Field:RECEIPTLOCATION Type: VARCHAR Length: 20
Field:SCRAPQTY Type: DOUBLE
Field:SCRAPCODE 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:SYSDATECREATED Type: TIMESTAMP
Field:SYSDATEMODIFIED Type: TIMESTAMP
Field:SYSUNIQUEID Type: DOUBLE
Field:SYSUSERCREATED Type: VARCHAR Length: 30
Field:SYSUSERMODIFIED Type: VARCHAR Length: 30
Field:RECEIPTEDEMPLOYEE Type: VARCHAR Length: 30
Field:RECEIPTEDSERVICEID Type: VARCHAR Length: 30