Interface:
DEBI
-
Payments
Version
2011.00
This documentation describes the AbaConnect Interface
Payments
for the
DEBI
Application.
General Information
General information about the AbaConnect interface.
| AbaConnect Interface Information |
| Application : | DEBI |
| Interface Name : | Payments |
| ID : | Zahlungen
(
100
)
|
| Version : | 2011.00 |
| Status: | Productive |
Displays the possible import and export features for this interface.
Displays additional information for this interface.
Modifications compared to version 2007.10
Payment text has been expanded from 30 to 80 characters.
Highest field Revision for this interface : 0 |
Mapping Information
The following displays the Mapping details for this interface.
| Mapping ID : | AbaZahlungen |
| 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>DEBI</Application>
<Id>Zahlungen</Id>
<MapId>AbaZahlungen</MapId>
<Version>2011.00</Version>
<!-- Attention : The client number (Mandant) is optional and implies that the data can only be imported into specified client (Mandant) -->
<!-- The Client Option (Mandant) only has an influence when importing data. It can be configured in the AbaConnect Export Settings. -->
<!-- By default, the client number (Mandant) is not written to the export file -->
<Mandant>7777</Mandant>
</Parameter>
<Transaction>
<Payment mode='SAVE'>
<!-- The specific data fields for the AbaConnect interface are included here. -->
</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"
"-aDEBI"
"-version2011.00"
"-M7777"
"-acidZahlungen"
"-mapidAbaZahlungen"
"-datamodeXML"
"-responseYES"
"-responsefileX:\response.xml"
"-exportfileX:\data.xml"
Import :
abaconnectimportconsole.exe "/USRuser" "/PWxxx"
"-aDEBI"
"-version2011.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.
Field Information
The following is a detailed description of the fields used in this interface.
| Field Type: | AbaConnect Enum |
| Action Type: | Import und Export |
| Field Length:
2 | Decimal Places:
0 | Mandatory Field:
Yes | Revision:
0 | Ascii ID :
- |
| Description: |
Payment type; the payment type determines which type of payment should be entered. The following types are allowed: 0 = Payment 2 = Advance payments 3 = Offsettings (settlements) 4 = Reductions
(The internal field ID for this element is "Zahlungstyp")
|
| Action Type: | Import und Export |
| Field Length:
4 | Decimal Places:
0 | Mandatory Field:
Yes | Revision:
0 | Ascii ID :
- |
| Description: |
Payment code; the payment code must already exist and be allowed on the basis of the payment type.
(The internal field ID for this element is "Zahlungsart")
|
| Action Type: | Import und Export |
| Field Length:
11 | Decimal Places:
0 | Mandatory Field:
Yes | Revision:
0 | Ascii ID :
- |
| Description: |
Customer number; the customer number must already exist
(The internal field ID for this element is "Kundennummer")
|
| Action Type: | Import und Export |
| Field Length:
10 | Decimal Places:
0 | Mandatory Field:
Yes | Revision:
0 | Ascii ID :
- |
| Description: |
Document number; the document number must already exist, exception: New entry of an advance payment. It must be unique, and it is possible to enter 0
(The internal field ID for this element is "Belegnummer")
|
| XML Element Name: | Number |
| Parent Element: | Payment |
| Action Type: | Import und Export |
| Field Length:
6 | Decimal Places:
0 | Mandatory Field:
Yes | Revision:
0 | Ascii ID :
- |
| Description: |
Payment item number, must be unique and sequential, it is also possible to enter 0
(The internal field ID for this element is "Zahlungsposition")
|
| Field Length:
60 | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
- |
| Description: |
Unique reference, required for replies if no fixed payment item number is specified
(The internal field ID for this element is "Unique_Referenz")
|
| XML Element Name: | Text |
| Parent Element: | Payment |
| Action Type: | Import und Export |
| Field Length:
80 | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
- |
| Description: |
Remark
(The internal field ID for this element is "Text")
|
| Field Type: | Datum (2000-03-20) |
| Action Type: | Import und Export |
| Field Length:
- | Decimal Places:
0 | Mandatory Field:
Yes | Revision:
0 | Ascii ID :
- |
| Description: |
Payment date, must lie within an open financial year
(The internal field ID for this element is "Zahlungsdatum")
|
| XML Element Name: | ValueDate |
| Parent Element: | Payment |
| Field Type: | Datum (2000-03-20) |
| Action Type: | Import und Export |
| Field Length:
- | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
- |
| Description: |
Value date, of informative character only in A/R
(The internal field ID for this element is "Valutadatum")
|
| Action Type: | Import und Export |
| Field Length:
6 | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
- |
| Description: |
Number of the company payment centre, mandatory for payment type 'Payment' and 'Advance payment'
(The internal field ID for this element is "Firmenzahlstelle")
|
| Field Length:
3 | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
- |
| Description: |
Payment currency in a broader sense: If there is a company payment centre, it is the actual company payment centre currency, otherwise the document currency
(The internal field ID for this element is "Zahlungswaehrung")
|
| Action Type: | Import und Export |
| Field Length:
12 | Decimal Places:
2 | Mandatory Field:
No | Revision:
0 | Ascii ID :
- |
| Description: |
Payment amount in payment currency (see also field 'Payment currency')
(The internal field ID for this element is "ZwBtr")
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.
|
| XML Element Name: | Amount |
| Parent Element: | Payment |
| Action Type: | Import und Export |
| Field Length:
12 | Decimal Places:
2 | Mandatory Field:
No | Revision:
0 | Ascii ID :
- |
| Description: |
Payment amount in document currency
(The internal field ID for this element is "BwBtr")
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.
|
| XML Element Name: | KeyAmount |
| Parent Element: | Payment |
| Action Type: | Import und Export |
| Field Length:
12 | Decimal Places:
2 | Mandatory Field:
Yes | Revision:
0 | Ascii ID :
- |
| Description: |
Payment amount in key currency
(The internal field ID for this element is "LwBtr")
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.
|
| Action Type: | Import und Export |
| Field Length:
6 | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
- |
| Description: |
Payment document number (mandatory if activated in company master data)
(The internal field ID for this element is "Zahlungsbelegnummer")
|
| Action Type: | Import und Export |
| Field Length:
10 | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
- |
| Description: |
Number of the offsetting documents, mandatory for payments of type 'Offsetting' (settlement)
(The internal field ID for this element is "Verrechnungsbeleg")
|
| Action Type: | Import und Export |
| Field Length:
11 | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
- |
| Description: |
Debit account; if the General Ledger is installed, the account must already exist
(The internal field ID for this element is "Sollkonto")
|
| Action Type: | Import und Export |
| Field Length:
11 | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
- |
| Description: |
Debit cost centre 1; if the General Ledger is installed, the cost centre must already exist
(The internal field ID for this element is "Sollkst1")
|
| Action Type: | Import und Export |
| Field Length:
11 | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
- |
| Description: |
Debit cost centre 2; if the General Ledger is installed, the cost centre must already exist
(The internal field ID for this element is "Sollkst2")
|
| XML Element Name: | TaxCode |
| Parent Element: | Payment |
| Action Type: | Import und Export |
| Field Length:
3 | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
- |
| Description: |
VAT code; mandatory with payment type 'Advance payment' if there is a VAT liability on the basis of the client definition and the payment date
(The internal field ID for this element is "MwstCode")
|
| Field Type: | Datum (2000-03-20) |
| Action Type: | Import und Export |
| Field Length:
- | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
- |
| Description: |
VAT validity date for the advance payment, only for payment type 'Advance payment'
(The internal field ID for this element is "MwstPer")
|
| Action Type: | Import und Export |
| Field Length:
11 | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
- |
| Description: |
Credit account; if the General Ledger is installed, the account must already exist, only with payment type 'Advance payment'
(The internal field ID for this element is "Habenkonto")
|
| Action Type: | Import und Export |
| Field Length:
11 | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
- |
| Description: |
Credit cost centre 1; if the General Ledger is installed, the cost centre must already exist, only with payment type 'Advance payment'
(The internal field ID for this element is "Habenkst1")
|
| Action Type: | Import und Export |
| Field Length:
11 | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
- |
| Description: |
Credit cost centre 2; if the General Ledger is installed, the cost centre must already exist, only with payment type 'Advance payment'
(The internal field ID for this element is "Habenkst2")
|
| XML Element Name: | Division |
| Parent Element: | Payment |
| Action Type: | Import und Export |
| Field Length:
6 | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
- |
| Description: |
Business area; the business area must already exist, only with payment type 'Advance payment'
(The internal field ID for this element is "Geschaeftsbereich")
|
| Action Type: | Import und Export |
| Field Length:
8 | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
- |
| Description: |
Business case number only with payment type 'Advance payment'
(The internal field ID for this element is "Geschaeftsfall")
|
| XML Element Name: | CostGroup |
| Parent Element: | Payment |
| Action Type: | Import und Export |
| Field Length:
8 | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
- |
| Description: |
The cost group must already exist, only with payment type 'Advance payment'
(The internal field ID for this element is "Kostengruppe")
|
| Action Type: | Import und Export |
| Field Length:
4 | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
- |
| Description: |
Responsible person; the responsible person must already exist, only with payment type 'Advance payment'
(The internal field ID for this element is "Verantwortlicher")
|
| Action Type: | Import und Export |
| Field Length:
10 | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
- |
| Description: |
Free document group 1; the free document group must already exist in the company base, depending on the definition, only with payment type 'Advance payment'
(The internal field ID for this element is "Beleggruppe1")
|
| Action Type: | Import und Export |
| Field Length:
6 | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
- |
| Description: |
Reminder area; the reminder area must already exist, only with payment type 'Advance payment'
(The internal field ID for this element is "Mahnbereich")
|
| Action Type: | Import und Export |
| Field Length:
4 | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
- |
| Description: |
Reminder procedure; the reminder procedure must already exist, only with payment type 'Advance payment'
(The internal field ID for this element is "Mahnverfahren")
|
| Action Type: | Import und Export |
| Field Length:
1 | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
- |
| Description: |
G/L code only with payment type 'Advance payment'
(The internal field ID for this element is "FibuCode")
|
| Field Type: | Boolean (true oder false) |
| Field Length:
- | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
- |
| Description: |
Processing instruction for multiple processings within a transaction: if "false", the processing is aborted immediately at the first error and the remaining processings no longer validated.
(The internal field ID for this element is "ContinueOnError")
|