In ODBC/JDBC I see that there are both is_non_posting in the table transactions and non_posting_line in transaction_lines. Is there a clear difference between the two?
Could there be a transaction which have is_non_posting = No and have lines that are non_posting_line = Yes?