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 |