--- schema_version: "1" id: c954774b83d2c1d03c8aa0ece77a463828a4bea3bc9f289a4adfb93a973818c3 title: ccdw_aggr_source_code_sales 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_source_code_sales.md canonical_url: https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_aggr_source_code_sales.html source_site: developer.salesforce.com content_type: documentation content_hash: 7039d0c077a3eb12e1b866e71b6f4383394323286466af8b6abdf48934414b16 products: - Composable Storefront - Salesforce APIs --- # ccdw_aggr_source_code_sales This table summarizes sales attributed to source codes. | Column Alias | Data Type | Key | Description | Index? | | ---------------------- | --------- | ------ | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------ | | `submit_date` | DATE | | Date of the sales submission. | No | | `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). | No | | `registered` | BOOLEAN | | Boolean indicating if the customer was registered. | No | | `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). | No | | `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 | No | | `device_class_code` | VARCHAR | **FK** | Device class code from [`ccdw_dim_user_agent`](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_dim_user_agent.md). | No | | `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 | | `source_code_status` | VARCHAR | | Status of the source code. | No | | `num_orders` | INTEGER | | Total number of orders attributed to the source code. | No | | `num_units` | INTEGER | | Total number of units sold attributed to the source code. | No | | `std_revenue` | NUMERIC | | Total revenue in standard currency attributed to the source code. | No |