Looking for table: plan + contribution

Hi Techies,

I'm working on a procedure to automatically assign some donor constituencies. A needed criteria is the resulting donations from a plan, and the attributes of that plan. A worker can relate a contribution to a plan in the Tess Client, but I dont know where that data is stored.

Is there a table with the donation ref_no and the plan_no? I think that there should be, but I dont know what its called.

Thanks,

Aaron