Loyalty Ledger DMO

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

• PromotionId has a FOREIGNKEY relationship with the Promotion DMO Id field.
• LoyaltyTransactionJournalId has a FOREIGNKEY relationship with the Loyalty Transaction Journal DMO Id field.
• LoyaltyProgramMemberId has a FOREIGNKEY relationship with the Loyalty Program Member DMO Id field.
• LoyaltyProgramCurrencyId has a FOREIGNKEY relationship with the Loyalty Program Currency DMO Id field.
• LoyaltyPgmCurrencySubtypeId has a FOREIGNKEY relationship with the Loyalty Program Currency Subtype DMO Id field.

• ActivityDate
• ActivityDateTime
• cdp_sys_record_currency
• CorrelationIdentifier
• CreatedById
• CreatedDate
• DataEntityId
• DataEntityInstanceId
• DataSourceId
• DataSourceObjectId
• EscrowPointsCreditDate
• EventType
• ExpirationDate
• ExternalRecordId
• ExternalSourceId
• FinancialTransactionTypeId
• Id
• InternalOrganizationId
• LastModifiedDate
• LedgerProcessingStatusId
• LoyaltyCurrencyUnitQuantity
• LoyaltyLedgerNotesText
• LoyaltyPgmCurrencySubtypeId
• LoyaltyProgramCurrencyExpirationDate
• LoyaltyProgramCurrencyId
• LoyaltyProgramCurrencyUnitsQuantity
• LoyaltyProgramMemberId
• LoyaltyTransactionJournalId
• NameInterfaceField
• PointsNumber
• PromotionId

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

• Field API Name: std__ActivityDateTime__c
• Data Type: DATETIME
• Description: The date when the journal ledger entry was created.

• 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__CorrelationIdentifier__c
• Data Type: TEXT
• Description: Alphanumeric string representing the correlation identifier.

• 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__DataEntityId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: std__DataEntityInstanceId__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__EscrowPointsCreditDate__c
• Data Type: DATEONLY
• Description: The date on which the escrow points is credited to the point balance for the loyalty ledger.

• Field API Name: std__EventType__c
• Data Type: TEXT
• Description: Alphanumeric string representing the event type.

• Field API Name: std__ExpirationDate__c
• Data Type: DATEONLY
• Description: Expiry date of the points given (applicable only for non-qualifying points).

• 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__Id__c
• Data Type: TEXT
• Description: Required. A unique, system-generated identifier for this LoyaltyLedger record. Maximum size is 36 characters.

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

• 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__LedgerProcessingStatusId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: std__LoyaltyCurrencyUnitQuantity__c
• Data Type: DOUBLE
• Description: The number of points or currency units given for this ledger record.

• Field API Name: std__LoyaltyLedgerNotesText__c
• Data Type: TEXT
• Description: Additional details about a loyalty ledger entry.

• Field API Name: std__LoyaltyPgmCurrencySubtypeId__c
• Data Type: TEXT
• Description: The loyalty program currency subtype associated with the loyalty ledger.

• Field API Name: std__LoyaltyProgramCurrencyExpirationDate__c
• Data Type: DATETIME
• Description: The date and time of the loyalty program currency expiration date.

• Field API Name: std__LoyaltyProgramCurrencyId__c
• Data Type: TEXT
• Description: Mediums of exchange that are allowed within a Loyalty Program such as Points and Miles.

• Field API Name: std__LoyaltyProgramCurrencyUnitsQuantity__c
• Data Type: DOUBLE
• Description: The quantity of points, miles or other program currencies that were awarded or spent in the transaction.

• Field API Name: std__LoyaltyProgramMemberId__c
• Data Type: TEXT
• Description: Member for which the record is being stored.

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

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

• Field API Name: std__PointsNumber__c
• Data Type: DOUBLE
• Description: Amount of points given by the system for this record.

• Field API Name: std__PromotionId__c
• Data Type: TEXT
• Description: The promotion that's applied to the associated transaction resulting in the credit or debit of points.