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. |