Country Import Format

NOTE For general information on using imports, see Imports FAQ.

The following table lists the format for importing a record in Country Import.

Column

Position

Field

Maximum Length

Format

Required

Description

A

1

Country

10

Character

Yes

Enter a country code.

B

2

Country Name

60

Character

Yes

Enter the name of the country.

C

3

ISO Country Code

3

Character

No

Enter the International Organization for Standardization (ISO) code for the country. You can enter the two- or three-digit ISO code.

D

4

State Label

16

Character

Yes

Enter the label that appears for a state or province field when the country is selected. This allows you to customize the field so it is specific to the country’s nomenclature.

Example For the country of Canada, enter Province because Canada is comprised of provinces.

E

5

Phone Format

16

Character

Yes

Enter the format of the phone numbers for the country.

Example For the US, the format could be (999)-999-9999

Note Only the character X and/or 9 are used to denote an entry value. X can be any keyboard value. 9 must be a numeric value. All other characters will appear exactly in the field position designated. So, if the format was XXt99, then the t would always appear in the third position of this field, and the fourth and fifth positions must be numbers.

F

6

Postal Code Format

11

Character

Yes, only if you do not enter YES for the Postal Code Not Required field

Enter the format of the postal codes for the country.

Example For the US, the format could be 99999-9999.

Note Only the character X and/or 9 are used to denote an entry value. X can be any keyboard value. 9 must be a numeric value. All other characters will appear exactly in the field position designated. So, if the format was XXt99, then the t would always appear in the third position of this field, and the fourth and fifth positions must be numbers.

G

7

Validate Postal Code Against Postal Code Maintenance

3

Yes/No

No

Enter Yes to only allow postal codes that have been set up in Postal Code Maintenance to be entered in Customer Maintenance.

H

8

Royalty Region Name

12

Character

No

Enter a valid royalty region for the country. For information on setting up royalty regions, see Royalty Region Maintenance.

I

9

State/Province Not Required

3

Yes/No

No

Enter YES if you do not want to require states or provinces to be included in addresses for the country. You should only enter YES for countries that do not have states or provinces.

J

10

Postal Code Not Required

3

Yes/No

No

Enter YES if you do not want to require postal codes to be included in addresses for the country. You should only enter YES for countries that do not have postal codes.

K

11

Default Currency

8

Character

Yes, only if you enter YES for the Use VAT field and enter an amount in the Invoice Amount Limit field

Enter the default currency for the country.

L

12

Use VAT

3

Yes/No

No

Enter YES if the country uses VAT.

M

13

VAT Due Days

3

Integer

No

Enter a number of days before vouchers expire if VAT invoices for the country have not been approved.

N

14

Default VAT Supplier

15

Character

No

Enter the supplier code of the default VAT supplier to which you will pay VAT for purchase orders. This is the default VAT supplier for purchase orders for products ordered from one country and shipped to a different country. This can be overridden for specific locations or purchase orders.

O

15

Invoice Amount Limit

14

>>>,>>>,>>9.99

No

Enter the invoice amount limit (in the country's default currency) if the country has limitations on the monetary amount of invoices created for each company.

P

16

Input VAT Clearing

29

Character

No

Enter all or part of the input VAT clearing general ledger account to use when resolving the account from the country. For more information on input VAT clearing accounts, see VAT Account Resolution.

Note You can enter asterisks (*) for account elements you do not want to resolve from the country. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks.

Q

17

Input VAT

29

Character

No

Enter all or part of the input VAT general ledger account to use when resolving the account from the country. For more information on input VAT accounts, see VAT Account Resolution.

Note You can enter asterisks (*) for account elements you do not want to resolve from the country. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks.

R

18

Input VAT Write-off

29

Character

No

Enter all or part of the input VAT write-off general ledger account to use when resolving the account from the country. For more information on input VAT write-off accounts, see VAT Account Resolution.

Note You can enter asterisks (*) for account elements you do not want to resolve from the country. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks.

S

19

Input VAT Pending

29

Character

No

Enter all or part of the input VAT pending general ledger account to use when resolving the account from the country. For more information on input VAT pending accounts, see VAT Account Resolution.

Note You can enter asterisks (*) for account elements you do not want to resolve from the country. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks.

T

20

Output VAT

29

Character

No

Enter all or part of the output VAT general ledger account to use when resolving the account from the country. For more information on output VAT accounts, see VAT Account Resolution.

Note You can enter asterisks (*) for account elements you do not want to resolve from the country. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks.

U

21

Output VAT Variance

29

Character

No

Enter all or part of the output VAT variance general ledger account to use when resolving the account from the country. For more information on output VAT variance accounts, see VAT Account Resolution.

Note You can enter asterisks (*) for account elements you do not want to resolve from the country. You must enter an asterisk for each digit in the account element. For example, if an element has a length of four, you must enter four asterisks.

V

22

 

 

 

 

Leave this field blank. It is not used.

W

23

Excise Supplier Code

15

Character

No

Enter a valid supplier code to which to pay excise tax for the country.

X

24

Excise Export Procedure

20

Character

No

If the country requires exported data for all products that are leaving the excise tax suspension regime, enter the Apprise program that will be used to export this data.