User Support Forum

Posted: **Mon Oct 06, 2003 11:29 am**

I am using Crystal Reports, so that I can do a monthly budget report. To do this I need to know in what table the account numbers are stored for the COA:!: Anyone know:?:

Posted: **Mon Oct 06, 2003 1:02 pm**

The account number information is stored in a table called FAACCTS. This is the structure:

Code: Select all

FAACCTS 
 FIELDS        DATATYPE    SIZE
  Acct           Character       9   
  Desc          Character     29   
  Type          Character       1   
  Db_Cr        Numeric         2   
  Category    Character       1   
  Level          Numeric         1   
  Pagebreak  Character       1   
  Yrstbal        Numeric       12  2 
  Currpd        Numeric       12  2 
  Budget        Character    120   
  Nextbudget  Character    120   
  Actual         Character    144   
  Prevyr        Character    144   
  Prevstbal     Numeric      12  2 
 INDEX     
  FAACCTS UPPER(ACCT) 
  FAACCTSA SUBSTR(ACCT,3,7)

It should be fairly easy to figure out what does what from looking at the Maintain Chart of Accounts screen in PowerChurch.

Hope that helps!

Posted: **Mon Oct 06, 2003 1:03 pm**

hmmm....those columns didn't look all screwy when I was composing the response.

User Support Forum

Question on where data is stored in the tables.

Question on where data is stored in the tables.

table structures

my kingdom for a TAB