Interface: NORM - Regie tariff item Version 2017.00

This documentation describes the AbaConnect Interface Regie tariff item for the NORM Application.


General Information

General information about the AbaConnect interface.

AbaConnect Interface Information
Application :NORM
Interface Name :Regie tariff item
ID :BR ( BR )
Version :2017.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 :Regie tariff item
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>NORM</Application>
      <Id>BR</Id>
      <MapId>AbaDefault</MapId>
      <Version>2017.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>
      <BOD_REBEREICH mode='SAVE'>
          <!-- The specific data fields for the AbaConnect interface are included here. -->
      </BOD_REBEREICH>
    </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"  "-aNORM"  "-version2017.00"  "-M7777"  "-acidBR"  "-mapidAbaDefault"  "-datamodeXML"  "-responseYES"  "-responsefileX:\response.xml"  "-exportfileX:\data.xml"

Import :
abaconnectimportconsole.exe "/USRuser" "/PWxxx"  "-aNORM"  "-version2017.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
BOD_REBEREICHArea---No
    BOD_REBEREICHFieldsFieldsBOD_REBEREICH--No
        - NR1AreaBOD_REBEREICHFieldsNumber4No
        - NR2No. 2BOD_REBEREICHFieldsNumber6No
        - NR3No. 3BOD_REBEREICHFieldsNumber6No
        - REBEREICHTYPRegiebereich TypBOD_REBEREICHFieldsNumber2No
    BOD_REJAHRYearBOD_REBEREICH--No
        BOD_REJAHRFieldsFieldsBOD_REJAHR--No
            - NR2YearBOD_REJAHRFieldsNumber6No
            - NR3No. 3BOD_REJAHRFieldsNumber6No
        BOD_REREGIONRegionBOD_REJAHR--No
            BOD_REREGIONFieldsFieldsBOD_REREGION--No
                - NR3RegionBOD_REREGIONFieldsNumber6No
                - REREGION_KURZ_BEZEICHNUNGRegion BezeichnungBOD_REREGIONFieldsText9999999No
            BRHRegie item hierarchyBOD_REREGION--No
                BRHFieldsFieldsBRH--No
                    - KEKATCategoryBRHFieldsNumber2No
                    - TARIFPOSNRCHILDTariff item no. childBRHFieldsText12No
                    - POSTYPTypeBRHFieldsNumber2No
                    - FAKPRODNRAInvoice productBRHFieldsText30No
                    - KONDGRPCondition groupBRHFieldsText13No
                    - TARIFPOSNRPARENTTariff item no. parentBRHFieldsText12No
                RegieTariffItemTextRegie item textBRH--No
                    RegieTariffItemTextFieldsFieldsRegieTariffItemText--No
                        - LanguageCodeLanguageRegieTariffItemTextFieldsText6No
                        - SearchTitleSearch titleRegieTariffItemTextFieldsText30No
                        - DesignationDesignationRegieTariffItemTextFieldsText120No
                        - TARIFPOSTariff itemRegieTariffItemTextFieldsBoolean-No
                RegieTariffItemRegie tariff itemBRH--No
                    RegieTariffItemFieldsFieldsRegieTariffItem--No
                        - OwnItemOwn itemRegieTariffItemFieldsBoolean-No
                        - TaxCodeVATRegieTariffItemFieldsText3No
                        - UnitNumberQURegieTariffItemFieldsNumber2No
                        - MachineOperationCodeMachine operation codeRegieTariffItemFieldsText1No
                        - MWSTMODUSVAT modeRegieTariffItemFieldsNumber2No
                    RegieRateRegie rateRegieTariffItem--No
                        RegieRateFieldsFieldsRegieRate--No
                            - RateNumberRate no.RegieRateFieldsNumber2No
                            - EIGENEOwn rateRegieRateFieldsBoolean-No
                            - OriginalPriceOriginal priceRegieRateFieldsNumber6No
                            - OwnPriceOwn priceRegieRateFieldsNumber6No
                            - EHTNRORIGINALOriginal QURegieRateFieldsNumber2No
                            - EHTNRNEWOwn QURegieRateFieldsNumber2No
                            - PriceModificationAllowedModification of price allowedRegieRateFieldsBoolean-No
                            - PriceModificationDatePrice modification dateRegieRateFieldsDate/Time-No
                            - PriceModificationUserPrice modification user-NameRegieRateFieldsText9999999No
                        RegieRateTextRegie rate textRegieRate--No
                            RegieRateTextFieldsFieldsRegieRateText--No
                                - LanguageCodeLanguageRegieRateTextFieldsText6No
                                - ShortDesignationAbbreviationRegieRateTextFieldsText7No
                                - DesignationDesignationRegieRateTextFieldsText60No



