国地域(Country Region and City)|iDempiere 13 画面リファレンス
国地域(Country Region and City)
Section titled “国地域(Country Region and City)”iDempiere 13 標準ウィンドウ(AD_Window_ID: 122)
メニュー: システム管理 ▸ 全般設定 ▸ システム設定 ▸ 国地域
Maintain Countries Regions and Cities
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.
| # | タブ | テーブル | 階層 | 説明 |
|---|---|---|---|---|
| 10 | 国 | C_Country | 0 | Define Country |
| 20 | 地域 | C_Region | 1 | Define Regions |
| 30 | 市 | C_City | 2 | Define Cities |
| 33 | 翻訳 | C_Region_Trl | 2 | |
| 35 | City (Without Regions) | C_City | 1 | Cities without Region |
| 40 | 翻訳 | C_Country_Trl | 1 | |
| 50 | Country Group | C_CountryGroupCountry | 1 |
国 タブのフィールド
Section titled “国 タブのフィールド”The Country Tab defines any country in which you do business. Values entered here are referenced in location records for Business Partners.
| フィールド | カラム | 型 | 必須 | 説明 |
|---|---|---|---|---|
| クライアント | AD_Client_ID | Table Direct | ✔ | Tenant for this installation. |
| 組織 | AD_Org_ID | Table Direct | ✔ | Organizational entity within tenant |
| ISO国コード | CountryCode | String | ✔ | Upper-case two-letter alphanumeric ISO Country code according to ISO 3166-1 |
| ISO Alpha-3 Code | ISOCountryCodeAlpha3 | String | ISO Alpha-3 country code - a three-letter code that represents a country name, which is usually more closely related to the country name | |
| 名称 | Name | String | ✔ | Alphanumeric identifier of the entity |
| 説明 | Description | String | Optional short description of the record | |
| M49 Code | M49Code | String | Standard country codes for statistical use (M49) defined by the United Nations | |
| Allow Cities out of List | AllowCitiesOutOfList | Yes-No | A flag to allow cities, currently not in the list, to be entered | |
| 地域あり | HasRegion | Yes-No | ✔ | Country contains Regions |
| 地域(表示名) | RegionName | String | Name of the Region | |
| グローバルアドレス書式 | DisplaySequence | String | ✔ | Format for printing this Address |
| アドレス逆表示 | IsAddressLinesReverse | Yes-No | ✔ | Print Address in reverse Order |
| Capture Sequence | CaptureSequence | String | ||
| ローカルアドレス書式 | DisplaySequenceLocal | String | Format for printing this Address locally | |
| ローカルアドレス逆表示 | IsAddressLinesLocalReverse | Yes-No | ✔ | Print Local Address in reverse Order |
| 郵便番号書式 | ExpressionPostal | String | Format of the postal code; Can contain fixed format elements, Variables: “_lLoOaAcCa09” | |
| 付加郵便番号 | HasPostal_Add | Yes-No | ✔ | Has Additional Postal Code |
| 付加の郵便書式 | ExpressionPostal_Add | String | Format of the value; Can contain fixed format elements, Variables: “_lLoOaAcCa09” | |
| 電話番号書式 | ExpressionPhone | String | Format of the phone; Can contain fixed format elements, Variables: “_lLoOaAcCa09” | |
| メディアサイズ | MediaSize | String | Java Media Size | |
| 銀行ルーティングNo書式 | ExpressionBankRoutingNo | String | Format of the Bank Routing Number | |
| 銀行口座番号書式 | ExpressionBankAccountNo | String | Format of the Bank Account | |
| 言語 | AD_Language | Table | Language for this entity | |
| 通貨 | C_Currency_ID | Table Direct | The Currency for this record | |
| 有効 | IsActive | Yes-No | ✔ | The record is active in the system |
| Placeholder for Address 1 | PlaceholderAddress1 | String | ||
| Placeholder for Address 2 | PlaceholderAddress2 | String | ||
| Placeholder for Address 3 | PlaceholderAddress3 | String | ||
| Placeholder for Address 4 | PlaceholderAddress4 | String | ||
| Placeholder for Address 5 | PlaceholderAddress5 | String | ||
| Placeholder for postal | PlaceholderPostal | String | ||
| Placeholder for additional zip | PlaceholderPostal_Add | String | ||
| Placeholder for city | PlaceholderCity | String | ||
| Placeholder for comments | PlaceholderComments | String |
地域 タブのフィールド
Section titled “地域 タブのフィールド”The Region Tab defines a Region within a Country. This tab is enabled only if the Has Region checkbox is selected for the Country.
| フィールド | カラム | 型 | 必須 | 説明 |
|---|---|---|---|---|
| クライアント | AD_Client_ID | Table Direct | ✔ | Tenant for this installation. |
| 組織 | AD_Org_ID | Table Direct | ✔ | Organizational entity within tenant |
| 国 | C_Country_ID | Table Direct | ✔ | Country |
| 名称 | Name | String | ✔ | Alphanumeric identifier of the entity |
| 説明 | Description | String | Optional short description of the record | |
| 有効 | IsActive | Yes-No | ✔ | The record is active in the system |
| デフォルト | IsDefault | Yes-No | Default value |
市 タブのフィールド
Section titled “市 タブのフィールド”The Cities Tab defines Cities within a Country or Region. Cities entered here are not referenced when entering the address.
| フィールド | カラム | 型 | 必須 | 説明 |
|---|---|---|---|---|
| クライアント | AD_Client_ID | Table Direct | ✔ | Tenant for this installation. |
| 組織 | AD_Org_ID | Table Direct | ✔ | Organizational entity within tenant |
| 国 | C_Country_ID | Table Direct | Country | |
| 地域(都道府県) | C_Region_ID | Table | Identifies a geographical Region | |
| 名称 | Name | String | ✔ | Alphanumeric identifier of the entity |
| 有効 | IsActive | Yes-No | ✔ | The record is active in the system |
| 郵便番号 | Postal | String | Postal code | |
| 地域コード | AreaCode | String | Phone Area Code | |
| 住所コード | Locode | String | Location code - UN/LOCODE | |
| 地理的座標 | Coordinates | String | Location coordinate |
翻訳 タブのフィールド
Section titled “翻訳 タブのフィールド”| フィールド | カラム | 型 | 必須 | 説明 |
|---|---|---|---|---|
| クライアント | AD_Client_ID | Table Direct | ✔ | Tenant for this installation. |
| 組織 | AD_Org_ID | Table Direct | ✔ | Organizational entity within tenant |
| 地域(都道府県) | C_Region_ID | Search | ✔ | Identifies a geographical Region |
| 言語 | AD_Language | Table | ✔ | Language for this entity |
| 有効 | IsActive | Yes-No | ✔ | The record is active in the system |
| 翻訳する | IsTranslated | Yes-No | ✔ | This column is translated |
| 名称 | Name | String | ✔ | Alphanumeric identifier of the entity |
City (Without Regions) タブのフィールド
Section titled “City (Without Regions) タブのフィールド”| フィールド | カラム | 型 | 必須 | 説明 |
|---|---|---|---|---|
| クライアント | AD_Client_ID | Table Direct | ✔ | Tenant for this installation. |
| 組織 | AD_Org_ID | Table Direct | ✔ | Organizational entity within tenant |
| 国 | C_Country_ID | Table Direct | Country | |
| 地域(都道府県) | C_Region_ID | Table | Identifies a geographical Region | |
| 名称 | Name | String | ✔ | Alphanumeric identifier of the entity |
| 有効 | IsActive | Yes-No | ✔ | The record is active in the system |
| 郵便番号 | Postal | String | Postal code | |
| 地域コード | AreaCode | String | Phone Area Code | |
| 住所コード | Locode | String | Location code - UN/LOCODE | |
| 地理的座標 | Coordinates | String | Location coordinate |
翻訳 タブのフィールド
Section titled “翻訳 タブのフィールド”| フィールド | カラム | 型 | 必須 | 説明 |
|---|---|---|---|---|
| クライアント | AD_Client_ID | Table Direct | ✔ | Tenant for this installation. |
| 組織 | AD_Org_ID | Table Direct | ✔ | Organizational entity within tenant |
| 国 | C_Country_ID | Table Direct | ✔ | Country |
| 言語 | AD_Language | Table | ✔ | Language for this entity |
| 有効 | IsActive | Yes-No | ✔ | The record is active in the system |
| 翻訳する | IsTranslated | Yes-No | ✔ | This column is translated |
| 名称 | Name | String | ✔ | Alphanumeric identifier of the entity |
| 説明 | Description | String | Optional short description of the record | |
| 地域(表示名) | RegionName | String | Name of the Region | |
| Placeholder for Address 1 | PlaceholderAddress1 | String | ||
| Placeholder for Address 2 | PlaceholderAddress2 | String | ||
| Placeholder for Address 3 | PlaceholderAddress3 | String | ||
| Placeholder for Address 4 | PlaceholderAddress4 | String | ||
| Placeholder for Address 5 | PlaceholderAddress5 | String | ||
| Placeholder for postal | PlaceholderPostal | String | ||
| Placeholder for additional zip | PlaceholderPostal_Add | String | ||
| Placeholder for city | PlaceholderCity | String | ||
| Placeholder for comments | PlaceholderComments | String |
Country Group タブのフィールド
Section titled “Country Group タブのフィールド”| フィールド | カラム | 型 | 必須 | 説明 |
|---|---|---|---|---|
| クライアント | AD_Client_ID | Table Direct | ✔ | Tenant for this installation. |
| 組織 | AD_Org_ID | Table Direct | ✔ | Organizational entity within tenant |
| 国 | C_Country_ID | Table Direct | Country | |
| Country Group | C_CountryGroup_ID | Table Direct | ||
| 開始日付 | DateFrom | Date | Starting date for a range | |
| 終了日付 | DateTo | Date | End date of a date range | |
| 有効 | IsActive | Yes-No | ✔ | The record is active in the system |