# 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](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-ccdimdatedmo-dmo.md) `Id` field.
- **UtcRecordTimeId** has a FOREIGNKEY relationship with the [Cc Dim Time DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-ccdimtimedmo-dmo.md) `Id` field.
- **StandardRecordDayId** has a FOREIGNKEY relationship with the [Cc Dim Date DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-ccdimdatedmo-dmo.md) `Id` field.
- **StandardRecordTimeId** has a FOREIGNKEY relationship with the [Cc Dim Time DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-ccdimtimedmo-dmo.md) `Id` field.
- **StandardRecordTimeZoneId** has a FOREIGNKEY relationship with the [Cc Dim Time Zone DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-ccdimtimezonedmo-dmo.md) `Id` field.
- **SiteId** has a FOREIGNKEY relationship with the [Cc Dim Site DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-ccdimsitedmo-dmo.md) `Id` field.

## Fields

- [cdp_sys_record_currency](#cdp_sys_record_currency)
- [DataSourceId](#datasourceid)
- [DataSourceObjectId](#datasourceobjectid)
- [Id](#id)
- [InternalOrganizationId](#internalorganizationid)
- [KQ_Id](#kq_id)
- [KQ_SiteId](#kq_siteid)
- [KQ_StandardRecordDayId](#kq_standardrecorddayid)
- [KQ_StandardRecordTimeId](#kq_standardrecordtimeid)
- [KQ_StandardRecordTimeZoneId](#kq_standardrecordtimezoneid)
- [KQ_UtcRecordDayId](#kq_utcrecorddayid)
- [KQ_UtcRecordTimeId](#kq_utcrecordtimeid)
- [NaturalCustomerListIdentifier](#naturalcustomerlistidentifier)
- [NumberOfCustomers](#numberofcustomers)
- [SiteId](#siteid)
- [StandardRecordDayId](#standardrecorddayid)
- [StandardRecordTimeId](#standardrecordtimeid)
- [StandardRecordTimestamp](#standardrecordtimestamp)
- [StandardRecordTimeZoneId](#standardrecordtimezoneid)
- [UtcRecordDayId](#utcrecorddayid)
- [UtcRecordTimeId](#utcrecordtimeid)
- [UtcRecordTimestamp](#utcrecordtimestamp)
- [UtcUpdateTimestamp](#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.