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.
SQL CDFLines and Disbursment checks
-
- Posts: 84
- Joined: Thu Sep 11, 2008 1:57 pm
Re: SQL CDFLines and Disbursment checks
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
Senior Report Developer
SoftPro