| Column | Description | Data Type | Length | Tables This Field Is In | In Query () | 
| ITEMNMBR | Item Number | String | 32 | View | |
| LOCNCODE | Location Code | String | 12 | View | |
| BIN | Bin | String | 16 | View | |
| QTYTYPE | QTY Type 1 = On Hand  | Integer | 2 | View | |
| QUANTITY | QTY | Currency | 10 | View | |
| ATYALLOC | QTY Allocated | Currency | 10 | View |