# 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`](/docs/commerce/b2c-commerce/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`](/docs/commerce/b2c-commerce/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`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_locale.md).                                                                                                         | Yes    |
| `payment_method_id`      | SMALLINT  | **FK** | Foreign key to [`ccdw_dim_payment_method`](/docs/commerce/b2c-commerce/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     |