Field Listing for Table ASSIGNMENTSHORTAGES
| Field: | ASSIGNMENTID | Type: | DOUBLE |
| Field: | ASSIGNMENTTYPE | Type: | VARCHAR Length: 20 |
| Field: | ASSIGNMENTREFERNCE | Type: | VARCHAR Length: 50 |
| Field: | ITEMCODE | Type: | VARCHAR Length: 50 |
| Field: | ITEMDESCRIPTION | Type: | VARCHAR Length: 255 |
| Field: | REQUIREDQTY | Type: | DOUBLE |
| Field: | AVAILABLEQTY | Type: | DOUBLE |
| Field: | SHORTAGEQTY | 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 |