GetClientInfoByEmail()

Description

Returns detailed client information based on the email address entered.

GetClientInfoByEmail(Email AS String)

Return Value

XML String

Parameters

Email = Email address for the client record to return.

Remarks

XML String has the following structure:

Field	Type	Length	Description
iId	Integer	4	Primary Key - Unique Identifier.
iLocationId	Integer	4	Not used.
cLastName	String	20	Client last name.
cFirstName	String	15	Client first name.
cAddress1	String	40	Address (Line 1).
cAddress2	String	40	Address (Line 2).
cCity	String	25	City.
cState	String	3	State.
cZip	String	10	Zip code.
cPostSort	String	5	Postal sort code.
lNonDeliv	Boolean	1	Indicates whether the address is non-deliverable.
cArea	String	4	Area code for home phone.
cHomePhone	String	8	Home phone.
cBusArea	String	4	Area code for business phone.
cBusPhone	String	8	Business phone.
cExtension	String	5	Business extension.
dFirstVisit	DateTime	8	First visit date.
dLastVisit	DateTime	8	Last visit date.
nNumVisits	Integer	4	Total number of visits.
iPrimeEmp	Integer	4	Primary Employee Id. Foreign Key to Employee iId.
nAge	Decimal	3,0	Client age.
dBday	DateTime	8	Client date of birth.
lChildren	Boolean	1	Indicates whether the client has children.
lMarried	Boolean	1	Indicates whether the client is married.
IPrimaryRes	Boolean	1	Indicates whether the client is the primary resident at their address.
dAnniv	DateTime	8	Anniversary date.
nSex	Decimal	1,0	Client gender. 1 = Male 2 = Female
lNoChecks	Boolean	1	Indicates whether the client has children.
lNoMail	Boolean	1	Indicates whether the client wants to receive mailings.
lInActive	Boolean	1	Indicates whether the client is inactive.
dDateDel	DateTime	8	Date deleted.
lDispNote	Boolean	1	Indicates whether the client’s notes display when you view their profile.
lConfirm	Boolean	1	Indicates whether the client receives appointment confirmations.
ICategoryId	Integer	4	Not used.
iGId	Integer	4	Client Global Id.
iGuestId	Integer	4	Id for the client in the property management system.
cRoomNum	String	8	Room number for the client in the property management system.
tCreated	DateTime	8	Date/time created.
iPoints	Integer	4	Current number of points for client.
lAllowPoints	Boolean	1	Indicates whether client can accrue points.
lDispNoteAppt	Boolean	1	Indicates whether the client's notes display when you view their appointments.
cConfSequence	String	7	Appointment confirmation sequence. A = Auto-Confirm C = Cell E = Email F = Fax H = Home S = SMS W = Work
lDispUDFreg	Boolean	1	Indicates whether entries in user defined fields display on the Register in Millennium.
lDispUDFAppt	Boolean	1	Indicates whether entries in user defined fields display on the Appointment Book in Millennium.
tChanged	DateTime	8	Date/time last changed.
mNotes	String		Client notes.
cLicense	String	20	Driver's license number.
cEmail	String	40	Client email address.
cFaxArea	String	4	Fax area code.
cFax	String	8	Fax number.
cCellArea	String	4	Cell phone area code.
cCellPhone	String	8	Cell phone number.
nCreditLimit	Decimal	8,2	Credit limit of the client's account.
iTermId	Integer	4
iRefId	Integer	4	Referral Type Id. Foreign Key to Referrals iId.
iRefPerId	Integer	4	Client referral if iRefId equals 2.