Dc Sellable Pack

In Scope

Technical: DC_SELLABLE_PACK | ID: OR-ITM-DC_SELLABLE_PACK-DC_SELLABLE_PACK

This table is a staging table for data conversion and will hold the sellable pack item information.

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_SELLABLE_PACK

Field Definitions(5)

Rules & Considerations(25)

Sample Load Data(4)

_scenario	DEPT	ITEM	CLASS	DIFF_1	DIFF_2	DIFF_3	DIFF_4	COMMENTS	SUBCLASS	ITEM_DESC	BRAND_NAME	SHORT_DESC	PACKAGE_UOM	UNIT_RETAIL	PACKAGE_SIZE	HANDLING_TEMP	MFG_REC_RETAIL	PERISHABLE_IND	NOTIONAL_PACK_IND	RETAIL_LABEL_TYPE	RETAIL_LABEL_VALUE	ITEM_DESC_SECONDARY	HANDLING_SENSITIVITY	PRODUCT_CLASSIFICATION	SOH_INQUIRY_AT_PACK_IND
Example values from field definitions	1	SAMPLE	1	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	1	SAMPLE	SAMPLE	SAMPLE	SAMP	1.0000	1.0000	SAMPLE	1.0000	S	S	SAMPLE	1.0000	SAMPLE	SAMPLE	SAMPLE	S
default	1003	Dc Sellable Pack-002-ALT	1103	Dc Sellabl	Dc Sellabl	Dc Sellabl	Dc Sellabl	Dc Sellable Pack-002-ALT	1113	Dc Sellable Pack-002-ALT	Dc Sellable Pack Secondary	Dc Sellable Pack-002-ALT	Dc S	12.5000	12.5000	Dc Sel	12.5000	D	D	Dc Sel	12.5000	Dc Sellable Pack-002-ALT	Dc Sel	Dc Sel	D
default	1005	Dc Sellable Pack-003-EDGE	1105	Dc Sellabl	Dc Sellabl	Dc Sellabl	Dc Sellabl	Dc Sellable Pack-003-EDGE	1115	Dc Sellable Pack-003-EDGE	Dc Sellable Pack Core	Dc Sellable Pack-003-EDGE	Dc S	14.0000	14.0000	Dc Sel	14.0000	D	D	Dc Sel	14.0000	Dc Sellable Pack-003-EDGE	Dc Sel	Dc Sel	D

Example values from field definitions

DEPT: 1
ITEM: SAMPLE
CLASS: 1
DIFF_1: SAMPLE
DIFF_2: SAMPLE
DIFF_3: SAMPLE
DIFF_4: SAMPLE
COMMENTS: SAMPLE
SUBCLASS: 1
ITEM_DESC: SAMPLE
BRAND_NAME: SAMPLE
SHORT_DESC: SAMPLE
PACKAGE_UOM: SAMP
UNIT_RETAIL: 1.0000
PACKAGE_SIZE: 1.0000
HANDLING_TEMP: SAMPLE
MFG_REC_RETAIL: 1.0000
PERISHABLE_IND: S
NOTIONAL_PACK_IND: S
RETAIL_LABEL_TYPE: SAMPLE
RETAIL_LABEL_VALUE: 1.0000
ITEM_DESC_SECONDARY: SAMPLE
HANDLING_SENSITIVITY: SAMPLE
PRODUCT_CLASSIFICATION: SAMPLE
SOH_INQUIRY_AT_PACK_IND: S

default

DEPT: 1003
ITEM: Dc Sellable Pack-002-ALT
CLASS: 1103
DIFF_1: Dc Sellabl
DIFF_2: Dc Sellabl
DIFF_3: Dc Sellabl
DIFF_4: Dc Sellabl
COMMENTS: Dc Sellable Pack-002-ALT
SUBCLASS: 1113
ITEM_DESC: Dc Sellable Pack-002-ALT
BRAND_NAME: Dc Sellable Pack Secondary
SHORT_DESC: Dc Sellable Pack-002-ALT
PACKAGE_UOM: Dc S
UNIT_RETAIL: 12.5000
PACKAGE_SIZE: 12.5000
HANDLING_TEMP: Dc Sel
MFG_REC_RETAIL: 12.5000
PERISHABLE_IND: D
NOTIONAL_PACK_IND: D
RETAIL_LABEL_TYPE: Dc Sel
RETAIL_LABEL_VALUE: 12.5000
ITEM_DESC_SECONDARY: Dc Sellable Pack-002-ALT
HANDLING_SENSITIVITY: Dc Sel
PRODUCT_CLASSIFICATION: Dc Sel
SOH_INQUIRY_AT_PACK_IND: D

default

DEPT: 1005
ITEM: Dc Sellable Pack-003-EDGE
CLASS: 1105
DIFF_1: Dc Sellabl
DIFF_2: Dc Sellabl
DIFF_3: Dc Sellabl
DIFF_4: Dc Sellabl
COMMENTS: Dc Sellable Pack-003-EDGE
SUBCLASS: 1115
ITEM_DESC: Dc Sellable Pack-003-EDGE
BRAND_NAME: Dc Sellable Pack Core
SHORT_DESC: Dc Sellable Pack-003-EDGE
PACKAGE_UOM: Dc S
UNIT_RETAIL: 14.0000
PACKAGE_SIZE: 14.0000
HANDLING_TEMP: Dc Sel
MFG_REC_RETAIL: 14.0000
PERISHABLE_IND: D
NOTIONAL_PACK_IND: D
RETAIL_LABEL_TYPE: Dc Sel
RETAIL_LABEL_VALUE: 14.0000
ITEM_DESC_SECONDARY: Dc Sellable Pack-003-EDGE
HANDLING_SENSITIVITY: Dc Sel
PRODUCT_CLASSIFICATION: Dc Sel
SOH_INQUIRY_AT_PACK_IND: D

Rule Validation Summary

Source Rule Count: 31
Governed Rule Count: 25