bank_reconciliation_statement_KEY | int (4) | NOT NULL | Links us to a reconciliation (one bank account, one period). |
bank_reconciliation_statement_detail_KEY | int (4) | NOT NULL | The primary key for this table. |
bank_transaction_reconciliation_detail_KEY | int (4) | NOT NULL | Links us to the bank transaction detail related to this record. |
bank_transaction__bank_transaction_type_KEY | int (4) | NOT NULL | Tells us what this is: check, deposit, or something else. |
bank_reconciliation_clear_status_KEY | int (4) | NOT NULL | Tells us if this item is cleared or uncleared in the bank reconciliation to which this record is related. |
bank_transaction__transaction_date | smalldatetime (4) | NOT NULL | Bank transaction detail date. |
bank_transaction__reference_number | nvarchar (32) | NOT NULL | Bank transaction reference. |
bank_transaction_detail__amount | decimal (9, 2) | NOT NULL | Bank transaction detail amount. |
bank_transaction_detail__description | nvarchar (240) | NOT NULL | Bank transaction detail description. |
cleared_amount | decimal (9, 2) | NOT NULL | Amount that this item was cleared for, but zero if no adjustment was made. |
adjustment_amount | decimal (9, 2) | NOT NULL | amount of adjustment, if any. |
adjustment__gl_account_KEY | int (4) | | GL account used if an adjustment is made. |
adjustment_reason | nvarchar (240) | NOT NULL | Reason given for an adjustment. |
adjustment__bank_transaction_KEY | int (4) | | Links us to the transaction to which the adjustment was made. |
bank_reconciliation_adjustment_type_KEY | int (4) | NOT NULL | The key of the adjustment type |
bank_reconciliation_recurring_adjustment_template_KEY | int (4) | | The key of the adjustment template, if any. This is only set non-null when the adjustment is a recurring adjustment, to provide linkage to the appropriate recurring adjustment template. |