Sales
In ScopeTechnical: sales | ID: RELEX-RA-SALES
Forecast calculation.
See how this object fits into Sales Demand
Review the broader sequencing and dependencies for this domain
Migration Details
- Complexity
- High
- Sequencing
- Stage 2 - Demand Signals
- Typical Sources
- ERPLegacy
Target Structure
- Load Approach
- Table
- Target Objects
- pos_transactions
This object has high complexity or dependency level
Review sequencing requirements before loading
Field Definitions(30)
Rules & Considerations(14)
Row Count
Field Mapping
Sample Load Data(5)
| _scenario | dateR | timeR | productR | locationR | quantityR | receipt_codeR | receipt_timestampR | value | discount | order_type | tax_amount | partner_code | campaign_code | checkout_code | checkout_type | row_timestamp | purchase_price | sales_tax_rate | discount_reason | fulfillment_type | delivery_zip_code | promotion_discount | receipt_row_number | original_sales_value | sales_value_with_tax | loyalty_customer_type | loyalty_customer_zip_code | transaction_campaign_code | original_sales_value_with_tax | transaction_promotion_discount |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 2020-12-15 | 13:30:00 | 123456 | STORE123 | -3 | STD-SALES-001 | 2020-02-20T20:02:20+02:00 | 15 | 0 | MARKDOWN_SALE | 2 | STD-SALES-001 | STD-SALES-001 | STD-SALES-001 | Self-service | 2020-02-20T20:02:20+02:00 | 1900-01-10 | 0 | Markdown | Home delivery | STD-SALES-001 | 0 | 1234 | 17 | 17 | Platinum | STD-SALES-001 | STD-SALES-001 | 20 | 8 |
default
- dateR
- 2020-12-15
- timeR
- 13:30:00
- productR
- 123456
- locationR
- STORE123
- quantityR
- -3
- receipt_codeR
- STD-SALES-001
- receipt_timestampR
- 2020-02-20T20:02:20+02:00
- value
- 15
- discount
- 0
- order_type
- MARKDOWN_SALE
- tax_amount
- 2
- partner_code
- STD-SALES-001
- campaign_code
- STD-SALES-001
- checkout_code
- STD-SALES-001
- checkout_type
- Self-service
- row_timestamp
- 2020-02-20T20:02:20+02:00
- purchase_price
- 1900-01-10
- sales_tax_rate
- 0
- discount_reason
- Markdown
- fulfillment_type
- Home delivery
- delivery_zip_code
- STD-SALES-001
- promotion_discount
- 0
- receipt_row_number
- 1234
- original_sales_value
- 17
- sales_value_with_tax
- 17
- loyalty_customer_type
- Platinum
- loyalty_customer_zip_code
- STD-SALES-001
- transaction_campaign_code
- STD-SALES-001
- original_sales_value_with_tax
- 20
- transaction_promotion_discount
- 8