Field Listing for Table ASSIGNMENTITEMS
| Field: | SUPPLYMETHOD | Type: | VARCHAR Length: 20 |
| Field: | CODETYPE | Type: | VARCHAR Length: 20 |
| Field: | ITEMCODE | Type: | VARCHAR Length: 50 |
| Field: | ITEMDESCRIPTION | Type: | VARCHAR Length: 255 |
| Field: | SITENAME | Type: | VARCHAR Length: 50 |
| Field: | ONHANDQTY | Type: | DOUBLE |
| Field: | REQUIREDQTY | Type: | DOUBLE |
| Field: | REMAININGQTY | Type: | DOUBLE |
| Field: | SHORTAGEQTY | Type: | DOUBLE |
| Field: | RUNOUTTIME | Type: | TIMESTAMP |
| Field: | ASSIGNMENTID | Type: | DOUBLE |
| Field: | ASSIGNMENTTYPE | Type: | VARCHAR Length: 20 |
| Field: | ASSIGNMENTREFERENCE | Type: | VARCHAR Length: 50 |
| Field: | ASSIGNMENTTIME | Type: | TIMESTAMP |
| Field: | SYSDATECREATED | Type: | TIMESTAMP |
| Field: | SYSDATEMODIFIED | Type: | TIMESTAMP |
| Field: | SYSUNIQUEID | Type: | DOUBLE |
| Field: | SYSUSERCREATED | Type: | VARCHAR Length: 30 |
| Field: | SYSUSERMODIFIED | Type: | VARCHAR Length: 30 |