Item Supplier (Service Layer)
In ScopeTechnical: SVC_ITEM_SUPPLIER | ID: OR-ITM-SVC_ITEM_SUPPLIER-ITEM_SUPPLIER_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_SUPPLIER.
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_SUPPLIER
Field Definitions(5)
Rules & Considerations(30)
constraint
validation
Sample Load Data(4)
| _scenario | ROW_SEQRPK | CHUNK_IDR | PROCESS_IDRPK | VPN | ITEM | ACTION | SUPPLIER | CASE_NAME | CREATE_ID | INNER_NAME | SUPP_LABEL | LAST_UPD_ID | PALLET_NAME | SUPP_DIFF_1 | SUPP_DIFF_2 | SUPP_DIFF_3 | SUPP_DIFF_4 | PROCESS$STATUS | CONCESSION_RATE | CREATE_DATETIME | DIRECT_SHIP_IND | CONSIGNMENT_RATE | PRIMARY_SUPP_IND | LAST_UPD_DATETIME | PRIMARY_CASE_SIZE | SUPP_DISCONTINUE_DATE | DEFAULT_EXPENSE_PROFILES | REFRESH_EXPENSES_FROM_PROFILES |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | 1 | SAMPLE | SAMPLE | SAMPLE | 1 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | 1.0000 | 2026-01-01 | S | 1.0000 | S | 2026-01-01 | SAMPLE | 2026-01-01 | S | S |
| default | 3 | 1000000003 | 1000000003 | Svc Item Supplier-002-ALT | Svc Item Supplier-002-ALT | Svc Item S | 3 | Svc It | C LIENT_INFO | Svc It | Svc Item Suppli | C LIENT_INFO | Svc It | Svc Item Supplier-002-ALT | Svc Item Supplier-002-ALT | Svc Item Supplier-002-ALT | Svc Item Supplier-002-ALT | N | 12.5000 | 2026-01-03 | S | 12.5000 | S | 2026-01-03 | Svc It | 2026-01-03 | S | S |
| default | 5 | 1000000005 | 1000000005 | Svc Item Supplier-003-EDGE | Svc Item Supplier-003-EDG | Svc Item S | 5 | Svc It | USE RENV | Svc It | Svc Item Suppli | USE RENV | Svc It | Svc Item Supplier-003-EDGE | Svc Item Supplier-003-EDGE | Svc Item Supplier-003-EDGE | Svc Item Supplier-003-EDGE | N | 14.0000 | 2026-01-05 | S | 14.0000 | S | 2026-01-05 | Svc It | 2026-01-05 | S | S |
Example values from field definitions
- ROW_SEQRPK
- 1
- CHUNK_IDR
- 1
- PROCESS_IDRPK
- 1
- VPN
- SAMPLE
- ITEM
- SAMPLE
- ACTION
- SAMPLE
- SUPPLIER
- 1
- CASE_NAME
- SAMPLE
- CREATE_ID
- SAMPLE
- INNER_NAME
- SAMPLE
- SUPP_LABEL
- SAMPLE
- LAST_UPD_ID
- SAMPLE
- PALLET_NAME
- SAMPLE
- SUPP_DIFF_1
- SAMPLE
- SUPP_DIFF_2
- SAMPLE
- SUPP_DIFF_3
- SAMPLE
- SUPP_DIFF_4
- SAMPLE
- PROCESS$STATUS
- SAMPLE
- CONCESSION_RATE
- 1.0000
- CREATE_DATETIME
- 2026-01-01
- DIRECT_SHIP_IND
- S
- CONSIGNMENT_RATE
- 1.0000
- PRIMARY_SUPP_IND
- S
- LAST_UPD_DATETIME
- 2026-01-01
- PRIMARY_CASE_SIZE
- SAMPLE
- SUPP_DISCONTINUE_DATE
- 2026-01-01
- DEFAULT_EXPENSE_PROFILES
- S
- REFRESH_EXPENSES_FROM_PROFILES
- S
default
- ROW_SEQRPK
- 3
- CHUNK_IDR
- 1000000003
- PROCESS_IDRPK
- 1000000003
- VPN
- Svc Item Supplier-002-ALT
- ITEM
- Svc Item Supplier-002-ALT
- ACTION
- Svc Item S
- SUPPLIER
- 3
- CASE_NAME
- Svc It
- CREATE_ID
- C LIENT_INFO
- INNER_NAME
- Svc It
- SUPP_LABEL
- Svc Item Suppli
- LAST_UPD_ID
- C LIENT_INFO
- PALLET_NAME
- Svc It
- SUPP_DIFF_1
- Svc Item Supplier-002-ALT
- SUPP_DIFF_2
- Svc Item Supplier-002-ALT
- SUPP_DIFF_3
- Svc Item Supplier-002-ALT
- SUPP_DIFF_4
- Svc Item Supplier-002-ALT
- PROCESS$STATUS
- N
- CONCESSION_RATE
- 12.5000
- CREATE_DATETIME
- 2026-01-03
- DIRECT_SHIP_IND
- S
- CONSIGNMENT_RATE
- 12.5000
- PRIMARY_SUPP_IND
- S
- LAST_UPD_DATETIME
- 2026-01-03
- PRIMARY_CASE_SIZE
- Svc It
- SUPP_DISCONTINUE_DATE
- 2026-01-03
- DEFAULT_EXPENSE_PROFILES
- S
- REFRESH_EXPENSES_FROM_PROFILES
- S
default
- ROW_SEQRPK
- 5
- CHUNK_IDR
- 1000000005
- PROCESS_IDRPK
- 1000000005
- VPN
- Svc Item Supplier-003-EDGE
- ITEM
- Svc Item Supplier-003-EDG
- ACTION
- Svc Item S
- SUPPLIER
- 5
- CASE_NAME
- Svc It
- CREATE_ID
- USE RENV
- INNER_NAME
- Svc It
- SUPP_LABEL
- Svc Item Suppli
- LAST_UPD_ID
- USE RENV
- PALLET_NAME
- Svc It
- SUPP_DIFF_1
- Svc Item Supplier-003-EDGE
- SUPP_DIFF_2
- Svc Item Supplier-003-EDGE
- SUPP_DIFF_3
- Svc Item Supplier-003-EDGE
- SUPP_DIFF_4
- Svc Item Supplier-003-EDGE
- PROCESS$STATUS
- N
- CONCESSION_RATE
- 14.0000
- CREATE_DATETIME
- 2026-01-05
- DIRECT_SHIP_IND
- S
- CONSIGNMENT_RATE
- 14.0000
- PRIMARY_SUPP_IND
- S
- LAST_UPD_DATETIME
- 2026-01-05
- PRIMARY_CASE_SIZE
- Svc It
- SUPP_DISCONTINUE_DATE
- 2026-01-05
- DEFAULT_EXPENSE_PROFILES
- S
- REFRESH_EXPENSES_FROM_PROFILES
- S
Rule Validation Summary
- Source Rule Count
- 50
- Governed Rule Count
- 30