Interface: PROJ - Rates Version 2010.00

This documentation describes the AbaConnect Interface Rates for the PROJ Application.


General Information

General information about the AbaConnect interface.

AbaConnect Interface Information
Application :PROJ
Interface Name :Rates
ID :N44 ( NStamm )
Version :2010.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
Die Ansatzfindung erfolgt nach der Regel:
Suche nach
 LeArtNr = NBW.LeArtNr
 Tarif = NPO.TarifNr
Wenn kein Ansatz gefunden, dann suche nach
 LeArtNr = NBW.LeArtNr
 Tarif = 0
Wenn kein Ansatz gefunden, dann suche nach
 LeArtNr = 0
 Tarif = NPO.TarifNr
Wenn kein Ansatz gefunden, dann suche nach
 LeArtNr = 0
 Tarif = 0

Es wird immer zuerst versucht der Projektspezifische Ansatz zu lesen, wenn dieser nicht gefunden wird, dann allgemeine.

Wenn kein Ansatz gefunden und der Ansatz vom Mitarbeiter geholt wird, dann werden die obigen Schritte mit der Mitarbeitergruppe wiederholt.

Wenn kein Ansatz gefunden und der Ansatz der Kostenstelle, des Kunden, der Anlage, der Mitabeitergruppe oder des Projekts gesucht wird, dann werden die obigen Schritte mit Key = 0 wiederholt.

Bsp. Suche des Ansatzes eines Mitarbeiters:
1. Suche nach projektspezifischem Mitarbeiteransatz
2. Suche nach Mitarbeiteransatz
3. Suche nach projektspezifischem Mitarbeitergruppenansatz
4. Suche nach Mitarbeitergruppenansatz
5. Suche nach Ansatz von Mitarbeitergruppe 0
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 :Rates
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>PROJ</Application>
      <Id>N44</Id>
      <MapId>AbaDefault</MapId>
      <Version>2010.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>
      <ProjectRate mode='SAVE'>
          <!-- The specific data fields for the AbaConnect interface are included here. -->
      </ProjectRate>
    </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"  "-aPROJ"  "-version2010.00"  "-M7777"  "-acidN44"  "-mapidAbaDefault"  "-datamodeXML"  "-responseYES"  "-responsefileX:\response.xml"  "-exportfileX:\data.xml"

Import :
abaconnectimportconsole.exe "/USRuser" "/PWxxx"  "-aPROJ"  "-version2010.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
ProjectRateRates---Yes
    - RecordTypeRate typeProjectRateNumber4Yes
    - CodeCodeProjectRateNumber12Yes
    - ServiceCodeService codeProjectRateNumber8Yes
    - TariffTariffProjectRateNumber12Yes
    - DateValid fromProjectRateDate-Yes
    - CurrencyCurrencyProjectRateText3Yes
    - InternalRateDefinitionDefinition field "Internal rate"ProjectRateNumber2No
    - InternalRateInternal rateProjectRateNumber12No
    - ExternalRateDefinitionDefinition field "External rate"ProjectRateNumber2No
    - ExternalRateExternal rateProjectRateNumber12No
    - BaseRateBase rateProjectRateNumber12No



Field Information

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

Rate type
XML Element Name:RecordType
Parent Element:ProjectRate
Field Type:Nummer
Action Type:Import und Export
Field Length:   4Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   4
Description:

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

Code
XML Element Name:Code
Parent Element:ProjectRate
Field Type:Nummer
Action Type:Import und Export
Field Length:   12Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   4
Description:

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

Service code
XML Element Name:ServiceCode
Parent Element:ProjectRate
Field Type:Nummer
Action Type:Import und Export
Field Length:   8Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   4
Description:

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

Tariff
XML Element Name:Tariff
Parent Element:ProjectRate
Field Type:Nummer
Action Type:Import und Export
Field Length:   12Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   4
Description:

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

Valid from
XML Element Name:Date
Parent Element:ProjectRate
Field Type:Datum (2000-03-20)
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   4
Description:

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

Currency
XML Element Name:Currency
Parent Element:ProjectRate
Field Type:Text
Action Type:Import und Export
Field Length:   3Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   4
Description:

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

Definition field "Internal rate"
XML Element Name:InternalRateDefinition
Parent Element:ProjectRate
Field Type:Nummer
Action Type:Import und Export
Field Length:   2Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   4
Description:
How do you want to calculate the rate?
(The internal field ID for this element is "AsIntDef")

Internal rate
XML Element Name:InternalRate
Parent Element:ProjectRate
Field Type:Nummer
Action Type:Import und Export
Field Length:   12Decimal Places:   4Mandatory Field:   NoRevision:   0Ascii ID :   4
Description:

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

Definition field "External rate"
XML Element Name:ExternalRateDefinition
Parent Element:ProjectRate
Field Type:Nummer
Action Type:Import und Export
Field Length:   2Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   4
Description:
How do you want to calculate the rate?
(The internal field ID for this element is "AsExtDef")

External rate
XML Element Name:ExternalRate
Parent Element:ProjectRate
Field Type:Nummer
Action Type:Import und Export
Field Length:   12Decimal Places:   4Mandatory Field:   NoRevision:   0Ascii ID :   4
Description:

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

Base rate
XML Element Name:BaseRate
Parent Element:ProjectRate
Field Type:Nummer
Action Type:Import und Export
Field Length:   12Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   4
Description:
The base rate is obtained from here. 
The base rates are the rates with tariff and serv. code = 0
(The internal field ID for this element is "RelKey")