Loyalty Ledger DMO

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

• LoyaltyTransactionJournalId has a FOREIGNKEY relationship with the Loyalty Transaction Journal DMO Id field.
• LoyaltyPgmCurrencySubtypeId has a FOREIGNKEY relationship with the Loyalty Program Currency Subtype DMO Id field.
• PromotionId has a FOREIGNKEY relationship with the Promotion 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.

• ActivityDate
• ActivityDateTime
• cdp_sys_record_currency
• CorrelationIdentifier
• CreatedById
• CreatedDate
• DataEntityId
• DataEntityInstanceId
• DataSourceId
• DataSourceObjectId
• EscrowPointsCreditDate
• EventType
• ExpirationDate
• ExternalRecordId
• ExternalSourceId
• FinancialTransactionTypeId
• Id
• InternalOrganizationId
• KQ_Id
• KQ_LoyaltyPgmCurrencySubtypeId
• KQ_LoyaltyProgramCurrencyId
• KQ_LoyaltyProgramMemberId
• KQ_LoyaltyTransactionJournalId
• KQ_PromotionId
• LastModifiedDate
• LedgerProcessingStatusId
• LoyaltyCurrencyUnitQuantity
• LoyaltyLedgerNotesText
• LoyaltyPgmCurrencySubtypeId
• LoyaltyProgramCurrencyExpirationDate
• LoyaltyProgramCurrencyId
• LoyaltyProgramCurrencyUnitsQuantity
• LoyaltyProgramMemberId
• LoyaltyTransactionJournalId
• Name
• PointsNumber
• PromotionId

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

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

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

• Field API Name: ssot__CorrelationIdentifier__c
• Data Type: TEXT
• Description: Alphanumeric string representing the correlation identifier.

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

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

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

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

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

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

• Field API Name: ssot__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: ssot__EventType__c
• Data Type: TEXT
• Description: Alphanumeric string representing the event type.

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

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

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

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

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

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

• Field API Name: KQ_Id__c
• Data Type: TEXT
• Description: Key Qualifier system field for Id

• Field API Name: KQ_LoyaltyPgmCurrencySubtypeId__c
• Data Type: TEXT
• Description: Key Qualifier system field for LoyaltyPgmCurrencySubtypeId

• Field API Name: KQ_LoyaltyProgramCurrencyId__c
• Data Type: TEXT
• Description: Key Qualifier system field for LoyaltyProgramCurrencyId

• Field API Name: KQ_LoyaltyProgramMemberId__c
• Data Type: TEXT
• Description: Key Qualifier system field for LoyaltyProgramMemberId

• Field API Name: KQ_LoyaltyTransactionJournalId__c
• Data Type: TEXT
• Description: Key Qualifier system field for LoyaltyTransactionJournalId

• Field API Name: KQ_PromotionId__c
• Data Type: TEXT
• Description: Key Qualifier system field for PromotionId

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

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

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

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

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

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

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

• Field API Name: ssot__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: ssot__LoyaltyProgramMemberId__c
• Data Type: TEXT
• Description: Member for which the record is being stored.

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

• Field API Name: ssot__Name__c
• Data Type: TEXT
• Description: Name of a Loyalty Ledger.

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

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