Inventory Adjusment Records
In ScopeTechnical: INV_ADJUST | ID: OR-STO-INV_ADJUST-INVENTORY_ADJUST
Stores the inventory adjusment records.
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_ADJUST
Field Definitions(5)
Rules & Considerations(27)
validation
constraint
Sample Load Data(4)
| _scenario | IDRPK | STATUSR | STORE_IDR | CREATE_DATER | CREATE_USERR | COMMENTS | CONTEXT_ID | ADJUST_DATE | EXTERNAL_ID | UPDATE_DATE | UPDATE_USER | APPROVE_DATE | APPROVE_USER | REFERENCE_ID | CONTEXT_VALUE | TEMPLATE_MODIFIER | EXTERNAL_CREATE_USER | EXTERNAL_UPDATE_USER | EXTERNAL_APPROVE_USER | INV_ADJUST_TEMPLATE_ID |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | 1 | 2026-01-01 | SAMPLE | SAMPLE | 1 | 2026-01-01 | SAMPLE | 2026-01-01 | SAMPLE | 2026-01-01 | SAMPLE | 1 | SAMPLE | 1 | SAMPLE | SAMPLE | SAMPLE | 1 |
| default | 3 | 3 | 1000000003 | 2026-01-03 | Inv Adjust-002-ALT | Inv Adjust-002-ALT | 1000000003 | 2026-01-03 | ALT-INV_ADJUST-002 | 2026-01-03 | 2026-01-02-ALT | 2026-01-03 | Inv Adjust-002-ALT | 1000000003 | Inv Adjust-002-ALT | 3 | Inv Adjust-002-ALT | 2026-01-02-ALT | Inv Adjust-002-ALT | 1000000003 |
| default | 5 | 5 | 1000000005 | 2026-01-05 | Inv Adjust-003-EDGE | Inv Adjust-003-EDGE | 1000000005 | 2026-01-05 | EDGE-INV_ADJUST-003 | 2026-01-05 | 2026-01-03-EDGE | 2026-01-05 | Inv Adjust-003-EDGE | — | Inv Adjust-003-EDGE | 5 | Inv Adjust-003-EDGE | 2026-01-03-EDGE | Inv Adjust-003-EDGE | 1000000005 |
Example values from field definitions
- IDRPK
- 1
- STATUSR
- 1
- STORE_IDR
- 1
- CREATE_DATER
- 2026-01-01
- CREATE_USERR
- SAMPLE
- COMMENTS
- SAMPLE
- CONTEXT_ID
- 1
- ADJUST_DATE
- 2026-01-01
- EXTERNAL_ID
- SAMPLE
- UPDATE_DATE
- 2026-01-01
- UPDATE_USER
- SAMPLE
- APPROVE_DATE
- 2026-01-01
- APPROVE_USER
- SAMPLE
- REFERENCE_ID
- 1
- CONTEXT_VALUE
- SAMPLE
- TEMPLATE_MODIFIER
- 1
- EXTERNAL_CREATE_USER
- SAMPLE
- EXTERNAL_UPDATE_USER
- SAMPLE
- EXTERNAL_APPROVE_USER
- SAMPLE
- INV_ADJUST_TEMPLATE_ID
- 1
default
- IDRPK
- 3
- STATUSR
- 3
- STORE_IDR
- 1000000003
- CREATE_DATER
- 2026-01-03
- CREATE_USERR
- Inv Adjust-002-ALT
- COMMENTS
- Inv Adjust-002-ALT
- CONTEXT_ID
- 1000000003
- ADJUST_DATE
- 2026-01-03
- EXTERNAL_ID
- ALT-INV_ADJUST-002
- UPDATE_DATE
- 2026-01-03
- UPDATE_USER
- 2026-01-02-ALT
- APPROVE_DATE
- 2026-01-03
- APPROVE_USER
- Inv Adjust-002-ALT
- REFERENCE_ID
- 1000000003
- CONTEXT_VALUE
- Inv Adjust-002-ALT
- TEMPLATE_MODIFIER
- 3
- EXTERNAL_CREATE_USER
- Inv Adjust-002-ALT
- EXTERNAL_UPDATE_USER
- 2026-01-02-ALT
- EXTERNAL_APPROVE_USER
- Inv Adjust-002-ALT
- INV_ADJUST_TEMPLATE_ID
- 1000000003
default
- IDRPK
- 5
- STATUSR
- 5
- STORE_IDR
- 1000000005
- CREATE_DATER
- 2026-01-05
- CREATE_USERR
- Inv Adjust-003-EDGE
- COMMENTS
- Inv Adjust-003-EDGE
- CONTEXT_ID
- 1000000005
- ADJUST_DATE
- 2026-01-05
- EXTERNAL_ID
- EDGE-INV_ADJUST-003
- UPDATE_DATE
- 2026-01-05
- UPDATE_USER
- 2026-01-03-EDGE
- APPROVE_DATE
- 2026-01-05
- APPROVE_USER
- Inv Adjust-003-EDGE
- REFERENCE_ID
- —
- CONTEXT_VALUE
- Inv Adjust-003-EDGE
- TEMPLATE_MODIFIER
- 5
- EXTERNAL_CREATE_USER
- Inv Adjust-003-EDGE
- EXTERNAL_UPDATE_USER
- 2026-01-03-EDGE
- EXTERNAL_APPROVE_USER
- Inv Adjust-003-EDGE
- INV_ADJUST_TEMPLATE_ID
- 1000000005
Rule Validation Summary
- Source Rule Count
- 38
- Governed Rule Count
- 27