Supplier Item Country Dim
In ScopeTechnical: SUPPLIER_ITEM_COUNTRY_DIM | ID: OR-SIOCS-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
Target Structure
- Load Approach
- Table
- Target Objects
- SUPPLIER_ITEM_COUNTRY_DIM
Field Definitions(15)
Rules & Considerations(38)
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | STD-SUPPLIER_I-001 | STD-SUPPLIER_I-001 | 1000000001 | Supplier Item Country Dim-001 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | Supplier Item Country Dim-001 | Supplier Item Country Dim-001 | 11.0000 | 11.0000 | Supplier Item Country Dim-001 | Supplier Item Country Dim-001 |
default
- ITEM_IDRPK
- STD-SUPPLIER_I-001
- COUNTRY_IDR
- STD-SUPPLIER_I-001
- SUPPLIER_IDR
- 1000000001
- DIMENSION_OBJECTR
- Supplier Item Country Dim-001
- WIDTH
- 11.0000
- HEIGHT
- 11.0000
- LENGTH
- 11.0000
- WEIGHT
- 11.0000
- NET_WEIGHT
- 11.0000
- WEIGHT_UOM
- Supplier Item Country Dim-001
- DIMENSION_UOM
- Supplier Item Country Dim-001
- LIQUID_VOLUME
- 11.0000
- STATISTICAL_CUBE
- 11.0000
- LIQUID_VOLUME_UOM
- Supplier Item Country Dim-001
- PRESENTATION_METHOD
- Supplier Item Country Dim-001