Loyalty Transaction Journal DMO

Object API Name: std__LoyaltyTransactionJournalDmo__dlm
Category: Unassigned
Availability: Available in 254 and later versions
Primary Key Field: Id

• EngagementId has a FOREIGNKEY relationship with the Message Engagement DMO Id field.
• LoyaltyProgramId has a FOREIGNKEY relationship with the Loyalty Program DMO Id field.
• PaymentMethodId has a FOREIGNKEY relationship with the Voucher DMO Id field.
• ProductCategoryId has a FOREIGNKEY relationship with the Product Category DMO Id field.
• EngagementId has a FOREIGNKEY relationship with the Product Browse Engagement DMO Id field.
• ProductId has a FOREIGNKEY relationship with the Goods Product DMO Id field.
• OfferId has a FOREIGNKEY relationship with the Offer DMO Id field.
• ProductId has a FOREIGNKEY relationship with the Bundle Product DMO Id field.
• PromotionId has a FOREIGNKEY relationship with the Promotion DMO Id field.
• EngagementId has a FOREIGNKEY relationship with the Shopping Cart Engagement DMO Id field.
• EngagementId has a FOREIGNKEY relationship with the Email Engagement DMO Id field.
• LoyaltyProgramReferredMemberId has a FOREIGNKEY relationship with the Loyalty Program Member DMO Id field.
• RelatedLoyaltyTransactionJournalId has a FOREIGNKEY relationship with the Loyalty Transaction Journal DMO Id field.
• LoyaltyProgramCorporateMemberId has a FOREIGNKEY relationship with the Loyalty Program Member DMO Id field.
• LoyaltyProgramMemberId has a FOREIGNKEY relationship with the Loyalty Program Member DMO Id field.
• SalesOrderProductId has a FOREIGNKEY relationship with the Sales Order Product DMO Id field.
• CouponId has a FOREIGNKEY relationship with the Coupon DMO Id field.
• ReferralId has a FOREIGNKEY relationship with the Referral DMO Id field.
• BrandId has a FOREIGNKEY relationship with the Brand DMO Id field.
• EngagementId has a FOREIGNKEY relationship with the Device Application Engagement DMO Id field.
• ProductId has a FOREIGNKEY relationship with the Master Product DMO Id field.
• LoyaltyJournalTypeId has a FOREIGNKEY relationship with the Loyalty Journal Type DMO Id field.
• EngagementId has a FOREIGNKEY relationship with the Website Engagement DMO Id field.
• AccountContactId has a FOREIGNKEY relationship with the Account Contact DMO Id field.
• LoyaltyProgramPartnerId has a FOREIGNKEY relationship with the Loyalty Program Partner DMO Id field.
• EngagementId has a FOREIGNKEY relationship with the Product Order Engagement DMO Id field.
• LoyaltyJournalSubtypeId has a FOREIGNKEY relationship with the Loyalty Journal Subtype DMO Id field.
• EngagementId has a FOREIGNKEY relationship with the Web Search Engagement DMO Id field.

• AccountContactId
• ActivityDate
• BenefitActionProcessTypeId
• BookedFareClassId
• BookedRoomTypeId
• BookingDate
• BrandId
• cdp_sys_record_currency
• CouponId
• CreatedById
• CreatedDate
• CurrencyId
• DataSourceId
• DataSourceObjectId
• EngagementId
• EstablishmentName
• ExternalRecordId
• ExternalSourceId
• FinancialTransactionTypeId
• FlightNumber
• Id
• IndustryId
• IndustryTypeText
• InternalOrganizationId
• InvoiceDate
• IsParentTransaction
• JournalDate
• LastModifiedDate
• LocationId
• LoyaltyJournalSubtypeId
• LoyaltyJournalTypeId
• LoyaltyProgramCorporateMemberId
• LoyaltyProgramId
• LoyaltyProgramMemberId
• LoyaltyProgramPartnerId
• LoyaltyProgramReferredMemberId
• LoyaltyTransactionJournalStatus
• NameInterfaceField
• OfferId
• PartyId
• PaymentMethodId
• PaymentMethodTypeId
• ProductCategoryId
• ProductId
• PromotionId
• ReasonText
• RedeemedPointsExpiryInfoText
• ReferralCodeText
• ReferralId
• RelatedLoyaltyTransactionJournalId
• SalesChannelId
• SalesOrderProductId
• TotalPromotionDiscountAmount
• TransactionAmount
• TransactionLocationName
• TransactionQuantity
• TransactionQuantityUom
• TransactionSourceId
• TravelDestinationName
• TravelDistanceNumber
• TravelDistanceUom
• TraveledFareClassId
• TravelOriginName
• UsageType
• VoucherCodeText

