What table can I find matching gifts and soft credits in? I'm trying to extract some contribution data for a resident company and he wants the totals to include soft credits and matching gifts. I don't see anything for that in the t_contribution table. Where can I find this so I can add it to my query? I'm in a bit of a time crunch and need to get this done today, so if anyone has a quick answer....I'd greatly appreciate it!!!
Teresa
I think you're looking for t_creditee, and tr_creditee_type to get which type is which (matching, soft credit etc.).
Nevermind everyone...I just thought of it and I believe it's the t_creditee table linking ref_no to t_contribution. It just suddenly came to me!!!
Thanks Amanda……as soon as I sent, it suddenly came to me it was the t_creditee table. Not sure why it took so long for me to figure it out. Thanks for the quick reply!!!!
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Amanda Freeman Sent: Wednesday, June 01, 2011 2:59 PM To: Teresa Dean Subject: Re: [Tessitura Technical Forum] Table to Matching Gifts