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	Point Type
Contains	Loyalty Member Tier
Contains	Loyalty Member
Contains	Contact
Contains	Card
Contains	Loyalty Transaction
Contains	Voucher
Contains	Member Promotion Enrollment
Contained by	Loyalty Member
Handled by	Loyalty Member Service

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	Loyalty Transaction	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	Point Type	Attributes associated with Member
MemberCard	Card	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 Promotion Enrollment	Member Enrollments into Enrollable Promotions.
MemberTier	Loyalty Member Tier	Member tier object associated to the Member
MemberTransactions	Loyalty Transaction	Transaction Object Associated with Member
MemberTypeCode	string	Member type code
MemberTypeMeaning	string	Member type meaning
MemberVoucher	Voucher	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	Contact	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	Loyalty Member	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	Card	Member card object associated to the Member
promotions	Member Promotion Enrollment	Member Enrollments into Enrollable Promotions.
reltype	string	Relationship type
vouchers	Voucher	Member voucher object associated to the Member