• Field API Name: std__AccountContactId__c
• Data Type: TEXT
• Description: An individual who has a role specific to an Account.

• Field API Name: std__ActivityDate__c
• Data Type: DATETIME
• Description: The date when the journal transaction occurred.

• Field API Name: std__BenefitActionProcessTypeId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: std__BookedFareClassId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: std__BookedRoomTypeId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: std__BookingDate__c
• Data Type: DATETIME
• Description: Date when the member booked lodging, using program benefits.

• Field API Name: std__BrandId__c
• Data Type: TEXT
• Description: The sum of name, term, design, symbol, and other feature that identifies one good or service as distinct from those of other sellers or other Internal Organizations within the same organization.

• Field API Name: std__cdp_sys_record_currency__c
• Data Type: TEXT
• Description: System-generated metadata field that stores a 3-letter ISO currency code.

• Field API Name: std__CouponId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: std__CreatedById__c
• Data Type: TEXT
• Description: The user who created the record.

• Field API Name: std__CreatedDate__c
• Data Type: DATETIME
• Description: The date and time the record was originally created.

• Field API Name: std__CurrencyId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: std__DataSourceId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: std__DataSourceObjectId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: std__EngagementId__c
• Data Type: TEXT
• Description: Details about a specific Engagement Vehicle having a specific target and Engagement Channel Action. For example details about the opening of an email message sent to a specific individual on a particular date.

• Field API Name: std__EstablishmentName__c
• Data Type: TEXT
• Description: Describes a business where a loyalty transaction took place.

• Field API Name: std__ExternalRecordId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: std__ExternalSourceId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: std__FinancialTransactionTypeId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: std__FlightNumber__c
• Data Type: TEXT
• Description: An id or name assigned by an airline to a travel route.

• Field API Name: std__Id__c
• Data Type: TEXT
• Description: Required. A unique, system-generated identifier for this LoyaltyTransactionJournal record. Maximum size is 36 characters.

• Field API Name: std__IndustryId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: std__IndustryTypeText__c
• Data Type: TEXT
• Description: Economic activity, often related to manufacturing or the processing of raw materials. Example values: Mining, Banking, Real Estate.

• Field API Name: std__InternalOrganizationId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: std__InvoiceDate__c
• Data Type: DATETIME
• Description: The date and time of the invoice date.

• Field API Name: std__IsParentTransaction__c
• Data Type: TEXT
• Description: Specifies whether the transction journal record is for the parent transaction of an activity.

• Field API Name: std__JournalDate__c
• Data Type: DATETIME
• Description: The date when the loyalty transaction entry posted to the account ledger.

• Field API Name: std__LastModifiedDate__c
• Data Type: DATETIME
• Description: The date and time of the last modification to this record.

• Field API Name: std__LocationId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: std__LoyaltyJournalSubtypeId__c
• Data Type: TEXT
• Description: Within Loyalty Journal Types such as accural, redemption and signup, finer-grained types can be defined, for example watched video, product purchase, or product review.

• Field API Name: std__LoyaltyJournalTypeId__c
• Data Type: TEXT
• Description: Types of Loyalty Transaction Journal entries include: accrual, redemption, signup and expiration.

• Field API Name: std__LoyaltyProgramCorporateMemberId__c
• Data Type: TEXT
• Description: A membership in the Loyalty Program that's associated with employment at a corporation.

