DebtorStatementRecipientsHistory


Columns

Column Type Size Nulls Auto Default Children Parents Comments
DebtorStatementRecipientsHistorySeq int identity 4 √ null
TransactionMode char 1 √ null
HistoryDate datetime 16,3 √ null
HistoryID int 4 √ null
DebtorStatementRecipientsSeq int 4 √ null
DebtorID int 4 √ null
DebtorStudentID int 4 √ null
RecipientSeq tinyint 1 √ null
ID int 4 √ null
PrimaryOnlyFlag bit 1 √ null
MailAddressCode varchar 1 √ null
NotifyMethod varchar 2 √ null
EmailAddressCode varchar 2 √ null
EmailOverride varchar 100 √ null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
PK_DebtorStatementRecipientsHistory Primary key Asc DebtorStatementRecipientsHistorySeq
AK_DebtorStatementRecipientsHistory_DebtorID Performance Asc/Asc DebtorID + DebtorStudentID
AK_DebtorStatementRecipientsHistory_DebtorStatementRecipientsSeq Performance Asc DebtorStatementRecipientsSeq