bank_reconciliation_recurring_adjustment_template_KEY | int (4) | NOT NULL | Primary key for this table |
description | nvarchar (240) | NOT NULL | The description of the adjustment |
bank_transaction_type_KEY | int (4) | NOT NULL | The key of the transaction type of the adjustment |
checkbook_KEY | int (4) | NOT NULL | The key of the checkbook of this adjustment. Every checkbook will have its own templates. |
sequence_number | int (4) | NOT NULL | tells us where the user wants to see a particular recurring adjustment when the recurring adjustment dialog is displayed for the first time in a new reconciliation |
deletion__bank_reconciliation_statement_KEY | int (4) | | The bank reconciliation statement key of the bank reconciliation in which a record was deleted. NULL if it has not been deleted. |
creation__bank_reconciliation_statement_KEY | int (4) | NOT NULL | The bank reconciliation statement key of the bank reconciliation in which a record was added. |
vendor_KEY | int (4) | | Bank Reconciliation recurring adjustment templates are used to create new bank reconciliation recurring adjustments. These adjustments are created once for each reconciliation for the checkbook with which they are associated. Each entry in the Bank_Reconciliation_Recurring_Adjustment_Template table represents one recurring adjustment, for the checkbook signified by the checkbook_KEY in the Bank_Reconciliation_Recurring_Adjustment_Template table record. Bank Reconciliation Recurring adjustments will have one of two bank transaction types: either payment or addition. Some recurring adjustments of bank transaction type payment will have a vendor associated with them, and thus will have a value for vendor_KEY in this table. Recurring adjustments of type Addition will not have a vendor associated with them, and thus in this table vendor_KEY will be null for recurring adjustment templates of type addition. The vendor key from the recurring adjustment template table becomes an entry in the Vendor_Bank_Transaction table when the recurring adjustment is created from the recurring adjustment template. |