We import netsuite data tables into snowflake, and I am trying to identify NetSuite Accounts Payable open invoices. I currently have the filter based on columns in the transactions and transaction_lines tables as this below. Does anyone know if this is correct?
WHERE
STATUS <> 'Paid In Full'
AND IS_ACCOUNTS_PAYABLE = TRUE
AND is_non_posting = 'No'