online_sales_fact
This table describes all the items purchased through the online store front.
This table describes all the items purchased through the online store front.
| Column Name | Data Type | NULLs |
sale_date_key |
INTEGER | No |
ship_date_key |
INTEGER | No |
product_key |
INTEGER | No |
product_version |
INTEGER | No |
customer_key |
INTEGER | No |
call_center_key |
INTEGER | No |
online_page_key |
INTEGER | No |
shipping_key |
INTEGER | No |
warehouse_key |
INTEGER | No |
promotion_key |
INTEGER | No |
pos_transaction_number |
INTEGER | No |
sales_quantity |
INTEGER | Yes |
sales_dollar_amount |
FLOAT | Yes |
ship_dollar_amount |
FLOAT | Yes |
net_dollar_amount |
FLOAT | Yes |
cost_dollar_amount |
FLOAT | Yes |
gross_profit_dollar_amount |
FLOAT | Yes |
transaction_type |
VARCHAR(16) | Yes |