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
Name | Type | Constraints | Description
bank_reconciliation_client_adjustment_KEY | int (4) | NOT NULL | Primary key for this table.
description | nvarchar (510) | NOT NULL | A description provided to explain the reason for the adjustment.
amount | decimal (9, 2) | NOT NULL | The amount of the adjustment.
sequence_number | int (4) | NOT NULL | This 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_KEY | int (4) | NOT NULL | A foreign key to link each client adjustment to a bank reconciliation statement.

Primary key
Name | Columns | Description
PK_Bank_Reconciliation_Client_Adjustment | bank_reconciliation_client_adjustment_KEY |

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