Miscellaneous
This section provides a complete list of the Miscellaneous properties you can configure in the connection settings for this provider.
| Property | Description |
| AccountSupportsSuiteAnalyticsConnect | A boolean indicating if Connect Service Feature is enabled for the authenticated account. |
| AggregateColumnMode | Indicating how aggregate columns should be treated. |
| ApplicationId | As of version 2020.1, requests to NetSuite require an application ID. |
| CustomFieldPermissions | A comma separated list of custom field permissions that gives you more control than IncludeCustomFieldColumns . |
| DefaultDomain | This property is used for the Oracle Database Gateway for ODBC. |
| EnableForeignKeyDetection | Whether to detect the foreign keys in ODBC. |
| IncludeCustomFieldColumns | A boolean indicating if you would like to include custom field columns. |
| IncludeCustomListTables | A boolean indicating if you would like to use tables based on custom lists. |
| IncludeCustomRecordTables | A boolean indicating if you would like to use tables based on custom record types. |
| IncludeDualTable | Set this property to mock the Oracle DUAL table for better compatibility with Oracle database. |
| IncludeLongTextColumns | A boolean indicating if you would like to support long or rich text custom fields. |
| IncludeReferenceColumns | A comma separated list representing the columns to include when retrieving data from a field representing a record reference. |
| LimitKeySize | The maximum length of a primary key column. |
| MapBigintToVarchar | This property controls whether or not the bigint type maps to SQL_VARCHAR instead of SQL_BIGINT. This property is false by default. |
| MapToInt | This property controls whether or not the long type maps to SQL_INTEGER instead of SQL_BIGINT. This property is false by default. |
| MapToLongVarchar | This property controls whether or not a column is returned as SQL_LONGVARCHAR. |
| MapToWVarchar | This property controls whether or not string types map to SQL_WVARCHAR instead of SQL_VARCHAR. This property is set by default. |
| MaximumColumnSize | The maximum column size. |
| MaximumConcurrentSessions | The maximum number of concurrent sessions available for use in the connection. |
| MaxRows | Specifies the maximum rows returned for queries without aggregation or GROUP BY. |
| NetsuiteDateFormat | The preferred date format set in NetSuite UI. |
| NetsuiteLongDateFormat | The preffered long date format set in NetSuite UI. |
| Other | Specifies additional hidden properties for specific use cases. These are not required for typical provider functionality. Use a semicolon-separated list to define multiple properties. |
| Pagesize | The number of results to return per page from NetSuite. |
| PseudoColumns | Specifies the pseudocolumns to expose as table columns. Use the format 'TableName=ColumnName;TableName=ColumnName'. The default is an empty string, which disables this property. |
| Readonly | Toggles read-only access to NetSuite from the provider. |
| ReportDoublesAsDecimal | Indicates if doubles should be reported as decimal. |
| RequestMemorizedTransactions | A boolean indicating if you want to request memorized transactions when retrieving transactions from NetSuite. |
| RTK | Specifies the runtime key for licensing the provider. If unset or invalid, the provider defaults to the standard licensing method. Use this property only in environments where the standard licensing method is unsupported or requires a runtime key. |
| SuiteQLDateFormat | An optional override for Date format. |
| SuiteQLDatetimeFormat | An optional override for Datetime format. |
| SuiteQLDatetimeFormula | An optional override for formula used when filtering on date field types. |
| Timeout | The value in seconds until the timeout error is thrown, canceling the operation. |
| UpperCaseIdentifiers | This property reports all identifiers in uppercase. This is the default for Oracle databases and thus allows better integration with Oracle tools such as the Oracle Database Gateway. |
| UseAsyncServices | A boolean indicating if you would like to use asynchronous services when inserting, updating, and deleting. |
| UseInternalNamesForCustomizations | A enum indicating whether you want to use internal names or labels for customizations. The default behavior of the NetSuite displays records and columns with their internal names. |
| UserDefinedViews | Specifies a filepath to a JSON configuration file defining custom views. The provider automatically detects and uses the views specified in this file. |
| UserTimezoneOffset | Your user timezone offset as defined in your NetSuite preferences under Home --> Preferences --> Time Zone. Ex: EST. |
| UseSimpleNames | Boolean determining if simple names should be used for tables and columns. |
| UseUpserts | A boolean indicating if you would like to perform an upsert when an INSERT operation is used. |
| WebServiceHost | An optional override for the web service host such as webservices.na1.netsuite.com. |