Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| StatementNumber | int | 4 | null |
|
|
|||
| StatementDate | datetime | 16,3 | √ | null |
|
|
||
| StatementDueDate | datetime | 16,3 | √ | null |
|
|
||
| StatementGroup | varchar | 10 | null |
|
|
|||
| StatementDescription | varchar | 50 | null |
|
|
|||
| StatementComment | varchar | 2147483647 | √ | null |
|
|
||
| Contribution1Description | varchar | 80 | null |
|
|
|||
| Contribution1Amount | money | 21,4 | null |
|
|
|||
| Contribution2Description | varchar | 80 | null |
|
|
|||
| Contribution2Amount | money | 21,4 | null |
|
|
|||
| ContributionAddTotalFlag | bit | 1 | null |
|
|
|||
| InstalCurrentStatementOnlyFlag | bit | 1 | null |
|
|
|||
| FullYearDiscountPercentage | decimal | 7,2 | null |
|
|
|||
| FullYearDiscountExpiryDate | datetime | 16,3 | √ | null |
|
|
||
| DiscountPercentage | decimal | 7,2 | null |
|
|
|||
| DiscountExpiryDate | datetime | 16,3 | √ | null |
|
|
||
| Contribution1GLCode | varchar | 15 | null |
|
|
|||
| Contribution2GLCode | varchar | 15 | null |
|
|
|||
| Contribution1TaxCode | varchar | 5 | null |
|
|
|||
| Contribution2TaxCode | varchar | 5 | null |
|
|
|||
| StatementGroup2 | varchar | 10 | null |
|
|
|||
| StatementGroup3 | varchar | 10 | null |
|
|
|||
| StatementGroup4 | varchar | 10 | null |
|
|
|||
| StatementGroupIncludeFlag | bit | 1 | null |
|
|
|||
| AllStatementGroupsFlag | bit | 1 | null |
|
|
|||
| PrintIfNegativeFlag | bit | 1 | null |
|
|
|||
| PrintIfZeroBalanceFlag | bit | 1 | null |
|
|
|||
| PrintIfArrangementsExistFlag | bit | 1 | null |
|
|
|||
| MinBalance | money | 21,4 | null |
|
|
|||
| PrintChargesOrReceiptsFlag | bit | 1 | null |
|
|
|||
| PrintChargesFlag | bit | 1 | null |
|
|
|||
| PrintChgRcptOrNonZeroFlag | bit | 1 | null |
|
|
|||
| ContributionEldestOnlyFlag | bit | 1 | null |
|
|
|||
| ContributionEachStudentFlag | bit | 1 | null |
|
|
|||
| DebtorSubLedgerCode | varchar | 15 | null |
|
|
|||
| GeneratedDate | datetime | 16,3 | √ | null |
|
|
||
| GeneratedByID | int | 4 | √ | null |
|
|
||
| PortalPublishDate | datetime | 16,3 | √ | null |
|
|
||
| PortalPublishByID | int | 4 | √ | null |
|
|
||
| ViewOriginalDate | datetime | 16,3 | √ | null |
|
|
||
| ViewOriginalByID | int | 4 | √ | null |
|
|
||
| StoreDate | datetime | 16,3 | √ | null |
|
|
||
| StoreByID | int | 4 | √ | null |
|
|
||
| ViewStoreDate | datetime | 16,3 | √ | null |
|
|
||
| ViewStoreByID | int | 4 | √ | null |
|
|
||
| EmailDate | datetime | 16,3 | √ | null |
|
|
||
| EmailByID | int | 4 | √ | null |
|
|
||
| PrintDate | datetime | 16,3 | √ | null |
|
|
||
| PrintByID | int | 4 | √ | null |
|
|
||
| StatementEmailType | varchar | 20 | null |
|
|
|||
| StatementEmailFrom | varchar | 100 | null |
|
|
|||
| StatementEmailBCC | varchar | 100 | null |
|
|
|||
| StatementEmailFromName | varchar | 100 | null |
|
|
|||
| StatementEmailSubject | varchar | 255 | null |
|
|
|||
| StatementEmailBody | varchar | 1000 | null |
|
|
|||
| InvoiceGeneratedDate | datetime | 16,3 | √ | null |
|
|
||
| InvoiceGeneratedByID | int | 4 | √ | null |
|
|
||
| InvoiceViewOriginalDate | datetime | 16,3 | √ | null |
|
|
||
| InvoiceViewOriginalByID | int | 4 | √ | null |
|
|
||
| InvoiceStoreDate | datetime | 16,3 | √ | null |
|
|
||
| InvoiceStoreByID | int | 4 | √ | null |
|
|
||
| InvoiceViewStoreDate | datetime | 16,3 | √ | null |
|
|
||
| InvoiceViewStoreByID | int | 4 | √ | null |
|
|
||
| ReminderSourceStatementNumber | int | 4 | √ | null |
|
|
||
| ReminderNumber | tinyint | 1 | null |
|
|
|||
| DebtorSubLedgerCodeDisplay | varchar | 15 | √ | null |
|
|
||
| DebtorSubLedgerDescription | varchar | 100 | √ | null |
|
|
||
| DefaultStatementGroup | varchar | 15 | √ | null |
|
|
||
| DebtorSubLedgerActiveFlag | bit | 1 | √ | null |
|
|
||
| DebtorStatementReportSuffix | varchar | 10 | √ | null |
|
|
||
| InvoiceStationeryReportSuffix | varchar | 10 | √ | null |
|
|
||
| DebtorStatementReport | varchar | 15 | √ | null |
|
|
||
| InvoiceStationeryReport | varchar | 17 | √ | null |
|
|
||
| DebtorStatementUnderlayFile | varchar | 255 | √ | null |
|
|
||
| DebtorStatementApplyUnderlayMain | varchar | 1 | null |
|
|
|||
| DebtorStatementApplyUnderlayHeader | varchar | 1 | null |
|
|
|||
| varchar | 1 | null |
|
|
||||
| DebtorInvoiceUnderlayFile | varchar | 255 | √ | null |
|
|
||
| DebtorInvoiceApplyUnderlayMain | varchar | 1 | null |
|
|
|||
| DebtorInvoiceApplyUnderlayHeader | varchar | 1 | null |
|
|
|||
| varchar | 1 | null |
|
|
Table contained 0 rows