Data Model
CData JDBC Driver 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 driver.
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:
Aisle | AISLEID |
Allocation | ALLOCATIONID |
APBillPayment | PAYITEMKEY |
Bin | BINID |
BudgetHeader | BUDGETID |
Class | CLASSID |
CreditCard | CARDID |
Customer | CUSTOMERID |
EEAccountLabel | ACCOUNTLABEL |
Employee | EMPLOYEEID |
ExpensePaymentType | NAME |
GAAPAdjJrnl | TITLE |
GLAcctGrp | NAME |
ICRow | ROWKEY |
InvPriceList | NAME |
Journal | TITLE |
POPriceList | NAME |
PositionSkill | NAME |
ProductLine | PRODUCTLINEID |
Project | PROJECTID |
StatJournal | TITLE |
TransactionRule | NAME |
TrxCurrencies | CODE |
UoM | NAME |
UserAdjJrnl | TITLE |
Vendor | VENDORID |
Warehouse | LOCATIONID |