Field Listing for Table INVENTORY

Field:ITEMCODE Type: VARCHAR Length: 50
Field:WAREHOUSECODE Type: VARCHAR Length: 20
Field:LOCATIONCODE Type: VARCHAR Length: 20
Field:INVENTORYUNIT Type: VARCHAR Length: 15
Field:INVENTORYQTY Type: DOUBLE
Field:LASTCOST Type: DOUBLE
Field:STANDARDCOST Type: DOUBLE
Field:ITEMAVERAGECOST 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:LASTADJUSTSOURCE Type: VARCHAR Length: 15
Field:LASTADJUSTTYPE Type: VARCHAR Length: 20
Field:LASTADJUSTREFERENCE Type: VARCHAR Length: 50
Field:LASTADJUSTMENTDATE Type: DATE
Field:SYSDATECREATED Type: TIMESTAMP
Field:SYSDATEMODIFIED Type: TIMESTAMP
Field:SYSUNIQUEID Type: DOUBLE
Field:SYSUSERCREATED Type: VARCHAR Length: 30
Field:SYSUSERMODIFIED Type: VARCHAR Length: 30