# Loyalty Tier Mshp Fee Option DMO

Represents the options by which members can pay for tier or club memberships.

## Object Properties

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

## Relationships

- **LoyaltyTierId** has a FOREIGNKEY relationship with the [Loyalty Tier DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-loyaltytierdmo-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

- [cdp_sys_record_currency](#cdp_sys_record_currency)
- [DataSourceId](#datasourceid)
- [DataSourceObjectId](#datasourceobjectid)
- [EffectiveEndDateTime](#effectiveenddatetime)
- [EffectiveStartDateTime](#effectivestartdatetime)
- [FeeType](#feetype)
- [Id](#id)
- [InternalOrganizationId](#internalorganizationid)
- [IsActive](#isactive)
- [KQ_Id](#kq_id)
- [KQ_LoyaltyProgramCurrencyId](#kq_loyaltyprogramcurrencyid)
- [KQ_LoyaltyTierId](#kq_loyaltytierid)
- [LoyaltyProgramCurrencyId](#loyaltyprogramcurrencyid)
- [LoyaltyTierId](#loyaltytierid)
- [MembershipDurationType](#membershipdurationtype)
- [MembershipFeeAmount](#membershipfeeamount)
- [MembershipPoints](#membershippoints)

### cdp_sys_record_currency

- **Field API Name:** `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:** `DataSourceId__c`
- **Data Type:** TEXT
- **Description:** A unique, system-generated identifier for this record.

### DataSourceObjectId

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

### EffectiveEndDateTime

- **Field API Name:** `EffectiveEndDateTime__c`
- **Data Type:** DATETIME
- **Description:** The date and time of the effective end date time.

### EffectiveStartDateTime

- **Field API Name:** `EffectiveStartDateTime__c`
- **Data Type:** DATETIME
- **Description:** The date and time of the effective start date time.

### FeeType

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

### Id

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

### InternalOrganizationId

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

### IsActive

- **Field API Name:** `IsActive__c`
- **Data Type:** BOOLEAN
- **Description:** Indicates whether this record is active (true) or not (false).

### KQ_Id

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

### KQ_LoyaltyProgramCurrencyId

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

### KQ_LoyaltyTierId

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

### LoyaltyProgramCurrencyId

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

### LoyaltyTierId

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

### MembershipDurationType

- **Field API Name:** `MembershipDurationType__c`
- **Data Type:** TEXT
- **Description:** Alphanumeric string representing the membership duration type.

### MembershipFeeAmount

- **Field API Name:** `MembershipFeeAmount__c`
- **Data Type:** CURRENCY
- **Description:** Monetary amount representing the membership fee amount. Do not include currency symbols or commas.

### MembershipPoints

- **Field API Name:** `MembershipPoints__c`
- **Data Type:** DOUBLE
- **Description:** Numeric value representing the membership points. Do not include currency symbols or commas.