client - Client Details

Field Description
SiteRegistered Surgery number the client is register at.
ClientKey Unique DM number relating to the client.
MasterRec The Premvet animal number for the Master record.
CID Combination of MasterRec and Site Number.
Surname Clients surname.
Title Clients title.
Initials Initials
AddressLine1 Address Details
AddressLine2
AddressLine3
Postcode
Telephone Telephone Number
EMail E-Mail address
Marketing Marketing Tag for the client.
NumberOfAnimals Number of animals this client has.
ActiveAnimals PDSA only - Number of active animals.
BadDebt Yes or No - Does the client have any animals with status 'BD'.
IsClient Yes or No - This is set to NO if ANY of the animals belonging to this client are marked with the 'Moved Away' status codes.
ClientBalance The amount the CLIENT has outstanding.
SpendY5 These fields relate to how much the client has spent in each year. DataMajor will use full calendar years. So SpendY5 is the 5th full year, that is in 2002 using the default 5 years will be spend in 1997, SpendY3 would be 1999, SpendY1 will be 2001. The SpendY field related to the CURRENT year e.g. everything since the 1st of Jan.
SpendY4
SpendY3
SpendY2
SpendY1
SpendY
SL12M Spend in the last 12 months.
VisitY5 Similar to Spend above, this relates to the number of transaction within the period.
VisitY4
VisitY3
VisitY2
VisitY1
VisitY
VL12M Number of Visits in last 12 months.
FirstRegistered Month and Year the client registered with you.
LastVisit Month and Year of the last visit.
LastPaid Month and Year of the last payment.
Mobile_Number Mobile number
Fax_Number Fax number
Telephone_xx Other telephone numnbers, where xx is 2 to 9 e.g. Telephone_8 is the eighth number.

Field Center PetAid Description
The following fields are only available with PDSA version.
PDSACategory Yes Yes Category of registration (Number).
PDSAWhat Yes Yes Description of the category.
UseData Yes Yes Yes/No can the data be used for mailings.
Period Yes Yes Period the data is valid for
UserItem1 Yes No User ID for Item 1
UserItem2 Yes No User ID for item 2
DateItem1 Yes No Date Item 1 was produced.
DateItem2 Yes No Date Item 2 was produced.
DetailsItem1 Yes No Item 1 details
DetailsItem2 Yes No Item 2 details.
Agent Yes Yes Agent
NatIns No Yes National Insurance Number
RegType No Yes smallint(2) unsigned
Date_Issued No Yes Date
User_Issued No Yes char(3)
Forms_Issued No Yes date
User_Forms No Yes char(3)
Forms_Returned No Yes date
User_Returned No Yes char(3)
Forms_NotR No Yes date
User_NotR No Yes char(3)
Reg_Approved No Yes date
User_Approved No Yes char(3)
Reg_Fees No Yes date
User_RegFee No Yes char(3)
Start_Date No Yes date
End_Date No Yes date
SAC_Reject No Yes smallint(1) unsigned
Resubmitted No Yes enum('No','Yes')