Interface: KRED - Payments Version 2018.00

This documentation describes the AbaConnect Interface Payments for the KRED Application.

General Information

General information about the AbaConnect interface.

AbaConnect Interface Information

Application :	KRED
Interface Name :	Payments
ID :	Payment ( Payment )
Version :	2018.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 : 0

Mapping Information

The following displays the Mapping details for this interface.

Mapping Information

Mapping ID :	AbaDefault
Mapping Name :	Payments
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>KRED</Application>
      <Id>Payment</Id>
      <MapId>AbaDefault</MapId>
      <Version>2018.00</Version>
      
      
      
      <Mandant>7777</Mandant>
    </Parameter>
    <Transaction>
      <Payment mode='SAVE'>
          
      </Payment>
    </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" "-aKRED" "-version2018.00" "-M7777" "-acidPayment" "-mapidAbaDefault" "-datamodeXML" "-responseYES" "-responsefileX:\response.xml" "-exportfileX:\data.xml"

Import :
abaconnectimportconsole.exe "/USRuser" "/PWxxx" "-aKRED" "-version2018.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
+ Payment	Payment	-	-	-	No
- DocumentNumber	Document number	Payment	Number	10	Yes
- SupplierNumber	Supplier no.	Payment	Number	12	Yes
- PaymentType	Payment type	Payment	Text	4	Yes
- Number	Item no.	Payment	Number	6	Yes
- PaymentDate	Payment date	Payment	Date	-	Yes
- Division	Division	Payment	Number	8	Yes
- CreditAccount	Payment credit account	Payment	Number	12	Yes
- CreditCostCenter1	Payment credit cost centre 1	Payment	Number	12	Yes
- CreditCostCenter2	Payment credit cost centre 2	Payment	Number	12	Yes
- PaymentAmount	Comp. paym. centre amount	Payment	Number	14	Yes
- PaymentRate	Comp. paym. centre rate	Payment	Number	14	Yes
- PaymentCurrency	Comp. paym. centre currency	Payment	Text	3	Yes
- Amount	Payment amount in document currency	Payment	Number	16	Yes
- DocumentRate	Document rate	Payment	Number	14	Yes
- DocumentCurrency	Payment currency	Payment	Text	3	Yes
- KeyAmount	Paym. amount in key currency	Payment	Number	16	Yes
- CompanyPaymentCentreNumber	Company payment centre no.	Payment	Number	6	Yes
- GeneralLedgerCode	G/L code	Payment	Text	1	Yes
- PaymentDocumentNumber	Payment document number	Payment	Number	10	Yes
- Text	Payment-Text	Payment	Text	80	Yes
- ClearingText	Clearing text	Payment	Text	30	Yes
- CheckNumber	Cheque number	Payment	Number	8	Yes
- Batch	Stack	Payment	Number	8	Yes

Field Information

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

Document number

XML Element Name:	DocumentNumber
Parent Element:	Payment

Field Type:

Nummer

Action Type:

Import und Export

Field Length: 10

Decimal Places: 0

Mandatory Field: Yes

Revision: 0

Ascii ID : -

Description:

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

Supplier no.

XML Element Name:	SupplierNumber
Parent Element:	Payment

Field Type:

Nummer

Action Type:

Import und Export

Field Length: 12

Decimal Places: 0

Mandatory Field: Yes

Revision: 0

Ascii ID : -

Description:

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

Payment type

XML Element Name:	PaymentType
Parent Element:	Payment

Field Type:

Text

Action Type:

Import und Export

Field Length: 4

Decimal Places: 0

Mandatory Field: Yes

Revision: 0

Ascii ID : -

Description:

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

Item no.

XML Element Name:	Number
Parent Element:	Payment

Field Type:

Nummer

Action Type:

Import und Export

Field Length: 6

Decimal Places: 0

Mandatory Field: Yes

Revision: 0

Ascii ID : -

Description:

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

Payment date

XML Element Name:	PaymentDate
Parent Element:	Payment

Field Type:

Datum (2000-03-20)

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

Division

XML Element Name:	Division
Parent Element:	Payment

Field Type:

Nummer

Action Type:

Import und Export

Field Length: 8

Decimal Places: 0

Mandatory Field: Yes

Revision: 0

Ascii ID : -

Description:

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

Payment credit account

XML Element Name:	CreditAccount
Parent Element:	Payment

Field Type:

Nummer

Action Type:

Import und Export

Field Length: 12

Decimal Places: 0

Mandatory Field: Yes

