Table: dbo.Bank_Reconciliation_Adjustment_Order
Columns
NameTypeConstraintsDescription
bank_reconciliation_adjustment_order_KEYint (4)NOT NULLPrimary key for this table
bank_reconciliation_adjustment_type_KEYint (4)NOT NULLThe key of the adjustment type.
bank_reconciliation_statement_KEYint (4)NOT NULLThe key of the reconciliation in which this adjustment appears
bank_transaction_KEYint (4)NOT NULLThe key of the adjustment transaction
sequence_numberint (4)NOT NULLThe order of the adjustment transaction, as it appears in the user interface (either the recurring adjustments dialog or the non-recurring adjustments dialog)
Primary key
NameColumnsDescription
PK_Bank_Reconciliation_Adjustment_Orderbank_reconciliation_adjustment_order_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Bank_Reconciliation_Adjustment_Order__Bank_Reconciliation_Adjustment_Type__bank_reconciliation_adjustment_type_KEYbank_reconciliation_adjustment_type_KEYBank_Reconciliation_Adjustment_Type (bank_reconciliation_adjustment_type_KEY)
FK_Bank_Reconciliation_Adjustment_Order__Bank_Reconciliation_Statement__bank_reconciliation_statement_KEYbank_reconciliation_statement_KEYBank_Reconciliation_Statement (bank_reconciliation_statement_KEY)
FK_Bank_Reconciliation_Adjustment_Order__Bank_Transaction__bank_transaction_KEYbank_transaction_KEYBank_Transaction (bank_transaction_KEY)

Schema diagram