CData ADO.NET Provider for Sage Intacct models Sage Intacct entities in relational Tables.

Table definitions are dynamically retrieved. When you connect using the provider, any changes you make, such as adding a new table, adding new columns, or changing a column's data type, are reflected immediately.

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

Sage Intacct offers support for various document tables that coincide with a specific document type. By default the document tables do not include custom fields associated with the table, but the user can access the following tables to retrieve any custom fields associated with the document type.

The following is a sample of the document tables and their associated document type tables.

PODocument	PODocumentPurchaseOrder
SODocument	SODocumentSalesOrder
INVDocument	INVDocumentAdjustmentIncrease

Inserting/Updating the ItemAggregate Field

When setting the ItemAggregate field in Insert/Update statements, modify the setting in the XML aggregate-only entries for each item using Field tags rather than Items tags. The CData ADO.NET Provider for Sage Intacct processes Items tags internally when it builds and passes the XML aggregate to the service.

Tables With Separate Required Primary Keys for INSERT and DELETE

The following table lists tables that have separate required primary keys for INSERT and DELETE, and their composite primary keys:

Aisle	AISLEID
Allocation	ALLOCATIONID
APBillPayment	PAYITEMKEY
Bin	BINID
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