Field Listing for Table PURCHASEALLOCATIONS

Field:ORDERNUMBER Type: VARCHAR Length: 15
Field:CODETYPE Type: VARCHAR Length: 20
Field:LINECODE Type: VARCHAR Length: 50
Field:ALLOCATIONTYPE Type: VARCHAR Length: 15
Field:ALLOCATIONREFERENCE Type: VARCHAR Length: 50
Field:ALLOCATIONQTY Type: DOUBLE
Field:RECEIPTQTYTODATE Type: DOUBLE
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:TASKORSTEP Type: VARCHAR Length: 20
Field:SOURCELINEDESCRIPTION Type: VARCHAR Length: 255
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