store_orders_fact
This table contains information about all orders made at the company’s brick-and-mortar stores.
This table contains information about all orders made at the company’s brick-and-mortar stores.
| Column Name | Data Type | NULLs |
product_key |
INTEGER | No |
product_version |
INTEGER | No |
store_key |
INTEGER | No |
vendor_key |
INTEGER | No |
employee_key |
INTEGER | No |
order_number |
INTEGER | No |
date_ordered |
DATE | Yes |
date_shipped |
DATE | Yes |
expected_delivery_date |
DATE | Yes |
date_delivered |
DATE | Yes |
quantity_ordered |
INTEGER | Yes |
quantity_delivered |
INTEGER | Yes |
shipper_name |
VARCHAR(32) | Yes |
unit_price |
INTEGER | Yes |
shipping_cost |
INTEGER | Yes |
total_order_cost |
INTEGER | Yes |
quantity_in_stock |
INTEGER | Yes |
reorder_level |
INTEGER | Yes |
overstock_ceiling |
INTEGER | Yes |