vDebtorTransactionAddress


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
DebtorCreatedDate datetime 16,3 √ null
DebtorCreatedBy varchar 50 √ null
DebtorModifiedDate datetime 16,3 √ null
DebtorModifiedBy varchar 50 √ null
DebtorPrimaryOnlyFlag bit 1 null
DebtorStatementGroup varchar 10 null
DebtorStatus varchar 3 null
DebtorLastPaymentDate datetime 16,3 √ null
DebtorLastPaymentAmount money 21,4 null
DebtorArrangementActiveFlag bit 1 null
DebtorLastOverdueLetterCode varchar 5 null
DebtorLastOverdueLetterDate datetime 16,3 √ null
DebtorAllowReceiptPrintFlag bit 1 null
DebtorAllowReminderFlag bit 1 null
DebtorAllowInterestFlag bit 1 null
DebtorAllowDeleteFlag bit 1 null
DebtorReferenceType varchar 3 null
DebtorReference varchar 60 null
DebtorPrepaid money 21,4 null
DebtorCurrentBalance money 21,4 null
DebtorTransactionSeq int 4 √ null
DebtorTransactionStudentID int 4 √ null
DebtorTransactionPostingNumber int 4 √ null
DebtorTransactionPostingSource varchar 10 √ null
DebtorTransactionPostingDate datetime 16,3 √ null
DebtorTransactionInstalmentSeq int 4 √ null
DebtorTransactionInstalmentsRemaining smallint 2 √ null
DebtorTransactionStatementNumber int 4 √ null
DebtorTransactionReceiptNumber int 4 √ null
DebtorTransactionFeeCode varchar 15 √ null
DebtorTransactionDate datetime 16,3 √ null
DebtorTransactionAmount money 21,4 √ null
DebtorTransactionAllocatedAmount money 21,4 √ null
DebtorTransactionTaxAmount money 21,4 null
DebtorTransactionStudentNameInternal varchar 100 √ null
DebtorTransactionStudentNameExternal varchar 100 √ null
DebtorTransactionStudentLegalFullName varchar 150 √ null
DebtorTransactionStudentPreferred varchar 20 √ null
DebtorTransactionStudentPreferredFormal varchar 20 √ null
DebtorTransactionStudentSurname varchar 30 √ null
DebtorTransactionDescription varchar 80 √ null
DebtorTransactionFullDescription varchar 186 √ null
DebtorMailName varchar 100 √ null
DebtorMailSalutation varchar 100 √ null
DebtorAddressComma varchar 8000 √ null
DebtorAddressFull varchar 602 √ null
DebtorSuburb varchar 8000 √ null
DebtorPostcode varchar 8000 √ null
DebtorCountryCode varchar 8000 √ 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
DebtorHomePhone varchar 15 √ null
DebtorHomeFax varchar 15 √ null
DebtorMobilePhone varchar 15 √ null
DebtorHomeEmail varchar 100 √ 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
DebtorDeceasedFlag bit 1 √ null
DebtorTransactionStatementDate datetime 16,3 √ null
DebtorSpouseNameInternal varchar 100 √ null
DebtorSpouseNameExternal varchar 100 √ null
DebtorSpouseLegalFullName varchar 150 √ null
DebtorSpouseSurname varchar 30 √ null
DebtorSpouseTitle varchar 30 √ null
DebtorSpouseInitials varchar 15 √ null
DebtorSpouseSuffix varchar 20 √ null
DebtorSpousePreferred varchar 20 √ null
DebtorSpousePreferredFormal varchar 20 √ null
DebtorSpouseGiven1 varchar 20 √ null
DebtorSpouseGiven2 varchar 50 √ null
DebtorSpouseGender varchar 15 √ null
DebtorSpouseHomePhone varchar 15 √ null
DebtorSpouseHomeFax varchar 15 √ null
DebtorSpouseMobilePhone varchar 15 √ null
DebtorSpouseHomeEmail varchar 100 √ null
DebtorSpouseOccupCode varchar 15 √ null
DebtorSpouseOccupDesc varchar 50 √ null
DebtorSpouseOccupCompany varchar 50 √ null
DebtorSpouseOccupIndustryCode varchar 8 √ null
DebtorSpouseOccupPositionCode varchar 8 √ null
DebtorSpouseOccupPhone varchar 15 √ null
DebtorSpouseOccupFax varchar 15 √ null
DebtorSpouseOccupMobilePhone varchar 15 √ null
DebtorSpouseOccupEmail varchar 100 √ null
DebtorSpouseDeceasedFlag bit 1 √ null
DebtorBPayReference varchar 21 null

Table contained 0 rows

View Definition

Possibly Referenced Tables/Views