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 only to the schema available through NetSuite.com.
What is Changing?
Over the next two releases, some tables and columns in the Connect Schema are targeted for deprecation. The deprecation process is scheduled as follows:
- As of 2021.1, the notes_system and notes_system_custom tables will be permanently removed. Since 2017 the Connect Browser has included a warning that these tables should not be used. Any queries that still include these tables will fail as of 2021.1. You can use the system_notes and system_notes_custom tables instead. See the Connect Browser for descriptions of the columns available for each table, then make adjustments to your existing queries as needed.
- As of 2021.2, the date_last_modified column will be permanently removed from the transaction_lines table. Since 2017 the Connect Browser has included a description that this column may return inaccurate values and that you should use the date_last_modified_gmt column instead. Note that the date_last_modified_gmt column returns results in GMT time zone. You should consider the time zone when you review your queries and make any adjustments as needed. You will receive another notification about this column’s removal in 2021.2.
Note: These changes will be effective when your account is upgraded to the corresponding release. However, the Connect Browser will not be upgraded at the same time so it will not show these changes at the time of your account upgrade. These changes will be visible in the Connect Browser when it is released at a later date.
Required Actions
You should check your existing queries and make any adjustments before these tables and this column are deprecated and permanently removed.
Note: Before you modify your queries, you should see the Connect Browser to check the descriptions of available tables and columns.
The following table lists the tables and columns affected by the upcoming deprecation:
For more information about the tables available in the Connect Schema, see Connect Schema (SuiteAnswers ID 92461).
If you have more questions, please contact NetSuite Customer Support.