Dc Product Line

In Scope

Technical: DC_PRODUCT_LINE | ID: OR-ITM-DC_PRODUCT_LINE-DC_PRODUCT_LINE

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_LINE

Field Definitions(5)

Rules & Considerations(20)

Sample Load Data(4)

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
AIP_CASE_TYPE
SAMPLE
ITEM_AGGREGATE_IND
S
ITEM_DESC_SECONDARY
SAMPLE
DIFF_1_AGGREGATE_IND
S
DIFF_2_AGGREGATE_IND
S
DIFF_3_AGGREGATE_IND
S
DIFF_4_AGGREGATE_IND
S
PRODUCT_CLASSIFICATION
SAMPLE

default

DEPT
1003
ITEM
Dc Product Line-002-ALT
CLASS
1103
DIFF_1
Dc Product
DIFF_2
Dc Product
DIFF_3
Dc Product
DIFF_4
Dc Product
COMMENTS
Dc Product Line-002-ALT
SUBCLASS
1113
ITEM_DESC
Dc Product Line-002-ALT
BRAND_NAME
Dc Product Line Secondary
SHORT_DESC
Dc Product Line-002-ALT
AIP_CASE_TYPE
Dc Pro
ITEM_AGGREGATE_IND
D
ITEM_DESC_SECONDARY
Dc Product Line-002-ALT
DIFF_1_AGGREGATE_IND
D
DIFF_2_AGGREGATE_IND
D
DIFF_3_AGGREGATE_IND
D
DIFF_4_AGGREGATE_IND
D
PRODUCT_CLASSIFICATION
Dc Pro

default

DEPT
1005
ITEM
Dc Product Line-003-EDGE
CLASS
1105
DIFF_1
Dc Product
DIFF_2
Dc Product
DIFF_3
Dc Product
DIFF_4
Dc Product
COMMENTS
Dc Product Line-003-EDGE
SUBCLASS
1115
ITEM_DESC
Dc Product Line-003-EDGE
BRAND_NAME
Dc Product Line Core
SHORT_DESC
Dc Product Line-003-EDGE
AIP_CASE_TYPE
Dc Pro
ITEM_AGGREGATE_IND
D
ITEM_DESC_SECONDARY
Dc Product Line-003-EDGE
DIFF_1_AGGREGATE_IND
D
DIFF_2_AGGREGATE_IND
D
DIFF_3_AGGREGATE_IND
D
DIFF_4_AGGREGATE_IND
D
PRODUCT_CLASSIFICATION
Dc Pro

Rule Validation Summary

Source Rule Count
26
Governed Rule Count
20