Companies

• Company (field CPY)

Code of the company on which the processing is done.

• field CPYNAM

• Short description (field CPYSHO)

• Legal company (field CPYLEGFLG)

• Legislation (field LEG)

Defined by the miscellaneous table 909, this code, attached to the company, is used to define the rules, notably accounting and the parameters. In particular, the general parameters can be defined at the level of the legislation.

• Legal form (field CPYLOG)

Used to define the legal form under which the enterprise is established.

• Registered capital (field RGCCUR)

• field RGCAMT

• Main site (field MAIFCY)

For a given company, it is necessary to have available a site proposed by default in a certain number of operations.

This code is used to identify the site concerned. It is unique for each site.

• Country (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.

• Company tax ID no. (field CRN)

Use this field to define the company tax registration number. This is an official identification number allocated by a government organization to identify a company. It is a unique code generally used to help with the administration of tax laws. The format of this number depends on the rules for the country.

This number might be known as a Tax Identification Number (TIN), SIREN (France), NIF (Spain), Company tax ID Number (USA). Generally, a business has a company registration number. 

• SIC code (field NAF)

This is the Standard Industrial Classification (SIC) code, which characterizes the principle activity of the business partner and can be used for selection, sorting, reporting, etc.

The entry format of the activity code depends on the Country.

• Unique identification number (field NID)

Unique number identifying the companies. Its format depends on the country.

In France, it presents as follows :

• For traders and companies, RCS VILLE X SIREN, where VILLE is the name of the town/city where the company is registered, Xtakes A for traders and B for the companies and SIREN is the SIREN number.
• For people registered with the chamber of work and craft, SIREN RM NNN, where SIREN is the SIREN number, and NNN a group of describing the chamber of work and craft.
• For the professions, it is the SIREN number.

• EU VAT no. (field EECNUM)

This is the European tax number, which must be assigned to all invoices within the European Community.

This number starts with two letters identifying the business partner's country and is followed by a variable number depending on the country.

It may be skipped or used for other purposes if the business partner is not associated with the EEC.

• Self-certification of origin (field ORICERFLG)

• REX number (field REXNUM)

• Division code (field DIVCOD)

Not used.

• Accounting currency (field ACCCUR)

This is the company currency code used for accounting. The accounting movements are registered, when not in this currency, in the transaction currency and the reporting currency.

• Cy's pr. activity (field KACT)

• EORI number (field EORINUM)

• field LOGO

This image represents the logo of the enterprise. It is useable in the reports.

• Address (field CODADR)

This code is used to identify the various addresses associated with the managed record (user, company, site, business partner of any description, etc.).

Each address code is unique to a given record.

In general, it is mandatory to enter an address for each record, and one of them must be declared as the default address using the corresponding box.

An address code cannot be modified or deleted once it is used at the level of a Bank ID number or for a contact. In this case, to be able to modify or delete an address code, it is first necessary to remove it from the level of the Bank ID number or contact.

• Code (field XCODADR)

This code is used to identify the various addresses associated with the managed record (user, company, site, business partner of any description, etc.).

Each address code is unique to a given record.

In general, it is mandatory to enter an address for each record, and one of them must be declared as the default address using the corresponding box.

An address code cannot be modified or deleted once it is used at the level of a Bank ID number or for a contact. In this case, to be able to modify or delete an address code, it is first necessary to remove it from the level of the Bank ID number or contact.

• Description (field XBPADES)

Name linked to the address.

• Country (field XBPACRY)

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

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

• Description (field XCRYNAM)

Title associated to the previous code.

• Type (field XADDTYPSA)

• Service type (field XADDSRVTYP)

• Unit/postal number (field XADDPOSNBR)

• Complex (field XADDCPXSA)

• field XADDLIG1

This table lists the various address lines. The formats of the title and of the entry are defined in the country table.

• field XADDLIG2

• field XADDLIG3

• Suburb/District (field XADDSUBSA)

• Postal code (field XPOSCOD)

The postal code, having an entry format defined in the Country table, makes it possible to specify the town/city and the geographical subdivision if they are defined for the country.
When the postal code is modified, the town/city corresponding to this new code is displayed automatically. The principle is the same for the geographical subdivision if it is present for the country.
It is also possible to manually enter the town/city name. If the town/city is already defined, the associated postal code is automatically displayed.

Specific cases:

- For ANDORRA, enter 99130
- For MONACO, enter 99138
- for the other foreign countries, mention the national ID code of this country or 99999 if it is unknown.

The control of this information and its mandatory nature depend on the setup performed in the country management. In order for the control to be applied, the POSCOD - Nonexistent postal code alert parameter (SUP chapter, INT group) must also be set to "Yes".

• City (field XCTY)

The city automatically proposed is the one associated with the postal code previously indicated. It is also possible to manually enter the name of a town/city:
- If the latter is defined, the associated postal code is automatically displayed,
- if the town/city does not exist and the postal code control has been set up at Country record level, a warning message appears without however preventing the entry to be continued. In addition, the CTY - Nonexistent city alert parameter (chapter SUP, group INT) needs to be set to "Yes" for this control to apply.

Notes:

• Its format is defined in the Country record setup.
• Depending on this setup, the entered town/city can automatically be converted into uppercase after it has been entered.
• In order to make selections easier without taking into account the format (accented characters/uppercase letters/lowercase letters), the selection window available on this field proposes a column dedicated to the search, where the names of the towns/cities are displayed in uppercase. The control which is carried out is case-insensitive since it is carried out with respect to the town/city name stored in uppercase.

• field XSAT

This field includes the geographical subdivision which is part of the postal address definition.
For instance, it can be the department for France or the state for the United States. The subdivision title and the potential control on its entry are defined in the Country setup.
If it is controlled, this code depends on the corresponding geographical subdivision.

This subdivision is automatically fed after the postal code and town/city have been entered, based on the Postal codes setup.

• Federal ID code (field XCODSEE)

• Website (field XFCYWEB)

This field is used to indicate a web site.

• Default address (field XBPAADDFLG)

When selected, this check box indicates that this is the default address.
Only one of the addresses in the selected record can (and must) be selected. This always corresponds to one of the BP's addresses.

• field XTEL1

Telephone number with en entry format dependent on the country. The general setup CTLTEL - Control telephone number is used to specify the level of control carried out according to the format of the number entered.

• field XTEL2

• field XTEL3

• field XTEL4

• field XTEL5

• field XWEB1

This field is used to specify the email address of the contact.

• field XWEB2

• field XWEB3

• field XWEB4

• field XWEB5

• Address (field CODADR)

This code is used to identify the various addresses associated with the managed record (user, company, site, business partner of any description, etc.).

Each address code is unique to a given record.

In general, it is mandatory to enter an address for each record, and one of them must be declared as the default address using the corresponding box.

An address code cannot be modified or deleted once it is used at the level of a Bank ID number or for a contact. In this case, to be able to modify or delete an address code, it is first necessary to remove it from the level of the Bank ID number or contact.

• Code (field XCODADR)

This code is used to identify the various addresses associated with the managed record (user, company, site, business partner of any description, etc.).

Each address code is unique to a given record.

In general, it is mandatory to enter an address for each record, and one of them must be declared as the default address using the corresponding box.

An address code cannot be modified or deleted once it is used at the level of a Bank ID number or for a contact. In this case, to be able to modify or delete an address code, it is first necessary to remove it from the level of the Bank ID number or contact.

• Description (field XBPADES)

Name linked to the address.

• Country (field XBPACRY)

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

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

• Description (field XCRYNAM)

Title associated to the previous code.

• Type (field XADDTYPSA)

• Service type (field XADDSRVTYP)

• Unit/postal number (field XADDPOSNBR)

• Complex (field XADDCPXSA)

• field XADDLIG1

This table lists the various address lines. The formats of the title and of the entry are defined in the country table.

• field XADDLIG2

• field XADDLIG3

• Suburb/District (field XADDSUBSA)

• Postal code (field XPOSCOD)

The postal code, having an entry format defined in the Country table, makes it possible to specify the town/city and the geographical subdivision if they are defined for the country.
When the postal code is modified, the town/city corresponding to this new code is displayed automatically. The principle is the same for the geographical subdivision if it is present for the country.
It is also possible to manually enter the town/city name. If the town/city is already defined, the associated postal code is automatically displayed.

Specific cases:

- For ANDORRA, enter 99130
- For MONACO, enter 99138
- for the other foreign countries, mention the national ID code of this country or 99999 if it is unknown.

The control of this information and its mandatory nature depend on the setup performed in the country management. In order for the control to be applied, the POSCOD - Nonexistent postal code alert parameter (SUP chapter, INT group) must also be set to "Yes".

• City (field XCTY)

The city automatically proposed is the one associated with the postal code previously indicated. It is also possible to manually enter the name of a town/city:
- If the latter is defined, the associated postal code is automatically displayed,
- if the town/city does not exist and the postal code control has been set up at Country record level, a warning message appears without however preventing the entry to be continued. In addition, the CTY - Nonexistent city alert parameter (chapter SUP, group INT) needs to be set to "Yes" for this control to apply.

Notes:

• Its format is defined in the Country record setup.
• Depending on this setup, the entered town/city can automatically be converted into uppercase after it has been entered.
• In order to make selections easier without taking into account the format (accented characters/uppercase letters/lowercase letters), the selection window available on this field proposes a column dedicated to the search, where the names of the towns/cities are displayed in uppercase. The control which is carried out is case-insensitive since it is carried out with respect to the town/city name stored in uppercase.

• field XSAT

This field includes the geographical subdivision which is part of the postal address definition.
For instance, it can be the department for France or the state for the United States. The subdivision title and the potential control on its entry are defined in the Country setup.
If it is controlled, this code depends on the corresponding geographical subdivision.

This subdivision is automatically fed after the postal code and town/city have been entered, based on the Postal codes setup.

• Federal ID code (field XCODSEE)

• Website (field XFCYWEB)

This field is used to indicate a web site.

• Default address (field XBPAADDFLG)

When selected, this check box indicates that this is the default address.
Only one of the addresses in the selected record can (and must) be selected. This always corresponds to one of the BP's addresses.

• field XTEL1

Telephone number with en entry format dependent on the country. The general setup CTLTEL - Control telephone number is used to specify the level of control carried out according to the format of the number entered.

• field XTEL2

• field XTEL3

• field XTEL4

• field XTEL5

• field XWEB1

This field is used to specify the email address of the contact.

• field XWEB2

• field XWEB3

• field XWEB4

• field XWEB5