Product Group Item Bkdn
In ScopeTechnical: PROD_GROUP_ITEM_BKDN | ID: OR-STO-PROD_GROUP_ITEM_BKDN-PRODUCT_GROUP_ITEM_BKDN
Temporary table holds product group schedule items breakdown details defined by the product group schedule or product group hierarchy. This table is used in product group related event generation.
See how this object fits into Store Operations
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
- PROD_GROUP_ITEM_BKDN
Field Definitions(19)
Rules & Considerations(24)
Sample Load Data(4)
| _scenario | ITEM_IDR | SELLABLER | STORE_IDR | PRODUCT_GROUP_IDR | PRODUCT_GROUP_SCHEDULE_IDR | CLASS_ID | ITEM_TYPE | SUBCLASS_ID | BREAKDOWN_NUM | DEPARTMENT_ID | PRIMARY_LOCATION | STORE_AREA_SEQUENCE | BREAKDOWN_DESCRIPTION | STORE_AREA_DESCRIPTION | STORE_SEQUENCE_AREA_ID | PROD_GROUP_SCHEDULE_DESC | STORE_AREA_ITEM_SEQUENCE | STORE_SEQUENCE_AREA_TYPE | UI_BREAKDOWN_NUM_OF_DESC |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | S | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | S | 1 | SAMPLE | SAMPLE | 1 | SAMPLE | 1 | 1 | SAMPLE |
Example values from field definitions
- ITEM_IDR
- SAMPLE
- SELLABLER
- S
- STORE_IDR
- 1
- PRODUCT_GROUP_IDR
- 1
- PRODUCT_GROUP_SCHEDULE_IDR
- 1
- CLASS_ID
- 1
- ITEM_TYPE
- 1
- SUBCLASS_ID
- 1
- BREAKDOWN_NUM
- 1
- DEPARTMENT_ID
- 1
- PRIMARY_LOCATION
- S
- STORE_AREA_SEQUENCE
- 1
- BREAKDOWN_DESCRIPTION
- SAMPLE
- STORE_AREA_DESCRIPTION
- SAMPLE
- STORE_SEQUENCE_AREA_ID
- 1
- PROD_GROUP_SCHEDULE_DESC
- SAMPLE
- STORE_AREA_ITEM_SEQUENCE
- 1
- STORE_SEQUENCE_AREA_TYPE
- 1
- UI_BREAKDOWN_NUM_OF_DESC
- SAMPLE
Rule Validation Summary
- Source Rule Count
- 27
- Governed Rule Count
- 24