Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| DebtorID | int | 4 | √ | null |
|
|
||
| DebtorStudentID | int | 4 | √ | null |
|
|
||
| DebtorCreatedDate | datetime | 16,3 | √ | null |
|
|
||
| DebtorCreatedBy | varchar | 50 | √ | null |
|
|
||
| DebtorModifiedDate | datetime | 16,3 | √ | null |
|
|
||
| DebtorModifiedBy | varchar | 50 | √ | null |
|
|
||
| PrimaryOnlyFlag | bit | 1 | √ | null |
|
|
||
| StatementGroup | varchar | 10 | √ | null |
|
|
||
| Status | varchar | 3 | √ | null |
|
|
||
| LastPaymentDate | datetime | 16,3 | √ | null |
|
|
||
| LastPaymentAmount | money | 21,4 | √ | null |
|
|
||
| ArrangementActiveFlag | bit | 1 | √ | null |
|
|
||
| LastOverdueLetterCode | varchar | 5 | √ | null |
|
|
||
| LastOverdueLetterDate | datetime | 16,3 | √ | null |
|
|
||
| AllowReceiptPrintFlag | bit | 1 | √ | null |
|
|
||
| AllowReminderFlag | bit | 1 | √ | null |
|
|
||
| AllowInterestFlag | bit | 1 | √ | null |
|
|
||
| AllowDebtorDeleteFlag | bit | 1 | √ | null |
|
|
||
| ReferenceType | varchar | 3 | √ | null |
|
|
||
| Reference | varchar | 60 | √ | null |
|
|
||
| Prepaid | money | 21,4 | √ | null |
|
|
||
| CurrentBalance | money | 21,4 | √ | null |
|
|
||
| Comment | varchar | 2147483647 | √ | null |
|
|
||
| AllowVoluntaryContributionFlag | bit | 1 | √ | null |
|
|
||
| NonStudentDebtorFlag | bit | 1 | √ | null |
|
|
||
| PaymentAutoDeductAmount | money | 21,4 | √ | null |
|
|
||
| PaymentAutoDeductFrequency | varchar | 5 | √ | null |
|
|
||
| PaymentAutoDeductNextDate | datetime | 16,3 | √ | null |
|
|
||
| StatementMethod | varchar | 1 | √ | null |
|
|
||
| MailAddressCode | varchar | 1 | √ | null |
|
|
||
| BPAYReference | varchar | 21 | √ | null |
|
|
||
| AgentDepositReference | varchar | 15 | √ | null |
|
|
||
| PaymentAutoDeductHoldFlag | bit | 1 | √ | null |
|
|
||
| PaymentAutoDeductMethod | varchar | 5 | √ | null |
|
|
||
| PaymentAutoDeductStopDate | datetime | 16,3 | √ | null |
|
|
||
| LastOverdueLetterAmount | money | 21,4 | √ | null |
|
|
||
| LastOverdueLetterRefDate | datetime | 16,3 | √ | null |
|
|
||
| LastOverdueLetterDaysBetween | smallint | 2 | √ | null |
|
|
||
| CommentWarningFlag | bit | 1 | √ | null |
|
|
||
| CommentWarningChargesFlag | bit | 1 | √ | null |
|
|
||
| CommentWarningReceiptsFlag | bit | 1 | √ | null |
|
|
||
| TransferBalanceToOtherDatabaseFlag | bit | 1 | √ | null |
|
|
||
| AllowCreditInterestFlag | bit | 1 | √ | null |
|
|
||
| SystemProcessNumberCreate | int | 4 | √ | null |
|
|
||
| ActiveFlag | bit | 1 | √ | null |
|
|
||
| InactiveSystemProcessNumber | int | 4 | √ | null |
|
|
||
| OverrideDebtorName | varchar | 100 | √ | null |
|
|
||
| OverrideInstalmentFreq | varchar | 15 | √ | null |
|
|
||
| OverrideInstalmentCount | smallint | 2 | √ | null |
|
|
||
| OverrideInstalmentDay | smallint | 2 | √ | null |
|
|
||
| NotifyMethod | varchar | 2 | √ | null |
|
|
||
| EmailAddressCode | varchar | 2 | √ | null |
|
|
||
| EmailOverride | varchar | 100 | √ | null |
|
|
||
| EziDebitCreatedDate | datetime | 16,3 | √ | null |
|
|
||
| EziDebitCustomerRef | int | 4 | √ | null |
|
|
||
| AutoDebitAuthorisedDate | datetime | 16,3 | √ | null |
|
|
||
| SpouseEmailAddressCode | varchar | 2 | √ | null |
|
|
||
| AllowOnlinePaymentSelectFlag | bit | 1 | √ | null |
|
|
||
| PaymentPlanRequiredFlag | bit | 1 | √ | null |
|
|
||
| AllowPaymentDiscountFlag | bit | 1 | √ | null |
|
|
||
| AllowPortalPaymentPlansFlag | bit | 1 | √ | null |
|
|
||
| SystemProcessNumberMode | varchar | 1 | √ | null |
|
|
||
| AllowSales | varchar | 1 | √ | null |
|
|
||
| TransactionMode | char | 1 | √ | null |
|
|
Table contained -1 rows