Table which holds data related to clients bank accounts. |
checkbook_KEY | int (4) | NOT NULL | Primary key for this table. |
client_KEY | int (4) | NOT NULL | Key of client that owns the checkbook. |
description | nvarchar (100) | NOT NULL | Checkbook description. |
bank_KEY | int (4) | | Key of Bank account is tied to. |
bank_account_type_KEY | nvarchar (22) | NOT NULL | Type of bank account. |
bank_account_number | nvarchar (34) | NOT NULL | Bank account the checkbook draws from. |
next_check_number | int (4) | NOT NULL | Next check number. |
next_direct_deposit_voucher_id | nvarchar (30) | NOT NULL | ID of next direct deposit voucher. |
use_separate_direct_deposit_voucher_id | bit (1) | NOT NULL | Flag which indicates that direct deposit check serial numbers should be drawn from the next_direct_deposit_voucher_id field instead of the next_check_number field |
bank_reconciliation_reference_number | nvarchar (30) | NOT NULL | Reference number to use for bank reconciliation. |
payroll_layout__report_definition_KEY | int (4) | | Key of report definition to use when printing payroll checks from this checkbook. |
vendor_layout__report_definition_KEY | int (4) | | Key of report definition to use when printing vendor checks from this checkbook. |
logo__report_image_KEY | int (4) | | Bank logo image |
signature_1__report_image_KEY | int (4) | | First signature image |
signature_2__report_image_KEY | int (4) | | Second signature image |
date_format_KEY | int (4) | | Date format to use on printed checks. |
bank_account_direct_deposit_status_KEY | nvarchar (16) | NOT NULL | FK the direct deposit prenote status |
number_of_digits_allowed_for_micr_auxiliary_onus | tinyint (1) | NOT NULL | Number of digits allowed for the MICR auxiliary on-us field |
starting_position_of_micr_onus | tinyint (1) | NOT NULL | Starting position for printing the MICR on-us field |
use_beginning_micr_onus_symbol | bit (1) | NOT NULL | Flag which indicates if the leading MICR symbol is printed for the on-us field |
funding_effective_date_selection | tinyint (1) | NOT NULL | Firm funding effective date selection. 1== CheckDate 2 == SystemDate |
funding_effective_date_offset | int (4) | NOT NULL | Firm funding effective date banking days offset |
fund_payroll_transaction | bit (1) | NOT NULL | Flag which indicates that this bank account will automatically generate impound funding transactions for payroll checks |
fund_tax_agent_transaction | bit (1) | NOT NULL | Flag which indicates that this bank account will automatically generate impound funding transactions for payroll tax agent checks |
fund_firm_vendor_transaction | bit (1) | NOT NULL | Flag which indicates that this bank account will automatically generate impound funding transactions for vendor checks |
fund_payroll_agent_transaction | bit (1) | NOT NULL | Flag which indicates that this bank account will automatically generate impound funding transactions for payroll agent checks |
is_account_inactive | bit (1) | NOT NULL | Is account inactive flag. |
gl_account_KEY | int (4) | | Key to the gl_account the checkbook draws from. |
bank_reconciliation_frequency_type_KEY | int (4) | NOT NULL | Reconciliation frequency time period |
bank_reconciliation_finalized_available_to_edit | int (4) | NOT NULL | The value of this column indicates how many prior finalized bank reconciliation statements are eligible to be opened back up and edited by the user. The maximum number allowed is based on the reconciliation frequency as follows: one years worth for Daily and Weekly and two years worth for Monthly, Quarterly, Semiannually, and Annually. |
tax_agent_funding_liability__gl_account_KEY | int (4) | | The GL Account for the tax agents funding liability. |
payroll_funding_liability__gl_account_KEY | int (4) | | The GL Account for the payroll funding liability. |
payroll_agent_funding_liability__gl_account_KEY | int (4) | | The GL Account for the payroll agents funding liability. |
account_holder_name | nvarchar (100) | NOT NULL | Contains the name of the account holder |
bank_reconciliation__journal_KEY | int (4) | NOT NULL | The key of the journal used in bank reconciliation when writing transactions with a General Ledger component, such as adjustments. |
positive_pay_start_date | smalldatetime (4) | | Start date for valid checks to include in the process positive pay view. Null means select all transactions. |
positive_pay__export_text_file_format_KEY | int (4) | | Export text file format to use to create positive pay files for this checkbook. Null means this checkbook is not set up for Positive Pay. |
micr_line_format_KEY | int (4) | NOT NULL | Type of format selected for MICR line (Standard, Custom). |
custom_micr_section_1 | nvarchar (40) | NOT NULL | First section of the custom MICR line (can be Aux on-us, transit or on-us). |
custom_micr_section_2 | nvarchar (24) | NOT NULL | Second section of the custom MICR line (can be Aux on-us, transit or on-us). |
custom_micr_section_3 | nvarchar (36) | NOT NULL | Third section of the custom MICR line (can be Aux on-us, transit or on-us). |
form_adjustment_write_off_threshold | decimal (9, 2) | NOT NULL | Impound only: Threshold amount for form adjustement write off. |
form_adjustment_write_off__gl_account_KEY | int (4) | | Impound only: The GL account for form adjustment write off. NULL indicates no account has been selected. |
impounding__gl_account_KEY | int (4) | | ACS-specific field for allowing a Bank Account to select an Impounding holding GL account. A null value indicates that an account was not selected. |
payroll_check_printing_primary_sort_by_type_KEY | int (4) | NOT NULL | Reference to primary sort by type for printing payroll checks |
employee_sort_by_type_KEY | int (4) | | Reference to secondary sort by type for printing payroll checks |
payroll_check_printing_primary__sort_order_type_KEY | int (4) | NOT NULL | Reference to primary sort order for printing payroll checks |
payroll_check_printing_secondary__sort_order_type_KEY | int (4) | NOT NULL | Reference to secondary sort order for printing payroll checks |
vendor_payment_primary_sort_by_type_KEY | int (4) | NOT NULL | Reference to primary sort by type for printing vendor checks |
vendor_payment_primary__sort_order_type_KEY | int (4) | NOT NULL | Reference to primary sort order for printing vendor checks |
fund_only_printed_payroll_checks | bit (1) | NOT NULL | Flag indicating funding only printed payroll checks. |
fund_only_printed_payroll_agent_checks | bit (1) | NOT NULL | Flag indicating funding only printed payroll agent checks. |
fund_only_printed_tax_agent_checks | bit (1) | NOT NULL | Flag indicating funding only printed tax agent checks. |
ap_layout__report_definition_KEY | int (4) | | Key of report definition to use when printing AP checks from this checkbook. Null means no AP layout was selected for this checkbook. |
is_online_bill_pay_bank_account | bit (1) | NOT NULL | |
fund_payroll_transaction_type_KEY | int (4) | NOT NULL | Contains a key to the type of fund payroll transaction selected. This is a modifier for the behavior specified by the fund payroll transactions field. |
export__quick_books_account_KEY | int (4) | | A foreign key to the Quick_Books_Account table, this is the quickbooks side of the mapping during the Acs to Quickbooks export data mapping process. This will be used to map Accounting CS checkbooks to QuickBooks GL accounts of type bank. This key will be null if no export mapping has been done. |
checkbook_guid | uniqueidentifier (16) | NOT NULL | A unique identifer for each checkbook row. |
prompt_for_next_check_number | bit (1) | NOT NULL | Indicates if we should prompt the user for the next check number when printing checks. |
starting_position_of_micr_onus_deposit_slip | tinyint (1) | NOT NULL | Starting position for printing the MICR on-us deposit slip field. Minimum value for starting position is 28, maximum is 32 and the default value is 31, this default ["BR"] value 31 is common for majority bank accounts |
custom_micr_section_1_deposit_slip | nvarchar (40) | NOT NULL | First section of the custom MICR line for deposit slip(can be Aux on-us, transit or on-us). If we choose custom option, user has to enter some value. We do not have ["BR"] any default and minimum length is 1, maximum length is 20 for this section |
custom_micr_section_2_deposit_slip | nvarchar (24) | NOT NULL | Second section of the custom MICR line for deposit slip(can be Aux on-us, transit or on-us).If we choose custom option, user has to enter some value. We do not have ["BR"] any default and minimum length is 1, maximum length is 12 for this section |
custom_micr_section_3_deposit_slip | nvarchar (36) | NOT NULL | Third section of the custom MICR line for deposit slip(can be Aux on-us, transit or on-us). If we choose custom option, user has to enter some value. We do not have ["BR"] any default value and minimum length is 1, maximum length is 18 for this section |
deposit_slip__micr_line_format_KEY | int (4) | NOT NULL | Type of format selected for MICR line for deposit slip(Standard, Custom). Standard is by default because some banks use the same routing number for deposit slips ["BR"] as they do for checks and for Custom, if the routing number needs to be different for deposit slips, then they can set it to custom and manually enter the correct["BR"] information |
use_beginning_micr_onus_symbol_deposit_slip | bit (1) | NOT NULL | Flag which indicates if the leading MICR symbol is printed for the on-us field for deposit slips |
deposit_layout__report_definition_KEY | int (4) | | Key of report definition to use when printing deposit slip from this checkbook. |
vendor_payment_secondary__sort_order_type_KEY | int (4) | NOT NULL | It determines the sort order (ascending or descending) for secondary sorting. |
vendor_payment_secondary_sort_by_type_KEY | int (4) | | This stores the key for secondary sort order. |
yodlee_financial_account_link_status_KEY | tinyint (1) | NOT NULL | The yodlee financial account link status. |
allow_all_applicable_firm_staff_access | bit (1) | NOT NULL | Bit field that indicates whether or not all the standard firm staff having access to the parent client have access to this checkbook |
allow_all_applicable_client_staff_access | bit (1) | NOT NULL | Bit field that indicates whether or not all the client staff having access to the parent client have access to this checkbook. |
pre_numbered_check_stock | bit (1) | NOT NULL | Pre-numbered check stock option, when printing checks, we can use this option to know if multi-page checks["BR"] should work as they do today (0) or if multi-page checks should skip check numbers["BR"] based on the number of pages the check takes up (1). |