Adempiere3.4.0/es/ManPageW CountryRegionandCity olh es
Contents
Window: Country Region and City
Description : Maintain Countries Regions and Cities
Help : The Countries, Regions and Cities Window defines the different entities that can be used in any address field. It defines the format of the address as well as associating Regions with Countries and Cities with Regions or Countries.
You would define Countries usually only on System level.
Tab: Country
Description : Define Country
Help : The Country Tab defines any country in which you do business. Values entered here are referenced in location records for Business Partners.
Table Name : C_Country
Fields
Name | Description | Help | Technical Data |
---|---|---|---|
Client | Client/Tenant for this installation. | A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. | AD_Client_ID
NUMBER(10) TableDir |
Organization | Organizational entity within client | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. | AD_Org_ID
NUMBER(10) TableDir |
ISO Country Code | Upper-case two-letter alphanumeric ISO Country code according to ISO 3166-1 - http://www.chemie.fu-berlin.de/diverse/doc/ISO_3166.html | For details - http://www.din.de/gremien/nas/nabd/iso3166ma/codlstp1.html or - http://www.unece.org/trade/rec/rec03en.htm | CountryCode
CHAR(2) String |
Name | Alphanumeric identifier of the entity | The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. | Name
NVARCHAR2(60) String |
Description | Optional short description of the record | A description is limited to 255 characters. | Description
NVARCHAR2(255) String |
Active | The record is active in the system | There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.
There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries. |
IsActive
CHAR(1) YesNo |
Country has Region | Country contains Regions | The Country has Region checkbox is selected if the Country being defined is divided into regions. If this checkbox is selected, the Region Tab is accessible. | HasRegion
CHAR(1) YesNo |
Region | Name of the Region | The Region Name defines the name that will print when this region is used in a document. | RegionName
NVARCHAR2(60) String |
Address Print Format | Format for printing this Address | The Address Print format defines the format to be used when this address prints. The following notations are used: @C@=City @P@=Postal @A@=PostalAdd @R@=Region | DisplaySequence
NVARCHAR2(20) String |
Reverse Address Lines | Print Address in reverse Order | If NOT selected the sequence is Address 1, Address 2, Address 3, Address 4, City/Region/Postal, Country.
If selected the sequence is Country, City/Region/Postal, Address 4, Address 3, Address 2, Address 1. The sequence of City/Region/Postal is determined by the address format. |
IsAddressLinesReverse
CHAR(1) YesNo |
Local Address Format | Format for printing this Address locally | The optional Local Address Print format defines the format to be used when this address prints for the Country. If defined, this format is used for printing the address for the country rather then the standard address format.
The following notations are used: @C@=City @P@=Postal @A@=PostalAdd @R@=Region |
DisplaySequenceLocal
NVARCHAR2(20) String |
Reverse Local Address Lines | Print Local Address in reverse Order | If NOT selected the local sequence is Address 1, Address 2, Address 3, Address 4, City/Region/Postal, Country.
If selected the local sequence is Country, City/Region/Postal, Address 4, Address 3, Address 2, Address 1. The sequence of City/Region/Postal is determined by the local address format. |
IsAddressLinesLocalReverse
CHAR(1) YesNo |
Postal Code Format | Format of the postal code; Can contain fixed format elements, Variables: "_lLoOaAcCa09" | Validation elements:
(Space) any character _ Space (fixed character) l any Letter a..Z NO space L any Letter a..Z NO space converted to upper case o any Letter a..Z or space O any Letter a..Z or space converted to upper case a any Letters & Digits NO space A any Letters & Digits NO space converted to upper case c any Letters & Digits or space C any Letters & Digits or space converted to upper case 0 Digits 0..9 NO space 9 Digits 0..9 or space Example of format "(000)_000-0000" |
ExpressionPostal
NVARCHAR2(20) String |
Additional Postal code | Has Additional Postal Code | The Additional Postal Code checkbox indicates if this address uses an additional Postal Code. If it is selected an additional field displays for entry of the additional Postal Code. | HasPostal_Add
CHAR(1) YesNo |
Additional Postal Format | Format of the value; Can contain fixed format elements, Variables: "_lLoOaAcCa09" | Validation elements:
(Space) any character _ Space (fixed character) l any Letter a..Z NO space L any Letter a..Z NO space converted to upper case o any Letter a..Z or space O any Letter a..Z or space converted to upper case a any Letters & Digits NO space A any Letters & Digits NO space converted to upper case c any Letters & Digits or space C any Letters & Digits or space converted to upper case 0 Digits 0..9 NO space 9 Digits 0..9 or space Example of format "(000)_000-0000" |
ExpressionPostal_Add
NVARCHAR2(20) String |
Phone Format | Format of the phone; Can contain fixed format elements, Variables: "_lLoOaAcCa09" | Validation elements:
(Space) any character _ Space (fixed character) l any Letter a..Z NO space L any Letter a..Z NO space converted to upper case o any Letter a..Z or space O any Letter a..Z or space converted to upper case a any Letters & Digits NO space A any Letters & Digits NO space converted to upper case c any Letters & Digits or space C any Letters & Digits or space converted to upper case 0 Digits 0..9 NO space 9 Digits 0..9 or space Example of format "(000)_000-0000" |
ExpressionPhone
NVARCHAR2(20) String |
Media Size | Java Media Size | The Java Media Size. Example: "MediaSize.ISO.A4" (the package javax.print.attribute.standard is assumed). If you define your own media size, use the fully qualified name.
If the pattern for your language is not correct, please create a Adempiere support request with the correct information |
MediaSize
NVARCHAR2(40) String |
Bank Routing No Format | Format of the Bank Routing Number | ExpressionBankRoutingNo
NVARCHAR2(20) String | |
Bank Account No Format | Format of the Bank Account | ExpressionBankAccountNo
NVARCHAR2(20) String | |
Language | Language for this entity | The Language identifies the language to use for display and formatting | AD_Language
VARCHAR2 Table |
Currency | The Currency for this record | Indicates the Currency to be used when processing or reporting on this record | C_Currency_ID
NUMBER(10) TableDir |
IsPostcodeLookup | Does this country have a post code web service | Enable the IsPostcodeLookup if you wish to configure a post code lookup web service | IsPostcodeLookup
CHAR(1) YesNo |
LookupUrl | The URL of the web service that the plugin connects to in order to retrieve postcode data | Enter the URL of the web service that the plugin connects to in order to retrieve postcode data | LookupUrl
VARCHAR2 String |
LookupClientID | The ClientID or Login submitted to the Lookup URL | Enter the ClientID or Login for your account provided by the post code web service provider | LookupClientID
VARCHAR2 String |
LookupPassword | The password submitted to the Lookup URL | Enter the password for your account provided by the post code web service provider | LookupPassword
VARCHAR2 String |
LookupClassName | The class name of the postcode lookup plugin | Enter the class name of the post code lookup plugin for your postcode web service provider | LookupClassName
VARCHAR2 String |
Tab: Translation
Description :
Help :
Table Name : C_Country_Trl
Fields
Name | Description | Help | Technical Data |
---|---|---|---|
Client | Client/Tenant for this installation. | A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. | AD_Client_ID
NUMBER(10) TableDir |
Organization | Organizational entity within client | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. | AD_Org_ID
NUMBER(10) TableDir |
Country | Country | The Country defines a Country. Each Country must be defined before it can be used in any document. | C_Country_ID
NUMBER(10) TableDir |
Language | Language for this entity | The Language identifies the language to use for display and formatting | AD_Language
VARCHAR2 Table |
Active | The record is active in the system | There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.
There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries. |
IsActive
CHAR(1) YesNo |
Translated | This column is translated | The Translated checkbox indicates if this column is translated. | IsTranslated
CHAR(1) YesNo |
Name | Alphanumeric identifier of the entity | The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. | Name
NVARCHAR2(60) String |
Description | Optional short description of the record | A description is limited to 255 characters. | Description
NVARCHAR2(255) String |
Region | Name of the Region | The Region Name defines the name that will print when this region is used in a document. | RegionName
NVARCHAR2(60) String |
Tab: Region
Description : Define Regions
Help : The Region Tab defines a Region within a Country. This tab is enabled only if the Has Region checkbox is selected for the Country.
Table Name : C_Region
Fields
Name | Description | Help | Technical Data |
---|---|---|---|
Client | Client/Tenant for this installation. | A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. | AD_Client_ID
NUMBER(10) TableDir |
Organization | Organizational entity within client | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. | AD_Org_ID
NUMBER(10) TableDir |
Country | Country | The Country defines a Country. Each Country must be defined before it can be used in any document. | C_Country_ID
NUMBER(10) TableDir |
Name | Alphanumeric identifier of the entity | The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. | Name
NVARCHAR2(60) String |
Description | Optional short description of the record | A description is limited to 255 characters. | Description
NVARCHAR2(255) String |
Active | The record is active in the system | There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.
There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries. |
IsActive
CHAR(1) YesNo |
Default | Default value | The Default Checkbox indicates if this record will be used as a default value. | IsDefault
CHAR(1) YesNo |
Tab: City
Description : Define Cities
Help : The Cities Tab defines Cities within a Country or Region. Cities entered here are not referenced when entering the address.
Table Name : C_City
Fields
Name | Description | Help | Technical Data |
---|---|---|---|
Client | Client/Tenant for this installation. | A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. | AD_Client_ID
NUMBER(10) TableDir |
Organization | Organizational entity within client | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. | AD_Org_ID
NUMBER(10) TableDir |
Country | Country | The Country defines a Country. Each Country must be defined before it can be used in any document. | C_Country_ID
NUMBER(10) TableDir |
Region | Identifies a geographical Region | The Region identifies a unique Region for this Country. | C_Region_ID
NUMBER(10) Table |
Name | Alphanumeric identifier of the entity | The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. | Name
NVARCHAR2(60) String |
Active | The record is active in the system | There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.
There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries. |
IsActive
CHAR(1) YesNo |
ZIP | Postal code | The Postal Code or ZIP identifies the postal code for this entity's address. | Postal
VARCHAR2 String |
Area Code | Phone Area Code | Phone Area Code | AreaCode
VARCHAR2 String |
Locode | Location code - UN/LOCODE | UN/Locode is a combination of a 2-character country code and a 3-character location code, e.g. BEANR is known as the city of Antwerp (ANR) which is located in Belgium (BE). | Locode
VARCHAR2 String |
Coordinates | Location coordinate | This column contains the geographical coordinates (latitude/longitude) of the location.<p>
In order to avoid unnecessary use of non-standard characters and space, the following standard presentation is used: |
Coordinates
VARCHAR2 String |