wkDebtorStatementRecipients


Columns

Column Type Size Nulls Auto Default Children Parents Comments
wkDebtorStatementRecipientsSeq int identity 4 √ null
UserIdentifier varchar 128 null
ID int 4 √ null
DebtorID int 4 √ null
DebtorStudentID int 4 √ null
DebtorName varchar 100 null
AddressFull varchar 500 null
RecipientSeq tinyint 1 √ null
AddressDPID varchar 8 √ null
AddressDPIDBarcode varchar 60 √ null
AddressSortPlanNumber varchar 10 √ null
AddressPAFVersion varchar 10 √ null
IncludeOnStatementFlag int 4 √ null
EmailAddress varchar 100 √ null
NotifyMethod varchar 2 √ null
CreatedDate datetime 16,3 √ (getdate())
CreatedBy varchar 128 √ null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
PK_wkDebtorStatementRecipients Primary key Asc wkDebtorStatementRecipientsSeq
AK_wkDebtorStatementRecipients_Debtor Performance Asc/Asc/Asc/Asc UserIdentifier + DebtorID + DebtorStudentID + ID