Item Supp Country Dim
In ScopeTechnical: ITEM_SUPP_COUNTRY_DIM | ID: OR-ITM-ITEM_SUPP_COUNTRY_DIM-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
Classification
- Object Type
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- ITEM_SUPP_COUNTRY_DIM
Field Definitions(21)
Rules & Considerations(34)
Sample Load Data(4)
| _scenario | ITEMRPK | LWH_UOMRPK | SUPPLIERR | CREATE_IDR | DIM_OBJECTR | WEIGHT_UOMRPK | LAST_UPDATE_IDR | ORIGIN_COUNTRYR | CREATE_DATETIMER | LIQUID_VOLUME_UOMRPK | LAST_UPDATE_DATETIMER | WIDTH | HEIGHT | LENGTH | WEIGHT | STAT_CUBE | TARE_TYPE | NET_WEIGHT | TARE_WEIGHT | LIQUID_VOLUME | PRESENTATION_METHOD |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | SAMP | 1 | SAMPLE | SAMPLE | SAMP | SAMPLE | SAM | 2026-01-01 | SAMP | 2026-01-01 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | SAMPLE | 1.0000 | 1.0000 | 1.0000 | SAMPLE |
Example values from field definitions
- ITEMRPK
- SAMPLE
- LWH_UOMRPK
- SAMP
- SUPPLIERR
- 1
- CREATE_IDR
- SAMPLE
- DIM_OBJECTR
- SAMPLE
- WEIGHT_UOMRPK
- SAMP
- LAST_UPDATE_IDR
- SAMPLE
- ORIGIN_COUNTRYR
- SAM
- CREATE_DATETIMER
- 2026-01-01
- LIQUID_VOLUME_UOMRPK
- SAMP
- LAST_UPDATE_DATETIMER
- 2026-01-01
- WIDTH
- 1.0000
- HEIGHT
- 1.0000
- LENGTH
- 1.0000
- WEIGHT
- 1.0000
- STAT_CUBE
- 1.0000
- TARE_TYPE
- SAMPLE
- NET_WEIGHT
- 1.0000
- TARE_WEIGHT
- 1.0000
- LIQUID_VOLUME
- 1.0000
- PRESENTATION_METHOD
- SAMPLE
Rule Validation Summary
- Source Rule Count
- 70
- Governed Rule Count
- 34