int PK_time_key

int hour

int minute

string bucket 15min

int PK_customer_key

string customer id hash

string segment

string city

string sex

string dob_flag

bool is_active

datetime effective_from

datetime effective_to

int PK_channel_key

string channel_name

string schema

int PK_product_key

string sku

string product_name

string brand

string category

bool is_active

datetime effective_from

datetime effective_to

int PK_payment_key

string method

string provider

string auth_result

int PK_date_key

string day_name

int day

int month

int quarter

int year

bool is_weekend

string fiscal_period

int PK_location_key

string store id

string store_name

string region

string city

string country

string geo_latlon

string tz

bool is_active

int PK_promo_key

string promo_name

string type

float discount_pct

float discount_amount

int PK_currency_key

string iso_code

string symbol

string name

int PK_sales_key

int FK_date_key

int FK_time_key

int FK_product_key

int FK_customer_key

int FK_channel_key

int FK_location_key

int FK_currency_key

int FK_payment_key

int FK_promo_key

float qty

float unit_price_cur

float unit_price_fx

float discount_amt

float tax_amt

float shipping_amt

float gross_amt_cur

float net_amt_cur

datetime loaded_at_utc

int PK_inventory_key

int FK_product_key

int FK_location_key

int FK_date_key

int FK_currency_key

float on_hand_qty

float received_qty

float available_qty

float inventory_value_cur

int PK_fxrate_key

int FK_date_key

int FK_currency_key

float rate_to_base

float rate_from_base