| Table p_partner_contact |
|
Description: Details of contacts with partners |
| PRIMARY KEY | ||
|
p_contact_id_i
integer default: 0 NOT NULL | identifying key for p_partner_contact | |
| UNIQUE KEY | ||
|
p_partner_key_n
bigint default: 0 NOT NULL | This is the partner key assigned to each partner. It consists of the fund id followed by a computer generated six digit number. | p_partner |
|
s_contact_date_d
date NOT NULL | Date of contact | |
|
s_contact_time_i
integer default: 0 NOT NULL | Time of contact | |
|
p_contact_code_c
varchar (16) NOT NULL | Contact code | p_method_of_contact |
|
p_contactor_c
varchar (20) | User who made the contact | |
|
p_contact_message_id_c
varchar (200) | The Message ID (only applies if the type of contact is an email); this helps to identify the email and to interface with the EMail application | |
|
p_contact_comment_c
varchar (30000) | Contact Comment (also used to hold contents of emails) | |
|
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_id_c
varchar (20) | If set, this contact is restricted to one user. | s_user |
|
p_mailing_code_c
varchar (50) | The mailing code associated with the contact | p_mailing |
|
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_contact | |
|
p_contact_location_c
varchar (8000) | Location of contact | |
|
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_contact_fk1: p_partner_key_n => p_partner p_partner_contact_fk2: p_mailing_code_c => p_mailing p_partner_contact_fk3: p_contact_code_c => p_method_of_contact p_partner_contact_fk4: s_module_id_c => s_module p_partner_contact_fk7: s_user_id_c => s_user p_partner_contact_fkcr: s_created_by_c => s_user p_partner_contact_fkmd: s_modified_by_c => s_user | ||
REFERENCED BY p_partner_contact_attribute, p_partner_reminder, s_group_partner_contact, p_partner_contact_file | ||