Payments

wdt_ID SerialNumber DateReceived DateIssued GiftAmount EligibleGiftAmount DescriptionOfAdvantage PeopleForeignKey GeneralLedger Program Payment Type
7 19366 21/02/2005 11:10 AM 21/02/2005 11:10 AM 50.00 50.00 Cheque Jim
6 16281 23/02/2004 12:08 PM 23/02/2004 12:08 PM 20.00 20.00 Cash Jim
9 03/12/2019 05:19 PM 03/12/2019 05:19 PM 66.66 100.00
10 454 09/12/2019 03:06 PM 10/12/2019 04:48 PM 100.00 100.00 Cash
11 131235 10/12/2019 10:59 AM 12/12/2019 10:59 AM 100.00 100.00 Cash Ammar
12 09/12/2019 03:35 PM 16/12/2019 03:35 PM 99,999.99 99,999.99 None Jason
13
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
1 156423748 Jason Paul Lum Trump International Inc. 123 Young RD Chilliwack British Columbia g3h5d7 Canada Email No
2 784521 Test N Tester 213 Fake St Abbotsford British Columbia h4j9k0 Canada Email No
3 1354315 Foreign T Test 123 Kar Ave Vancouver British Columbia h1j3k0 Canada Email No
4 999 Jim Adam 10046 Llanberis Way Rosedale British Columbia V0X1X0 Canada Email No
5 1564541561 Ammar J Nabod 123 Young Rd Chilliwack British Columbia h0h0h0 Canada Email No
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
1 1 Canada Revenue Agency canada.ca/charities-giving Official donation receipt for income tax purposes 118852797 RR 0001 CHILLIWACK COMMUNITY SERVICES 45938 WELLINGTON AVENUE CHILLIWACK BC V2P2C7

Country

wdt_ID Name Code
1 Afghanistan AF
2 Åland Islands AX
3 Albania AL
4 Algeria DZ
5 American Samoa AS
6 Andorra AD
7 Angola AO
8 Anguilla AI
9 Antarctica AQ
10 Antigua and Barbuda AG
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
1 156423748 Jason Paul Lum Trump International Inc. 123 Young RD Chilliwack British Columbia g3h5d7 Canada Email No
2 784521 Test N Tester 213 Fake St Abbotsford British Columbia h4j9k0 Canada Email No
3 1354315 Foreign T Test 123 Kar Ave Vancouver British Columbia h1j3k0 Canada Email No
4 999 Jim Adam 10046 Llanberis Way Rosedale British Columbia V0X1X0 Canada Email No
5 1564541561 Ammar J Nabod 123 Young Rd Chilliwack British Columbia h0h0h0 Canada Email No
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
7 19366 21/02/2005 11:10 AM 21/02/2005 11:10 AM 50.00 50.00 Cheque Jim
6 16281 23/02/2004 12:08 PM 23/02/2004 12:08 PM 20.00 20.00 Cash Jim
9 03/12/2019 05:19 PM 03/12/2019 05:19 PM 66.66 100.00
10 454 09/12/2019 03:06 PM 10/12/2019 04:48 PM 100.00 100.00 Cash
11 131235 10/12/2019 10:59 AM 12/12/2019 10:59 AM 100.00 100.00 Cash Ammar
12 09/12/2019 03:35 PM 16/12/2019 03:35 PM 99,999.99 99,999.99 None Jason
13
DateReceived DateIssued GiftAmount EligibleGiftAmount DescriptionOfAdvantage PeopleForeignKey GeneralLedger Program Payment Type

Test SQL Generated Table