This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

I remember hearing this is a limitation, but I can query the standard NetSuite 'State' table?
```{
	"q": "select * from state"
} ```


<@U014V915U8N> This should work:
```SELECT
	State.ID,
	State.ShortName,
	State.FullName,
	State.Country
FROM
	State
ORDER BY
	State.ShortName```


And there's a Country table as well:
```SELECT
	Country.ID,
	Country.Name,
	Country.Edition,
	Country.Nationality
FROM
	Country
ORDER BY
	Country.Name```


<@U856E2SEA> do you happen to know what permissions control these tables? I can hit them with my admin role, but I run into a vague permission error

<@U014V915U8N> This is a guess, but maybe try Setup &gt; Accounting Lists?

Figured it out, it was actually the `Setup &gt; Set Up Company 'Allows usage of the Search State task'`

Not sure why it fell under that permission, but it works now.