Dc Item Supplier

In Scope

Technical: DC_ITEM_SUPPLIER | ID: OR-ITM-DC_ITEM_SUPPLIER-DC_ITEM_SUPPLIER

This table is a staging table for data conversion and will hold data of 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

Classification

Object Type: dictionary

Target Structure

Load Approach: Table
Target Objects: DC_ITEM_SUPPLIER

Field Definitions(5)

Rules & Considerations(11)

Sample Load Data(4)

_scenario	VPN	ITEM	SUPPLIER	CASE_NAME	INNER_NAME	SUPP_LABEL	PALLET_NAME	CONCESSION_RATE	DIRECT_SHIP_IND	CONSIGNMENT_RATE	PRIMARY_SUPP_IND
Example values from field definitions	SAMPLE	SAMPLE	1	SAMPLE	SAMPLE	SAMPLE	SAMPLE	1.0000	S	1.0000	S
default	Dc Item Supplier-002-ALT	Dc Item Supplier-002-ALT	3	Dc Ite	Dc Ite	Dc Item Supplie	Dc Ite	12.5000	D	12.5000	D
default	Dc Item Supplier-003-EDGE	Dc Item Supplier-003-EDGE	5	Dc Ite	Dc Ite	Dc Item Supplie	Dc Ite	14.0000	D	14.0000	D

Example values from field definitions

VPN: SAMPLE
ITEM: SAMPLE
SUPPLIER: 1
CASE_NAME: SAMPLE
INNER_NAME: SAMPLE
SUPP_LABEL: SAMPLE
PALLET_NAME: SAMPLE
CONCESSION_RATE: 1.0000
DIRECT_SHIP_IND: S
CONSIGNMENT_RATE: 1.0000
PRIMARY_SUPP_IND: S

default

VPN: Dc Item Supplier-002-ALT
ITEM: Dc Item Supplier-002-ALT
SUPPLIER: 3
CASE_NAME: Dc Ite
INNER_NAME: Dc Ite
SUPP_LABEL: Dc Item Supplie
PALLET_NAME: Dc Ite
CONCESSION_RATE: 12.5000
DIRECT_SHIP_IND: D
CONSIGNMENT_RATE: 12.5000
PRIMARY_SUPP_IND: D

default

VPN: Dc Item Supplier-003-EDGE
ITEM: Dc Item Supplier-003-EDGE
SUPPLIER: 5
CASE_NAME: Dc Ite
INNER_NAME: Dc Ite
SUPP_LABEL: Dc Item Supplie
PALLET_NAME: Dc Ite
CONCESSION_RATE: 14.0000
DIRECT_SHIP_IND: D
CONSIGNMENT_RATE: 14.0000
PRIMARY_SUPP_IND: D

Rule Validation Summary

Source Rule Count: 17
Governed Rule Count: 11