Product-location-campaigns
In ScopeTechnical: product_location_campaigns | ID: RELEX-RA-PRODUCT_LOCATION_CAMPAIGNS
Correcting historical sales (repl. and promo) and forecasting future campaigns (promo).
See how this object fits into Promotions
Review the broader sequencing and dependencies for this domain
Migration Details
- Complexity
- Medium
- Sequencing
- Stage 3 - Optimization Parameters
- Typical Sources
- ERPLegacy
Target Structure
- Load Approach
- Table
- Target Objects
- product_location_campaigns
Field Definitions(5)
Rules & Considerations(29)
Sample Load Data(4)
| _scenario | productRPK | campaignRPK | locationRPK | state | Displays | Features | set_number | campaign_price | secondary_space | set_reward_quantity | set_multiple_quantity | set_price_modification_value | set_price_modification_method_code |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 57896 | P13010 | 550 | DELETE | Checkout | TV | 1 | 5 | False | 1 | 1 | 1 | STD-PRODUCT_LO-001 |
| default | 57896-ALT | P13010-ALT | 550-ALT | DELETE-ALT | Checkout-ALT | TV-ALT | 3 | 6 | True | 3 | 3 | 3 | ALT-PRODUCT_LO-002 |
| default | 57896-EDGE | P13010-EDGE | 550-EDGE | DELETE-EDGE | Checkout-EDGE | TV-EDGE | 5 | 7 | False | 5 | 5 | 5 | EDGE-PRODUCT_LO-003 |
default
- productRPK
- 57896
- campaignRPK
- P13010
- locationRPK
- 550
- state
- DELETE
- Displays
- Checkout
- Features
- TV
- set_number
- 1
- campaign_price
- 5
- secondary_space
- False
- set_reward_quantity
- 1
- set_multiple_quantity
- 1
- set_price_modification_value
- 1
- set_price_modification_method_code
- STD-PRODUCT_LO-001
default
- productRPK
- 57896-ALT
- campaignRPK
- P13010-ALT
- locationRPK
- 550-ALT
- state
- DELETE-ALT
- Displays
- Checkout-ALT
- Features
- TV-ALT
- set_number
- 3
- campaign_price
- 6
- secondary_space
- True
- set_reward_quantity
- 3
- set_multiple_quantity
- 3
- set_price_modification_value
- 3
- set_price_modification_method_code
- ALT-PRODUCT_LO-002
default
- productRPK
- 57896-EDGE
- campaignRPK
- P13010-EDGE
- locationRPK
- 550-EDGE
- state
- DELETE-EDGE
- Displays
- Checkout-EDGE
- Features
- TV-EDGE
- set_number
- 5
- campaign_price
- 7
- secondary_space
- False
- set_reward_quantity
- 5
- set_multiple_quantity
- 5
- set_price_modification_value
- 5
- set_price_modification_method_code
- EDGE-PRODUCT_LO-003