Scope Text from the Project Base table into the Client Invoice Base Widget - Cacher Snippet

9/6/2017 - 12:18 PM

Scope Text from the Project Base table into the Client Invoice Base Widget

Scope Text from the Project Base table into the Client Invoice Base Widget

Ajera-clientbase-Scope-Text.sql

/* Courtesy MJ Brennan posted to https://www.linkedin.com/groups/1276507 */
/* Client Base */

SELECT cast(dbo.AxInvoiceGroup.igScopeOfWork as varchar(1000))
FROM dbo.AxInvoiceGroup INNER JOIN
dbo.AxClientInvoice ON dbo.AxInvoiceGroup.igKey = dbo.AxClientInvoice.ciInvoiceGroup
WHERE (dbo.AxClientInvoice.ciKey = [Client Invoice Key])