Dc Grocery Variant
In ScopeTechnical: DC_GROCERY_VARIANT | ID: OR-ITM-DC_GROCERY_VARIANT-DC_GROCERY_VARIANT
This table is a staging table for data conversion and will hold product line variant 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_GROCERY_VARIANT
Field Definitions(5)
Rules & Considerations(14)
Sample Load Data(4)
| _scenario | ITEM | PREFIX | COMMENTS | FORMAT_ID | ITEM_DESC | BRAND_NAME | SHORT_DESC | ITEM_PARENT | AIP_CASE_TYPE | ITEM_GRANDPARENT | ITEM_NUMBER_TYPE | ITEM_DESC_SECONDARY | PRIMARY_REF_ITEM_IND | PRODUCT_CLASSIFICATION |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | 1 | SAMPLE | S | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | S | SAMPLE |
| default | Dc Grocery Variant-002-AL | 3 | Dc Grocery Variant-002-ALT | A | Dc Grocery Variant-002-ALT | Dc Grocery Variant Secondary | Dc Grocery Variant-002-ALT | Dc Grocery Variant-002-AL | Dc Gro | Dc Grocery Variant-002-AL | Dc Gro | Dc Grocery Variant-002-ALT | D | Dc Gro |
| default | Dc Grocery Variant-003-ED | 5 | Dc Grocery Variant-003-EDGE | E | Dc Grocery Variant-003-EDGE | Dc Grocery Variant Core | Dc Grocery Variant-003-EDGE | Dc Grocery Variant-003-ED | Dc Gro | Dc Grocery Variant-003-ED | Dc Gro | Dc Grocery Variant-003-EDGE | D | Dc Gro |
Example values from field definitions
- ITEM
- SAMPLE
- PREFIX
- 1
- COMMENTS
- SAMPLE
- FORMAT_ID
- S
- ITEM_DESC
- SAMPLE
- BRAND_NAME
- SAMPLE
- SHORT_DESC
- SAMPLE
- ITEM_PARENT
- SAMPLE
- AIP_CASE_TYPE
- SAMPLE
- ITEM_GRANDPARENT
- SAMPLE
- ITEM_NUMBER_TYPE
- SAMPLE
- ITEM_DESC_SECONDARY
- SAMPLE
- PRIMARY_REF_ITEM_IND
- S
- PRODUCT_CLASSIFICATION
- SAMPLE
default
- ITEM
- Dc Grocery Variant-002-AL
- PREFIX
- 3
- COMMENTS
- Dc Grocery Variant-002-ALT
- FORMAT_ID
- A
- ITEM_DESC
- Dc Grocery Variant-002-ALT
- BRAND_NAME
- Dc Grocery Variant Secondary
- SHORT_DESC
- Dc Grocery Variant-002-ALT
- ITEM_PARENT
- Dc Grocery Variant-002-AL
- AIP_CASE_TYPE
- Dc Gro
- ITEM_GRANDPARENT
- Dc Grocery Variant-002-AL
- ITEM_NUMBER_TYPE
- Dc Gro
- ITEM_DESC_SECONDARY
- Dc Grocery Variant-002-ALT
- PRIMARY_REF_ITEM_IND
- D
- PRODUCT_CLASSIFICATION
- Dc Gro
default
- ITEM
- Dc Grocery Variant-003-ED
- PREFIX
- 5
- COMMENTS
- Dc Grocery Variant-003-EDGE
- FORMAT_ID
- E
- ITEM_DESC
- Dc Grocery Variant-003-EDGE
- BRAND_NAME
- Dc Grocery Variant Core
- SHORT_DESC
- Dc Grocery Variant-003-EDGE
- ITEM_PARENT
- Dc Grocery Variant-003-ED
- AIP_CASE_TYPE
- Dc Gro
- ITEM_GRANDPARENT
- Dc Grocery Variant-003-ED
- ITEM_NUMBER_TYPE
- Dc Gro
- ITEM_DESC_SECONDARY
- Dc Grocery Variant-003-EDGE
- PRIMARY_REF_ITEM_IND
- D
- PRODUCT_CLASSIFICATION
- Dc Gro
Rule Validation Summary
- Source Rule Count
- 20
- Governed Rule Count
- 14