| Table a_ep_account |
|
Description: This contains the settings for one specific bank account |
| PRIMARY KEY | ||
|
a_banking_details_key_i
integer NOT NULL | The bank account whose settings are defined here | p_banking_details |
|
a_ledger_number_i
integer default: 0 NOT NULL | The bank account has to be assigned to a ledger | a_ledger, a_account, a_motivation_detail |
|
a_account_code_c
varchar (16) NOT NULL | The GL account for the bank account | a_account |
|
a_importfile_path_c
varchar (200) | This tells the plugin where to find the statement files for this bank account | |
|
a_exportfile_path_c
varchar (200) | This tells the plugin where to write any generated files for this bank account | |
|
a_plugin_filename_c
varchar (200) | This can be either the name of an executable or a DLL that is able to process the country (or bank) specific bank statements | |
|
a_plugin_parameters_c
varchar (500) | Other parameters for the plugin can be stored here | |
|
a_confidential_gift_flag_l
boolean default: '0' | if this is true, all gifts to this bank account get this flag set | |
|
a_tax_deductible_l
boolean default: '1' | Whether the gifts to this bank account are tax deductible | |
|
a_motivation_group_code_c
varchar (16) | This defines a default motivation group. | a_motivation_detail |
|
a_motivation_detail_code_c
varchar (16) | This defines a default motivation detail within a motivation group. | a_motivation_detail |
|
s_date_created_d
date default: CURRENT_DATE | The date the record was created. | |
|
s_created_by_c
varchar (20) | User ID of who created this record. | s_user |
|
s_date_modified_d
date | The date the record was modified. | |
|
s_modified_by_c
varchar (20) | User ID of who last modified this record. | s_user |
|
s_modification_id_t
timestamp default: CURRENT_TIMESTAMP | This identifies the current version of the record. | |
FOREIGN KEY a_ep_account_fk1: a_banking_details_key_i => p_banking_details a_ep_account_fk2: a_ledger_number_i => a_ledger a_ep_account_fk3: a_ledger_number_i;a_account_code_c => a_account a_ep_account_fk4: a_ledger_number_i;a_motivation_group_code_c;a_motivation_detail_code_c => a_motivation_detail a_ep_account_fkcr: s_created_by_c => s_user a_ep_account_fkmd: s_modified_by_c => s_user | ||