| Table: dbo.Client_Direct_Deposit | |||
| Columns | |||
| Name | Type | Constraints | Description |
| checkbook_KEY | int (4) | NOT NULL | checkbook_KEY |
| default_direct_deposit_file_setup | bit (1) | NOT NULL | Flag indicating that this direct deposit setup is the default. |
| primary_bank_account | bit (1) | NOT NULL | primary_bank_account |
| originator__bank_KEY | int (4) | NOT NULL | ACH originator bank key |
| immediate_origin_name_selection | int (4) | NOT NULL | ACH immediate origin name source selection - See CK_Client_Direct_Deposit__immediate_origin_name_selection for more details. |
| immediate_origin_name_other | nvarchar (46) | NOT NULL | ACH immediate origin name to use if immediate_origin_name is "other" |
| immediate_origin_id_selection | int (4) | NOT NULL | ACH immediate origin id source selection - See CK_Client_Direct_Deposit__immediate_origin_id_selection for more details. |
| immediate_origin_id_other | nvarchar (20) | NOT NULL | ACH immediate origin id to use if immediate_origin_id is "other" |
| immediate_destination__bank_KEY | int (4) | NOT NULL | ACH immediate destination bank key |
| create_balanced_file_for_payroll_checks | bit (1) | NOT NULL | Balanced file creation requested for payroll checks. |
| create_balanced_file_for_vendor_checks | bit (1) | NOT NULL | Balanced file creation requested for vendor checks. |
| create_balanced_file_for_tax_deposits | bit (1) | NOT NULL | Balanced file creation requested for tax deposits. |
| direct_deposit_status_KEY | nvarchar (16) | NOT NULL | Status of direct deposit info. |
| company_name_selection | int (4) | NOT NULL | ACH company name source selection - See CK_Client_Direct_Deposit__company_name_selection for more details. |
| company_name_other | nvarchar (32) | NOT NULL | ACH company name if company_name is "other" |
| company_id_selection | int (4) | NOT NULL | ACH company id source selection - See CK_Client_Direct_Deposit__company_id_selection for more details. |
| company_id_other | nvarchar (20) | NOT NULL | ACH company id if company_id is "other" |
| leading_number | int (4) | NOT NULL | ACH leading_number |
| individual_id_selection | int (4) | NOT NULL | ACH individual id source selection - See CK_Client_Direct_Deposit__individual_id_selection for more details. |
| reference_code | nvarchar (16) | NOT NULL | ACH reference code |
| company_discretionary_data | nvarchar (40) | NOT NULL | ACH company discretionary data |
| company_descriptive_date | nvarchar (12) | NOT NULL | ACH company descriptive date |
| use_file_header | bit (1) | NOT NULL | Use file header for ACH |
| exclude_eight_record | bit (1) | NOT NULL | exclude eight record from ACH |
| automatically_override_waiting_status | bit (1) | NOT NULL | Automatically override waiting status |
| override_waiting_status_days | int (4) | NOT NULL | Override waiting status days |
| prenote_date | smalldatetime (4) | Date of prenote transaction | |
| prenote_created | bit (1) | NOT NULL | Flag indicating that a prenote file have been created for this entry |
| payroll_ncv_effective_date_selection | tinyint (1) | NOT NULL | Payroll and non-commercial vendor use for effective date selection. 1== CheckDate 2 == SystemDate |
| payroll_ncv_effective_date_offset | smallint (2) | NOT NULL | Payroll and non-commercial vendor effective date banking days offset |
| commercial_vendor_effective_date_selection | tinyint (1) | NOT NULL | Commercial vendor use for effective date selection. 1== CheckDate 2 == SystemDate |
| commercial_vendor_effective_date_offset | smallint (2) | NOT NULL | Commercial vendor effective date banking days offset |
| tax_payment_effective_date_selection | tinyint (1) | NOT NULL | Tax payments use for effective date selection. 1== CheckDate 2 == SystemDate |
| tax_payment_effective_date_offset | smallint (2) | NOT NULL | Tax payments effective date banking days offset |
| child_support_effective_date_selection | tinyint (1) | NOT NULL | Child support use for effective date setting. 1== CheckDate 2 == SystemDate |
| child_support_effective_date_offset | smallint (2) | NOT NULL | Child support effective date banking days offset |
| record_created_date | smalldatetime (4) | NOT NULL | Date this record was created - used when automatically updating status to approved. |
| create_balanced_file_for_fund_checks | bit (1) | NOT NULL | Balanced file creation requested for fund checks. |
| process_via_intercept | bit (1) | NOT NULL | 1 means Direct deposit transactions are processed by ACS via InterceptEFT. 0 means (absent another transmitter) the user will handle transmission by hand. |
| client_direct_deposit_KEY | int (4) | NOT NULL | Primary key to the table. |
| is_client_record | bit (1) | NOT NULL | Denotes this entry is for client access direct deposit (T) or firm direct deposit (F). |
| combine_like_company_batch | bit (1) | NOT NULL | Option to combine entry detail records under a single client batch header record where the client batch headers are identical. |
| prenote_effective_date | smalldatetime (4) | The effective date used when prenoting this allocation. | |
| notes | nvarchar (480) | NOT NULL | Direct deposit processing notes when this allocation is prenoted. |
| add_crlf_to_end_of_file | bit (1) | NOT NULL | Flag which indicates the user wants a carriage return / line feed added to the end of the ACH file. |
| create_separate_ccd_batch_for_ppd_balancing_entry | bit (1) | NOT NULL | When true we will create a separate CCD batch for the balancing entry of a PPD transaction (assuming there is a balancing entry). |
| Primary key | |||
| Name | Columns | Description | |
| PK_Client_Direct_Deposit | client_direct_deposit_KEY | ||
| Incoming foreign keys | |||
| Name | Columns | Referencing table | Description |
| FK_Direct_Deposit_Fileheader__Client_Direct_Deposit__client_direct_deposit_KEY | client_direct_deposit_KEY | Direct_Deposit_Fileheader | |