Table: dbo.Bank_Reconciliation_Recurring_Adjustment_Template
Columns
Name | Type | Constraints | Description
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.

Primary key
Name | Columns | Description
PK_Bank_Reconciliation_Recurring_Adjustment_Template | bank_reconciliation_recurring_adjustment_template_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Bank_Reconciliation_Recurring_Adjustment_Template__Bank_Reconciliation_Statement__creation__bank_reconciliation_statement_KEY | creation__bank_reconciliation_statement_KEY | Bank_Reconciliation_Statement (bank_reconciliation_statement_KEY) |
FK_Bank_Reconciliation_Recurring_Adjustment_Template__Bank_Reconciliation_Statement__deletion__bank_reconciliation_statement_KEY | deletion__bank_reconciliation_statement_KEY | Bank_Reconciliation_Statement (bank_reconciliation_statement_KEY) |
FK_Bank_Reconciliation_Recurring_Adjustment_Template__Bank_Transaction_Type__bank_transaction_type_KEY | bank_transaction_type_KEY | Bank_Transaction_Type (bank_transaction_type_KEY) |
FK_Bank_Reconciliation_Recurring_Adjustment_Template__Checkbook__checkbook_KEY | checkbook_KEY | Checkbook (checkbook_KEY) |
FK_Bank_Reconciliation_Recurring_Adjustment_Template__Vendor__vendor_KEY | vendor_KEY | Vendor (vendor_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Bank_Reconciliation_Recurring_Adjustment_Template_Distribution__Bank_Reconciliation_Recurring_Adjustment_Template__bank_recon | bank_reconciliation_recurring_adjustment_template_KEY | Bank_Reconciliation_Recurring_Adjustment_Template_Distribution |
FK_Bank_Reconciliation_Statement_Detail__Bank_Reconciliation_Recurring_Adjustment_Template__bank_reconciliation_recurring_adjust | bank_reconciliation_recurring_adjustment_template_KEY | Bank_Reconciliation_Statement_Detail |