Setting Up Locations

Use the following components to set up locations:

Country (COUNTRY_TABLE)
State (STATE_DEFN)
Location (LOCATION_TBL)
Country Statistics (COUNTRY_STAT)

Use the LOCATION_TBL_CI component interface to load data into the tables for these components.

This topic discusses how to:

Review country descriptions.
Select address formats by country.
Review state and province descriptions.
Define locations.
Add location details.
Define countries for reporting.

Pages Used to Set Up Locations

Page Name	Definition Name	Navigation	Usage
Country Description	COUNTRY_DEFN	select Set Up Financials/Supply Chain, then select Common Definitions, then select Location, then select Country, then select Country Description	Add or review country descriptions.
Address Format	ADDR_FORMAT_TABLE	select Set Up Financials/Supply Chain, then select Common Definitions, then select Location, then select Country, then select Address Format	Select address fields for a country so that the system displays addresses in the appropriate format.
State	STATE_DEFN	select Set Up Financials/Supply Chain, then select Common Definitions, then select Location, then select State, then select State	Add or review a state or province code.
Location Definition	LOCATION_TBL	select Set Up Financials/Supply Chain, then select Common Definitions, then select Location, then select Location, then select Location Definition	Define a location code, such as a branch office or shipping office.
Location Detail	LOCATION_TBL2	select Set Up Financials/Supply Chain, then select Common Definitions, then select Location, then select Location, then select Location Detail	Add details to a location definition.
Country Stat Rpt Codes	COUNTRY_STAT_PNL	select Set Up Financials/Supply Chain, then select Common Definitions, then select Location, then select Country Statistics, then select Country Stat Rpt Codes	Enter country codes requiring reporting as well as reporting options for each country code that you specify.

Country Description Page

Use the Country Description page (COUNTRY_DEFN) to add or review country descriptions.

Navigation

select Set Up Financials/Supply Chain, then select Common Definitions, then select Location, then select Country, then select Country Description

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

Enter a two-character country code to meet value added tax (VAT) requirements. The system appends the 2-character country code to the VAT registration ID, which is a 20-character number to meet VAT requirements.

EU Member State (European Union member state)

Select if the country is a member of the European Union. You must select this option to include a country in prompts for Intrastat reporting.

Address Format Page

Use the Address Format page (ADDR_FORMAT_TABLE) to select address fields for a country so that the system displays addresses in the appropriate format.

Navigation

select Set Up Financials/Supply Chain, then select Common Definitions, then select Location, then select Country, then select Address Format

Available

Select to make the field available everywhere in the system.

Label

Enter the name of the field as it is to appear on the page.

For example, change the value in the State field to Province or Department.

Address 1, Address 2, Address 3, and Address 4

Select the address fields normally used by the country that you selected.

Postal Search

Select if you want the Postal Search link to appear on the Location Definition page. This link enables the user to find a postal delivery code.

Number 1, Number 2, House Type, Field 1 Label, Field 2 Label, and Field 3 Label

If you select these fields, they replace the Address 4 field on pages.

Location - State Page

Use the Location - State page (STATE_DEFN) to add or review a state or province code.

Navigation

select Set Up Financials/Supply Chain, then select Common Definitions, then select Location, then select State, then select State

Numeric Code

Use to assign a number to a state or province for statistics and reports.

State

Enter a state abbreviation.

Country

Select a country.

Description

Enter a description for the state or locality.

Location - Definition Page

Use the Location Definition page (LOCATION_TBL) to define a location code, such as a branch office or shipping office.

Navigation

select Set Up Financials/Supply Chain, then select Common Definitions, then select Location, then select Location, then select Location Definition

Image: Location Definition page

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

Enter a description and populate the fields for the telephone and address information.

The address fields that appear are defined on the Address Format page.

In City Limit

Select if you use a third-party tax provider product and if you need to access additional city tax information.

Note: The In City Limit is not used by the Vertex O Series tax solution.

Alternate Character Set

Click to access a page where you can enter or display (or both) field values in an alternate character set. This button appears only if you selected the Alternate Character check box on the User Preferences - Overall Preferences page.

Address 2 and Address 3

If not used at this location, you can enter values in these fields to provide more information about the location, such as Printing Division or Western Annex.

Address 4

The space available to display addresses on a page is limited. The Address 4 field will not appear if you select some of the optional address fields on the Address Format page, such as Number 1 or House Type.

GeoCode

This value is used by third-party tax applications to link a location definition to their tax calculation algorithms. If no geocode has been selected, this field displays a Lookup link. Clicking the geocode value or Lookup link accesses the Tax GeoCode Selection page, where you select a geocode value for the location definition.

You must select a geocode for each location definition in order to integrate properly with your third-party tax application.

Error messages that appear for this field are issued by the third-party application, and more information is provided in the third-party application documentation.

Location - Detail Page

Use the Location Detail page (LOCATION_TBL2) to add details to a location definition.

Navigation

select Set Up Financials/Supply Chain, then select Common Definitions, then select Location, then select Location, then select Location Detail

Image: Location Detail page

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

Attention To

Enter the name that appears in the attention area of correspondence for this location.

Location Detail

Enter additional information that you want to maintain for this location.

Carton Label

Select the default format for printing carton labels for this location.

Shipping Container Label

Select the default format for printing shipping container labels for this location.

Usage Label

Select the default format for printing item usage labels for this location.

ID Numbers

Use this section to specify any additional types of identifiers for the location. The system supports a list of number types, such as GLN (a 13-digit numeric value) or DUNS number. Except for GLNs, other ID numbers entered here are not validated at save.

The SetID field is not available for edit for all ID types. For each location specified in the system, you can only enter one ID number for any given type.

Country Stat Rpt Codes Page

Use the Country Stat Rpt Codes (country statistics report codes) page (COUNTRY_STAT_PNL) to enter country codes requiring reporting as well as reporting options for each country code that you specify.

Navigation

select Set Up Financials/Supply Chain, then select Common Definitions, then select Location, then select Country Statistics, then select Country Stat Rpt Codes

Image: Country Stat Rpt Codes

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

Use for Statistics

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

2-Char VAT (two character value added tax)

Enter a 2-character country code to meet special value added tax (VAT) requirements for certain countries. This is useful for some countries that are not using the ISO 3166 country code in conjunction with their VAT registration ID. When appending the 2-character country code to the VAT registration ID, Financials accesses this separate country code. The VAT registration ID is a 20-character number to meet VAT requirements.

2-Char Intrastat (two character intrastat)

Displays the country identifier for the European statistical offices. This code is printed on some of the Intrastat Layout forms.

2-Char ESL (two-character European Sales List)

Used for countries that are members of the European Union. This code is usually printed as part of the VAT Registration Information on the European Sales List (ESL).

3-Dig Cntry (three-digit country)

Used as a country identifier for the European statistical offices, the code is usually printed on the Intrastat report to identify source or destination countries to or from which goods are shipped.

7-Char Descr (seven-character description)

Used for the German international EFT layout to identify countries into or from which electronic funds are sent or received.

SUT Flag (sales and use tax flag)

Informational only.