# 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`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_date.md) for the UTC submission day. | No | | `utc_submit_time_id` | SMALLINT | **FK** | Foreign key to [`ccdw_dim_time`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_time.md) 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`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_date.md) for the standard submission day. | Yes | | `std_submit_time_id` | SMALLINT | **FK** | Foreign key to [`ccdw_dim_time`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_time.md) for the standard submission time. | No | | `std_timezone_id` | SMALLINT | **FK** | Foreign key to [`ccdw_dim_timezone`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_timezone.md) for the standard time zone. | No | | `locale_id` | SMALLINT | **FK** | Foreign key to [`ccdw_dim_locale`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_locale.md). | Yes | | `site_id` | SMALLINT | **FK** | Foreign key to [`ccdw_dim_site`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_site.md) for the submission site. | Yes | | `business_channel_id` | SMALLINT | **FK** | Foreign key to [`ccdw_dim_business_channel`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_business_channel.md). | Yes | | `user_agent_id` | INTEGER | **FK** | Foreign key to [`ccdw_dim_user_agent`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_user_agent.md). | Yes | | `source_code_group_id` | INTEGER | **FK** | Foreign key to [`ccdw_dim_source_code_group`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_source_code_group.md). | No | | `payment_method_id` | SMALLINT | **FK** | Foreign key to [`ccdw_dim_payment_method`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_payment_method.md). | Yes | | `visitor_id` | VARCHAR(100) | | Unique identifier for a visitor session. This ID persists across sessions and is associated with an anonymous tracking cookie (for example, dwanonymous). | No | | `customer_id` | BIGINT | **FK** | Foreign key to [`ccdw_dim_customer`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_customer.md). For unregistered buyers, this value is `1` and can't distinguish one unregistered buyer from another. | Yes | | `buyer_email` | VARCHAR(256) | | Hashed email address of the buyer. If order was placed in session with tracking disabled (dw_dnt = 1) or shopper subsequently requested deletion of personal data, this will return `anonymous` | No | | `is_anonymous` | BOOLEAN | | Indicates whether customer is anonymous or registered. | No | | `do_not_track` | BOOLEAN | | Indicates whether the customer has opted out of tracking. | No | | `lcl_currency_id` | SMALLINT | **FK** | Foreign key to [`ccdw_dim_currency`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_currency.md) for local currency. | No | | `std_currency_id` | SMALLINT | **FK** | Foreign key to [`ccdw_dim_currency`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_currency.md) for standard currency. | No | | `shipping_geography_id` | INTEGER | **FK** | Foreign key to [`ccdw_dim_geography`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_geography.md) for the shipping address provided at checkout. Populated for orders placed after October 2024. | No | | `invoice_geography_id` | INTEGER | **FK** | Foreign key to [`ccdw_dim_geography`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_geography.md) for the billing or invoice address. Populated for orders placed after October 2024. | No | | `customer_geography_id` | INTEGER | **FK** | Foreign key to [`ccdw_dim_geography`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_geography.md) for the customer's profile address. Populated for registered customers only (orders placed after October 2024). | 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 | | `traffic_source_id` | SMALLINT | **FK** | Foreign key to [`ccdw_dim_traffic_source`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_traffic_source.md). Identifies the attributed external traffic source for this order. | No | | `traffic_campaign` | VARCHAR | | Campaign name associated with the attributed external traffic. | No | | `referer_net_loc` | VARCHAR | | Network location (hostname) of the referring site. | No | | `referer_term` | VARCHAR | | Search term from the referring site, when present. | No |