ccdw_fact_promotion_line_item

This table records the application of promotions to individual line items. Each row represents a promotion line item in an order.

Column Alias	Data Type	Key	Description	Index?
`promotion_line_item_id`	BIGINT	PK	Unique identifier for the promotion line item.	Yes
`promotion_id`	INTEGER	FK	Foreign key to `ccdw_dim_promotion`.	Yes
`sku_id`	INTEGER	FK	Foreign key to `ccdw_dim_product` for the SKU affected by the promotion.	Yes
`promotion_instance_id`	VARCHAR(50)		Unique key representing the usage/application of a promotion in an order.	No
`line_item_id`	BIGINT	FK	Foreign key to `ccdw_fact_line_item`.	No
`nline_item_id`	VARCHAR(50)		Normalized line item identifier.	No
`order_id`	BIGINT	FK	A surrogate key representing the order associated with the line item.	Yes
`norder_id`	VARCHAR(50)		The natural key representing the order in the source system.	No
`utc_submit_timestamp`	TIMESTAMP		UTC timestamp when the promotion was applied.	Yes
`utc_submit_day_id`	SMALLINT	FK	Foreign key to `ccdw_dim_date` for the UTC submission day.	Yes
`utc_submit_time_id`	SMALLINT	FK	Foreign key to `ccdw_dim_time` for the UTC submission time.	No
`utc_update_timestamp`	TIMESTAMP		Last modified UTC timestamp of this record.	Yes
`std_submit_timestamp`	TIMESTAMP		Timestamp when the promotion was applied, in standard time.	No
`std_submit_day_id`	SMALLINT	FK	Foreign key to `ccdw_dim_date` for the standard submission day.	Yes
`std_submit_time_id`	SMALLINT	FK	Foreign key to `ccdw_dim_time` for the standard submission time.	No
`std_timezone_id`	SMALLINT	FK	Foreign key to `ccdw_dim_timezone` for the standard time zone.	No
`locale_id`	SMALLINT	FK	Foreign key to `ccdw_dim_locale`.	Yes
`site_id`	SMALLINT	FK	Foreign key to `ccdw_dim_site` for the submission site.	Yes
`business_channel_id`	SMALLINT	FK	Foreign key to `ccdw_dim_business_channel`.	Yes
`user_agent_id`	INTEGER	FK	Foreign key to `ccdw_dim_user_agent`.	Yes
`campaign_id`	INTEGER	FK	Foreign key to `ccdw_dim_campaign`.	No
`source_code_group_id`	INTEGER	FK	Foreign key to `ccdw_dim_source_code_group`.	No
`visitor_id`	VARCHAR(100)		Unique key representing an ID of the visitor.	No
`customer_id`	BIGINT	FK	Foreign key to `ccdw_dim_customer`.	Yes
`lcl_currency_id`	SMALLINT	FK	Foreign key to `ccdw_dim_currency` for local currency.	No
`std_currency_id`	SMALLINT	FK	Foreign key to `ccdw_dim_currency` for standard currency.	No
`shipping_geography_id`	INTEGER	FK	Foreign key to `ccdw_dim_geography` for shipping location.	No
`invoice_geography_id`	INTEGER	FK	Foreign key to `ccdw_dim_geography` for invoice location.	No
`customer_geography_id`	INTEGER	FK	Foreign key to `ccdw_dim_geography` for customer's address.	No
`quantity`	NUMERIC		The number of units of this line item that were purchased.	No
`lcl_li_promo_disc`	NUMERIC		The line item promotional discounts associated with the line item.	No
`lcl_li_promo_disc_order_alloc`	NUMERIC		The order level promotional discounts associated with the line item (pro-rated).	No
`lcl_li_promo_disc_ship_alloc`	NUMERIC		The line item shipping level promotional discounts associated with the line item (pro-rated).	No
`lcl_li_manual_disc`	NUMERIC		The line item manual discounts associated with the line item.	No
`lcl_li_manual_disc_order_alloc`	NUMERIC		The order level manual discounts associated with the line item (pro-rated).	No
`lcl_li_manual_disc_ship_alloc`	NUMERIC		The shipping level manual discounts associated with the line item (pro-rated).	No
`lcl_li_tax`	NUMERIC		The line item level tax.	No
`lcl_li_tax_order_alloc`	NUMERIC		The order level tax (pro-rated).	No
`lcl_li_shipping`	NUMERIC		The line item level shipping.	No
`lcl_li_shipping_order_alloc`	NUMERIC		The order level shipping (pro-rated).	No
`lcl_li_gross_merchandise_value`	NUMERIC		The gross merchandise value of the line item (in tendered currency).	No
`std_li_promo_disc`	NUMERIC		The line item promotional discounts associated with the line item.	No
`std_li_promo_disc_order_alloc`	NUMERIC		The order level promotional discounts associated with the line item (pro-rated).	No
`std_li_promo_disc_ship_alloc`	NUMERIC		The line item shipping level promotional discounts associated with the line item (pro-rated).	No
`std_li_manual_disc`	NUMERIC		The line item manual discounts associated with the line item.	No
`std_li_manual_disc_order_alloc`	NUMERIC		The order level manual discounts associated with the line item (pro-rated).	No
`std_li_manual_disc_ship_alloc`	NUMERIC		The shipping level manual discounts associated with the line item (pro-rated).	No
`std_li_tax`	NUMERIC		The line item level tax.	No
`std_li_tax_order_alloc`	NUMERIC		The order level tax (pro-rated).	No
`std_li_shipping`	NUMERIC		The line item level shipping.	No
`std_li_shipping_order_alloc`	NUMERIC		The order level shipping (pro-rated).	No
`std_li_gross_merchandise_value`	NUMERIC		The gross merchandise value of the line item as determined by the attribution of promotional GMV to promotions.	No