Dc Product

In Scope

Technical: DC_PRODUCT | ID: OR-ITM-DC_PRODUCT-DC_PRODUCT

This table is a staging table for data conversion and will hold style item data of ITEM_MASTER table.

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_PRODUCT

Field Definitions(5)

Rules & Considerations(34)

Sample Load Data(4)

_scenario	ITEM	DIFF_1	DIFF_2	DIFF_3	DIFF_4	COMMENTS	ITEM_DESC	WASTE_PCT	BRAND_NAME	SHORT_DESC	WASTE_TYPE	ITEM_PARENT	PACKAGE_UOM	FORECAST_IND	PACKAGE_SIZE	STANDARD_UOM	AIP_CASE_TYPE	HANDLING_TEMP	CONTAINER_ITEM	PERISHABLE_IND	STORE_ORD_MULT	MERCHANDISE_IND	UOM_CONV_FACTOR	CATCH_WEIGHT_IND	DEFAULT_WASTE_PCT	DEPOSIT_ITEM_TYPE	RETAIL_LABEL_TYPE	COST_ZONE_GROUP_ID	RETAIL_LABEL_VALUE	ITEM_DESC_SECONDARY	PRIMARY_PRODUCT_IND	HANDLING_SENSITIVITY	PRODUCT_CLASSIFICATION	DEPOSIT_IN_PRICE_PER_UOM
Example values from field definitions	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	1.0000	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMP	S	1.0000	SAMP	SAMPLE	SAMPLE	SAMPLE	S	S	S	1.0000000000	S	1.0000	SAMPLE	SAMPLE	1	1.0000	SAMPLE	S	SAMPLE	SAMPLE	SAMPLE
default	Dc Product-002-ALT	Dc Product	Dc Product	Dc Product	Dc Product	Dc Product-002-ALT	Dc Product-002-ALT	12.5000	Dc Product Secondary	Dc Product-002-ALT	Dc Pro	Dc Product-002-ALT	Dc P	D	12.5000	Dc P	Dc Pro	Dc Pro	Dc Product-002-ALT	D	C	D	12.5000000000	N	12.5000	Dc Pro	Dc Pro	100003	12.5000	Dc Product-002-ALT	D	Dc Pro	Dc Pro	Dc Pro
default	Dc Product-003-EDGE	Dc Product	Dc Product	Dc Product	Dc Product	Dc Product-003-EDGE	Dc Product-003-EDGE	14.0000	Dc Product Core	Dc Product-003-EDGE	Dc Pro	Dc Product-003-EDGE	Dc P	D	14.0000	Dc P	Dc Pro	Dc Pro	Dc Product-003-EDGE	D	C	D	14.0000000000	Y	14.0000	Dc Pro	Dc Pro	100005	14.0000	Dc Product-003-EDGE	D	Dc Pro	Dc Pro	Dc Pro

Example values from field definitions

default

ITEM: Dc Product-002-ALT
DIFF_1: Dc Product
DIFF_2: Dc Product
DIFF_3: Dc Product
DIFF_4: Dc Product
COMMENTS: Dc Product-002-ALT
ITEM_DESC: Dc Product-002-ALT
WASTE_PCT: 12.5000
BRAND_NAME: Dc Product Secondary
SHORT_DESC: Dc Product-002-ALT
WASTE_TYPE: Dc Pro
ITEM_PARENT: Dc Product-002-ALT
PACKAGE_UOM: Dc P
FORECAST_IND: D
PACKAGE_SIZE: 12.5000
STANDARD_UOM: Dc P
AIP_CASE_TYPE: Dc Pro
HANDLING_TEMP: Dc Pro
CONTAINER_ITEM: Dc Product-002-ALT
PERISHABLE_IND: D
STORE_ORD_MULT: C
MERCHANDISE_IND: D
UOM_CONV_FACTOR: 12.5000000000
CATCH_WEIGHT_IND: N
DEFAULT_WASTE_PCT: 12.5000
DEPOSIT_ITEM_TYPE: Dc Pro
RETAIL_LABEL_TYPE: Dc Pro
COST_ZONE_GROUP_ID: 100003
RETAIL_LABEL_VALUE: 12.5000
ITEM_DESC_SECONDARY: Dc Product-002-ALT
PRIMARY_PRODUCT_IND: D
HANDLING_SENSITIVITY: Dc Pro
PRODUCT_CLASSIFICATION: Dc Pro
DEPOSIT_IN_PRICE_PER_UOM: Dc Pro

default

ITEM: Dc Product-003-EDGE
DIFF_1: Dc Product
DIFF_2: Dc Product
DIFF_3: Dc Product
DIFF_4: Dc Product
COMMENTS: Dc Product-003-EDGE
ITEM_DESC: Dc Product-003-EDGE
WASTE_PCT: 14.0000
BRAND_NAME: Dc Product Core
SHORT_DESC: Dc Product-003-EDGE
WASTE_TYPE: Dc Pro
ITEM_PARENT: Dc Product-003-EDGE
PACKAGE_UOM: Dc P
FORECAST_IND: D
PACKAGE_SIZE: 14.0000
STANDARD_UOM: Dc P
AIP_CASE_TYPE: Dc Pro
HANDLING_TEMP: Dc Pro
CONTAINER_ITEM: Dc Product-003-EDGE
PERISHABLE_IND: D
STORE_ORD_MULT: C
MERCHANDISE_IND: D
UOM_CONV_FACTOR: 14.0000000000
CATCH_WEIGHT_IND: Y
DEFAULT_WASTE_PCT: 14.0000
DEPOSIT_ITEM_TYPE: Dc Pro
RETAIL_LABEL_TYPE: Dc Pro
COST_ZONE_GROUP_ID: 100005
RETAIL_LABEL_VALUE: 14.0000
ITEM_DESC_SECONDARY: Dc Product-003-EDGE
PRIMARY_PRODUCT_IND: D
HANDLING_SENSITIVITY: Dc Pro
PRODUCT_CLASSIFICATION: Dc Pro
DEPOSIT_IN_PRICE_PER_UOM: Dc Pro

Rule Validation Summary

Source Rule Count: 44
Governed Rule Count: 34