RelationShip between CustPackingSlipTrans and CustInvoiceTrans

X++  Query

CustInvoicePackingSlipQuantityMatch custInvoicePackingSlipQuantityMatch;
    CustInvoiceTrans custInvoiceTrans;
    CustPackingSlipTrans custPackingSlipTrans;
    CustPackingSlipJour custPackingSlipJour;
 
    select firstOnly custPackingSlipJour
    join custPackingSlipTrans
    where custPackingSlipJour.PackingSlipId==custPackingSlipTrans.PackingSlipId
    join custInvoicePackingSlipQuantityMatch
    where custInvoicePackingSlipQuantityMatch.PackingSlipSourceDocumentLine==custPackingSlipTrans.SourceDocumentLine
    join custInvoiceTrans
    where custInvoicePackingSlipQuantityMatch.InvoiceSourceDocumentLine==custInvoiceTrans.SourceDocumentLine
    ;


SQL Query

select invTrans.INVOICEID,invTrans.QTY ,slipTrans.PACKINGSLIPID, slipTrans.QTY,slipTrans.NAME  from
CustInvoicePackingSlipQuantityMatch match
join CustInvoiceTrans invTrans on invTrans.SOURCEDOCUMENTLINE=match.INVOICESOURCEDOCUMENTLINE
join CustPackingSlipTrans slipTrans  on slipTrans.SOURCEDOCUMENTLINE = match.PACKINGSLIPSOURCEDOCUMENTLINE