# Loyalty Membership Lifecycle DMO

## Object Properties

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

## Relationships

- **OrderItemId** has a FOREIGNKEY relationship with the [Sales Order Product DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-salesorderproductdmo-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.
- **LoyaltyMemberTierId** has a FOREIGNKEY relationship with the [Loyalty Member Tier DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-loyaltymembertierdmo-dmo.md) `Id` field.

## Fields

- [cdp_sys_record_currency](#cdp_sys_record_currency)
- [CommentText](#commenttext)
- [CreatedDate](#createddate)
- [DataSourceId](#datasourceid)
- [DataSourceObjectId](#datasourceobjectid)
- [EffectiveEndDate](#effectiveenddate)
- [EffectiveStartDate](#effectivestartdate)
- [ExternalIdentifier](#externalidentifier)
- [Id](#id)
- [InternalOrganizationId](#internalorganizationid)
- [KQ_Id](#kq_id)
- [KQ_LoyaltyMemberTierId](#kq_loyaltymembertierid)
- [KQ_LoyaltyProgramMemberId](#kq_loyaltyprogrammemberid)
- [KQ_OrderItemId](#kq_orderitemid)
- [LoyaltyMemberTierId](#loyaltymembertierid)
- [LoyaltyProgramMemberId](#loyaltyprogrammemberid)
- [MembershipStatus](#membershipstatus)
- [MembershipType](#membershiptype)
- [OrderItemId](#orderitemid)
- [SubscriptionEffectiveEndDateTime](#subscriptioneffectiveenddatetime)
- [SubscriptionEffectiveStartDateTime](#subscriptioneffectivestartdatetime)

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

### CommentText

- **Field API Name:** `ssot__CommentText__c`
- **Data Type:** TEXT
- **Description:** The comments for the member's lifecycle event.

### CreatedDate

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

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

### EffectiveEndDate

- **Field API Name:** `ssot__EffectiveEndDate__c`
- **Data Type:** DATEONLY
- **Description:** The date till when the member's lifecycle event is effective.

### EffectiveStartDate

- **Field API Name:** `ssot__EffectiveStartDate__c`
- **Data Type:** DATEONLY
- **Description:** The date from when the member's lifecycle event is effective.

### ExternalIdentifier

- **Field API Name:** `ssot__ExternalIdentifier__c`
- **Data Type:** TEXT
- **Description:** The external identifier of the member's lifecycle event.

### Id

- **Field API Name:** `ssot__Id__c`
- **Data Type:** TEXT
- **Description:** Required. A unique, system-generated identifier for this LoyaltyMembershipLifecycle record. Maximum size is 15 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_LoyaltyMemberTierId

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

### KQ_LoyaltyProgramMemberId

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

### KQ_OrderItemId

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

### LoyaltyMemberTierId

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

### LoyaltyProgramMemberId

- **Field API Name:** `ssot__LoyaltyProgramMemberId__c`
- **Data Type:** TEXT
- **Description:** The loyalty program member whose lifecycle is tracked.

### MembershipStatus

- **Field API Name:** `ssot__MembershipStatus__c`
- **Data Type:** TEXT
- **Description:** The status of the member's lifecycle event.

### MembershipType

- **Field API Name:** `ssot__MembershipType__c`
- **Data Type:** TEXT
- **Description:** The type of lifecycle event of the member.

### OrderItemId

- **Field API Name:** `ssot__OrderItemId__c`
- **Data Type:** TEXT
- **Description:** The order associated with the lifecycle event.

### SubscriptionEffectiveEndDateTime

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

### SubscriptionEffectiveStartDateTime

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