Table p_country
Description:
List of countries with their codes
PRIMARY KEY
p_country_code_c
varchar (8) NOT NULL
This is a code which identifies a country. It is the ISO code (ISO 3166)

p_country_name_c
varchar (80) NOT NULL
The name of the country
p_undercover_l
boolean default: '0'
Describes if the country is politically sensitive.
p_internat_telephone_code_i
integer default: 0
The telephone code needed to dial into a country
p_internat_postal_type_code_c
varchar (16)
p_international_postal_type
p_internat_access_code_c
varchar (8)
The code needed to dial out of a country.
p_time_zone_minimum_n
numeric (6, 2) default: 0
Number of hours +/- GMT
p_time_zone_maximum_n
numeric (6, 2) default: 0
Number of hours +/- GMT
p_deletable_l
boolean default: '1' NOT NULL
This defines if the country code can be deleted. This can only be updated by the system manager. At the risk of serious operational integrity. Default to Yes
p_address_order_i
integer default: 0
Tab order of the city, county, and post code fields on the Partner Edit screen
p_country_name_local_c
varchar (80)
The name of the country in the Local language
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_country_fk1: p_internat_postal_type_code_c => p_international_postal_type
p_country_fkcr: s_created_by_c => s_user
p_country_fkmd: s_modified_by_c => s_user


REFERENCED BY
a_currency, p_location, p_address_layout,
p_address_block, p_formality, a_ledger,
p_partner_attribute, p_unit, pm_passport_details,
pm_passport_details, pm_formal_education, p_partner_interest