Supplier Item Country Dim
In ScopeTechnical: SUPPLIER_ITEM_COUNTRY_DIM | ID: OR-STO-SUPPLIER_ITEM_COUNTRY_DIM-SUPPLIER_ITEM_COUNTRY_DIM
this table will hold dimensions for each item/supplier/country/dim_object combination.
See how this object fits into Store Operations
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
- SUPPLIER_ITEM_COUNTRY_DIM
Field Definitions(5)
Rules & Considerations(21)
validation
constraint
Sample Load Data(4)
| _scenario | ITEM_IDRPK | COUNTRY_IDR | SUPPLIER_IDR | DIMENSION_OBJECTR | WIDTH | HEIGHT | LENGTH | WEIGHT | NET_WEIGHT | WEIGHT_UOM | DIMENSION_UOM | LIQUID_VOLUME | STATISTICAL_CUBE | LIQUID_VOLUME_UOM | PRESENTATION_METHOD |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | SAM | 1 | SAMPLE | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | SAMP | SAMP | 1.0000 | 1.0000 | SAMP | SAMPLE |
| default | ALT-SUPPLIER_I-002 | ALT | 1000000003 | Suppli | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | Supp | Supp | 12.5000 | 12.5000 | Supp | Suppli |
| default | EDGE-SUPPLIER_I-003 | EDG | 1000000005 | Suppli | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | Supp | Supp | 14.0000 | 14.0000 | Supp | Suppli |
Example values from field definitions
- ITEM_IDRPK
- SAMPLE
- COUNTRY_IDR
- SAM
- SUPPLIER_IDR
- 1
- DIMENSION_OBJECTR
- SAMPLE
- WIDTH
- 1.0000
- HEIGHT
- 1.0000
- LENGTH
- 1.0000
- WEIGHT
- 1.0000
- NET_WEIGHT
- 1.0000
- WEIGHT_UOM
- SAMP
- DIMENSION_UOM
- SAMP
- LIQUID_VOLUME
- 1.0000
- STATISTICAL_CUBE
- 1.0000
- LIQUID_VOLUME_UOM
- SAMP
- PRESENTATION_METHOD
- SAMPLE
default
- ITEM_IDRPK
- ALT-SUPPLIER_I-002
- COUNTRY_IDR
- ALT
- SUPPLIER_IDR
- 1000000003
- DIMENSION_OBJECTR
- Suppli
- WIDTH
- 12.5000
- HEIGHT
- 12.5000
- LENGTH
- 12.5000
- WEIGHT
- 12.5000
- NET_WEIGHT
- 12.5000
- WEIGHT_UOM
- Supp
- DIMENSION_UOM
- Supp
- LIQUID_VOLUME
- 12.5000
- STATISTICAL_CUBE
- 12.5000
- LIQUID_VOLUME_UOM
- Supp
- PRESENTATION_METHOD
- Suppli
default
- ITEM_IDRPK
- EDGE-SUPPLIER_I-003
- COUNTRY_IDR
- EDG
- SUPPLIER_IDR
- 1000000005
- DIMENSION_OBJECTR
- Suppli
- WIDTH
- 14.0000
- HEIGHT
- 14.0000
- LENGTH
- 14.0000
- WEIGHT
- 14.0000
- NET_WEIGHT
- 14.0000
- WEIGHT_UOM
- Supp
- DIMENSION_UOM
- Supp
- LIQUID_VOLUME
- 14.0000
- STATISTICAL_CUBE
- 14.0000
- LIQUID_VOLUME_UOM
- Supp
- PRESENTATION_METHOD
- Suppli
Rule Validation Summary
- Source Rule Count
- 24
- Governed Rule Count
- 21