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