Loyalty Program Currency DMO

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

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

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

• cdp_sys_record_currency
• CreatedDate
• CurrencyExpirationExtensionModelId
• CurrencyExpirationModelId
• CurrencyTypeId
• DataSourceId
• DataSourceObjectId
• DoesAllowLedgerTracing
• DoesAllowNegativeBalance
• ExpirationPeriodFrequencyNumber
• ExpirationPeriodFrequencyTimeUom
• ExternalRecordId
• ExternalSourceId
• HasEscrow
• Id
• InternalOrganizationId
• IsActive
• IsPrimary
• LastModifiedDate
• LoyaltyProgramId
• LoyaltyTierGroupId
• NameInterfaceField
• QualifyingPointEndDate
• QualifyingPointStartDate
• UnitCostAmount

• Field API Name: std__cdp_sys_record_currency__c
• Data Type: TEXT
• Description: System-generated metadata field that stores a 3-letter ISO currency code.

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

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

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

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

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

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

• Field API Name: std__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: std__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: std__ExpirationPeriodFrequencyNumber__c
• Data Type: DOUBLE
• Description: How frequently loyalty currency units expire, quantified in terms of the expiration period frequency UOM.

• Field API Name: std__ExpirationPeriodFrequencyTimeUom__c
• Data Type: TEXT
• Description: Alphanumeric string representing the expiration period frequency time uom.

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

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

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

• Field API Name: std__Id__c
• Data Type: TEXT
• Description: Required. A unique, system-generated identifier for this LoyaltyProgramCurrency record. Maximum size is 36 characters.

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

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

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

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

• Field API Name: std__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: std__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: std__NameInterfaceField__c
• Data Type: TEXT
• Description: Name of this record.

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

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

• Field API Name: std__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.