Interface: EPAY - EFT-Transaction Version 2023.10

This documentation describes the AbaConnect Interface EFT-Transaction for the EPAY Application.

General Information

General information about the AbaConnect interface.

AbaConnect Interface Information

Application :	EPAY
Interface Name :	EFT-Transaction
ID :	EFT-Transaction ( PaymentTransaction )
Version :	2023.10
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 :	EFT-Transaction
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>EPAY</Application>
      <Id>EFT-Transaction</Id>
      <MapId>AbaDefault</MapId>
      <Version>2023.10</Version>
      
      
      
      <Mandant>7777</Mandant>
    </Parameter>
    <Transaction>
      <PtDetail mode='SAVE'>
          
      </PtDetail>
    </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" "-aEPAY" "-version2023.10" "-M7777" "-acidEFT-Transaction" "-mapidAbaDefault" "-datamodeXML" "-responseYES" "-responsefileX:\response.xml" "-exportfileX:\data.xml"

Import :
abaconnectimportconsole.exe "/USRuser" "/PWxxx" "-aEPAY" "-version2023.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
+ PtDetail	Detail (Transaction)	-	-	-	Yes
+ PtEntry	Booking	PtDetail	-	-	Yes
- EntryId	Entry identification	PtEntry	Number	10	Yes
- DetailType	Type	PtEntry	Number	4	Yes
- Currency	Currency	PtEntry	Text	3	No
- Amount	Amount	PtEntry	Number	14	No
- FibuJournalId	Reference to G/L journal	PtEntry	Text	3	No
- FibuReference	Reference to G/L entry	PtEntry	GUID	36	No
- Direction	Direction	PtDetail	Text	2	Yes
- FileId	File identification	PtDetail	Number	10	Yes
- TransferId	Transmission identification	PtDetail	Number	10	Yes
- GroupId	Group identification	PtDetail	Number	10	Yes
- DetailId	Detail identification	PtDetail	Number	10	Yes
- Status	Status	PtDetail	Text	1	No
- BookingDone	completed	PtDetail	Boolean	-	No
- TerminalId	Terminal-ID	PtDetail	Text	50	No
- BrandId	Brand-ID	PtDetail	Text	40	No
- AcquirerName	Acquirer designation	PtDetail	Text	40	No
- ValueDate	Value date	PtDetail	Date	-	No
- TransactionDateTime	Transaction time	PtDetail	Date/Time	-	No
- TransactionId	Transaction-ID	PtDetail	Text	50	No
- TransactionText	Transaction text	PtDetail	Text	50	No
- Currency	Currency	PtDetail	Text	3	No
- GrossAmount	Gross amount	PtDetail	Number	14	No
- NetAmount	Net amount	PtDetail	Number	14	No
- TipAmount	Tip amount	PtDetail	Number	14	No
- FeeAmount	Commission amount	PtDetail	Number	14	No
- CardNumberFragment	Fragment of the credit card number	PtDetail	Text	40	No
- CardHolderName	Name of credit card holder	PtDetail	Text	50	No
- OriginalCurrency	Original currency	PtDetail	Text	3	No
- OriginalAmount	Amount in original currency	PtDetail	Number	14	No
- ExchangeRate	Rate	PtDetail	Number	14	No
- OrderNumber		PtDetail	Number	10	No
- OrderSubNumber		PtDetail	Number	2	No
- SourceReference	Source reference	PtDetail	GUID	36	No
- Source	Record sources	PtDetail	Text	20	No
- PaymentId	Payout-ID	PtDetail	Text	50	No
- PaymentState	Payment status	PtDetail	Number	2	No
- MerchantId	Handler ID	PtDetail	Text	20	No
- MerchantName	Handler name	PtDetail	Text	50	No
- MerchantCategory	Category	PtDetail	Text	50	No
- MerchantCategoryCode	Category code	PtDetail	Text	20	No
- MerchantMail	E-mail	PtDetail	Text	65	No
- MerchantLine1	Supplement	PtDetail	Text	50	No
- MerchantCity	Location	PtDetail	Text	50	No
- MerchantPostCode	postcode	PtDetail	Text	15	No
- MerchantCountry	Country	PtDetail	Text	4	No
- MatchingType		PtDetail	Number	2	No

Field Information

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

Booking

