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
NameTypeConstraintsDescription
bank_reconciliation_statement_summary_KEYint (4)NOT NULLPrimary key for this table
bank_reconciliation_statement_KEYint (4)NOT NULLThe key of the reconciliation to which a statement summary record pertains.
statement_summary_indexint (4)NOT NULLWith 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.
amountdecimal (9, 2)NOT NULLThe amount for one statement -- either the credit amount or the debit amount.
is_creditbit (1)NOT NULLEach 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
NameColumnsDescription
PK_Bank_Reconciliation_Statement_Summarybank_reconciliation_statement_summary_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Bank_Reconciliation_Statement_Summary__Bank_Reconciliation_Statement__bank_reconciliation_statement_KEYbank_reconciliation_statement_KEYBank_Reconciliation_Statement (bank_reconciliation_statement_KEY)

Schema diagram