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 |