XML Element Name:	PtEntry
Parent Element:	PtDetail

Field Type:

Action Type:

Import und Export

Field Length: -

Decimal Places: 0

Mandatory Field: Yes

Revision: 0

Ascii ID : 1

Description:

Entry identification

XML Element Name:	EntryId
Parent Element:	PtEntry

Field Type:

Nummer

Action Type:

Import und Export

Field Length: 10

Decimal Places: 0

Mandatory Field: Yes

Revision: 0

Ascii ID : 6

Description:

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

Type

XML Element Name:	DetailType
Parent Element:	PtEntry

Field Type:

Nummer

Action Type:

Import und Export

Field Length: 4

Decimal Places: 0

Mandatory Field: Yes

Revision: 0

Ascii ID : 7

Description:

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

Currency

XML Element Name:	Currency
Parent Element:	PtEntry

Field Type:

Text

Action Type:

Import und Export

Field Length: 3

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : 8

Description:

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

Amount

XML Element Name:	Amount
Parent Element:	PtEntry

Field Type:

Nummer

Action Type:

Import und Export

Field Length: 14

Decimal Places: 8

Mandatory Field: No

Revision: 0

Ascii ID : 9

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.

Reference to G/L journal

XML Element Name:	FibuJournalId
Parent Element:	PtEntry

Field Type:

Text

Action Type:

Import und Export

Field Length: 3

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : 10

Description:

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

Reference to G/L entry

XML Element Name:	FibuReference
Parent Element:	PtEntry

Field Type:

GUID

Action Type:

Import und Export

Field Length: 36

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : 11

Description:

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

Direction

XML Element Name:	Direction
Parent Element:	PtDetail

Field Type:

Text

Action Type:

Import und Export

Field Length: 2

Decimal Places: 0

Mandatory Field: Yes

Revision: 0

Ascii ID : 2

Description:

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

File identification

XML Element Name:	FileId
Parent Element:	PtDetail

Field Type:

Nummer

Action Type:

Import und Export

Field Length: 10

Decimal Places: 0

Mandatory Field: Yes

Revision: 0

Ascii ID : 3

Description:

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

Transmission identification

XML Element Name:	TransferId
Parent Element:	PtDetail

Field Type:

Nummer

Action Type:

Import und Export

Field Length: 10

Decimal Places: 0

Mandatory Field: Yes

Revision: 0

Ascii ID : 4

Description:

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

Group identification

XML Element Name:	GroupId
Parent Element:	PtDetail

Field Type:

Nummer

Action Type:

Import und Export

Field Length: 10

Decimal Places: 0

Mandatory Field: Yes

Revision: 0

Ascii ID : 5

Description:

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

Detail identification

XML Element Name:	DetailId
Parent Element:	PtDetail

Field Type:

Nummer

Action Type:

Import und Export

Field Length: 10

Decimal Places: 0

Mandatory Field: Yes

Revision: 0

Ascii ID : 6

Description:

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

Status

XML Element Name:	Status
Parent Element:	PtDetail

Field Type:

Text

Action Type:

Import und Export

Field Length: 1

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : 7

Description:

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

completed

XML Element Name:	BookingDone
Parent Element:	PtDetail

Field Type:

Boolean (true oder false)

Action Type:

Import und Export

Field Length: -

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : 8

Description:

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

Terminal-ID

XML Element Name:	TerminalId
Parent Element:	PtDetail

Field Type:

Text

Action Type:

Import und Export

Field Length: 50

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : 9

Description:

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

Brand-ID

XML Element Name:	BrandId
Parent Element:	PtDetail

Field Type:

Text

Action Type:

Import und Export

Field Length: 40

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : 10

Description:

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

Acquirer designation

XML Element Name:	AcquirerName
Parent Element:	PtDetail

Field Type:

Text

Action Type:

Import und Export

Field Length: 40

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : 11

Description:

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

Value date

XML Element Name:	ValueDate
Parent Element:	PtDetail

Field Type:

Datum (2000-03-20)

Action Type:

Import und Export

Field Length: -

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : 12

Description:

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

Transaction time

XML Element Name:	TransactionDateTime
Parent Element:	PtDetail

Field Type:

Datum/Zeit (2006-08-08T10:16:54.509+02:00)

Action Type:

Import und Export

Field Length: -

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : 13

Description:

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

