Table: dbo.Bank_Reconciliation_Statement_Summary
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.
Columns
Name | Type | Constraints | Description
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.

Primary key
Name | Columns | Description
PK_Bank_Reconciliation_Statement_Summary | bank_reconciliation_statement_summary_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Bank_Reconciliation_Statement_Summary__Bank_Reconciliation_Statement__bank_reconciliation_statement_KEY | bank_reconciliation_statement_KEY | Bank_Reconciliation_Statement (bank_reconciliation_statement_KEY) |