Table p_contact_log

Description:
Details of contacts with partners

PRIMARY KEY
p_contact_log_id_i bigint default: 0 NOT NULL	identifying key for p_contact_log

s_contact_date_d date NOT NULL	Date of contact
s_contact_time_i integer default: 0	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 text	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 default: CURRENT_TIMESTAMP	This identifies the current version of the record.
FOREIGN KEY p_contact_log_fk1: p_mailing_code_c => p_mailing p_contact_log_fk2: p_contact_code_c => p_method_of_contact p_contact_log_fk3: s_module_id_c => s_module p_contact_log_fk4: s_user_id_c => s_user p_contact_log_fkcr: s_created_by_c => s_user p_contact_log_fkmd: s_modified_by_c => s_user
REFERENCED BY p_partner_contact_attribute, p_partner_contact, p_partner_reminder, s_group_partner_contact, p_partner_contact_file