| Table p_partner_reminder |
|
Description: A reminder that can be linked to a Partner or Partner contact |
| PRIMARY KEY | ||
|
p_partner_reminder_id_i
integer NOT NULL | Primary Key of this reminder | |
| UNIQUE KEY | ||
|
p_partner_key_n
bigint NOT NULL | Partner key of Partner to which the reminder is related | p_partner |
|
p_contact_id_i
bigint | ID of Contact to which reminder relates. Null means that reminder relates just to a Partner | p_contact_log |
|
p_reminder_id_i
integer default: 0 NOT NULL | ID of this reminder (only unique per Partner/Contact) | |
|
s_user_id_c
varchar (20) | The user that requires this reminder | s_user |
|
p_category_code_c
varchar (40) | This is a category, by which reminders can be grouped. | p_reminder_category |
|
p_action_type_c
varchar (16) | Type of action to take on getting the reminder (eg. Email etc) | |
|
p_reminder_reason_c
varchar (600) | Reason for the reminder (eg. birthday, etc.) | |
|
p_comment_c
varchar (5000) | Additional Comments | |
|
p_event_date_d
date NOT NULL | Date of event that reminder is about (if the reminder relates to a specific event like a birthday). | |
|
p_first_reminder_date_d
date | Date on which to send/display first reminder. | |
|
p_reminder_frequency_i
integer default: 0 | Frequency (in days) with which re-reminders should be sent. | |
|
p_last_reminder_sent_d
date | Date on which the last reminder was sent | |
|
p_next_reminder_date_d
date | Date on which the next reminder will be sent | |
|
p_reminder_active_l
boolean default: '1' NOT NULL | Is this reminder still active? | |
|
p_email_address_c
varchar (1000) | Email address to which reminder should be sent | |
|
p_restricted_l
boolean default: '0' | Indicates whether or not the contact has restricted access. If it does then the access will be controlled by s_group_partner_reminder | |
|
s_module_id_c
varchar (20) | Identifies a module. A module is any part of aprogram which is related to each menu entry or to the sub-system. Eg, partner administration, AP, AR etc. | s_module |
|
s_user_restriction_c
varchar (20) | If set, this contact is restricted to one user. | s_user |
|
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_partner_reminder_fk1: p_partner_key_n => p_partner p_partner_reminder_fk2: p_contact_id_i => p_contact_log p_partner_reminder_fk3: s_user_id_c => s_user p_partner_reminder_fk4: s_module_id_c => s_module p_partner_reminder_fk5: s_user_restriction_c => s_user p_partner_reminder_fk6: p_category_code_c => p_reminder_category p_partner_reminder_fkcr: s_created_by_c => s_user p_partner_reminder_fkmd: s_modified_by_c => s_user | ||
REFERENCED BY p_partner_action, s_group_partner_reminder | ||