DebtorStatementControl


Columns

Column Type Size Nulls Auto Default Children Parents Comments
StatementNumber int identity 4 √ null
DebtorStatementBalances.StatementNumber FK_DebtorStatementBalances_DebtorStatementControl R
StatementDate datetime 16,3 √ null
StatementDueDate datetime 16,3 √ null
StatementGroup varchar 10 ('')
StatementDescription varchar 50 ('')
StatementComment varchar 2147483647 √ null
Contribution1Description varchar 80 ('')
Contribution1Amount money 21,4 ((0))
Contribution2Description varchar 80 ('')
Contribution2Amount money 21,4 ((0))
ContributionAddTotalFlag bit 1 ((0))
InstalCurrentStatementOnlyFlag bit 1 ((0))
FullYearDiscountPercentage decimal 7,2 ((0))
FullYearDiscountExpiryDate datetime 16,3 √ null
DiscountPercentage decimal 7,2 ((0))
DiscountExpiryDate datetime 16,3 √ null
Contribution1GLCode varchar 15 ('')
Contribution2GLCode varchar 15 ('')
Contribution1TaxCode varchar 5 ('')
Contribution2TaxCode varchar 5 ('')
StatementGroup2 varchar 10 ('')
StatementGroup3 varchar 10 ('')
StatementGroup4 varchar 10 ('')
StatementGroupIncludeFlag bit 1 ((1))
AllStatementGroupsFlag bit 1 ((0))
PrintIfNegativeFlag bit 1 ((1))
PrintIfZeroBalanceFlag bit 1 ((0))
PrintIfArrangementsExistFlag bit 1 ((1))
MinBalance money 21,4 ((0))
PrintChargesOrReceiptsFlag bit 1 ((0))
PrintChargesFlag bit 1 ((0))
PrintChgRcptOrNonZeroFlag bit 1 ((1))
ContributionEldestOnlyFlag bit 1 ((0))
ContributionEachStudentFlag bit 1 ((0))
DebtorSubLedgerCode varchar 15 ('')
PortalPublishDate datetime 16,3 √ null
ViewOriginalDate datetime 16,3 √ null
StoreDate datetime 16,3 √ null
ViewStoreDate datetime 16,3 √ null
EmailDate datetime 16,3 √ null
PrintDate datetime 16,3 √ null
StatementEmailType varchar 20 ('')
StatementEmailFrom varchar 100 ('')
StatementEmailBCC varchar 100 ('')
StatementEmailFromName varchar 100 ('')
StatementEmailSubject varchar 255 ('')
StatementEmailBody varchar 1000 ('')
InvoiceGeneratedDate datetime 16,3 √ null
InvoiceViewOriginalDate datetime 16,3 √ null
InvoiceStoreDate datetime 16,3 √ null
InvoiceViewStoreDate datetime 16,3 √ null
GeneratedDate datetime 16,3 √ null
GeneratedByID int 4 √ null
StoreByID int 4 √ null
PortalPublishByID int 4 √ null
ViewOriginalByID int 4 √ null
ViewStoreByID int 4 √ null
EmailByID int 4 √ null
PrintByID int 4 √ null
InvoiceGeneratedByID int 4 √ null
InvoiceViewOriginalByID int 4 √ null
InvoiceStoreByID int 4 √ null
InvoiceViewStoreByID int 4 √ null
ReminderSourceStatementNumber int 4 √ null
ReminderNumber tinyint 1 ((0))
DebtorStatementApplyUnderlayMain varchar 1 ('B')
DebtorStatementApplyUnderlayHeader varchar 1 ('B')
DebtorStatementApplyUnderlayFooter varchar 1 ('B')
DebtorInvoiceApplyUnderlayMain varchar 1 ('B')
DebtorInvoiceApplyUnderlayHeader varchar 1 ('B')
DebtorInvoiceApplyUnderlayFooter varchar 1 ('B')
DiscountFeeBasedFlag bit 1 ((0))
DiscountFeeDateFrom datetime 16,3 √ null
DiscountFeeDateTo datetime 16,3 √ null
DiscountRoundDirection varchar 1 √ ('N')
DiscountRoundCents smallint 2 √ null
DiscountOwingBasedFlag bit 1 ((0))

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
PK_DebtorStatementControl Primary key Asc StatementNumber
AK_DebtorStatementControl_ReminderSourceStatementNumber Performance Asc ReminderSourceStatementNumber

Relationships

Close relationships within degrees of separation