LoyaltyTransactionJournal
The Loyalty Transaction Journal DMO is a Data Cloud data model object (DMO) for a collection of transactions related to a loyalty program. Loyalty Transaction Journals are related to a voucher, but could relate to other payment method types.
Columns
| Name | Type | References | Description |
| Account Contact | Varchar | A reference ID to an individual who has a role specific to the account. | |
| Activity Date | Datetime | The date of the transaction. | |
| Benefit Action Process Type | Varchar | A reference idea to the process type of the benefit. | |
| Booked Fare Class | Varchar | A reference ID for the fare class that was booked, such as economy or first-class. | |
| Booked Room Type | Varchar | A reference ID for the type of room booked. | |
| Booking Date | Datetime | The booking date of the voucher or related loyalty reward. | |
| Brand | Varchar | A reference ID to the brand association to the transaction journal. | |
| Created Date | Datetime | The date the record was created. | |
| Currency | Varchar | A reference ID to the currency related to the reward. | |
| 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. | |
| Engagement | Varchar | A reference ID to the engagement related to the transaction. | |
| Establishment Name | Varchar | The name of the establishment related to the transaction. | |
| 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 Transaction Type | Varchar | A reference ID to the type of the financial institution used for the transaction. | |
| Flight Number | Varchar | The flight number related to the transaction. | |
| Industry | Varchar | A reference ID to the industry, for example, financial services or hospitality. | |
| Internal Organization | Varchar | A reference ID to the business unit or other internal organization that owns the business account. | |
| Invoice Date | Datetime | The date of the invoice. | |
| Journal Date | Datetime | The date of the journal. | |
| Last Modified Date | Datetime | The date when a user last modified the record. | |
| Location | Varchar | A reference ID to the location related to the transaction. | |
| Loyalty Journal Subtype | Varchar | A reference ID for a subtype of a loyalty journal type, for example, a watched video or product review. | |
| Loyalty Journal Type | Varchar | A reference ID to the type of loyalty journal. | |
| Loyalty Program | Varchar | A reference ID to a marketing strategy designed to encourage customers to shop at or use the services of business associated with the program. | |
| Loyalty Program Corporate Member | Varchar | A reference ID to the corporate member of a loyalty program | |
| Loyalty Program Member | Varchar | A reference ID to the person who has joined a loyalty program | |
| Loyalty Program Partner | Varchar | A reference ID to a company who provides a loyalty program offering to members. | |
| Loyalty Program Referred Member | Varchar | A reference ID to a person referred to the program by a loyalty member. | |
| Loyalty Transaction Journal Id | Varchar | A unique ID used as the primary key for the Loyalty Transaction Journal DMO. | |
| Loyalty Transaction Journal Status | Varchar | The status of the loyalty transaction journal. | |
| Name | Varchar | The name of a loyalty program transaction journal. | |
| Payment Method | Varchar | A reference ID to the method of payment. | |
| Payment Method Type | Varchar | A reference ID to the type of payment method, for example a gift card or cash. | |
| Product | Varchar | A reference ID to a product intended to be sold, for example goods, services, bundles, or made-to-order products. | |
| Reason | Varchar | The reason for the loyalty transaction. | |
| Related Loyalty Transaction Journal | Varchar | A reference ID to related transaction records. | |
| Sales Channel | Varchar | A reference ID to the sales channel used to place order. | |
| Sales Order Product | Varchar | A reference ID to the product purchased in a sales order. | |
| Transaction Amount | Double | The amount of the transaction. | |
| Transaction Quantity | Double | The number of transactions. | |
| Transaction Quantity UOM | Varchar | The transaction unit of measure, for example, credits. | |
| Travel Destination Name | Varchar | The name of the travel destination. | |
| Travel Distance Number | Double | The total distance, for example, 100. | |
| Travel Distance UOM | Varchar | The total distance unit of measure, for example, miles. | |
| Travel Origin Name | Varchar | The name or location where the travel began. | |
| Traveled Fare Class | Varchar | A reference ID to the type of class, for example, first or business class. |