Setting Up Country and State Information

This topic discusses how to:

Review country descriptions.
Select an address format by country.
Validate addresses.
Define countries for reporting.
Specify state information.

Pages Used to Set up Country and State Information

Page Name	Definition Name	Navigation	Usage
Country Table - Country Description	COUNTRY_DEFN	select EPM Foundation, then select EPM Setup, then select Common Definitions, then select Country and State Info, then select Country Table, then select Country Description	Review country descriptions.
Country Table - Address Format	ADDR_FORMAT_TABLE	select EPM Foundation, then select EPM Setup, then select Common Definitions, then select Country and State Info, then select Country Table, then select Address Format	Select an address format by country. You do so by configuring address fields and field descriptions so that addresses conform to the customary address format of the specified country. After the address format is set, it appears everywhere that the system uses the address subrecord.
Country Table - Valid Address	EO_ADDR_VALIDAT	select EPM Foundation, then select EPM Setup, then select Common Definitions, then select Country and State Info, then select Country Table, then select Valid Address	Validate addresses by adding valid combinations of address fields.
Country Statistics	COUNTRY_STAT_PNL	select EPM Foundation, then select EPM Setup, then select Common Definitions, then select Country and State Info, then select Country Statistics	Specify countries for reporting.
State	STATE_DEFN	select EPM Foundation, then select EPM Setup, then select Common Definitions, then select Country and State Info, then select State Table, then select State	Specify state, province, or other geopolitical region information.

Country Table - Country Description Page

Use the Country Table - Country Description page (COUNTRY_DEFN) to review country descriptions.

Navigation

select EPM Foundation, then select EPM Setup, then select Common Definitions, then select Country and State Info, then select Country Table, then select Country Description

Image: Country Description page

This example illustrates the fields and controls on the Country Description page. You can find definitions for the fields and controls later on this page.

The system displays the country code, description, and a short description for the country.

PeopleSoft delivers a fully populated country code table, which is updated as national boundaries and designations change.

2-Char Country Code (two-character country code)

Enter a country code. Country codes are informational indicators that record the value-added tax (VAT) registration ID for each country where your company does business.

EU Member State (European Union member state)

Select to specify that the country is a member of the European Union.

Country Table - Valid Address Page

Use the Country Table - Valid Address page (EO_ADDR_VALIDAT) to validate addresses by adding valid combinations of address fields.

Navigation

select EPM Foundation, then select EPM Setup, then select Common Definitions, then select Country and State Info, then select Country Table, then select Valid Address

To enable this page, select the Enable Address Search check box on the Address Format page, which enables the Used in Search column. The fields that you select to be used in a search appear on the Valid Address page as columns. Enter the valid address combinations that the user can search for and select.

Country Statistics Page

Use the Country Statistics page (COUNTRY_STAT_PNL) to specify countries for reporting.

Navigation

select EPM Foundation, then select EPM Setup, then select Common Definitions, then select Country and State Info, then select Country Statistics

Image: Country Statistics page

This example illustrates the fields and controls on the Country Statistics page. You can find definitions for the fields and controls later on this page.

PeopleSoft EPM only uses this page to establish the countries for statistical purposes. So most of the information is for informational purposes only, because the reports mentioned are not available through the PeopleSoft EPM database. For more information on the reports mentioned in the following topic, refer to the appropriate PeopleSoft Financials application documentation.

Country

Select the country on which you would like to report.

Use for Statistics

If this check box is selected, the country recognized by the International Standards Organization (ISO) is also recognized by the European statistical offices. If the check box is not selected, the country is recognized only by the ISO. In this case, European statistical offices assume that the country is a part of another country when producing statistical data such as the gross national product (GNP). For example, for the ISO, the principality of Monaco has its own country code, but for statistical purposes, Monaco is assumed to be part of France, and therefore has the same statistical country code as France.

2-Char Intrastat Country Cd (two-character intrastat country code)

The country identifier for the European statistical offices. This code often appears on intrastat layout forms.

2-Char ESL Country Cd (two-character ESL country code)

Used for countries that are members of the European Union. It usually appears as part of the VAT registration information on the European Sales List (ESL).

3-Dig Stat Country Cd (three-digit statistical country code)

Used as a country identifier for the European statistical offices. It usually appears on the intrastat report to identify source or destination countries to which or from which goods are shipped.

7-Char Country Descr (seven-character country description)

Used for the German international Electronic Funds Transfer (EFT) layout. It identifies countries into which or from which electronic funds are sent or received.

Sales/Use Tax Code

Informational only. This field can be set to None, Sales, or Use.

State Page

Use the State page (STATE_DEFN) to specify state, province, or other geopolitical region information.

Navigation

select EPM Foundation, then select EPM Setup, then select Common Definitions, then select Country and State Info, then select State Table, then select State

Image: State page

This example illustrates the fields and controls on the State page. You can find definitions for the fields and controls later on this page.

PeopleSoft delivers a fully populated state code table. PeopleSoft updates the state table as changes occur. This table provides states, provinces, and equivalent geopolitical entities (for example, Dutch communities and French departments) for all supported countries. The codes are based on standard postal codes.

Numeric Code

Assign a number to a state or province for statistics and reporting purposes.