Inv Status Qty
In ScopeTechnical: INV_STATUS_QTY | ID: OR-MFCS-INV_STATUS_QTY
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
Target Structure
- Load Approach
- Table
- Target Objects
- INV_STATUS_QTY
Field Definitions(8)
Rules & Considerations(28)
Sample Load Data(4)
| _scenario | QTYR | ITEMRPK | LOCATIONR | LOC_TYPER | INV_STATUSRPK | LAST_UPDATE_IDR | CREATE_DATETIMER | LAST_UPDATE_DATETIMER |
|---|---|---|---|---|---|---|---|---|
| default | 11.0000 | Inv Status Qty-001 | 1 | S | 01 | MIG_USER | 2026-01-01 | 2026-01-01 |
default
- QTYR
- 11.0000
- ITEMRPK
- Inv Status Qty-001
- LOCATIONR
- 1
- LOC_TYPER
- S
- INV_STATUSRPK
- 01
- LAST_UPDATE_IDR
- MIG_USER
- CREATE_DATETIMER
- 2026-01-01
- LAST_UPDATE_DATETIMER
- 2026-01-01