From the SDK:
In some cases, particularly when integrating Office Accounting data with
Microsoft Office Excel or Microsoft Office Access, many developers prefer to
rely on ADO or ADO.NET rather than on the Office Accounting API for data
access. To permit such access outside of the usual Office Accounting API,
this section documents ten database views that are part of the Office
Accounting company database schema.
Caution:
In addition to the ten views documented in this section, an Office
Accounting company database implements a large number of additional tables,
views, and stored procedures that are not documented here. Directly accessing
these undocumented objects through ADO, ADO.NET, or through some other means
is not recommended.
You can grab the SDK from the following link - once you install it, look
under "Database Schema Reference".
http://www.microsoft.com/downloads/details.aspx?FamilyID=0d9fa476-c445-4d07-b8aa-f37e3c5ead9b&DisplayLang=en
Post by Pete PowerFolks,
Does a data dictionary exist for Office Accounting.
Please advise.
Thanks,
-Pete