Andrew
07/22/2022, 10:55 PMtdietrich
07/23/2022, 12:32 AMSELECT
Transaction.TranID,
Transaction.TranDate,
BUILTIN.DF( Transaction.Type ) AS Type,
BUILTIN.DF( Transaction.Status ) AS Status,
BUILTIN.DF( Transaction.Entity ) AS Entity,
BUILTIN.DF( Transaction.Employee ) AS Employee,
BUILTIN.DF( TransactionLine.Item ) AS Item,
TransactionLine.Quantity,
TransactionLine.Rate,
BUILTIN.DF( TransactionLine.Class ) AS Class
FROM
Transaction
INNER JOIN TransactionLine ON
( TransactionLine.Transaction = Transaction.ID )
AND ( TransactionLine.MainLine = 'T' )
WHERE
( Transaction.TranDate >= BUILTIN.RELATIVE_RANGES( 'DAGO7', 'START' ) )