What is the table to query for accounting periods ? I exposed the field in my query and its all numeric, I need to change the ID to the human readable - I tried AccountingPeriod and Accounting_Period and it doesnt look like either of those exist, I cant find any things in the roles that look like its a permission issue...

@Kevin Weitzner There's a query in this post that might help: https://timdietrich.me/blog/netsuite-suiteql-accounting-periods/

You could also try

BUILTIN.DF(postingperiod)

to get text representation of the accounting period

Thank you both so much. Will review tomorrow