On Hand Inventory Quantities
In ScopeTechnical: on_hand_inventory_quantities | ID: D365BC-INV-ON_HAND_INVENTORY_QUANTITIES
D365 BC migration object for On Hand Inventory Quantities.
See how this object fits into Inventory Supply Chain
Review the broader sequencing and dependencies for this domain
Migration Details
- Complexity
- High
- Sequencing
- Opening Balances
- Typical Sources
- ERPLegacy
Target Structure
- Load Approach
- Table
- Target Objects
- On-hand Inventory Quantities
This object has high complexity or dependency level
Review sequencing requirements before loading
Field Definitions(5)
Rules & Considerations(22)
Sample Load Data(5)
| _scenario | Item No. | Quantity | Qty. (Base) | CUTOVER_WAVE | ON_HAND_NAME | Variant Code | Location Code | DEPENDENCY_LEVEL | ON_REFERENCE_KEY | EFFECTIVE_TO_DATE | ON_HAND_SOURCE_ID | SOURCE_ROW_NUMBER | HAND_REFERENCE_KEY | EFFECTIVE_FROM_DATE | LOAD_SEQUENCE_STAGE | ON_HAND_CHANGE_HASH | ON_HAND_DESCRIPTION | ON_HAND_STATUS_CODE | ON_HAND_BUSINESS_KEY | INVENTORY_REFERENCE_KEY | QUANTITIES_REFERENCE_KEY | ON-HAND INVENTORY QUANTITIES_REFERENCE_KEY |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | Item No. | 100.00 | 100.00 | On Hand Inventory Quantities-006 | On Hand Inventory Quantities Primary | Variant Code | Location Code | On Hand Inventory Quantities-007 | STD-ON_HAND-001 | 2026-01-15 | SRC-ON_HAND-001 | 16 | STD-ON_HAND-001 | 2026-01-14 | Opening Balances | On Hand Inventory Quantities-017 | On Hand Inventory Quantities: Baseline migration row | ACTIVE | BK-ON_HAND-001 | STD-ON_HAND-001 | STD-ON_HAND-001 | STD-ON_HAND-001 |
| default | — | — | — | On Hand Inventory Quantities-006 | On Hand Inventory Quantities Secondary | — | — | MEDIUM-ALT | ALT-ON_HAND-002 | 2026-01-16 | LEG-ON_HAND-002 | 17 | ALT-ON_HAND-002 | 2026-01-15 | Opening Balances | On Hand Inventory Quantities-017-ALT | On Hand Inventory Quantities: Alternate source profile | PENDING | ALT-ON_HAND-002 | ALT-ON_HAND-002 | ALT-ON_HAND-002 | ALT-ON_HAND-002 |
| default | — | — | — | On Hand Inventory Quantities-006 | On Hand Inventory Quantities Legacy | — | — | On Hand Inventory Quantities-007 | — | 2026-01-17 | EXT-ON_HAND-003 | 18 | — | 2026-01-16 | Opening Balances | On Hand Inventory Quantities-017-EDGE | — | HOLD | EDGE-ON_HAND-003 | — | — | — |
Example values from field definitions
- Item No.
- Item No.
- Quantity
- 100.00
- Qty. (Base)
- 100.00
- CUTOVER_WAVE
- On Hand Inventory Quantities-006
- ON_HAND_NAME
- On Hand Inventory Quantities Primary
- Variant Code
- Variant Code
- Location Code
- Location Code
- DEPENDENCY_LEVEL
- On Hand Inventory Quantities-007
- ON_REFERENCE_KEY
- STD-ON_HAND-001
- EFFECTIVE_TO_DATE
- 2026-01-15
- ON_HAND_SOURCE_ID
- SRC-ON_HAND-001
- SOURCE_ROW_NUMBER
- 16
- HAND_REFERENCE_KEY
- STD-ON_HAND-001
- EFFECTIVE_FROM_DATE
- 2026-01-14
- LOAD_SEQUENCE_STAGE
- Opening Balances
- ON_HAND_CHANGE_HASH
- On Hand Inventory Quantities-017
- ON_HAND_DESCRIPTION
- On Hand Inventory Quantities: Baseline migration row
- ON_HAND_STATUS_CODE
- ACTIVE
- ON_HAND_BUSINESS_KEY
- BK-ON_HAND-001
- INVENTORY_REFERENCE_KEY
- STD-ON_HAND-001
- QUANTITIES_REFERENCE_KEY
- STD-ON_HAND-001
- ON-HAND INVENTORY QUANTITIES_REFERENCE_KEY
- STD-ON_HAND-001
default
- Item No.
- —
- Quantity
- —
- Qty. (Base)
- —
- CUTOVER_WAVE
- On Hand Inventory Quantities-006
- ON_HAND_NAME
- On Hand Inventory Quantities Secondary
- Variant Code
- —
- Location Code
- —
- DEPENDENCY_LEVEL
- MEDIUM-ALT
- ON_REFERENCE_KEY
- ALT-ON_HAND-002
- EFFECTIVE_TO_DATE
- 2026-01-16
- ON_HAND_SOURCE_ID
- LEG-ON_HAND-002
- SOURCE_ROW_NUMBER
- 17
- HAND_REFERENCE_KEY
- ALT-ON_HAND-002
- EFFECTIVE_FROM_DATE
- 2026-01-15
- LOAD_SEQUENCE_STAGE
- Opening Balances
- ON_HAND_CHANGE_HASH
- On Hand Inventory Quantities-017-ALT
- ON_HAND_DESCRIPTION
- On Hand Inventory Quantities: Alternate source profile
- ON_HAND_STATUS_CODE
- PENDING
- ON_HAND_BUSINESS_KEY
- ALT-ON_HAND-002
- INVENTORY_REFERENCE_KEY
- ALT-ON_HAND-002
- QUANTITIES_REFERENCE_KEY
- ALT-ON_HAND-002
- ON-HAND INVENTORY QUANTITIES_REFERENCE_KEY
- ALT-ON_HAND-002
default
- Item No.
- —
- Quantity
- —
- Qty. (Base)
- —
- CUTOVER_WAVE
- On Hand Inventory Quantities-006
- ON_HAND_NAME
- On Hand Inventory Quantities Legacy
- Variant Code
- —
- Location Code
- —
- DEPENDENCY_LEVEL
- On Hand Inventory Quantities-007
- ON_REFERENCE_KEY
- —
- EFFECTIVE_TO_DATE
- 2026-01-17
- ON_HAND_SOURCE_ID
- EXT-ON_HAND-003
- SOURCE_ROW_NUMBER
- 18
- HAND_REFERENCE_KEY
- —
- EFFECTIVE_FROM_DATE
- 2026-01-16
- LOAD_SEQUENCE_STAGE
- Opening Balances
- ON_HAND_CHANGE_HASH
- On Hand Inventory Quantities-017-EDGE
- ON_HAND_DESCRIPTION
- —
- ON_HAND_STATUS_CODE
- HOLD
- ON_HAND_BUSINESS_KEY
- EDGE-ON_HAND-003
- INVENTORY_REFERENCE_KEY
- —
- QUANTITIES_REFERENCE_KEY
- —
- ON-HAND INVENTORY QUANTITIES_REFERENCE_KEY
- —
Rule Validation Summary
- Source Rule Count
- 22
- Governed Rule Count
- 5