Fee_Balance, 148 (ver3.7.0)
This table records the Global fee balance for each student. Total is updated each time a fee transaction or fee is created.
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
Balance | 3.7.0 | Float | The global balance a student accumulates for all fee transactions. |
Credit | 3.7.0 | Float | A total of all the credit the student has for the year. |
DCID | 4.0.0 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
Debit | 3.7.0 | Float | A total of the entire debit the student has for the year. |
ID | 3.7.0 | Number(10,0) | Sequential number generated by the application. Indexed. |
SchoolID | 3.7.0 | Number(10,0) | The School_Number of the associated Schools record. |
StudentID | 3.7.0 | Number(10,0) | The internal number and ID of the associated Students record. |
TeacherID | 3.7.0 | Number(10,0) | The internal identification number of the teacher in the associated SchoolStaff record. Indexed. |
YearID | 3.7.0 | Number(10,0) | A number representing which year the term belongs to, such as 13 for 2003-2004. The number is equal to the ID of the year term divided by 100. |