Item Supplier Origin Country Relationships
In ScopeTechnical: ITEM_SUPP_COUNTRY | ID: OR-ITM-ITEM_SUPP_COUNTRY-ITEM_SUPP_COUNTRY
Stores all item supplier origin country relationships.
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
Field Definitions(5)
Rules & Considerations(74)
constraint
validation
Sample Load Data(4)
| _scenario | ITEMRPK | SUPPLIERRPK | UNIT_COSTR | ORIGIN_COUNTRY_IDRPK | HI | TI | COST_UOM | BASE_COST | CREATE_ID | LEAD_TIME | ROUND_LVL | DEFAULT_UOP | MAX_ORDER_QTY | MAX_TOLERANCE | MIN_ORDER_QTY | MIN_TOLERANCE | PURCHASE_RATE | PURCHASE_TYPE | INCLUSIVE_COST | LAST_UPDATE_ID | PACKING_METHOD | SUPP_PACK_SIZE | TOLERANCE_TYPE | CREATE_DATETIME | INNER_PACK_SIZE | PRICING_CONTROL | SUPP_HIER_LVL_1 | SUPP_HIER_LVL_2 | SUPP_HIER_LVL_3 | PICKUP_LEAD_TIME | PRIMARY_SUPP_IND | SUPP_HIER_TYPE_1 | SUPP_HIER_TYPE_2 | SUPP_HIER_TYPE_3 | CALCULATION_BASIS | ROUND_TO_CASE_PCT | EXTENDED_BASE_COST | ROUND_TO_INNER_PCT | ROUND_TO_LAYER_PCT | PRIMARY_COUNTRY_IND | ROUND_TO_PALLET_PCT | LAST_UPDATE_DATETIME | NEGOTIATED_ITEM_COST |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | 1 | 1.0000 | SAM | 1.0000 | 1.0000 | SAMP | 1.0000 | SAMPLE | 1 | SAMPLE | SAMPLE | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1 | 1.0000 | SAMPLE | SAMPLE | 1.0000 | SAMPLE | 2026-01-01 | 1.0000 | S | SAMPLE | SAMPLE | SAMPLE | 1 | S | SAMPLE | SAMPLE | SAMPLE | S | 1.0000 | 1.0000 | 1.0000 | 1.0000 | S | 1.0000 | 2026-01-01 | 1.0000 |
| default | Item Supp Country-002-ALT | 3 | 12.5000 | ALT | 12.5000 | 12.5000 | Item | 12.5000 | C LIENT_INFO | 3 | Item S | C | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 1 | 12.5000 | MDM_USER | Item S | 12.5000 | A | 2026-01-03 | 12.5000 | N | Item Supp | Item Supp | Item Supp | 3 | N | Item S | Item S | Item S | P | 12.5000 | 12.5000 | 12.5000 | 12.5000 | N | 12.5000 | 2026-01-03 | 12.5000 |
| default | Item Supp Country-003-EDG | 5 | 14.0000 | EDG | 14.0000 | 14.0000 | Item | 14.0000 | USE RENV | 5 | Item S | C | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 2 | 14.0000 | BATCH_USER | Item S | 14.0000 | A | 2026-01-05 | 14.0000 | N | Item Supp | Item Supp | Item Supp | 5 | Y | Item S | Item S | Item S | C | 14.0000 | 14.0000 | 14.0000 | 14.0000 | Y | 14.0000 | 2026-01-05 | 14.0000 |
Example values from field definitions
- ITEMRPK
- SAMPLE
- SUPPLIERRPK
- 1
- UNIT_COSTR
- 1.0000
- ORIGIN_COUNTRY_IDRPK
- SAM
- HI
- 1.0000
- TI
- 1.0000
- COST_UOM
- SAMP
- BASE_COST
- 1.0000
- CREATE_ID
- SAMPLE
- LEAD_TIME
- 1
- ROUND_LVL
- SAMPLE
- DEFAULT_UOP
- SAMPLE
- MAX_ORDER_QTY
- 1.0000
- MAX_TOLERANCE
- 1.0000
- MIN_ORDER_QTY
- 1.0000
- MIN_TOLERANCE
- 1.0000
- PURCHASE_RATE
- 1.0000
- PURCHASE_TYPE
- 1
- INCLUSIVE_COST
- 1.0000
- LAST_UPDATE_ID
- SAMPLE
- PACKING_METHOD
- SAMPLE
- SUPP_PACK_SIZE
- 1.0000
- TOLERANCE_TYPE
- SAMPLE
- CREATE_DATETIME
- 2026-01-01
- INNER_PACK_SIZE
- 1.0000
- PRICING_CONTROL
- S
- SUPP_HIER_LVL_1
- SAMPLE
- SUPP_HIER_LVL_2
- SAMPLE
- SUPP_HIER_LVL_3
- SAMPLE
- PICKUP_LEAD_TIME
- 1
- PRIMARY_SUPP_IND
- S
- SUPP_HIER_TYPE_1
- SAMPLE
- SUPP_HIER_TYPE_2
- SAMPLE
- SUPP_HIER_TYPE_3
- SAMPLE
- CALCULATION_BASIS
- S
- ROUND_TO_CASE_PCT
- 1.0000
- EXTENDED_BASE_COST
- 1.0000
- ROUND_TO_INNER_PCT
- 1.0000
- ROUND_TO_LAYER_PCT
- 1.0000
- PRIMARY_COUNTRY_IND
- S
- ROUND_TO_PALLET_PCT
- 1.0000
- LAST_UPDATE_DATETIME
- 2026-01-01
- NEGOTIATED_ITEM_COST
- 1.0000
default
- ITEMRPK
- Item Supp Country-002-ALT
- SUPPLIERRPK
- 3
- UNIT_COSTR
- 12.5000
- ORIGIN_COUNTRY_IDRPK
- ALT
- HI
- 12.5000
- TI
- 12.5000
- COST_UOM
- Item
- BASE_COST
- 12.5000
- CREATE_ID
- C LIENT_INFO
- LEAD_TIME
- 3
- ROUND_LVL
- Item S
- DEFAULT_UOP
- C
- MAX_ORDER_QTY
- 12.5000
- MAX_TOLERANCE
- 12.5000
- MIN_ORDER_QTY
- 12.5000
- MIN_TOLERANCE
- 12.5000
- PURCHASE_RATE
- 12.5000
- PURCHASE_TYPE
- 1
- INCLUSIVE_COST
- 12.5000
- LAST_UPDATE_ID
- MDM_USER
- PACKING_METHOD
- Item S
- SUPP_PACK_SIZE
- 12.5000
- TOLERANCE_TYPE
- A
- CREATE_DATETIME
- 2026-01-03
- INNER_PACK_SIZE
- 12.5000
- PRICING_CONTROL
- N
- SUPP_HIER_LVL_1
- Item Supp
- SUPP_HIER_LVL_2
- Item Supp
- SUPP_HIER_LVL_3
- Item Supp
- PICKUP_LEAD_TIME
- 3
- PRIMARY_SUPP_IND
- N
- SUPP_HIER_TYPE_1
- Item S
- SUPP_HIER_TYPE_2
- Item S
- SUPP_HIER_TYPE_3
- Item S
- CALCULATION_BASIS
- P
- ROUND_TO_CASE_PCT
- 12.5000
- EXTENDED_BASE_COST
- 12.5000
- ROUND_TO_INNER_PCT
- 12.5000
- ROUND_TO_LAYER_PCT
- 12.5000
- PRIMARY_COUNTRY_IND
- N
- ROUND_TO_PALLET_PCT
- 12.5000
- LAST_UPDATE_DATETIME
- 2026-01-03
- NEGOTIATED_ITEM_COST
- 12.5000
default
- ITEMRPK
- Item Supp Country-003-EDG
- SUPPLIERRPK
- 5
- UNIT_COSTR
- 14.0000
- ORIGIN_COUNTRY_IDRPK
- EDG
- HI
- 14.0000
- TI
- 14.0000
- COST_UOM
- Item
- BASE_COST
- 14.0000
- CREATE_ID
- USE RENV
- LEAD_TIME
- 5
- ROUND_LVL
- Item S
- DEFAULT_UOP
- C
- MAX_ORDER_QTY
- 14.0000
- MAX_TOLERANCE
- 14.0000
- MIN_ORDER_QTY
- 14.0000
- MIN_TOLERANCE
- 14.0000
- PURCHASE_RATE
- 14.0000
- PURCHASE_TYPE
- 2
- INCLUSIVE_COST
- 14.0000
- LAST_UPDATE_ID
- BATCH_USER
- PACKING_METHOD
- Item S
- SUPP_PACK_SIZE
- 14.0000
- TOLERANCE_TYPE
- A
- CREATE_DATETIME
- 2026-01-05
- INNER_PACK_SIZE
- 14.0000
- PRICING_CONTROL
- N
- SUPP_HIER_LVL_1
- Item Supp
- SUPP_HIER_LVL_2
- Item Supp
- SUPP_HIER_LVL_3
- Item Supp
- PICKUP_LEAD_TIME
- 5
- PRIMARY_SUPP_IND
- Y
- SUPP_HIER_TYPE_1
- Item S
- SUPP_HIER_TYPE_2
- Item S
- SUPP_HIER_TYPE_3
- Item S
- CALCULATION_BASIS
- C
- ROUND_TO_CASE_PCT
- 14.0000
- EXTENDED_BASE_COST
- 14.0000
- ROUND_TO_INNER_PCT
- 14.0000
- ROUND_TO_LAYER_PCT
- 14.0000
- PRIMARY_COUNTRY_IND
- Y
- ROUND_TO_PALLET_PCT
- 14.0000
- LAST_UPDATE_DATETIME
- 2026-01-05
- NEGOTIATED_ITEM_COST
- 14.0000
Rule Validation Summary
- Source Rule Count
- 144
- Governed Rule Count
- 74