Question on where data is stored in the tables.

[jgolden]

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:?:

[Zaphod]

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!

[Zaphod]

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