Table: dbo.Client_Bank_Reconciliation_Option
Columns
NameTypeConstraintsDescription
client_KEYint (4)NOT NULLPrimary key 0...1 to Client Table
view_check_detailbit (1)NOT NULLView check detail
view_deposit_detailbit (1)NOT NULLView deposit detail
use_check_number_as_reference_numberbit (1)NOT NULLUse check number as the transaction reference number for adjustments to checks
show_graphbit (1)NOT NULLShow Graph "Prior Reconciliation Ending Balances"
do_not_default_direct_deposit_to_clearedbit (1)NOT NULLDetermines 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_accountsbit (1)NOT NULLOption to not display any reconciliations for inactive bank accounts in bank reconciliation.
Primary key
NameColumnsDescription
PK_Client_Bank_Reconciliation_Option$client_KEYclient_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Client_Bank_Reconciliation_Option__Client__client_KEYclient_KEYClient (client_KEY)

Schema diagram