Field | Type | Default | Description |
---|---|---|---|
id | int (11) | NOT NULL | PRIMARY KEY - Auto increment field to hold unique ID |
period | int(11) | 0 | Accountig period |
gl_account | varchar(16) | NULL | General Ledger account |
statement_balance | float | 0 | Balance in the account after the period/gl_account has been reconciled. This amount will usually be zero after reconciliation but may not be zero if reconciliation is in process. This allows for partial reconciliations, saving the intermediate results. |
cleared_items | text | '' | Encoded list of items selected to be cleared in a given period/gl_account. |