Change to Display Size and Precision in Some Connect Columns

As of 2021.2, SuiteAnalytics Connect changes the display size and precision for return values in some columns.

Note:

This change applies to the NetSuite.com data source only.

The following table shows the list of columns with changes:

Column Name	Previous Value	Updated Value
`transaction_history.column_number`	Display size: 90	Display size: 138
`transaction_lines.gl_sequence`	Display size: 40 Precision: 40	Display size: 256 Precision: 256

Column Name

Previous Value

Updated Value

transaction_history.column_number

Display size: 90

Display size: 138

transaction_lines.gl_sequence

Display size: 40

Precision: 40

Display size: 256

Precision: 256

If you work with the NetSuite.com data source and you are using column attributes in your configuration, review this change and make adjustments as needed.

To see the display size and precision for all columns, you can run the following query:

          SELECT COLUMN_NAME, TYPE_NAME, OA_LENGTH, OA_PRECISION, OA_SCALE FROM OA_COLUMNS WHERE TABLE_NAME = 'TRANSACTION_HISTORY'

For information about the column attributes, see Table Summary.

Related Topics