Payments

wdt_ID SerialNumber DateReceived DateIssued GiftAmount EligibleGiftAmount DescriptionOfAdvantage PeopleForeignKey GeneralLedger Program Payment Type
DateReceived DateIssued GiftAmount EligibleGiftAmount DescriptionOfAdvantage PeopleForeignKey GeneralLedger Program Payment Type
wdt_ID GUIDPrimaryKey FirstName MiddleInitial LastName Organization Street1 Street2 City ProvinceState PostalCode Country Email Phone Preferred Communication Active Donor Since Signed up for Mailing list Notes
FirstName MiddleInitial LastName Organization Street1 Street2 City Country Email Phone Preferred Communication Active Donor Since Signed up for Mailing list Notes

StaticFieldsForReceipts

wdt_ID PrimaryKey TaxAgency WebsiteOfTaxAgency OfficialDonationRecept CharitableRegistration CharityName CharityStreetAddress CharityCity CharityProvince CharityZipCode

Country

wdt_ID Name Code
Name Code

Donor List

wdt_ID GUIDPrimaryKey FirstName MiddleInitial LastName Organization Street1 Street2 City ProvinceState PostalCode Country Email Phone Preferred Communication Active Donor Since Signed up for Mailing list Notes
FirstName MiddleInitial LastName Organization Street1 Street2 City Country Email Phone Preferred Communication Active Donor Since Signed up for Mailing list Notes

Donation/Payment List

Payments

wdt_ID SerialNumber DateReceived DateIssued GiftAmount EligibleGiftAmount DescriptionOfAdvantage PeopleForeignKey GeneralLedger Program Payment Type
DateReceived DateIssued GiftAmount EligibleGiftAmount DescriptionOfAdvantage PeopleForeignKey GeneralLedger Program Payment Type

Test SQL Generated Table