# Loyalty Ledger DMO

## Object Properties

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

## Relationships

- **LoyaltyTransactionJournalId** has a FOREIGNKEY relationship with the [Loyalty Transaction Journal DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-loyaltytransactionjournaldmo-dmo.md) `Id` field.
- **LoyaltyPgmCurrencySubtypeId** has a FOREIGNKEY relationship with the [Loyalty Program Currency Subtype DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-loyaltyprogramcurrencysubtypedmo-dmo.md) `Id` field.
- **PromotionId** has a FOREIGNKEY relationship with the [Promotion DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-promotiondmo-dmo.md) `Id` field.
- **LoyaltyProgramMemberId** has a FOREIGNKEY relationship with the [Loyalty Program Member DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-loyaltyprogrammemberdmo-dmo.md) `Id` field.
- **LoyaltyProgramCurrencyId** has a FOREIGNKEY relationship with the [Loyalty Program Currency DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-loyaltyprogramcurrencydmo-dmo.md) `Id` field.

## Fields

- [ActivityDate](#activitydate)
- [ActivityDateTime](#activitydatetime)
- [cdp_sys_record_currency](#cdp_sys_record_currency)
- [CorrelationIdentifier](#correlationidentifier)
- [CreatedById](#createdbyid)
- [CreatedDate](#createddate)
- [DataEntityId](#dataentityid)
- [DataEntityInstanceId](#dataentityinstanceid)
- [DataSourceId](#datasourceid)
- [DataSourceObjectId](#datasourceobjectid)
- [EscrowPointsCreditDate](#escrowpointscreditdate)
- [EventType](#eventtype)
- [ExpirationDate](#expirationdate)
- [ExternalRecordId](#externalrecordid)
- [ExternalSourceId](#externalsourceid)
- [FinancialTransactionTypeId](#financialtransactiontypeid)
- [Id](#id)
- [InternalOrganizationId](#internalorganizationid)
- [KQ_Id](#kq_id)
- [KQ_LoyaltyPgmCurrencySubtypeId](#kq_loyaltypgmcurrencysubtypeid)
- [KQ_LoyaltyProgramCurrencyId](#kq_loyaltyprogramcurrencyid)
- [KQ_LoyaltyProgramMemberId](#kq_loyaltyprogrammemberid)
- [KQ_LoyaltyTransactionJournalId](#kq_loyaltytransactionjournalid)
- [KQ_PromotionId](#kq_promotionid)
- [LastModifiedDate](#lastmodifieddate)
- [LedgerProcessingStatusId](#ledgerprocessingstatusid)
- [LoyaltyCurrencyUnitQuantity](#loyaltycurrencyunitquantity)
- [LoyaltyLedgerNotesText](#loyaltyledgernotestext)
- [LoyaltyPgmCurrencySubtypeId](#loyaltypgmcurrencysubtypeid)
- [LoyaltyProgramCurrencyExpirationDate](#loyaltyprogramcurrencyexpirationdate)
- [LoyaltyProgramCurrencyId](#loyaltyprogramcurrencyid)
- [LoyaltyProgramCurrencyUnitsQuantity](#loyaltyprogramcurrencyunitsquantity)
- [LoyaltyProgramMemberId](#loyaltyprogrammemberid)
- [LoyaltyTransactionJournalId](#loyaltytransactionjournalid)
- [Name](#name)
- [PointsNumber](#pointsnumber)
- [PromotionId](#promotionid)

### ActivityDate

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

### ActivityDateTime

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

### cdp_sys_record_currency

- **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.

### CorrelationIdentifier

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

### CreatedById

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

### CreatedDate

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

### DataEntityId

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

### DataEntityInstanceId

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

### DataSourceId

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

### DataSourceObjectId

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

### EscrowPointsCreditDate

- **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.

### EventType

- **Field API Name:** `ssot__EventType__c`
- **Data Type:** TEXT
- **Description:** Alphanumeric string representing the event type.

### ExpirationDate

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

### ExternalRecordId

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

### ExternalSourceId

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

### FinancialTransactionTypeId

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

### Id

- **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.

### InternalOrganizationId

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

### KQ_Id

- **Field API Name:** `KQ_Id__c`
- **Data Type:** TEXT
- **Description:** Key Qualifier system field for Id

### KQ_LoyaltyPgmCurrencySubtypeId

- **Field API Name:** `KQ_LoyaltyPgmCurrencySubtypeId__c`
- **Data Type:** TEXT
- **Description:** Key Qualifier system field for LoyaltyPgmCurrencySubtypeId

### KQ_LoyaltyProgramCurrencyId

- **Field API Name:** `KQ_LoyaltyProgramCurrencyId__c`
- **Data Type:** TEXT
- **Description:** Key Qualifier system field for LoyaltyProgramCurrencyId

### KQ_LoyaltyProgramMemberId

- **Field API Name:** `KQ_LoyaltyProgramMemberId__c`
- **Data Type:** TEXT
- **Description:** Key Qualifier system field for LoyaltyProgramMemberId

### KQ_LoyaltyTransactionJournalId

- **Field API Name:** `KQ_LoyaltyTransactionJournalId__c`
- **Data Type:** TEXT
- **Description:** Key Qualifier system field for LoyaltyTransactionJournalId

### KQ_PromotionId

- **Field API Name:** `KQ_PromotionId__c`
- **Data Type:** TEXT
- **Description:** Key Qualifier system field for PromotionId

### LastModifiedDate

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

### LedgerProcessingStatusId

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

### LoyaltyCurrencyUnitQuantity

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

### LoyaltyLedgerNotesText

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

### LoyaltyPgmCurrencySubtypeId

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

### LoyaltyProgramCurrencyExpirationDate

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

### LoyaltyProgramCurrencyId

- **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.

### LoyaltyProgramCurrencyUnitsQuantity

- **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.

### LoyaltyProgramMemberId

- **Field API Name:** `ssot__LoyaltyProgramMemberId__c`
- **Data Type:** TEXT
- **Description:** Member for which the record is being stored.

### LoyaltyTransactionJournalId

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

### Name

- **Field API Name:** `ssot__Name__c`
- **Data Type:** TEXT
- **Description:** Name of a Loyalty Ledger.

### PointsNumber

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

### PromotionId

- **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.