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(5)
Rules & Considerations(24)
constraint
validation
Sample Load Data(4)
| _scenario | ITEM_IDR | STORE_IDR | PRODUCT_GROUP_IDR | PRODUCT_GROUP_SCHEDULE_IDR | CLASS_ID | SELLABLE | 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 | 1 | 1 | 1 | 1 | S | 1 | 1 | 1 | 1 | S | 1 | SAMPLE | SAMPLE | 1 | SAMPLE | 1 | 1 | SAMPLE |
| default | ALT-PROD_GROUP-002 | 1000000003 | 1000000003 | 1000000003 | 1000000003 | P | 3 | 1000000003 | 4 | 1000000003 | P | 3 | Prod Group Item Bkdn: Alternate source profile | Prod Group Item Bkdn: Alternate source profile | 1000000003 | Prod Group Item Bkdn-002-ALT | 3 | 3 | Prod Group Item Bkdn-002-ALT |
| default | EDGE-PROD_GROUP-003 | 1000000005 | 1000000005 | 1000000005 | 1000000005 | P | 5 | 1000000005 | 6 | 1000000005 | P | 5 | — | — | 1000000005 | Prod Group Item Bkdn-003-EDGE | 5 | 5 | Prod Group Item Bkdn-003-EDGE |
Example values from field definitions
- ITEM_IDR
- SAMPLE
- STORE_IDR
- 1
- PRODUCT_GROUP_IDR
- 1
- PRODUCT_GROUP_SCHEDULE_IDR
- 1
- CLASS_ID
- 1
- SELLABLE
- S
- 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
default
- ITEM_IDR
- ALT-PROD_GROUP-002
- STORE_IDR
- 1000000003
- PRODUCT_GROUP_IDR
- 1000000003
- PRODUCT_GROUP_SCHEDULE_IDR
- 1000000003
- CLASS_ID
- 1000000003
- SELLABLE
- P
- ITEM_TYPE
- 3
- SUBCLASS_ID
- 1000000003
- BREAKDOWN_NUM
- 4
- DEPARTMENT_ID
- 1000000003
- PRIMARY_LOCATION
- P
- STORE_AREA_SEQUENCE
- 3
- BREAKDOWN_DESCRIPTION
- Prod Group Item Bkdn: Alternate source profile
- STORE_AREA_DESCRIPTION
- Prod Group Item Bkdn: Alternate source profile
- STORE_SEQUENCE_AREA_ID
- 1000000003
- PROD_GROUP_SCHEDULE_DESC
- Prod Group Item Bkdn-002-ALT
- STORE_AREA_ITEM_SEQUENCE
- 3
- STORE_SEQUENCE_AREA_TYPE
- 3
- UI_BREAKDOWN_NUM_OF_DESC
- Prod Group Item Bkdn-002-ALT
default
- ITEM_IDR
- EDGE-PROD_GROUP-003
- STORE_IDR
- 1000000005
- PRODUCT_GROUP_IDR
- 1000000005
- PRODUCT_GROUP_SCHEDULE_IDR
- 1000000005
- CLASS_ID
- 1000000005
- SELLABLE
- P
- ITEM_TYPE
- 5
- SUBCLASS_ID
- 1000000005
- BREAKDOWN_NUM
- 6
- DEPARTMENT_ID
- 1000000005
- PRIMARY_LOCATION
- P
- STORE_AREA_SEQUENCE
- 5
- BREAKDOWN_DESCRIPTION
- —
- STORE_AREA_DESCRIPTION
- —
- STORE_SEQUENCE_AREA_ID
- 1000000005
- PROD_GROUP_SCHEDULE_DESC
- Prod Group Item Bkdn-003-EDGE
- STORE_AREA_ITEM_SEQUENCE
- 5
- STORE_SEQUENCE_AREA_TYPE
- 5
- UI_BREAKDOWN_NUM_OF_DESC
- Prod Group Item Bkdn-003-EDGE
Rule Validation Summary
- Source Rule Count
- 27
- Governed Rule Count
- 24