Hello! We are currently using fivetran to sync Netsuite Analytics data to our data warehouse using netsuite.com data source. In a current task I'm working on, I need to identify "Closed/Cancelled" transaction lines of a sales order. I can see the "Closed" flag field on NS, but I can't find it in the raw data extracted from NS. I can't find it amongst the Transaction Line fields setup on NS and not in the docs here . Any ideas how I can retrieve it? Thanks

can you not just used

date_closed

and check if its null?

I did look into this field and I found it to not be consistent with the flag on NS, i.e., sometimes it has a date but the line is not cancelled on NS, or it doesn't have a value and the flag is True on NS

isClosed is what you want from the transactionlines table I think

Thanks for your input Bryan, we are planning the migration to the new data source. but good to know this field exists in the new one 👍