online_sales_fact

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