I have been working on a client management system that is closely integrated with a Sage Line 50 database. As the project has developed I have found myself wanting and needing more and more information regarding the structure of the Sage Line 50 database as well as the relations between the tables within it.

After much time spent searching on Google and also contacting the authors of Sage Line 50 (who only suggested paying for use of their SDK) I found there is next to nothing out there on the web in the way of information on the Sage Line 50 database schema.

So I have produced this spreadsheet to describe the Sage Line 50 ODBC Schema for my reference and understanding.

Currently there is one table per sheet describe with the first sheet listing ALL tables in the database. This is a work in progress and I will be adding more to it as I discover and understand more about the relationships between the individual tables. ie Which tables are join tables, what fields are used to relate to other tables etc.

If you are interested dowload it here: Sage-Line-50-ODBC-Schema.ods

If anybody happens to revise this spreadsheet with more information I would appreciate it if you could email me the revised spreadsheet then I can post it again here. If not, I'll just post my next revision when I have more information.