Loyalty Member Tier
Member Tier Data Object for Loyalty Member Service
QName: {http://xmlns.oracle.com/apps/sales/loyalty/member/service/memberService/}MemberTier
Logical Business Objects
-
CRM : Loyalty : Loyalty Member
Relationships
The following table describes how this service data object is related to other service data objects or business object services.
Relationship Type | Object or Service |
---|---|
Contained by |
|
Handled by |
Attributes
The following table describes attributes in the service data object.
Name | Type | Description |
---|---|---|
ActiveFlg |
string |
Active flag |
Comments |
string |
Member tier Comments |
CreatedBy |
string |
Tier created by reference |
EndDt |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Member tier end date |
LastUpdateDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Last update date |
LookupCode |
string |
Reason lookup code |
LookupType |
string |
Reason lookup type |
LoyTierClsId |
long |
Loyalty tier class Id |
LoyTierId |
long |
Loyalty tier Id |
MemTierId |
long |
Primary key
|
MemberId |
long |
Tier associated member identifier |
MemberTierNumber |
string |
Member tier number |
NextTierName |
string |
Next tier name |
ObjectVersionNumber |
int |
It is used to implement optimistic lock |
PresentQualPoints |
decimal |
Present qualifying points |
QualPointsToUpgrade |
decimal |
Required qualifying points to upgrade to next tier |
ReasonValue |
string |
Reason for change the tier |
StartDt |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Start date |
StartQualPd |
string |
LOV Meaning of the LOV Code 'StaryQualPdCode' |
StartQualPdCode |
string |
Start qualifying period code |
TierClassId |
long |
Member tier identifier |
TierClassName |
string |
Tier class name |
TierId |
long |
Tier identifier |
TierName |
string |
Tier name |
TierQualPoints |
decimal |
Tier qualifying points |
TillDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
Till date for upgrade to next tier |