Cc Fact Customer List Snapshot DMO

This DMO contains customer list snapshot fact data from ccdw_fact_customer_list_snapshot. Each record represents a snapshot of customer list metrics at a point in time.

Object Properties

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

Relationships

• UtcRecordDayId has a FOREIGNKEY relationship with the Cc Dim Date DMO Id field.
• UtcRecordTimeId has a FOREIGNKEY relationship with the Cc Dim Time DMO Id field.
• StandardRecordDayId has a FOREIGNKEY relationship with the Cc Dim Date DMO Id field.
• StandardRecordTimeId has a FOREIGNKEY relationship with the Cc Dim Time DMO Id field.
• StandardRecordTimeZoneId has a FOREIGNKEY relationship with the Cc Dim Time Zone DMO Id field.
• SiteId has a FOREIGNKEY relationship with the Cc Dim Site DMO Id field.

Fields

• cdp_sys_record_currency
• DataSourceId
• DataSourceObjectId
• Id
• InternalOrganizationId
• KQ_Id
• KQ_SiteId
• KQ_StandardRecordDayId
• KQ_StandardRecordTimeId
• KQ_StandardRecordTimeZoneId
• KQ_UtcRecordDayId
• KQ_UtcRecordTimeId
• NaturalCustomerListIdentifier
• NumberOfCustomers
• SiteId
• StandardRecordDayId
• StandardRecordTimeId
• StandardRecordTimestamp
• StandardRecordTimeZoneId
• UtcRecordDayId
• UtcRecordTimeId
• UtcRecordTimestamp
• UtcUpdateTimestamp

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.

Id

• Field API Name: Id__c
• Data Type: DOUBLE
• Description: Unique identifier for a customer list snapshot record.

InternalOrganizationId

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

KQ_Id

• Field API Name: KQ_Id__c
• Data Type: TEXT
• Description: Key Qualifier system field for Id

KQ_SiteId

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

KQ_StandardRecordDayId

• Field API Name: KQ_StandardRecordDayId__c
• Data Type: TEXT
• Description: Key Qualifier system field for StandardRecordDayId

KQ_StandardRecordTimeId

• Field API Name: KQ_StandardRecordTimeId__c
• Data Type: TEXT
• Description: Key Qualifier system field for StandardRecordTimeId

KQ_StandardRecordTimeZoneId

• Field API Name: KQ_StandardRecordTimeZoneId__c
• Data Type: TEXT
• Description: Key Qualifier system field for StandardRecordTimeZoneId

KQ_UtcRecordDayId

• Field API Name: KQ_UtcRecordDayId__c
• Data Type: TEXT
• Description: Key Qualifier system field for UtcRecordDayId

KQ_UtcRecordTimeId

• Field API Name: KQ_UtcRecordTimeId__c
• Data Type: TEXT
• Description: Key Qualifier system field for UtcRecordTimeId

NaturalCustomerListIdentifier

• Field API Name: NaturalCustomerListIdentifier__c
• Data Type: TEXT
• Description: Normalized customer list identifier.

NumberOfCustomers

• Field API Name: NumberOfCustomers__c
• Data Type: DOUBLE
• Description: Total number of registered customers at the time of snapshot.

SiteId

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

StandardRecordDayId

• Field API Name: StandardRecordDayId__c
• Data Type: DOUBLE
• Description: Foreign key to ccdw_dim_date for the standard record day.

StandardRecordTimeId

• Field API Name: StandardRecordTimeId__c
• Data Type: DOUBLE
• Description: Foreign key to ccdw_dim_time for the standard record time.

StandardRecordTimestamp

• Field API Name: StandardRecordTimestamp__c
• Data Type: DATETIME
• Description: Timestamp of the snapshot, in standard time.

StandardRecordTimeZoneId

• Field API Name: StandardRecordTimeZoneId__c
• Data Type: DOUBLE
• Description: Foreign key to ccdw_dim_timezone for the standard record time zone.

UtcRecordDayId

• Field API Name: UtcRecordDayId__c
• Data Type: DOUBLE
• Description: Foreign key to ccdw_dim_date for the UTC record day.

UtcRecordTimeId

• Field API Name: UtcRecordTimeId__c
• Data Type: DOUBLE
• Description: Foreign key to ccdw_dim_time for the UTC record time.

UtcRecordTimestamp

• Field API Name: UtcRecordTimestamp__c
• Data Type: DATETIME
• Description: UTC timestamp of the snapshot.

UtcUpdateTimestamp

• Field API Name: UtcUpdateTimestamp__c
• Data Type: DATETIME
• Description: Last modified UTC timestamp of this record.