Field Information

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

Fields
XML Element Name:BOD_REBEREICHFields
Parent Element:BOD_REBEREICH
Field Type:Type[ 15 ]
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                

Area
XML Element Name:NR1
Parent Element:BOD_REBEREICHFields
Field Type:Nummer
Action Type:Import und Export
Field Length:   4Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

No. 2
XML Element Name:NR2
Parent Element:BOD_REBEREICHFields
Field Type:Nummer
Action Type:Import und Export
Field Length:   6Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

No. 3
XML Element Name:NR3
Parent Element:BOD_REBEREICHFields
Field Type:Nummer
Action Type:Import und Export
Field Length:   6Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Regiebereich Typ
XML Element Name:REBEREICHTYP
Parent Element:BOD_REBEREICHFields
Field Type:Nummer
Action Type:Export only
Field Length:   2Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Year
XML Element Name:BOD_REJAHR
Parent Element:BOD_REBEREICH
Field Type:ID
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                

Fields
XML Element Name:BOD_REJAHRFields
Parent Element:BOD_REJAHR
Field Type:Type[ 15 ]
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                

Year
XML Element Name:NR2
Parent Element:BOD_REJAHRFields
Field Type:Nummer
Action Type:Import und Export
Field Length:   6Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

No. 3
XML Element Name:NR3
Parent Element:BOD_REJAHRFields
Field Type:Nummer
Action Type:Import und Export
Field Length:   6Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Region
XML Element Name:BOD_REREGION
Parent Element:BOD_REJAHR
Field Type:ID
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                

Fields
XML Element Name:BOD_REREGIONFields
Parent Element:BOD_REREGION
Field Type:Type[ 15 ]
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                

Region
XML Element Name:NR3
Parent Element:BOD_REREGIONFields
Field Type:Nummer
Action Type:Import und Export
Field Length:   6Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Region Bezeichnung
XML Element Name:REREGION_KURZ_BEZEICHNUNG
Parent Element:BOD_REREGIONFields
Field Type:Text
Action Type:Export only
Field Length:   9999999Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Regie item hierarchy
XML Element Name:BRH
Parent Element:BOD_REREGION
Field Type:ID
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                

Fields
XML Element Name:BRHFields
Parent Element:BRH
Field Type:Type[ 15 ]
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                

Category
XML Element Name:KEKAT
Parent Element:BRHFields
Field Type:Nummer
Action Type:Import und Export
Field Length:   2Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Tariff item no. child
XML Element Name:TARIFPOSNRCHILD
Parent Element:BRHFields
Field Type:Text
Action Type:Import und Export
Field Length:   12Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Type
XML Element Name:POSTYP
Parent Element:BRHFields
Field Type:Nummer
Action Type:Import und Export
Field Length:   2Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Invoice product
XML Element Name:FAKPRODNRA
Parent Element:BRHFields
Field Type:Text
Action Type:Export only
Field Length:   30Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Condition group
XML Element Name:KONDGRP
Parent Element:BRHFields
Field Type:Text
Action Type:Export only
Field Length:   13Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Tariff item no. parent
XML Element Name:TARIFPOSNRPARENT
Parent Element:BRHFields
Field Type:Text
Action Type:Import und Export
Field Length:   12Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Regie item text
XML Element Name:RegieTariffItemText
Parent Element:BRH
Field Type:ID
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Master data

Fields
XML Element Name:RegieTariffItemTextFields
Parent Element:RegieTariffItemText
Field Type:Type[ 15 ]
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                

