Loyalty Membership Lifecycle DMO

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

• OrderItemId has a FOREIGNKEY relationship with the Sales Order Product DMO Id field.
• LoyaltyProgramMemberId has a FOREIGNKEY relationship with the Loyalty Program Member DMO Id field.
• LoyaltyMemberTierId has a FOREIGNKEY relationship with the Loyalty Member Tier DMO Id field.

• cdp_sys_record_currency
• CommentText
• CreatedDate
• DataSourceId
• DataSourceObjectId
• EffectiveEndDate
• EffectiveStartDate
• ExternalIdentifier
• Id
• InternalOrganizationId
• KQ_Id
• KQ_LoyaltyMemberTierId
• KQ_LoyaltyProgramMemberId
• KQ_OrderItemId
• LoyaltyMemberTierId
• LoyaltyProgramMemberId
• MembershipStatus
• MembershipType
• OrderItemId
• SubscriptionEffectiveEndDateTime
• SubscriptionEffectiveStartDateTime

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

• Field API Name: ssot__CommentText__c
• Data Type: TEXT
• Description: The comments for the member’s lifecycle event.

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

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

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

• Field API Name: ssot__EffectiveEndDate__c
• Data Type: DATEONLY
• Description: The date till when the member’s lifecycle event is effective.

• Field API Name: ssot__EffectiveStartDate__c
• Data Type: DATEONLY
• Description: The date from when the member’s lifecycle event is effective.

• Field API Name: ssot__ExternalIdentifier__c
• Data Type: TEXT
• Description: The external identifier of the member’s lifecycle event.

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

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

• Field API Name: KQ_Id__c
• Data Type: TEXT
• Description: Key Qualifier system field for Id

• Field API Name: KQ_LoyaltyMemberTierId__c
• Data Type: TEXT
• Description: Key Qualifier system field for LoyaltyMemberTierId

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

• Field API Name: KQ_OrderItemId__c
• Data Type: TEXT
• Description: Key Qualifier system field for OrderItemId

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

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

• Field API Name: ssot__MembershipStatus__c
• Data Type: TEXT
• Description: The status of the member’s lifecycle event.

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

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

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

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