| Name | Type | Length | Decimal | Relation | Description |
| ITEMNUM | String | 25 | IN ITEMNUM | ||
| WHNUM | String | 8 | IN WAREHOUSE DETAIL WHNUM - The warehouse code | ||
| BINLOC | String | 10 | IN WAREHOUSE DETAIL BINLOC - The bin location of the item | ||
| REORDMETH | String | 1 | IN WAREHOUSE DETAIL REORDMETH - The re-order method to use | ||
| ECOQTY | Decimal | 10 | 3 | IN WAREHOUSE DETAIL ECOQTY - The economic order quantity | |
| REOQTY | Decimal | 10 | 3 | IN WAREHOUSE DETAIL REOQTY - The reorder quantity | |
| MINQTY | Decimal | 10 | 3 | IN WAREHOUSE DETAIL MINQTY - The minimum amount that can be ordered | |
| MAXONHAND | Decimal | 12 | 4 | IN WAREHOUSE DETAIL MAXONHAND - The maximum amount that should be on hand | |
| BEGAVGCOST | Decimal | 12 | 4 | IN WAREHOUSE DETAIL BEGAVGCOST - ** no in use ** | |
| BEGBALQTY | Decimal | 12 | 4 | IN WAREHOUSE DETAIL BEGBALQTY - The opening quantity on hand for the period. | |
| QTYRECVD | Decimal | 12 | 4 | IN WAREHOUSE DETAIL QTYRECVD - The total quantity received in the current period | |
| QTYADJUST | Decimal | 12 | 4 | IN WAREHOUSE DETAIL QTYADJUST - The total quantity adjusted in the current period | |
| QTYSOLD | Decimal | 12 | 4 | IN WAREHOUSE DETAIL QTYSOLD - The total quantity sold in the current period | |
| QTYONHAND | Decimal | 12 | 4 | IN WAREHOUSE DETAIL QTYONHAND - The current quantity on hand | |
| QTYONPORD | Decimal | 12 | 4 | IN WAREHOUSE DETAIL QTYONPORD - The current quantity on purchase order (this number is calculated on the fly based upon open purchase orders) | |
| QTYONSORD | Decimal | 12 | 4 | IN WAREHOUSE DETAIL QTYONSORD - The current quantity on sales order (this number is calculated on the fly based upon open sales orders) | |
| QTYONBORD | Decimal | 12 | 4 | IN WAREHOUSE DETAIL QTYONBORD - Quantity on backorder ** not currently in use ** | |
| ITEMCAT | String | 3 | IN ITEMCAT | ||
| AVGCOST | Decimal | 12 | 4 | IN AVGCOST | |
| STANDCOST | Decimal | 12 | 4 | IN STANDCOST | |
| LASTCOST | Decimal | 12 | 4 | IN LASTCOST | |
| LASTRCPT | DateTime | 8 | IN LASTRCPT | ||
| LASTSOLD | DateTime | 8 | IN LASTSOLD | ||
| QTYONWATER | Decimal | 12 | 4 | IN QTYONWATER | |
| MULTIBIN | Boolean | 1 | IN MULTIBIN | ||
| ISSERIAL | Boolean | 1 | IN ISSERIAL | ||
| BINLOC01 | String | 10 | IN BINLOC01 | ||
| BINLOC02 | String | 10 | IN BINLOC02 | ||
| BINLOC03 | String | 10 | IN BINLOC03 | ||
| BINLOC04 | String | 10 | IN BINLOC04 | ||
| BINLOC05 | String | 10 | IN BINLOC05 | ||
| BINLOC06 | String | 10 | IN BINLOC06 | ||
| BINLOC07 | String | 10 | IN BINLOC07 | ||
| BINLOC08 | String | 10 | IN BINLOC08 | ||
| BINLOC09 | String | 10 | IN BINLOC09 | ||
| BINLOC10 | String | 10 | IN BINLOC10 | ||
| _NullFlags | 2 | IN _NullFlags |