--- schema_version: "1" id: 6dfee565aa4c76c49c441a7b71f4fa9396e85b1d87451a091417420d0b25d4c6 title: ccdw_fact_order_payments collection: developer version: current locale: en-us portal_url: https://docs.salesforce.com/developer/current/en-us/commerce-cloud/b2c-commerce/guides/jdbc/jdbc_ccdw_fact_order_payments.md canonical_url: https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_fact_order_payments.html source_site: developer.salesforce.com content_type: documentation content_hash: 994fc34417d81b2f39acd717bfef59a18ad351d0b51af5a8c25ea71385c48be4 products: - Composable Storefront - Salesforce APIs --- # 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`](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_dim_date.md) for the UTC submission day. | No | | `utc_submit_time_id` | SMALLINT | **FK** | Foreign key to [`ccdw_dim_time`](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/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`](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_dim_date.md) for the standard submission day. | Yes | | `std_submit_time_id` | SMALLINT | **FK** | Foreign key to [`ccdw_dim_time`](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_dim_time.md) for the standard submission time. | No | | `std_timezone_id` | SMALLINT | **FK** | Foreign key to [`ccdw_dim_timezone`](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_dim_timezone.md) for the standard time zone. | No | | `locale_id` | SMALLINT | **FK** | Foreign key to [`ccdw_dim_locale`](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_dim_locale.md). | Yes | | `site_id` | SMALLINT | **FK** | Foreign key to [`ccdw_dim_site`](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_dim_site.md) for the submission site. | Yes | | `business_channel_id` | SMALLINT | **FK** | Foreign key to [`ccdw_dim_business_channel`](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_dim_business_channel.md). | Yes | | `user_agent_id` | INTEGER | **FK** | Foreign key to [`ccdw_dim_user_agent`](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_dim_user_agent.md). | Yes | | `source_code_group_id` | INTEGER | **FK** | Foreign key to [`ccdw_dim_source_code_group`](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_dim_source_code_group.md). | No | | `payment_method_id` | SMALLINT | **FK** | Foreign key to [`ccdw_dim_payment_method`](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/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`](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/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`](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_dim_currency.md) for local currency. | No | | `std_currency_id` | SMALLINT | **FK** | Foreign key to [`ccdw_dim_currency`](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_dim_currency.md) for standard currency. | No | | `shipping_geography_id` | INTEGER | **FK** | Foreign key to [`ccdw_dim_geography`](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/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`](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/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`](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/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`](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/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 |