Sage 50 Accounts Database Schema

Question

I am accessing Sage 50 data via their ODBC Driver but cannot seem to establish if the tables 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

score 3 · Answer 1 · edited Nov 05 '12 at 18:58

3

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

edited Nov 05 '12 at 18:58

newfurniturey

37,556
9
94
102

answered Nov 28 '11 at 15:21

Adam McCrory

391
3
7

score 1 · Accepted Answer · answered Jul 06 '10 at 10:07

1

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

Don't know if that helps at all.

answered Jul 06 '10 at 10:07

Jonathan

25,873
13
66
85

score 0 · Answer 3 · answered Apr 28 '15 at 07:55

0

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

answered Apr 28 '15 at 07:55

Laurence Nicolaou

569
2
8
28

but the question - albeit vague - was about the schema, i.e. indexes/types/lengths/etc of those columns – underscore_d Feb 23 '17 at 13:58

score 0 · Answer 4 · answered Jul 18 '17 at 20:59

0

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

answered Jul 18 '17 at 20:59

Alexrgs

831
8
20

1

Bear in mind, this dictionary for US/CA version and it does not apply to UK version of Sage 50 Accounts to the best of my knowledge – Alexander Kucheryuk Apr 05 '19 at 09:45

score -1 · Answer 5 · edited Mar 18 '11 at 14:22

-1

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

edited Mar 18 '11 at 14:22

Brad Larson

170,088
45
397
571

answered Aug 25 '10 at 09:16

Jason Raikes

1

Sage 50 Accounts Database Schema

5 Answers5