| Name | Type | Length | Decimal | Relation | Description |
| TRANNUM | String | 4 | IN TRANS HISTORY TRANNUM - The inventory transaction number | ||
| ITEMNUM | String | 25 | IN ITEMNUM | ||
| WHCODE | String | 8 | IN WHCODE | ||
| WHSETRNSFR | String | 8 | IN TRANS HISTORY WHSETRNSFR - The warehouse the item was transferred from if a transfer. | ||
| TRANCODE | String | 1 | IN TRANS HISTORY TRANCODE - The transaction type (1= | ||
| VENDCUST | String | 10 | IN TRANS HISTORY VENDCUST - The vendor or customer number | ||
| SOPONUM | String | 10 | IN TRANS HISTORY SOPONUM - The sales order or purchase order number. | ||
| REFSYS | String | 2 | IN TRANS HISTORY REFSYS - The module where the transaction originated (SO,PO,IN) | ||
| USERID | String | 4 | IN TRANS HISTORY USERID - The ID of the user that entered the transaction. | ||
| TRBATCH | String | 10 | IN TRBATCH | ||
| ACCTNUM | String | 12 | IN ACCTNUM | ||
| PACCTNUM | String | 12 | IN PACCTNUM | ||
| ALLOCATEDP | Decimal | 3 | 0 | IN ALLOCATEDP | |
| ALLOCATEDA | String | 12 | IN ALLOCATEDA | ||
| ALLOCATED2 | Decimal | 3 | 0 | IN ALLOCATED2 | |
| ALLOCATED3 | String | 12 | IN ALLOCATED3 | ||
| ALLOCATED4 | Decimal | 3 | 0 | IN ALLOCATED4 | |
| SERLOTRCPT | String | 15 | IN SERLOTRCPT | ||
| TRANDATE | DateTime | 8 | IN TRANS HISTORY TRANDATE - The date the transaction was posted | ||
| TRANQTY | Decimal | 12 | 4 | IN TRANS HISTORY TRANQTY - The transaction quantity | |
| UNITCOST | Decimal | 8 | 6 | IN UNITCOST | |
| UNITPRICE | Decimal | 12 | 4 | IN TRANS HISTORY UNITPRICE - The unit price | |
| PRODUCTLIN | String | 4 | IN PRODUCTLIN | ||
| REFERENCED | DateTime | 8 | IN REFERENCED | ||
| ESTIMATE | Decimal | 9 | 5 | IN TRANS HISTORY ESTIMATE - ** not currently in use ** | |
| BINLOC | String | 10 | IN BINLOC |