This table will store bank reconciliation statement summary data entered by the user. The statement summary dialog is an optional feature in bank reconciliation and allows users to enter statement deposits/other credits and check/other debits amounts for multiple statements, amounts which are totaled and carry into one bank reconciliation. |
bank_reconciliation_statement_summary_KEY | int (4) | NOT NULL | Primary key for this table |
bank_reconciliation_statement_KEY | int (4) | NOT NULL | The key of the reconciliation to which a statement summary record pertains. |
statement_summary_index | int (4) | NOT NULL | With the current design, up to 12 debit and 12 credit amounts can be entered per statement. Each record in this table will be one of those 12, and this field tells us which it is. The acceptable range of values is 1 - 12. |
amount | decimal (9, 2) | NOT NULL | The amount for one statement -- either the credit amount or the debit amount. |
is_credit | bit (1) | NOT NULL | Each record in this table will be either a deposits/other credits amount or a checks/other debits amount. When this field is true then it is a credit amount. |