Item Supp Country
In ScopeTechnical: ITEM_SUPP_COUNTRY | ID: OR-MFCS-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
Target Structure
- Load Approach
- Table
- Target Objects
- ITEM_SUPP_COUNTRY
Field Definitions(43)
Rules & Considerations(74)
Sample Load Data(4)
| _scenario | HIR | TIR | ITEMRPK | COST_UOMRPK | SUPPLIERR | CREATE_IDR | ROUND_LVLR | UNIT_COSTR | LAST_UPDATE_IDR | SUPP_PACK_SIZER | CREATE_DATETIMER | INNER_PACK_SIZER | PRIMARY_SUPP_INDR | SUPP_HIER_TYPE_1PK | SUPP_HIER_TYPE_2PK | SUPP_HIER_TYPE_3PK | ORIGIN_COUNTRY_IDRPK | ROUND_TO_CASE_PCTR | ROUND_TO_INNER_PCTR | ROUND_TO_LAYER_PCTR | PRIMARY_COUNTRY_INDR | ROUND_TO_PALLET_PCTR | LAST_UPDATE_DATETIMER | BASE_COST | LEAD_TIME | DEFAULT_UOP | MAX_ORDER_QTY | MAX_TOLERANCE | MIN_ORDER_QTY | MIN_TOLERANCE | PURCHASE_RATE | PURCHASE_TYPE | INCLUSIVE_COST | PACKING_METHOD | TOLERANCE_TYPE | PRICING_CONTROL | SUPP_HIER_LVL_1 | SUPP_HIER_LVL_2 | SUPP_HIER_LVL_3 | PICKUP_LEAD_TIME | CALCULATION_BASIS | EXTENDED_BASE_COST | NEGOTIATED_ITEM_COST |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 11.0000 | 11.0000 | Item Supp Country-001 | Item Supp Country-001 | 1 | USERENV | Item Supp Country-001 | 11.0000 | MIG_USER | 11.0000 | 2026-01-01 | 11.0000 | Y | Item Supp Country-001 | Item Supp Country-001 | Item Supp Country-001 | STD-ITEM_SUPP-001 | 11.0000 | 11.0000 | 11.0000 | Y | 11.0000 | 2026-01-01 | 11.0000 | 0001 | C | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 0 | 11.0000 | Item Supp Country-001 | A | NULL | Item Supp Country-001 | Item Supp Country-001 | Item Supp Country-001 | 0001 | C | 11.0000 | 11.0000 |
default
- HIR
- 11.0000
- TIR
- 11.0000
- ITEMRPK
- Item Supp Country-001
- COST_UOMRPK
- Item Supp Country-001
- SUPPLIERR
- 1
- CREATE_IDR
- USERENV
- ROUND_LVLR
- Item Supp Country-001
- UNIT_COSTR
- 11.0000
- LAST_UPDATE_IDR
- MIG_USER
- SUPP_PACK_SIZER
- 11.0000
- CREATE_DATETIMER
- 2026-01-01
- INNER_PACK_SIZER
- 11.0000
- PRIMARY_SUPP_INDR
- Y
- SUPP_HIER_TYPE_1PK
- Item Supp Country-001
- SUPP_HIER_TYPE_2PK
- Item Supp Country-001
- SUPP_HIER_TYPE_3PK
- Item Supp Country-001
- ORIGIN_COUNTRY_IDRPK
- STD-ITEM_SUPP-001
- ROUND_TO_CASE_PCTR
- 11.0000
- ROUND_TO_INNER_PCTR
- 11.0000
- ROUND_TO_LAYER_PCTR
- 11.0000
- PRIMARY_COUNTRY_INDR
- Y
- ROUND_TO_PALLET_PCTR
- 11.0000
- LAST_UPDATE_DATETIMER
- 2026-01-01
- BASE_COST
- 11.0000
- LEAD_TIME
- 0001
- DEFAULT_UOP
- C
- MAX_ORDER_QTY
- 11.0000
- MAX_TOLERANCE
- 11.0000
- MIN_ORDER_QTY
- 11.0000
- MIN_TOLERANCE
- 11.0000
- PURCHASE_RATE
- 11.0000
- PURCHASE_TYPE
- 0
- INCLUSIVE_COST
- 11.0000
- PACKING_METHOD
- Item Supp Country-001
- TOLERANCE_TYPE
- A
- PRICING_CONTROL
- NULL
- SUPP_HIER_LVL_1
- Item Supp Country-001
- SUPP_HIER_LVL_2
- Item Supp Country-001
- SUPP_HIER_LVL_3
- Item Supp Country-001
- PICKUP_LEAD_TIME
- 0001
- CALCULATION_BASIS
- C
- EXTENDED_BASE_COST
- 11.0000
- NEGOTIATED_ITEM_COST
- 11.0000