FrontAccounting forum — Database Schema FA 2.4.6

Re: Database Schema FA 2.4.6

null@example.com (apmuthu) — Thu, 20 Aug 2020 18:51:20 +0000

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

null@example.com (cleal) — Thu, 20 Aug 2020 15:14:08 +0000

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

null@example.com (kvvaradha) — Thu, 20 Aug 2020 05:39:04 +0000

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

null@example.com (bdika) — Thu, 20 Aug 2020 04:49:37 +0000

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