Item Supplier
In ScopeTechnical: ITEM_SUPPLIER | ID: OR-MFCS-ITEM_SUPPLIER
Stores all item supplier relationships for all items.
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
- ITEM_SUPPLIER
Field Definitions(21)
Rules & Considerations(36)
Sample Load Data(4)
| _scenario | ITEMRPK | SUPPLIERRPK | CASE_NAMER | CREATE_IDR | INNER_NAMER | PALLET_NAMER | LAST_UPDATE_IDR | CREATE_DATETIMER | DIRECT_SHIP_INDR | PRIMARY_SUPP_INDR | LAST_UPDATE_DATETIMER | VPN | SUPP_LABEL | SUPP_DIFF_1 | SUPP_DIFF_2 | SUPP_DIFF_3 | SUPP_DIFF_4 | CONCESSION_RATE | CONSIGNMENT_RATE | PRIMARY_CASE_SIZE | SUPP_DISCONTINUE_DATE |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | Item Supplier-001 | 1 | Item Supplier Primary | USERENV | Item Supplier Primary | Item Supplier Primary | MIG_USER | 2026-01-01 | Item Supplier-001 | sub | 2026-01-01 | Item Supplier-001 | Item Supplier-001 | Item Supplier-001 | Item Supplier-001 | Item Supplier-001 | Item Supplier-001 | 11.0000 | 11.0000 | Item Supplier-001 | 2026-01-01 |
default
- ITEMRPK
- Item Supplier-001
- SUPPLIERRPK
- 1
- CASE_NAMER
- Item Supplier Primary
- CREATE_IDR
- USERENV
- INNER_NAMER
- Item Supplier Primary
- PALLET_NAMER
- Item Supplier Primary
- LAST_UPDATE_IDR
- MIG_USER
- CREATE_DATETIMER
- 2026-01-01
- DIRECT_SHIP_INDR
- Item Supplier-001
- PRIMARY_SUPP_INDR
- sub
- LAST_UPDATE_DATETIMER
- 2026-01-01
- VPN
- Item Supplier-001
- SUPP_LABEL
- Item Supplier-001
- SUPP_DIFF_1
- Item Supplier-001
- SUPP_DIFF_2
- Item Supplier-001
- SUPP_DIFF_3
- Item Supplier-001
- SUPP_DIFF_4
- Item Supplier-001
- CONCESSION_RATE
- 11.0000
- CONSIGNMENT_RATE
- 11.0000
- PRIMARY_CASE_SIZE
- Item Supplier-001
- SUPP_DISCONTINUE_DATE
- 2026-01-01