Table: dbo.Bank_Reconciliation_Adjustment_Type
Columns
NameTypeConstraintsDescription
bank_reconciliation_adjustment_type_KEYint (4)NOT NULLThe primary key for this table.
descriptionnvarchar (60)NOT NULLThe reconciliation adjustment type description. Not an adjustment means not an adjustment in bank reconciliation. Recurring means a recurring adjustment in bank reconciliation, one that the user enters each statement period for a given checkbook. Non Recurring means an adjustment for one statement period only. Line Items means an adjustment to a check or other item; Line item adjustment is used when a check or other item is cleared for an amount different than the original amount.
Primary key
NameColumnsDescription
PK_Bank_Reconciliation_Adjustment_Typebank_reconciliation_adjustment_type_KEY
Unique constraints
NameColumnsDescription
UK_Bank_Reconciliation_Adjustment_Type$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Bank_Reconciliation_Adjustment_Order__Bank_Reconciliation_Adjustment_Type__bank_reconciliation_adjustment_type_KEYbank_reconciliation_adjustment_type_KEYBank_Reconciliation_Adjustment_Order
FK_Bank_Reconciliation_Statement_Detail__Bank_Reconciliation_Adjustment_Type__bank_reconciliation_adjustment_type_KEYbank_reconciliation_adjustment_type_KEYBank_Reconciliation_Statement_Detail

Schema diagram