LoyaltyLedger
The Loyalty Ledger DMO is a Data Cloud data model object (DMO) to record the points credited or debited for a member across transactions.
Columns
| Name | Type | References | Description |
| Activity Datetime | Datetime | The date a loyalty program member completes a transaction with the loyalty program partner. | |
| Created Date | Datetime | The date when the record was created. | |
| Data Entity | Varchar | A reference ID to the category a business or organization is interested in, for example, a hospital, account, or person. | |
| Data Entity Instance | Varchar | A reference ID to a particular occurrence of one category of things defined by the Data Entity. | |
| Data Source | Varchar | A reference ID for the logical name for a system that is the source of records identified by an 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. | |
| 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. | |
| Financial TransactionType | Varchar | A reference ID to financial transactions, for example Credit or Debit. | |
| Internal Organization | Varchar | A reference ID to the business unit or other internal organization that owns the business account. | |
| Last Modified Date | Datetime | The date when a user last modified the record. | |
| Ledger Processing Status | Varchar | A reference ID to the value of Ledger Processing Status, for example, not processed, successfully processed, or failed processing. | |
| Loyalty Currency Unit Quantity | Double | The total number of loyalty currency units, such as points or miles, given for ledger record. | |
| Loyalty Ledger ID | Varchar | A unique ID used as the primary key for the Loyalty Ledger DMO. | |
| Loyalty Ledger Notes | Varchar | Additional details about loyalty ledger entry. | |
| Loyalty Program Currency | Varchar | A reference ID to the medium of exchange allowed within a loyalty program, for example points or miles. | |
| Loyalty Program Currency Expiration Date | Datetime | The date when the loyalty program currency is set to expire. | |
| Loyalty Program Currency Units Quantity | Double | The quantity of loyalty program currency awarded or spent in a transaction. | |
| Loyalty Transaction Journal | Varchar | A reference ID to a collection of transactions related to loyalty program. | |
| Name | Varchar | The name of a loyalty ledger. |