store_sales_fact

This table contains information about all sales made at the company’s brick-and-mortar stores.

Column Name Data Type NULLs
date_key
INTEGER No
product_key
INTEGER No
product_version
INTEGER No
store_key
INTEGER No
promotion_key
INTEGER No
customer_key
INTEGER No
employee_key
INTEGER No
pos_transaction_number
INTEGER No
sales_quantity
INTEGER Yes
sales_dollar_amount
INTEGER Yes
cost_dollar_amount
INTEGER Yes
gross_profit_dollar_amount
INTEGER Yes
transaction_type
VARCHAR(16) Yes
transaction_time
TIME Yes
tender_type
VARCHAR(8) Yes