Table p_partner_reminder
Description:
A reminder that can be linked to a Partner or Partner contact
PRIMARY 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 NOT NULL
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
Date of event that reminder is about (if the reminder relates to a specific event like a birthday).
p_first_reminder_date_d
date NOT NULL
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
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