Table: dbo.Bank_Reconciliation_Client_Adjustment
This table stores adjustments that show adjustments that the user wants one of their clients to make in their own bank account records. Adjustments in this table do not impact the general ledger, they are used for report purposes only. They do not impact any bank reconciliation statement totals, they are just intended as a means for a user to convey information to one of their clients about adjustments the client has to make to their own records.
Columns
NameTypeConstraintsDescription
bank_reconciliation_client_adjustment_KEYint (4)NOT NULLPrimary key for this table.
descriptionnvarchar (510)NOT NULLA description provided to explain the reason for the adjustment.
amountdecimal (9, 2)NOT NULLThe amount of the adjustment.
sequence_numberint (4)NOT NULLThis will allow the user to order adjustments and store the order. This is the order in which adjustments will be shown in the bank reconciliation user interface.
bank_reconciliation_statement_KEYint (4)NOT NULLA foreign key to link each client adjustment to a bank reconciliation statement.
Primary key
NameColumnsDescription
PK_Bank_Reconciliation_Client_Adjustmentbank_reconciliation_client_adjustment_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Bank_Reconciliation_Client_Adjustment__Bank_Reconciliation_Statement__bank_reconciliation_statement_KEYbank_reconciliation_statement_KEYBank_Reconciliation_Statement (bank_reconciliation_statement_KEY)

Schema diagram