国家、省、市 (窗口 ID-122)
窗口: 国家、省、市
描述: 维护国家、省、市
幫助: 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: 国家
描述: 定义国家
幫助 The Country Tab defines any country in which you do business. Values entered here are referenced in location records for Business Partners.
File:国家、省、市 - 国家 - 窗口 (iDempiere 1.0.0).png
| 名稱 | 名稱 | 描述 | 幫助 | 產品規格 |
|---|---|---|---|---|
| Client | 客户 | 安装此软件的客户 | 客户是一个公司或者合法的实体。你不能在客户之间共享数据。 | AD_Client_ID numeric(10) NOT NULL Table Direct |
| Organization | 机构 | 客户内的机构实体。 | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. | AD_Org_ID numeric(10) NOT NULL Table Direct |
| ISO Country Code | ISO国家代码 | 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 character(2) NOT NULL 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 character varying(60) NOT NULL String |
| Description | 描述 | 该记录的可选描述 | 描述最多为 255 个字符。 | Description character varying(255) String |
| Active | 有效 | 本记录有效 | 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 character(1) NOT NULL Yes-No |
| Country has Region | 该国有(省级)区划 | 该国有(省级)区划 | 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 character(1) NOT NULL Yes-No |
| Region | 区域名字 | 该区域的名字 | The Region Name defines the name that will print when this region is used in a document. | RegionName character varying(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 character varying(20) NOT NULL 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 character(1) NOT NULL Yes-No |
| Capture Sequence | Capture Sequence | null | The Capture Sequence defines the fields to be used when capturing an address on this country. The following notations are used: @CO@=Country, @C@=City, @P@=Postal, @A@=PostalAdd, @R@=Region, @A1@=Address 1 to @A4@=Address 4. Country is always mandatory, add a bang ! to make another field mandatory, for example @C!@ makes city mandatory, @A1!@ makes Address 1 mandatory. | CaptureSequence character varying(60) String |
| 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 character varying(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 character(1) NOT NULL Yes-No |
| Postal Code Format | 邮编格式 | Format of the postal code; Can contain fixed format elements, Variables: "_lLoOaAcCa09" | 验证元素:(空格)任何的个性
_ 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 &数字无空格 A any Letters & Digits NO space converted to upper case c any Letters &数字或空间 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 character varying(20) String |
| 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 character(1) NOT NULL Yes-No |
| Additional Postal Format | 附加邮编格式 | Format of the value; Can contain fixed format elements, Variables: "_lLoOaAcCa09" | 验证元素:(空格)任何的个性
_ 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 &数字无空格 A any Letters & Digits NO space converted to upper case c any Letters &数字或空间 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 character varying(20) String |
| Phone Format | 电话号码格式 | Format of the phone; Can contain fixed format elements, Variables: "_lLoOaAcCa09" | 验证元素:(空格)任意字符
_ 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 &数字无空格 A any Letters & Digits NO space converted to upper case c any Letters &数字或空间 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 character varying(20) String |
| Media Size | 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 character varying(40) String |
| Bank Routing No Format | 银行Routing码格式 | Format of the Bank Routing Number | null | ExpressionBankRoutingNo character varying(20) String |
| Bank Account No Format | 银行账号格式 | 银行账号的格式 | null | ExpressionBankAccountNo character varying(20) String |
| Language | 语言 | 本客户使用的语言 | The Language identifies the language to use for display | AD_Language character varying(6) Table |
| Currency | 货币 | 币种为该笔记录 | Indicates the Currency to be used when processing or reporting on this record | C_Currency_ID numeric(10) Table Direct |
| Use Postcode Lookup | Use Postcode Lookup | Does this country have a post code web service | Enable the IsPostcodeLookup if you wish to configure a post code lookup web service | IsPostcodeLookup character(1) NOT NULL Yes-No |
| Allow Cities out of List | Allow Cities out of List | A flag to allow cities, currently not in the list, to be entered | null | AllowCitiesOutOfList character(1) Yes-No |
| Lookup URL | Lookup URL | 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 character varying(100) String |
| Lookup Client ID | Lookup Client ID | 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 character varying(50) String |
| Lookup Password | Lookup Password | The password submitted to the Lookup URL | Enter the password for your account provided by the post code web service provider | LookupPassword character varying(50) String |
| Lookup ClassName | Lookup ClassName | 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 character varying(255) String |
TAB: 翻译
描述: null
幫助 null
File:国家、省、市 - 翻译 - 窗口 (iDempiere 1.0.0).png
| 名稱 | 名稱 | 描述 | 幫助 | 產品規格 |
|---|---|---|---|---|
| Client | 客户 | 安装此软件的客户 | 客户是一个公司或者合法的实体。你不能在客户之间共享数据。 | AD_Client_ID numeric(10) NOT NULL Table Direct |
| Organization | 机构 | 客户内的机构实体。 | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. | AD_Org_ID numeric(10) NOT NULL Table Direct |
| Country | 国家 | 国家 | The Country defines a Country. Each Country must be defined before it can be used in any document. | C_Country_ID numeric(10) NOT NULL Table Direct |
| Language | 语言 | 本客户使用的语言 | The Language identifies the language to use for display | AD_Language character varying(6) NOT NULL Table |
| Active | 有效 | 本记录有效 | 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 character(1) NOT NULL Yes-No |
| Translated | 已翻译 | 列被翻译 | The Translated checkbox indicates if this column is translated. | IsTranslated character(1) NOT NULL Yes-No |
| 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 character varying(60) NOT NULL String |
| Description | 描述 | 该记录的可选描述 | 描述最多为 255 个字符。 | Description character varying(255) String |
| Region | 区域名字 | 该区域的名字 | The Region Name defines the name that will print when this region is used in a document. | RegionName character varying(60) String |
TAB: 区域
描述: 定义区域
幫助 The Region Tab defines a Region within a Country. This tab is enabled only if the Has Region checkbox is selected for the Country.
File:国家、省、市 - 区域 - 窗口 (iDempiere 1.0.0).png
| 名稱 | 名稱 | 描述 | 幫助 | 產品規格 |
|---|---|---|---|---|
| Region | 区域 | Identifies a geographical Region | The Region identifies a unique Region for this Country. | C_Region_ID numeric(10) NOT NULL ID |
| Client | 客户 | 安装此软件的客户 | 客户是一个公司或者合法的实体。你不能在客户之间共享数据。 | AD_Client_ID numeric(10) NOT NULL Table Direct |
| Organization | 机构 | 客户内的机构实体。 | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. | AD_Org_ID numeric(10) NOT NULL Table Direct |
| Country | 国家 | 国家 | The Country defines a Country. Each Country must be defined before it can be used in any document. | C_Country_ID numeric(10) NOT NULL Table Direct |
| 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 character varying(60) NOT NULL String |
| Description | 描述 | 该记录的可选描述 | 描述最多为 255 个字符。 | Description character varying(255) String |
| Active | 有效 | 本记录有效 | 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 character(1) NOT NULL Yes-No |
| Default | 缺省值 | 缺省值 | The Default Checkbox indicates if this record will be used as a default value. | IsDefault character(1) Yes-No |
TAB: 城市
描述: 定义城市
幫助 The Cities Tab defines Cities within a Country or Region. Cities entered here are not referenced when entering the address.
File:国家、省、市 - 城市 - 窗口 (iDempiere 1.0.0).png
| 名稱 | 名稱 | 描述 | 幫助 | 產品規格 |
|---|---|---|---|---|
| City | 城市 | 城市 | 在一个国家中的城市 | C_City_ID numeric(10) NOT NULL ID |
| Client | 客户 | 安装此软件的客户 | 客户是一个公司或者合法的实体。你不能在客户之间共享数据。 | AD_Client_ID numeric(10) NOT NULL Table Direct |
| Organization | 机构 | 客户内的机构实体。 | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. | AD_Org_ID numeric(10) NOT NULL Table Direct |
| Country | 国家 | 国家 | The Country defines a Country. Each Country must be defined before it can be used in any document. | C_Country_ID numeric(10) Table Direct |
| Region | 区域 | Identifies a geographical Region | The Region identifies a unique Region for this Country. | C_Region_ID numeric(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 character varying(60) NOT NULL String |
| Active | 有效 | 本记录有效 | 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 character(1) NOT NULL Yes-No |
| ZIP | 邮编 | 邮政编码 | The Postal Code field identifies the postal code for this entity's address. | Postal character varying(10) String |
| Area Code | 区号 | 长途区号 | 长途区号 | AreaCode character varying(10) 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).
See: http: www.unece.org cefact locode service main.htm |
Locode character varying(10) String |
| Coordinates | 坐标 | 位置坐标 | This column contains the geographical coordinates (latitude longitude) of the location.
In order to avoid unnecessary use of non-standard characters and space, the following standard presentation is used: |
Coordinates character varying(15) String |
.png){kind=link}
.png){kind=link}
.png){kind=link}
.png){kind=link}