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(5)
Rules & Considerations(33)
validation
constraint
Sample Load Data(4)
| _scenario | ITEMR | LOCATIONR | LOC_TYPER | ID | REASON | ADJ_QTY | USER_ID | ADJ_DATE | COMMENTS | PREV_QTY | CREATE_ID | ADJ_WEIGHT | INV_STATUS | WEIGHT_TYPE | INVENTORY_ID | ADJ_WEIGHT_UOM | CREATE_DATETIME | WEIGHT_ONLY_ADJUSTMENT | INVENTORY_IDENTIFIER_TYPE |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | 1 | S | 1 | 1 | 1.0000 | SAMPLE | 2026-01-01 | SAMPLE | 1.0000 | SAMPLE | 1.0000 | 1 | SAMPLE | SAMPLE | SAMP | 2026-01-01 | S | SAMPLE |
| default | Inv Adj-002-ALT | 3 | S | 3 | 3 | 12.5000 | ALT-INV_ADJ-002 | 2026-01-03 | Inv Adj-002-ALT | 12.5000 | C LIENT_INFO | 12.5000 | 3 | Inv Ad | ALT-INV_ADJ-002 | Inv | 2026-01-03 | N | L |
| default | Inv Adj-003-EDGE | 5 | S | 5 | 5 | 14.0000 | EDGE-INV_ADJ-003 | 2026-01-05 | Inv Adj-003-EDGE | 14.0000 | USE RENV | 14.0000 | 5 | Inv Ad | EDGE-INV_ADJ-003 | Inv | 2026-01-05 | Y | E |
Example values from field definitions
- ITEMR
- SAMPLE
- LOCATIONR
- 1
- LOC_TYPER
- S
- ID
- 1
- REASON
- 1
- ADJ_QTY
- 1.0000
- USER_ID
- SAMPLE
- ADJ_DATE
- 2026-01-01
- COMMENTS
- SAMPLE
- PREV_QTY
- 1.0000
- CREATE_ID
- SAMPLE
- ADJ_WEIGHT
- 1.0000
- INV_STATUS
- 1
- WEIGHT_TYPE
- SAMPLE
- INVENTORY_ID
- SAMPLE
- ADJ_WEIGHT_UOM
- SAMP
- CREATE_DATETIME
- 2026-01-01
- WEIGHT_ONLY_ADJUSTMENT
- S
- INVENTORY_IDENTIFIER_TYPE
- SAMPLE
default
- ITEMR
- Inv Adj-002-ALT
- LOCATIONR
- 3
- LOC_TYPER
- S
- ID
- 3
- REASON
- 3
- ADJ_QTY
- 12.5000
- USER_ID
- ALT-INV_ADJ-002
- ADJ_DATE
- 2026-01-03
- COMMENTS
- Inv Adj-002-ALT
- PREV_QTY
- 12.5000
- CREATE_ID
- C LIENT_INFO
- ADJ_WEIGHT
- 12.5000
- INV_STATUS
- 3
- WEIGHT_TYPE
- Inv Ad
- INVENTORY_ID
- ALT-INV_ADJ-002
- ADJ_WEIGHT_UOM
- Inv
- CREATE_DATETIME
- 2026-01-03
- WEIGHT_ONLY_ADJUSTMENT
- N
- INVENTORY_IDENTIFIER_TYPE
- L
default
- ITEMR
- Inv Adj-003-EDGE
- LOCATIONR
- 5
- LOC_TYPER
- S
- ID
- 5
- REASON
- 5
- ADJ_QTY
- 14.0000
- USER_ID
- EDGE-INV_ADJ-003
- ADJ_DATE
- 2026-01-05
- COMMENTS
- Inv Adj-003-EDGE
- PREV_QTY
- 14.0000
- CREATE_ID
- USE RENV
- ADJ_WEIGHT
- 14.0000
- INV_STATUS
- 5
- WEIGHT_TYPE
- Inv Ad
- INVENTORY_ID
- EDGE-INV_ADJ-003
- ADJ_WEIGHT_UOM
- Inv
- CREATE_DATETIME
- 2026-01-05
- WEIGHT_ONLY_ADJUSTMENT
- Y
- INVENTORY_IDENTIFIER_TYPE
- E
Rule Validation Summary
- Source Rule Count
- 47
- Governed Rule Count
- 33