# 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`](/docs/commerce/b2c-commerce/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`](/docs/commerce/b2c-commerce/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`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_user_agent.md).                                                                                          | No     |
| `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     |
| `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     |