Svc Item Supplier
In ScopeTechnical: SVC_ITEM_SUPPLIER | ID: OR-MFCS-SVC_ITEM_SUPPLIER
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
Target Structure
- Load Approach
- Table
- Target Objects
- SVC_ITEM_SUPPLIER
Field Definitions(28)
Rules & Considerations(20)
Sample Load Data(4)
| _scenario | ROW_SEQR | 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 1 | 1000000001 | 1000000001 | Svc Item Supplier-001 | Svc Item Supplier-001 | Svc Item Supplier-001 | 1 | Svc Item Supplier Primary | USERENV | Svc Item Supplier Primary | Svc Item Supplier-001 | USERENV | Svc Item Supplier Primary | Svc Item Supplier-001 | Svc Item Supplier-001 | Svc Item Supplier-001 | Svc Item Supplier-001 | N | 11.0000 | 2026-01-01 | Svc Item Supplier-001 | 11.0000 | Svc Item Supplier-001 | 2026-01-01 | Svc Item Supplier-001 | 2026-01-01 | Svc Item Supplier-001 | Svc Item Supplier-001 |
default
- ROW_SEQR
- 1
- CHUNK_IDR
- 1000000001
- PROCESS_IDRPK
- 1000000001
- VPN
- Svc Item Supplier-001
- ITEM
- Svc Item Supplier-001
- ACTION
- Svc Item Supplier-001
- SUPPLIER
- 1
- CASE_NAME
- Svc Item Supplier Primary
- CREATE_ID
- USERENV
- INNER_NAME
- Svc Item Supplier Primary
- SUPP_LABEL
- Svc Item Supplier-001
- LAST_UPD_ID
- USERENV
- PALLET_NAME
- Svc Item Supplier Primary
- SUPP_DIFF_1
- Svc Item Supplier-001
- SUPP_DIFF_2
- Svc Item Supplier-001
- SUPP_DIFF_3
- Svc Item Supplier-001
- SUPP_DIFF_4
- Svc Item Supplier-001
- PROCESS$STATUS
- N
- CONCESSION_RATE
- 11.0000
- CREATE_DATETIME
- 2026-01-01
- DIRECT_SHIP_IND
- Svc Item Supplier-001
- CONSIGNMENT_RATE
- 11.0000
- PRIMARY_SUPP_IND
- Svc Item Supplier-001
- LAST_UPD_DATETIME
- 2026-01-01
- PRIMARY_CASE_SIZE
- Svc Item Supplier-001
- SUPP_DISCONTINUE_DATE
- 2026-01-01
- DEFAULT_EXPENSE_PROFILES
- Svc Item Supplier-001
- REFRESH_EXPENSES_FROM_PROFILES
- Svc Item Supplier-001