Hi, all. I've been using SuiteAnalytics Connect to pull data into an MS SQL Server for a couple years now, using Linked Servers for the data connection and OPENQUERY for my queries. It works perfectly, but it is built on the NetSuite.com data source, not NetSuite2.com. Today I connected to the NetSuite2.com to start thinking about how to convert my queries over, assuming that some of the table structure would be different, but I'm completely baffled by what I'm seeing so far. Once connected to my SQL Server environment, I ran

select * from OPENQUERY([NETSUITE2],'select * from OA_TABLES')

and I cannot figure out how to put together an item, customer, or transaction record. Is there any decent documentation of the standard tables or how to use this schema? The older schema had some issues, but at least I knew were to start. Additionally, poking around online for some answers, I saw some people referencing an items or transaction_lines table in NetSuite2.com, but I don't see those. Am I somehow missing them? Or misreading random Internet posts. Any guidance as to how to start this transition would be appreciated.