Table openpetra_trunk.public.a_accounting_system_parameter
One record describing the limitations imposed on the accounting system.

 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_number_of_accounting_periods_i int4 10  √  0
a_actuals_data_retention_i int4 10  √  0
a_budget_data_retention_i int4 10  √  0
a_number_fwd_posting_periods_i int4 10  √  0
a_ledger_number_i int4 10 0
a_ledger.a_ledger_number_i a_accounting_system_param_fk1 R
a_recipient_gift_statement_txt_c varchar 264  √  null Recipient gift statement text
a_recipient_gift_statement_tx2_c varchar 264  √  null Recipient gift statement text 2
a_donor_gift_statement_txt_c varchar 264  √  null Donor gift statement text
a_donor_gift_statement_tx2_c varchar 264  √  null Donor gift statement text 2
a_hosa_statement_txt_c varchar 264  √  null Hosa statement text
a_hosa_statement_tx2_c varchar 264  √  null Hosa (Home Office Statement of Accounts) statement text 2
a_hosa_statement_tx3_c varchar 264  √  null Hosa statement text 3
a_hosa_statement_tx4_c varchar 264  √  null Hosa statement text 4
a_donor_receipt_txt_c varchar 64  √  null Text for the donor receipt heading.
a_stewardship_report_txt_c varchar 264  √  null Stewardship Report text
a_stewardship_report_tx2_c varchar 264  √  null Stewardship Report text
a_donor_yearly_receipt_txt_c varchar 64  √  null Text for the yearly donor receipt heading.
a_gift_data_retention_i int4 10  √  2 How many years to retain gift data.
a_deceased_address_text_c varchar 400  √  null Text to put on receipt when addressing a deceased donor
s_date_created_d date 13  √  ('now'::text)::date
s_created_by_c varchar 20  √  null
s_user.s_user_id_c a_accounting_system_parameter_fkcr R
s_date_modified_d date 13  √  null
s_modified_by_c varchar 20  √  null
s_user.s_user_id_c a_accounting_system_parameter_fkmd R
s_modification_id_c varchar 150  √  null

Table contained 3 rows at Do Nov 10 18:00 MEZ 2011

Indexes:
Column(s) Type Sort Constraint Name
a_ledger_number_i Primary key Asc a_accounting_system_param_pk
a_ledger_number_i Must be unique Asc inx_a_accounting_system_param_pk0
s_created_by_c Performance Asc inx_ng_system_parameter_fkcr_key1
s_modified_by_c Performance Asc inx_ng_system_parameter_fkmd_key2

Close relationships  within of separation: