Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| DebtorID | int | 4 | null |
|
|
|||
| DebtorStudentID | int | 4 | null |
|
|
|||
| DebtorSubLedgerCode | varchar | 15 | √ | null |
|
|
||
| DebtorSubLedgerCodeDisplay | varchar | 15 | √ | null |
|
|
||
| DebtorStatementGroup | varchar | 10 | null |
|
|
|||
| DebtorStatus | varchar | 3 | null |
|
|
|||
| BPAYReference | varchar | 21 | null |
|
|
|||
| DebtorNameInternal | varchar | 100 | null |
|
|
|||
| DebtorNameExternal | varchar | 100 | null |
|
|
|||
| DebtorLegalFullName | varchar | 150 | null |
|
|
|||
| DebtorSurname | varchar | 30 | null |
|
|
|||
| DebtorTitle | varchar | 30 | null |
|
|
|||
| DebtorInitials | varchar | 15 | null |
|
|
|||
| DebtorSuffix | varchar | 20 | null |
|
|
|||
| DebtorPreferred | varchar | 20 | null |
|
|
|||
| DebtorPreferredFormal | varchar | 20 | null |
|
|
|||
| DebtorGiven1 | varchar | 20 | null |
|
|
|||
| DebtorGiven2 | varchar | 50 | null |
|
|
|||
| DebtorGender | varchar | 15 | null |
|
|
|||
| DebtorCreatedDate | datetime | 16,3 | √ | null |
|
|
||
| DebtorCreatedBy | varchar | 50 | √ | null |
|
|
||
| DebtorModifiedDate | datetime | 16,3 | √ | null |
|
|
||
| DebtorModifiedBy | varchar | 50 | √ | null |
|
|
||
| DebtorAllowReceiptPrintFlag | bit | 1 | null |
|
|
|||
| DebtorAllowReminderFlag | bit | 1 | null |
|
|
|||
| DebtorAllowInterestFlag | bit | 1 | null |
|
|
|||
| DebtorAllowDeleteFlag | bit | 1 | null |
|
|
|||
| DebtorActiveFlag | bit | 1 | null |
|
|
|||
| DebtorReferenceType | varchar | 3 | null |
|
|
|||
| DebtorReference | varchar | 60 | null |
|
|
|||
| DebtorPrepaid | money | 21,4 | null |
|
|
|||
| DebtorCurrentBalance | money | 21,4 | null |
|
|
|||
| DebtorNotifiedBalance | money | 21,4 | √ | null |
|
|
||
| DebtorLastPaymentDate | datetime | 16,3 | √ | null |
|
|
||
| DebtorLastPaymentAmount | money | 21,4 | null |
|
|
|||
| DebtorArrangementActiveFlag | bit | 1 | null |
|
|
|||
| DebtorLastOverdueLetterCode | varchar | 5 | null |
|
|
|||
| DebtorLastOverdueLetterDate | datetime | 16,3 | √ | null |
|
|
||
| DebtorLastOverdueLetterAmount | money | 21,4 | null |
|
|
|||
| DebtorLastOverdueLetterRefDate | datetime | 16,3 | √ | null |
|
|
||
| DebtorLastOverdueLetterDaysBetween | smallint | 2 | null |
|
|
|||
| DebtorMailName | varchar | 100 | √ | null |
|
|
||
| OverrideDebtorName | varchar | 100 | null |
|
|
|||
| DebtorPrimaryOnlyFlag | bit | 1 | null |
|
|
|||
| DebtorMailSalutation | varchar | 100 | √ | null |
|
|
||
| DebtorAddressComma | varchar | 8000 | √ | null |
|
|
||
| DebtorAddressFull | varchar | 602 | √ | null |
|
|
||
| DebtorAddressDPID | varchar | 8 | √ | null |
|
|
||
| DebtorAddressDPIDBarcode | varchar | 60 | √ | null |
|
|
||
| DebtorAddressSortPlanNumber | varchar | 10 | √ | null |
|
|
||
| DebtorAddressPAFVersion | varchar | 10 | √ | null |
|
|
||
| DebtorSuburb | varchar | 40 | √ | null |
|
|
||
| DebtorPostcode | varchar | 5 | √ | null |
|
|
||
| DebtorCountryCode | varchar | 5 | √ | null |
|
|
||
| DebtorMailAddressCode | varchar | 1 | null |
|
|
|||
| DebtorOccupCode | varchar | 15 | √ | null |
|
|
||
| DebtorOccupDesc | varchar | 50 | null |
|
|
|||
| DebtorOccupCompany | varchar | 50 | null |
|
|
|||
| DebtorOccupIndustryCode | varchar | 8 | null |
|
|
|||
| DebtorOccupPositionCode | varchar | 8 | null |
|
|
|||
| DebtorOccupPhone | varchar | 15 | null |
|
|
|||
| DebtorOccupFax | varchar | 15 | null |
|
|
|||
| DebtorOccupMobilePhone | varchar | 15 | null |
|
|
|||
| DebtorOccupEmail | varchar | 100 | null |
|
|
|||
| DebtorHomePhone | varchar | 15 | √ | null |
|
|
||
| DebtorHomeFax | varchar | 15 | √ | null |
|
|
||
| DebtorMobilePhone | varchar | 15 | null |
|
|
|||
| DebtorHomeEmail | varchar | 100 | null |
|
|
|||
| DebtorSpouseNameInternal | varchar | 100 | √ | null |
|
|
||
| DebtorSpouseNameExternal | varchar | 100 | √ | null |
|
|
||
| DebtorSpouseLegalFullName | varchar | 150 | √ | null |
|
|
||
| DebtorSpouseGiven1 | varchar | 20 | √ | null |
|
|
||
| DebtorSpouseGiven2 | varchar | 50 | √ | null |
|
|
||
| DebtorSpousePreferred | varchar | 20 | √ | null |
|
|
||
| DebtorSpousePreferredFormal | varchar | 20 | √ | null |
|
|
||
| DebtorSpouseSurname | varchar | 30 | √ | null |
|
|
||
| DebtorSpouseMobilePhone | varchar | 15 | √ | null |
|
|
||
| DebtorSpouseOccupPhone | varchar | 15 | √ | null |
|
|
||
| DebtorSpouseOccupMobilePhone | varchar | 15 | √ | null |
|
|
||
| DebtorCommentWarningFlag | bit | 1 | null |
|
|
|||
| DebtorComment | varchar | 2147483647 | √ | null |
|
|
||
| DebtorCommentWarningChargesFlag | bit | 1 | null |
|
|
|||
| DebtorCommentWarningReceiptsFlag | bit | 1 | null |
|
|
|||
| DebtorPaymentAutoDeductAmount | money | 21,4 | null |
|
|
|||
| DebtorPaymentAutoDeductFrequency | varchar | 5 | null |
|
|
|||
| DebtorPaymentAutoDeductNextDate | datetime | 16,3 | √ | null |
|
|
||
| DebtorPaymentAutoDeductHoldFlag | bit | 1 | null |
|
|
|||
| DebtorPaymentAutoDeductMethod | varchar | 5 | null |
|
|
|||
| DebtorPaymentAutoDeductStopDate | datetime | 16,3 | √ | null |
|
|
||
| DebtorEziDebitCreatedDate | datetime | 16,3 | √ | null |
|
|
||
| DebtorEziDebitCreatedFlag | bit | 1 | √ | null |
|
|
||
| DebtorEziDebitCustomerRef | int | 4 | √ | null |
|
|
||
| DebtorAutoDebitAuthorisedDate | datetime | 16,3 | √ | null |
|
|
||
| DebtorAddress1Silent | varchar | 8000 | √ | null |
|
|
||
| DebtorAddress2Silent | varchar | 8000 | √ | null |
|
|
||
| DebtorSuburbSilent | varchar | 8000 | √ | null |
|
|
||
| DebtorPostCodeSilent | varchar | 8000 | √ | null |
|
|
||
| DebtorStateSilent | varchar | 8000 | √ | null |
|
|
||
| DebtorMobilePhoneSilent | varchar | 8000 | √ | null |
|
|
||
| DebtorIDFull | varchar | 15 | √ | null |
|
|
||
| DebtorAllowSales | varchar | 1 | null |
|
|
|||
| DebtorAllowSalesFlag | bit | 1 | √ | null |
|
|
||
| DebtorNotifyMethod | varchar | 2 | null |
|
|
Table contained 0 rows