LoyaltyMemberCurrency
The Loyalty Member Currency DMO is a Data Cloud data model object (DMO) representing the value a loyalty member selects to receive, for example, as airline miles or as points.
Columns
| Name | Type | References | Description |
| Created Date | Datetime | The date the record was created. | |
| 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. | |
| Expirable Points | Double | The number of points that expire if not redeemed. | |
| 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. | |
| Last Accrual Processed Date | Datetime | The date when point accrual process was last run. | |
| Last Expiration Process Run Date | Datetime | The date when expirable points were last calculated. | |
| Last Modified Date | Datetime | The date when a user last modified the record. | |
| Last Reset Date | Datetime | The date when points were most recently converted to baseline value for point accrual period. | |
| Loyalty Member Currency Id | Varchar | A unique ID used as primary key for the Loyalty Member Currency DMO. | |
| Loyalty Member Tier Id | Varchar | A reference ID to which tier loyalty member belongs. | |
| Loyalty Program Member | Varchar | A reference ID to person who joined loyalty program. | |
| Name | Varchar | The loyalty member currency name. | |
| Next Reset Date | Datetime | The date when points are changed to a baseline value for the accrual period. | |
| Points Balance | Double | The current number of points available for redemption. | |
| Points Balance Before Reset | Double | The total number of points before account was reset. | |
| Total Points Accrued | Double | The total number of accrued points, including expired and redeemed points. | |
| Total Points Expired | Double | The total number of expired points. | |
| Total Points Redeemed | Double | The total number of points redeemed. |