Svc Item Supp Country Loc
In ScopeTechnical: SVC_ITEM_SUPP_COUNTRY_LOC | ID: OR-MFCS-SVC_ITEM_SUPP_COUNTRY_LOC
This is the staging table for Item Induction module. It is used to temporarily hold data before it is uploaded/updated in ITEM_SUPP_COUNTRY_LOC.
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
- SVC_ITEM_SUPP_COUNTRY_LOC
Field Definitions(36)
Rules & Considerations(24)
Sample Load Data(4)
| _scenario | ROW_SEQR | CHUNK_IDR | PROCESS_IDRPK | LOC | ITEM | ACTION | COST_UOM | LOC_TYPE | SUPPLIER | BASE_COST | CREATE_ID | ROUND_LVL | UNIT_COST | LAST_UPD_ID | PURCHASE_RATE | PURCHASE_TYPE | INCLUSIVE_COST | PROCESS$STATUS | CREATE_DATETIME | PRICING_CONTROL | 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 | LAST_UPD_DATETIME | ORIGIN_COUNTRY_ID | ROUND_TO_CASE_PCT | EXTENDED_BASE_COST | ROUND_TO_INNER_PCT | ROUND_TO_LAYER_PCT | ROUND_TO_PALLET_PCT | NEGOTIATED_ITEM_COST |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 1 | 1000000001 | 1000000001 | 1 | Svc Item Supp Country Loc-001 | Svc Item Supp Country Loc-001 | Svc Item Supp Country Loc-001 | Svc Item Supp Country Loc-001 | 1 | 11.0000 | USER | Svc Item Supp Country Loc-001 | 11.0000 | USER | 11.0000 | 0 | 11.0000 | N | 2026-01-01 | Svc Item Supp Country Loc-001 | Svc Item Supp Country Loc-001 | Svc Item Supp Country Loc-001 | Svc Item Supp Country Loc-001 | 0001 | Svc Item Supp Country Loc-001 | Svc Item Supp Country Loc-001 | Svc Item Supp Country Loc-001 | C | 2026-01-01 | STD-SVC_ITEM-001 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 | 11.0000 |
default
- ROW_SEQR
- 1
- CHUNK_IDR
- 1000000001
- PROCESS_IDRPK
- 1000000001
- LOC
- 1
- ITEM
- Svc Item Supp Country Loc-001
- ACTION
- Svc Item Supp Country Loc-001
- COST_UOM
- Svc Item Supp Country Loc-001
- LOC_TYPE
- Svc Item Supp Country Loc-001
- SUPPLIER
- 1
- BASE_COST
- 11.0000
- CREATE_ID
- USER
- ROUND_LVL
- Svc Item Supp Country Loc-001
- UNIT_COST
- 11.0000
- LAST_UPD_ID
- USER
- PURCHASE_RATE
- 11.0000
- PURCHASE_TYPE
- 0
- INCLUSIVE_COST
- 11.0000
- PROCESS$STATUS
- N
- CREATE_DATETIME
- 2026-01-01
- PRICING_CONTROL
- Svc Item Supp Country Loc-001
- SUPP_HIER_LVL_1
- Svc Item Supp Country Loc-001
- SUPP_HIER_LVL_2
- Svc Item Supp Country Loc-001
- SUPP_HIER_LVL_3
- Svc Item Supp Country Loc-001
- PICKUP_LEAD_TIME
- 0001
- SUPP_HIER_TYPE_1
- Svc Item Supp Country Loc-001
- SUPP_HIER_TYPE_2
- Svc Item Supp Country Loc-001
- SUPP_HIER_TYPE_3
- Svc Item Supp Country Loc-001
- CALCULATION_BASIS
- C
- LAST_UPD_DATETIME
- 2026-01-01
- ORIGIN_COUNTRY_ID
- STD-SVC_ITEM-001
- ROUND_TO_CASE_PCT
- 11.0000
- EXTENDED_BASE_COST
- 11.0000
- ROUND_TO_INNER_PCT
- 11.0000
- ROUND_TO_LAYER_PCT
- 11.0000
- ROUND_TO_PALLET_PCT
- 11.0000
- NEGOTIATED_ITEM_COST
- 11.0000