| Field | Description |
|---|---|
| SiteAnimal | Unique identifier for multiple sites. |
| ClientKey | An internally generated client number. This number is NOT related to any field within Premvet. |
| PVID | Premvet Animal number |
| AnimalName | Name of the animal/horse. |
| Species | Species (EQ records will be set to 'Equine', FC records will be set to 'Farm') |
| Breed | Breed (FC records this is Map Reference) |
| Sex | Sex (FC records this is Herd Type) |
| Neutered | Has it been neutered (Yes or No) |
| ORT | 'Old' Record type. SA = Small Animal, FC = Farm Client, EQ = Equine Record |
| DateOfBirth | Date of Birth |
| Age | Age of animal in years |
| IDNumber | ID number (or tattoo number, Herd Reference) |
| Colour | Colour |
| Weight | Weight of the animal (Null for Equine records). |
| LastWeightDate | Date the last time the Weight was updated via AP code) |
| Height | Height (Equine records only). |
| Insured | Is the animal insured Yes or No. |
| InsuredWith | Who is it insured with? |
| TBU | Is the record card to be updated (New animal via diary). |
| Classification | Classification |
| Ref1 | Ref 1 field on Additional screen |
| Date1 | Date 1 field on Additional screen |
| FNote | Farm Record - Notes |
| Class | Classification as a number |
| RefPrac | Referral Practice (as a Number - See Abid in address book). |
| ReferredBy | Referred by |
| PreferredUser | User the client prefers. |
| AddedBy | User who added the record. |
| SeenInPeriod | Animal has been seen in the period (Yes or No). |
| LoyaltyMultiplier | Loyalty Multiplier. |
| LoyaltyPoints | Number of Loyalty point accumulated. |
| ChronicStatus | The Chronic status (if any) this animal is tagged with. |
| Mileage | Mileage on record card. |
| SurgeryNumber | Surgery Number the animal usually attends. |
| Status | Status codes on the card. |
| Dead | Is the animal Alive or Dead. |
| DateofDeath | Date the animal died. |
| IsClient | Is the animal still valid (Yes / No) - Uses 'Moved Away' 'No Longer Client' Status Code |
| IsClientDate | If no longer a client what was last transaction Date. |
| DiscField | Discount field from the Man Record. |
| ESDAmount | The discount amount the animal is offerred for Early Settlement Discount. |
| ESDType | What does the ESD Amount related to P=percentage, A=Absolute. |
| SurcAmount | The surcharge amount related to this animal. |
| SurcType | Is the Surcharge a Percentage or Asolute amount. |
| SDDAmount | Does any Special Drug Discount apply to this animal. |
| SDDType | Is the SDD a Percentage or Absolute amount. |
| TOSAmount | Any Time of Sale discount/surcharge in force. |
| TOSType | Is the TOS amount a Percentage or Absolute amount. |
| TOSFees | If on split TOS discounts this is the Fees amount. |
| TOSDrugs | If on split TOS discounts this is the drugs amount. |
| DrugsAtCost | Yes or No - does the animal receive drugs at cost? |
| DrugsNoVAT | Yes or No - Does the animal receive drugs at 0% VAT (Charity) |
| SendBill | What is the 'Send Bill Flag' set to (Yes or No). |
| BillType | What invoice type does the animal receive. |
| FirstRegisteredDate | Month and Year the animal was first registered. |
| LastConsDate | Full date when a consultation last took place. |
| LastPaidDate | Full date when a payment last took place. |
| AnimalBalance | The amount outstanding for this animal. |
| AnimalBFAmount | The Balance at the time the records were included in the clinical table. |
| Locked | Does the animal have an Admin lock applied. |
| IsMaster | Is this the Master record for the client (Yes/No). |
| Archive | Has the animal been marked for archive (0-9, 0=No, 1=Status, 2=Age, 3=Last Seen etc.). |
| CS_xxxx | Custom sheet. All fields will be prefixed with CS_ |
| MR_Flag_X | Management Flag X (1-11) either Yes or No. |
| LastBilledDate | Date the animal was last billed. |
| LastBilledAmount | The Amount the animal was last billed. |
| NextApptDate | The Date and Time of the next appointment. (At present old style diary only) |
| DiaryQueue | The Queue the above appointment was in. |