Interface: NORM - Regie tariff item Version 2011.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 :2011.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
Master data
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>2011.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>
      <RegieTariffItem mode='SAVE'>
          <!-- The specific data fields for the AbaConnect interface are included here. -->
      </RegieTariffItem>
    </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"  "-version2011.00"  "-M7777"  "-acidBR"  "-mapidAbaDefault"  "-datamodeXML"  "-responseYES"  "-responsefileX:\response.xml"  "-exportfileX:\data.xml"

Import :
abaconnectimportconsole.exe "/USRuser" "/PWxxx"  "-aNORM"  "-version2011.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
RegieTariffItemRegie tariff item---No
    RegieTariffItemFieldsFieldsRegieTariffItem--No
        - AreaAreaRegieTariffItemFieldsNumber4No
        - RegieRegionRegionRegieTariffItemFieldsNumber4No
        - YearYearRegieTariffItemFieldsNumber4No
        - CategoryCategoryRegieTariffItemFieldsNumber2No
        - ItemNumberTariff item no.RegieTariffItemFieldsText12No
        - UnitNumberQURegieTariffItemFieldsNumber2No
        - MachineOperationCodeMachine operation codeRegieTariffItemFieldsText1No
        - OwnItemOwn itemRegieTariffItemFieldsBoolean-No
        - TaxCodeVATRegieTariffItemFieldsText3No
        - DesignationDesignationRegieTariffItemFieldsText255No
        - RegionRegionRegieTariffItemFieldsText255No
        - Rate1Rate 1RegieTariffItemFieldsNumber6No
        - Rate2Rate 2RegieTariffItemFieldsNumber6No
        - Rate3Rate 3RegieTariffItemFieldsNumber6No
        - Rate4Rate 4RegieTariffItemFieldsNumber6No
        - Rate5Rate 5RegieTariffItemFieldsNumber6No
        - Rate6Rate 6RegieTariffItemFieldsNumber6No
    RegieRateRegie rateRegieTariffItem--No
        RegieRateFieldsFieldsRegieRate--No
            - RateNumberRate no.RegieRateFieldsNumber2No
            - OriginalPriceOriginal priceRegieRateFieldsNumber6No
            - OwnPriceOwn priceRegieRateFieldsNumber6No
            - PriceModificationAllowedModification of price allowedRegieRateFieldsBoolean-No
            - PriceModificationDateDatum PreismutationRegieRateFieldsDate/Time-No
            - TariffItemNumberTariff item no.RegieRateFieldsText12No
            - PriceModificationUserPrice modification userRegieRateFieldsText255No
            - ShortDesignationAbbreviationRegieRateFieldsText255No
            - DesignationDesignationRegieRateFieldsText255No
        RegieRateTextRegie rate textRegieRate--No
            RegieRateTextFieldsFieldsRegieRateText--No
                - LanguageCodeLanguageRegieRateTextFieldsText6No
                - ShortDesignationAbbreviationRegieRateTextFieldsText7No
                - DesignationDesignationRegieRateTextFieldsText30No
    RegieTariffItemTextRegie item textRegieTariffItem--No
        RegieTariffItemTextFieldsFieldsRegieTariffItemText--No
            - LanguageCodeLanguageRegieTariffItemTextFieldsText6No
            - SearchTitleSearch titleRegieTariffItemTextFieldsText30No
            - DesignationDesignationRegieTariffItemTextFieldsText120No



Field Information

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

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:

                

Area
XML Element Name:Area
Parent Element:RegieTariffItemFields
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 "REBEREICH")
                    

Region
XML Element Name:RegieRegion
Parent Element:RegieTariffItemFields
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 "REREGION")
                    

Year
XML Element Name:Year
Parent Element:RegieTariffItemFields
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 "JAHR")
                    

Category
XML Element Name:Category
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 "KEKAT")
                    

Tariff item no.
XML Element Name:ItemNumber
Parent Element:RegieTariffItemFields
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 "TARIFPOSNR")
                    

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")
                    

Own item
XML Element Name:OwnItem
Parent Element:RegieTariffItemFields
Field Type:Boolean (true oder false)
Action Type:Export only
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")
                    

Designation
XML Element Name:Designation
Parent Element:RegieTariffItemFields
Field Type:Text
Action Type:Export only
Field Length:   255Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Region
XML Element Name:Region
Parent Element:RegieTariffItemFields
Field Type:Text
Action Type:Export only
Field Length:   255Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Rate 1
XML Element Name:Rate1
Parent Element:RegieTariffItemFields
Field Type:Nummer
Action Type:Export only
Field Length:   6Decimal Places:   4Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Rate 2
XML Element Name:Rate2
Parent Element:RegieTariffItemFields
Field Type:Nummer
Action Type:Export only
Field Length:   6Decimal Places:   4Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Rate 3
XML Element Name:Rate3
Parent Element:RegieTariffItemFields
Field Type:Nummer
Action Type:Export only
Field Length:   6Decimal Places:   4Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Rate 4
XML Element Name:Rate4
Parent Element:RegieTariffItemFields
Field Type:Nummer
Action Type:Export only
Field Length:   6Decimal Places:   4Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Rate 5
XML Element Name:Rate5
Parent Element:RegieTariffItemFields
Field Type:Nummer
Action Type:Export only
Field Length:   6Decimal Places:   4Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Rate 6
XML Element Name:Rate6
Parent Element:RegieTariffItemFields
Field Type:Nummer
Action Type:Export only
Field Length:   6Decimal Places:   4Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

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")
                    

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.

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")
                    

Datum Preismutation
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")
                    

Tariff item no.
XML Element Name:TariffItemNumber
Parent Element:RegieRateFields
Field Type:Text
Action Type:Export only
Field Length:   12Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

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

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

Abbreviation
XML Element Name:ShortDesignation
Parent Element:RegieRateFields
Field Type:Text
Action Type:Export only
Field Length:   255Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Designation
XML Element Name:Designation
Parent Element:RegieRateFields
Field Type:Text
Action Type:Export only
Field Length:   255Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

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:   30Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Regie item text
XML Element Name:RegieTariffItemText
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: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")