Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| FileYear | smallint | 2 | null |
|
|
|||
| FamilyID | int | 4 | null |
|
|
|||
| DebtorID | int | 4 | null |
|
|
|||
| StudentID | int | 4 | null |
|
|
|||
| TransactionSeq | int | 4 | null |
|
|
|||
| FeeCode | varchar | 15 | null |
|
|
|||
| TransactionAmount | money | 21,4 | null |
|
|
|||
| TransactionDate | datetime | 16,3 | √ | null |
|
|
||
| AutoTuitionCode | varchar | 5 | null |
|
|
|||
| Campus | varchar | 3 | null |
|
|
|||
| YearLevel | smallint | 2 | √ | null |
|
|
||
| YearLevelTo | int | 4 | √ | null |
|
|
||
| SiblingCount | tinyint | 1 | null |
|
|
|||
| FamilyPosition | tinyint | 1 | null |
|
|
|||
| Boarder | varchar | 3 | null |
|
|
|||
| BoarderType | varchar | 1 | null |
|
|
|||
| TuitionVariationType | varchar | 3 | null |
|
|
|||
| DebtorFeesDescription | varchar | 80 | null |
|
|
|||
| DebtorFeesAmount | money | 21,4 | null |
|
|
|||
| AutoTuitionPeriodIncludeFlag | bit | 1 | null |
|
|
|||
| AutoTuitionPeriodNumber | smallint | 2 | null |
|
|
|||
| FeeCategoryCode | varchar | 15 | null |
|
|
|||
| ActiveFlag | bit | 1 | null |
|
|
|||
| DebtorSubLedgerCode | varchar | 15 | null |
|
|
|||
| FeeCategoryDescription | varchar | 30 | null |
|
|
|||
| FeeCategorySynergyMeaning | varchar | 30 | null |
|
|
|||
| TaxAmount | money | 21,4 | null |
|
|
Table contained 0 rows