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. |
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. |