Changes to Return Values in SuiteAnalytics Connect Columns
Since 2020.2, SuiteAnalytics Connect changes the length attribute for return values in some columns and custom fields.
This change applies to the NetSuite.com data source only.
If you work with the NetSuite.com data source and you are using the column attributes in your configuration, review them and make adjustments as needed. To avoid error or discrepancies, your configuration must match the column values listed in the Connect Browser.
The following table shows the list of columns with length changes for return values:
|
Column name |
Previous length |
Updated length |
|---|---|---|
|
rmtemplate.description |
1000 |
4000 |
|
crmtemplate.name |
128 |
4000 |
|
item_fulfillments.status |
480 |
4000 |
|
items.type_name |
128 |
4000 |
|
roles1.permission_name |
200 |
4000 |
|
system_notes.name |
283 |
4000 |
|
system_notes.operation |
264 |
4000 |
|
system_notes_custom.name |
227 |
4000 |
|
system_notes_custom.operation |
208 |
4000 |
|
transactions.status |
480 |
4000 |
The length attribute also changes for custom fields that correspond to phone numbers in the NetSuite UI. The length changes from 21 to 32 bytes. These changes are available in the 2020.2 Connect Browser.
For information about the column attributes, see Table Summary.