Cc Aggr Payment Sales Summary DMO

This DMO aggregates payment sales summary data by site, business channel, payment method, and other dimensions.

Object API Name: CcAggrPaymentSalesSummary_std__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.
• PaymentMethodId has a FOREIGNKEY relationship with the Cc Dim Payment Method DMO Id field.

• BusinessChannelId
• cdp_sys_record_currency
• DataSourceId
• DataSourceObjectId
• DeviceClassCode
• InternalOrganizationId
• IsFirstTimeBuyer
• IsRegistered
• KQ_BusinessChannelId
• KQ_PaymentMethodId
• KQ_SiteId
• LocaleCode
• NumberOfOrders
• NumberOfPayments
• PaymentMethodId
• SiteId
• StandardCaptureAmount
• StandardRefundAmount
• StandardTransactionAmount
• SubmitDate

• 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_PaymentMethodId__c
• Data Type: TEXT
• Description: Key Qualifier system field for PaymentMethodId

• Field API Name: KQ_SiteId__c
• Data Type: TEXT
• Description: Key Qualifier system field for SiteId

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

• Field API Name: NumberOfOrders__c
• Data Type: DOUBLE
• Description: Total number of orders associated with payments.

• Field API Name: NumberOfPayments__c
• Data Type: DOUBLE
• Description: Total number of payments.

• Field API Name: PaymentMethodId__c
• Data Type: DOUBLE
• Description: Foreign key to ccdw_dim_payment_method.

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

• Field API Name: StandardCaptureAmount__c
• Data Type: DOUBLE
• Description: Total captured amount in standard currency.

• Field API Name: StandardRefundAmount__c
• Data Type: DOUBLE
• Description: Total refunded amount in standard currency.

• Field API Name: StandardTransactionAmount__c
• Data Type: DOUBLE
• Description: Total transaction amount in standard currency.

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