Agents
Agent
Agent Status
Country
Territory
Preference Name
Price List
Student Currency
Agent Currency
Memo Currency
Agent Parent

Teachers
Teacher
Teacher Status
Sex
School
Preference Name

Enrolments
Enrol
Enrol Arrival Status
Enrol Bookings Status
Student Agent
Student Price List
Student Currency
Main Agent
Commission Agent
Agent Price List
Agent Currency
Memo Currency
School
Group
Student
Sex
Profession
Country
Territory
Origin Country
Language
Student Level
Student Source

Enrolment - Students
Student
Student Status
Sex
Profession
Country
Territory
Origin Country
Language
Student Source
Preference Name

Enrolment - Groups
Group
Group Arrival Status
Group Bookings Status
School
Main Agent
Commission Agent
Currency
Memo Currency
Price List
Country
Territory
Language

Enrolment - Accommodation Finance
Accommodation
Accommodation Status
Accommodation Town
Accommodation Area
Accommodation Room Type
Price Item
Package
Preference Name
School
Enrol
Group
Student
Sex
Profession
Country
Territory
Origin Country
Language
Student Level
Student Source

Enrolment - Accommodation Booking
Accommodation Booking
Accommodation Booking Status
Accommodation room
Price Item
School
Enrol
Group
Student
Sex
Profession
Country
Territory
Origin Country
Language
Student Level
Student Source

Enrolment - Course Finance
Course
Course Status
Price Item
Package
School
Enrol
Group
Student
Sex
Profession
Country
Territory
Origin Country
Language
Student Level
Student Source

Enrolment - Course Booking
Course Booking
Course Booking Status
Course
School
Enrol
Group
Student
Sex
Profession
Country
Territory
Origin Country
Language
Student Level
Student Source

Enrolment - Classing
Class
Course Booking
Course
School
School Room
Class Level
Enrol
Group
Student
Sex
Profession
Country
Territory
Origin Country
Language
Student Level
Student Source

Enrolment - Transfers
Transfer
Transfer Status
Transfer Type
Pick Up
Drop Off
Price Item
Package
Enrol
Group
School
Student
Sex
Profession
Country
Territory
Origin Country
Language
Student Level
Student Source

Enrolment - Sundries
Sundry
Sundry Status
Price Item
Package
Enrol
Group
School
Student
Sex
Profession
Country
Territory
Origin Country
Language
Student Level
Student Source

All categories list fields in a table.
The contents of each field can be easily deduced from its name, eg. txtSurname in category Student.

The first 3 characters of a field name indicate the type of data held.

bln = Boolean (True or False)
cur = Currency (number with 2 decimal places and currency symbol)
dec = Decimal (number with decimal places)
dte = Date/Time
int = Integer (number with no decimal places)
mem = Memo (variable size text fields used for notes)
txt = Text

Record ID Numbers

All fields with names similar to "intXXXXId" are pointers to records in a table, and are not usually required on documents.
Exceptions to this being:

Student ID = intStudentId
Agent ID = intAgentId
Accommodation ID = intHostId

Addresses

Agents, accommodations and students each have 3 addresses.
The field intAddressID determines which is the default

"0" = Main Address
"1" = Statements Address
"2" = Other Address

Invoice Headers

Field txtInvoiceType indicates the document type.

"D" = Invoice
"C" = Credit Note
"P" = Proforma
"PC" = Proforma Credit
"PD" = Proforma Debit

Note: Types "PC" and "PD" only occur when a student has been credited and re-invoiced.

Field txtCreditAgainst only applies to credits. It is the number of the invoice being credited.

Field blnDirect indicates who has been invoiced.

True = Invoices the student
False = Invoices the agent

Invoice Lines

Field txtInvoiceType indicates the line type.

"D" = Debit item
"C" = Credit item
"N" = Narrative (comment line)