Loyalty Transaction Journal DMO

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.

ssot__LoyaltyTransactionJournal__dlm

Other

Loyalty

Loyalty Transaction Journal ID (ssot__Id__c)

ObjectFieldCardinalityRelated ObjectRelated Field
Loyalty LedgerLoyalty Transaction JournalMany To One: N:1Loyalty Transaction JournalLoyalty Transaction Journal ID
Loyalty Transaction JournalEngagementMany To One: N:1Product Browse EngagementProduct Browse Engagement ID
Loyalty Transaction JournalEngagementMany To One: N:1Product Order EngagementProduct Order Engagement ID
Loyalty Transaction JournalProductMany To One: N:1Goods ProductGoods Product ID
Loyalty Transaction JournalProductMany To One: N:1Bundle ProductBundle Product ID
Loyalty Transaction JournalEngagementMany To One: N:1Shopping Cart EngagementShopping Cart Engagement ID
Loyalty Transaction JournalEngagementMany To One: N:1Message EngagementMessage Engagement ID
Loyalty Transaction JournalAccount ContactMany To One: N:1Account ContactAccount Contact ID
Loyalty Transaction JournalBrandMany To One: N:1BrandBrand ID
Loyalty Transaction JournalEngagementMany To One: N:1Device Application EngagementDevice Application Engagement ID
Loyalty Transaction JournalEngagementMany To One: N:1Email EngagementEmail Engagement ID
Loyalty Transaction JournalLoyal Journal SubtypeMany To One: N:1Loyal Journal SubtypeLoyal Journal Subtype ID
Loyalty Transaction JournalLoyalty Program Corporate MemberMany To One: N:1Loyalty Program MemberLoyalty Program Member ID
Loyalty Transaction JournalLoyalty Program MemberMany To One: N:1Loyalty Program MemberLoyalty Program Member ID
Loyalty Transaction JournalLoyalty Program Referred MemberMany To One: N:1Loyalty Program MemberLoyalty Program Member ID
Loyalty Transaction JournalLoyalty Program PartnerMany To One: N:1Loyalty Program PartnerLoyalty Program Partner ID
Loyalty Transaction JournalLoyalty ProgramMany To One: N:1Loyalty ProgramLoyalty Program ID
Loyalty Transaction JournalEngagementMany To One: N:1Web Search EngagementWeb Search Engagement ID
Loyalty Transaction JournalEngagementMany To One: N:1Website EngagementWebsite Engagement ID
Loyalty Transaction JournalRelated Loyalty Transaction JournalMany To One: N:1Loyalty Transaction JournalLoyalty Transaction Journal ID
Loyalty Transaction JournalLoyalty Journal TypeMany To One: N:1Loyalty Journal TypeLoyalty Journal Type ID
Loyalty Transaction JournalPayment MethodMany To One: N:1VoucherVoucher ID
Loyalty Transaction JournalProductMany To One: N:1Master ProductMaster Product ID
Loyalty Transaction JournalSales Order ProductMany To One: N:1Sales Order ProductSales Order Product ID
VoucherLoyalty Transaction JournalMany To One: N:1Loyalty Transaction JournalLoyalty Transaction Journal ID
Field NameField API NameDescriptionData Type
Account Contactssot__AccountContactId__cA reference ID to an individual who has a role specific to the account.text
Activity Datessot__ActivityDate__cThe date of the transaction.dateTime
Benefit Action Process Typessot__BenefitActionProcessTypeId__cA reference idea to the process type of the benefit.text
Booked Fare Classssot__BookedFareClassId__cA reference ID for the fare class that was booked, such as economy or first-class.text
Booked Room Typessot__BookedRoomTypeId__cA reference ID for the type of room booked.text
Booking Datessot__BookingDate__cThe booking date of the voucher or related loyalty reward.dateTime
Brandssot__BrandId__cA reference ID to the brand association to the transaction journal.text
Created Datessot__CreatedDate__cThe date the record was created.dateTime
Currencyssot__CurrencyId__cA reference ID to the currency related to the reward.text
Data Sourcessot__DataSourceId__cA reference ID for the logical name for a system that is the source of records identified by an external record ID.text
Data Source Objectssot__DataSourceObjectId__cA 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.text
Engagementssot__EngagementId__cA reference ID to the engagement related to the transaction.text
Establishment Namessot__EstablishmentName__cThe name of the establishment related to the transaction.text
External Record IDssot__ExternalRecordId__cA reference ID to an external data source system.text
External Source IDssot__ExternalSourceId__cA reference ID for the system in which the external record ID was assigned.text
Financial Transaction Typessot__FinancialTransactionTypeId__cA reference ID to the type of the financial institution used for the transaction.text
Flight Numberssot__FlightNumber__cThe flight number related to the transaction.text
Industryssot__IndustryId__cA reference ID to the industry, for example, financial services or hospitality.text
Internal Organizationssot__InternalOrganizationId__cA reference ID to the business unit or other internal organization that owns the business account.text
Invoice Datessot__InvoiceDate__cThe date of the invoice.dateTime
Journal Datessot__JournalDate__cThe date of the journal.dateTime
Last Modified Datessot__LastModifiedDate__cThe date when a user last modified the record.dateTime
Locationssot__LocationId__cA reference ID to the location related to the transaction.text
Loyalty Journal Subtypessot__LoyaltyJournalSubtypeId__cA reference ID for a subtype of a loyalty journal type, for example, a watched video or product review.text
Loyalty Journal Typessot__LoyaltyJournalTypeId__cA reference ID to the type of loyalty journal.text
Loyalty Programssot__LoyaltyProgramId__cA reference ID to a marketing strategy designed to encourage customers to shop at or use the services of business associated with the program.text
Loyalty Program Corporate Memberssot__LoyaltyProgramCorporateMemberId__cA reference ID to the corporate member of a loyalty programtext
Loyalty Program Memberssot__LoyaltyProgramMemberId__cA reference ID to the person who has joined a loyalty programtext
Loyalty Program Partnerssot__LoyaltyProgramPartnerId__cA reference ID to a company who provides a loyalty program offering to members.text
Loyalty Program Referred Memberssot__LoyaltyProgramReferredMemberId__cA reference ID to a person referred to the program by a loyalty member.text
Loyalty Transaction Journal Idssot__Id__cA unique ID used as the primary key for the Loyalty Transaction Journal DMO.text
Loyalty Transaction Journal Statusssot__LoyaltyTransactionJournalStatus__cThe status of the loyalty transaction journal.text
Namessot__Name__cThe name of a loyalty program transaction journal.text
Payment Methodssot__PaymentMethodId__cA reference ID to the method of payment.text
Payment Method Typessot__PaymentMethodTypeId__cA reference ID to the type of payment method, for example a gift card or cash.text
Productssot__ProductId__cA reference ID to a product intended to be sold, for example goods, services, bundles, or made-to-order products.text
Reasonssot__ReasonText__cThe reason for the loyalty transaction.text
Related Loyalty Transaction Journalssot__RelatedLoyaltyTransactionJournalId__cA reference ID to related transaction records.text
Sales Channelssot__SalesChannelId__cA reference ID to the sales channel used to place order.text
Sales Order Productssot__SalesOrderProductId__cA reference ID to the product purchased in a sales order.text
Transaction Amountssot__TransactionAmount__cThe amount of the transaction.number
Transaction Quantityssot__TransactionQuantity__cThe number of transactions.number
Transaction Quantity UOMssot__TransactionQuantityUOM__cThe transaction unit of measure, for example, credits.text
Travel Destination Namessot__TravelDestinationName__cThe name of the travel destination.text
Travel Distance Numberssot__TravelDistanceNumber__cThe total distance, for example, 100.number
Travel Distance UOMssot__TravelDistanceUOM__cThe total distance unit of measure, for example, miles.text
Travel Origin Namessot__TravelOriginName__cThe name or location where the travel began.text
Traveled Fare Classssot__TraveledFareClassId__cA reference ID to the type of class, for example, first or business class.text