# Cc Aggr Source Code Sales DMO

This DMO aggregates source code sales data by date, business channel, site, and source code group.

## Object Properties

**Object API Name:** `CcAggrSourceCodeSales_std__dlm`\
**Category:** Unassigned\
**Availability:** Available in 260 and later versions\
**Primary Key Field:** SiteId

## Relationships

- **BusinessChannelId** has a FOREIGNKEY relationship with the [Cc Dim Business Channel DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-ccdimbusinesschanneldmo-dmo.md) `Id` field.
- **SiteId** has a FOREIGNKEY relationship with the [Cc Dim Site DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-ccdimsitedmo-dmo.md) `Id` field.
- **SourceCodeGroupId** has a FOREIGNKEY relationship with the [Cc Dim Source Code Group DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-ccdimsourcecodegroupdmo-dmo.md) `Id` field.

## Fields

- [BusinessChannelId](#businesschannelid)
- [cdp_sys_record_currency](#cdp_sys_record_currency)
- [DataSourceId](#datasourceid)
- [DataSourceObjectId](#datasourceobjectid)
- [DeviceClassCode](#deviceclasscode)
- [InternalOrganizationId](#internalorganizationid)
- [IsFirstTimeBuyer](#isfirsttimebuyer)
- [IsRegistered](#isregistered)
- [KQ_BusinessChannelId](#kq_businesschannelid)
- [KQ_SiteId](#kq_siteid)
- [KQ_SourceCodeGroupId](#kq_sourcecodegroupid)
- [NumberOfOrders](#numberoforders)
- [NumberOfUnits](#numberofunits)
- [SiteId](#siteid)
- [SourceCodeGroupId](#sourcecodegroupid)
- [SourceCodeStatus](#sourcecodestatus)
- [StandardRevenue](#standardrevenue)
- [SubmitDate](#submitdate)

### BusinessChannelId

- **Field API Name:** `BusinessChannelId__c`
- **Data Type:** DOUBLE
- **Description:** Foreign key to ccdw_dim_business_channel.

### cdp_sys_record_currency

- **Field API Name:** `cdp_sys_record_currency__c`
- **Data Type:** TEXT
- **Description:** System-generated metadata field that stores a 3-letter ISO currency code.

### DataSourceId

- **Field API Name:** `DataSourceId__c`
- **Data Type:** TEXT
- **Description:** A unique, system-generated identifier for this record.

### DataSourceObjectId

- **Field API Name:** `DataSourceObjectId__c`
- **Data Type:** TEXT
- **Description:** A unique, system-generated identifier for this record.

### DeviceClassCode

- **Field API Name:** `DeviceClassCode__c`
- **Data Type:** TEXT
- **Description:** Code for the device classification.

### InternalOrganizationId

- **Field API Name:** `InternalOrganizationId__c`
- **Data Type:** TEXT
- **Description:** A unique, system-generated identifier for this record.

### IsFirstTimeBuyer

- **Field API Name:** `IsFirstTimeBuyer__c`
- **Data Type:** BOOLEAN
- **Description:** Boolean indicating if the customer was a first-time buyer.

### IsRegistered

- **Field API Name:** `IsRegistered__c`
- **Data Type:** BOOLEAN
- **Description:** Boolean indicating if the customer was registered.

### KQ_BusinessChannelId

- **Field API Name:** `KQ_BusinessChannelId__c`
- **Data Type:** TEXT
- **Description:** Key Qualifier system field for BusinessChannelId

### KQ_SiteId

- **Field API Name:** `KQ_SiteId__c`
- **Data Type:** TEXT
- **Description:** Key Qualifier system field for SiteId

### KQ_SourceCodeGroupId

- **Field API Name:** `KQ_SourceCodeGroupId__c`
- **Data Type:** TEXT
- **Description:** Key Qualifier system field for SourceCodeGroupId

### NumberOfOrders

- **Field API Name:** `NumberOfOrders__c`
- **Data Type:** DOUBLE
- **Description:** Total number of orders attributed to the source code.

### NumberOfUnits

- **Field API Name:** `NumberOfUnits__c`
- **Data Type:** DOUBLE
- **Description:** Total number of units sold attributed to the source code.

### SiteId

- **Field API Name:** `SiteId__c`
- **Data Type:** DOUBLE
- **Description:** Foreign key to ccdw_dim_site.

### SourceCodeGroupId

- **Field API Name:** `SourceCodeGroupId__c`
- **Data Type:** DOUBLE
- **Description:** Foreign key to ccdw_dim_source_code_group.

### SourceCodeStatus

- **Field API Name:** `SourceCodeStatus__c`
- **Data Type:** TEXT
- **Description:** Status of the source code.

### StandardRevenue

- **Field API Name:** `StandardRevenue__c`
- **Data Type:** DOUBLE
- **Description:** Total revenue in standard currency attributed to the source code.

### SubmitDate

- **Field API Name:** `SubmitDate__c`
- **Data Type:** DATEONLY
- **Description:** Date of the sales submission.