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 |