Conversion Table Lines Sub-Tab

This section includes the fields and descriptions for the Conversion Table Lines sub-tab.

Field Description
External Registration No. In this field, you can enter an external registration number, for example, an ID of a department at the external source. When the conversion table is used in connection with an import, entries which have an external registration and account number corresponding to the combination on the current conversion table line will be converted. The conversion means that the entries created in Maconomy will be posted with the allocation combination entered in the dimension fields on the current line.
External Account No. In this field you enter an external account number. When the conversion table is used in connection with an import, entries which have an external registration and account number corresponding to the combination on the current conversion table line will be converted. The conversion means that the entries which are created in Maconomy will be posted with the allocation combination entered in the dimension fields on the current line.
Company No. In this field you enter a value for the dimension Company. The company number will be inserted in all imported data. For each entry created, Maconomy will determine which company number will be used. The selection is carried out in accordance with the following order of priority:
  1. If a conversion table has been assigned to the data agent, Maconomy will check whether the combination of the external registration number and the external account number exists in the conversion table for the data agent from which the import is carried out. If this is the case, Maconomy will check whether a company number is entered on the conversion table line, and, if so, that number will be used.
  2. If there is no company number on the conversion table line that fulfills the imported combination of the external registration number and the external account number, or if the combination does not exist in the conversion table, Maconomy will check whether a company number has been specified on the import line. If this is the case, that number will be used.
  3. If no company number has been entered for the imported line, the company number that has been assigned to the data agent in the window Data Agents in this field will be used.
  4. If no company number is entered for the current data agent, Maconomy will try to derive a value in accordance with the order of priority defined in the Dimension Derivations workspace. If there is no value to derive, the standard value from the System Parameters workspace in the Set-Up module will be used.
Account No. The functionality of this field is similar to that of the field “Company No.”
Location The functionality of this field is similar to that of the field “Company No.”
Entity The functionality of this field is similar to that of the field “Company No.”
Project The functionality of this field is similar to that of the field “Company No.”
Purpose The functionality of this field is similar to that of the field “Company No.”
Spec. 1-3 The functionality of these fields is similar to that of the field “Company No.”
Local Spec. 1-3 The functionality of these fields is similar to that of the field “Company No.”