Database Tables

Chart of Accounts Relationship Diagram

AsChartofAccounts and AsChartofAccountsEntity Tables

AsChartofAccountsEntry Table

The values of these fields are saved in AsChartOfAccountsEntry table and provide detail for an account. When a transaction or suspense generates an accounting record in AsAccountingDetail it is associated to this table via the ChartofAccountsEntryGuid and provides further information regarding the account.  The AsChartOfAccountsEntry is associated to the account via the ChartofAccountsEntityGUID in the AsChartOfAccountsEntity table.  

Criteria Database Tables

Disbursement Table

Results Database Tables