Interface: LOHN - Tariff definition Version 2023.00

This documentation describes the AbaConnect Interface Tariff definition for the LOHN Application.


General Information

General information about the AbaConnect interface.

AbaConnect Interface Information
Application :LOHN
Interface Name :Tariff definition
ID :HierarchyStandardRateDefinition ( TablesAndTariffs )
Version :2023.00
Status:Productive


Displays the possible import and export features for this interface.

Export / Import Modus
Export :XML
Import :XML


Displays additional information for this interface.

Additional Information

                                  Highest field Revision for this interface : 0



Mapping Information

The following displays the Mapping details for this interface.

Mapping Information
Mapping ID :AbaDefault
Mapping Name :Tariff definition
Description :

                



Example AbaConnect XML Structure

The following is an example of an XML Header structure. This information is also visible in an AbaConnect XML Export file, that has been exported via the Abacus AbaConnect User Interface.

AbaConnect XML Struktur
<?xml version='1.0' encoding='UTF-8'?>
<AbaConnectContainer>
  <TaskCount>1</TaskCount>
  <Task>
    <Parameter>
      <Application>LOHN</Application>
      <Id>HierarchyStandardRateDefinition</Id>
      <MapId>AbaDefault</MapId>
      <Version>2023.00</Version>
      <!-- Attention : The client number (Mandant) is optional and implies that the data can only be imported into specified client (Mandant) -->
      <!-- The Client Option (Mandant) only has an influence when importing data. It can be configured in the AbaConnect Export Settings. -->
      <!-- By default, the client number (Mandant) is not written to the export file -->
      <Mandant>7777</Mandant>
    </Parameter>
    <Transaction>
      <StandardRate mode='SAVE'>
          <!-- The specific data fields for the AbaConnect interface are included here. -->
      </StandardRate>
    </Transaction>
  </Task>
</AbaConnectContainer>



Example AbaConnect Command Line

The following includes examples of AbaConnect Command Line. The AbaConnect Command Line is executed with the abaconnectexportconsole.exe and abaconnectimportconsole.exe programmes. The AbaConnect Command Line must be run direct on the Abacus server. More detailed information about AbaConnect Command Line is available on the Abacus Homepage. The following examples serve as starting point for creating a simple command line.

AbaConnect Command Line
Export :
abaconnectexportconsole.exe "/USRuser" "/PWxxx"  "-aLOHN"  "-version2023.00"  "-M7777"  "-acidHierarchyStandardRateDefinition"  "-mapidAbaDefault"  "-datamodeXML"  "-responseYES"  "-responsefileX:\response.xml"  "-exportfileX:\data.xml"

Import :
abaconnectimportconsole.exe "/USRuser" "/PWxxx"  "-aLOHN"  "-version2023.00"  "-M7777"  "-datamodeXML"  "-responseYES"  "-responsefileX:\response.xml"  "-importfileX:\data.xml"

N.B. : For importing XML data, it is not necessary to specify the Interface ID and Mapping on the Command Line. This information is contained in the XML Import file.



Mapping Structure

The following displays a simplified mapping structure for this interface.
The XML-Element and Parent-Name are always in english. Click on the row to display additional information.

XML Element Name Field Name Parent Name Type Length Mandatory
StandardRateTariff---Yes
    - RateNumberTariff numberStandardRateNumber4Yes
    - TableNumberTable numberStandardRateNumber4No
    - ClientTableClient-specific tableStandardRateBoolean-No
    - ActiveActiveStandardRateBoolean-No
    - ActiveForCompensationActive for compensation roundStandardRateBoolean-Yes
    - ShownInCalculationShow payroll settlement in the legendStandardRateBoolean-No
    DescriptionDesignationStandardRate--No
        - LanguageLanguageDescriptionText2Yes
        - TextTextDescriptionText100Yes
    FieldFieldStandardRate--No
        - FieldNumberField numberFieldNumber2Yes
        - ValueTypeTariff valueFieldNumber2Yes
        - LengthText length/number of digits before the decimal pointFieldNumber2Yes
        - DecimalPlacesDecimal placesFieldNumber2Yes
        - NumericalDefaultValueDefault value (numerical)FieldNumber10No
        - TextualDefaultValueDefault value (textual)FieldText13No
        - UppercaseShow in capital lettersFieldBoolean-No
        - ReadOnlyRead onlyFieldBoolean-No
        - EnabledForRateCalculationUse for number of tariff calculationFieldBoolean-No
        - ActivityRateFieldLevel of employmentFieldBoolean-No
        - ShownInCalculationShow payroll settlement in the legendFieldBoolean-No
        - ShownInSalaryProcessingShow in payroll processingFieldBoolean-No
        DescriptionDesignationField--No
            - LanguageLanguageDescriptionText2Yes
            - TextTextDescriptionText100Yes
    - BookingItemDivisionBusiness area update elementStandardRateNumber1No
    - BookingItemGLAccountBooking element G/L accountStandardRateNumber1No
    - BookingItemCostCenter1Update element cost centre 1. LevelStandardRateNumber1No
    - BookingItemCostCenter2Update element cost centre 2. LevelStandardRateNumber1No



Field Information

The following is a detailed description of the fields used in this interface.

Tariff number
XML Element Name:RateNumber
Parent Element:StandardRate
Field Type:Nummer
Action Type:Import und Export
Field Length:   4Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   1
Description:

                                  (The internal field ID for this element is "rateNumber")
                    

Table number
XML Element Name:TableNumber
Parent Element:StandardRate
Field Type:Nummer
Action Type:Import und Export
Field Length:   4Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   2
Description:

                                  (The internal field ID for this element is "tableNumber")
                    

