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(6)
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 |
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
Rule Validation Summary
- Source Rule Count
- 22
- Governed Rule Count
- 5