Interface: LOHN - XML Preentry Version 2014.00

This documentation describes the AbaConnect Interface XML Preentry for the LOHN Application.

General Information

General information about the AbaConnect interface.

AbaConnect Interface Information

Application :	LOHN
Interface Name :	XML Preentry
ID :	HierarchyPreEntry ( PreEntry )
Version :	2014.00
Status:	Expiring (Available until Abacus V2025)

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 :
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>HierarchyPreEntry</Id>
      <MapId>AbaDefault</MapId>
      <Version>2014.00</Version>
      
      
      
      <Mandant>7777</Mandant>
    </Parameter>
    <Transaction>
      <PreEntry mode='SAVE'>
          
      </PreEntry>
    </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" "-aLOHN" "-version2014.00" "-M7777" "-acidHierarchyPreEntry" "-mapidAbaDefault" "-datamodeXML" "-responseYES" "-responsefileX:\response.xml" "-exportfileX:\data.xml"

Import :
abaconnectimportconsole.exe "/USRuser" "/PWxxx" "-aLOHN" "-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
+ PreEntry	Pre-entry	-	-	-	Yes
- EmployeeNumber	Personnel no.	PreEntry	Number	10	Yes
- PeriodDate	Date of period	PreEntry	Date	-	Yes
- PeriodNumber	Number of period	PreEntry	Number	2	Yes
- PayrollType	Payroll type	PreEntry	Number	4	Yes
- DocumentNumber	Document number	PreEntry	Number	8	No
- Currency	Currency	PreEntry	Text	3	No
- TextPayrollType	Text payroll type	PreEntry	Text	100	No
- Amount	Amount	PreEntry	Number	10	No
- MutationCodeAmount	Mutation code amount	PreEntry	Boolean	-	No
- Factor	Factor	PreEntry	Number	10	No
- MutationCodeFactor	Mutation code factor	PreEntry	Boolean	-	No
- CostCentre1	Cost centre 1	PreEntry	Number	12	No
- CostCentre2	Cost centre 2	PreEntry	Number	12	No
- FreeNumber	Free number	PreEntry	Number	10	No
- MunicipalityFunction	Municipality function	PreEntry	Number	6	No
- MunicipalityType	Municipality type	PreEntry	Number	8	No
- SubtypeRefNr	Number of subtype ref	PreEntry	Number	10	No
- Division	Division to book the pre-entry	PreEntry	Number	6	No
- ContractNumber	Contract no.	PreEntry	Number	8	No
- EntryNumber	Preentry no.	PreEntry	Number	8	No
- PreEntryDate	Pre-entry date	PreEntry	Date	-	No
- NbwRefNr	Reference no. NBW	PreEntry	Number	10	No
- NbwSplitNr	Split no. NBW	PreEntry	Number	2	No
+ ChildAllowance	Child Allowance	PreEntry	-	-	No
- Allowance	Allowance	ChildAllowance	Number	1	No
- Type	Allowance type	ChildAllowance	Number	3	No
- ValidFrom	Valid from	ChildAllowance	Date	-	No
- ValidTo	Valid to	ChildAllowance	Date	-	No
- Canton	Canton	ChildAllowance	Text	2	No
- EntitelmentNumber	Entitlement no.	ChildAllowance	Text	16	No

Field Information

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

Personnel no.

XML Element Name:	EmployeeNumber
Parent Element:	PreEntry

Field Type:

Nummer

Action Type:

Import und Export

Field Length: 10

Decimal Places: 0

Mandatory Field: Yes

Revision: 0

Ascii ID : 1

Description:

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

Date of period

XML Element Name:	PeriodDate
Parent Element:	PreEntry

Field Type:

Datum (2000-03-20)

Action Type:

Import und Export

Field Length: -

Decimal Places: 0

Mandatory Field: Yes

Revision: 0

Ascii ID : 2

Description:

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

Number of period

XML Element Name:	PeriodNumber
Parent Element:	PreEntry

Field Type:

Nummer

Action Type:

Import und Export

Field Length: 2

Decimal Places: 0

Mandatory Field: Yes

Revision: 0

Ascii ID : 3

Description:

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

Payroll type

XML Element Name:	PayrollType
Parent Element:	PreEntry

Field Type:

Nummer

Action Type:

Import und Export

Field Length: 4

Decimal Places: 0

Mandatory Field: Yes

Revision: 0

Ascii ID : 4

Description:

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

Document number

XML Element Name:	DocumentNumber
Parent Element:	PreEntry

Field Type:

Nummer

Action Type:

Import und Export

Field Length: 8

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : 5

Description:

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

Currency

XML Element Name:	Currency
Parent Element:	PreEntry

Field Type:

Text

Action Type:

Import und Export

Field Length: 3

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : 6

Description:

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

Text payroll type

XML Element Name:	TextPayrollType
Parent Element:	PreEntry

