Loyalty Aggr Point Expiration Ledger DMO

Object Properties

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

Relationships

• LoyaltyProgramMemberId has a FOREIGNKEY relationship with the Loyalty Program Member DMO Id field.

Fields

• cdp_sys_record_currency
• DataSourceId
• DataSourceObjectId
• ExpirationDate
• ExpirationPointsNumber
• Id
• InternalOrganizationId
• KQ_Id
• KQ_LoyaltyProgramMemberId
• LoyaltyProgramCurrency
• LoyaltyProgramMemberId
• Name
• PointsStatus
• RedeemedPointsNumber

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.

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.

ExpirationDate

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

ExpirationPointsNumber

• Field API Name: ssot__ExpirationPointsNumber__c
• Data Type: DOUBLE
• Description: Numeric value representing the expiration points number. Do not include currency symbols or commas.

Id

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

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_LoyaltyProgramMemberId

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

LoyaltyProgramCurrency

• Field API Name: ssot__LoyaltyProgramCurrency__c
• Data Type: TEXT
• Description: Currency used within the loyalty program associated with the record.

LoyaltyProgramMemberId

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

Name

• Field API Name: ssot__Name__c
• Data Type: TEXT
• Description: The primary name or label for this record.

PointsStatus

• Field API Name: ssot__PointsStatus__c
• Data Type: TEXT
• Description: Alphanumeric string representing the points status.

RedeemedPointsNumber

• Field API Name: ssot__RedeemedPointsNumber__c
• Data Type: DOUBLE
• Description: Numeric value representing the redeemed points number. Do not include currency symbols or commas.