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(15)
Rules & Considerations(20)
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 |
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
Rule Validation Summary
- Source Rule Count
- 23
- Governed Rule Count
- 20