Field Listing for Table ITEMBATCHES

Field:ITEMCODE Type: VARCHAR Length: 50
Field:BATCHNO Type: VARCHAR Length: 50
Field:BATCHDESCRIPTION Type: VARCHAR Length: 100
Field:BATCHNOTES Type: BLOB
Field:BATCHSTATUS Type: VARCHAR Length: 20
Field:ISSUESONHOLD Type: BOOLEAN
Field:SUPPLYSTYLE Type: VARCHAR Length: 20
Field:SUPPLYSOURCE Type: VARCHAR Length: 50
Field:PRODUCTIONDATE Type: DATE
Field:EXPIRYDATE Type: DATE
Field:LASTCHANGEDUSEROREMPLOYEE Type: VARCHAR Length: 20
Field:LASTCHANGEDNAME Type: VARCHAR Length: 50
Field:LASTCHANGEDFROM Type: VARCHAR Length: 20
Field:LASTSERVICEID Type: VARCHAR Length: 30
Field:ITEMANDBATCH Type: VARCHAR Length: 102
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:SUPPLYBATCHNO Type: VARCHAR Length: 50
Field:QTYONHAND Type: DOUBLE