Page 1 of 1

SQL CDFLines and Disbursment checks

Posted: Fri Feb 10, 2017 3:31 pm
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.

Re: SQL CDFLines and Disbursment checks

Posted: Mon Feb 13, 2017 11:45 am
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.