| Field | Type | Default | Description |
|---|---|---|---|
| id | int (11) | NOT NULL | PRIMARY KEY - Identifies the history record number. |
| period | int (11) | 0 | INDEX - The accounting period of the record |
| account_id | char (15) | NOT NULL | INDEX - Holds the general ledger account number (or id) |
| beginning_balance | real (double) | 0 | Holds the beginning balance of the specific account for a given period. |
| debit_amount | real (double) | 0 | Holds the debit amount for the given ledger account for the given period. |
| credit_amount | real (double) | 0 | Holds the credit amount for the given ledger account for the given period. |
| budget | real (double) | 0 | Holds the budgeted amount for the given ledger accout for the given period. |
| last_update | date | 0000-00-00 | Last update of the record. |