Home >

AX1086

Import source: Intacct

NOTE: This import source is only available if you have licensed Intacct integration.

The Source tab of the Import Wizard uses the following settings when importing data from Intacct.

Item	Description
Source	Select Intacct to read data directly from Intacct.

Connection

Complete the following connection information for the import source.

NOTE: This information is only used to connect to the source and extract the data into the import temptable. Transformation steps are not performed using these credentials.

Item	Description
User ID	The user name to use to connect to Intacct.
Company ID	The company ID to use to connect to Intacct.
Password	The password to use to connect to Intacct.
Table Name	The Intacct table from which to read data.
Filter	A filter to limit the data to be read from the table. The following SQL operators are supported in the filter: <, >, >=, <=, =, LIKE, NOT LIKE, IN, NOT IN. When doing NULL comparisons, use IS NOT NULL or IS NULL. Compound filters using AND and OR are supported, but joins are not supported. If the value you are filtering on contains an apostrophe, add a backslash before it to escape the apostrophe (for example: contactname = 'Erik\'s Deli').
Column Names	A comma-delimited list of columns to be read from the table. Leave this blank to return all columns.

See the Intacct Developer API Reference for more information on Intacct tables that can be queried, and any special requirements and considerations for each table. Tables can be queried if they support the ReadByQuery API method.