Item Supp Country (Service Layer)
In ScopeTechnical: SVC_ITEM_SUPP_COUNTRY | ID: OR-ITM-SVC_ITEM_SUPP_COUNTRY-ITEM_SUPP_COUNTRY_SERVICE_LAYER
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.
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
- SVC_ITEM_SUPP_COUNTRY
Field Definitions(5)
Rules & Considerations(52)
constraint
validation
Sample Load Data(4)
| _scenario | ROW_SEQR | CHUNK_IDR | PROCESS_IDRPK | HI | TI | ITEM | ACTION | COST_UOM | SUPPLIER | BASE_COST | CREATE_ID | LEAD_TIME | ROUND_LVL | UNIT_COST | DEFAULT_UOP | LAST_UPD_ID | MAX_ORDER_QTY | MAX_TOLERANCE | MIN_ORDER_QTY | MIN_TOLERANCE | PURCHASE_RATE | PURCHASE_TYPE | INCLUSIVE_COST | PACKING_METHOD | PROCESS$STATUS | SUPP_PACK_SIZE | TOLERANCE_TYPE | CREATE_DATETIME | INNER_PACK_SIZE | PRICING_CONTROL | SUPP_HIER_LVL_1 | SUPP_HIER_LVL_2 | SUPP_HIER_LVL_3 | PICKUP_LEAD_TIME | PRIMARY_SUPP_IND | 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 | PRIMARY_COUNTRY_IND | ROUND_TO_PALLET_PCT | NEGOTIATED_ITEM_COST | DEFAULT_EXPENSE_PROFILES | REFRESH_EXPENSES_FROM_PROFILES |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | 1 | 1.0000 | 1.0000 | SAMPLE | SAMPLE | SAMP | 1 | 1.0000 | SAMPLE | 1 | SAMPLE | 1.0000 | SAMPLE | SAMPLE | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1.0000 | 1 | 1.0000 | SAMPLE | SAMPLE | 1.0000 | SAMPLE | 2026-01-01 | 1.0000 | S | SAMPLE | SAMPLE | SAMPLE | 1 | S | SAMPLE | SAMPLE | SAMPLE | S | 2026-01-01 | SAM | 1.0000 | 1.0000 | 1.0000 | 1.0000 | S | 1.0000 | 1.0000 | S | S |
| default | 3 | 1000000003 | 1000000003 | 12.5000 | 12.5000 | Svc Item Supp Country-002 | Svc Item S | Svc | 3 | 12.5000 | C LIENT_INFO | 3 | Svc It | 12.5000 | Svc It | C LIENT_INFO | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 12.5000 | 1 | 12.5000 | Svc It | N | 12.5000 | Svc It | 2026-01-03 | 12.5000 | N | Svc Item S | Svc Item S | Svc Item S | 3 | S | Svc It | Svc It | Svc It | P | 2026-01-03 | ALT | 12.5000 | 12.5000 | 12.5000 | 12.5000 | S | 12.5000 | 12.5000 | S | S |
| default | 5 | 1000000005 | 1000000005 | 14.0000 | 14.0000 | Svc Item Supp Country-003 | Svc Item S | Svc | 5 | 14.0000 | USE RENV | 5 | Svc It | 14.0000 | Svc It | USE RENV | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 14.0000 | 2 | 14.0000 | Svc It | N | 14.0000 | Svc It | 2026-01-05 | 14.0000 | N | Svc Item S | Svc Item S | Svc Item S | 5 | S | Svc It | Svc It | Svc It | C | 2026-01-05 | EDG | 14.0000 | 14.0000 | 14.0000 | 14.0000 | S | 14.0000 | 14.0000 | S | S |
Example values from field definitions
- ROW_SEQR
- 1
- CHUNK_IDR
- 1
- PROCESS_IDRPK
- 1
- HI
- 1.0000
- TI
- 1.0000
- ITEM
- SAMPLE
- ACTION
- SAMPLE
- COST_UOM
- SAMP
- SUPPLIER
- 1
- BASE_COST
- 1.0000
- CREATE_ID
- SAMPLE
- LEAD_TIME
- 1
- ROUND_LVL
- SAMPLE
- UNIT_COST
- 1.0000
- DEFAULT_UOP
- SAMPLE
- LAST_UPD_ID
- SAMPLE
- MAX_ORDER_QTY
- 1.0000
- MAX_TOLERANCE
- 1.0000
- MIN_ORDER_QTY
- 1.0000
- MIN_TOLERANCE
- 1.0000
- PURCHASE_RATE
- 1.0000
- PURCHASE_TYPE
- 1
- INCLUSIVE_COST
- 1.0000
- PACKING_METHOD
- SAMPLE
- PROCESS$STATUS
- SAMPLE
- SUPP_PACK_SIZE
- 1.0000
- TOLERANCE_TYPE
- SAMPLE
- CREATE_DATETIME
- 2026-01-01
- INNER_PACK_SIZE
- 1.0000
- PRICING_CONTROL
- S
- SUPP_HIER_LVL_1
- SAMPLE
- SUPP_HIER_LVL_2
- SAMPLE
- SUPP_HIER_LVL_3
- SAMPLE
- PICKUP_LEAD_TIME
- 1
- PRIMARY_SUPP_IND
- S
- SUPP_HIER_TYPE_1
- SAMPLE
- SUPP_HIER_TYPE_2
- SAMPLE
- SUPP_HIER_TYPE_3
- SAMPLE
- CALCULATION_BASIS
- S
- LAST_UPD_DATETIME
- 2026-01-01
- 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_EXPENSE_PROFILES
- S
- REFRESH_EXPENSES_FROM_PROFILES
- S
default
- ROW_SEQR
- 3
- CHUNK_IDR
- 1000000003
- PROCESS_IDRPK
- 1000000003
- HI
- 12.5000
- TI
- 12.5000
- ITEM
- Svc Item Supp Country-002
- ACTION
- Svc Item S
- COST_UOM
- Svc
- SUPPLIER
- 3
- BASE_COST
- 12.5000
- CREATE_ID
- C LIENT_INFO
- LEAD_TIME
- 3
- ROUND_LVL
- Svc It
- UNIT_COST
- 12.5000
- DEFAULT_UOP
- Svc It
- LAST_UPD_ID
- C LIENT_INFO
- MAX_ORDER_QTY
- 12.5000
- MAX_TOLERANCE
- 12.5000
- MIN_ORDER_QTY
- 12.5000
- MIN_TOLERANCE
- 12.5000
- PURCHASE_RATE
- 12.5000
- PURCHASE_TYPE
- 1
- INCLUSIVE_COST
- 12.5000
- PACKING_METHOD
- Svc It
- PROCESS$STATUS
- N
- SUPP_PACK_SIZE
- 12.5000
- TOLERANCE_TYPE
- Svc It
- CREATE_DATETIME
- 2026-01-03
- INNER_PACK_SIZE
- 12.5000
- PRICING_CONTROL
- N
- SUPP_HIER_LVL_1
- Svc Item S
- SUPP_HIER_LVL_2
- Svc Item S
- SUPP_HIER_LVL_3
- Svc Item S
- PICKUP_LEAD_TIME
- 3
- PRIMARY_SUPP_IND
- S
- SUPP_HIER_TYPE_1
- Svc It
- SUPP_HIER_TYPE_2
- Svc It
- SUPP_HIER_TYPE_3
- Svc It
- CALCULATION_BASIS
- P
- LAST_UPD_DATETIME
- 2026-01-03
- 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
- S
- ROUND_TO_PALLET_PCT
- 12.5000
- NEGOTIATED_ITEM_COST
- 12.5000
- DEFAULT_EXPENSE_PROFILES
- S
- REFRESH_EXPENSES_FROM_PROFILES
- S
default
- ROW_SEQR
- 5
- CHUNK_IDR
- 1000000005
- PROCESS_IDRPK
- 1000000005
- HI
- 14.0000
- TI
- 14.0000
- ITEM
- Svc Item Supp Country-003
- ACTION
- Svc Item S
- COST_UOM
- Svc
- SUPPLIER
- 5
- BASE_COST
- 14.0000
- CREATE_ID
- USE RENV
- LEAD_TIME
- 5
- ROUND_LVL
- Svc It
- UNIT_COST
- 14.0000
- DEFAULT_UOP
- Svc It
- LAST_UPD_ID
- USE RENV
- MAX_ORDER_QTY
- 14.0000
- MAX_TOLERANCE
- 14.0000
- MIN_ORDER_QTY
- 14.0000
- MIN_TOLERANCE
- 14.0000
- PURCHASE_RATE
- 14.0000
- PURCHASE_TYPE
- 2
- INCLUSIVE_COST
- 14.0000
- PACKING_METHOD
- Svc It
- PROCESS$STATUS
- N
- SUPP_PACK_SIZE
- 14.0000
- TOLERANCE_TYPE
- Svc It
- CREATE_DATETIME
- 2026-01-05
- INNER_PACK_SIZE
- 14.0000
- PRICING_CONTROL
- N
- SUPP_HIER_LVL_1
- Svc Item S
- SUPP_HIER_LVL_2
- Svc Item S
- SUPP_HIER_LVL_3
- Svc Item S
- PICKUP_LEAD_TIME
- 5
- PRIMARY_SUPP_IND
- S
- SUPP_HIER_TYPE_1
- Svc It
- SUPP_HIER_TYPE_2
- Svc It
- SUPP_HIER_TYPE_3
- Svc It
- CALCULATION_BASIS
- C
- LAST_UPD_DATETIME
- 2026-01-05
- 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
- S
- ROUND_TO_PALLET_PCT
- 14.0000
- NEGOTIATED_ITEM_COST
- 14.0000
- DEFAULT_EXPENSE_PROFILES
- S
- REFRESH_EXPENSES_FROM_PROFILES
- S
Rule Validation Summary
- Source Rule Count
- 78
- Governed Rule Count
- 52