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(42)
Rules & Considerations(58)
Sample Load Data(4)
| _scenario | LOCR | ITEMRPK | RTV_QTYR | LOC_TYPER | CREATE_IDR | CUSTOMER_RESVR | PACK_COMP_EXPR | PACK_COMP_SOHR | STOCK_ON_HANDR | IN_TRANSIT_QTYR | LAST_UPDATE_IDR | PACK_COMP_RESVR | CREATE_DATETIMER | NON_SELLABLE_QTYR | PACK_COMP_INTRANR | TSF_EXPECTED_QTYR | TSF_RESERVED_QTYR | CUSTOMER_BACKORDERR | PACK_COMP_CUST_BACKR | PACK_COMP_CUST_RESVR | LAST_UPDATE_DATETIMER | IN_PROGRESS_SALES_QTYR | PACK_COMP_NON_SELLABLER | AV_COST | QTY_SOLD | LAST_SOLD | UNIT_COST | FIRST_SOLD | ITEM_PARENT | SHIPPED_QTY | PRIMARY_SUPP | QTY_RECEIVED | LAST_RECEIVED | PRIMARY_CNTRY | AVERAGE_WEIGHT | FINISHER_UNITS | FIRST_RECEIVED | ITEM_GRANDPARENT | FINISHER_AV_RETAIL | SOH_UPDATE_DATETIME | LAST_HIST_EXPORT_DATE | PACK_COMP_SHIPPED_QTY |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | 1.0000 | S | SAMPLE | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | SAMPLE | 1.0000 | 2026-01-01 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 2026-01-01 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 2026-01-01 | 1.0000 | 2026-01-01 | SAMPLE | 1.0000 | 1 | 1.0000 | 2026-01-01 | SAM | 1.0000 | 1.0000 | 2026-01-01 | SAMPLE | 1.0000 | 2026-01-01 | 2026-01-01 | 1.0000 |
Example values from field definitions
- LOCR
- 1
- ITEMRPK
- SAMPLE
- RTV_QTYR
- 1.0000
- LOC_TYPER
- S
- CREATE_IDR
- SAMPLE
- CUSTOMER_RESVR
- 1.0000
- PACK_COMP_EXPR
- 1.0000
- PACK_COMP_SOHR
- 1.0000
- STOCK_ON_HANDR
- 1.0000
- IN_TRANSIT_QTYR
- 1.0000
- LAST_UPDATE_IDR
- SAMPLE
- PACK_COMP_RESVR
- 1.0000
- CREATE_DATETIMER
- 2026-01-01
- NON_SELLABLE_QTYR
- 1.0000
- PACK_COMP_INTRANR
- 1.0000
- TSF_EXPECTED_QTYR
- 1.0000
- TSF_RESERVED_QTYR
- 1.0000
- CUSTOMER_BACKORDERR
- 1.0000
- PACK_COMP_CUST_BACKR
- 1.0000
- PACK_COMP_CUST_RESVR
- 1.0000
- LAST_UPDATE_DATETIMER
- 2026-01-01
- IN_PROGRESS_SALES_QTYR
- 1.0000
- PACK_COMP_NON_SELLABLER
- 1.0000
- AV_COST
- 1.0000
- QTY_SOLD
- 1.0000
- 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
- LAST_RECEIVED
- 2026-01-01
- PRIMARY_CNTRY
- SAM
- AVERAGE_WEIGHT
- 1.0000
- FINISHER_UNITS
- 1.0000
- FIRST_RECEIVED
- 2026-01-01
- ITEM_GRANDPARENT
- SAMPLE
- FINISHER_AV_RETAIL
- 1.0000
- SOH_UPDATE_DATETIME
- 2026-01-01
- LAST_HIST_EXPORT_DATE
- 2026-01-01
- PACK_COMP_SHIPPED_QTY
- 1.0000
Rule Validation Summary
- Source Rule Count
- 118
- Governed Rule Count
- 58