Interface: LOHN - XML Preentry period Version 2019.00

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

General Information

General information about the AbaConnect interface.

AbaConnect Interface Information

Application :	LOHN
Interface Name :	XML Preentry period
ID :	PeriodPreentry ( PreEntry )
Version :	2019.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 : 2

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>PeriodPreentry</Id>
      <MapId>AbaDefault</MapId>
      <Version>2019.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" "-version2019.00" "-M7777" "-acidPeriodPreentry" "-mapidAbaDefault" "-datamodeXML" "-responseYES" "-responsefileX:\response.xml" "-exportfileX:\data.xml"

Import :
abaconnectimportconsole.exe "/USRuser" "/PWxxx" "-aLOHN" "-version2019.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
- EntryNumber	Preentry no.	Preentry	Number	8	No
- Employee	Personnel no.	Preentry	Number	10	Yes
- Contract	Contract no.	Preentry	Number	8	No
- Date	Date	Preentry	Date	-	Yes
- PreentryDate	Pre-entry date	Preentry	Date	-	No
- PeriodNumber	Number of period	Preentry	Number	2	Yes
- Paytype	Paytype	Preentry	Number	4	Yes
- PaytypeText	Text payroll type	Preentry	Text	100	No
- Amount	Amount	Preentry	Number	10	No
- AmountActive	Quantity active	Preentry	Boolean	-	No
- AmountUnit	Number unit	Preentry	Text	4	Yes
- Operator	Operator	Preentry	Number	1	Yes
- Factor	Factor	Preentry	Number	10	No
- FactorActive	Rate active	Preentry	Boolean	-	No
- FactorUnit	Rate unit	Preentry	Text	4	Yes
- Currency	Currency	Preentry	Text	4	No
- VatCode	VAT code	Preentry	Text	3	No
- SubtypeReference	Payroll type detail	Preentry	Number	10	No
- EntryGroup	Entry group	Preentry	Number	8	No
- Comment	Comment	Preentry	Text	300	No
- Project	Projet	Preentry	Number	12	Yes
- ProjectReferenceNumber	Project reference no.	Preentry	Number	10	No
- ProjectSplitNumber	Project split no.	Preentry	Number	2	No
- Recurring	Recurring	Preentry	Boolean	-	Yes
- Order	Order	Preentry	Number	10	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
- ValidUntil	Valid to	ChildAllowance	Date	-	No
- Canton	Canton	ChildAllowance	Text	2	No
- EntitlementNumber	Entitlement no.	ChildAllowance	Text	16	No
+ FreeFields	Free fields	Preentry	-	-	No
- Nr1	Free number 1	FreeFields	Number	8	No
- Nr2	Free number 2	FreeFields	Number	8	No
- Text1	Free text 1	FreeFields	Text	50	No
- Text2	Free text 2	FreeFields	Text	50	No
- Date1	Free date 1	FreeFields	Date	-	No
+ CostCentre	Cost centre	Preentry	-	-	No
- Division	Division	CostCentre	Number	6	No
- Account	G/L account	CostCentre	Number	12	No
- CostCentre1	Cost centre 1	CostCentre	Number	12	No
- CostCentre2	Cost centre 2	CostCentre	Number	12	No

Field Information

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

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

Personnel no.

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

Contract no.

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

Date

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

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

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

Paytype

XML Element Name:	Paytype
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 "paytype")

Text payroll type

XML Element Name:	PaytypeText
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 "text")

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.

Quantity active

XML Element Name:	AmountActive
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 "amountActive")

Number unit

XML Element Name:	AmountUnit
Parent Element:	Preentry

Field Type:

Text

Action Type:

Import und Export

Field Length: 4

Decimal Places: 0

Mandatory Field: Yes

Revision: 0

Ascii ID : 201

Description:

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

Operator

XML Element Name:	Operator
Parent Element:	Preentry

Field Type:

Nummer

Action Type:

