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. |