tdietrich
11/11/2020, 3:34 PMSELECT DISTINCT
Transaction.TranDate AS Date,
BUILTIN.DF( Transaction.Type ) AS Type,
Transaction.TranID,
BUILTIN.DF( Transaction.Status ) AS Status,
PreviousTransactionLineLink.LinkType,
Transaction.ForeignTotal AS Amount
FROM
PreviousTransactionLineLink
INNER JOIN Transaction ON
( Transaction.ID = PreviousTransactionLineLink.NextDoc )
WHERE
( PreviousTransactionLineLink.PreviousDoc = 7301 )
ORDER BY
Transaction.TranDate