# Loyalty Program Currency DMO

Mediums of exchange that are allowed within a Loyalty Program such as Points and Miles.

## Object Properties

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

## Relationships

- **LoyaltyTierGroupId** has a FOREIGNKEY relationship with the [Loyalty Tier Group DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-loyaltytiergroupdmo-dmo.md) `Id` field.
- **LoyaltyProgramId** has a FOREIGNKEY relationship with the [Loyalty Program DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-loyaltyprogramdmo-dmo.md) `Id` field.

## Fields

- [cdp_sys_record_currency](#cdp_sys_record_currency)
- [CreatedDate](#createddate)
- [CurrencyExpirationExtensionModelId](#currencyexpirationextensionmodelid)
- [CurrencyExpirationModelId](#currencyexpirationmodelid)
- [CurrencyTypeId](#currencytypeid)
- [DataSourceId](#datasourceid)
- [DataSourceObjectId](#datasourceobjectid)
- [DoesAllowLedgerTracing](#doesallowledgertracing)
- [DoesAllowNegativeBalance](#doesallownegativebalance)
- [ExpirationPeriodFrequencyNumber](#expirationperiodfrequencynumber)
- [ExpirationPeriodFrequencyTimeUOM](#expirationperiodfrequencytimeuom)
- [ExternalRecordId](#externalrecordid)
- [ExternalSourceId](#externalsourceid)
- [HasEscrow](#hasescrow)
- [Id](#id)
- [InternalOrganizationId](#internalorganizationid)
- [IsActive](#isactive)
- [IsPrimary](#isprimary)
- [KQ_Id](#kq_id)
- [KQ_LoyaltyProgramId](#kq_loyaltyprogramid)
- [KQ_LoyaltyTierGroupId](#kq_loyaltytiergroupid)
- [LastModifiedDate](#lastmodifieddate)
- [LoyaltyProgramId](#loyaltyprogramid)
- [LoyaltyTierGroupId](#loyaltytiergroupid)
- [Name](#name)
- [QualifyingPointEndDate](#qualifyingpointenddate)
- [QualifyingPointStartDate](#qualifyingpointstartdate)
- [UnitCostAmount](#unitcostamount)

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

### CurrencyExpirationExtensionModelId

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

### CurrencyExpirationModelId

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

### CurrencyTypeId

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

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

### DoesAllowLedgerTracing

- **Field API Name:** `ssot__DoesAllowLedgerTracing__c`
- **Data Type:** BOOLEAN
- **Description:** Whether points credited by accrual transactions and debited by redemption transactions are traced (true) or not (false).

### DoesAllowNegativeBalance

- **Field API Name:** `ssot__DoesAllowNegativeBalance__c`
- **Data Type:** BOOLEAN
- **Description:** Whether the currency allows members to hold a negative point balance when a member redeeems points points than they have in their point balance.

### ExpirationPeriodFrequencyNumber

- **Field API Name:** `ssot__ExpirationPeriodFrequencyNumber__c`
- **Data Type:** DOUBLE
- **Description:** How frequently loyalty currency units expire, quantified in terms of the expiration period frequency UOM.

### ExpirationPeriodFrequencyTimeUOM

- **Field API Name:** `ssot__ExpirationPeriodFrequencyTimeUOM__c`
- **Data Type:** TEXT
- **Description:** How often currency such as points or miles expires, for example monthly or yearly.

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

### HasEscrow

- **Field API Name:** `ssot__HasEscrow__c`
- **Data Type:** BOOLEAN
- **Description:** Whether the escrow is enabled for the currency.

### Id

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

### IsActive

- **Field API Name:** `ssot__IsActive__c`
- **Data Type:** TEXT
- **Description:** True if the currency is currently in use with the Loyalty Program.

### IsPrimary

- **Field API Name:** `ssot__IsPrimary__c`
- **Data Type:** TEXT
- **Description:** True if this currency is the primary currency for the Loyalty Program.

### KQ_Id

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

### KQ_LoyaltyProgramId

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

### KQ_LoyaltyTierGroupId

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

### LastModifiedDate

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

### LoyaltyProgramId

- **Field API Name:** `ssot__LoyaltyProgramId__c`
- **Data Type:** TEXT
- **Description:** A marketing strategy designed to encourage customers to continue to shop at or use the services of a business associated with the program.

### LoyaltyTierGroupId

- **Field API Name:** `ssot__LoyaltyTierGroupId__c`
- **Data Type:** TEXT
- **Description:** Loyalty Programs may have multiple sets of benefit tiers organized into groups aligned to their objectives, for example Lifetime, Marketing and REgular.

### Name

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

### QualifyingPointEndDate

- **Field API Name:** `ssot__QualifyingPointEndDate__c`
- **Data Type:** DATETIME
- **Description:** The last date the loyalty program accrues currency value.

### QualifyingPointStartDate

- **Field API Name:** `ssot__QualifyingPointStartDate__c`
- **Data Type:** DATETIME
- **Description:** The first date the loyalty program isgin accruing currency value.

### UnitCostAmount

- **Field API Name:** `ssot__UnitCostAmount__c`
- **Data Type:** DOUBLE
- **Description:** This is optional attribute on the currency table to associate a cost per each point awarded for this currency (NQP Only). This is primarily to be used to compute overall liability of the currency program.