| Table: dbo.Client_Bank_Reconciliation_Option | |||
| Columns | |||
| Name | Type | Constraints | Description |
| client_KEY | int (4) | NOT NULL | Primary key 0...1 to Client Table |
| view_check_detail | bit (1) | NOT NULL | View check detail |
| view_deposit_detail | bit (1) | NOT NULL | View deposit detail |
| use_check_number_as_reference_number | bit (1) | NOT NULL | Use check number as the transaction reference number for adjustments to checks |
| show_graph | bit (1) | NOT NULL | Show Graph "Prior Reconciliation Ending Balances" |
| do_not_default_direct_deposit_to_cleared | bit (1) | NOT NULL | Determines whether direct deposit transactions are defaulted to be marked as cleared or not.["BR"] Default to false (this means default to clear direct deposits). |
| do_not_display_inactive_bank_accounts | bit (1) | NOT NULL | Option to not display any reconciliations for inactive bank accounts in bank reconciliation. |
| Primary key | |||
| Name | Columns | Description | |
| PK_Client_Bank_Reconciliation_Option$client_KEY | client_KEY | ||
| Foreign keys | |||
| Name | Columns | Referenced table | Description |
| FK_Client_Bank_Reconciliation_Option__Client__client_KEY | client_KEY | Client (client_KEY) | |