Table openpetra_trunk.public.a_processed_fee
Stores administrative fees and grants which have been calculated on gifts.

 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_ledger_number_i int4 10 0
a_cost_centre.a_ledger_number_i a_processed_fee_fk1 R
a_gift_batch.a_ledger_number_i a_processed_fee_fk4 R
a_gift_detail.a_ledger_number_i a_processed_fee_fk3 R
a_accounting_period.a_ledger_number_i a_processed_fee_fk2 R
This is used as a key field in most of the accounting system files
a_fee_code_c varchar 16 the fee which the calculated amounts are stored against.
a_cost_centre_code_c varchar 24
a_cost_centre.a_cost_centre_code_c a_processed_fee_fk1 R
Cost centre code which the fee will be charged against.
a_period_number_i int4 10 0
a_accounting_period.a_accounting_period_number_i a_processed_fee_fk2 R
Period number
a_periodic_amount_n numeric 24,10 0 Total Amount of the fee for the given period.
a_batch_number_i int4 10
a_gift_batch.a_batch_number_i a_processed_fee_fk4 R
a_gift_detail.a_batch_number_i a_processed_fee_fk3 R
Number of the gift batch containing this detail.
a_gift_transaction_number_i int4 10
a_gift_detail.a_gift_transaction_number_i a_processed_fee_fk3 R
Identifies a gift transaction within a gift batch.
a_detail_number_i int4 10
a_gift_detail.a_detail_number_i a_processed_fee_fk3 R
Identifies a gift detail within a gift transaction. When a donor gives a donation to multiple recipients (a split gift), a gift detail record is created for each recipient.
a_processed_date_d date 13  √  null Date admin fee calculations have been run to fee total has been created as a transaction in the general ledger.
s_timestamp_i int4 10  √  null System generated time stamp.
s_date_created_d date 13  √  ('now'::text)::date
s_created_by_c varchar 20  √  null
s_user.s_user_id_c a_processed_fee_fkcr R
s_date_modified_d date 13  √  null
s_modified_by_c varchar 20  √  null
s_user.s_user_id_c a_processed_fee_fkmd R
s_modification_id_c varchar 150  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
a_ledger_number_i + a_batch_number_i + a_gift_transaction_number_i + a_detail_number_i + a_fee_code_c Primary key Asc/Asc/Asc/Asc/Asc a_processed_fee_pk
a_ledger_number_i + a_period_number_i + a_fee_code_c + a_cost_centre_code_c + a_processed_date_d + s_timestamp_i Performance Asc/Asc/Asc/Asc/Asc/Asc a_processed_fee_k0
a_ledger_number_i + a_fee_code_c + a_batch_number_i + a_gift_transaction_number_i + a_detail_number_i Performance Asc/Asc/Asc/Asc/Asc a_processed_fee_k21
a_ledger_number_i + a_cost_centre_code_c Performance Asc/Asc inx_a_processed_fee_fk1_key1
a_ledger_number_i + a_period_number_i Performance Asc/Asc inx_a_processed_fee_fk2_key2
a_ledger_number_i + a_batch_number_i + a_gift_transaction_number_i + a_detail_number_i Performance Asc/Asc/Asc/Asc inx_a_processed_fee_fk3_key3
a_ledger_number_i + a_batch_number_i Performance Asc/Asc inx_a_processed_fee_fk4_key4
s_created_by_c Performance Asc inx_a_processed_fee_fkcr_key5
s_modified_by_c Performance Asc inx_a_processed_fee_fkmd_key6
a_ledger_number_i + a_batch_number_i + a_gift_transaction_number_i + a_detail_number_i + a_fee_code_c Must be unique Asc/Asc/Asc/Asc/Asc inx_a_processed_fee_pk0

Close relationships  within of separation: