Sales

In Scope

Technical: 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(5)

Rules & Considerations(14)

Row Count

Field Mapping

Data Accuracy

Daily Sales Quantity

Weekly Sales Quantity

Sample Load Data(5)

_scenario	dateR	timeR	locationR	receipt_codeR	receipt_timestampR	value	product	discount	quantity	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	STORE123	STD-SALES-001	2020-02-20T20:02:20+02:00	15	123456	0	-3	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	2020-12-16	13:30:00-ALT	STORE123-ALT	ALT-SALES-002	2020-02-20T20:02:20+02:00-ALT	16	123456-ALT	1	-2	MARKDOWN_SALE-ALT	3	ALT-SALES-002	ALT-SALES-002	ALT-SALES-002	Self-service-ALT	2020-02-20T20:02:20+02:00-ALT	1900-01-10-ALT	1	Markdown-ALT	Home delivery-ALT	ALT-SALES-002	1	1235	18	18	Platinum-ALT	ALT-SALES-002	ALT-SALES-002	21	9
default	2020-12-17	13:30:00-EDGE	STORE123-EDGE	EDGE-SALES-003	2020-02-20T20:02:20+02:00-EDGE	17	123456-EDGE	2	-1	MARKDOWN_SALE-EDGE	4	EDGE-SALES-003	EDGE-SALES-003	EDGE-SALES-003	Self-service-EDGE	2020-02-20T20:02:20+02:00-EDGE	1900-01-10-EDGE	2	Markdown-EDGE	Home delivery-EDGE	EDGE-SALES-003	2	1236	19	19	Platinum-EDGE	EDGE-SALES-003	EDGE-SALES-003	22	10

default

dateR: 2020-12-15
timeR: 13:30:00
locationR: STORE123
receipt_codeR: STD-SALES-001
receipt_timestampR: 2020-02-20T20:02:20+02:00
value: 15
product: 123456
discount: 0
quantity: -3
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

default

dateR: 2020-12-16
timeR: 13:30:00-ALT
locationR: STORE123-ALT
receipt_codeR: ALT-SALES-002
receipt_timestampR: 2020-02-20T20:02:20+02:00-ALT
value: 16
product: 123456-ALT
discount: 1
quantity: -2
order_type: MARKDOWN_SALE-ALT
tax_amount: 3
partner_code: ALT-SALES-002
campaign_code: ALT-SALES-002
checkout_code: ALT-SALES-002
checkout_type: Self-service-ALT
row_timestamp: 2020-02-20T20:02:20+02:00-ALT
purchase_price: 1900-01-10-ALT
sales_tax_rate: 1
discount_reason: Markdown-ALT
fulfillment_type: Home delivery-ALT
delivery_zip_code: ALT-SALES-002
promotion_discount: 1
receipt_row_number: 1235
original_sales_value: 18
sales_value_with_tax: 18
loyalty_customer_type: Platinum-ALT
loyalty_customer_zip_code: ALT-SALES-002
transaction_campaign_code: ALT-SALES-002
original_sales_value_with_tax: 21
transaction_promotion_discount: 9

default

dateR: 2020-12-17
timeR: 13:30:00-EDGE
locationR: STORE123-EDGE
receipt_codeR: EDGE-SALES-003
receipt_timestampR: 2020-02-20T20:02:20+02:00-EDGE
value: 17
product: 123456-EDGE
discount: 2
quantity: -1
order_type: MARKDOWN_SALE-EDGE
tax_amount: 4
partner_code: EDGE-SALES-003
campaign_code: EDGE-SALES-003
checkout_code: EDGE-SALES-003
checkout_type: Self-service-EDGE
row_timestamp: 2020-02-20T20:02:20+02:00-EDGE
purchase_price: 1900-01-10-EDGE
sales_tax_rate: 2
discount_reason: Markdown-EDGE
fulfillment_type: Home delivery-EDGE
delivery_zip_code: EDGE-SALES-003
promotion_discount: 2
receipt_row_number: 1236
original_sales_value: 19
sales_value_with_tax: 19
loyalty_customer_type: Platinum-EDGE
loyalty_customer_zip_code: EDGE-SALES-003
transaction_campaign_code: EDGE-SALES-003
original_sales_value_with_tax: 22
transaction_promotion_discount: 10