Interface: LOHN - Tariff definition Version 2015.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 :HierarchyTariffDefinition ( HierLohn )
Version :2015.00


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>HierarchyTariffDefinition</Id>
      <MapId>AbaDefault</MapId>
      <Version>2015.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>
      <TariffDefinition mode='SAVE'>
          <!-- The specific data fields for the AbaConnect interface are included here. -->
      </TariffDefinition>
    </Transaction>
  </Task>
</AbaConnectContainer>



Example AbaConnect Command Line

The following includes examples of AbaConnect Command Line. As of ABACUS V2010, the AbaConnect Command Line is executed with the abaconnectexportconsole.exe and abaconnectimportconsole.exe programmes, instead of abajvm.exe. More detailed information about AbaConnect Command Line is available on the ABACUS Homepage.

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

Import :
abaconnectimportconsole.exe "/USRuser" "/PWxxx"  "-aLOHN"  "-version2015.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
+ TariffDefinitionTariff definition---Yes
    - TariffNrTariff no.TariffDefinitionNumber4Yes
    - LanguageCode1Language code 1TariffDefinitionText5Yes
    - LanguageCode2Language code 2TariffDefinitionText5Yes
    - LanguageCode3Language code 3TariffDefinitionText5Yes
    - LanguageCode4Language code 4TariffDefinitionText5Yes
    - LanguageCode5Language code 5TariffDefinitionText5Yes
    - LanguageCode6Language code 6TariffDefinitionText5Yes
    - Text1Text 1TariffDefinitionText35Yes
    - Text2Text 2TariffDefinitionText35Yes
    - Text3Text 3TariffDefinitionText35Yes
    - Text4Text 4TariffDefinitionText35Yes
    - Text5Text 5TariffDefinitionText35Yes
    - Text6Text 6TariffDefinitionText35Yes
    - TableNrTable numberTariffDefinitionNumber4Yes
    - TableLocalUse client-dependant tablesTariffDefinitionBoolean-Yes
    - InvisibleCalcHide in tariff legendTariffDefinitionBoolean-Yes
    - VisibleBookItemBooking elements visibleTariffDefinitionBoolean-Yes
    - TariffActiveActive tariffTariffDefinitionBoolean-Yes
    + TariffColumnTariff columnTariffDefinition--No
        - TariffNrTariff no.TariffColumnNumber4Yes
        - ColumnNrColumn numberTariffColumnNumber2Yes
        - LanguageCode1Language code 1TariffColumnText5Yes
        - LanguageCode2Language code 2TariffColumnText5Yes
        - LanguageCode3Language code 3TariffColumnText5Yes
        - LanguageCode4Language code 4TariffColumnText5Yes
        - LanguageCode5Language code 5TariffColumnText5Yes
        - LanguageCode6Language code 6TariffColumnText5Yes
        - Text1Text 1TariffColumnText35Yes
        - Text2Text 2TariffColumnText35Yes
        - Text3Text 3TariffColumnText35Yes
        - Text4Text 4TariffColumnText35Yes
        - Text5Text 5TariffColumnText35Yes
        - Text6Text 6TariffColumnText35Yes
        - ColumnTypeTariff valueTariffColumnNumber2Yes
        - LengthTotal lengthTariffColumnNumber2Yes
        - PreDecimalPlacesPre-decimal placesTariffColumnNumber2Yes
        - DecimalPlacesDecimal placesTariffColumnNumber2Yes
        - DefaultValueNumNumber proposalTariffColumnNumber10Yes
        - DefaultValueStrText proposalTariffColumnText13Yes
        - UpperCaseUpper case lettersTariffColumnBoolean-Yes
        - ReadOnlyRead onlyTariffColumnBoolean-Yes
        - QuantityColumnTariff quantityTariffColumnBoolean-Yes
        - InvisibleCalcHide in tariff legendTariffColumnBoolean-Yes



Field Information

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

Tariff no.
XML Element Name:TariffNr
Parent Element:TariffDefinition
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 "TariffNr")
                    

Language code 1
XML Element Name:LanguageCode1
Parent Element:TariffDefinition
Field Type:Text
Action Type:Import und Export
Field Length:   5Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   15
Description:

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

Language code 2
XML Element Name:LanguageCode2
Parent Element:TariffDefinition
Field Type:Text
Action Type:Import und Export
Field Length:   5Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   16
Description:

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

Language code 3
XML Element Name:LanguageCode3
Parent Element:TariffDefinition
Field Type:Text
Action Type:Import und Export
Field Length:   5Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   17
Description:

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

Language code 4
XML Element Name:LanguageCode4
Parent Element:TariffDefinition
Field Type:Text
Action Type:Import und Export
Field Length:   5Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   18
Description:

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

Language code 5
XML Element Name:LanguageCode5
Parent Element:TariffDefinition
Field Type:Text
Action Type:Import und Export
Field Length:   5Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   19
Description:

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

Language code 6
XML Element Name:LanguageCode6
Parent Element:TariffDefinition
Field Type:Text
Action Type:Import und Export
Field Length:   5Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   20
Description:

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

