store_sales_fact
This table contains information about all sales made at the company’s brick-and-mortar stores.
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 |