I see there is a Role in the Contribution records now, but I cannot find where that is stored. I would especially like to use the Cr role to pull up Soft Credit contributions. Where is that coming from?
Jan LaRocque
Houston Symphony
Really? No one know where this comes from? Where this code is stored?
The data you see in the Contributions tab appears to be generated by the sproc AP_CONTRIBUTIONS, which has this parameter:
@included_roles varchar(10) = 'O,I,C' -- O - Owner, I - Initiator, C - Creditee
So, you won't find the literal "O", "Cr", etc., in T_CONTRIBUTION. Rather, I suspect the client displays one or the other based on the output of the above sproc.
Oh, that's too bad that I can't just pull the "Cr" role. That would make my life so much easier.
Thank you for your reply, Chris.