On-hand Inventory Quantities
In ScopeTechnical: InventOnHandItem | ID: D365FO-TRX-INVENTONHANDITEM-ON_HAND_INVENTORY_QUANTITIES
See how this object fits into Open Transactions History
Review the broader sequencing and dependencies for this domain
Migration Details
- Complexity
- High
- Sequencing
- Stage 4 - Opening Balances
- Typical Sources
- ERPLegacy
Classification
- Object Type
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- InventOnHandItem
This object has high complexity or dependency level
Review sequencing requirements before loading
Field Definitions(5)
Rules & Considerations(27)
validation
constraint
Sample Load Data(4)
| _scenario | ItemIdRPK | InventDimIdRPK | InventSiteIdR | InventLocationIdR | AvailablePhysicalR | PostedQty | DataAreaId | UnitSymbol | BatchNumber | OnOrderReceipt | ReservedPhysical | DefaultDimensionDisplayValue | IsBlocked | ProductSizeId | ProductColorId | InventoryStatusId | LicensePlateNumber | WarehouseLocationId |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | F0001 | 000000 | USMF | WH1 | 100.0 | 100.0 | USMF | ea | — | — | — | — | — | — | — | — | — | — |
| On-Hand with Batch, Reserved, and On Order Receipt | A0002 | 000001 | USMF | WH2 | 80 | 100 | USMF | pcs | BCH001 | 50 | 20 | Department:023 | — | — | — | — | — | — |
| On-Hand with Color/Size, Blocked status, WMS Location | F0003 | 000002 | USMF | WH3 | 0 | 25 | USMF | box | — | — | — | Project:P001 | 1 | M | BLUE | Blocked | LP-456 | REC-A01 |
Example values from field definitions
- ItemIdRPK
- F0001
- InventDimIdRPK
- 000000
- InventSiteIdR
- USMF
- InventLocationIdR
- WH1
- AvailablePhysicalR
- 100.0
- PostedQty
- 100.0
- DataAreaId
- USMF
- UnitSymbol
- ea
- BatchNumber
- —
- OnOrderReceipt
- —
- ReservedPhysical
- —
- DefaultDimensionDisplayValue
- —
- IsBlocked
- —
- ProductSizeId
- —
- ProductColorId
- —
- InventoryStatusId
- —
- LicensePlateNumber
- —
- WarehouseLocationId
- —
On-Hand with Batch, Reserved, and On Order Receipt
- ItemIdRPK
- A0002
- InventDimIdRPK
- 000001
- InventSiteIdR
- USMF
- InventLocationIdR
- WH2
- AvailablePhysicalR
- 80
- PostedQty
- 100
- DataAreaId
- USMF
- UnitSymbol
- pcs
- BatchNumber
- BCH001
- OnOrderReceipt
- 50
- ReservedPhysical
- 20
- DefaultDimensionDisplayValue
- Department:023
- IsBlocked
- —
- ProductSizeId
- —
- ProductColorId
- —
- InventoryStatusId
- —
- LicensePlateNumber
- —
- WarehouseLocationId
- —
On-Hand with Color/Size, Blocked status, WMS Location
- ItemIdRPK
- F0003
- InventDimIdRPK
- 000002
- InventSiteIdR
- USMF
- InventLocationIdR
- WH3
- AvailablePhysicalR
- 0
- PostedQty
- 25
- DataAreaId
- USMF
- UnitSymbol
- box
- BatchNumber
- —
- OnOrderReceipt
- —
- ReservedPhysical
- —
- DefaultDimensionDisplayValue
- Project:P001
- IsBlocked
- 1
- ProductSizeId
- M
- ProductColorId
- BLUE
- InventoryStatusId
- Blocked
- LicensePlateNumber
- LP-456
- WarehouseLocationId
- REC-A01
Rule Validation Summary
- Source Rule Count
- 27
- Governed Rule Count
- 27