tdietrich
06/25/2021, 10:08 PMSELECT
Credit.TranDate,
Credit.TranID,
BUILTIN.DF( Credit.Entity ) AS Vendor,
BUILTIN.DF( CreditLine.CreatedFrom ) AS Bill,
CreditLine.ForeignAmount,
CreditLine.*
FROM
Transaction AS Credit
INNER JOIN TransactionLine AS CreditLine ON
( CreditLine.Transaction = Credit.ID )
AND ( CreditLine.Mainline = 'T' )
WHERE
Credit.ID = 1438783