Item Location SOH Eod
In ScopeTechnical: ITEM_LOC_SOH_EOD | ID: OR-INV-ITEM_LOC_SOH_EOD-ITEM_LOCATION_SOH_EOD
Stores the end-of-day position of inventory buckets at the item-location intersection. The data is from the ITEM_LOC_SOH table with the auditing fields and is refreshed daily after phase 2 of...
See how this object fits into Inventory Management
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
- ITEM_LOC_SOH_EOD
Field Definitions(5)
Rules & Considerations(59)
constraint
validation
Sample Load Data(4)
| _scenario | LOCRPK | ITEMRPK | LOC_TYPER | AV_COST | RTV_QTY | QTY_SOLD | CREATE_ID | LAST_SOLD | UNIT_COST | FIRST_SOLD | ITEM_PARENT | SHIPPED_QTY | PRIMARY_SUPP | QTY_RECEIVED | CUSTOMER_RESV | LAST_RECEIVED | PACK_COMP_EXP | PACK_COMP_SOH | PRIMARY_CNTRY | STOCK_ON_HAND | AVERAGE_WEIGHT | FINISHER_UNITS | FIRST_RECEIVED | IN_TRANSIT_QTY | LAST_UPDATE_ID | PACK_COMP_RESV | CREATE_DATETIME | ITEM_GRANDPARENT | NON_SELLABLE_QTY | PACK_COMP_INTRAN | TSF_EXPECTED_QTY | TSF_RESERVED_QTY | CUSTOMER_BACKORDER | FINISHER_AV_RETAIL | PACK_COMP_CUST_BACK | PACK_COMP_CUST_RESV | SOH_UPDATE_DATETIME | LAST_UPDATE_DATETIME | IN_PROGRESS_SALES_QTY | LAST_HIST_EXPORT_DATE | PACK_COMP_SHIPPED_QTY | PACK_COMP_NON_SELLABLE |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | S | 1.0000 | 1.0000 | 1.0000 | SAMPLE | 2026-01-01 | 1.0000 | 2026-01-01 | SAMPLE | 1.0000 | 1 | 1.0000 | 1.0000 | 2026-01-01 | 1.0000 | 1.0000 | SAM | 1.0000 | 1.0000 | 1.0000 | 2026-01-01 | 1.0000 | SAMPLE | 1.0000 | 2026-01-01 | SAMPLE | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 2026-01-01 | 2026-01-01 | 1.0000 | 2026-01-01 | 1.0000 | 1.0000 |
| default | 3 | Item Loc SOH Eod-002-ALT | w | 12.5000 | 12.5000 | 12.5000 | MDM_USER | 2026-02-09 | 12.5000 | 2026-02-09 | Item Loc SOH Eod-002-ALT | 0.0000 | 3 | 12.5000 | 12.5000 | 2026-02-09 | 12.5000 | 12.5000 | Ite | 12.5000 | 12.5000 | 12.5000 | 2026-02-09 | 12.5000 | MDM_USER | 12.5000 | 2026-01-03 | Item Loc SOH Eod-002-ALT | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 2026-01-03 | 2026-01-03 | 12.5000 | 2026-01-03 | 0.0000 | 12.5000 |
| default | 5 | Item Loc SOH Eod-003-EDGE | s | 14.0000 | 14.0000 | 14.0000 | BATCH_USER | 2026-03-12 | 14.0000 | 2026-03-12 | Item Loc SOH Eod-003-EDGE | 0.0000 | 5 | 14.0000 | 14.0000 | 2026-03-12 | 14.0000 | 14.0000 | Ite | 14.0000 | 14.0000 | 14.0000 | 2026-03-12 | 14.0000 | BATCH_USER | 14.0000 | 2026-01-05 | Item Loc SOH Eod-003-EDGE | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 2026-01-05 | 2026-01-05 | 14.0000 | 2026-01-05 | 0.0000 | 14.0000 |
Example values from field definitions
- LOCRPK
- 1
- ITEMRPK
- SAMPLE
- LOC_TYPER
- S
- AV_COST
- 1.0000
- RTV_QTY
- 1.0000
- QTY_SOLD
- 1.0000
- CREATE_ID
- SAMPLE
- LAST_SOLD
- 2026-01-01
- UNIT_COST
- 1.0000
- FIRST_SOLD
- 2026-01-01
- ITEM_PARENT
- SAMPLE
- SHIPPED_QTY
- 1.0000
- PRIMARY_SUPP
- 1
- QTY_RECEIVED
- 1.0000
- CUSTOMER_RESV
- 1.0000
- LAST_RECEIVED
- 2026-01-01
- PACK_COMP_EXP
- 1.0000
- PACK_COMP_SOH
- 1.0000
- PRIMARY_CNTRY
- SAM
- STOCK_ON_HAND
- 1.0000
- AVERAGE_WEIGHT
- 1.0000
- FINISHER_UNITS
- 1.0000
- FIRST_RECEIVED
- 2026-01-01
- IN_TRANSIT_QTY
- 1.0000
- LAST_UPDATE_ID
- SAMPLE
- PACK_COMP_RESV
- 1.0000
- CREATE_DATETIME
- 2026-01-01
- ITEM_GRANDPARENT
- SAMPLE
- NON_SELLABLE_QTY
- 1.0000
- PACK_COMP_INTRAN
- 1.0000
- TSF_EXPECTED_QTY
- 1.0000
- TSF_RESERVED_QTY
- 1.0000
- CUSTOMER_BACKORDER
- 1.0000
- FINISHER_AV_RETAIL
- 1.0000
- PACK_COMP_CUST_BACK
- 1.0000
- PACK_COMP_CUST_RESV
- 1.0000
- SOH_UPDATE_DATETIME
- 2026-01-01
- LAST_UPDATE_DATETIME
- 2026-01-01
- IN_PROGRESS_SALES_QTY
- 1.0000
- LAST_HIST_EXPORT_DATE
- 2026-01-01
- PACK_COMP_SHIPPED_QTY
- 1.0000
- PACK_COMP_NON_SELLABLE
- 1.0000
default
- LOCRPK
- 3
- ITEMRPK
- Item Loc SOH Eod-002-ALT
- LOC_TYPER
- w
- AV_COST
- 12.5000
- RTV_QTY
- 12.5000
- QTY_SOLD
- 12.5000
- CREATE_ID
- MDM_USER
- LAST_SOLD
- 2026-02-09
- UNIT_COST
- 12.5000
- FIRST_SOLD
- 2026-02-09
- ITEM_PARENT
- Item Loc SOH Eod-002-ALT
- SHIPPED_QTY
- 0.0000
- PRIMARY_SUPP
- 3
- QTY_RECEIVED
- 12.5000
- CUSTOMER_RESV
- 12.5000
- LAST_RECEIVED
- 2026-02-09
- PACK_COMP_EXP
- 12.5000
- PACK_COMP_SOH
- 12.5000
- PRIMARY_CNTRY
- Ite
- STOCK_ON_HAND
- 12.5000
- AVERAGE_WEIGHT
- 12.5000
- FINISHER_UNITS
- 12.5000
- FIRST_RECEIVED
- 2026-02-09
- IN_TRANSIT_QTY
- 12.5000
- LAST_UPDATE_ID
- MDM_USER
- PACK_COMP_RESV
- 12.5000
- CREATE_DATETIME
- 2026-01-03
- ITEM_GRANDPARENT
- Item Loc SOH Eod-002-ALT
- NON_SELLABLE_QTY
- 12.5000
- PACK_COMP_INTRAN
- 12.5000
- TSF_EXPECTED_QTY
- 12.5000
- TSF_RESERVED_QTY
- 12.5000
- CUSTOMER_BACKORDER
- 12.5000
- FINISHER_AV_RETAIL
- 12.5000
- PACK_COMP_CUST_BACK
- 12.5000
- PACK_COMP_CUST_RESV
- 12.5000
- SOH_UPDATE_DATETIME
- 2026-01-03
- LAST_UPDATE_DATETIME
- 2026-01-03
- IN_PROGRESS_SALES_QTY
- 12.5000
- LAST_HIST_EXPORT_DATE
- 2026-01-03
- PACK_COMP_SHIPPED_QTY
- 0.0000
- PACK_COMP_NON_SELLABLE
- 12.5000
default
- LOCRPK
- 5
- ITEMRPK
- Item Loc SOH Eod-003-EDGE
- LOC_TYPER
- s
- AV_COST
- 14.0000
- RTV_QTY
- 14.0000
- QTY_SOLD
- 14.0000
- CREATE_ID
- BATCH_USER
- LAST_SOLD
- 2026-03-12
- UNIT_COST
- 14.0000
- FIRST_SOLD
- 2026-03-12
- ITEM_PARENT
- Item Loc SOH Eod-003-EDGE
- SHIPPED_QTY
- 0.0000
- PRIMARY_SUPP
- 5
- QTY_RECEIVED
- 14.0000
- CUSTOMER_RESV
- 14.0000
- LAST_RECEIVED
- 2026-03-12
- PACK_COMP_EXP
- 14.0000
- PACK_COMP_SOH
- 14.0000
- PRIMARY_CNTRY
- Ite
- STOCK_ON_HAND
- 14.0000
- AVERAGE_WEIGHT
- 14.0000
- FINISHER_UNITS
- 14.0000
- FIRST_RECEIVED
- 2026-03-12
- IN_TRANSIT_QTY
- 14.0000
- LAST_UPDATE_ID
- BATCH_USER
- PACK_COMP_RESV
- 14.0000
- CREATE_DATETIME
- 2026-01-05
- ITEM_GRANDPARENT
- Item Loc SOH Eod-003-EDGE
- NON_SELLABLE_QTY
- 14.0000
- PACK_COMP_INTRAN
- 14.0000
- TSF_EXPECTED_QTY
- 14.0000
- TSF_RESERVED_QTY
- 14.0000
- CUSTOMER_BACKORDER
- 14.0000
- FINISHER_AV_RETAIL
- 14.0000
- PACK_COMP_CUST_BACK
- 14.0000
- PACK_COMP_CUST_RESV
- 14.0000
- SOH_UPDATE_DATETIME
- 2026-01-05
- LAST_UPDATE_DATETIME
- 2026-01-05
- IN_PROGRESS_SALES_QTY
- 14.0000
- LAST_HIST_EXPORT_DATE
- 2026-01-05
- PACK_COMP_SHIPPED_QTY
- 0.0000
- PACK_COMP_NON_SELLABLE
- 14.0000
Rule Validation Summary
- Source Rule Count
- 119
- Governed Rule Count
- 59