Fee fields

Fee structure fields

Field	Type	Description
name	Text	Fee structure name (e.g., "Grade 7 Fees 2024/2025")
academic_year_id	Reference	Linked academic year
description	Text	Brief description of the fee structure
is_active	Boolean	Whether the structure is currently in use
items	Array	List of fee items with name and amount

Invoice fields

Field	Type	Description
invoice_number	Text	Auto-generated unique invoice number
student_id	Reference	Student this invoice is for
fee_structure_id	Reference	The fee structure used to generate this invoice
total_amount	Number	Total amount due
amount_paid	Number	Amount already paid
balance	Number	Remaining balance (auto-calculated)
due_date	Date	Payment deadline
status	Enum	pending, partial, paid, overdue

Payment fields

Field	Type	Description
payment_number	Text	Auto-generated payment reference
invoice_id	Reference	Linked invoice
amount	Number	Amount paid
payment_method	Enum	cash, bank_transfer, mobile_money, check
reference_number	Text	External reference (bank reference, check number)
payment_date	Date	Date the payment was received
notes	Text	Additional notes about the payment

Receipt fields

Field	Type	Description
receipt_number	Text	Auto-generated receipt number
payment_id	Reference	Linked payment
school_name	Text	School name (from school profile)
school_logo	URL	School logo (from school profile)
student_name	Text	Student name
student_id	Text	Student ID
amount_paid	Number	Amount paid in this transaction
remaining_balance	Number	Outstanding balance after this payment