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 API Name: std__CcFactCustomerListSnapshotDmo__dlm
Category: Unassigned
Availability: Available in 260 and later versions
Primary Key Field: Id

• 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.

• cdp_sys_record_currency
• DataSourceId
• DataSourceObjectId
• Id
• InternalOrganizationId
• NaturalCustomerListIdentifier
• NumberOfCustomers
• SiteId
• StandardRecordDayId
• StandardRecordTimeId
• StandardRecordTimestamp
• StandardRecordTimeZoneId
• UtcRecordDayId
• UtcRecordTimeId
• UtcRecordTimestamp
• UtcUpdateTimestamp

• 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__Id__c
• Data Type: DOUBLE
• Description: Unique identifier for a customer list snapshot record.

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

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

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

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

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

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

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

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

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

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

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

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