Hi everyone! Is there any way to filter the transactionline table on record type (i.e. 'SalesOrd') without joining it to the transaction table, or any other table? I don't see any column in transactionline that would allow one to do such a thing

I don’t believe you can. It’s easy enough to join to the transaction table though

Yeah that's what we have been doing, but it's a bit trickier with the extraction tool that we are using (CData Sync). It works though, so I guess I shouldn't worry about it.