Tableau Connector for Sage Intacct

Build 21.0.7930

Data Model

CData Tableau Connector for Sage Intacct models Sage Intacct entities in relational Tables.

Table definitions are dynamically retrieved. Any changes you make, such as adding a new table, or adding new columns, or changing the data type of a column, will immediately be reflected when you connect using the connector.

By default, only the list of the tables below supports the GETDELETED statement. You can add GETDELETED statement support for other tables via the GetdeletedTables connection property, by simply specifying the comma separated list of the tables and their corresponding key columns.

Default tables list that support the GETDELETED statement: Contact, Department, Glacctgrppurpose, Glbatch, Apaccountlabel, Apadjustment, Appymt, Apbill, Aradjustment, Arinvoice, Podocumentparams, Warehouse, Obspctcompleted, Task, Timesheet, Contractitempricelist, Contractdetail.

The Tables and Views listed in the documentation are samples of what you may have access to in your Intacct account.

Please note, there are several tables that have separate required primary keys for INSERT and DELETE. Such tables (and their composite primary keys) are listed below:

AisleAISLEID
AllocationALLOCATIONID
APBillPaymentPAYITEMKEY
BinBINID
BudgetHeaderBUDGETID
ClassCLASSID
CreditCardCARDID
CustomerCUSTOMERID
EEAccountLabelACCOUNTLABEL
EmployeeEMPLOYEEID
ExpensePaymentTypeNAME
GAAPAdjJrnlTITLE
GLAcctGrpNAME
ICRowROWKEY
InvPriceListNAME
JournalTITLE
POPriceListNAME
PositionSkillNAME
ProductLinePRODUCTLINEID
ProjectPROJECTID
StatJournalTITLE
TransactionRuleNAME
TrxCurrenciesCODE
UoMNAME
UserAdjJrnlTITLE
VendorVENDORID
WarehouseLOCATIONID

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930