Revision: 0

Ascii ID : -

Description:

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

Payment credit cost centre 1

XML Element Name:	CreditCostCenter1
Parent Element:	Payment

Field Type:

Nummer

Action Type:

Import und Export

Field Length: 12

Decimal Places: 0

Mandatory Field: Yes

Revision: 0

Ascii ID : -

Description:

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

Payment credit cost centre 2

XML Element Name:	CreditCostCenter2
Parent Element:	Payment

Field Type:

Nummer

Action Type:

Import und Export

Field Length: 12

Decimal Places: 0

Mandatory Field: Yes

Revision: 0

Ascii ID : -

Description:

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

Comp. paym. centre amount

XML Element Name:	PaymentAmount
Parent Element:	Payment

Field Type:

Nummer

Action Type:

Import und Export

Field Length: 14

Decimal Places: 2

Mandatory Field: Yes

Revision: 0

Ascii ID : -

Description:

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

Comp. paym. centre rate

XML Element Name:	PaymentRate
Parent Element:	Payment

Field Type:

Nummer

Action Type:

Import und Export

Field Length: 14

Decimal Places: 8

Mandatory Field: Yes

Revision: 0

Ascii ID : -

Description:

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

Comp. paym. centre currency

XML Element Name:	PaymentCurrency
Parent Element:	Payment

Field Type:

Text

Action Type:

Import und Export

Field Length: 3

Decimal Places: 0

Mandatory Field: Yes

Revision: 0

Ascii ID : -

Description:

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

Payment amount in document currency

XML Element Name:	Amount
Parent Element:	Payment

Field Type:

Nummer

Action Type:

Import und Export

Field Length: 16

Decimal Places: 2

Mandatory Field: Yes

Revision: 0

Ascii ID : -

Description:

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

Document rate

XML Element Name:	DocumentRate
Parent Element:	Payment

Field Type:

Nummer

Action Type:

Import und Export

Field Length: 14

Decimal Places: 8

Mandatory Field: Yes

Revision: 0

Ascii ID : -

Description:

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

Payment currency

XML Element Name:	DocumentCurrency
Parent Element:	Payment

Field Type:

Text

Action Type:

Import und Export

Field Length: 3

Decimal Places: 0

Mandatory Field: Yes

Revision: 0

Ascii ID : -

Description:

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

Paym. amount in key currency

XML Element Name:	KeyAmount
Parent Element:	Payment

Field Type:

Nummer

Action Type:

Import und Export

Field Length: 16

Decimal Places: 2

Mandatory Field: Yes

Revision: 0

Ascii ID : -

Description:

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

Company payment centre no.

XML Element Name:	CompanyPaymentCentreNumber
Parent Element:	Payment

Field Type:

Nummer

Action Type:

Import und Export

Field Length: 6

Decimal Places: 0

Mandatory Field: Yes

Revision: 0

Ascii ID : -

Description:

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

G/L code

XML Element Name:	GeneralLedgerCode
Parent Element:	Payment

Field Type:

Text

Action Type:

Import und Export

Field Length: 1

Decimal Places: 0

Mandatory Field: Yes

Revision: 0

Ascii ID : -

Description:

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

Payment document number

XML Element Name:	PaymentDocumentNumber
Parent Element:	Payment

Field Type:

Nummer

Action Type:

Import und Export

Field Length: 10

Decimal Places: 0

Mandatory Field: Yes

Revision: 0

Ascii ID : -

Description:

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

Payment-Text

XML Element Name:	Text
Parent Element:	Payment

Field Type:

Text

Action Type:

Import und Export

Field Length: 80

Decimal Places: 0

Mandatory Field: Yes

Revision: 0

Ascii ID : -

Description:

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

Clearing text

XML Element Name:	ClearingText
Parent Element:	Payment

Field Type:

Text

Action Type:

Import und Export

Field Length: 30

Decimal Places: 0

Mandatory Field: Yes

Revision: 0

Ascii ID : -

Description:

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

Cheque number

XML Element Name:	CheckNumber
Parent Element:	Payment

Field Type:

Nummer

Action Type:

Import und Export

Field Length: 8

Decimal Places: 0

Mandatory Field: Yes

Revision: 0

Ascii ID : -

Description:

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

Stack

XML Element Name:	Batch
Parent Element:	Payment

Field Type:

Nummer

Action Type:

Import und Export

Field Length: 8

Decimal Places: 0

Mandatory Field: Yes

Revision: 0

Ascii ID : 1

Description:

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