Item Supplier Relationships For All Items
In ScopeTechnical: ITEM_SUPPLIER | ID: OR-ITM-ITEM_SUPPLIER-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
Classification
- Object Type
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- ITEM_SUPPLIER
Field Definitions(21)
Rules & Considerations(31)
validation
constraint
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | 1 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | 2026-01-01 | S | S | 2026-01-01 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | 1.0000 | 1.0000 | SAMPLE | 2026-01-01 |
Example values from field definitions
- ITEMRPK
- SAMPLE
- SUPPLIERRPK
- 1
- CASE_NAMER
- SAMPLE
- CREATE_IDR
- SAMPLE
- INNER_NAMER
- SAMPLE
- PALLET_NAMER
- SAMPLE
- LAST_UPDATE_IDR
- SAMPLE
- CREATE_DATETIMER
- 2026-01-01
- DIRECT_SHIP_INDR
- S
- PRIMARY_SUPP_INDR
- S
- LAST_UPDATE_DATETIMER
- 2026-01-01
- VPN
- SAMPLE
- SUPP_LABEL
- SAMPLE
- SUPP_DIFF_1
- SAMPLE
- SUPP_DIFF_2
- SAMPLE
- SUPP_DIFF_3
- SAMPLE
- SUPP_DIFF_4
- SAMPLE
- CONCESSION_RATE
- 1.0000
- CONSIGNMENT_RATE
- 1.0000
- PRIMARY_CASE_SIZE
- SAMPLE
- SUPP_DISCONTINUE_DATE
- 2026-01-01
Rule Validation Summary
- Source Rule Count
- 67
- Governed Rule Count
- 31