Loyalty Member Currency DMO

How a member of a loyalty program has chosen to receive value within the program. For example as airline miles, or as points that can be used to redeem other types of awards.

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

• LoyaltyMemberTierId has a FOREIGNKEY relationship with the Loyalty Member Tier DMO Id field.
• CurrencyTypeId has a FOREIGNKEY relationship with the Loyalty Program Currency 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.

• cdp_sys_record_currency
• CreatedDate
• CurrencyTypeId
• DataSourceId
• DataSourceObjectId
• ExpirablePointsNumber
• ExternalRecordId
• ExternalSourceId
• Id
• InternalOrganizationId
• LastAccrualProcessedDate
• LastEscrowProcessedDateTime
• LastExpirationProcessRunDate
• LastModifiedDate
• LastPointsAggregationDateTime
• LastResetDate
• LoyaltyMemberTierId
• LoyaltyProgramCurrencyId
• LoyaltyProgramMemberId
• NameInterfaceField
• NextResetDate
• PointsBalanceBeforeResetNumber
• PointsBalanceNumber
• PointsBalBeforeSecondLastReset
• RedemStlPendFromDateTime
• TotalEscrowAccruedPointsNumber
• TotalEscrowRolloverPointsNumber
• TotalPointsAccruedNumber
• TotalPointsExpiredNumber
• TotalPointsRedeemedNumber

• 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__CreatedDate__c
• Data Type: DATETIME
• Description: The date and time the record was originally created.

• Field API Name: std__CurrencyTypeId__c
• Data Type: TEXT
• Description: Ways of accruing value in a Loyalty Program, for example Miles, Points or a nationial currency such as US dollars.

• 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__ExpirablePointsNumber__c
• Data Type: DOUBLE
• Description: The points that would have expired if the member had not done any redemptions.

• 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__Id__c
• Data Type: TEXT
• Description: Required. A unique, system-generated identifier for this LoyaltyMemberCurrency 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__LastAccrualProcessedDate__c
• Data Type: DATETIME
• Description: The date point accrual process was last run.

• Field API Name: std__LastEscrowProcessedDateTime__c
• Data Type: DATETIME
• Description: This field indicates the datetime at which the Escrow job has last run.

• Field API Name: std__LastExpirationProcessRunDate__c
• Data Type: DATETIME
• Description: The date is used to calculate expirable points.

• 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__LastPointsAggregationDateTime__c
• Data Type: DATETIME
• Description: The date on which the member's fixed type non-qualifying points were last aggregated.

• Field API Name: std__LastResetDate__c
• Data Type: DATETIME
• Description: The date on which points were last changed to a baseline value for the accural period.

• Field API Name: std__LoyaltyMemberTierId__c
• Data Type: TEXT
• Description: The benefit tier within the program to which a member is assigned.

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

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

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

• Field API Name: std__NextResetDate__c
• Data Type: DATETIME
• Description: The next date on which points are changed to a baseline value for the accural period.

• Field API Name: std__PointsBalanceBeforeResetNumber__c
• Data Type: DOUBLE
• Description: How many points the member had before it was reset.

• Field API Name: std__PointsBalanceNumber__c
• Data Type: DOUBLE
• Description: The current number of points available for redemption.

• Field API Name: std__PointsBalBeforeSecondLastReset__c
• Data Type: DOUBLE
• Description: The points balance before the second to last points reset of the member's associated qualifying currency.

• Field API Name: std__RedemStlPendFromDateTime__c
• Data Type: DATETIME
• Description: The date and time from when the redemption settlement is pending.

• Field API Name: std__TotalEscrowAccruedPointsNumber__c
• Data Type: DOUBLE
• Description: The total number of escrow points that are accrued.

• Field API Name: std__TotalEscrowRolloverPointsNumber__c
• Data Type: DOUBLE
• Description: The total number of escrow points that are already credited to the points balance until the current date.

• Field API Name: std__TotalPointsAccruedNumber__c
• Data Type: DOUBLE
• Description: The total number of points accrued in the program. Expired and redeemed points are included.

• Field API Name: std__TotalPointsExpiredNumber__c
• Data Type: DOUBLE
• Description: The number of member points that have expired.

• Field API Name: std__TotalPointsRedeemedNumber__c
• Data Type: DOUBLE
• Description: The number of points that the member has redeemed.