Table a_accounting_system_parameter

Description:
One record describing the limitations imposed on the accounting system.

PRIMARY KEY
a_ledger_number_i integer default: 0 NOT NULL		a_ledger

a_number_of_accounting_periods_i integer default: 0
a_actuals_data_retention_i integer default: 0
a_budget_data_retention_i integer default: 0
a_number_fwd_posting_periods_i integer default: 0
a_recipient_gift_statement_txt_c varchar (264)	Recipient gift statement text
a_recipient_gift_statement_tx2_c varchar (264)	Recipient gift statement text 2
a_donor_gift_statement_txt_c varchar (264)	Donor gift statement text
a_donor_gift_statement_tx2_c varchar (264)	Donor gift statement text 2
a_hosa_statement_txt_c varchar (264)	Hosa statement text
a_hosa_statement_tx2_c varchar (264)	Hosa (Home Office Statement of Accounts) statement text 2
a_hosa_statement_tx3_c varchar (264)	Hosa statement text 3
a_hosa_statement_tx4_c varchar (264)	Hosa statement text 4
a_donor_receipt_txt_c varchar (64)	Text for the donor receipt heading.
a_stewardship_report_txt_c varchar (264)	Stewardship Report text
a_stewardship_report_tx2_c varchar (264)	Stewardship Report text
a_donor_yearly_receipt_txt_c varchar (64)	Text for the yearly donor receipt heading.
a_gift_data_retention_i integer default: 2	How many years to retain gift data.
a_deceased_address_text_c varchar (400)	Text to put on receipt when addressing a deceased donor
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_accounting_system_param_fk1: a_ledger_number_i => a_ledger a_accounting_system_parameter_fkcr: s_created_by_c => s_user a_accounting_system_parameter_fkmd: s_modified_by_c => s_user