Data Model
Sage Intacct Adapter 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 adapter.
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 |