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(33)
Rules & Considerations(55)
Sample Load Data(4)
| _scenario | LOCR | ITEMRPK | COST_UOMRPK | LOC_TYPER | SUPPLIERR | CREATE_IDR | ROUND_LVLR | UNIT_COSTR | LAST_UPDATE_IDR | CREATE_DATETIMER | PRIMARY_LOC_INDR | SUPP_HIER_TYPE_1RPK | SUPP_HIER_TYPE_2RPK | SUPP_HIER_TYPE_3RPK | ORIGIN_COUNTRY_IDR | ROUND_TO_CASE_PCTR | ROUND_TO_INNER_PCTR | ROUND_TO_LAYER_PCTR | ROUND_TO_PALLET_PCTR | LAST_UPDATE_DATETIMER | BASE_COST | PURCHASE_RATE | PURCHASE_TYPE | INCLUSIVE_COST | 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | SAMP | S | 1 | SAMPLE | SAMPLE | 1.0000 | SAMPLE | 2026-01-01 | S | SAMPLE | SAMPLE | SAMPLE | SAM | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 2026-01-01 | 1.0000 | 1.0000 | 1 | 1.0000 | S | SAMPLE | SAMPLE | SAMPLE | 1 | S | 1.0000 | 1.0000 |
Example values from field definitions
- LOCR
- 1
- ITEMRPK
- SAMPLE
- COST_UOMRPK
- SAMP
- LOC_TYPER
- S
- SUPPLIERR
- 1
- CREATE_IDR
- SAMPLE
- ROUND_LVLR
- SAMPLE
- UNIT_COSTR
- 1.0000
- LAST_UPDATE_IDR
- SAMPLE
- CREATE_DATETIMER
- 2026-01-01
- PRIMARY_LOC_INDR
- S
- SUPP_HIER_TYPE_1RPK
- SAMPLE
- SUPP_HIER_TYPE_2RPK
- SAMPLE
- SUPP_HIER_TYPE_3RPK
- SAMPLE
- ORIGIN_COUNTRY_IDR
- SAM
- ROUND_TO_CASE_PCTR
- 1.0000
- ROUND_TO_INNER_PCTR
- 1.0000
- ROUND_TO_LAYER_PCTR
- 1.0000
- ROUND_TO_PALLET_PCTR
- 1.0000
- LAST_UPDATE_DATETIMER
- 2026-01-01
- BASE_COST
- 1.0000
- PURCHASE_RATE
- 1.0000
- PURCHASE_TYPE
- 1
- INCLUSIVE_COST
- 1.0000
- PRICING_CONTROL
- S
- SUPP_HIER_LVL_1
- SAMPLE
- SUPP_HIER_LVL_2
- SAMPLE
- SUPP_HIER_LVL_3
- SAMPLE
- PICKUP_LEAD_TIME
- 1
- CALCULATION_BASIS
- S
- EXTENDED_BASE_COST
- 1.0000
- NEGOTIATED_ITEM_COST
- 1.0000
Rule Validation Summary
- Source Rule Count
- 111
- Governed Rule Count
- 55