Inventory Adjustment
In ScopeTechnical: INV_ADJ | ID: OR-STO-INV_ADJ-INVENTORY_ADJUSTMENT
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
Classification
- Object Type
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- INV_ADJ
Field Definitions(19)
Rules & Considerations(31)
Sample Load Data(4)
| _scenario | IDRPK | ITEMR | REASONRPK | ADJ_QTYR | USER_IDR | ADJ_DATER | LOCATIONR | LOC_TYPER | CREATE_IDR | INV_STATUSRPK | CREATE_DATETIMER | COMMENTS | PREV_QTY | ADJ_WEIGHT | WEIGHT_TYPE | INVENTORY_ID | ADJ_WEIGHT_UOM | WEIGHT_ONLY_ADJUSTMENT | INVENTORY_IDENTIFIER_TYPE |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | 1 | 1.0000 | SAMPLE | 2026-01-01 | 1 | S | SAMPLE | 1 | 2026-01-01 | SAMPLE | 1.0000 | 1.0000 | SAMPLE | SAMPLE | SAMP | S | SAMPLE |
Example values from field definitions
- IDRPK
- 1
- ITEMR
- SAMPLE
- REASONRPK
- 1
- ADJ_QTYR
- 1.0000
- USER_IDR
- SAMPLE
- ADJ_DATER
- 2026-01-01
- LOCATIONR
- 1
- LOC_TYPER
- S
- CREATE_IDR
- SAMPLE
- INV_STATUSRPK
- 1
- CREATE_DATETIMER
- 2026-01-01
- COMMENTS
- SAMPLE
- PREV_QTY
- 1.0000
- ADJ_WEIGHT
- 1.0000
- WEIGHT_TYPE
- SAMPLE
- INVENTORY_ID
- SAMPLE
- ADJ_WEIGHT_UOM
- SAMP
- WEIGHT_ONLY_ADJUSTMENT
- S
- INVENTORY_IDENTIFIER_TYPE
- SAMPLE
Rule Validation Summary
- Source Rule Count
- 45
- Governed Rule Count
- 31