Skip to main content
Skip table of contents

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.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.