Dc Item Supp Country
In ScopeTechnical: DC_ITEM_SUPP_COUNTRY | ID: OR-ITM-DC_ITEM_SUPP_COUNTRY-DC_ITEM_SUPP_COUNTRY
This table is a staging table for data conversion and will hold data of ITEM_SUPP_COUNTRY table.
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
- DC_ITEM_SUPP_COUNTRY
Field Definitions(5)
Rules & Considerations(24)
Sample Load Data(4)
| _scenario | HI | TI | ITEM | COST_UOM | SUPPLIER | BASE_COST | LEAD_TIME | ROUND_LVL | UNIT_COST | DEFAULT_UOP | MAX_ORDER_QTY | MIN_ORDER_QTY | INCLUSIVE_COST | PACKING_METHOD | SUPP_PACK_SIZE | INNER_PACK_SIZE | ORIGIN_COUNTRY_ID | ROUND_TO_CASE_PCT | EXTENDED_BASE_COST | ROUND_TO_INNER_PCT | ROUND_TO_LAYER_PCT | PRIMARY_COUNTRY_IND | ROUND_TO_PALLET_PCT | NEGOTIATED_ITEM_COST |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1.0000 | 1.0000 | SAMPLE | SAMP | 1 | 1.0000 | 1 | SAMPLE | 1.0000 | SAMPLE | 1.0000 | 1.0000 | 1.0000 | SAMPLE | 1.0000 | 1.0000 | SAM | 1.0000 | 1.0000 | 1.0000 | 1.0000 | S | 1.0000 | 1.0000 |
| default | 12.5000 | 12.5000 | Dc Item Supp Country-002- | Dc I | 3 | 12.5000 | 3 | Dc Ite | 12.5000 | Dc Ite | 12.5000 | 12.5000 | 12.5000 | Dc Ite | 12.5000 | 12.5000 | ALT | 12.5000 | 12.5000 | 12.5000 | 12.5000 | D | 12.5000 | 12.5000 |
| default | 14.0000 | 14.0000 | Dc Item Supp Country-003- | Dc I | 5 | 14.0000 | 5 | Dc Ite | 14.0000 | Dc Ite | 14.0000 | 14.0000 | 14.0000 | Dc Ite | 14.0000 | 14.0000 | EDG | 14.0000 | 14.0000 | 14.0000 | 14.0000 | D | 14.0000 | 14.0000 |
Example values from field definitions
- HI
- 1.0000
- TI
- 1.0000
- ITEM
- SAMPLE
- COST_UOM
- SAMP
- SUPPLIER
- 1
- BASE_COST
- 1.0000
- LEAD_TIME
- 1
- ROUND_LVL
- SAMPLE
- UNIT_COST
- 1.0000
- DEFAULT_UOP
- SAMPLE
- MAX_ORDER_QTY
- 1.0000
- MIN_ORDER_QTY
- 1.0000
- INCLUSIVE_COST
- 1.0000
- PACKING_METHOD
- SAMPLE
- SUPP_PACK_SIZE
- 1.0000
- INNER_PACK_SIZE
- 1.0000
- ORIGIN_COUNTRY_ID
- SAM
- 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
- NEGOTIATED_ITEM_COST
- 1.0000
default
- HI
- 12.5000
- TI
- 12.5000
- ITEM
- Dc Item Supp Country-002-
- COST_UOM
- Dc I
- SUPPLIER
- 3
- BASE_COST
- 12.5000
- LEAD_TIME
- 3
- ROUND_LVL
- Dc Ite
- UNIT_COST
- 12.5000
- DEFAULT_UOP
- Dc Ite
- MAX_ORDER_QTY
- 12.5000
- MIN_ORDER_QTY
- 12.5000
- INCLUSIVE_COST
- 12.5000
- PACKING_METHOD
- Dc Ite
- SUPP_PACK_SIZE
- 12.5000
- INNER_PACK_SIZE
- 12.5000
- ORIGIN_COUNTRY_ID
- ALT
- 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
- D
- ROUND_TO_PALLET_PCT
- 12.5000
- NEGOTIATED_ITEM_COST
- 12.5000
default
- HI
- 14.0000
- TI
- 14.0000
- ITEM
- Dc Item Supp Country-003-
- COST_UOM
- Dc I
- SUPPLIER
- 5
- BASE_COST
- 14.0000
- LEAD_TIME
- 5
- ROUND_LVL
- Dc Ite
- UNIT_COST
- 14.0000
- DEFAULT_UOP
- Dc Ite
- MAX_ORDER_QTY
- 14.0000
- MIN_ORDER_QTY
- 14.0000
- INCLUSIVE_COST
- 14.0000
- PACKING_METHOD
- Dc Ite
- SUPP_PACK_SIZE
- 14.0000
- INNER_PACK_SIZE
- 14.0000
- ORIGIN_COUNTRY_ID
- EDG
- 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
- D
- ROUND_TO_PALLET_PCT
- 14.0000
- NEGOTIATED_ITEM_COST
- 14.0000
Rule Validation Summary
- Source Rule Count
- 30
- Governed Rule Count
- 24