--- schema_version: "1" id: 80110ad69772610f1341b7bee5bbcdb790910d4ce149be54d48f9ed9cf9086e7 title: ccdw_aggr_payment_sales_summary 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_aggr_payment_sales_summary.md canonical_url: https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_aggr_payment_sales_summary.html source_site: developer.salesforce.com content_type: documentation content_hash: 94742da07d976d6578599431dd6a10c380315b5aa151e7f53da271bf1f75c452 products: - Composable Storefront - Salesforce APIs --- # ccdw_aggr_payment_sales_summary This table summarizes payment-related sales metrics by various dimensions. | Column Alias | Data Type | Key | Description | Index? | | ------------------------ | --------- | ------ | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------ | | `submit_date` | DATE | | Date of the sales submission. | 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 | | `registered` | BOOLEAN | | Boolean indicating if the customer was registered. | 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). | Yes | | `first_time_buyer` | BOOLEAN | | Boolean indicating if the customer was a first-time buyer across any site in the realm. Includes orders placed in sessions with tracking disabled (dw_dnt = 1) where buyer status cannot be established | Yes | | `first_time_buyer` | BOOLEAN | | Boolean indicating if the customer was a first-time buyer across any site in the realm. Includes orders placed in sessions with tracking disabled (dw_dnt = 1) where buyer status cannot be established. | Yes | | `locale_code` | VARCHAR | | Locale code from [`ccdw_dim_locale`](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_dim_locale.md). | Yes | | `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 | | `num_payments` | INTEGER | | Total number of payments. | No | | `num_orders` | INTEGER | | Total number of orders associated with payments. | No | | `std_captured_amount` | NUMERIC | | Total captured amount in standard currency. | No | | `std_refunded_amount` | NUMERIC | | Total refunded amount in standard currency. | No | | `std_transaction_amount` | NUMERIC | | Total transaction amount in standard currency. | No |