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.