vDonorRecentReceiptsCommunityAddresses


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID int 4 null
IDType varchar 1 null
SpouseFlag bit 1 null
NameInternal varchar 100 null
NameExternal varchar 100 null
LegalFullName varchar 150 null
Surname varchar 30 null
SurnamePrevious varchar 30 null
Title varchar 30 null
Initials varchar 15 null
Suffix varchar 20 null
Preferred varchar 20 null
PreferredFormal varchar 20 null
Given1 varchar 20 null
Given2 varchar 50 null
BirthDate datetime 16,3 √ null
DeceasedDate datetime 16,3 √ null
DeceasedFlag bit 1 null
Gender varchar 15 null
MobilePhone varchar 15 null
DefaultMobilePhone varchar 15 null
SilentMobilePhoneFlag bit 1 null
Email varchar 100 null
ReligionCode varchar 5 null
CountryOfBirthCode varchar 5 null
HomeLanguageCode varchar 5 null
NationalityCode varchar 5 null
Nationality2Code varchar 5 null
Education varchar 255 null
Qualifications varchar 255 null
HighestSecondaryYearLevel tinyint 1 null
HighestQualificationLevel varchar 15 null
LastYearOfStudy int 4 null
MaritalStatus varchar 1 null
MailNamePrimary varchar 100 null
MailNameJoint varchar 100 null
MailSalutationPrimary varchar 100 null
MailSalutationJoint varchar 100 null
Comment varchar 2147483647 √ null
Biography varchar 2147483647 √ null
ParishCode varchar 5 null
OccupCode varchar 15 √ null
OccupCodeDesc varchar 120 √ null
OccupDesc varchar 50 null
OccupDescIncludeInAddressFlag bit 1 null
OccupCompany varchar 50 null
OccupCompanyAttn varchar 40 null
OccupIndustryCode varchar 8 null
OccupPositionCode varchar 8 null
OccupPhone varchar 15 null
OccupFax varchar 15 null
OccupEmail varchar 100 null
OccupAddressFull varchar 200 null
OccupAddressComma varchar 200 null
OccupSuburb varchar 40 null
OccupState varchar 5 √ null
OccupCountryCode varchar 5 null
OccupPostCode varchar 5 null
OccupMobilePhone varchar 15 null
SilentOccupMobilePhoneFlag bit 1 null
OccupAddressDPID varchar 8 null
OccupAddressDPIDBarcode varchar 60 null
OccupAddressSortPlanNumber varchar 3 null
OccupAddressPAFVersion varchar 10 null
DirectoryIncludeFlag bit 1 null
DirectoryProvideFlag bit 1 null
PublishToAssociatedFlag bit 1 null
DefaultEmail varchar 201 null
SpouseID int 4 null
WebSite varchar 100 null
SpouseNameInternal varchar 100 √ null
SpouseNameExternal varchar 100 √ null
SpouseLegalFullName varchar 150 √ null
SpouseSurname varchar 30 √ null
SpouseSurnamePrevious varchar 30 √ null
SpouseTitle varchar 30 √ null
SpouseInitials varchar 15 √ null
SpouseSuffix varchar 20 √ null
SpousePreferred varchar 20 √ null
SpousePreferredFormal varchar 20 √ null
SpouseGiven1 varchar 20 √ null
SpouseGiven2 varchar 50 √ null
SpouseBirthDate datetime 16,3 √ null
SpouseDeceasedDate datetime 16,3 √ null
SpouseDeceasedFlag bit 1 √ null
SpouseGender varchar 15 √ null
SpouseMobilePhone varchar 15 √ null
SpouseDefaultMobilePhone varchar 15 √ null
SpouseEmail varchar 100 √ null
SpouseReligionCode varchar 5 √ null
SpouseCountryOfBirthCode varchar 5 √ null
SpouseHomeLanguageCode varchar 5 √ null
SpouseNationalityCode varchar 5 √ null
SpouseNationality2Code varchar 5 √ null
SpouseEducation varchar 255 √ null
SpouseQualifications varchar 255 √ null
SpouseHighestSecondaryYearLevel tinyint 1 √ null
SpouseHighestQualificationLevel varchar 15 √ null
SpouseLastYearOfStudy int 4 √ null
SpouseMaritalStatus varchar 1 √ null
SpouseComment varchar 2147483647 √ null
SpouseBiography varchar 2147483647 √ null
SpouseParishCode varchar 5 √ null
SpouseMailNamePrimary varchar 100 √ null
SpouseMailSalutationPrimary varchar 100 √ null
SpouseOccupAddressFull varchar 200 √ null
SpouseOccupAddressComma varchar 200 √ null
SpouseOccupCode varchar 15 √ null
OccupSpouseCodeDesc varchar 120 √ null
SpouseOccupDesc varchar 50 √ null
SpouseOccupCompany varchar 50 √ null
SpouseOccupCompanyAttn varchar 40 √ null
SpouseOccupIndustryCode varchar 8 √ null
SpouseOccupPositionCode varchar 8 √ null
SpouseOccupPhone varchar 15 √ null
SpouseOccupFax varchar 15 √ null
SpouseOccupEmail varchar 100 √ null
SpouseOccupState varchar 5 √ null
SpouseOccupCountryCode varchar 5 √ null
SpouseOccupPostCode varchar 5 √ null
SpouseOccupMobilePhone varchar 15 √ null
SpouseOccupSuburb varchar 40 √ null
SpouseOccupAddressDPID varchar 8 √ null
SpouseOccupAddressDPIDBarcode varchar 60 √ null
SpouseOccupAddressSortPlanNumber varchar 3 √ null
SpouseOccupAddressPAFVersion varchar 10 √ null
SpousePublishToAssociatedFlag bit 1 √ null
SpouseDirectoryIncludeFlag bit 1 √ null
SpouseDirectoryProvideFlag bit 1 √ null
SpouseDefaultEmail varchar 201 √ null
SpouseWebSite varchar 100 √ null
AddressID int 4 null
Address1 varchar 40 null
Address2 varchar 40 null
Address3 varchar 40 null
Suburb varchar 40 null
State varchar 5 null
CountryCode varchar 5 null
PostCode varchar 5 null
AddressComma varchar 200 √ null
AddressFull varchar 200 √ null
AddressDPID varchar 8 null
AddressDPIDBarcode varchar 60 null
AddressSortPlanNumber varchar 3 null
AddressPAFVersion varchar 10 null
HomeAddress1 varchar 40 null
HomeAddress2 varchar 40 null
HomeAddress3 varchar 40 null
HomeSuburb varchar 40 null
HomeState varchar 5 null
HomeCountryCode varchar 5 null
HomePostCode varchar 5 null
HomeAddressComma varchar 200 √ null
HomeAddressFull varchar 200 √ null
HomeAddressDPID varchar 8 null
HomeAddressDPIDBarcode varchar 60 null
HomeAddressSortPlanNumber varchar 3 null
HomeAddressPAFVersion varchar 10 null
HomePhone varchar 15 √ null
HomePhoneAlt varchar 15 null
HomeFax varchar 15 null
SilentPhoneFlag bit 1 null
AddressComment varchar 250 null
MailFlag bit 1 null
MagazineFlag bit 1 null
SolicitationFlag bit 1 null
RaffleFlag bit 1 null
ValidAddressFlag bit 1 null
SilentHomeAddressFlag bit 1 null
PhoneActual varchar 15 null
ConstitCodes varchar 200 √ null
WorkWithChildrenCheckStatus varchar 15 null
WorkWithChildrenCheckRegistrationNumber varchar 30 null
WorkWithChildrenCheckExpiryDate datetime 16,3 √ null
SpouseWorkWithChildrenCheckStatus varchar 15 √ null
SpouseWorkWithChildrenCheckRegistrationNumber varchar 30 √ null
SpouseWorkWithChildrenCheckExpiryDate datetime 16,3 √ null
CountryDescription varchar 40 √ null
HomeCountryDescription varchar 40 √ null
OccupCountryDescription varchar 40 √ null
ReceiptTotal money 21,4 √ null
DonationCount int 4 √ null
FirstDonationDate datetime 16,3 √ null
FoundationBasis money 21,4 √ null
LastReceipt1Date datetime 16,3 √ null
LastReceipt1Appeal varchar 10 √ null
LastReceipt1Fund varchar 15 √ null
LastReceipt1Amount money 21,4 √ null
LastReceipt1AnonymousFlag int 4 √ null
LastReceipt1ReceiptNo varchar 10 √ null
LastReceipt1Comments varchar 2000 √ null
LastReceipt1IDJoint int 4 √ null
LastReceipt2Date datetime 16,3 √ null
LastReceipt2Appeal varchar 10 √ null
LastReceipt2Fund varchar 15 √ null
LastReceipt2Amount money 21,4 √ null
LastReceipt2AnonymousFlag int 4 √ null
LastReceipt2ReceiptNo varchar 10 √ null
LastReceipt2Comments varchar 2000 √ null
LastReceipt2IDJoint int 4 √ null
LastReceipt3Date datetime 16,3 √ null
LastReceipt3Appeal varchar 10 √ null
LastReceipt3Fund varchar 15 √ null
LastReceipt3Amount money 21,4 √ null
LastReceipt3AnonymousFlag int 4 √ null
LastReceipt3ReceiptNo varchar 10 √ null
LastReceipt3Comments varchar 2000 √ null
LastReceipt3IDJoint int 4 √ null
LastReceipt4Date datetime 16,3 √ null
LastReceipt4Appeal varchar 10 √ null
LastReceipt4Fund varchar 15 √ null
LastReceipt4Amount money 21,4 √ null
LastReceipt4AnonymousFlag int 4 √ null
LastReceipt4ReceiptNo varchar 10 √ null
LastReceipt4Comments varchar 2000 √ null
LastReceipt4IDJoint int 4 √ null
LastReceipt5Date datetime 16,3 √ null
LastReceipt5Appeal varchar 10 √ null
LastReceipt5Fund varchar 15 √ null
LastReceipt5Amount money 21,4 √ null
LastReceipt5AnonymousFlag int 4 √ null
LastReceipt5ReceiptNo varchar 10 √ null
LastReceipt5Comments varchar 2000 √ null
LastReceipt5IDJoint int 4 √ null
LastReceipt6Date datetime 16,3 √ null
LastReceipt6Appeal varchar 10 √ null
LastReceipt6Fund varchar 15 √ null
LastReceipt6Amount money 21,4 √ null
LastReceipt6AnonymousFlag int 4 √ null
LastReceipt6ReceiptNo varchar 10 √ null
LastReceipt6Comments varchar 2000 √ null
LastReceipt6IDJoint int 4 √ null
LastReceipt7Date datetime 16,3 √ null
LastReceipt7Appeal varchar 10 √ null
LastReceipt7Fund varchar 15 √ null
LastReceipt7Amount money 21,4 √ null
LastReceipt7AnonymousFlag int 4 √ null
LastReceipt7ReceiptNo varchar 10 √ null
LastReceipt7Comments varchar 2000 √ null
LastReceipt7IDJoint int 4 √ null
LastReceipt8Date datetime 16,3 √ null
LastReceipt8Appeal varchar 10 √ null
LastReceipt8Fund varchar 15 √ null
LastReceipt8Amount money 21,4 √ null
LastReceipt8AnonymousFlag int 4 √ null
LastReceipt8ReceiptNo varchar 10 √ null
LastReceipt8Comments varchar 2000 √ null
LastReceipt8IDJoint int 4 √ null
LastReceipt9Date datetime 16,3 √ null
LastReceipt9Appeal varchar 10 √ null
LastReceipt9Fund varchar 15 √ null
LastReceipt9Amount money 21,4 √ null
LastReceipt9AnonymousFlag int 4 √ null
LastReceipt9ReceiptNo varchar 10 √ null
LastReceipt9Comments varchar 2000 √ null
LastReceipt9IDJoint int 4 √ null
LastReceipt10Date datetime 16,3 √ null
LastReceipt10Appeal varchar 10 √ null
LastReceipt10Fund varchar 15 √ null
LastReceipt10Amount money 21,4 √ null
LastReceipt10AnonymousFlag int 4 √ null
LastReceipt10ReceiptNo varchar 10 √ null
LastReceipt10Comments varchar 2000 √ null
LastReceipt10IDJoint int 4 √ null

Table contained 0 rows

View Definition

Possibly Referenced Tables/Views