| Name | Type | Length | Decimal | Relation | Description |
| WHCODE | String | 8 | IN PHYSICAL WHCODE - The warehouse code | ||
| ITEMNUM | String | 25 | IN ITEMNUM | ||
| SERLOTRCPT | String | 15 | IN PHYSICAL SERLOTRCPT - Serial or lot number | ||
| ACCTNUM | String | 12 | IN PHYSICAL ACCTNUM - General ledger account for inventory. | ||
| PACCTNUM | String | 12 | IN PHYSICAL PACCTNUM - General ledger account for adjustment. | ||
| RCPTDATE | DateTime | 8 | IN PHYSICAL RCPTDATE - The date of adjustment | ||
| PREVCOUNT | Decimal | 12 | 4 | IN PHYSICAL PREVCOUNT - The on hand quantity of the item before adjustment. | |
| PHYSCOUNT | Decimal | 12 | 4 | IN PHYSICAL PHYSCOUNT - The quantity on hand after physical count. | |
| UNITCOST | Decimal | 12 | 4 | IN PHYSICAL UNITCOST - The unit cost of the item (calculated at update). | |
| USERID | String | 4 | IN USERID | ||
| KEYID | String | 12 | IN KEYID |