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 | ||