michoel
04/14/2021, 1:48 AMSELECT transaction.id, transaction.entity, BUILTIN.DF(transaction.entity), transactionline.location FROM transaction JOIN transactionline ON transaction.id = transactionline.transaction AND transactionline.mainline = 'T' WHERE type = 'SalesOrd'