Item Supp Country Dim
In ScopeTechnical: ITEM_SUPP_COUNTRY_DIM | ID: OR-MFCS-ITEM_SUPP_COUNTRY_DIM
This table will hold dimensions of inner/case/pallet for each item/supplier/country combination.
See how this object fits into Item 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_SUPP_COUNTRY_DIM
Field Definitions(21)
Rules & Considerations(40)
Sample Load Data(4)
| _scenario | ITEMRPK | LWH_UOMPK | SUPPLIERR | CREATE_IDR | DIM_OBJECTR | WEIGHT_UOMPK | LAST_UPDATE_IDR | ORIGIN_COUNTRYR | CREATE_DATETIMER | LIQUID_VOLUME_UOMPK | LAST_UPDATE_DATETIMER | WIDTH | HEIGHT | LENGTH | WEIGHT | STAT_CUBE | TARE_TYPE | NET_WEIGHT | TARE_WEIGHT | LIQUID_VOLUME | PRESENTATION_METHOD |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | Item Supp Country Dim-001 | field | 1 | USERENV | Item Supp Country Dim-001 | field | MIG_USER | Item Supp Country Dim-001 | 2026-01-01 | field | 2026-01-01 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | W | 11.0000 | 11.0000 | 11.0000 | Item Supp Country Dim-001 |
default
- ITEMRPK
- Item Supp Country Dim-001
- LWH_UOMPK
- field
- SUPPLIERR
- 1
- CREATE_IDR
- USERENV
- DIM_OBJECTR
- Item Supp Country Dim-001
- WEIGHT_UOMPK
- field
- LAST_UPDATE_IDR
- MIG_USER
- ORIGIN_COUNTRYR
- Item Supp Country Dim-001
- CREATE_DATETIMER
- 2026-01-01
- LIQUID_VOLUME_UOMPK
- field
- LAST_UPDATE_DATETIMER
- 2026-01-01
- WIDTH
- 11.0000
- HEIGHT
- 11.0000
- LENGTH
- 11.0000
- WEIGHT
- 11.0000
- STAT_CUBE
- 11.0000
- TARE_TYPE
- W
- NET_WEIGHT
- 11.0000
- TARE_WEIGHT
- 11.0000
- LIQUID_VOLUME
- 11.0000
- PRESENTATION_METHOD
- Item Supp Country Dim-001