Intacct Pre-Mapped Data Warehouse Tables / GIs

Click here for learning about Tableau, Power BI, and MS Excel templates for Intacct.

Tables

Pre-mapped ETL+ tables available for Sage Intacct as of 01/2023. Subject to change without notice.

Source	Table Name

Source	Table Name
Intacct	APBill
Intacct	ARInvoice
Intacct	ARInvoiceItem
Intacct	Company
Intacct	Contract
Intacct	ContractDetail
Intacct	Customer
Intacct	Department
Intacct	DimensionRelationships
Intacct	Dimensions
Intacct	Employee
Intacct	GLAccount
Intacct	GLAccountBalance
Intacct	GLAcctGrp
Intacct	BLBatch
Intacct	GLBudgetItem
Intacct	GLDetail
Intacct	Item
Intacct	Location
Intacct	Project
Intacct	SODocument
Intacct	SODocumentSubtotals
Intacct	UserInfo
Intacct	Vendor
Intacct	Warehouse
Data Warehouse	4_Today
Data Warehouse	5_Date
Data Warehouse	6_DatePeriod

Notes:

Some of the above tables will only be deployed using customized SOWs or via services.
All Intacct tables can be extracted into the data warehouse using an ODBC.
We only recommend extracting tables that are important for your reporting purposes.

Table Columns Example

The following is an example of an Intacct table and its column names, indexes, and formatting in ETL+.

Column green icons indicate the data type and/or index definition have been set or changed in ETL+.

Delta Load Example

DataSelf ETL+ templates include delta load configuration for popular large tables. This dramatically reduces the time to refresh the data warehouse. ETL+ Table Load Types.

The following is an example of a table configured to use the Upsert feature.

Table Linking Example

The following is an example of how _AR_Aging_Today tables are linked in DataSelf’s out-of-the-box templates. This linking applies the same way for Tableau data sources, Power BI data sets, Excel, and other reporting tools.