-
Netsuite - Connect / Schema / Analytics - Table Relationship between Transactions and File
I have connected to the following NS schema to my SQL server database and all tables replicated Schema Browser (SuiteTalk) Connect Browser (Netsuite.com Analytics) Analytics Browser (Netsuite2.com Analytics) I am trying to get the relationship between transaction and file attachment, so that I can join both table to create…
-
Upcoming Removal of the SuiteAnalytics Connect transaction_lines.date_last_modified Column
This notice is intended for customers who use SuiteAnalytics Connect. The date_last_modified column will be permanently removed from the transaction_lines table. This change is targeted to occur when your account is upgraded to NetSuite 2021.2. Note: This removal will apply only to the schema available through the…
-
Inventory Location on transaction line from ODBC
Hello, We are trying to get the Inventory Location field from the transaction lines via ODBC but the answer provided in SuiteAnswers (88572) does not work. I've looked at the Analytics browser and it seems that inventorylocation should be available via Connect, but I don't see it in the table TRANSACTION_LINES. Does anyone…
-
Differences between Analytics Browser and Connect Browser
Hi Everyone, I was wondering if someone here could explain the differences between the records I see in the Analytics Browser vs the Connect Browser. We're utilizing Fivetran to pull data out of Netsuite and it seems to be pulling all of the data from the Connect Schema as seen from the Connect Browser. The main problem…
-
Reminder: Removal of some Connect Tables and Columns
This notice is to inform you of the removal of some tables and columns from the Connect schema, starting in Release 2021.1. This gradual removal process is designed to allow you time to make any needed adjustments to your queries. Note: This removal applies only to the schema available through NetSuite.com. What is…
-
Upcoming Deprecation of some Connect Tables and Columns
This notice is intended for customers who use SuiteAnalytics Connect. Deprecation of some tables and columns from the Connect Schema is targeted for the next two releases, starting in 2021.1. This gradual process is designed to allow you time to make any needed adjustments to your queries. Note: This deprecation applies…