Interface: LOHN - ASCII Pre-entry Version 2007.10

This documentation describes the AbaConnect Interface ASCII Pre-entry for the LOHN Application.

General Information

General information about the AbaConnect interface.

AbaConnect Interface Information

Application :	LOHN
Interface Name :	ASCII Pre-entry
ID :	FlatPreEntry ( PreEntry )
Version :	2007.10
Status:	Expiring (Available until Abacus V2025)

Displays the possible import and export features for this interface.

Export / Import Modus

Export :	XML / ASCII
Import :	XML / ASCII

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>FlatPreEntry</Id>
      <MapId>AbaDefault</MapId>
      <Version>2007.10</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" "-version2007.10" "-M7777" "-acidFlatPreEntry" "-mapidAbaDefault" "-datamodeXML" "-responseYES" "-responsefileX:\response.xml" "-exportfileX:\data.xml"

Import :
abaconnectimportconsole.exe "/USRuser" "/PWxxx" "-aLOHN" "-version2007.10" "-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
- ChildNumber	Number of the child	PreEntry	Number	2	No
- Division	Division to book the pre-entry	PreEntry	Number	6	No
- ContractNumber	Contract no.	PreEntry	Number	8	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 (truncation allowed)

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 the child

XML Element Name:	ChildNumber
Parent Element:	PreEntry

Field Type:

Nummer

Action Type:

Import und Export

Field Length: 2

Decimal Places: 0

Mandatory Field: No

Revision: 1

Ascii ID : 17

Description:

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

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: 1

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: 1

Ascii ID : 19

Description:

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