Fee_Transaction, 147 (ver4.0.4)
Fee Transaction associated with a specific Fee (via the FeeID).
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
Amount | 4.0.4 | Float | Fee amount for this transaction. |
Custom | 4.0.4 | CLOB | Custom field. |
DateTime | 4.0.4 | Varchar(15) | Date and time of this transaction (as a string value). |
Date_Value | 4.0.4 | Date | Actual date of the transaction. |
DCID | 4.0.4 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
Description | 4.0.4 | Varchar(79) | Transaction description. |
FeeID | 4.0.4 | Number(10,0) | Fee to which this transaction applies. Indexed. |
Global_NetEffect | 4.0.4 | Float | Global Net affect. |
Global_Starting_Balance | 4.0.4 | Float | Starting balance. |
Group_Transaction_ID | 4.0.4 | Number(10,0) | Group transaction identifier. Indexed. |
ID | 4.0.4 | Number(10,0) | Sequential number generated by the application. Indexed. |
Internal_Info_For_Trigger | 4.0.4 | Number(10,0) | Trigger information. |
| Internal_Note | 23.6.0 | Varchar2(4000 char) | For future use by PowerSchool |
NetEffect | 4.0.4 | Float | Net effect. |
Payment_Method | 4.0.4 | Varchar(11) | Payment method. |
Payment_Ref_Nbr | 4.0.4 | Varchar(79) | Payment reference number. |
Receipt_Nbr | 4.0.4 | Varchar(79) | Receipt number. |
SchoolID | 4.0.4 | Number(10,0) | The School_Number of the associated Schools record. |
Starting_Balance | 4.0.4 | Float | Starting balance. |
StudentID | 4.0.4 | Number(10,0) | The internal number and ID of the associated Students record. |
System_User_ID | 4.0.4 | Number(10,0) | User ID. |
TeacherID | 4.0.4 | Number(10,0) | The internal identification number of the teacher in the associated SchoolStaff record. Indexed. |
Time | 4.0.4 | Number(10,0) | Transaction time value. |
Transaction_Type | 4.0.4 | Varchar(13) | Type of transaction. |
YearID | 4.0.4 | 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. Indexed. |