List of unused columns/tables in the database structure

This is a list of columns or even tables in petra.xml, that should be removed, because they are not used.

Please always add a comment, whether or where it has been used in the old Progress code.

• a_accounting_period.a_effective_date_d: Only used in the setup screen for the accounting periods, progress\petra\finance\glsetup\gs1014p.p
• a_ledger.a_current_accounting_period_i: deprecated; not used at the moment; please use a_current_period_i
• a_ledger.a_periods_per_financial_year_i: deprecated; not used at the moment; please use a_number_of_accounting_periods_i

List of names which shall be changed something

• a_transaction.a_debit_credit_indicator_l: The name is mistakable. The name a_transaction.a_is_debit_indicator_l may be something more clear.
• a_recurring_gift_detail.a_gift_amount_n should be renamed to a_gift_transaction_amount_n, to reflect that this amount is in the transaction currency. In analogy to a_gift_detail, a_gift_amount_n is the amount in base currency