Get prepayments of project Invoice in d365fo x++

Get prepayments of project Invoice in d365fo x++

Code:

select 
newAccTrans.TRANSID, NewAcc.PROJINVOICEID,
orginAccTrans.TRANSID, orginAcc.PROJINVOICEID,
newAccTrans.PSARefRecId

from ProjOnAccTrans newAccTrans
join ProjInvoiceOnAcc NewAcc
on NewAcc.TRANSID = newAccTrans.TRANSID

join ProjOnAccTrans orginAccTrans
on orginAccTrans.RECID = newAccTrans.PSARefRecId
join ProjInvoiceOnAcc orginAcc
on orginAcc.TRANSID = orginAccTrans.TRANSID


where newAccTrans.TRANSID = '4040-000192'