vDebtorStuConcessionsApplied


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ConcessionTransactionSeq int 4 null
DebtorID int 4 null
DebtorStudentID int 4 null
StudentID int 4 null
PostingNumber int 4 null
PostingSource varchar 10 null
InstalmentSeq int 4 null
InstalmentsRemaining smallint 2 null
StatementNumber int 4 null
FeeCode varchar 15 null
TransactionDate datetime 16,3 √ null
TransactionAmount money 21,4 null
TransactionDescription varchar 80 null
AllocatedAmount money 21,4 null
FeeUnits decimal 11,4 null
FeeRate money 21,4 null
StudentNameInternal varchar 100 √ null
StudentNameExternal varchar 100 √ null
StudentLegalFullName varchar 150 √ null
StudentSurname varchar 30 √ null
StudentPreferred varchar 20 √ null
StudentPreferredFormal varchar 20 √ null
StudentName varchar 54 √ null
StudentGender varchar 15 √ null
StudentBirthDate datetime 16,3 √ null
StudentCampus varchar 3 √ null
StudentCampusDescription varchar 30 √ null
YearLevel smallint 2 √ null
FamilyPosition smallint 2 √ null
FileYear smallint 2 √ null
FileSemester smallint 2 √ null
FeeDescription varchar 80 √ null
DiscountPercentage decimal 9,4 √ null
AutoTuitionCodeFee varchar 5 √ null
AutoTuitionCodeConcession varchar 5 √ null
ConcessionTypeCode varchar 15 √ null
EffectiveFromDate datetime 16,3 √ null
EffectiveToDate datetime 16,3 √ null

Table contained 0 rows

View Definition

Possibly Referenced Tables/Views