I'm going to create a ticket for NetSuite, but has anyone that uses Suite Analytics Connect ODBC driver run across this oddity in the NS2.com data source? The SQL query results not making ANY logical sense?

I can explain it but it still won't make any logical sense. In order to filter on the status field, you'll need to use the transaction type specific status value. So, in your example, I think it would be "SalesOrder:H". Why the value it displays in output is different from the value you have to filter on is beyond my understanding. 🙂

and I forgot case sensitive in Oracle SQL 🙂 ? if it is case sensitive, try with t.status <> 'H'

@eblackey I think it's because we don't really have a "true" connection to our data in the database. Instead NetSuite appears to have WHO KNOWS how many layers of business code sitting between us and our data... so in those business layers they can play weird games like this. Just give me a good old-fashioned "cross-reference table" INNER JOIN please instead!!!