ccdw_fact_order_payments

This table records payment transactions for orders. Each row represents an order payment.

Column Alias	Data Type	Key	Description	Index?
`order_payment_id`	BIGINT	PK	Unique identifier for the order payment record.	Yes
`norder_id`	VARCHAR(50)		The natural key representing the order in the source system.	Yes
`utc_submit_timestamp`	TIMESTAMP		UTC timestamp when the payment was submitted.	No
`utc_submit_day_id`	SMALLINT	FK	Foreign key to `ccdw_dim_date` for the UTC submission day.	No
`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 payment was submitted, 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
`source_code_group_id`	INTEGER	FK	Foreign key to `ccdw_dim_source_code_group`.	No
`payment_method_id`	SMALLINT	FK	Foreign key to `ccdw_dim_payment_method`.	Yes
`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
`lcl_captured_amount`	NUMERIC		Captured amount in local currency.	No
`lcl_refunded_amount`	NUMERIC		Refunded amount in local currency.	No
`lcl_transaction_amount`	NUMERIC		Transaction amount in local currency.	No
`std_captured_amount`	NUMERIC		Captured amount in standard currency.	No
`std_refunded_amount`	NUMERIC		Refunded amount in standard currency.	No
`std_transaction_amount`	NUMERIC		Transaction amount in standard currency.	No