| 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 default: CURRENT_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 | ||