Field Type:

Text

Action Type:

Import und Export

Field Length: 100

Decimal Places: 0

Mandatory Field: No

Revision: 1

Ascii ID : 7

Description:

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

Amount

XML Element Name:	Amount
Parent Element:	PreEntry

Field Type:

Nummer

Action Type:

Import und Export

Field Length: 10

Decimal Places: 6

Mandatory Field: No

Revision: 0

Ascii ID : 8

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.

Mutation code amount

XML Element Name:	MutationCodeAmount
Parent Element:	PreEntry

Field Type:

Boolean (true oder false)

Action Type:

Import und Export

Field Length: -

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : 9

Description:

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

Factor

XML Element Name:	Factor
Parent Element:	PreEntry

Field Type:

Nummer

Action Type:

Import und Export

Field Length: 10

Decimal Places: 6

Mandatory Field: No

Revision: 0

Ascii ID : 10

Description:

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

Mutation code factor

XML Element Name:	MutationCodeFactor
Parent Element:	PreEntry

Field Type:

Boolean (true oder false)

Action Type:

Import und Export

Field Length: -

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : 11

Description:

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

Cost centre 1

XML Element Name:	CostCentre1
Parent Element:	PreEntry

Field Type:

Nummer

Action Type:

Import und Export

Field Length: 12

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : 12

Description:

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

Cost centre 2

XML Element Name:	CostCentre2
Parent Element:	PreEntry

Field Type:

Nummer

Action Type:

Import und Export

Field Length: 12

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : 13

Description:

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

Free number

XML Element Name:	FreeNumber
Parent Element:	PreEntry

Field Type:

Nummer

Action Type:

Import und Export

Field Length: 10

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : 14

Description:

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

Municipality function

XML Element Name:	MunicipalityFunction
Parent Element:	PreEntry

Field Type:

Nummer

Action Type:

Import und Export

Field Length: 6

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : 15

Description:

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

Municipality type

XML Element Name:	MunicipalityType
Parent Element:	PreEntry

Field Type:

Nummer

Action Type:

Import und Export

Field Length: 8

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : 16

Description:

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

Number of subtype ref

XML Element Name:	SubtypeRefNr
Parent Element:	PreEntry

Field Type:

Nummer

Action Type:

Import und Export

Field Length: 10

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : 17

Description:

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

Division to book the pre-entry

XML Element Name:	Division
Parent Element:	PreEntry

Field Type:

Nummer

Action Type:

Import und Export

Field Length: 6

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : 18

Description:

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

Contract no.

XML Element Name:	ContractNumber
Parent Element:	PreEntry

Field Type:

Nummer

Action Type:

Import und Export

Field Length: 8

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : 19

Description:

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

Preentry no.

XML Element Name:	EntryNumber
Parent Element:	PreEntry

Field Type:

Nummer

Action Type:

Import und Export

Field Length: 8

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : 20

Description:

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

Pre-entry date

XML Element Name:	PreEntryDate
Parent Element:	PreEntry

Field Type:

Datum (2000-03-20)

Action Type:

Import und Export

Field Length: -

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : 21

Description:

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

Reference no. NBW

XML Element Name:	NbwRefNr
Parent Element:	PreEntry

Field Type:

Nummer

Action Type:

Export only

Field Length: 10

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : 22

Description:

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

Split no. NBW

XML Element Name:	NbwSplitNr
Parent Element:	PreEntry

Field Type:

Nummer

Action Type:

Export only

Field Length: 2

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : 23

Description:

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

Child Allowance

XML Element Name:	ChildAllowance
Parent Element:	PreEntry

Field Type:

Array List

Action Type:

Import und Export

Field Length: -

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : 200

Description:

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

Allowance

XML Element Name:	Allowance
Parent Element:	ChildAllowance

Field Type:

Nummer

Action Type:

Import und Export

Field Length: 1

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : 201

Description:

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

Allowance type

XML Element Name:	Type
Parent Element:	ChildAllowance

Field Type:

Nummer

Action Type:

Import und Export

Field Length: 3

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : 202

Description:

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

Valid from

XML Element Name:	ValidFrom
Parent Element:	ChildAllowance

Field Type:

Datum (2000-03-20)

Action Type:

Import und Export

Field Length: -

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : 203

Description:

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

Valid to

XML Element Name:	ValidTo
Parent Element:	ChildAllowance

Field Type:

Datum (2000-03-20)

Action Type:

Import und Export

Field Length: -

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : 204

Description:

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

Canton

XML Element Name:	Canton
Parent Element:	ChildAllowance

Field Type:

Text

Action Type:

Import und Export

Field Length: 2

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : 205

Description:

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

Entitlement no.

XML Element Name:	EntitelmentNumber
Parent Element:	ChildAllowance

Field Type:

Text

Action Type:

Import und Export

Field Length: 16

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : 206

Description:

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