Table relation between Salesline and ProjInvoiceJour

Dynamics 365 for Finance and Operations/AX User Forum
1

Hi All,

i have list project sales orders. I need to display Invoice Id in the report each line of sales order. I found the invoice id available in the ProjInvoiceJour tale but there there is no direct relation between salesLine and ProjInvoiceJour.

I need to add this in existing query output. Please find below query and let me know relation between above mentioned table?

SELECT 
     s.DATAAREAID, s.CUSTGROUP, s.SALESGROUP, s.INVENTLOCATIONID, 
s.INVENTSITEID, p.PROJID, s.SALESID, '' as InvoiceNo, cps.DELIVERYDATE,
s.SALESNAME, s.CUSTACCOUNT, wi.FilterCode[4], tist.tmxInventStatusName, sl.ITEMID, sl.NAME, '' as Brand, cps.QTY, sl.SALESPRICE,
	 s.CURRENCYCODE
FROM 
    ProjTable p 
JOIN  
    SalesTable s ON p.ProjId = s.ProjId 
    AND p.DATAAREAID = s.DATAAREAID
JOIN   
    SalesLine sl ON s.SalesId = sl.SalesId 
	AND s.DATAAREAID = sl.DATAAREAID
JOIN 
   CustPackingSlipTrans cps ON sl.SalesId = cps.SalesId 
   AND sl.LineNum = cps.LineNum 
   AND sl.ItemId = cps.ItemId 
   AND sl.InventTransId = cps.InventTransId 
   AND sl.DATAAREAID = cps.DATAAREAID
LEFT OUTER JOIN 
   InventTable i ON sl.ItemId = i.ItemId 
   AND sl.DATAAREAID = i.DATAAREAID
LEFT OUTER JOIN 
   WHSInventTable wi ON i.ItemId = wi.ItemId 
   AND i.DATAAREAID = wi.DATAAREAID
LEFT OUTER JOIN  
   tmxInventItemStatus tiis ON i.ItemId = tiis.ItemId 
   AND i.DATAAREAID = tiis.DATAAREAID
LEFT OUTER JOIN 
   tmxInventStatusTable tist ON tiis.tmxInventStatusTableRef = tist.RecId 
LEFT OUTER JOIN 
   MAX_ItemCostView micv ON i.ItemId = micv.ItemId
   AND i.DATAAREAID = micv.DATAAREAID
where 
   s.DATAAREAID = 'MTL'
   and s.CUSTACCOUNT not in('MTL-003619','MTL-003686','MTL-003676',
   'MTL-003620','MTL-003645','MTL-006710','MTL-003800', 'MTL-002907','MTL-002906',
   'MTL-002908','MTL-003677','MTL-006711','MTL-006719','MGC-001242',
   'MGC-001227','MGC-000186','MGC-001235','MGC-001238', 'MGC-001250',
   'MGC-001822','MGC-001228')
   And ((cps.DeliveryDate>={ts '2020-02-01 00:00:00.000'} AND cps.DeliveryDate<={ts '2020-02-05 00:00:00.000'}))