Dc Orderable Pack

In Scope

Technical: DC_ORDERABLE_PACK | ID: OR-ITM-DC_ORDERABLE_PACK-DC_ORDERABLE_PACK

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

Field Definitions(5)

Rules & Considerations(33)

Sample Load Data(4)

_scenario	DEPT	ITEM	CLASS	DIFF_1	DIFF_2	DIFF_3	DIFF_4	COMMENTS	SUBCLASS	ITEM_DESC	PACK_TYPE	SALE_TYPE	BRAND_NAME	ORDER_TYPE	SHORT_DESC	PACKAGE_UOM	PACKAGE_SIZE	SELLABLE_IND	HANDLING_TEMP	ORDER_AS_TYPE	MFG_REC_RETAIL	PERISHABLE_IND	STORE_ORD_MULT	SIMPLE_PACK_IND	CATCH_WEIGHT_IND	NOTIONAL_PACK_IND	RETAIL_LABEL_TYPE	COST_ZONE_GROUP_ID	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	S	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMP	1.0000	S	SAMPLE	S	1.0000	S	S	S	S	S	SAMPLE	1	1.0000	SAMPLE	SAMPLE	SAMPLE	S
default	1003	Dc Orderable Pack-002-ALT	1103	Dc Orderab	Dc Orderab	Dc Orderab	Dc Orderab	Dc Orderable Pack-002-ALT	1113	Dc Orderable Pack-002-ALT	D	Dc Ord	Dc Orderable Pack Secondary	Dc Ord	Dc Orderable Pack-002-ALT	Dc O	12.5000	D	Dc Ord	D	12.5000	D	D	D	D	D	Dc Ord	100003	12.5000	Dc Orderable Pack-002-ALT	Dc Ord	Dc Ord	D
default	1005	Dc Orderable Pack-003-EDG	1105	Dc Orderab	Dc Orderab	Dc Orderab	Dc Orderab	Dc Orderable Pack-003-EDGE	1115	Dc Orderable Pack-003-EDGE	D	Dc Ord	Dc Orderable Pack Core	Dc Ord	Dc Orderable Pack-003-EDGE	Dc O	14.0000	D	Dc Ord	D	14.0000	D	D	D	D	D	Dc Ord	100005	14.0000	Dc Orderable Pack-003-EDGE	Dc Ord	Dc Ord	D

Example values from field definitions

default

DEPT: 1003
ITEM: Dc Orderable Pack-002-ALT
CLASS: 1103
DIFF_1: Dc Orderab
DIFF_2: Dc Orderab
DIFF_3: Dc Orderab
DIFF_4: Dc Orderab
COMMENTS: Dc Orderable Pack-002-ALT
SUBCLASS: 1113
ITEM_DESC: Dc Orderable Pack-002-ALT
PACK_TYPE: D
SALE_TYPE: Dc Ord
BRAND_NAME: Dc Orderable Pack Secondary
ORDER_TYPE: Dc Ord
SHORT_DESC: Dc Orderable Pack-002-ALT
PACKAGE_UOM: Dc O
PACKAGE_SIZE: 12.5000
SELLABLE_IND: D
HANDLING_TEMP: Dc Ord
ORDER_AS_TYPE: D
MFG_REC_RETAIL: 12.5000
PERISHABLE_IND: D
STORE_ORD_MULT: D
SIMPLE_PACK_IND: D
CATCH_WEIGHT_IND: D
NOTIONAL_PACK_IND: D
RETAIL_LABEL_TYPE: Dc Ord
COST_ZONE_GROUP_ID: 100003
RETAIL_LABEL_VALUE: 12.5000
ITEM_DESC_SECONDARY: Dc Orderable Pack-002-ALT
HANDLING_SENSITIVITY: Dc Ord
PRODUCT_CLASSIFICATION: Dc Ord
SOH_INQUIRY_AT_PACK_IND: D

default

DEPT: 1005
ITEM: Dc Orderable Pack-003-EDG
CLASS: 1105
DIFF_1: Dc Orderab
DIFF_2: Dc Orderab
DIFF_3: Dc Orderab
DIFF_4: Dc Orderab
COMMENTS: Dc Orderable Pack-003-EDGE
SUBCLASS: 1115
ITEM_DESC: Dc Orderable Pack-003-EDGE
PACK_TYPE: D
SALE_TYPE: Dc Ord
BRAND_NAME: Dc Orderable Pack Core
ORDER_TYPE: Dc Ord
SHORT_DESC: Dc Orderable Pack-003-EDGE
PACKAGE_UOM: Dc O
PACKAGE_SIZE: 14.0000
SELLABLE_IND: D
HANDLING_TEMP: Dc Ord
ORDER_AS_TYPE: D
MFG_REC_RETAIL: 14.0000
PERISHABLE_IND: D
STORE_ORD_MULT: D
SIMPLE_PACK_IND: D
CATCH_WEIGHT_IND: D
NOTIONAL_PACK_IND: D
RETAIL_LABEL_TYPE: Dc Ord
COST_ZONE_GROUP_ID: 100005
RETAIL_LABEL_VALUE: 14.0000
ITEM_DESC_SECONDARY: Dc Orderable Pack-003-EDGE
HANDLING_SENSITIVITY: Dc Ord
PRODUCT_CLASSIFICATION: Dc Ord
SOH_INQUIRY_AT_PACK_IND: D

Rule Validation Summary

Source Rule Count: 39
Governed Rule Count: 33