Language
XML Element Name:LanguageCode
Parent Element:RegieTariffItemTextFields
Field Type:Text
Action Type:Import und Export
Field Length:   6Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Search title
XML Element Name:SearchTitle
Parent Element:RegieTariffItemTextFields
Field Type:Text
Action Type:Export only
Field Length:   30Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Designation
XML Element Name:Designation
Parent Element:RegieTariffItemTextFields
Field Type:Text
Action Type:Import und Export
Field Length:   120Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Tariff item
XML Element Name:TARIFPOS
Parent Element:RegieTariffItemTextFields
Field Type:Boolean (true oder false)
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Regie tariff item
XML Element Name:RegieTariffItem
Parent Element:BRH
Field Type:ID
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Master data

Fields
XML Element Name:RegieTariffItemFields
Parent Element:RegieTariffItem
Field Type:Type[ 15 ]
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                

Own item
XML Element Name:OwnItem
Parent Element:RegieTariffItemFields
Field Type:Boolean (true oder false)
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

VAT
XML Element Name:TaxCode
Parent Element:RegieTariffItemFields
Field Type:Text
Action Type:Import und Export
Field Length:   3Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

QU
XML Element Name:UnitNumber
Parent Element:RegieTariffItemFields
Field Type:Nummer
Action Type:Import und Export
Field Length:   2Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Quantity unit
(The internal field ID for this element is "EHTNR")

Machine operation code
XML Element Name:MachineOperationCode
Parent Element:RegieTariffItemFields
Field Type:Text
Action Type:Import und Export
Field Length:   1Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

VAT mode
XML Element Name:MWSTMODUS
Parent Element:RegieTariffItemFields
Field Type:Nummer
Action Type:Import und Export
Field Length:   2Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Regie rate
XML Element Name:RegieRate
Parent Element:RegieTariffItem
Field Type:ID
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Master data

Fields
XML Element Name:RegieRateFields
Parent Element:RegieRate
Field Type:Type[ 15 ]
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                

Rate no.
XML Element Name:RateNumber
Parent Element:RegieRateFields
Field Type:Nummer
Action Type:Import und Export
Field Length:   2Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Own rate
XML Element Name:EIGENE
Parent Element:RegieRateFields
Field Type:Boolean (true oder false)
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Original price
XML Element Name:OriginalPrice
Parent Element:RegieRateFields
Field Type:Nummer
Action Type:Import und Export
Field Length:   6Decimal Places:   4Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Own price
XML Element Name:OwnPrice
Parent Element:RegieRateFields
Field Type:Nummer
Action Type:Import und Export
Field Length:   6Decimal Places:   4Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Original QU
XML Element Name:EHTNRORIGINAL
Parent Element:RegieRateFields
Field Type:Nummer
Action Type:Import und Export
Field Length:   2Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Original unit of quantity
(The internal field ID for this element is "EHTNRORIGINAL")

Own QU
XML Element Name:EHTNRNEW
Parent Element:RegieRateFields
Field Type:Nummer
Action Type:Import und Export
Field Length:   2Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Own unit of quantity
(The internal field ID for this element is "EHTNRNEW")

Modification of price allowed
XML Element Name:PriceModificationAllowed
Parent Element:RegieRateFields
Field Type:Boolean (true oder false)
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Price modification date
XML Element Name:PriceModificationDate
Parent Element:RegieRateFields
Field Type:Datum/Zeit (2006-08-08T10:16:54.509+02:00)
Action Type:Export only
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Price modification user-Name
XML Element Name:PriceModificationUser
Parent Element:RegieRateFields
Field Type:Text
Action Type:Export only
Field Length:   9999999Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Regie rate text
XML Element Name:RegieRateText
Parent Element:RegieRate
Field Type:ID
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Master data

Fields
XML Element Name:RegieRateTextFields
Parent Element:RegieRateText
Field Type:Type[ 15 ]
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                

Language
XML Element Name:LanguageCode
Parent Element:RegieRateTextFields
Field Type:Text
Action Type:Import und Export
Field Length:   6Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Abbreviation
XML Element Name:ShortDesignation
Parent Element:RegieRateTextFields
Field Type:Text
Action Type:Import und Export
Field Length:   7Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Designation
XML Element Name:Designation
Parent Element:RegieRateTextFields
Field Type:Text
Action Type:Import und Export
Field Length:   60Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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