You are here: File Descriptions > Inventory > INQTxxx - IN Quantity Totals

# INQTxxx - IN Quantity Totals

The IN Quantity Totals file summarizes the information from the IN Quantity Locations file by lot, location, and item. The record also carries non-detail amounts, such as on-order, committed and in-use quantities, and total item value.

There is one record for each lot for each item location, and one record for each item location.

| Template: | DIM INQT:"ITEM:C(20), LOCA:C(6*), LOTN:C(16*), OHQ:N(14*), RSV1:N(14*), CMTQ:N(14*), IUQ:N(14*), PRQ:N(14*), RSV3:N(14*), RSV4:N(14*), OOQ:N(14*), ERQ:N(14*), RSV6:N(14*), TOTC:N(14*), RSV7:N(1*), ISVA:C(1*), ISVN[2]:N(1*)"

Key Definitions

| Key Number | Field | Description
| 0 | [1:1:20] + | Item ID +
|  | [1:21:6] + | Location ID +
|  | [2:1:16] | Lot Number
| 1 | [1:21:6] + | Location ID +
|  | [1:1:20] + | Item ID +
|  | [2:1:16] | Lot Number
| 2 | [2:1:16] + | Lot Number +
|  | [1:1:20] + | Item ID +
|  | [1:21:6] | Location ID
|  | __________ |
|  | 9 segments |

IN Quantity Totals

| File Name: | INQTxxx | Record Size: | 217(256)
| File Type: | Mkeyed - Dynamic | Number of Keys: | 3

| Field | Field Name | Description | A/N | Length | Note
| 1(1,20) | ITEM | Item ID | A | 20 |
| 1(21,6) | LOCA | Location ID | A | 6 |
| 2 | LOTN | Lot Number | A | 16 |
| 3 | OHQ | On-Hand Quantity | N | 14 | IQTY
| 4 | RSV1 | Reserved for OSD | N | 14 |
| 5 | CMTQ | Committed Quantity | N | 14 | IQTY
| 6 | IUQ | In-Use Quantity | N | 14 | IQTY
| 7 | PRQ | Processing Return Quantity | N | 14 | INQT
| 8 | RSV3 | Reserved for OSD | N | 14 |
| 9 | RSV4 | Reserved for OSD | N | 14 |
| 10 | OOQ | On-Order Quantity | N | 14 | IQTY
| 11 | ERQ | Expected Return Quantity | N | 14 | IQTY
| 12 | RSV6 | Reserved for OSD | N | 14 |
| 13 | TOTC | Total Cost | N | 14 | DOLL
| 14 | RSV7 | Reserved for OSD | N | 1 |
| 15 | ISVA | Reserved for ISV | A | 1 |
| 16 | ISVN[1] | Reserved for ISV 1 | N | 1 |
| 17 | ISVN[2] | Reserved for ISV 2 | N | 1 |