Item Supplier Relationships For All Items

In Scope

Technical: 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(5)

Rules & Considerations(33)

validation

constraint

Sample Load Data(4)

_scenario	ITEMRPK	SUPPLIERRPK	PRIMARY_SUPP_INDR	VPN	CASE_NAME	CREATE_ID	INNER_NAME	SUPP_LABEL	PALLET_NAME	SUPP_DIFF_1	SUPP_DIFF_2	SUPP_DIFF_3	SUPP_DIFF_4	LAST_UPDATE_ID	CONCESSION_RATE	CREATE_DATETIME	DIRECT_SHIP_IND	CONSIGNMENT_RATE	PRIMARY_CASE_SIZE	LAST_UPDATE_DATETIME	SUPP_DISCONTINUE_DATE
Example values from field definitions	SAMPLE	1	S	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	1.0000	2026-01-01	S	1.0000	SAMPLE	2026-01-01	2026-01-01
default	Item Supplier-002-ALT	3	s	Item Supplier-002-ALT	Item S	C LIENT_INFO	Item S	Item Supplier-0	Item S	Item Supplier-002-ALT	Item Supplier-002-ALT	Item Supplier-002-ALT	Item Supplier-002-ALT	MDM_USER	12.5000	2026-01-03	I	12.5000	Item S	2026-01-03	2026-01-03
default	Item Supplier-003-EDGE	5	s	Item Supplier-003-EDGE	Item S	USE RENV	Item S	Item Supplier-0	Item S	Item Supplier-003-EDGE	Item Supplier-003-EDGE	Item Supplier-003-EDGE	Item Supplier-003-EDGE	BATCH_USER	14.0000	2026-01-05	I	14.0000	Item S	2026-01-05	2026-01-05

Example values from field definitions

ITEMRPK: SAMPLE
SUPPLIERRPK: 1
PRIMARY_SUPP_INDR: S
VPN: SAMPLE
CASE_NAME: SAMPLE
CREATE_ID: SAMPLE
INNER_NAME: SAMPLE
SUPP_LABEL: SAMPLE
PALLET_NAME: SAMPLE
SUPP_DIFF_1: SAMPLE
SUPP_DIFF_2: SAMPLE
SUPP_DIFF_3: SAMPLE
SUPP_DIFF_4: SAMPLE
LAST_UPDATE_ID: SAMPLE
CONCESSION_RATE: 1.0000
CREATE_DATETIME: 2026-01-01
DIRECT_SHIP_IND: S
CONSIGNMENT_RATE: 1.0000
PRIMARY_CASE_SIZE: SAMPLE
LAST_UPDATE_DATETIME: 2026-01-01
SUPP_DISCONTINUE_DATE: 2026-01-01

default

ITEMRPK: Item Supplier-002-ALT
SUPPLIERRPK: 3
PRIMARY_SUPP_INDR: s
VPN: Item Supplier-002-ALT
CASE_NAME: Item S
CREATE_ID: C LIENT_INFO
INNER_NAME: Item S
SUPP_LABEL: Item Supplier-0
PALLET_NAME: Item S
SUPP_DIFF_1: Item Supplier-002-ALT
SUPP_DIFF_2: Item Supplier-002-ALT
SUPP_DIFF_3: Item Supplier-002-ALT
SUPP_DIFF_4: Item Supplier-002-ALT
LAST_UPDATE_ID: MDM_USER
CONCESSION_RATE: 12.5000
CREATE_DATETIME: 2026-01-03
DIRECT_SHIP_IND: I
CONSIGNMENT_RATE: 12.5000
PRIMARY_CASE_SIZE: Item S
LAST_UPDATE_DATETIME: 2026-01-03
SUPP_DISCONTINUE_DATE: 2026-01-03

default

ITEMRPK: Item Supplier-003-EDGE
SUPPLIERRPK: 5
PRIMARY_SUPP_INDR: s
VPN: Item Supplier-003-EDGE
CASE_NAME: Item S
CREATE_ID: USE RENV
INNER_NAME: Item S
SUPP_LABEL: Item Supplier-0
PALLET_NAME: Item S
SUPP_DIFF_1: Item Supplier-003-EDGE
SUPP_DIFF_2: Item Supplier-003-EDGE
SUPP_DIFF_3: Item Supplier-003-EDGE
SUPP_DIFF_4: Item Supplier-003-EDGE
LAST_UPDATE_ID: BATCH_USER
CONCESSION_RATE: 14.0000
CREATE_DATETIME: 2026-01-05
DIRECT_SHIP_IND: I
CONSIGNMENT_RATE: 14.0000
PRIMARY_CASE_SIZE: Item S
LAST_UPDATE_DATETIME: 2026-01-05
SUPP_DISCONTINUE_DATE: 2026-01-05

Rule Validation Summary

Source Rule Count: 69
Governed Rule Count: 33