Country
C_Country
Country
Overview
| Table Name | C_Country |
|---|---|
| Access Level | System + Client |
| Entity Type | D |
| Is Document | No |
| Is View | No |
| Has UUID | Yes |
| Parent Table | C_Currency |
| Wiki | View on iDempiere Wiki |
Columns (45)
| Column | Type | Required | Default | Description |
|---|---|---|---|---|
AD_Language |
Table(6) | No | - | Language for this entity |
AllowCitiesOutOfList |
Yes-No(1) | No | Y | A flag to allow cities, currently not in the list, to be entered |
CaptureSequence |
String(60) | No | - | - |
C_Currency_ID |
Table Direct(22) | No | - | The Currency for this record |
CountryCodeAlpha3 |
String(3) | No | - | Upper-case tree-letter alphanumeric ISO Country code according to ISO 3166-1 - http://www.chemie.fu-berlin.de/diverse/doc/ISO_3166.html |
CountryCodeNumeric |
String(3) | No | - | Numeric ISO Country code according to ISO 3166-1 - http://www.chemie.fu-berlin.de/diverse/doc/ISO_3166.html |
DisplaySequenceLocal |
String(20) | No | - | Format for printing this Address locally |
ExpressionBankAccountNo |
String(20) | No | - | Format of the Bank Account |
ExpressionBankRoutingNo |
String(20) | No | - | Format of the Bank Routing Number |
IsAddressLinesLocalReverse |
Yes-No(1) | Yes | - | Print Local Address in reverse Order |
IsAddressLinesReverse |
Yes-No(1) | Yes | - | Print Address in reverse Order |
MediaSize |
String(40) | No | - | Java Media Size |
PlaceholderAddress1 |
String(255) | No | - | - |
PlaceholderAddress2 |
String(255) | No | - | - |
PlaceholderAddress3 |
String(255) | No | - | - |
PlaceholderAddress4 |
String(255) | No | - | - |
PlaceholderAddress5 |
String(255) | No | - | - |
PlaceholderCity |
String(255) | No | - | - |
PlaceholderComments |
String(255) | No | - | - |
PlaceholderPostal |
String(255) | No | - | - |
PlaceholderPostal_Add |
String(255) | No | - | - |
Name |
String(60) | Yes | - | Alphanumeric identifier of the entity |
AD_Client_ID |
Table Direct(22) | Yes | @#AD_Client_ID@ | Tenant for this installation. |
AD_Org_ID |
Table Direct(22) | Yes | @#AD_Org_ID@ | Organizational entity within tenant |
C_Country_ID |
Table Direct(22) | Yes | - | Country |
C_Country_UU |
String(36) | No | - | - |
CountryCode |
String(2) | Yes | - | Upper-case two-letter alphanumeric ISO Country code according to ISO 3166-1 - http://www.chemie.fu-berlin.de/diverse/doc/ISO_3166.html |
Created |
Date+Time(7) | Yes | SYSDATE | Date this record was created |
CreatedBy |
Search(22) | Yes | - | User who created this records |
Description |
String(255) | No | - | Optional short description of the record |
DisplaySequence |
String(20) | Yes | @C@, @R@ @P@ | Format for printing this Address |
ExpressionPhone |
String(20) | No | - | Format of the phone; Can contain fixed format elements, Variables: "_lLoOaAcCa09" |
ExpressionPostal |
String(20) | No | - | Format of the postal code; Can contain fixed format elements, Variables: "_lLoOaAcCa09" |
ExpressionPostal_Add |
String(20) | No | - | Format of the value; Can contain fixed format elements, Variables: "_lLoOaAcCa09" |
HasPostal_Add |
Yes-No(1) | Yes | - | Has Additional Postal Code |
HasRegion |
Yes-No(1) | Yes | - | Country contains Regions |
IsActive |
Yes-No(1) | Yes | Y | The record is active in the system |
IsPostcodeLookup |
Yes-No(1) | No | N | Does this country have a post code web service |
LookupClassName |
String(255) | No | - | The class name of the postcode lookup plugin |
LookupClientID |
String(50) | No | - | The Client ID or Login submitted to the Lookup URL |
LookupPassword |
String(50) | No | - | The password submitted to the Lookup URL |
LookupUrl |
String(100) | No | - | The URL of the web service that the plugin connects to in order to retrieve postcode data |
RegionName |
String(60) | No | State | Name of the Region |
Updated |
Date+Time(7) | Yes | SYSDATE | Date this record was updated |
UpdatedBy |
Search(22) | Yes | - | User who updated this records |
Foreign Keys
| Column | References | Description |
|---|---|---|
C_Currency_ID |
C_Currency.C_Currency_ID | The Currency for this record |
AD_Client_ID |
AD_Client.AD_Client_ID | Tenant for this installation. |
AD_Org_ID |
AD_Org.AD_Org_ID | Organizational entity within tenant |
Generated on 2026-05-03T18:00:24.598398896Z