Tables

The driver 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 JDBC Driver 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.
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.
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.
ItemWarehouseInfo	Retrieves Item Warehouse 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.
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.
PjEstimate	Retreives Project Estimate 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.