Text 1
XML Element Name:Text1
Parent Element:TariffDefinition
Field Type:Text
Action Type:Import und Export
Field Length:   35Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   9
Description:

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

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

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

Text 3
XML Element Name:Text3
Parent Element:TariffDefinition
Field Type:Text
Action Type:Import und Export
Field Length:   35Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   11
Description:

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

Text 4
XML Element Name:Text4
Parent Element:TariffDefinition
Field Type:Text
Action Type:Import und Export
Field Length:   35Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   12
Description:

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

Text 5
XML Element Name:Text5
Parent Element:TariffDefinition
Field Type:Text
Action Type:Import und Export
Field Length:   35Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   13
Description:

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

Text 6
XML Element Name:Text6
Parent Element:TariffDefinition
Field Type:Text
Action Type:Import und Export
Field Length:   35Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   14
Description:

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

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

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

Use client-dependant tables
XML Element Name:TableLocal
Parent Element:TariffDefinition
Field Type:Boolean (true oder false)
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   3
Description:

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

Hide in tariff legend
XML Element Name:InvisibleCalc
Parent Element:TariffDefinition
Field Type:Boolean (true oder false)
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   4
Description:

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

Booking elements visible
XML Element Name:VisibleBookItem
Parent Element:TariffDefinition
Field Type:Boolean (true oder false)
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   5
Description:

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

Active tariff
XML Element Name:TariffActive
Parent Element:TariffDefinition
Field Type:Boolean (true oder false)
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   6
Description:

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

Tariff column
XML Element Name:TariffColumn
Parent Element:TariffDefinition
Field Type:ID
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   8
Description:

                

Tariff no.
XML Element Name:TariffNr
Parent Element:TariffColumn
Field Type:Nummer
Action Type:Import und Export
Field Length:   4Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   17
Description:

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

Column number
XML Element Name:ColumnNr
Parent Element:TariffColumn
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 "ColumnNr")
                    

Language code 1
XML Element Name:LanguageCode1
Parent Element:TariffColumn
Field Type:Text
Action Type:Import und Export
Field Length:   5Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   24
Description:

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

Language code 2
XML Element Name:LanguageCode2
Parent Element:TariffColumn
Field Type:Text
Action Type:Import und Export
Field Length:   5Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   25
Description:

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

Language code 3
XML Element Name:LanguageCode3
Parent Element:TariffColumn
Field Type:Text
Action Type:Import und Export
Field Length:   5Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   26
Description:

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

Language code 4
XML Element Name:LanguageCode4
Parent Element:TariffColumn
Field Type:Text
Action Type:Import und Export
Field Length:   5Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   27
Description:

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

Language code 5
XML Element Name:LanguageCode5
Parent Element:TariffColumn
Field Type:Text
Action Type:Import und Export
Field Length:   5Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   28
Description:

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

Language code 6
XML Element Name:LanguageCode6
Parent Element:TariffColumn
Field Type:Text
Action Type:Import und Export
Field Length:   5Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   29
Description:

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

Text 1
XML Element Name:Text1
Parent Element:TariffColumn
Field Type:Text
Action Type:Import und Export
Field Length:   35Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   18
Description:

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

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

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

Text 3
XML Element Name:Text3
Parent Element:TariffColumn
Field Type:Text
Action Type:Import und Export
Field Length:   35Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   20
Description:

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

Text 4
XML Element Name:Text4
Parent Element:TariffColumn
Field Type:Text
Action Type:Import und Export
Field Length:   35Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   21
Description:

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

Text 5
XML Element Name:Text5
Parent Element:TariffColumn
Field Type:Text
Action Type:Import und Export
Field Length:   35Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   22
Description:

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

Text 6
XML Element Name:Text6
Parent Element:TariffColumn
Field Type:Text
Action Type:Import und Export
Field Length:   35Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   23
Description:

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

Tariff value
XML Element Name:ColumnType
Parent Element:TariffColumn
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 "ColumnType")
                    

Total length
XML Element Name:Length
Parent Element:TariffColumn
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 "Length")
                    

Pre-decimal places
XML Element Name:PreDecimalPlaces
Parent Element:TariffColumn
Field Type:Nummer
Action Type:Import und Export
Field Length:   2Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   6
Description:

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

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

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

Number proposal
XML Element Name:DefaultValueNum
Parent Element:TariffColumn
Field Type:Nummer
Action Type:Import und Export
Field Length:   10Decimal Places:   4Mandatory Field:   YesRevision:   0Ascii ID :   7
Description:

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

Text proposal
XML Element Name:DefaultValueStr
Parent Element:TariffColumn
Field Type:Text
Action Type:Import und Export
Field Length:   13Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   8
Description:

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

Upper case letters
XML Element Name:UpperCase
Parent Element:TariffColumn
Field Type:Boolean (true oder false)
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   9
Description:

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

Read only
XML Element Name:ReadOnly
Parent Element:TariffColumn
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 "ReadOnly")
                    

Tariff quantity
XML Element Name:QuantityColumn
Parent Element:TariffColumn
Field Type:Boolean (true oder false)
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   11
Description:

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

Hide in tariff legend
XML Element Name:InvisibleCalc
Parent Element:TariffColumn
Field Type:Boolean (true oder false)
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   12
Description:

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