Prod Group Item Bkdn
In ScopeTechnical: PROD_GROUP_ITEM_BKDN | ID: OR-SIOCS-PROD_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
Target Structure
- Load Approach
- Table
- Target Objects
- PROD_GROUP_ITEM_BKDN
Field Definitions(19)
Rules & Considerations(46)
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | STD-PROD_GROUP-001 | Prod Group Item Bkdn-001 | 1000000001 | 1000000001 | 1000000001 | 1000000001 | 01 | 1000000001 | 2 | 1000000001 | Prod Group Item Bkdn-001 | 1 | Prod Group Item Bkdn: Baseline migration row | Prod Group Item Bkdn: Baseline migration row | 1000000001 | Prod Group Item Bkdn-001 | 1 | 0001 | Prod Group Item Bkdn-001 |
default
- ITEM_IDR
- STD-PROD_GROUP-001
- SELLABLER
- Prod Group Item Bkdn-001
- STORE_IDR
- 1000000001
- PRODUCT_GROUP_IDR
- 1000000001
- PRODUCT_GROUP_SCHEDULE_IDR
- 1000000001
- CLASS_ID
- 1000000001
- ITEM_TYPE
- 01
- SUBCLASS_ID
- 1000000001
- BREAKDOWN_NUM
- 2
- DEPARTMENT_ID
- 1000000001
- PRIMARY_LOCATION
- Prod Group Item Bkdn-001
- STORE_AREA_SEQUENCE
- 1
- BREAKDOWN_DESCRIPTION
- Prod Group Item Bkdn: Baseline migration row
- STORE_AREA_DESCRIPTION
- Prod Group Item Bkdn: Baseline migration row
- STORE_SEQUENCE_AREA_ID
- 1000000001
- PROD_GROUP_SCHEDULE_DESC
- Prod Group Item Bkdn-001
- STORE_AREA_ITEM_SEQUENCE
- 1
- STORE_SEQUENCE_AREA_TYPE
- 0001
- UI_BREAKDOWN_NUM_OF_DESC
- Prod Group Item Bkdn-001