# Loyalty Member Currency DMO

How a member of a loyalty program has chosen to receive value within the program. For example as airline miles, or as points that can be used to redeem other types of awards.

## Object Properties

**Object API Name:** `ssot__LoyaltyMemberCurrency__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](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-loyaltyprogrammemberdmo-dmo.md) `Id` field.
- **LoyaltyMemberTierId** has a FOREIGNKEY relationship with the [Loyalty Member Tier DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-loyaltymembertierdmo-dmo.md) `Id` field.
- **CurrencyTypeId** has a FOREIGNKEY relationship with the [Loyalty Program Currency DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-loyaltyprogramcurrencydmo-dmo.md) `Id` field.
- **LoyaltyProgramCurrencyId** has a FOREIGNKEY relationship with the [Loyalty Program Currency DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-loyaltyprogramcurrencydmo-dmo.md) `Id` field.

## Fields

- [cdp_sys_record_currency](#cdp_sys_record_currency)
- [CreatedDate](#createddate)
- [CurrencyTypeId](#currencytypeid)
- [DataSourceId](#datasourceid)
- [DataSourceObjectId](#datasourceobjectid)
- [ExpirablePointsNumber](#expirablepointsnumber)
- [ExternalRecordId](#externalrecordid)
- [ExternalSourceId](#externalsourceid)
- [Id](#id)
- [InternalOrganizationId](#internalorganizationid)
- [KQ_CurrencyTypeId](#kq_currencytypeid)
- [KQ_Id](#kq_id)
- [KQ_LoyaltyMemberTierId](#kq_loyaltymembertierid)
- [KQ_LoyaltyProgramCurrencyId](#kq_loyaltyprogramcurrencyid)
- [KQ_LoyaltyProgramMemberId](#kq_loyaltyprogrammemberid)
- [LastAccrualProcessedDate](#lastaccrualprocesseddate)
- [LastEscrowProcessedDateTime](#lastescrowprocesseddatetime)
- [LastExpirationProcessRunDate](#lastexpirationprocessrundate)
- [LastModifiedDate](#lastmodifieddate)
- [LastPointsAggregationDateTime](#lastpointsaggregationdatetime)
- [LastResetDate](#lastresetdate)
- [LoyaltyMemberTierId](#loyaltymembertierid)
- [LoyaltyProgramCurrencyId](#loyaltyprogramcurrencyid)
- [LoyaltyProgramMemberId](#loyaltyprogrammemberid)
- [Name](#name)
- [NextResetDate](#nextresetdate)
- [PointsBalanceBeforeResetNumber](#pointsbalancebeforeresetnumber)
- [PointsBalanceNumber](#pointsbalancenumber)
- [PointsBalBeforeSecondLastReset](#pointsbalbeforesecondlastreset)
- [RedemStlPendFromDateTime](#redemstlpendfromdatetime)
- [TotalEscrowAccruedPointsNumber](#totalescrowaccruedpointsnumber)
- [TotalEscrowRolloverPointsNumber](#totalescrowrolloverpointsnumber)
- [TotalPointsAccruedNumber](#totalpointsaccruednumber)
- [TotalPointsExpiredNumber](#totalpointsexpirednumber)
- [TotalPointsRedeemedNumber](#totalpointsredeemednumber)

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

### CreatedDate

- **Field API Name:** `ssot__CreatedDate__c`
- **Data Type:** DATETIME
- **Description:** The date and time the record was originally created.

### CurrencyTypeId

- **Field API Name:** `ssot__CurrencyTypeId__c`
- **Data Type:** TEXT
- **Description:** Ways of accruing value in a Loyalty Program, for example Miles, Points or a nationial currency such as US dollars.

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

### ExpirablePointsNumber

- **Field API Name:** `ssot__ExpirablePointsNumber__c`
- **Data Type:** DOUBLE
- **Description:** The points that would have expired if the member had not done any redemptions.

### ExternalRecordId

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

### ExternalSourceId

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

### Id

- **Field API Name:** `ssot__Id__c`
- **Data Type:** TEXT
- **Description:** Required. A unique, system-generated identifier for this LoyaltyMemberCurrency record. Maximum size is 36 characters.

### InternalOrganizationId

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

### KQ_CurrencyTypeId

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

### KQ_Id

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

### KQ_LoyaltyMemberTierId

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

### KQ_LoyaltyProgramCurrencyId

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

### KQ_LoyaltyProgramMemberId

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

### LastAccrualProcessedDate

- **Field API Name:** `ssot__LastAccrualProcessedDate__c`
- **Data Type:** DATETIME
- **Description:** The date point accrual process was last run.

### LastEscrowProcessedDateTime

- **Field API Name:** `ssot__LastEscrowProcessedDateTime__c`
- **Data Type:** DATETIME
- **Description:** This field indicates the datetime at which the Escrow job has last run.

### LastExpirationProcessRunDate

- **Field API Name:** `ssot__LastExpirationProcessRunDate__c`
- **Data Type:** DATETIME
- **Description:** The date is used to calculate expirable points.

### LastModifiedDate

- **Field API Name:** `ssot__LastModifiedDate__c`
- **Data Type:** DATETIME
- **Description:** The date and time of the last modification to this record.

### LastPointsAggregationDateTime

- **Field API Name:** `ssot__LastPointsAggregationDateTime__c`
- **Data Type:** DATETIME
- **Description:** The date on which the member's fixed type non-qualifying points were last aggregated.

### LastResetDate

- **Field API Name:** `ssot__LastResetDate__c`
- **Data Type:** DATETIME
- **Description:** The date on which points were last changed to a baseline value for the accural period.

### LoyaltyMemberTierId

- **Field API Name:** `ssot__LoyaltyMemberTierId__c`
- **Data Type:** TEXT
- **Description:** The benefit tier within the program to which a member is assigned.

### LoyaltyProgramCurrencyId

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

### LoyaltyProgramMemberId

- **Field API Name:** `ssot__LoyaltyProgramMemberId__c`
- **Data Type:** TEXT
- **Description:** A person who has joined a Loyalty Program.

### Name

- **Field API Name:** `ssot__Name__c`
- **Data Type:** TEXT
- **Description:** Name of a Loyalty Member Currency.

### NextResetDate

- **Field API Name:** `ssot__NextResetDate__c`
- **Data Type:** DATETIME
- **Description:** The next date on which points are changed to a baseline value for the accural period.

### PointsBalanceBeforeResetNumber

- **Field API Name:** `ssot__PointsBalanceBeforeResetNumber__c`
- **Data Type:** DOUBLE
- **Description:** How many points the member had before it was reset.

### PointsBalanceNumber

- **Field API Name:** `ssot__PointsBalanceNumber__c`
- **Data Type:** DOUBLE
- **Description:** The current number of points available for redemption.

### PointsBalBeforeSecondLastReset

- **Field API Name:** `ssot__PointsBalBeforeSecondLastReset__c`
- **Data Type:** DOUBLE
- **Description:** The points balance before the second to last points reset of the member's associated qualifying currency.

### RedemStlPendFromDateTime

- **Field API Name:** `ssot__RedemStlPendFromDateTime__c`
- **Data Type:** DATETIME
- **Description:** The date and time from when the redemption settlement is pending.

### TotalEscrowAccruedPointsNumber

- **Field API Name:** `ssot__TotalEscrowAccruedPointsNumber__c`
- **Data Type:** DOUBLE
- **Description:** The total number of escrow points that are accrued.

### TotalEscrowRolloverPointsNumber

- **Field API Name:** `ssot__TotalEscrowRolloverPointsNumber__c`
- **Data Type:** DOUBLE
- **Description:** The total number of escrow points that are already credited to the points balance until the current date.

### TotalPointsAccruedNumber

- **Field API Name:** `ssot__TotalPointsAccruedNumber__c`
- **Data Type:** DOUBLE
- **Description:** The total number of points accrued in the program. Expired and redeemed points are included.

### TotalPointsExpiredNumber

- **Field API Name:** `ssot__TotalPointsExpiredNumber__c`
- **Data Type:** DOUBLE
- **Description:** The number of member points that have expired.

### TotalPointsRedeemedNumber

- **Field API Name:** `ssot__TotalPointsRedeemedNumber__c`
- **Data Type:** DOUBLE
- **Description:** The number of points that the member has redeemed.