NetSuite Data Structure

So great. You know how to access the data.

But, as you can imagine, this data is optimized across a massive superstructure. And the underlying components support a variety of services across a wider variety of industries. So you need to infer that the structure will be complicated. But again, one bite at a time…

I will again reference the link provided in an earlier post;

refining odbc queries

Suffice it to say that some deeper analysis is required here.

With that said, here is another nugget;

Oracle NetSuite schema browser

The next step is to analyze the structure and determine where your data resides

Just don’t forget. The structure will have a hierarchy – and that may vary depending on what NetSuite version you are using.

But once you have connected to the data source, you can expand on the sql query to access only the required content.