SQL CDFLines and Disbursment checks

Discussions related to custom development with Select.
Post Reply
nathan
Posts: 3
Joined: Thu Jul 28, 2016 9:00 am

SQL CDFLines and Disbursment checks

Post by nathan »

Hello,

I am trying to retrieve Disbursment Check and CDF data from the SelectDb in sql. If anyone has queries or insight into relating Disbursement checks to the CDFLine items they are written for, and if the check has been applied would be much appreciated.
Lisa Ennis
Posts: 84
Joined: Thu Sep 11, 2008 1:57 pm

Re: SQL CDFLines and Disbursment checks

Post by Lisa Ennis »

I recommend looking at the stored procedures rptdoc.DisbursementSummaryByCDFId, and/or the rptdoc.RevenueFeeDetails. These are good starting places for getting information related to the Disbursements and related CDF lines. These are the stored procedures used for readydoc reports and will show the tables and the joins that have this information.
Lisa Ennis
Senior Report Developer
SoftPro
Post Reply