Interface: LOHN - Payroll values 01 - 10 Version 2007.10

This documentation describes the AbaConnect Interface Payroll values 01 - 10 for the LOHN Application.


General Information

General information about the AbaConnect interface.

AbaConnect Interface Information
Application :LOHN
Interface Name :Payroll values 01 - 10
ID :FlatPayrollData01to10 ( PayrollData )
Version :2007.10
Status:Productive


Displays the possible import and export features for this interface.

Export / Import Modus
Export :ASCII
Import :ASCII


Displays additional information for this interface.

Additional Information

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

                



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"  "-acidFlatPayrollData01to10"  "-mapidAbaDefault"  "-datamodeASCII"  "-responseYES"  "-responsefileX:\response.xml"  "-exportfileX:\data.csv"

Import :
abaconnectimportconsole.exe "/USRuser" "/PWxxx"  "-aLOHN"  "-version2007.10"  "-M7777"  "-acidFlatPayrollData01to10"  "-mapidAbaDefault"  "-datamodeASCII"  "-responseYES"  "-responsefileX:\response.xml"  "-importfileX:\data.csv"



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
+ Amount01To10Payroll values 01 - 10---Yes
    - EmployeeNumberPersonnel no.Amount01To10Number10Yes
    - YearTimeAxisYear time axisAmount01To10Number4Yes
    - MonthTimeAxisMonth time axisAmount01To10Number2Yes
    - MonthlyWageMonthly wageAmount01To10Number10No
    - HourlyWageHourly wageAmount01To10Number10No
    - Amount3Payroll value 3Amount01To10Number10No
    - CarExpensesFlatRateCar expenses flat-rateAmount01To10Number10No
    - FixedExpensesFixed expensesAmount01To10Number10No
    - RoomRoomAmount01To10Number10No
    - MealsMealsAmount01To10Number10No
    - GeneralAbonnementSBBGeneral abonnement SBBAmount01To10Number10No
    - PurchasePriceCompanyCarPurchase price company carAmount01To10Number10No
    - PrivatePartCompanyCarPrivate part company carAmount01To10Number10No



Field Information

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

Personnel no.
XML Element Name:EmployeeNumber
Parent Element:Amount01To10
Field Type:Nummer
Action Type:Import und Export
Field Length:   10Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   1
Description:

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

Year time axis
XML Element Name:YearTimeAxis
Parent Element:Amount01To10
Field Type:Nummer
Action Type:Import und Export
Field Length:   4Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   2
Description:

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

Month time axis
XML Element Name:MonthTimeAxis
Parent Element:Amount01To10
Field Type:Nummer
Action Type:Import und Export
Field Length:   2Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   3
Description:

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

Monthly wage
XML Element Name:MonthlyWage
Parent Element:Amount01To10
Field Type:Nummer
Action Type:Import und Export
Field Length:   10Decimal Places:   4Mandatory Field:   NoRevision:   0Ascii ID :   4
Description:

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

Hourly wage
XML Element Name:HourlyWage
Parent Element:Amount01To10
Field Type:Nummer
Action Type:Import und Export
Field Length:   10Decimal Places:   4Mandatory Field:   NoRevision:   0Ascii ID :   5
Description:

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

Payroll value 3
XML Element Name:Amount3
Parent Element:Amount01To10
Field Type:Nummer
Action Type:Import und Export
Field Length:   10Decimal Places:   4Mandatory Field:   NoRevision:   0Ascii ID :   6
Description:

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

Car expenses flat-rate
XML Element Name:CarExpensesFlatRate
Parent Element:Amount01To10
Field Type:Nummer
Action Type:Import und Export
Field Length:   10Decimal Places:   4Mandatory Field:   NoRevision:   0Ascii ID :   7
Description:

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

Fixed expenses
XML Element Name:FixedExpenses
Parent Element:Amount01To10
Field Type:Nummer
Action Type:Import und Export
Field Length:   10Decimal Places:   4Mandatory Field:   NoRevision:   0Ascii ID :   8
Description:

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

Room
XML Element Name:Room
Parent Element:Amount01To10
Field Type:Nummer
Action Type:Import und Export
Field Length:   10Decimal Places:   4Mandatory Field:   NoRevision:   0Ascii ID :   9
Description:

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

Meals
XML Element Name:Meals
Parent Element:Amount01To10
Field Type:Nummer
Action Type:Import und Export
Field Length:   10Decimal Places:   4Mandatory Field:   NoRevision:   0Ascii ID :   10
Description:

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

General abonnement SBB
XML Element Name:GeneralAbonnementSBB
Parent Element:Amount01To10
Field Type:Nummer
Action Type:Import und Export
Field Length:   10Decimal Places:   4Mandatory Field:   NoRevision:   0Ascii ID :   11
Description:

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

Purchase price company car
XML Element Name:PurchasePriceCompanyCar
Parent Element:Amount01To10
Field Type:Nummer
Action Type:Import und Export
Field Length:   10Decimal Places:   4Mandatory Field:   NoRevision:   0Ascii ID :   12
Description:

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

Private part company car
XML Element Name:PrivatePartCompanyCar
Parent Element:Amount01To10
Field Type:Nummer
Action Type:Import und Export
Field Length:   10Decimal Places:   4Mandatory Field:   NoRevision:   0Ascii ID :   13
Description:

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