Field Listing for Table ITEMSITEMASTER
Field: | ITEMCODE | Type: | VARCHAR Length: 50 |
Field: | SITENAME | Type: | VARCHAR Length: 50 |
Field: | ONHANDQTY | Type: | DOUBLE |
Field: | SUPPLYQTY | Type: | DOUBLE |
Field: | DEMANDQTY | Type: | DOUBLE |
Field: | AVAILABLEQTY | Type: | DOUBLE |
Field: | FREEQTY | Type: | DOUBLE |
Field: | REORDERLEVEL | Type: | DOUBLE |
Field: | REORDERQTY | Type: | DOUBLE |
Field: | REORDERMULTIPLE | Type: | DOUBLE |
Field: | LEADTIME | Type: | INTEGER |
Field: | SOURCEDBY | Type: | VARCHAR Length: 20 |
Field: | SUPPLYMETHOD | Type: | VARCHAR Length: 20 |
Field: | PRIMARYSUPPLIER | Type: | VARCHAR Length: 50 |
Field: | LASTRECEIPTDATE | Type: | TIMESTAMP |
Field: | LASTSALEDATE | Type: | TIMESTAMP |
Field: | LASTCOST | Type: | DOUBLE |
Field: | LASTCOSTDATE | Type: | DATE |
Field: | STANDARDCOST | Type: | DOUBLE |
Field: | STANDARDCOSTDATE | Type: | DATE |
Field: | AVERAGECOST | Type: | DOUBLE |
Field: | AVERAGECOSTDATE | Type: | DATE |
Field: | AVERAGECOSTCHANGE | Type: | VARCHAR Length: 10 |
Field: | CUSTOMSTYLE | Type: | VARCHAR Length: 10 |
Field: | SIZEONHANDQTY | Type: | DOUBLE |
Field: | REORDERBASIS | Type: | VARCHAR Length: 20 |
Field: | SYSDATECREATED | Type: | TIMESTAMP |
Field: | SYSDATEMODIFIED | Type: | TIMESTAMP |
Field: | SYSUNIQUEID | Type: | DOUBLE |
Field: | SYSUSERCREATED | Type: | VARCHAR Length: 30 |
Field: | SYSUSERMODIFIED | Type: | VARCHAR Length: 30 |