• Field API Name: std__LoyaltyProgramId__c
• Data Type: TEXT
• Description: A marketing strategy designed to encourage customers to continue to shop at or use the services of a business associated with the program.

• Field API Name: std__LoyaltyProgramMemberId__c
• Data Type: TEXT
• Description: A person who has joined a Loyalty Program.

• Field API Name: std__LoyaltyProgramPartnerId__c
• Data Type: TEXT
• Description: Another organization that's integrated into the Loyalty Program offering point redemption or co-marketing product lines.

• Field API Name: std__LoyaltyProgramReferredMemberId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: std__LoyaltyTransactionJournalStatus__c
• Data Type: TEXT
• Description: Values for Loyalty Transaction Journal Status may include: Unposted, Posted and Deleted.

• Field API Name: std__NameInterfaceField__c
• Data Type: TEXT
• Description: Name of this record.

• Field API Name: std__OfferId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: std__PartyId__c
• Data Type: TEXT
• Description: The Account, Contact for whom the transaction journal is created.

• Field API Name: std__PaymentMethodId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: std__PaymentMethodTypeId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: std__ProductCategoryId__c
• Data Type: TEXT
• Description: The category of the product associated with the booking.

• Field API Name: std__ProductId__c
• Data Type: TEXT
• Description: What is intended to be sold. For example, goods, services, bundles, made to order products.

• Field API Name: std__PromotionId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: std__ReasonText__c
• Data Type: TEXT
• Description: Why the journal entry was created.

• Field API Name: std__RedeemedPointsExpiryInfoText__c
• Data Type: TEXT
• Description: The details of the points that are redeemed in a transaction and their corresponding expiration dates.

• Field API Name: std__ReferralCodeText__c
• Data Type: TEXT
• Description: The referral code that was provided by the contact for the purchase.

• Field API Name: std__ReferralId__c
• Data Type: TEXT
• Description: The associated referral for the transaction journal.

• Field API Name: std__RelatedLoyaltyTransactionJournalId__c
• Data Type: TEXT
• Description: A collection of transactions related to a Loyalty Program.

• Field API Name: std__SalesChannelId__c
• Data Type: TEXT
• Description: Which channel is used to sell goods. For example, Web Store, Retail Store, Street Faire.

• Field API Name: std__SalesOrderProductId__c
• Data Type: TEXT
• Description: A component of a Sales Order that identifies a product or service that's sold to the customer.

• Field API Name: std__TotalPromotionDiscountAmount__c
• Data Type: DOUBLE
• Description: The amount of discount provided by the associated promotion for the transaction journal.

• Field API Name: std__TransactionAmount__c
• Data Type: DOUBLE
• Description: The total amount that can be attributed to the exchange of goods, services or loyalty currency for this transaction journal entry.

• Field API Name: std__TransactionLocationName__c
• Data Type: TEXT
• Description: A place associated with the loyalty transaction.

• Field API Name: std__TransactionQuantity__c
• Data Type: DOUBLE
• Description: The number of items purchased.

• Field API Name: std__TransactionQuantityUom__c
• Data Type: TEXT
• Description: Alphanumeric string representing the transaction quantity uom.

• Field API Name: std__TransactionSourceId__c
• Data Type: TEXT
• Description: The associated record id of the retail store, location, or webstore where the transaction journal has originated.

• Field API Name: std__TravelDestinationName__c
• Data Type: TEXT
• Description: Describes the final point for a loyalty journal transaction involving travel.

• Field API Name: std__TravelDistanceNumber__c
• Data Type: DOUBLE
• Description: Quantifies the number of miles or kilometers traveled.

• Field API Name: std__TravelDistanceUom__c
• Data Type: TEXT
• Description: Alphanumeric string representing the travel distance uom.

• Field API Name: std__TraveledFareClassId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: std__TravelOriginName__c
• Data Type: TEXT
• Description: Describes the beginning point for a loyalty journal transaction involving travel.

• Field API Name: std__UsageType__c
• Data Type: TEXT
• Description: The business usage associated with the record.

• Field API Name: std__VoucherCodeText__c
• Data Type: TEXT
• Description: The associated voucher code for the transaction record.