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(8)
Rules & Considerations(16)
Sample Load Data(4)
| _scenario | QTYR | ITEMRPK | LOCATIONR | LOC_TYPER | INV_STATUSRPK | LAST_UPDATE_IDR | CREATE_DATETIMER | LAST_UPDATE_DATETIMER |
|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1.0000 | SAMPLE | 1 | S | 1 | SAMPLE | 2026-01-01 | 2026-01-01 |
Example values from field definitions
- QTYR
- 1.0000
- ITEMRPK
- SAMPLE
- LOCATIONR
- 1
- LOC_TYPER
- S
- INV_STATUSRPK
- 1
- LAST_UPDATE_IDR
- SAMPLE
- CREATE_DATETIMER
- 2026-01-01
- LAST_UPDATE_DATETIMER
- 2026-01-01
Rule Validation Summary
- Source Rule Count
- 44
- Governed Rule Count
- 16