DebtorInstalmentsHistory


Columns

Column Type Size Nulls Auto Default Children Parents Comments
DebtorInstalmentsHistorySeq int identity 4 √ null
TransactionMode char 1 √ null
HistoryDate datetime 16,3 √ null
HistoryID int 4 √ null
InstalmentSeq int 4 null
DebtorID int 4 null
DebtorStudentID int 4 null
InstalmentDescription varchar 80 √ null
InstalmentDate datetime 16,3 √ null
FeeCode varchar 15 √ null
TotalAmount money 21,4 √ null
TotalCharged money 21,4 √ null
PostingNumber int 4 √ null
PostingSource varchar 10 √ null
InstalmentsStoppedFlag bit 1 √ null
InstalmentFrequency varchar 15 √ null
InstalmentNumber smallint 2 √ null
InstalmentNextAmount money 21,4 √ null
InstalmentNextDate datetime 16,3 √ null
StatementNumber int 4 √ null
StudentID int 4 √ null
StudentCourseChargesSeq int 4 √ null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
PK_DebtorInstalmentsHistory Primary key Asc DebtorInstalmentsHistorySeq
AK_DebtorInstalmentsHistory_DebtorID Performance Asc/Asc DebtorID + DebtorStudentID
AK_DebtorInstalmentsHistory_InstalmentSeq Performance Asc InstalmentSeq