<div>
You may check below reference, might find some pointers to build your query<br />
<br />
<a href="https://www.gptablereference.com/" rel="ugc">https://www.gptablereference.com/</a><br />
<a href="http://victoriayudin.com/gp-tables/" rel="ugc">http://victoriayudin.com/gp-tables/</a>
</div>


You may check below reference, might find some pointers to build your query

https://www.gptablereference.com/ [https://www.gptablereference.com/]
http://victoriayudin.com/gp-tables/ [http://victoriayudin.com/gp-tables/]

<div>
I think you can use this view to get everything you need: <a href="http://victoriayudin.com/2009/10/22/sql-view-for-payables-payment-apply-detail-in-dynamics-gp/" rel="ugc">http://victoriayudin.com/2009/10/22/sql-view-for-payables-payment-apply-detail-in-dynamics-gp/</a>
</div>


I think you can use this view to get everything you need: http://victoriayudin.com/2009/10/22/sql-view-for-payables-payment-apply-detail-in-dynamics-gp/ [http://victoriayudin.com/2009/10/22/sql-view-for-payables-payment-apply-detail-in-dynamics-gp/]

<div>
Also, need to pull in Vendor id and address -- sorry I forgot to include that in my request. &nbsp;Victoria, that is the exact view I am using but need the vendor and vendor address as well. &nbsp;Thanks.
</div>


Also, need to pull in Vendor id and address -- sorry I forgot to include that in my request.  Victoria, that is the exact view I am using but need the vendor and vendor address as well.  Thanks.

<div>
I know how to look up SQL views, etc. &nbsp;The internet sites were just regurgitated to me --
</div>


I know how to look up SQL views, etc.  The internet sites were just regurgitated to me --

<div>
<div class="content wysiwyg-content">
I need to run a report for our CFO with vendor name, invoice date, vendor id class, and check number, check date. Could someone help with a SQL script to pull this information.
</div>
</div>


I need to run a report for our CFO with vendor name, invoice date, vendor id class, and check number, check date. Could someone help with a SQL script to pull this information.

Great Plains - GP 2013- SQL tables for Transactions report

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft Dynamics is a line of enterprise resource planning (ERP) and customer relationship management (CRM) software applications. Dynamics can be used with other Microsoft solutions, such as SharePoint, Yammer, Office 365, Azure and Outlook. Dynamics ERP comprises a group of enterprise-resource-planning products includes Dynamics AX (formerly Axapta), a multi-language, multi-currency enterprise software with business management features for financial, human resources, and operations management; Dynamics GP (formerly Great Plains Software); Dynamics NAV (formerly Navision) for financials, supply chain, and people; Dynamics SL (formerly Solomon IV)for project-driven organizations; Dynamics C5 (formerly Concorde C5) for manufacturing, supply chains, analytics and electronic commerce; and Dynamics CRM.