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
a_sponsorship_l boolean default: '0' NOT NULL	Indicates whether or not the motivation is for a paying a sponsorship. The recipient key might be used.
a_membership_l boolean default: '0' NOT NULL	Indicates whether or not the motivation is for paying a membership. The recipient key should be used.
a_worker_support_l boolean default: '0' NOT NULL	Indicates whether or not the motivation is for supporting a worker. The recipient key must be used.
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_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