Cc Aggr Sales Summary DMO

This DMO provides aggregate sales summary metrics by site, date, and customer attributes.

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

• SiteId has a FOREIGNKEY relationship with the Cc Dim Site DMO Id field.
• BusinessChannelId has a FOREIGNKEY relationship with the Cc Dim Business Channel DMO Id field.

• BusinessChannelId
• cdp_sys_record_currency
• DataSourceId
• DataSourceObjectId
• DeviceClassCode
• InternalOrganizationId
• IsFirstTimeBuyer
• IsRegistered
• IsShopperAgent
• LocaleCode
• NumberOfOrders
• NumberOfUnits
• SiteId
• StandardRevenue
• StandardShipping
• StandardTax
• StandardTotalDiscount
• StdManualOrderDiscount
• StdManualProductDiscount
• StdManualShippingDiscount
• StdPromoOrderDiscount
• StdPromoProductDiscount
• StdPromoShippingDiscount
• SubmitDate

• Field API Name: std__BusinessChannelId__c
• Data Type: DOUBLE
• Description: Foreign key to ccdw_dim_business_channel.

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

• Field API Name: std__DataSourceId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: std__DataSourceObjectId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: std__DeviceClassCode__c
• Data Type: TEXT
• Description: Code for the device classification.

• Field API Name: std__InternalOrganizationId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

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

• Field API Name: std__IsRegistered__c
• Data Type: BOOLEAN
• Description: Boolean indicating if the customer was registered.

• Field API Name: std__IsShopperAgent__c
• Data Type: BOOLEAN
• Description: Boolean indicating whether the activity was generated by a Shopper Agent.

• Field API Name: std__LocaleCode__c
• Data Type: TEXT
• Description: Abbreviated locale code.

• Field API Name: std__NumberOfOrders__c
• Data Type: DOUBLE
• Description: Total number of orders.

• Field API Name: std__NumberOfUnits__c
• Data Type: DOUBLE
• Description: Total number of units sold.

• Field API Name: std__SiteId__c
• Data Type: DOUBLE
• Description: Foreign key to ccdw_dim_site.

• Field API Name: std__StandardRevenue__c
• Data Type: DOUBLE
• Description: Total revenue in standard currency. Aggregated from std_li_gross_merchandise_value.

• Field API Name: std__StandardShipping__c
• Data Type: DOUBLE
• Description: Total shipping cost in standard currency.

• Field API Name: std__StandardTax__c
• Data Type: DOUBLE
• Description: Total tax in standard currency.

• Field API Name: std__StandardTotalDiscount__c
• Data Type: DOUBLE
• Description: Total discount in standard currency.

• Field API Name: std__StdManualOrderDiscount__c
• Data Type: DOUBLE
• Description: Manual discount applied at the order level in standard currency.

• Field API Name: std__StdManualProductDiscount__c
• Data Type: DOUBLE
• Description: Manual discount applied to products in standard currency.

• Field API Name: std__StdManualShippingDiscount__c
• Data Type: DOUBLE
• Description: Manual discount applied to shipping in standard currency.

• Field API Name: std__StdPromoOrderDiscount__c
• Data Type: DOUBLE
• Description: Promotional discount applied at the order level in standard currency.

• Field API Name: std__StdPromoProductDiscount__c
• Data Type: DOUBLE
• Description: Promotional discount applied to products in standard currency.

• Field API Name: std__StdPromoShippingDiscount__c
• Data Type: DOUBLE
• Description: Promotional discount applied to shipping in standard currency.

• Field API Name: std__SubmitDate__c
• Data Type: DATEONLY
• Description: Date of the sales submission.