Country

This code is used to identify the country associated with the information.

In the country table, which controls this field, there is a certain number of characteristics useful to perform controls on dependent information, and especially :

• the telephone number format
• the format of the number identifying a company or an activity (SIRET, NAF in France)
• the postal code format
• the format of the bank ID number

Enter the description of the relevant record.

This long description is used as a title in screens and reports.

This code helps identify the currency for a site, a business partner, or define a default value. This code is controlled in the currency table. It is advisable to use the ISO code during the creation of a new currency.

Select this check box if the country is a member of the European Union.   
The EU-related information are used for the Intrastat declaration. 

Enter the date at which the country joined the European Union, if this country is a member state of the EU.

Enter the date at which the country has left the European Union, if this country is a former member state of the EU.

Select this check box to enable the EORI number field for all entities from this country including companies, sites and business partners (BPs).

Note: This number is needed for entities doing business within the UK and for EU companies importing and exporting goods and services with the UK.

Code controlled in the language table making it possible to define the language of a business partner.

This flag identifies the countries that belong to the SEPA area.

The SEPA area means Single Euro Payments Area.

This affiliation to the SEPA area is controlled in payment creation if they are based on payment modes known as "SEPA" (SEPA Credit Transfer or SEPA Direct Debit).

Numeric country code according to the ISO 3166 standard.

Code used by the Customs administration for the Intrastat declaration.

The root for the value added tax identification number for this country (TVA in France, IVA in Italy, VAT in UK, .....etc).
This field only concerns the countries who are part of the European Community identified by the indicator EC membership.
This field is initialised by the first 2 characters of the currency code.

When this check box is selected, it indicates that:

• the Company Registration number, the identification number and the EU tax number are mandatory on the company record,
• the EU tax number is mandatory on the BP record, except if the BP is a natural person.

Format of the identification number and applied to the Number field during the entry of the companies. Warning: The identification number cannot exceed 80 characters.

Format of the EU tax number used in BP and company entry. Warning: The VAT number should not exceed 20 characters.

Format of the national company identification number, specific to each country and applied to the Site Registration number field on entering BPs and sites. Warning: The Site Registration number cannot exceed 20 characters.

When checked, this box specifies that the Site Registration number is mandatory on the site record.
It also specifies that the Site Registration number and the EU tax number are mandatory on the BP's record if the BP is a corporation.

Corresponds to the titles of the three address lines.

Format used to enter the address.

This field is used to specify the length of the postal code on which the control will be based.
The value: "0" means that the control is carried out on the whole length.
This is a useful feature for some countries, like the United States, where postal codes can contain a suffix identifying a district or a building, for example, in dense urban areas.
Thus, if the postal code is entered using the following format: 5#[-]4#, and the control applies to the first 5 characters only, the town/city corresponding to the postal code made of the first 5 characters will be the one to be submitted when no record corresponding to the full code can be found.

This field is used to manage the community code and to verify the existence of the post code.

When checked, this box specifies that it is mandatory to enter the postal code and the town/city on the addresses of such entities as Company, Site and all the BP entities (BP, Prospect, Customer, Supplier, Carrier and Sales rep).

Format used to display the town/city.
The formats used in some countries cannot be complied with by the standard Sage X3 format application (in the United-States, the first letter of each word of a town/city can be an uppercase letter: for example, Los Angeles). It is then necessary to use a sub-program in the control program associated with the function, in order to apply the requested format.

For additional information, see the technical annex in the documentation on the Country record.

When this indicator is abled, the names of towns/cities entered by the users are automatically converted to uppercase characters, irrespective of the case specified in the previous field for the town/city format. It is abled at all times by default so as to keep the historical behavior of the application.

When the indicator is disabled, the format specified in the previous field is the one that is displayed.

 Irrespective of the entry format, it remains possible, when entering an address, to select towns/cities without taking the case and accented characters into consideration. The selection window contains a column dedicated to the search. In it the names of the towns/cities are stored in uppercase letters.

The format of the community code, appropriate to each country and applied to the field Community code during the entry of postal codes.

Warning : The city code should not exceed 10 characters.

This field is used to elaborate the sub-division of the phone number to find the country code.
It must be entered in the form d-f where "d" represents the character at the beginning of the country code on the formatted field and where "f" represents the character at the end of the country code on the formatted field.

For France, for example, if the phone number format is "[(33)]#[.]##[.]##[.]##[.]##", the formatted phone number will be (33)1.46.45.44.42 and the user will have to specify 2-3 to find 33 as a country code.

The DECOUPE(PAYS,TEL,INTER,REGION,NUTEL) (SUB-DIVISION(COUNTRY, TEL, INTER, REGION, TELNO.) sub-program From CONTNUM is used to find this information.

The general setup CTLTEL - Phone number control is used to completely deactivate the entry control of the phone number or even to carry out a control only during modification.

This field is used to elaborate the sub-division of the phone number to find the region code.
It must be entered as "d-f" where "d" is the first character and where "f" is the last character of of the region prefix in the formatted field.

For France, for example, if the phone number format is "[(33)]#[.]##[.]##[.]##[.]##", the formatted phone number will be (33)1.46.45.44.42 and the user will have to specify 5-5 to find 1 as a country code.

The DECOUPE(PAYS,TEL,INTER,REGION,NUTEL) (SUB-DIVISION(COUNTRY, TEL, INTER, REGION, TELNO.) sub-program From CONTNUM is used to find this information.

The general setup CTLTEL - Phone number control is used to completely deactivate the entry control of the phone number or even to carry out a control only during modification.

When defining a country, it must be attached to a continent. This link is used to define a hierarchy in the datamarts of the Business Intelligence Module.

This checkbox is used to define by country what is the geographical subdivision of the highest level. For instance the Region for France,the State for the United States...

Title to be displayed to express the highest geographical subdvision of a country. For instance: Region for France, State for the United States...

This represents the Report Format, used especially in the USA.

This checkbox is used to define for each country the geographical subdivision of the lowest level compared to the previous one. For instance: Department for France, District for the United States...

Title to be displayed to express the geographical subdivision belonging to a level lower than the previous one. For example, the Department for France, and County for the United-States...

This checkbox is used to specify for a country if one of the two above mentioned geographical sub-divisions must be taken into account in the definition of the postal address.
For instance, for the United States, if the first subdivision is theState, Subdivision1 will need to be specified here for it to be entered and saved in the addresses.

When abled, this indicator makes it possible to set up an existence control and submit a selection window when entering the subdivision in all those screens where an address needs to be entered.
This control will be carried out based on the subdivisions entered at geographical subdivisions setup level.