Question on where data is stored in the tables.
Moderators: Moderators, Tech Support
Question on where data is stored in the tables.
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:?:
-
- Program Development
- Posts: 830
- Joined: Tue Sep 02, 2003 12:48 pm
- Location: PowerChurch Software
- Contact:
table structures
The account number information is stored in a table called FAACCTS. This is the structure:
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!
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)
Hope that helps!
-
- Program Development
- Posts: 830
- Joined: Tue Sep 02, 2003 12:48 pm
- Location: PowerChurch Software
- Contact:
my kingdom for a TAB
hmmm....those columns didn't look all screwy when I was composing the response.