ODBC Driver for Salesforce Data Cloud

Build 24.0.9175

LoyaltyBenefit

The Loyalty Benefit DMO is a Data Cloud data model object (DMO) for a perk or betterment that is available to the members of a Loyalty Program. Examples include waived airline baggage fees, complimentary hotel stays, or a rental car upgrade.

Columns

Name Type References Description
Benefit Action Varchar A reference ID for actions such as creating a service entitlement that can be triggered automatically when a loyalty program benefit is assigned to a program member.
Benefit Status Varchar A reference ID for benefit status values such as Active or Inactive.
Created Date Datetime The date the record was created.
Data Source Varchar A reference ID for the logical name for a system that is the source of records identified by an external record ID.
Data Source Object Varchar A reference ID for the logical name of the object where this record came from, whether that is a name of a cloud storage file or another connector’s external object.
Description Varchar The description of the loyalty program.
External Record ID Varchar A reference ID to an external data source system.
External Source ID Varchar A reference ID for the system in which the external record ID was assigned.
Internal Organization Varchar A reference ID to the business unit or other internal organization that owns the business account.
Last Modified Date Datetime The date when a user last modified the record.
Loyalty Benefit Priority Number Varchar Priority rating of the loyalty benefit, for example, 1 for highest or 2 for second highest priority.
Loyalty Benefit ID Varchar A unique ID used as the primary key for the Loyalty Benefit DMO.
Loyalty Benefit Type Varchar A reference ID to the Loyalty Benefit Types that are used to group the various benefits available within a Loyalty Program. For example, baggage benefits could be used to group reduced fees, extra baggage allowances, and weight limit benefits.
Loyalty Benefit UOM Varchar The type of benefit unit within a Loyalty Benefit Type. For example, if the Loyalty Benefit Type is luggage, then UOM is the number of additional free bags.
Loyalty Benefit Value Varchar Loyalty Benefit values are used to determine how many units of the benefit type. For instance if Loyalty Benefit UOM is the number of free bags, then Benefit Value could be 1, 2 or 3.
Name Varchar Name of the loyalty benefit.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175