| PRIMARY 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 |
|
p_site_key_n
bigint default: 0 NOT NULL |
This is the key that tell what site created the linked location
| p_location |
|
p_location_key_i
integer default: 0 NOT NULL |
| p_location |
|
|
p_date_effective_d
date |
| |
|
p_date_good_until_d
date |
| |
|
p_location_type_c
varchar (24) |
| p_location_type |
|
p_send_mail_l
boolean default: '0' |
| |
|
p_fax_number_c
varchar (50) |
| |
|
p_telex_i
integer default: 0 |
| |
|
p_telephone_number_c
varchar (50) |
| |
|
p_extension_i
integer default: 0 |
| |
|
p_email_address_c
varchar (120) |
| |
|
p_location_detail_comment_c
varchar (512) |
| |
|
p_fax_extension_i
integer default: 0 |
| |
|
p_mobile_number_c
varchar (50) |
| |
|
p_alternate_telephone_c
varchar (50) |
| |
|
p_url_c
varchar (128) |
| |
|
p_restricted_l
boolean default: '0' |
Indicates whether or not the partner location has restricted access. If it does then the access will be controlled by s_group_partner_location.
| |
|
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_location_fk1: p_partner_key_n => p_partner
p_partner_location_fk2: p_site_key_n;p_location_key_i => p_location
p_partner_location_fk3: p_location_type_c => p_location_type
p_partner_location_fkcr: s_created_by_c => s_user
p_partner_location_fkmd: s_modified_by_c => s_user
|
REFERENCED BY
s_group_partner_location |
|