Miscellaneous
This section provides a complete list of the Miscellaneous properties you can configure in the connection settings for this provider.
| Property | Description |
| UseLegacy | Indicates whether the provider uses the legacy XML-based API implementation for Sage Intacct. |
| ClientID | The company ID of the child company that you want to connect to. |
| DocParId | The name of a transaction type in Sage Intacct for which the provider returns associated custom fields. |
| EnableSubscriptions | A comma-separated list of one or more subscriptions enabled in your Sage Intacct account. |
| IncludeDetailAggregate | Indicates whether the provider includes aggregate columns in query results. |
| IncludeGLEntries | Indicates whether the provider preserves existing GLEntry items when updating the GLBatch table. |
| IncludeItemDetails | Indicates whether the provider includes aggregate columns in query results for the INVDOCUMENTPARAMS , PODOCUMENTPARAMS , and SODOCUMENTPARAMS tables. |
| IncludeRelatedAttributes | The scope of related attributes that the provider retrieves alongside the queried table's attributes. |
| LocationsId | The ID of the shared child company location that you want to access in Sage Intacct. |
| MaxRows | Specifies the maximum number of rows returned for queries that do not include either aggregation or GROUP BY. |
| MinimumColumnSize | The minimum column size that the provider reports for string columns. |
| Other | Specifies advanced connection properties for specialized scenarios. Use this property only under the guidance of our Support team to address specific issues. |
| Pagesize | The maximum number of records per page the provider returns when requesting data from Sage Intacct. |
| PreferredDateFormats | A semicolon separated string containing a list of DateTime formats which should be tried when parsing DateTime values. |
| ReadByName | Indicates whether the provider uses the ReadByName clause when querying Sage Intacct. |
| Readonly | Toggles read-only access to Sage Intacct from the provider. |
| ReturnFormatAsXML | Indicates whether the provider requests data from Sage Intacct in XML format. |
| RowScanDepth | The maximum number of rows to scan to look for the columns available in a table. |
| ShowPrivateEntityData | Indicates whether queries return data from private entities owned by the top-level entity. |
| Timeout | Specifies the maximum time, in seconds, that the provider waits for a server response before throwing a timeout error. |
| UserDefinedViews | Specifies a filepath to a JSON configuration file that defines custom views. The provider automatically detects and uses the views specified in this file. |