Item Loc SOH Eod
In ScopeTechnical: ITEM_LOC_SOH_EOD | ID: OR-MFCS-ITEM_LOC_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
Target Structure
- Load Approach
- Table
- Target Objects
- ITEM_LOC_SOH_EOD
Field Definitions(42)
Rules & Considerations(117)
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 1 | Item Loc SOH Eod-001 | 11.0000 | store | MIG_USER | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | MIG_USER | 11.0000 | 2026-01-01 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 2026-01-01 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 2026-01-06 | 11.0000 | 2026-01-06 | Item Loc SOH Eod-001 | 0 | 1 | 11.0000 | 2026-01-06 | Item Loc SOH Eod-001 | 11.0000 | 11.0000 | 2026-01-06 | Item Loc SOH Eod-001 | 11.0000 | 2026-01-01 | 2026-01-01 | 0 |
default
- LOCR
- 1
- ITEMRPK
- Item Loc SOH Eod-001
- RTV_QTYR
- 11.0000
- LOC_TYPER
- store
- CREATE_IDR
- MIG_USER
- CUSTOMER_RESVR
- 11.0000
- PACK_COMP_EXPR
- 11.0000
- PACK_COMP_SOHR
- 11.0000
- STOCK_ON_HANDR
- 11.0000
- IN_TRANSIT_QTYR
- 11.0000
- LAST_UPDATE_IDR
- MIG_USER
- PACK_COMP_RESVR
- 11.0000
- CREATE_DATETIMER
- 2026-01-01
- NON_SELLABLE_QTYR
- 11.0000
- PACK_COMP_INTRANR
- 11.0000
- TSF_EXPECTED_QTYR
- 11.0000
- TSF_RESERVED_QTYR
- 11.0000
- CUSTOMER_BACKORDERR
- 11.0000
- PACK_COMP_CUST_BACKR
- 11.0000
- PACK_COMP_CUST_RESVR
- 11.0000
- LAST_UPDATE_DATETIMER
- 2026-01-01
- IN_PROGRESS_SALES_QTYR
- 11.0000
- PACK_COMP_NON_SELLABLER
- 11.0000
- AV_COST
- 11.0000
- QTY_SOLD
- 11.0000
- LAST_SOLD
- 2026-01-06
- UNIT_COST
- 11.0000
- FIRST_SOLD
- 2026-01-06
- ITEM_PARENT
- Item Loc SOH Eod-001
- SHIPPED_QTY
- 0
- PRIMARY_SUPP
- 1
- QTY_RECEIVED
- 11.0000
- LAST_RECEIVED
- 2026-01-06
- PRIMARY_CNTRY
- Item Loc SOH Eod-001
- AVERAGE_WEIGHT
- 11.0000
- FINISHER_UNITS
- 11.0000
- FIRST_RECEIVED
- 2026-01-06
- ITEM_GRANDPARENT
- Item Loc SOH Eod-001
- FINISHER_AV_RETAIL
- 11.0000
- SOH_UPDATE_DATETIME
- 2026-01-01
- LAST_HIST_EXPORT_DATE
- 2026-01-01
- PACK_COMP_SHIPPED_QTY
- 0