Table: dbo.Bank_Reconciliation_Adjustment_Order
Columns
Name | Type | Constraints | Description
bank_reconciliation_adjustment_order_KEY | int (4) | NOT NULL | Primary key for this table
bank_reconciliation_adjustment_type_KEY | int (4) | NOT NULL | The key of the adjustment type.
bank_reconciliation_statement_KEY | int (4) | NOT NULL | The key of the reconciliation in which this adjustment appears
bank_transaction_KEY | int (4) | NOT NULL | The key of the adjustment transaction
sequence_number | int (4) | NOT NULL | The 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
Name | Columns | Description
PK_Bank_Reconciliation_Adjustment_Order | bank_reconciliation_adjustment_order_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Bank_Reconciliation_Adjustment_Order__Bank_Reconciliation_Adjustment_Type__bank_reconciliation_adjustment_type_KEY | bank_reconciliation_adjustment_type_KEY | Bank_Reconciliation_Adjustment_Type (bank_reconciliation_adjustment_type_KEY) |
FK_Bank_Reconciliation_Adjustment_Order__Bank_Reconciliation_Statement__bank_reconciliation_statement_KEY | bank_reconciliation_statement_KEY | Bank_Reconciliation_Statement (bank_reconciliation_statement_KEY) |
FK_Bank_Reconciliation_Adjustment_Order__Bank_Transaction__bank_transaction_KEY | bank_transaction_KEY | Bank_Transaction (bank_transaction_KEY) |