Sage 50 Accounts Database Schema

I am accessing Sage 50 data via their ODBC Driver but cannot seem to establish if the tab开发者_JAVA百科les have a unique / primary key. The ODBC.NET Driver does not seem to return any information relating to indexes or key field information.

Anyone got any clues?

Tim

---

On the main objects such as Customers, Suppliers the Key indexed fields are ACCOUNT_REF, if its a transaction file you would join on HEADER.HEADER_NUMBER -> SPLIT.HEADER_NUMBER - they work on old school linked lists are are not indexed

For Sales or Purchase Orders, Invoice documents you would join INVOICE.INVOICE_NUMBER to INVOICE_ITEM.INVOICE_NUMBER

---

Tables ending in "m" seem to be master tables with actual real data in...

Don't know if that helps at all.

---

I created a ODBC data source and exported the data in excel and it clearly shows the table names, columns and data.

---

Check the sage 50 data dictionary lots of information about the database such as: columns , indexes, keys, length, type , descriptions.

---

Sage Line 50 uses a proprietry database. As far as I am aware there is no indexing of the tables.