Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| DebtorID | int | 4 | null |
|
|
|||
| DebtorStudentID | int | 4 | null |
|
|
|||
| DebtorIDFull | varchar | 15 | √ | null |
|
|
||
| DebtorName | varchar | 100 | √ | null |
|
|
||
| OverrideDebtorName | varchar | 100 | null |
|
|
|||
| OverrideDebtorNameFlag | bit | 1 | √ | null |
|
|
||
| Surname | varchar | 30 | √ | null |
|
|
||
| Given1 | varchar | 20 | √ | null |
|
|
||
| Preferred | varchar | 20 | √ | null |
|
|
||
| WebSite | varchar | 100 | √ | null |
|
|
||
| DebtorSubLedgerCode | varchar | 15 | √ | null |
|
|
||
| DebtorSubLedgerCodeDisplay | varchar | 15 | √ | null |
|
|
||
| DebtorSubLedgerDebtorStudentID | 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 |
|
|
|||
| AllowSales | varchar | 1 | null |
|
|
|||
| AllowSalesFlag | bit | 1 | √ | null |
|
|
||
| AllowCreditInterestFlag | bit | 1 | null |
|
|
|||
| SystemProcessNumberCreate | int | 4 | null |
|
|
|||
| ActiveFlag | bit | 1 | null |
|
|
|||
| InactiveSystemProcessNumber | int | 4 | null |
|
|
|||
| AddressComma | varchar | 8000 | √ | null |
|
|
||
| AddressFull | varchar | 602 | √ | null |
|
|
||
| AddressDPID | varchar | 8 | √ | null |
|
|
||
| AddressDPIDBarcode | varchar | 60 | √ | null |
|
|
||
| AddressSortPlanNumber | varchar | 10 | √ | null |
|
|
||
| AddressPAFVersion | varchar | 10 | √ | null |
|
|
||
| OverrideInstalmentFreq | varchar | 15 | null |
|
|
|||
| OverrideInstalmentCount | smallint | 2 | √ | null |
|
|
||
| OverrideInstalmentDay | smallint | 2 | √ | null |
|
|
||
| NotifyMethod | varchar | 2 | null |
|
|
|||
| EmailAddressCode | varchar | 2 | null |
|
|
|||
| EmailAddress | varchar | 201 | √ | null |
|
|
||
| EmailOverride | varchar | 100 | null |
|
|
|||
| EziDebitCreatedDate | datetime | 16,3 | √ | null |
|
|
||
| EziDebitCreatedFlag | bit | 1 | √ | null |
|
|
||
| EziDebitCustomerRef | int | 4 | √ | null |
|
|
||
| AutoDebitAuthorisedDate | datetime | 16,3 | √ | null |
|
|
||
| Address1 | varchar | 8000 | √ | null |
|
|
||
| Address2 | varchar | 8000 | √ | null |
|
|
||
| Suburb | varchar | 8000 | √ | null |
|
|
||
| State | varchar | 8000 | √ | null |
|
|
||
| PostCode | varchar | 8000 | √ | null |
|
|
||
| CountryCode | varchar | 8000 | √ | null |
|
|
||
| SilentMobilePhoneFlag | bit | 1 | √ | null |
|
|
||
| SilentOccupMobilePhoneFlag | bit | 1 | √ | null |
|
|
||
| SilentPhoneFlag | bit | 1 | √ | null |
|
|
||
| SilentHomeAddressFlag | bit | 1 | √ | null |
|
|
||
| SilentAddressFlag | bit | 1 | √ | null |
|
|
||
| SilentAddressText | varchar | 8000 | √ | null |
|
|
||
| SilentMobileText | varchar | 8000 | √ | null |
|
|
||
| SilentPhoneText | varchar | 8000 | √ | null |
|
|
||
| SpouseEmailAddressCode | varchar | 2 | null |
|
|
|||
| AllowOnlinePaymentSelectFlag | bit | 1 | null |
|
|
Table contained 0 rows