Country

• Countries (field CRY)

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 that identifies a company or an activity (site tax ID number, NAF in France), and whether its entry is mandatory or not,
• the format of the postal code/town/city and the geographical subdivision, and whether its entry is mandatory or not,
• the mandatory or not mandatory aspect of the Site Registration number entry, of the identification number of the company as well as the EU tax no.,
• the format of the Bank ID number code.

• field CRYDES

Enter the description of the relevant record.

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

• Currency (field CUR)

Code making it possible to identify the currency for a site, a Business Partner, or to define a default value. This code is controlled in the currency table. It is advisable to use the ISO coding during the creation of a new currency.

• EU member (field EECFLG)

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

• EU entry date (field EECDAT)

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

• EU withdrawal date (field EECDATOUT)

• Generalized system of preferences (field GSPFLG)

• EORI identification (field EORIFLG)

• Primary language (field LAN)

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

• SEPA area (field FLGSEPA)

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

• Control script (field CTLPRG)

• Involved in DUE (field FLGDUE)

• ISO-3166-1 alpha-2 (field ISO)

This represents the country code according to the ISO standard 7372.

• ISO-3166-1 alpha-3 (field ISOA3)

• ISO-3166-1 numeric (field ISONUM)

Numeric country code according to the ISO 3166 standard.

• Federal ID code (field CINSEE)

• Intrastat country code (field EECCOD)

• VAT radical (field CRYVATNUM)

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.

• field CRNFMTFLG

• Company tax ID no. (field CRNFMT)

• Company tax ID mandatory (field CRNOBL)

When checked, this box specifies that the Company Registration number, the identification number and the EU tax number are mandatory on the company record.

• field NIDFMTFLG

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.

• Unique number (field NIDFMT)

• field EECFMTFLG

Format of the EU tax number used during the BPs and companies entry. Warning: The tax number should not exceed 20 characters.

• VAT format (field EECFMT)

• field NAFFMTFLG

• SIC (field NAFFMT)

• field CRTFMTFLG

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.

• Site tax ID number (field CRTFMT)

• Site tax ID no. mandator (field CRTOBL)

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.

• field SOCNUMFLG1

• Social Securité number 1 (field SOCNUMFMT)

• field SOCNUMFLG2

• Social Securité number 2 (field SOCNUMFMT2)

• Titles (field ADRNAM)

Corresponds to the titles of the three address lines.

• Address format (field ADRCODFMT)

Format used to enter the address.

• Postal code (field POSCODFMT)

• Controlled length (field MINZIP)

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.

• Postal code control (field POSCODCTL)

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

• Mandatory postal code (field POSOBL)

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

• City format (field CTYCODFMT)

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.

• Upper-case letters (field CTYUPP)

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.

• INSEE code format (field CTYNUMFMT)

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.

• Telephone (field TELFMT)

• Country code control (field TELTCY)

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.

• Region country control (field TELREG)

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.

• Continent (field CONTINENT)

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.

• Subdivision entry (field ETAT)

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.

• Subdivision control (field ETATCTL)

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.

• Subdivision 1 (field ETATFLG)

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

• Description (field ETATNAM)

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

• Format (field ETATFMT)

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

• Subdivision 2 (field ETATFLG2)

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

• Description (field ETATNAM2)

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

• Format (field ETATFMT2)

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

• Bank ID number (field BIDFMT)

• Paying bank (field PABFMT)

• Bank control (field BIDCTL)

• Length of bank (field BANLNG)

• IBAN management (field FLIBAN)

• Local BID window (field BIDCLS)