Table: dbo.Bank_Reconciliation_Rapid_Clear_Unmatched_Transaction | |||
This table will hold all the pending unmatched keyed-in data in the Rapid Clear dialog for a given bank reconciliation. This data will be deleted for finalized bank reconciliations. | |||
Columns | |||
Name | Type | Constraints | Description |
bank_reconciliation_rapid_clear_unmatched_transaction_KEY | int (4) | NOT NULL | Primary key |
bank_reconciliation_statement_KEY | int (4) | NOT NULL | Foreign key to the associated bank reconciliation statement. |
impound__client_KEY | int (4) | Client key for IBAR, null for BAR. | |
gl_balance_effect_KEY | int (4) | NOT NULL | Foreign key to the GL_Balance_Effect table. 1 if the transaction is a debit, 2 if it is a credit. |
reference_number | nvarchar (32) | NOT NULL | Reference number for debits, empty string for credits. |
amount | decimal (9, 2) | NOT NULL | Amount keyed-in by the user. |
Primary key | |||
Name | Columns | Description | |
PK_Bank_Reconciliation_Rapid_Clear_Unmatched_Transaction | bank_reconciliation_rapid_clear_unmatched_transaction_KEY |