Setting Up the Country Table (WCTY)
Purpose: Setting up the country table consists of creating identifying codes for each country where your customers or vendors reside. You can also create information related to a country, such as:
• any duty rates that apply to shipments to the country
• the telephone number formats for each country
• valid states for each country, and whether they are subject to VAT
• whether a state or a postal code is required for a customer address
• whether a valid SCF/ship via is required for the ship via and shipping address on an order
• a default VAT or tax rate for the country
Default country: Use the Default Country for Customer Address (B17) system control value to specify this default.
In this chapter:
• Work with Telephone Number Format Screen
- Telephone Number Format Examples
- Validation For Phone Numbers
- Telephone Number Layout Screen (Create Mode)
- Revising Telephone Number Formats
How to display this screen: Enter WCTY in the Fast path field at the top of any menu or select Work with Countries from a menu.
Field |
Description |
Country |
A code representing a country. Alphanumeric, 3 positions; optional. |
Description |
The name of the country. Alphanumeric, 30 positions; optional. |
Require state |
Controls whether a state is required in Order Entry, Customer Maintenance, and when setting up item restrictions by country/state. See Entering Additional Item Information, for more information on item country/state restrictions. Valid values are: • Yes = A state code is required. • No = A state code is not required. Optional. |
Country prefix |
The country's international telephone prefix. Numeric, 3 positions; optional. |
ISO code |
A code representing the international standard code used to identify a country. If you use the Experian Data Quality (EDQ) Address Validate API, the system sends the ISO country code instead of the country code as part of the address sent to EDQ for standardization. See Country ISO Codes for a list of country ISO codes supplied by EDQ. If you are using the ChannelAdvisor integration, you need to specify a 2-position ISO code for each country where you ship orders. See ChannelAdvisor Integration Overview and ChannelAdvisor Setup for more information. Alphanumeric, 3 positions; optional. |
Screen Option |
Procedure |
Create a country code |
Select Create to display the Create Country Screen. |
Change a country code |
Select Change for a country code to display the Change Country screen. See Create Country Screen for field descriptions. You can change any information except the country code. |
Delete a country code |
Select Delete for a country. |
Display a country code |
Select Display for a country code to advance to Display Country screen. You cannot change any information on this screen. See Create Country Screen for field descriptions. |
Work with duty rates for a country |
Select Duty Rates for a country code to display the Work with Duty Rates Screen. |
Work with telephone number formats for a country |
Select Phone Format for a country code to display the Work with Telephone Number Format Screen. |
Work with state codes for a country |
Select States for a country code to display the Work with States Screen. |
Work with user defined fields |
Select User Options for a country code to advance to the Work with User Fields Screen. |
Purpose: Use this screen to create a country code.
How to display this screen: Select Create at the Work with Countries Screen.
Field |
Description |
Country |
A code to identify a country. Invoice currency: If you want the system to record the currency rate in effect for orders at the time they are billed in the Invoice Currency table, the country code must match a code from the Currency table. You must also have the Track Invoice Currency (D68) system control value selected. Note: This is a separate type of tracking than that related to multi-currency by offer. See Setting Up Order Entry Values for more information on defining Order Entry values. Alphanumeric, 3 position. Create screen: required. Change screen: display-only. |
Description |
A description of the country. This is the description that prints on pick slips, for example. Alphanumeric, 30 positions; required. |
This flag controls whether a state code is required for customer addresses, or for item country/state restrictions that you set up through the Work with Items menu option. Valid values are: • Selected (default) = The state code is required. • Unselected = The state code is not required; however, if you do specify a state code for a customer address, it needs to be a valid state for the country as set up through the Create State Screen. You can define state codes for a country by selecting States for a country at the Work with Countries Screen. Item restrictions: If a country does not require state codes, you can set up item country/state restrictions for the entire country. Item country restrictions prevent you from entering an order for items which cannot be shipped to this country. See Entering Additional Item Information. |
|
Indicates whether a postal code is required for customer addresses for the country. Valid values are: • Selected (default) = The postal code is required. • Unselected = The postal code is optional for customer addresses, and: - You do not need to set up postal code records for the country using the Setting Up the Zip/City/State (Postal Code) Table (WZIP) option. - If you enter a postal code for a customer address, the system does not validate it against the Postal Code table or the SCF table. See the Perform ship via edit? flag below for more information. Brokered backorders: When the system submits a brokered backorder for fulfillment, the Order Broker rejects it if the shipping address does not include a postal code. In this situation, the backorder returns to standard backorder processing in the warehouse. See Brokered Backorders for more information on brokered backorders. |
|
Perform ship via edit? |
Indicates whether to validate the SCF and ship via on an order or order line against the SCF Ship Via table. Valid values are: • Selected (default) = The SCF/ship via combination on an order or order line must exist in the SCF Ship Via table. • Unselected = The SCF/ship via combination on an order or order line does not need to exist in the SCF Ship Via table. Note: If the Require postal code? flag is unselected for a country, no ship via edit takes place in order entry regardless of the setting of the Perform ship via edit? flag. Use Working with SCF Codes (WSCF) to create the SCF record of # for the country, and then use Working with SCF/Ship Via Values (WSHV) to create the SCF/ship via record for each valid ship via for the country. |
Phone country code |
A valid international telephone prefix for the country. You can define a telephone number format for a country by selecting Phone Format for next to a country at the Work with Countries Screen. See Telephone Number Layout Screen (Create Mode). Numeric, 3 positions; optional. |
The default VAT or tax percentage for the country. The system uses this value in two different ways, depending on how the Tax Included in Price (E70) system control value is set: If this system control value is selected this means that you charge the tax-inclusive price for items you ship to certain states or provinces; instead of including an amount in the Tax bucket on the order, the tax is “hidden” in the item price. To determine the hidden tax amount, the system first checks the SKU record to determine if there is a unique hidden tax amount or percentage defined for the item; if there is no hidden tax information for the item, the system uses the VAT percentage defined for the country where you are shipping the order. If there is no VAT percentage for the customer's country, and if there is no hidden tax information for the SKU, no hidden tax will be charged. Only shipments to states flagged as subject to VAT (the VAT exempt flag is unselected) use tax-inclusive pricing and hidden tax. See Work with States Screen. The system never checks the VAT percentage for orders subject to regular taxing rather than VAT; instead, the system first checks the customer's postal code record, then the customer's SCF, for the tax rate on the order. |
|
|
If this system control value is unselected, this means that any tax on the order is included in the Tax bucket and you never charge a tax-inclusive price or hidden tax. If an item on an order is subject to tax, the system multiplies the item price by the VAT percentage for the customer's country and adds this amount to the Tax bucket on the order. If there is no VAT percentage defined for the customer's country, the system next checks the customer's postal code, then the customer's SCF, to find an applicable tax percentage. Numeric, 6 positions; optional. |
ISO code |
A code representing the international standard code used to identify a country. If you use the Experian Data Quality (EDQ) Address Validate API, the system sends the ISO country code instead of the country code as part of the address sent to EDQ for standardization. See Country ISO Codes for a list of country ISO codes supplied by EDQ. Alphanumeric, 3 positions; optional. |
Purpose: Use this screen to create, change, delete or display duty rates for international orders. The system consults these rates to determine whether to add duty to orders you are shipping to this country.
Overview: Duty is a tax you can add to orders you are shipping to customers in certain countries. The system performs the following checks to determine whether to charge duty for an item in Order Entry:
• Is the shipper exempt from duty? If the field for the shipper on the order header is selected, the system will not add any duty to the order. This flag must be unselected for the system to evaluate the order for duty charges.
• Does the item's harmonize code match a duty rate defined for the country? The system compares the harmonize code defined for the item or SKU with the harmonize codes associated with the duty rates. If it finds a match in harmonize code, the system computes duty for the item and adds this charge to the order. Two blank records are a match; that is, if both the item's and the duty rate's harmonize codes are blank, the system will add the duty to the order. You can define harmonize codes for items through Performing Initial Item Entry (MITM) or Updating Harmonize Codes (UPHC).
If you use an external tax system and want to pass the duty information, you must create a product table record for duty.
Reviewing duty charges: Duty appears on the order totals in the Handling bucket, but appears separately on the Display Order Detail Screen (Reviewing Order Line Detail) in standard Order Inquiry and the Work with Order Line Screen (Changing/Adding an Item) in Order Entry and Order Maintenance. The system writes an order line message when an item has a duty charge. You can also review duty charges on an invoice at the Invoice Detail Charges screen, available by selecting Invoices in standard Order Inquiry and advancing to the invoice detail level.
Note: Duty does not appear on your pick slip without customization. Contact your Order Management System representative for more information.
How to display this screen: Select Duty Rates for a country at the Work with Countries Screen.
Field |
Description |
Country |
The code representing the country where the duty rates apply. Alphanumeric, 3 positions; display-only. |
Description |
The description associated with the country code. Alphanumeric, 25 positions; display-only. |
Harmonize code |
The code that associates an item with a duty rate. The system applies duty to an order if the ship-to address is in this country, and if the harmonize code defined for the item or SKU matches a harmonize code defined for a duty rate. If both the item's and the duty rate's harmonize codes are blank, the system considers this a match, and applies the duty rate. You can define harmonize codes for items through Performing Initial Item Entry (MITM) or Updating Harmonize Codes (UPHC). Alphanumeric, 16 positions; optional. |
Duty amount |
The amount of duty to add to the order for the item. The system multiplies this amount by the unit quantity. You can define either a duty amount or a percentage. Numeric, 11 positions with a 2-place decimal; display-only. |
Duty percent |
The percentage of duty to add to the order for the item. The system adds the percentage of the extended price for the item line. Numeric, 5 positions with a 2-place decimal; display-only. |
Screen Option |
Procedure |
Change a duty rate |
Select Change for a duty rate to advance to the Change Duty Rates screen. You can change only the Duty percent or Duty amount fields on this screen. See Create Duty Rates Screen for field descriptions. |
Delete a duty rate |
Select Delete for a duty rate. |
Display a duty rate |
Select Display for a duty rate to advance to the Display Duty Rates screen. You cannot change any information on this screen. See Create Duty Rates Screen for field descriptions. |
Create a duty rate |
Select Create to create a new duty rate. See Create Duty Rates Screen. |
Purpose: Use this screen to create a duty rate.
How to display this screen: Select Create at the Work with Duty Rates Screen.
Field |
Description |
Country |
The code representing the country where the duty rates apply. Alphanumeric, 3 positions; display-only. |
Harmonize code |
The code that associates an item with a duty rate. The system applies duty to an order if the ship-to address is in this country, and if the harmonize code defined for the item or SKU matches a harmonize code defined for a duty rate. If both the item's and the duty rate's harmonize codes are blank, the system considers this a match, and applies the duty rate; for this reason, a blank harmonize code is a valid value. You can define harmonize codes for items through Performing Initial Item Entry (MITM) or Updating Harmonize Codes (UPHC). Alphanumeric, 16 positions. Create screen: required. Change screen: display-only. |
Duty percentage |
The percentage of duty to add to the order for the item. The system adds the percentage of the extended price for the item line. You can define either a duty amount or a percentage. Numeric, 5 positions with a 2-place decimal; required if no duty amount is defined. |
Duty amount |
The amount of duty to add to the order for the item. The system multiplies this amount by the unit quantity. You can define either a duty amount or a percentage. Numeric, 11 positions with a 2-place decimal; required if no duty percentage is defined. |
Work with Telephone Number Format Screen
Purpose: Use this screen to define the format for phone numbers. Telephone number formats are defined by country, but each country can have more than one telephone number format.
When an operator enters a phone number, the system compares the number of numeric characters in the phone number with the telephone number formats you have defined. In order to match a format, the phone number must have the same number of numeric positions as a telephone number format. If the system cannot find a match, the phone number does not map to a telephone number format and displays as it was entered by the operator. For this reason, it is useful to consider the different telephone number formats your operators typically use and define a format to cover each.
Telephone Number Format Examples
Example: |
Telephone number format with a numeric length of 7: 1 2 3 - 4 5 6 7 |
|
7 position phone number: 5550100 |
|
5550100 formats to 555 - 0100 |
Example: |
Telephone number format with a numeric length of 10: ( 1 2 3 ) 4 5 6 - 7 8 9 10 |
|
10 position phone number: 5085550100 |
|
5085550100 formats to (508) 555 - 0100 |
Example: |
Telephone number format with a numeric length of 11: 1 ( 2 3 4 ) 5 6 7 - 11 10 9 8 |
|
11 position phone number: 15085550100 |
|
15085550100 formats to 1 (508) 555 - 0100 |
The system calls a user-defined program to validate phone numbers outside the Order Management System environment if you set the External Validation for Phone Number (E64) system control value to Y. The system provides a “hook” to the program when an operator accepts the entries on a screen containing a phone number associated with a country. You can use this program to validate phone number rules for a specific country: for example, if a phone number for a country should only contain 6 numbers and the operator enters more than 6, the screen displays an error message. Phone numbers that are not associated with a country, for example, phone numbers in the Bank, Salesman, Warehouse and Ship Via tables, are not validated. The program validates phone numbers based on the following parameters:
• Company
• Country
• State
• City
• Phone Number
How to display this screen: Select Phone Format for a country.
Field |
Description |
Country |
The country code and description associated with the phone format. Country code: Alphanumeric, 3 positions; display-only. Country description: Alphanumeric, 30 positions; display-only. |
Code length |
The number of numeric characters in the phone number. Numeric, 3 positions; optional. |
Format (Telephone number format) |
The telephone number format, illustrated by arranging numbers from 1 to 14 in the same order and position as the numbers in a phone number would display. Enter special characters, such as hyphens or parenthesis, where you would like them to display. Example: The telephone number format used in the United States to represent an area code and a local phone number is: (508) 555-0100 When an operator enters a phone number containing 10 numbers (as in the example), the phone number changes to the format defined for 10 numbers, regardless of how the operator entered it into the system. Alphanumeric, fourteen 2-position fields; display-only. |
Screen Option |
Description |
Change a telephone number format |
Select Change for a telephone number format to advance to the Telephone Number Layout screen in Change mode. You can change the Formatted telephone number positions fields on this screen only. See Telephone Number Layout Screen (Create Mode) for field descriptions. |
Delete a telephone number format |
Select Delete for a telephone number format. |
Display a telephone number format |
Select Display for the telephone number format to advance to the Telephone Number Layout screen in Display mode. You cannot change any information on this screen. See Telephone Number Layout Screen (Create Mode) for field descriptions. |
Create a telephone number format |
Select Create. See Telephone Number Layout Screen (Create Mode). |
Map existing phone numbers to the telephone number formats defined. |
Select Submit Reformat. See Revising Telephone Number Formats. |
Telephone Number Layout Screen (Create Mode)
Purpose: Use this screen to create a telephone number format for a country.
How to display this screen: Select Create at the Work with Telephone Number Format Screen.
Field |
Description |
Country |
The country associated with the telephone number format you are creating. Alphanumeric, 3 positions; display-only. |
The number of numeric characters in the phone number. The maximum number is 14. Numeric, 3 positions. Create screen: required. Change screen: display-only. |
|
The order and positions of each of the numbers for a phone number format, including any special characters such as hyphens or parentheses. The first number of the phone number will display where you enter a 1, the second number will display where you enter a 2, etc. Example: Create a United States phone number containing an area code and local phone number as: ( 1 2 3 ) 4 5 6 - 7 8 9 10 A message similar to the following indicates if you enter a telephone number format that includes a numeric length already defined for that country: Telephone Number Format already exists. Note: If an operator enters a phone number containing a length that has not been defined in a telephone number format, the system will not format the phone number and it will display as it was entered by the operator. Alphanumeric, fourteen 2-position fields; optional. |
Instructions:
1. Enter the numeric length of the telephone number format in the Length field.
2. Enter the telephone number format in the Formatted telephone number positions fields, indicating where each number of the phone number should display. Include any special characters, such as hyphens or parentheses in the format. Use the Unformatted Telephone Number Positions fields as a guideline. See the field descriptions for examples.
Revising Telephone Number Formats
Submitting reformat: Select Submit Reformat at the Work with Telephone Number Format Screen to submit a batch program. This program revises existing phone numbers to the telephone number formats defined on the screen. You must confirm the submission at the Confirm Accept pop-up window.
Only phone numbers containing the same length as a telephone number format will be revises. For example, if a telephone number format with a length of 10 is defined as: ( 1 2 3 ) 4 5 6 - 7 8 9 10, any telephone number with a length of 10 will be revised so that the first 3 positions are in parentheses and a hyphen is between the sixth and seventh numbers.
Purpose: Use this screen to define the state codes for a country. The system prevents you from entering a customer address if the state and country do not match, based on your entries here.
How to display this screen: Select States for a country at the Work with Countries Screen.
Field |
Description |
Country |
The country code associated with the states. Alphanumeric, 3 positions; display-only. |
State |
A code that defines a state within a country. Alphanumeric, 2 positions; optional. |
Description |
The name of the state. Alphanumeric, 25 positions; display-only. |
VAT exempt flag |
This flag controls whether shipments to this state are exempt to VAT only if the Tax Included in Price (E70) system control value is selected; in this case, the system uses the tax-inclusive price for an item and adds a Hidden tax, if applicable, to the order line. If this system control value is unselected, or if the state is exempt from VAT, the system adds tax to the order in the Tax bucket, and does not check this field when determining whether to charge tax on an order. Valid values are: • Y = Shipments to this state are exempt from VAT if the Tax Included in Price (E70) system control value is selected; the regular item price will be used, rather than the tax-inclusive price, and any tax on the order will be added to the Tax bucket. The system will check the postal code first, and then the SCF, to find the appropriate tax rate for the order. • N (default) = Shipments to this state are subject to VAT if the Tax Included in Price (E70) system control value is selected; the tax-inclusive price will be used, and any applicable tax for an item will appear in the Hidden tax field on the order line. This setting defaults to unselected if there is a VAT percent (Value added tax percentage) defined for the country; otherwise, it defaults to selected. Display-only. |
Screen Option |
Description |
Change the description or VAT exempt flag for a state |
Select Change for a state to display the Change State screen. You can change only the Description and VAT exempt flag fields on this screen. See Create State Screen for field descriptions. |
Delete a state |
Select Delete for a state. |
Create a state |
Select Create to display the Create State Screen. |
Purpose: Use this screen to create a state code for a country.
How to display this screen: Select Create at the Work with States Screen.
Field |
Description |
Country |
The country associated with the state. Alphanumeric, 3 positions; display-only. |
State code |
A code that defines a state within the country. For countries that do not require states, you should create one state record with a state code of **. Then, when you create SCF and postal codes for the country, you assign each to this state code. Alphanumeric, 2 positions. Create screen: required. Change screen: display-only. |
The description of the state you are creating. Alphanumeric, 25 positions; required. |
|
Controls whether shipments to this state are exempt from VAT. The system checks this flag only if the Tax Included in Price (E70) system control value is selected; in this case, the system uses the tax-inclusive price for an item subject to VAT and adds a Hidden tax, if applicable, to the order line. If this system control value is unselected, or if the state is VAT-exempt, the system adds any applicable tax to the order in the Tax bucket, and does not check this field when determining whether to charge tax on an order. Valid values are: • Selected = Shipments to this state are exempt from VAT if the Tax Included in Price (E70) system control value is selected; the regular item price will be used, rather than the tax-inclusive price, and any tax on the order will be added to the Tax bucket. The system will check the postal code first, and then the SCF, to find the appropriate tax rate for the order. • Unselected = Shipments to this state are subject to VAT if the Tax Included in Price (E70) system control value is selected; the tax-inclusive price will be used, and any applicable tax for an item will appear in the Hidden tax field on the order line. This field defaults to unselected if there is a VAT percent (Value added tax percentage) defined for the country; otherwise, it defaults to selected. |
Note: When you create a state, you must also define an SCF code and postal code for the state or Order Entry, Maintenance and Catalog Requests display an error message similar to the following:
Invalid state (FL) for zip. Valid states are: (MA)
See Working with SCF Codes (WSCF) for more information on SCF's, and Setting Up the Zip/City/State (Postal Code) Table (WZIP) for more information on postal codes.