Transaction-ID

XML Element Name:	TransactionId
Parent Element:	PtDetail

Field Type:

Text

Action Type:

Import und Export

Field Length: 50

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : 14

Description:

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

Transaction text

XML Element Name:	TransactionText
Parent Element:	PtDetail

Field Type:

Text

Action Type:

Import und Export

Field Length: 50

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : 15

Description:

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

Currency

XML Element Name:	Currency
Parent Element:	PtDetail

Field Type:

Text

Action Type:

Import und Export

Field Length: 3

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : 16

Description:

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

Gross amount

XML Element Name:	GrossAmount
Parent Element:	PtDetail

Field Type:

Nummer

Action Type:

Import und Export

Field Length: 14

Decimal Places: 8

Mandatory Field: No

Revision: 0

Ascii ID : 17

Description:

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

Net amount

XML Element Name:	NetAmount
Parent Element:	PtDetail

Field Type:

Nummer

Action Type:

Import und Export

Field Length: 14

Decimal Places: 8

Mandatory Field: No

Revision: 0

Ascii ID : 18

Description:

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

Tip amount

XML Element Name:	TipAmount
Parent Element:	PtDetail

Field Type:

Nummer

Action Type:

Import und Export

Field Length: 14

Decimal Places: 8

Mandatory Field: No

Revision: 0

Ascii ID : 19

Description:

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

Commission amount

XML Element Name:	FeeAmount
Parent Element:	PtDetail

Field Type:

Nummer

Action Type:

Import und Export

Field Length: 14

Decimal Places: 8

Mandatory Field: No

Revision: 0

Ascii ID : 20

Description:

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

Fragment of the credit card number

XML Element Name:	CardNumberFragment
Parent Element:	PtDetail

Field Type:

Text

Action Type:

Import und Export

Field Length: 40

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : 21

Description:

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

Name of credit card holder

XML Element Name:	CardHolderName
Parent Element:	PtDetail

Field Type:

Text

Action Type:

Import und Export

Field Length: 50

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : 22

Description:

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

Original currency

XML Element Name:	OriginalCurrency
Parent Element:	PtDetail

Field Type:

Text

Action Type:

Import und Export

Field Length: 3

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : 23

Description:

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

Amount in original currency

XML Element Name:	OriginalAmount
Parent Element:	PtDetail

Field Type:

Nummer

Action Type:

Import und Export

Field Length: 14

Decimal Places: 8

Mandatory Field: No

Revision: 0

Ascii ID : 24

Description:

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

Rate

XML Element Name:	ExchangeRate
Parent Element:	PtDetail

Field Type:

Nummer

Action Type:

Import und Export

Field Length: 14

Decimal Places: 8

Mandatory Field: No

Revision: 0

Ascii ID : 25

Description:

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

XML Element Name:	OrderNumber
Parent Element:	PtDetail

Field Type:

Nummer

Action Type:

Import und Export

Field Length: 10

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : 26

Description:

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

XML Element Name:	OrderSubNumber
Parent Element:	PtDetail

Field Type:

Nummer

Action Type:

Import und Export

Field Length: 2

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : 27

Description:

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

Source reference

XML Element Name:	SourceReference
Parent Element:	PtDetail

Field Type:

GUID

Action Type:

Import und Export

Field Length: 36

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : 28

Description:

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

Record sources

XML Element Name:	Source
Parent Element:	PtDetail

Field Type:

Text

Action Type:

Import und Export

Field Length: 20

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : 29

Description:

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

Payout-ID

XML Element Name:	PaymentId
Parent Element:	PtDetail

Field Type:

Text

Action Type:

Import und Export

Field Length: 50

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : 30

Description:

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

Payment status

XML Element Name:	PaymentState
Parent Element:	PtDetail

Field Type:

Nummer

Action Type:

Import und Export

Field Length: 2

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : 31

Description:

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

Handler ID

XML Element Name:	MerchantId
Parent Element:	PtDetail

Field Type:

Text

Action Type:

Import und Export

Field Length: 20

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : 32

Description:

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

Handler name

XML Element Name:	MerchantName
Parent Element:	PtDetail

Field Type:

Text

Action Type:

Import und Export

Field Length: 50

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : 33

Description:

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

XML Element Name:	MerchantCategoryCode
Parent Element:	PtDetail