Client-specific table
XML Element Name:ClientTable
Parent Element:StandardRate
Field Type:Boolean (true oder false)
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   3
Description:

                                  (The internal field ID for this element is "localTable")
                    

Active
XML Element Name:Active
Parent Element:StandardRate
Field Type:Boolean (true oder false)
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   4
Description:

                                  (The internal field ID for this element is "active")
                    

Active for compensation round
XML Element Name:ActiveForCompensation
Parent Element:StandardRate
Field Type:Boolean (true oder false)
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   10
Description:

                                  (The internal field ID for this element is "activeForCompensation")
                    

Show payroll settlement in the legend
XML Element Name:ShownInCalculation
Parent Element:StandardRate
Field Type:Boolean (true oder false)
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   6
Description:

                                  (The internal field ID for this element is "shownInCalculation")
                    

Language
XML Element Name:Language
Parent Element:Description
Field Type:Text
Action Type:Import und Export
Field Length:   2Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   1
Description:

                                  (The internal field ID for this element is "language")
                    

Text
XML Element Name:Text
Parent Element:Description
Field Type:Text
Action Type:Import und Export
Field Length:   100Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   2
Description:

                                  (The internal field ID for this element is "text")
                    

Designation
XML Element Name:Description
Parent Element:StandardRate
Field Type:Array List
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   8
Description:

                                  (The internal field ID for this element is "descriptions")
                    

Field number
XML Element Name:FieldNumber
Parent Element:Field
Field Type:Nummer
Action Type:Import und Export
Field Length:   2Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   1
Description:

                                  (The internal field ID for this element is "fieldNumber")
                    

Tariff value
XML Element Name:ValueType
Parent Element:Field
Field Type:Nummer
Action Type:Import und Export
Field Length:   2Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   2
Description:

                                  (The internal field ID for this element is "valueType")
                    

Text length/number of digits before the decimal point
XML Element Name:Length
Parent Element:Field
Field Type:Nummer
Action Type:Import und Export
Field Length:   2Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   3
Description:

                                  (The internal field ID for this element is "length")
                    

Decimal places
XML Element Name:DecimalPlaces
Parent Element:Field
Field Type:Nummer
Action Type:Import und Export
Field Length:   2Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   4
Description:

                                  (The internal field ID for this element is "decimalPlaces")
                    

Default value (numerical)
XML Element Name:NumericalDefaultValue
Parent Element:Field
Field Type:Nummer
Action Type:Import und Export
Field Length:   10Decimal Places:   4Mandatory Field:   NoRevision:   0Ascii ID :   5
Description:

                                  (The internal field ID for this element is "numericalDefaultValue")
                    
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.

Default value (textual)
XML Element Name:TextualDefaultValue
Parent Element:Field
Field Type:Text
Action Type:Import und Export
Field Length:   13Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   6
Description:

                                  (The internal field ID for this element is "textualDefaultValue")
                    

Show in capital letters
XML Element Name:Uppercase
Parent Element:Field
Field Type:Boolean (true oder false)
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   7
Description:

                                  (The internal field ID for this element is "uppercase")
                    

Read only
XML Element Name:ReadOnly
Parent Element:Field
Field Type:Boolean (true oder false)
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   8
Description:

                                  (The internal field ID for this element is "readOnly")
                    

Use for number of tariff calculation
XML Element Name:EnabledForRateCalculation
Parent Element:Field
Field Type:Boolean (true oder false)
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   9
Description:

                                  (The internal field ID for this element is "enabledForRateCalculation")
                    

Level of employment
XML Element Name:ActivityRateField
Parent Element:Field
Field Type:Boolean (true oder false)
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   13
Description:

                                  (The internal field ID for this element is "activityRateField")
                    

Show payroll settlement in the legend
XML Element Name:ShownInCalculation
Parent Element:Field
Field Type:Boolean (true oder false)
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   10
Description:

                                  (The internal field ID for this element is "shownInCalculation")
                    

Show in payroll processing
XML Element Name:ShownInSalaryProcessing
Parent Element:Field
Field Type:Boolean (true oder false)
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   12
Description:

                                  (The internal field ID for this element is "shownInSalaryProcessing")
                    

Field
XML Element Name:Field
Parent Element:StandardRate
Field Type:Array List
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   7
Description:

                                  (The internal field ID for this element is "fields")
                    

Designation
XML Element Name:Description
Parent Element:Field
Field Type:Array List
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   11
Description:

                                  (The internal field ID for this element is "descriptions")
                    

Business area update element
XML Element Name:BookingItemDivision
Parent Element:StandardRate
Field Type:Nummer
Action Type:Import und Export
Field Length:   1Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   11
Description:

                                  (The internal field ID for this element is "bookingItemDivision")
                    

Booking element G/L account
XML Element Name:BookingItemGLAccount
Parent Element:StandardRate
Field Type:Nummer
Action Type:Import und Export
Field Length:   1Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   12
Description:

                                  (The internal field ID for this element is "bookingItemGLAccount")
                    

Update element cost centre 1. Level
XML Element Name:BookingItemCostCenter1
Parent Element:StandardRate
Field Type:Nummer
Action Type:Import und Export
Field Length:   1Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   13
Description:

                                  (The internal field ID for this element is "bookingItemCostCenter1")
                    

Update element cost centre 2. Level
XML Element Name:BookingItemCostCenter2
Parent Element:StandardRate
Field Type:Nummer
Action Type:Import und Export
Field Length:   1Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   14
Description:

                                  (The internal field ID for this element is "bookingItemCostCenter2")