---
schema_version: "1"
id: e83445c364d7d0592f0a704adeafce17f542e3fb3704850ffe04405331fad0a8
title: Loyalty Aggr Point Expiration Ledger DMO
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/data-cloud/data-cloud-dmo-mapping/guides/std_dmos/c360dm-si-loyaltyaggregatedptexpirationledgerdmo-dmo.md
canonical_url: https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-loyaltyaggregatedptexpirationledgerdmo-dmo.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: 29070067c6dc382776b2536ea0e84120fc302676e098a6cd64b07979b3015798
products:
  - Data 360 DMO and Mapping Guide
  - Data 360 Developer Documentation
---
# Loyalty Aggr Point Expiration Ledger DMO

## Object Properties

**Object API Name:** `ssot__LoyaltyAggregatedPointExpirationLedger__dlm`  
**Category:** Unassigned  
**Availability:** Available in 254 and later versions  
**Primary Key Field:** Id  

## Relationships

- **LoyaltyProgramMemberId** has a FOREIGNKEY relationship with the [Loyalty Program Member DMO](https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-loyaltyprogrammemberdmo-dmo.md) `Id` field.


## Fields

- [cdp_sys_record_currency](#cdp_sys_record_currency)
- [DataSourceId](#datasourceid)
- [DataSourceObjectId](#datasourceobjectid)
- [ExpirationDate](#expirationdate)
- [ExpirationPointsNumber](#expirationpointsnumber)
- [Id](#id)
- [InternalOrganizationId](#internalorganizationid)
- [KQ_Id](#kq_id)
- [KQ_LoyaltyProgramMemberId](#kq_loyaltyprogrammemberid)
- [LoyaltyProgramCurrency](#loyaltyprogramcurrency)
- [LoyaltyProgramMemberId](#loyaltyprogrammemberid)
- [Name](#name)
- [PointsStatus](#pointsstatus)
- [RedeemedPointsNumber](#redeemedpointsnumber)

### cdp_sys_record_currency

- **Field API Name:** `ssot__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:** `ssot__DataSourceId__c`
- **Data Type:** TEXT
- **Description:** A unique, system-generated identifier for this record.

### DataSourceObjectId

- **Field API Name:** `ssot__DataSourceObjectId__c`
- **Data Type:** TEXT
- **Description:** A unique, system-generated identifier for this record.

### ExpirationDate

- **Field API Name:** `ssot__ExpirationDate__c`
- **Data Type:** DATETIME
- **Description:** The date and time of the expiration date.

### ExpirationPointsNumber

- **Field API Name:** `ssot__ExpirationPointsNumber__c`
- **Data Type:** DOUBLE
- **Description:** Numeric value representing the expiration points number. Do not include currency symbols or commas.

### Id

- **Field API Name:** `ssot__Id__c`
- **Data Type:** TEXT
- **Description:** A unique, system-generated identifier for this record.

### InternalOrganizationId

- **Field API Name:** `ssot__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_LoyaltyProgramMemberId

- **Field API Name:** `KQ_LoyaltyProgramMemberId__c`
- **Data Type:** TEXT
- **Description:** Key Qualifier system field for LoyaltyProgramMemberId

### LoyaltyProgramCurrency

- **Field API Name:** `ssot__LoyaltyProgramCurrency__c`
- **Data Type:** TEXT
- **Description:** Currency used within the loyalty program associated with the record.

### LoyaltyProgramMemberId

- **Field API Name:** `ssot__LoyaltyProgramMemberId__c`
- **Data Type:** TEXT
- **Description:** A unique, system-generated identifier for this record.

### Name

- **Field API Name:** `ssot__Name__c`
- **Data Type:** TEXT
- **Description:** The primary name or label for this record.

### PointsStatus

- **Field API Name:** `ssot__PointsStatus__c`
- **Data Type:** TEXT
- **Description:** Alphanumeric string representing the points status.

### RedeemedPointsNumber

- **Field API Name:** `ssot__RedeemedPointsNumber__c`
- **Data Type:** DOUBLE
- **Description:** Numeric value representing the redeemed points number. Do not include currency symbols or commas.