Table chart_of_accounts_history

Table chart_of_accounts_history contains the historical and future balances of each general ledger account. Every journal entry affects this table. When an entry is posted to the ledger, the affected acocunts are incremented or decremented (according to accouting rules) to the posted period and rolled into future periods for as many periods have been created. This table is filled andmaintained by the system. DO NOT EDIT THE INFORMATION IN THIS TABLE or the books may become out of balance!

NOTE: This table has the largest impact on a journal posting. Every posted entry rolls from the current period to the last period in the system. If too many fiscal years are generated in advance, the time to post an entry will significantly increase.

Table Type: InnoDB

Field Type Default Description
id int (11) NOT NULL PRIMARY KEY - Identifies the history record number.
periodint (11)0INDEX - The accounting period of the record
account_idchar (15)NOT NULL
INDEX - Holds the general ledger account number (or id)
beginning_balancereal (double)0Holds the beginning balance of the specific account for a given period.
debit_amountreal (double) 0Holds the debit amount for the given ledger account for the given period.
credit_amountreal (double)0Holds the credit amount for the given ledger account for the given period.
budgetreal (double)0Holds the budgeted amount for the given ledger accout for the given period.
last_updatedate0000-00-00Last update of the record.