Table idempiere9.adempiere.c_country
Country

 Generated by
Quality Systems & Solutions
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
c_country_id numeric 10
c_country.c_country_id ccountry_ccountry R
c_country.c_country_id ccountry_ccountry R
Country
ad_client_id numeric 10
ad_client.ad_client_id c_countryclient R
Client/Tenant for this installation.
ad_org_id numeric 10
ad_org.ad_org_id c_countryorg R
Organizational entity within client
isactive bpchar 1 'Y'::bpchar The record is active in the system
created timestamp 29,6 now() Date this record was created
createdby numeric 10 User who created this records
updated timestamp 29,6 now() Date this record was updated
updatedby numeric 10 User who updated this records
name varchar 60 Alphanumeric identifier of the entity
description varchar 255  √  null Optional short description of the record
countrycode bpchar 2 Upper-case two-letter alphanumeric ISO Country code according to ISO 3166-1 - http://www.chemie.fu-berlin.de/diverse/doc/ISO_3166.html
hasregion bpchar 1 'N'::bpchar Country contains Regions
regionname varchar 60  √  null Name of the Region
expressionphone varchar 20  √  null Format of the phone; Can contain fixed format elements, Variables: "_lLoOaAcCa09"
displaysequence varchar 20 Format for printing this Address
expressionpostal varchar 20  √  null Format of the postal code; Can contain fixed format elements, Variables: "_lLoOaAcCa09"
haspostal_add bpchar 1 'N'::bpchar Has Additional Postal Code
expressionpostal_add varchar 20  √  null Format of the value; Can contain fixed format elements, Variables: "_lLoOaAcCa09"
ad_language varchar 6  √  null
ad_language.ad_language adlanguage_ccountry R
Language for this entity
c_currency_id numeric 10  √  null The Currency for this record
displaysequencelocal varchar 20  √  null Format for printing this Address locally
isaddresslinesreverse bpchar 1 'N'::bpchar Print Address in reverse Order
isaddresslineslocalreverse bpchar 1 'N'::bpchar Print Local Address in reverse Order
expressionbankroutingno varchar 20  √  null Format of the Bank Routing Number
expressionbankaccountno varchar 20  √  null Format of the Bank Account
mediasize varchar 40  √  null Java Media Size
ispostcodelookup bpchar 1 'N'::bpchar Does this country have a post code web service
lookupclassname varchar 255  √  null The class name of the postcode lookup plugin
lookupclientid varchar 50  √  null The ClientID or Login submitted to the Lookup URL
lookuppassword varchar 50  √  null The password submitted to the Lookup URL
lookupurl varchar 100  √  null The URL of the web service that the plugin connects to in order to retrieve postcode data
allowcitiesoutoflist bpchar 1  √  'Y'::bpchar A flag to allow cities, currently not in the list, to be entered
capturesequence varchar 60  √  null Capture Sequence
c_country_uu varchar 36  √  NULL::character varying C_Country_UU
placeholderaddress1 varchar 255  √  NULL::character varying Placeholder for Address 1
placeholderaddress2 varchar 255  √  NULL::character varying Placeholder for Address 2
placeholderaddress3 varchar 255  √  NULL::character varying Placeholder for Address 3
placeholderaddress4 varchar 255  √  NULL::character varying Placeholder for Address 4
placeholderaddress5 varchar 255  √  NULL::character varying Placeholder for Address 5
placeholdercity varchar 255  √  NULL::character varying Placeholder for city
placeholdercomments varchar 255  √  NULL::character varying Placeholder for comments
placeholderpostal varchar 255  √  NULL::character varying Placeholder for postal
placeholderpostal_add varchar 255  √  NULL::character varying Placeholder for additional zip

Table contained 251 rows at 2021-12-25 14:46 +0100

Indexes:
Column(s) Type Sort Constraint Name
c_country_id Primary key Asc c_country_pkey
c_country_uu Must be unique Asc c_country_uu_idx
countrycode Must be unique Asc c_countrycode

Close relationships  within of separation: