FrontAccounting forum — Database Schema FA 2.4.6

Re: Database Schema FA 2.4.6

2020-08-20T18:51:20Z

https://frontaccounting.com/fawiki/index.php?n=Devel.ERDiagram23
https://frontaccounting.com/fawiki/index.php?n=Devel.ERDiagram24

2020-08-20T15:14:08Z

Hi there,
You can use MySQL Workbench to generate database schema.

2020-08-20T05:39:04Z

You can query on gl_trans table. With respect to account code, you will retrieve all transactions

2020-08-20T04:49:37Z

I'm not sure which tables to query to get all the transactions for an account in my FA chart of accounts.

Is there a place where I can find the database schema?

Does anyone know which tables I should be using to accomplish this?

Any help would be much appreciated.

Thank you.

Bill Dika