Loyalty Program Currency DMO

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

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

• LoyaltyTierGroupId has a FOREIGNKEY relationship with the Loyalty Tier Group DMO Id field.
• LoyaltyProgramId has a FOREIGNKEY relationship with the Loyalty Program DMO Id field.

• cdp_sys_record_currency
• CreatedDate
• CurrencyExpirationExtensionModelId
• CurrencyExpirationModelId
• CurrencyTypeId
• DataSourceId
• DataSourceObjectId
• DoesAllowLedgerTracing
• DoesAllowNegativeBalance
• ExpirationPeriodFrequencyNumber
• ExpirationPeriodFrequencyTimeUOM
• ExternalRecordId
• ExternalSourceId
• HasEscrow
• Id
• InternalOrganizationId
• IsActive
• IsPrimary
• KQ_Id
• KQ_LoyaltyProgramId
• KQ_LoyaltyTierGroupId
• LastModifiedDate
• LoyaltyProgramId
• LoyaltyTierGroupId
• Name
• QualifyingPointEndDate
• QualifyingPointStartDate
• UnitCostAmount

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

• Field API Name: KQ_Id__c
• Data Type: TEXT
• Description: Key Qualifier system field for Id

• Field API Name: KQ_LoyaltyProgramId__c
• Data Type: TEXT
• Description: Key Qualifier system field for LoyaltyProgramId

• Field API Name: KQ_LoyaltyTierGroupId__c
• Data Type: TEXT
• Description: Key Qualifier system field for LoyaltyTierGroupId

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

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

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

• Field API Name: ssot__Name__c
• Data Type: TEXT
• Description: Name of a Loyalty Program Currency.

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

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

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