• From: Canada
  • Registered: 12/27/2012
  • Posts: 14

Topic: Database Schema FA 2.4.6

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

  • From: India, TN, Karur
  • Registered: 05/16/2014
  • Posts: 1,195

Re: Database Schema FA 2.4.6

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

Subscription service based on FA
HRM CRM POS batch Themes

kvvaradha's Website

  • cleal
  • cleal
  • Senior Member
  • Offline
  • From: Guatemala
  • Registered: 10/25/2018
  • Posts: 50

Re: Database Schema FA 2.4.6

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

cleal

cleal's Website

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: Database Schema FA 2.4.6

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

apmuthu's Website