ABCDEF
1
2
Dataset name: Sales
3
Dataset description: Core dataset in project - the most granular sales data
4
Data granularity: Order-line (single item in the order)
5
Field nameDescription
6
Order line dimensions
7
order_line_idOrder line internat number
8
quantityItem (order line) quantity
9
unit_price_tax_inclGross unit price (tax included)
10
unit_price_tax_exclNet unit price (tax included)
11
unit_tax_valueAmount of tax in unit price
12
subtotal_tax_inclSubtotal gross value: quantity x unit price (amount before discounts, tax included)
13
subtotal_tax_exclSubtotal net value: quantity x unit price (amount before discounts, tax excluded)
14
subtotal_taxAmount of tax in subtotal value
15
item_discount_tax_inclItem level discount gross amount (tax included)
16
item_discount_tax_exclItem level discount net amount (tax excluded)
17
item_discount_taxAmount of tax in discount value
18
item_revenue_tax_inclTotal gross value (tax included): line subtotal - line discount
19
item_revenue_tax_exclTotal net value (tax excluded): line subtotal - line discount
20
item_tax_valueTotal tax amount for order line
21
unit_price_tax_incl_in_plnMulticurrency feautre - gross unit price (tax included) in unified currency
22
unit_price_tax_excl_in_plnMulticurrency feautre - net unit price (tax included) in unified currency
23
unit_tax_value_in_plnMulticurrency feautre - amount of tax in unit price in unified currency
24
subtotal_tax_incl_in_plnMulticurrency feautre - subtotal gross value: quantity x unit price (amount before discounts, tax included) in unified currency
25
subtotal_tax_excl_in_plnMulticurrency feautre - subtotal net value: quantity x unit price (amount before discounts, tax excluded) in unified currency
26
subtotal_tax_in_plnMulticurrency feautre - amount of tax in subtotal value in unified currency
27
item_discount_tax_incl_in_plnMulticurrency feautre - item level discount gross amount (tax included) in unified currency
28
item_discount_tax_excl_in_plnMulticurrency feautre - item level discount net amount (tax excluded) in unified currency
29
item_discount_tax_in_plnMulticurrency feautre - amount of tax in discount value in unified currency
30
item_revenue_tax_incl_in_plnMulticurrency feautre - total gross value (tax included): line subtotal - line discount in unified currency
31
item_revenue_tax_excl_in_plnMulticurrency feautre - total net value (tax excluded): line subtotal - line discount in unified currency
32
item_tax_value_in_plnMulticurrency feautre - total tax amount for order line in unified currency
33
Product-scoped dimensions
34
variant_idVariant identifiers: internal identifier in ERP/CRM
35
variant_nameVariant display name (from ERP / CRM)
36
variant_skuVariant identifiers: Stock Keeping Unit
37
variant_gtinVariant identifiers: Global Trade Item Number
38
variant_features__colorVariant sample features: color
39
variant_features__sizeVariant sample features: size
40
product_idProduct identifier (to which variant is assigned)
41
product_nameProduct display name (from ERP / CRM)
42
product_attributes__seriesProduct sample attribute: series
43
product_attributes__printProduct sample attribute: series
44
product_category_idProduct category identifier #1 (referenced category tree in ecommerce)
45
product_category_nameProduct category name #1 (referenced category tree in ecommerce)
46
product_category2_idProduct category identifier #2 (referenced category tree in ecommerce)
47
product_category2_nameProduct category name #2 (referenced category tree in ecommerce)
48
product_category3_idProduct category identifier #3 (referenced category tree in ecommerce)
49
product_category3_nameProduct category name #3 (referenced category tree in ecommerce)
50
Order-scoped dimensions
51
order_keyOrder key (unique identifier in data warehouse)
52
order_data_stream_idData stream from which the order is sent to DW
53
order_idOrder unique identifier in store (ERP /CRM, numeric format)
54
order_referenceOrder unique identifier in store (ERP /CRM, string format)
55
order_createdDate and time when order was created
56
order_updatedDate and time when order was last updated
57
order_cancelledDate and time when order was cancelled
58
order_deliveredDate and time when order was delivered
59
order_paidDate and time when order was paid
60
order_refundedDate and time when order was refunded
61
shipping_tax_inclShipping cost (tax included)
62
shipping_tax_exclShipping cost (tax excluded)
63
shipping_tax_incl_in_plnMulticurrency feautre - shipping cost (tax included) in unified currency
64
shipping_tax_excl_in_plnMulticurrency feautre - shipping cost (tax excluded) in unified currency
65
discount_tax_inclTotal discounts value applied to order (tax included)
66
discount_tax_exclTotal discounts value applied to order (tax excluded)
67
discount_tax_incl_in_plnMulticurrency feautre - total discounts value applied to order (tax included) in unified currency
68
discount_tax_excl_in_plnMulticurrency feautre - total discounts value applied to order (tax excluded) in unified currency
69
discount_codeDiscount code used in order (if applicable)
70
discount_metaAdditional data about discounts used in the order
71
currency_keyOrder currency as 2-digit ISO code
72
currencyOrder currency (display name)
73
status_keyOrder status unique identifier in data warehouse
74
status_idOrder state unique identifier in data source (store)
75
status_nameOrder state internal name in data source (store)
76
statusUnified order type from predefined types in data warehouse
77
status_descriptionOrder state description
78
status_is_validEquals 1 if order state is business valid (i.e. delivered, picked up)
79
payment_keyPayment type unique identifier in data warehouse
80
payment_idPayment type unique identifier in data source (store)
81
payment_namePayment type internal name in data source (store)
82
paymentUnified payment type from predefined types in data warehouse
83
payment_softwareSoftware provider for online payments (if applicable)
84
delivery_keyDelivery unique identifier in data warehouse
85
delivery_idDelivery method unique identifier in data source (store)
86
delivery_nameDelivery method internal name in data source (store)
87
deliveryUnified delivery method from predefined types in data warehouse
88
delivery_payment_typeDefault payment type assigned to delivery method
89
carrier_companyCarrier name (if applicable)
90
delivery_is_default_freeEquals 1 if delivery is free of charge by default
91
shipping_keyShipping details: location unique key in data warehouse
92
shipping_country_codeShipping details: country code reference key
93
shipping_postcodeShipping details: location postcode (typed by customer)
94
shipping_cityShipping details: location city (typed by customer)
95
shipping_zoneShipping details: location zone part (voivodeship, state etc.)
96
shipping_latitudeShipping details: location latitude
97
shipping_longitudeShipping details: location longitude
98
billing_keyBilling details: location unique key in data warehouse
99
billing_country_codeBilling details: country code reference key
100
billing_postcodeBilling details: location postcode (typed by customer)