Import und Export

Field Length: 1

Decimal Places: 0

Mandatory Field: Yes

Revision: 0

Ascii ID : 203

Description:

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

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.

Rate active

XML Element Name:	FactorActive
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 "factorActive")

Rate unit

XML Element Name:	FactorUnit
Parent Element:	Preentry

Field Type:

Text

Action Type:

Import und Export

Field Length: 4

Decimal Places: 0

Mandatory Field: Yes

Revision: 0

Ascii ID : 202

Description:

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

Currency

XML Element Name:	Currency
Parent Element:	Preentry

Field Type:

Text

Action Type:

Import und Export

Field Length: 4

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : 6

Description:

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

VAT code

XML Element Name:	VatCode
Parent Element:	Preentry

Field Type:

Text

Action Type:

Import und Export

Field Length: 3

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : 204

Description:

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

Payroll type detail

XML Element Name:	SubtypeReference
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 "subtypeReference")

Entry group

XML Element Name:	EntryGroup
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 "entryGroup")

Comment

XML Element Name:	Comment
Parent Element:	Preentry

Field Type:

Text

Action Type:

Import und Export

Field Length: 300

Decimal Places: 0

Mandatory Field: No

Revision: 2

Ascii ID : 211

Description:

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

Projet

XML Element Name:	Project
Parent Element:	Preentry

Field Type:

Nummer

Action Type:

Import und Export

Field Length: 12

Decimal Places: 0

Mandatory Field: Yes

Revision: 0

Ascii ID : 214

Description:

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

Project reference no.

XML Element Name:	ProjectReferenceNumber
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 "projectReferenceNumber")

Project split no.

XML Element Name:	ProjectSplitNumber
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 "projectSplitNumber")

Recurring

XML Element Name:	Recurring
Parent Element:	Preentry

Field Type:

Boolean (true oder false)

Action Type:

Import und Export

Field Length: -

Decimal Places: 0

Mandatory Field: Yes

Revision: 0

Ascii ID : -

Description:

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

Order

XML Element Name:	Order
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 "orderNumber")

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

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:	ValidUntil
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:	EntitlementNumber
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 "string1")

Free fields

XML Element Name:	FreeFields
Parent Element:	Preentry

Field Type:

Type[ 15 ]

Action Type:

Import und Export

Field Length: -

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : 212

Description:

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

Free number 1

XML Element Name:	Nr1
Parent Element:	FreeFields

Field Type:

Nummer

Action Type:

Import und Export

Field Length: 8

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : 206

Description:

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

Free number 2

XML Element Name:	Nr2
Parent Element:	FreeFields

Field Type:

Nummer

Action Type:

Import und Export

Field Length: 8

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : 207

Description:

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

Free text 1

XML Element Name:	Text1
Parent Element:	FreeFields

Field Type:

Text

Action Type:

Import und Export

Field Length: 50

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : 208

Description:

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

Free text 2

XML Element Name:	Text2
Parent Element:	FreeFields

Field Type:

Text

Action Type:

Import und Export

Field Length: 50

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : 209

Description:

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

Free date 1

XML Element Name:	Date1
Parent Element:	FreeFields

Field Type:

Datum (2000-03-20)

Action Type:

Import und Export

Field Length: -

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : 210

Description:

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

Cost centre

XML Element Name:	CostCentre
Parent Element:	Preentry

Field Type:

Array List

Action Type:

Import und Export

Field Length: -

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : 213

Description:

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

Division

XML Element Name:	Division
Parent Element:	CostCentre

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

G/L account

XML Element Name:	Account
Parent Element:	CostCentre

Field Type:

Nummer

Action Type:

Import und Export

Field Length: 12

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : 205

Description:

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

Cost centre 1

XML Element Name:	CostCentre1
Parent Element:	CostCentre

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

Cost centre 2

XML Element Name:	CostCentre2
Parent Element:	CostCentre

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