Inventory Status Quantity
In ScopeTechnical: INV_STATUS_QTY | ID: OR-ITM-INV_STATUS_QTY-INVENTORY_STATUS_QUANTITY
For any non-salable merchandise at a specific location, this table will hold the item, a status from inv_status_types, the location and the quantity.
See how this object fits into Item Management
Review the broader sequencing and dependencies for this domain
Migration Details
- Complexity
- Medium
- Sequencing
- Stage 2
- Typical Sources
- ERPLegacy
Classification
- Object Type
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- INV_STATUS_QTY
Field Definitions(5)
Rules & Considerations(20)
validation
constraint
Sample Load Data(4)
| _scenario | QTYR | ITEMRPK | LOCATIONRPK | LOC_TYPERPK | INV_STATUSRPK | LAST_UPDATE_ID | CREATE_DATETIME | LAST_UPDATE_DATETIME |
|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1.0000 | SAMPLE | 1 | S | 1 | SAMPLE | 2026-01-01 | 2026-01-01 |
| default | 12.5000 | Inv Status Qty-002-ALT | 3 | S | 3 | MDM_USER | 2026-01-03 | 2026-01-03 |
| default | 14.0000 | Inv Status Qty-003-EDGE | 5 | S | 5 | BATCH_USER | 2026-01-05 | 2026-01-05 |
Example values from field definitions
- QTYR
- 1.0000
- ITEMRPK
- SAMPLE
- LOCATIONRPK
- 1
- LOC_TYPERPK
- S
- INV_STATUSRPK
- 1
- LAST_UPDATE_ID
- SAMPLE
- CREATE_DATETIME
- 2026-01-01
- LAST_UPDATE_DATETIME
- 2026-01-01
default
- QTYR
- 12.5000
- ITEMRPK
- Inv Status Qty-002-ALT
- LOCATIONRPK
- 3
- LOC_TYPERPK
- S
- INV_STATUSRPK
- 3
- LAST_UPDATE_ID
- MDM_USER
- CREATE_DATETIME
- 2026-01-03
- LAST_UPDATE_DATETIME
- 2026-01-03
default
- QTYR
- 14.0000
- ITEMRPK
- Inv Status Qty-003-EDGE
- LOCATIONRPK
- 5
- LOC_TYPERPK
- S
- INV_STATUSRPK
- 5
- LAST_UPDATE_ID
- BATCH_USER
- CREATE_DATETIME
- 2026-01-05
- LAST_UPDATE_DATETIME
- 2026-01-05
Rule Validation Summary
- Source Rule Count
- 48
- Governed Rule Count
- 20