RE: How to filter out deleted transactions from NS Transactions table?
I’m pulling data from a few NetSuite back-end tables into Snowflake. I’ve noticed that deleted transactions do not show up in the UI interface, but are still included in the Transactions back-end table (https://system.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2018_1/odbc/record/transaction.html).
I Couldn’t find any identification in the Transactions table for deleted transactions.
I tried using the System_notes table after reading this thread: https://stackoverflow.com/questions/46433007/how-to-identify-deleted-transactions-in-the-netsuite-transactions-table, but no deleted transactions show up in the System_notes table.
Does someone know how to identify and filter out deleted transactions when pulling data from NS back-end tables? This process needs to be fully automatic, not a one-time manual filtration, as I try to recreate a P&L NetSuite report outside NetSuite.
‘DELETE’ is logged as Action in TRANSACTION_HISTORY table