Table p_mailing
Description:
Lists mailings that are being tracked. When entering gifts, the mailing that motivated the gift can be indicated.
PRIMARY KEY
p_mailing_code_c
varchar (50) NOT NULL
Mailing Code

p_mailing_description_c
varchar (160)
Mailing Description
p_mailing_date_d
date
Date Of Mailing
a_motivation_group_code_c
varchar (16)
This defines a motivation group.
a_motivation_detail_code_c
varchar (16)
This defines the motivation detail within a motivation group.
p_mailing_cost_n
numeric (19, 2) default: 0
Cost of Mailing
p_mailing_attributed_amount_n
numeric (19, 2) default: 0
Gift amount attributed to this mailing
p_viewable_l
boolean default: '1'
Indicates if the mailing is viewable in comboboxes where the user can select it
p_viewable_until_d
date
Date until this mailing is viewable for users (if p_viewable_l is set)
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
p_mailing_fkcr: s_created_by_c => s_user
p_mailing_fkmd: s_modified_by_c => s_user


REFERENCED BY
p_contact_log, a_ep_match, a_recurring_gift_detail,
a_gift_detail