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 |