Tableau Connector for Sage Intacct

Build 21.0.7930

Tables

The connector models the data in Sage Intacct into a list of tables that can be queried using standard SQL statements.

Generally, querying Sage Intacct tables is the same as querying a table in a relational database. Sometimes there are special cases, for example, including a certain column in the WHERE clause might be required to get data for certain columns in the table. This is typically needed for situations where a separate request must be made for each row to get certain columns. These types of situations are clearly documented at the top of the table page linked below.

CData Tableau Connector for Sage Intacct Tables

Name Description
AcctLabelTaxGroup Retrieves AcctLabelTaxGroup report data.
AcctRange Retrieves AcctRange report data.
ActivityLog Retrieves ActivityLog report data.
Aisle Retrieves Aisle report data.
Allocation Retrieves Allocation report data.
APAccountLabel Retrieves APAccountLabel report data.
APAdjustment Retrieves APAdjustment report data.
APBill Retrieves APBill report data.
APBillBatch Retrieves APBillBatch report data.
APPymt Retrieves APPymt report data.
APRecurBill Retrieves APRecurBill report data.
APTerm Retrieves APTerm report data.
ARAccountLabel Retrieves ARAccountLabel report data.
ARAdjustment Retrieves ARAdjustment report data.
ARInvoice Retrieves ARInvoice report data.
ARInvoiceBatch Retrieves ARInvoiceBatch report data.
ARPaymentBatch Retrieves ARPaymentBatch report data.
ARTerm Retrieves ARTerm report data.
Attendee Retrieves Attendee report data.
Billing_Contact Retrieves Billing_Contact report data.
Bin Retrieves Bin report data.
BudgetHeader Retrieves BudgetHeader report data.
CheckingAccount Retrieves CheckingAccount report data.
Class Retrieves Class report data.
Comments Retrieves Comments report data.
Contact Retrieves Contact report data.
Contract A collection of Contract items.
CreditCard Retrieves CreditCard report data.
Customer Retrieves Customer report data.
CustomerEmailTemplate Retrieves CustomerEmailTemplate report data.
CustomerGroup Retrieves CustomerGroup report data.
CustomerVisibility Retrieves CustomerVisibility report data.
CustType Retrieves CustType report data.
Department Retrieves Department report data.
EarningType Retrieves EarningType report data.
EEAccountLabel Retrieves EEAccountLabel report data.
EExpenses Retrieves EExpenses report data.
EmailTemplate Retrieves EmailTemplate report data.
Employee Retrieves Employee report data.
EmployeeEntityContacts Retrieves EmployeeEntityContacts report data.
EmployeeGroup Retrieves EmployeeGroup report data.
EmployeeOutOfOffice Retrieves EmployeeOutOfOffice report data.
EmployeePositionSkill Retrieves EmployeePositionSkill report data.
EmployeeRate Retrieves EmployeeRate report data.
EmployeeType Retrieves EmployeeType report data.
ExchangeRate Retrieves ExchangeRate report data.
ExpenseAdjustments Retrieves ExpenseAdjustments report data.
ExpensePaymentType Retrieves ExpensePaymentType report data.
GAAPAdjJrnl Retrieves GAAPAdjJrnl report data.
GLAccount Retrieves GLAccount report data.
GLAcctGrp Retrieves GLAcctGrp report data.
GLAcctGrpMember Retrieves GLAcctGrpMember report data.
GLBatch Retrieves GLBatch report data.
GLBudget Retrieves GLBudget report data.
GLCoaCatMember Retrieves GLCoaCatMember report data.
GLCompGrpMember Retrieves GLCompGrpMember report data.
ICRow Retrieves ICRow report data.
InvDocument Retrieves InvDocument report data.
InvDocumentParams Retrieves InvDocumentParams report data.
InvPriceList Retrieves InvPriceList report data.
Item Retrieves Item report data.
ItemTaxGroup Retrieves ItemTaxGroup report data.
Journal Retrieves Journal report data.
Location Retrieves Location report data.
Misc_Supporting_Document Retrieves Misc_Supporting_Document report data.
OutOfOffice Retrieves OutOfOffice report data.
PODocument Retrieves PODocument report data.
PODocumentParams Retrieves PODocumentParams report data.
POPriceList Retrieves POPriceList report data.
PositionSkill Retrieves PositionSkill report data.
ProductLine Retrieves ProductLine report data.
Project Retrieves Project report data.
ProjectGroup Retrieves ProjectGroup report data.
ProjectResources Retrieves ProjectResources report data.
ProjectStatus Retrieves ProjectStatus report data.
ProjectTransactionRule Retrieves ProjectTransactionRule report data.
ProjectType Retrieves ProjectType report data.
RecurGLBatch Retrieves RecurGLBatch report data.
RenewalMacro Retrieves RenewalMacro report data.
ReportingPeriod Retrieves ReportingPeriod report data.
Revrecschedule Retrieves RevRecSchedule report data.
Revrecscheduleentry Retrieves RevRecScheduleEntry report data.
RevRecTemplate Retrieves RevRecTemplate report data.
RevRecTemplMilestone Retrieves RevRecTemplMilestone report data.
SavingsAccount Retrieves SavingsAccount report data.
Seminar Retrieves Seminar report data.
Seminar_Package Retrieves Seminar_Package report data.
Seminar_Registration Retrieves Seminar_Registration report data.
SODocument Retrieves SODocument report data.
SODocumentParams Retrieves SODocumentParams report data.
SOPriceList Retrieves SOPriceList report data.
StatAccount Retrieves StatAccount report data.
StatJournal Retrieves StatJournal report data.
STKitDocument Retrieves STKitDocument report data.
Task Retrieves Task report data.
TaskResources Retrieves TaskResources report data.
TaxGroup Retrieves TaxGroup report data.
TerritoryGroup Retrieves TerritoryGroup report data.
Timesheet Retrieves Timesheet report data.
TimeType Retrieves TimeType report data.
Track A collection of Track items.
TransactionRule Retrieves TransactionRule report data.
TransactionRuleDetail Retrieves TransactionRuleDetail report data.
TrxCurrencies Retrieves TrxCurrencies report data.
UoM Retrieves UoM report data.
UserAdjJrnl Retrieves UserAdjJrnl report data.
UserInfo Retrieves UserInfo report data.
UserRoles Retrieves UserRoles report data.
Vendor Retrieves Vendor report data.
VendorGroup Retrieves VendorGroup report data.
VendorVisibility Retrieves VendorVisibility report data.
VendType Retrieves VendType report data.
Warehouse Retrieves Warehouse report data.

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