Item Supp Country Location
In ScopeTechnical: ITEM_SUPP_COUNTRY_LOC | ID: OR-ITM-ITEM_SUPP_COUNTRY_LOC-ITEM_SUPP_COUNTRY_LOCATION
This table will hold one record for each location associated with a given item/supplier/country.
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_LOC
Field Definitions(5)
Rules & Considerations(58)
constraint
validation
Sample Load Data(4)
| _scenario | LOCR | ITEMRPK | LOC_TYPER | SUPPLIERR | ORIGIN_COUNTRY_IDR | COST_UOM | BASE_COST | CREATE_ID | ROUND_LVL | UNIT_COST | PURCHASE_RATE | PURCHASE_TYPE | INCLUSIVE_COST | LAST_UPDATE_ID | CREATE_DATETIME | PRICING_CONTROL | PRIMARY_LOC_IND | SUPP_HIER_LVL_1 | SUPP_HIER_LVL_2 | SUPP_HIER_LVL_3 | PICKUP_LEAD_TIME | 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 | ROUND_TO_PALLET_PCT | LAST_UPDATE_DATETIME | NEGOTIATED_ITEM_COST |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | S | 1 | SAM | SAMP | 1.0000 | SAMPLE | SAMPLE | 1.0000 | 1.0000 | 1 | 1.0000 | SAMPLE | 2026-01-01 | S | S | SAMPLE | SAMPLE | SAMPLE | 1 | SAMPLE | SAMPLE | SAMPLE | S | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 2026-01-01 | 1.0000 |
| default | 3 | Item Supp Country Loc-002 | S | 3 | ALT | Item | 12.5000 | C LIENT_INFO | Item S | 12.5000 | 12.5000 | 1 | 12.5000 | MDM_USER | 2026-01-03 | N | — | Item Supp | Item Supp | Item Supp | 3 | Item S | Item S | Item S | P | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 2026-01-03 | 12.5000 |
| default | 5 | Item Supp Country Loc-003 | S | 5 | EDG | Item | 14.0000 | USE RENV | Item S | 14.0000 | 14.0000 | 2 | 14.0000 | BATCH_USER | 2026-01-05 | N | — | Item Supp | Item Supp | Item Supp | 5 | Item S | Item S | Item S | C | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 2026-01-05 | 14.0000 |
Example values from field definitions
- LOCR
- 1
- ITEMRPK
- SAMPLE
- LOC_TYPER
- S
- SUPPLIERR
- 1
- ORIGIN_COUNTRY_IDR
- SAM
- COST_UOM
- SAMP
- BASE_COST
- 1.0000
- CREATE_ID
- SAMPLE
- ROUND_LVL
- SAMPLE
- UNIT_COST
- 1.0000
- PURCHASE_RATE
- 1.0000
- PURCHASE_TYPE
- 1
- INCLUSIVE_COST
- 1.0000
- LAST_UPDATE_ID
- SAMPLE
- CREATE_DATETIME
- 2026-01-01
- PRICING_CONTROL
- S
- PRIMARY_LOC_IND
- S
- SUPP_HIER_LVL_1
- SAMPLE
- SUPP_HIER_LVL_2
- SAMPLE
- SUPP_HIER_LVL_3
- SAMPLE
- PICKUP_LEAD_TIME
- 1
- 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
- ROUND_TO_PALLET_PCT
- 1.0000
- LAST_UPDATE_DATETIME
- 2026-01-01
- NEGOTIATED_ITEM_COST
- 1.0000
default
- LOCR
- 3
- ITEMRPK
- Item Supp Country Loc-002
- LOC_TYPER
- S
- SUPPLIERR
- 3
- ORIGIN_COUNTRY_IDR
- ALT
- COST_UOM
- Item
- BASE_COST
- 12.5000
- CREATE_ID
- C LIENT_INFO
- ROUND_LVL
- Item S
- UNIT_COST
- 12.5000
- PURCHASE_RATE
- 12.5000
- PURCHASE_TYPE
- 1
- INCLUSIVE_COST
- 12.5000
- LAST_UPDATE_ID
- MDM_USER
- CREATE_DATETIME
- 2026-01-03
- PRICING_CONTROL
- N
- PRIMARY_LOC_IND
- —
- SUPP_HIER_LVL_1
- Item Supp
- SUPP_HIER_LVL_2
- Item Supp
- SUPP_HIER_LVL_3
- Item Supp
- PICKUP_LEAD_TIME
- 3
- 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
- ROUND_TO_PALLET_PCT
- 12.5000
- LAST_UPDATE_DATETIME
- 2026-01-03
- NEGOTIATED_ITEM_COST
- 12.5000
default
- LOCR
- 5
- ITEMRPK
- Item Supp Country Loc-003
- LOC_TYPER
- S
- SUPPLIERR
- 5
- ORIGIN_COUNTRY_IDR
- EDG
- COST_UOM
- Item
- BASE_COST
- 14.0000
- CREATE_ID
- USE RENV
- ROUND_LVL
- Item S
- UNIT_COST
- 14.0000
- PURCHASE_RATE
- 14.0000
- PURCHASE_TYPE
- 2
- INCLUSIVE_COST
- 14.0000
- LAST_UPDATE_ID
- BATCH_USER
- CREATE_DATETIME
- 2026-01-05
- PRICING_CONTROL
- N
- PRIMARY_LOC_IND
- —
- SUPP_HIER_LVL_1
- Item Supp
- SUPP_HIER_LVL_2
- Item Supp
- SUPP_HIER_LVL_3
- Item Supp
- PICKUP_LEAD_TIME
- 5
- 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
- ROUND_TO_PALLET_PCT
- 14.0000
- LAST_UPDATE_DATETIME
- 2026-01-05
- NEGOTIATED_ITEM_COST
- 14.0000
Rule Validation Summary
- Source Rule Count
- 114
- Governed Rule Count
- 58