Table openpetra_trunk.public.a_ep_account
This contains the settings for one specific bank account

 Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
a_banking_details_key_i int4 10
p_banking_details.p_banking_details_key_i a_ep_account_fk1 R
The bank account whose settings are defined here
a_ledger_number_i int4 10 0
a_account.a_ledger_number_i a_ep_account_fk3 R
a_motivation_detail.a_ledger_number_i a_ep_account_fk4 R
a_ledger.a_ledger_number_i a_ep_account_fk2 R
The bank account has to be assigned to a ledger
a_account_code_c varchar 16
a_account.a_account_code_c a_ep_account_fk3 R
The GL account for the bank account
a_importfile_path_c varchar 200  √  null This tells the plugin where to find the statement files for this bank account
a_exportfile_path_c varchar 200  √  null This tells the plugin where to write any generated files for this bank account
a_plugin_filename_c varchar 200  √  null 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  √  null Other parameters for the plugin can be stored here
a_confidential_gift_flag_l bool 1  √  false if this is true, all gifts to this bank account get this flag set
a_tax_deductable_l bool 1  √  true Whether the gifts to this bank account are tax deductable
a_motivation_group_code_c varchar 16  √  null
a_motivation_detail.a_motivation_group_code_c a_ep_account_fk4 R
This defines a default motivation group.
a_motivation_detail_code_c varchar 16  √  null
a_motivation_detail.a_motivation_detail_code_c a_ep_account_fk4 R
This defines a default motivation detail within a motivation group.
s_date_created_d date 13  √  ('now'::text)::date
s_created_by_c varchar 20  √  null
s_user.s_user_id_c a_ep_account_fkcr R
s_date_modified_d date 13  √  null
s_modified_by_c varchar 20  √  null
s_user.s_user_id_c a_ep_account_fkmd R
s_modification_id_c varchar 150  √  null

Table contained 0 rows at Mi Nov 09 18:02 MEZ 2011

Indexes:
Column(s) Type Sort Constraint Name
a_banking_details_key_i Primary key Asc a_ep_account_pk
a_ledger_number_i Performance Asc inx_a_ep_account_fk2_key1
a_ledger_number_i + a_account_code_c Performance Asc/Asc inx_a_ep_account_fk3_key2
a_ledger_number_i + a_motivation_group_code_c + a_motivation_detail_code_c Performance Asc/Asc/Asc inx_a_ep_account_fk4_key3
s_created_by_c Performance Asc inx_a_ep_account_fkcr_key4
s_modified_by_c Performance Asc inx_a_ep_account_fkmd_key5
a_banking_details_key_i Must be unique Asc inx_a_ep_account_pk0

Close relationships  within of separation: