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 Id field.
• SiteId has a FOREIGNKEY relationship with the Cc Dim Site DMO Id field.
• SourceCodeGroupId has a FOREIGNKEY relationship with the Cc Dim Source Code Group DMO Id field.

Fields

• BusinessChannelId
• cdp_sys_record_currency
• DataSourceId
• DataSourceObjectId
• DeviceClassCode
• InternalOrganizationId
• IsFirstTimeBuyer
• IsRegistered
• KQ_BusinessChannelId
• KQ_SiteId
• KQ_SourceCodeGroupId
• NumberOfOrders
• NumberOfUnits
• SiteId
• SourceCodeGroupId
• SourceCodeStatus
• StandardRevenue
• 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.