One Row For Each Item/Supplier Combination
In ScopeTechnical: SUPPLIER_ITEM | ID: OR-STO-SUPPLIER_ITEM-SUPPLIER_ITEM
Stores one row for each item/supplier combination within the system.
See how this object fits into Store Operations
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
- SUPPLIER_ITEM
Field Definitions(4)
Rules & Considerations(10)
constraint
validation
Sample Load Data(4)
| _scenario | ITEM_IDRPK | SUPPLIER_IDRPK | IS_PRIMARY | VENDOR_PRODUCT_NUMBER |
|---|---|---|---|---|
| Example values from field definitions | SAMPLE | 1 | SAM | SAMPLE |
| default | ALT-SUPPLIER_I-002 | 1000000003 | N | Supplier Item-002-ALT |
| default | EDGE-SUPPLIER_I-003 | 1000000005 | Y | Supplier Item-003-EDGE |
Example values from field definitions
- ITEM_IDRPK
- SAMPLE
- SUPPLIER_IDRPK
- 1
- IS_PRIMARY
- SAM
- VENDOR_PRODUCT_NUMBER
- SAMPLE
default
- ITEM_IDRPK
- ALT-SUPPLIER_I-002
- SUPPLIER_IDRPK
- 1000000003
- IS_PRIMARY
- N
- VENDOR_PRODUCT_NUMBER
- Supplier Item-002-ALT
default
- ITEM_IDRPK
- EDGE-SUPPLIER_I-003
- SUPPLIER_IDRPK
- 1000000005
- IS_PRIMARY
- Y
- VENDOR_PRODUCT_NUMBER
- Supplier Item-003-EDGE
Rule Validation Summary
- Source Rule Count
- 14
- Governed Rule Count
- 10