Supplier Item Country
In ScopeTechnical: SUPPLIER_ITEM_COUNTRY | ID: OR-STO-SUPPLIER_ITEM_COUNTRY-SUPPLIER_ITEM_COUNTRY
Stores one entry for each country associated with a item/suppler. it is used to determine what the case size of an item will be for a particular supplier in the...
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
Field Definitions(5)
Rules & Considerations(11)
constraint
validation
Sample Load Data(4)
| _scenario | ITEM_IDRPK | COUNTRY_IDR | SUPPLIER_IDR | CASE_SIZE | UNIT_COST_VALUE | UNIT_COST_CURRENCY |
|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | SAM | 1 | 1.0000 | 1.0000 | SAM |
| default | ALT-SUPPLIER_I-002 | ALT | 1000000003 | 12.5000 | 12.5000 | Sup |
| default | EDGE-SUPPLIER_I-003 | EDG | 1000000005 | 14.0000 | 14.0000 | Sup |
Example values from field definitions
- ITEM_IDRPK
- SAMPLE
- COUNTRY_IDR
- SAM
- SUPPLIER_IDR
- 1
- CASE_SIZE
- 1.0000
- UNIT_COST_VALUE
- 1.0000
- UNIT_COST_CURRENCY
- SAM
default
- ITEM_IDRPK
- ALT-SUPPLIER_I-002
- COUNTRY_IDR
- ALT
- SUPPLIER_IDR
- 1000000003
- CASE_SIZE
- 12.5000
- UNIT_COST_VALUE
- 12.5000
- UNIT_COST_CURRENCY
- Sup
default
- ITEM_IDRPK
- EDGE-SUPPLIER_I-003
- COUNTRY_IDR
- EDG
- SUPPLIER_IDR
- 1000000005
- CASE_SIZE
- 14.0000
- UNIT_COST_VALUE
- 14.0000
- UNIT_COST_CURRENCY
- Sup
Rule Validation Summary
- Source Rule Count
- 14
- Governed Rule Count
- 11