Interface: LOHN - Payroll values 21 - 30 Version 2007.10

This documentation describes the AbaConnect Interface Payroll values 21 - 30 for the LOHN Application.


General Information

General information about the AbaConnect interface.

AbaConnect Interface Information
Application :LOHN
Interface Name :Payroll values 21 - 30
ID :FlatPayrollData21to30 ( 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"  "-acidFlatPayrollData21to30"  "-mapidAbaDefault"  "-datamodeASCII"  "-responseYES"  "-responsefileX:\response.xml"  "-exportfileX:\data.csv"

Import :
abaconnectimportconsole.exe "/USRuser" "/PWxxx"  "-aLOHN"  "-version2007.10"  "-M7777"  "-acidFlatPayrollData21to30"  "-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
+ Amount21To30Payroll values 21 - 30---Yes
    - EmployeeNumberPersonnel no.Amount21To30Number10Yes
    - YearTimeAxisYear time axisAmount21To30Number4Yes
    - MonthTimeAxisMonth time axisAmount21To30Number2Yes
    - HourlyWage2Hourly wage 2Amount21To30Number10No
    - RepaymentOfLoansDeductionRepayment of loans deductionAmount21To30Number10No
    - Amount23Loan balanceAmount21To30Number10No
    - WithholdingTaxDeductionFixedFixed withholding taxAmount21To30Number10No
    - BorderCrosserDeductionFixedFixed border crosser deductionAmount21To30Number10No
    - PensionOccupationalBenefitEmployerPF/LOB employer contributionAmount21To30Number10No
    - LoanRateLoan rateAmount21To30Number10No
    - LoanBalanceLoan balanceAmount21To30Number10No
    - GarnishmentOfWagesLoan garnishmentAmount21To30Number10No
    - Amount30Payroll value 30Amount21To30Number10No



Field Information

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

Personnel no.
XML Element Name:EmployeeNumber
Parent Element:Amount21To30
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:Amount21To30
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:Amount21To30
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")
                    

Hourly wage 2
XML Element Name:HourlyWage2
Parent Element:Amount21To30
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 "Amount21")
                    
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.

Repayment of loans deduction
XML Element Name:RepaymentOfLoansDeduction
Parent Element:Amount21To30
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 "Amount22")
                    
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.

Loan balance
XML Element Name:Amount23
Parent Element:Amount21To30
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 "Amount23")
                    
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.

Fixed withholding tax
XML Element Name:WithholdingTaxDeductionFixed
Parent Element:Amount21To30
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 "Amount24")
                    
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.

Fixed border crosser deduction
XML Element Name:BorderCrosserDeductionFixed
Parent Element:Amount21To30
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 "Amount25")
                    
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.

PF/LOB employer contribution
XML Element Name:PensionOccupationalBenefitEmployer
Parent Element:Amount21To30
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 "Amount26")
                    
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.

Loan rate
XML Element Name:LoanRate
Parent Element:Amount21To30
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 "Amount27")
                    
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.

Loan balance
XML Element Name:LoanBalance
Parent Element:Amount21To30
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 "Amount28")
                    
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.

Loan garnishment
XML Element Name:GarnishmentOfWages
Parent Element:Amount21To30
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 "Amount29")
                    
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.

Payroll value 30
XML Element Name:Amount30
Parent Element:Amount21To30
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 "Amount30")
                    
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.