Inv Adj
In ScopeTechnical: INV_ADJ | ID: OR-MFCS-INV_ADJ
This table will contain and audit trail for inventory adjustment.
See how this object fits into Store Operations
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_ADJ
Field Definitions(19)
Rules & Considerations(56)
Sample Load Data(4)
| _scenario | IDRPK | ITEMR | REASONPK | USER_IDR | ADJ_DATER | LOCATIONR | LOC_TYPER | CREATE_IDR | INV_STATUSPK | CREATE_DATETIMER | ADJ_QTY | COMMENTS | PREV_QTY | ADJ_WEIGHT | WEIGHT_TYPE | INVENTORY_ID | ADJ_WEIGHT_UOM | WEIGHT_ONLY_ADJUSTMENT | INVENTORY_IDENTIFIER_TYPE |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 1 | Inv Adj-001 | 0001 | STD-INV_ADJ-001 | 2026-01-01 | 1 | S | USERENV | 01 | 2026-01-01 | 11.0000 | Inv Adj-001 | 11.0000 | 11.0000 | Inv Adj-001 | STD-INV_ADJ-001 | Inv Adj-001 | Y | IIDT |
default
- IDRPK
- 1
- ITEMR
- Inv Adj-001
- REASONPK
- 0001
- USER_IDR
- STD-INV_ADJ-001
- ADJ_DATER
- 2026-01-01
- LOCATIONR
- 1
- LOC_TYPER
- S
- CREATE_IDR
- USERENV
- INV_STATUSPK
- 01
- CREATE_DATETIMER
- 2026-01-01
- ADJ_QTY
- 11.0000
- COMMENTS
- Inv Adj-001
- PREV_QTY
- 11.0000
- ADJ_WEIGHT
- 11.0000
- WEIGHT_TYPE
- Inv Adj-001
- INVENTORY_ID
- STD-INV_ADJ-001
- ADJ_WEIGHT_UOM
- Inv Adj-001
- WEIGHT_ONLY_ADJUSTMENT
- Y
- INVENTORY_IDENTIFIER_TYPE
- IIDT