Loyalty Member
Member Data Object for Loyalty Member Service
QName: {http://xmlns.oracle.com/apps/sales/loyalty/member/service/memberService/}Member
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 |
---|---|
Contains |
|
Contains |
|
Contains |
|
Contains |
|
Contains |
|
Contains |
|
Contains |
|
Contains |
|
Contained by |
|
Handled by |
Attributes
The following table describes attributes in the service data object.
Name | Type | Description |
---|---|---|
AccntId |
long |
Account Id |
AccountFullName |
string |
Account full name |
AccountName |
string |
Account name |
AccountPartyNumber |
string |
Account party number |
AccrualLookupCode |
string |
Accrual lookup code |
AccrualLookupType |
string |
Accrual lookup type |
AccrualMeaning |
string |
Accrual meaning |
AccrualStartDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The date when member starts to accrue the points |
AccrualToHouseholdFlg |
string |
Accrual to household flag |
AccrualToMemId |
long |
Member that any new transaction will accrual points to |
AccrualType |
string |
Used to store the Accrual type |
AccrualTypeCode |
string |
Accrual type code |
AttributeCategory |
string |
Structure definition of the user descriptive flexfield |
ClassLookupCode |
string |
Class lookup code |
ClassLookupType |
string |
Class lookup type |
ClassMeaning |
string |
Class meaning |
ContactDateOfBirth |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
Date the contact person was born |
ContactFirstName |
string |
Contact first name |
ContactId |
long |
Contact Id |
ContactLastName |
string |
Contact last name |
ContactName |
string |
Contact name |
CorpCurrencyCode |
string |
Corporate currency code for extensibility |
CorpMemberNumber |
string |
Used to store the corporate membership number reference |
CreatedBy |
string |
Created By |
CreationDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Creation Date |
CreationSource |
string |
Creation source |
CurcyConvRateType |
string |
Currency conversion rate type for extensibility |
CurrencyCode |
string |
Currency code |
CurrencyDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
Currency date |
CurrentDateTimeAttr |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Current date time attribute |
DateOfBirth |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
Date the person was born |
EditTransactionUI |
Transaction object associated with Member |
|
EmailAddress |
string |
Email address |
FormattedPhoneNumber |
string |
Formatted phone number |
GroupLookupCode |
string |
Group lookup code |
GroupLookupType |
string |
Group lookup type |
GroupMeaning |
string |
Group meaning |
HouseholdFullName |
string |
Household full name |
HouseholdMemIsChanged |
string |
Indicates whether the household member is changed |
HouseholdMember |
string |
Household member |
HouseholdMemberId |
long |
Household member Id |
HouseholdName |
string |
Household name |
LastAccrTransactionDt |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
LLast accural transaction date |
LastRdmTransactionDt |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Indicates the members last redemption transaction date |
LastTransactionProcedDt |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Last transaction proceed date |
LastUpdateDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Last Update Date |
LastUpdateLogin |
string |
Last Update Login |
LastUpdatedBy |
string |
Last Updated By |
LftmPointTypeAVal |
decimal |
Lifetime payment type A value |
LftmPointTypeBVal |
decimal |
Lifetime payment type B value |
LftmPointTypeCVal |
decimal |
Lifetime payment type C value |
LftmPointTypeDVal |
decimal |
Lifetime payment type D value |
LftmPointTypeEVal |
decimal |
Lifetime payment type E value |
LftmPointTypeFVal |
decimal |
Lifetime payment type F value |
LftmPointTypeGVal |
decimal |
Lifetime payment type G value |
LftmPointTypeHVal |
decimal |
Lifetime payment type H value |
LookupCode |
string |
Status lookup code |
LookupType |
string |
Status lookup type |
LoyAccountName |
string |
Name of an Account |
LoyHouseholdName |
string |
Name of a Household |
LoyProgramName |
string |
Name of the Loyalty Program. |
LoyaltyProgramName |
string |
Name of the loyalty program |
LstTierChangeDt |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Date of member's last tier change |
MemberAttributes |
Attributes associated with Member |
|
MemberCard |
Member card object associated with Member |
|
MemberClassCode |
string |
Member class code |
MemberClassMeaning |
string |
Member class meaning |
MemberEmailAddress |
string |
Email address of the member |
MemberGrpCode |
string |
Member group code |
MemberId |
long |
Member unique identifier |
MemberName |
string |
Name of the member |
MemberNumber |
string |
Member number |
MemberPhaseCode |
string |
Member phase code |
MemberPhaseMeaning |
string |
Member phase meaning |
MemberPromotionsEnrolled |
Member Enrollments into Enrollable Promotions. |
|
MemberTier |
Member tier object associated to the Member |
|
MemberTransactions |
Transaction Object Associated with Member |
|
MemberTypeCode |
string |
Member type code |
MemberTypeMeaning |
string |
Member type meaning |
MemberVoucher |
Member voucher object associated to the Member |
|
MembershipSchemeId |
long |
Refers to the product id(enrollment product) |
MobileNumber |
string |
Mobile number |
ObjectVersionNumber |
int |
It is used to imiplement optimistic lock |
OrgGroupId |
long |
Orgnization group Id |
OrgGroupPartyNumber |
string |
Organization group party number |
ParentMember |
string |
Parent member flag |
PartyId |
long |
Party identifier |
PartyName |
string |
Party Name |
PartyNumber |
string |
The Party Number of the contact associated to the Loyalty Member |
PersonD |
Person object associated to the Member |
|
PersonFirstName |
string |
Person first name |
PersonLastName |
string |
Person last name |
PersonName |
string |
Person name |
PersonProfileId |
long |
Person profile identifier |
PhaseLookupCode |
string |
Phase lookup code |
PhaseLookupType |
string |
Phase lookup type |
PhaseMeaning |
string |
Phase meaning |
PhoneNumber |
string |
Phone number |
PointTypeAVal |
decimal |
Point type A value |
PointTypeBVal |
decimal |
Point type B value |
PointTypeCVal |
decimal |
Point type C value |
PointTypeDVal |
decimal |
Point type D value |
PointTypeEVal |
decimal |
Point type E value |
PointTypeFVal |
decimal |
Point type F value |
PointTypeGVal |
decimal |
Point type G value |
PointTypeHVal |
decimal |
Point type H value |
Points |
string |
Points balance |
PrConId |
long |
Primary contact Id |
PreviousTierName |
string |
Previous tier name |
ProgId |
long |
Program identification number |
ProgName |
string |
Loyalty program name |
ProgramName |
string |
Name of the Program |
ProgramNumber |
string |
Program number |
RealTimeBonusFlag |
boolean |
Real Time Bonus Flag |
ReferConId |
long |
Primary contact Id of referral member |
ReferredById |
long |
Referred by identification reference |
ReferredByIdMember |
Referred by member object associated to the Member |
|
ReferredByName |
string |
Referred by member name |
ReferredByNumber |
string |
Referred by member number |
RelationshipId |
long |
To store relationship between members |
RelationshipRecId |
long |
Relationship record Id |
RelationshipType |
string |
Relationship type |
StartDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Start date |
Status |
string |
Member status |
StatusCode |
string |
Status code |
SuppressCall |
string |
Suppress call |
SuppressCallFlag |
boolean |
Block Member Call Contact |
SuppressEmail |
string |
Suppress email |
SuppressEmailFlag |
boolean |
Block Member Email Contact |
SuppressFax |
string |
Suppress fax |
SuppressFaxFlag |
boolean |
Block Member Fax Contact |
SuppressMail |
string |
Suppress mail |
SuppressMailFlag |
boolean |
Block Member Mail Contact |
SuppressSMS |
string |
Suppress SMS |
SuppressSMSFlag |
boolean |
Block Member SMS Contact |
SurvMemNumber |
string |
Surviving member number |
TierName |
string |
Tier name |
ValLifeScore |
string |
Holds the life time values score of the member |
WorkPhoneNumber |
string |
Work phone number |
cards |
Member card object associated to the Member |
|
promotions |
Member Enrollments into Enrollable Promotions. |
|
reltype |
string |
Relationship type |
vouchers |
Member voucher object associated to the Member |