Table a_motivation_detail
Description:
Used as a subdvision of motivation group. Details of the reason money has been received, where it is going (cost centre and account), and fees to be charged on it.
PRIMARY KEY
a_ledger_number_i
integer default: 0 NOT NULL
This is used as a key field in most of the accounting system files a_motivation_group, a_account, a_cost_centre, a_account
a_motivation_group_code_c
varchar (16) NOT NULL
This defines a motivation group. a_motivation_group
a_motivation_detail_code_c
varchar (16) NOT NULL
This defines the motivation detail within a motivation group.

a_motivation_detail_audience_c
varchar (160)
This is a long description and is 80 characters long.
a_motivation_detail_desc_c
varchar (160) NOT NULL
This is a long description and is 80 characters long.
a_account_code_c
varchar (16) NOT NULL
This identifies the account the financial transaction must be stored against a_account
a_cost_centre_code_c
varchar (24) NOT NULL
This identifies which cost centre an account is applied to a_cost_centre
a_motivation_status_l
boolean default: '1' NOT NULL
Defines whether the motivation code is still in use
a_mailing_cost_n
numeric (24, 10) default: 0
This is a number of currency units
a_bulk_rate_flag_l
boolean default: '0' NOT NULL
Used to get a yes no response from the user
a_next_response_status_c
varchar (24)
This defines what should happen next
a_activate_partner_flag_l
boolean default: '0' NOT NULL
Used to get a yes no response from the user
a_number_sent_i
integer default: 0
The number of items sent out in a mailing
a_number_of_responses_i
integer default: 0
The number of items returned from a mailing
a_target_number_of_responses_i
integer default: 0
The target number of items returned from a mailing
a_target_amount_n
numeric (24, 10) default: 0
This is a number of currency units
a_amount_received_n
numeric (24, 10) default: 0
This is a number of currency units
p_recipient_key_n
bigint default: 0 NOT NULL
This is the partner key assigned to each partner. It consists of the ledger id followed by a computer generated six digit number. p_partner
a_autopopdesc_l
boolean default: '0'
A flag to automatically populate the description in the gift comment
a_receipt_l
boolean default: '1'
Whether receipts should be printed
a_dont_report_l
boolean default: '0'
Don't include these gifts in reporting
a_tax_deductible_l
boolean default: '1'
Whether this gift is tax deductible
a_motivation_detail_desc_local_c
varchar (160)
This is a long description and is 80 characters long in the local language.
a_short_code_c
varchar (8)
A short code for the motivation which can then be used on receipts
a_restricted_l
boolean default: '0'
Indicates whether or not the motivation has restricted access. If it does then the access will be controlled by s_group_motivation
a_export_to_intranet_l
boolean default: '1'
Whether or not gifts with this motivation should be exported to the worldwide Intranet (to help distinguish non-gifts like sales)
a_report_column_c
varchar (40)
Which column should these gifts be reported in?
a_tax_deductible_account_code_c
varchar (16)
Account Code to be used for the Tax deductible portion of this Gift a_account
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
This identifies the current version of the record.


FOREIGN KEY
a_motivation_detail_fk1: a_ledger_number_i;a_motivation_group_code_c => a_motivation_group
a_motivation_detail_fk2: a_ledger_number_i;a_account_code_c => a_account
a_motivation_detail_fk3: a_ledger_number_i;a_cost_centre_code_c => a_cost_centre
a_motivation_detail_fk4: p_recipient_key_n => p_partner
a_motivation_detail_fk5: a_ledger_number_i;a_tax_deductible_account_code_c => a_account
a_motivation_detail_fkcr: s_created_by_c => s_user
a_motivation_detail_fkmd: s_modified_by_c => s_user


REFERENCED BY
a_ep_account, a_ep_match, a_motivation_detail_fee,
a_recurring_gift_detail, a_gift_detail, s_group_motivation,
p_foundation_proposal_detail