Set up country address layouts window

The Set up country address layouts window is used to enter format codes, to modify existing format codes, to format address layouts, and to apply formatted addresses to specific countries defined in the Country_Names table. This address format information is stored in the Country_Addr_Layouts table.

Desktop: Customers > Set up tables > Country address layouts

Format

This field contains an address format code that will be auto-assigned to an address format (Country_Addr_Layouts.ADDRESS_FORMAT).

Description

Specifies a description for the address format (Country_Addr_Layouts.DESCRIPTION).

Address Fields

Use this drop-down list to select the fields that you want to use in the address format.

Use the area located below the Address Fields field to format the address layout (Country_Addr_Layouts.ADDRESS_LAYOUT). The formatted address layout combines the component fields of the address with four formatting codes:

  • [U] - Uppercase. Enter [U] before a component field to make the data in the field all uppercase. For example, [U]CITY would generate all capital letters for a city such as NEW YORK or LONDON.
  • [N] - New line. Enter [N] after a component field to insert a carriage return. For example, ADDRESS_1[N] would generate a carriage return and place the next component field on a different line in the address.
  • [S] - Space. Enter [S] after a component field to insert a space between component fields. For example, [U]STATE_PROVINCES[S][U]ZIP would display as TEXAS 75208 when generated in an address.
  • [C] - Comma. Enter [C] after a component field to insert a comma between component fields. For example, CITY[C][S][U]STATE[S][U]ZIP would display as Dallas, TEXAS 75208 when generated in an address.

Available Countries

Lists the countries that have not had address formats applied to them.

Note: Countries must be entered on the Country names window before they will be available for address formatting.

Add

Used to move selected countries from the Available Countries list to the Format Applied to list. This action is part of the process of applying an address format to a country.

Remove

Used to move selected countries from the Format Applied to list to the Available Countries list. This action is part of the process of removing an address format from a country.

Layout Applied to

Lists the countries for which address formatting has been applied.

Test Layout

Opens the Address Layout Tester window that is used to verify that an address is formatted correctly.

To enter an address format

  1. From Country address layouts window, click New. The Format field automatically populates with the next succeeding format code. For example, if the last format code created was 15, then format code 16 will be entered automatically in the Format field.
  2. Enter a Description for the country address format.
  3. Arrange the component fields in the area located below the Address Fields field to suit the desired address layout. For example, if you want the country name to display on the first line in the address layout, press Enter before ADDRESS_1[N] to move it to the second line, highlight COUNTRY and press Ctrl+X, then press Ctrl+V.
  4. Enter the formatting codes in the Address Layouts field to format the address.
  5. Click Save.

To apply an address format to a country

Make sure the country that you want to apply an address format to has been added to the Country_Names table.

  1. From Country address layouts window, click Find.
  2. Click the lookup icon in the Format field to choose the format code for the address format that you want to modify.
  3. Click OK. The address format assigned to that code opens in the window. The countries for which no address formatting has been applied display in the Available Countries drop-down list.
  4. Click Edit.
  5. Select the country (or countries) from the Available Countries list for which you want to apply address formatting.
  6. Click Add to move the selected country from the Available Countries list to the Layout Applied to list.
  7. Click Save to apply the address format to the country.
  8. (optional) Select Test Layout to verify that the formatted address layout produces the desired result.

More:
Address Layout Tester window