Cc Aggr Source Code Sales DMO

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

This is a standard data model object (DMO), which is created in your org only after you map it. Until it’s mapped, this DMO is visible on the data mapping screen but doesn’t appear in the Data Model list or record view in the Data 360 app. This is expected behavior. To use this DMO, search for it on the data mapping screen and complete the mapping. After it’s mapped, the DMO and its fields appear in the Data Model list.

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

  • Field API Name: BusinessChannelId__c
  • Data Type: DOUBLE
  • Description: Foreign key to ccdw_dim_business_channel.
  • Field API Name: cdp_sys_record_currency__c
  • Data Type: TEXT
  • Description: System-generated metadata field that stores a 3-letter ISO currency code.
  • Field API Name: DataSourceId__c
  • Data Type: TEXT
  • Description: A unique, system-generated identifier for this record.
  • Field API Name: DataSourceObjectId__c
  • Data Type: TEXT
  • Description: A unique, system-generated identifier for this record.
  • Field API Name: DeviceClassCode__c
  • Data Type: TEXT
  • Description: Code for the device classification.
  • Field API Name: InternalOrganizationId__c
  • Data Type: TEXT
  • Description: A unique, system-generated identifier for this record.
  • Field API Name: IsFirstTimeBuyer__c
  • Data Type: BOOLEAN
  • Description: Boolean indicating if the customer was a first-time buyer.
  • Field API Name: IsRegistered__c
  • Data Type: BOOLEAN
  • Description: Boolean indicating if the customer was registered.
  • Field API Name: KQ_BusinessChannelId__c
  • Data Type: TEXT
  • Description: Key Qualifier system field for BusinessChannelId
  • Field API Name: KQ_SiteId__c
  • Data Type: TEXT
  • Description: Key Qualifier system field for SiteId
  • Field API Name: KQ_SourceCodeGroupId__c
  • Data Type: TEXT
  • Description: Key Qualifier system field for SourceCodeGroupId
  • Field API Name: NumberOfOrders__c
  • Data Type: DOUBLE
  • Description: Total number of orders attributed to the source code.
  • Field API Name: NumberOfUnits__c
  • Data Type: DOUBLE
  • Description: Total number of units sold attributed to the source code.
  • Field API Name: SiteId__c
  • Data Type: DOUBLE
  • Description: Foreign key to ccdw_dim_site.
  • Field API Name: SourceCodeGroupId__c
  • Data Type: DOUBLE
  • Description: Foreign key to ccdw_dim_source_code_group.
  • Field API Name: SourceCodeStatus__c
  • Data Type: TEXT
  • Description: Status of the source code.
  • Field API Name: StandardRevenue__c
  • Data Type: DOUBLE
  • Description: Total revenue in standard currency attributed to the source code.
  • Field API Name: SubmitDate__c
  • Data Type: DATEONLY
  • Description: Date of the sales submission.