Interface: HRMS - HR account entries Version 2014.00

This documentation describes the AbaConnect Interface HR account entries for the HRMS Application.


General Information

General information about the AbaConnect interface.

AbaConnect Interface Information
Application :HRMS
Interface Name :HR account entries
ID :AccountBookingData ( PersonnelAccounts )
Version :2014.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 : 1



Mapping Information

The following displays the Mapping details for this interface.

Mapping Information
Mapping ID :AbaDefault
Mapping Name :HR account entries
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>HRMS</Application>
      <Id>AccountBookingData</Id>
      <MapId>AbaDefault</MapId>
      <Version>2014.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>
      <AccountBookingData mode='SAVE'>
          <!-- The specific data fields for the AbaConnect interface are included here. -->
      </AccountBookingData>
    </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"  "-aHRMS"  "-version2014.00"  "-M7777"  "-acidAccountBookingData"  "-mapidAbaDefault"  "-datamodeXML"  "-responseYES"  "-responsefileX:\response.xml"  "-exportfileX:\data.xml"

Import :
abaconnectimportconsole.exe "/USRuser" "/PWxxx"  "-aHRMS"  "-version2014.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
+ AccountBookingDataHR account entries---Yes
    - JournalAccount journalAccountBookingDataNumber4Yes
    - BookingDateEntry dateAccountBookingDataDate-No
    - BookingNumberEntry numberAccountBookingDataNumber8No
    - AccountNumbernumberAccountBookingDataNumber10Yes
    - DivisionDivisionAccountBookingDataNumber8No
    - ContractContractAccountBookingDataNumber8No
    - AmountAmountAccountBookingDataNumber12No
    - QuantityQuantityAccountBookingDataNumber8No
    - ValueDateValue dateAccountBookingDataDate-No
    - InterestDateInterest dateAccountBookingDataDate-No
    - TransactionCodeTransaction codeAccountBookingDataNumber4Yes
    - TransactionIDTransaction IDAccountBookingDataNumber4No
    - TextEntry textAccountBookingDataText100No
    - DocumentNumberDoc. numberAccountBookingDataText6No
    - ProgramABACUS ProgrammAccountBookingDataNumber2No
    - CancelledEntry cancelledAccountBookingDataBoolean-No



Field Information

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

Account journal
XML Element Name:Journal
Parent Element:AccountBookingData
Field Type:Nummer
Action Type:Import und Export
Field Length:   4Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   -
Description:

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

Entry date
XML Element Name:BookingDate
Parent Element:AccountBookingData
Field Type:Datum (2000-03-20)
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Entry number
XML Element Name:BookingNumber
Parent Element:AccountBookingData
Field Type:Nummer
Action Type:Import und Export
Field Length:   8Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
The entry numbers are assigned per journal. This means that entry number 1 may occur once in journal 30 and 40.
(The internal field ID for this element is "BookNr")

number
XML Element Name:AccountNumber
Parent Element:AccountBookingData
Field Type:Nummer
Action Type:Import und Export
Field Length:   10Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   -
Description:

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

Division
XML Element Name:Division
Parent Element:AccountBookingData
Field Type:Nummer
Action Type:Import und Export
Field Length:   8Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Contract
XML Element Name:Contract
Parent Element:AccountBookingData
Field Type:Nummer
Action Type:Import und Export
Field Length:   8Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

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

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

Quantity
XML Element Name:Quantity
Parent Element:AccountBookingData
Field Type:Nummer
Action Type:Import und Export
Field Length:   8Decimal Places:   4Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Value date
XML Element Name:ValueDate
Parent Element:AccountBookingData
Field Type:Datum (2000-03-20)
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Interest date
XML Element Name:InterestDate
Parent Element:AccountBookingData
Field Type:Datum (2000-03-20)
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Transaction code
XML Element Name:TransactionCode
Parent Element:AccountBookingData
Field Type:Nummer
Action Type:Import und Export
Field Length:   4Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   -
Description:

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

Transaction ID
XML Element Name:TransactionID
Parent Element:AccountBookingData
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 "Id")
                    

Entry text
XML Element Name:Text
Parent Element:AccountBookingData
Field Type:Text
Action Type:Import und Export
Field Length:   100Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Doc. number
XML Element Name:DocumentNumber
Parent Element:AccountBookingData
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 "Doc")
                    

ABACUS Programm
XML Element Name:Program
Parent Element:AccountBookingData
Field Type:Nummer
Action Type:Import und Export
Field Length:   2Decimal Places:   0Mandatory Field:   NoRevision:   1Ascii ID :   -
Description:

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

Entry cancelled
XML Element Name:Cancelled
Parent Element:AccountBookingData
Field Type:Boolean (true oder false)
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   1Ascii ID :   -
Description:

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