Table: dbo.Bank_Reconciliation_Recurring_Adjustment_Template
Columns
NameTypeConstraintsDescription
bank_reconciliation_recurring_adjustment_template_KEYint (4)NOT NULLPrimary key for this table
descriptionnvarchar (240)NOT NULLThe description of the adjustment
bank_transaction_type_KEYint (4)NOT NULLThe key of the transaction type of the adjustment
checkbook_KEYint (4)NOT NULLThe key of the checkbook of this adjustment. Every checkbook will have its own templates.
sequence_numberint (4)NOT NULLtells 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_KEYint (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_KEYint (4)NOT NULLThe bank reconciliation statement key of the bank reconciliation in which a record was added.
vendor_KEYint (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
NameColumnsDescription
PK_Bank_Reconciliation_Recurring_Adjustment_Templatebank_reconciliation_recurring_adjustment_template_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Bank_Reconciliation_Recurring_Adjustment_Template__Bank_Reconciliation_Statement__creation__bank_reconciliation_statement_KEYcreation__bank_reconciliation_statement_KEYBank_Reconciliation_Statement (bank_reconciliation_statement_KEY)
FK_Bank_Reconciliation_Recurring_Adjustment_Template__Bank_Reconciliation_Statement__deletion__bank_reconciliation_statement_KEYdeletion__bank_reconciliation_statement_KEYBank_Reconciliation_Statement (bank_reconciliation_statement_KEY)
FK_Bank_Reconciliation_Recurring_Adjustment_Template__Bank_Transaction_Type__bank_transaction_type_KEYbank_transaction_type_KEYBank_Transaction_Type (bank_transaction_type_KEY)
FK_Bank_Reconciliation_Recurring_Adjustment_Template__Checkbook__checkbook_KEYcheckbook_KEYCheckbook (checkbook_KEY)
FK_Bank_Reconciliation_Recurring_Adjustment_Template__Vendor__vendor_KEYvendor_KEYVendor (vendor_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Bank_Reconciliation_Recurring_Adjustment_Template_Distribution__Bank_Reconciliation_Recurring_Adjustment_Template__bank_reconbank_reconciliation_recurring_adjustment_template_KEYBank_Reconciliation_Recurring_Adjustment_Template_Distribution
FK_Bank_Reconciliation_Statement_Detail__Bank_Reconciliation_Recurring_Adjustment_Template__bank_reconciliation_recurring_adjustbank_reconciliation_recurring_adjustment_template_KEYBank_Reconciliation_Statement_Detail

Schema diagram