ODBC Driver for Salesforce Data Cloud

Build 24.0.9175

LoyaltyProgramCurrency

The Loyalty Program Currency DMO is a Data Cloud data model object (DMO) representing the value or currency that the loyalty program offers to customers.

Columns

Name Type References Description
Created Date Datetime The date the record was created.
Currency Expiration Extension Model Varchar A reference ID to the program’s currency model, for example, the rewards don’t expire or expire on a certain date.
Currency Expiration Model Varchar A reference ID to the values of the currency expiration model, such as fixed or activity based.
Currency Type Varchar A reference ID to methods of accruing value in loyalty program, for example miles, points, or a hard currency such as US dollars.
Data Source Varchar A reference ID for the logical name for a system that is the source of records identified by external record ID.
Data Source Object Varchar A reference ID for the logical name of the object where this record came from, whether that is a name of a cloud storage file or another connector’s external object.
Expiration Period Frequency Double The frequent currency units expire in relation to the unit of measure (UOM).
Expiration Period Frequency Time UOM Varchar The time period for how often currency such as points or miles expire.
External Record ID Varchar A reference ID to an external data source system.
External Source ID Varchar A reference ID for the system in which the external record ID was assigned.
Internal Organization Varchar A reference ID to the business unit or other internal organization that owns the business account.
Is Active Varchar An indicator if the currency is being used.
Is Primary Varchar An indicator if the currency is the primary currency for the loyalty program.
Last Modified Date Datetime The date when a user last modified the record.
Loyalty Program Varchar A reference ID to the loyalty program.
Loyalty Program Currency ID Varchar A unique ID used as primary key for the Loyalty Program Currency DMO.
Loyalty Tier Group Varchar A reference ID to the tiers available in a loyalty program.
Name Varchar The loyalty member currency name.
Qualifying Point End Date Datetime The date when currency stops being accrued.
Qualifying Point Start Date Datetime The date when currency begins to be accrued.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175