Interface: DEBI - Document prepayments Version 2013.00

This documentation describes the AbaConnect Interface Document prepayments for the DEBI Application.


General Information

General information about the AbaConnect interface.

AbaConnect Interface Information
Application :DEBI
Interface Name :Document prepayments
ID :DocumentAdvancePayment ( 050 )
Version :2013.00
Status:Productive


Displays the possible import and export features for this interface.

Export / Import Modus
Export :XML
Import :No Import


Displays additional information for this interface.

Additional Information
Modifications compared to version 2010.00
Person responsible for visas has been increased from 4 to 10 jobs (int. ->long)
Highest field Revision for this interface : 1



Mapping Information

The following displays the Mapping details for this interface.

Mapping Information
Mapping ID :AbaDefault
Mapping Name :Document prepayments
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"  "-aDEBI"  "-version2013.00"  "-M7777"  "-acidDocumentAdvancePayment"  "-mapidAbaDefault"  "-datamodeXML"  "-responseYES"  "-responsefileX:\response.xml"  "-exportfileX:\data.xml"




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
DocumentAdvancePaymentDocument---Yes
    - DocumentCodeDocument typeDocumentAdvancePaymentText4No
    - CustomerNumberCustomer numberDocumentAdvancePaymentNumber11No
    - NumberDocument numberDocumentAdvancePaymentNumber10Yes
    - ReferenceDocument referenceDocumentAdvancePaymentText60No
    - TextRemarkDocumentAdvancePaymentText60No
    - AccountReceivableDateA/R document dateDocumentAdvancePaymentDate-No
    - GeneralLedgerDateG/L document dateDocumentAdvancePaymentDate-No
    - CurrencyCurrencyDocumentAdvancePaymentText3No
    - AmountDocument amount in DCDocumentAdvancePaymentNumber12No
    - KeyAmountDocument amount in KCDocumentAdvancePaymentNumber12No
    - AmountOIOI amount in DCDocumentAdvancePaymentNumber12No
    - KeyAmountOIOI amount in KCDocumentAdvancePaymentNumber12No
    - BusinessCaseBusiness caseDocumentAdvancePaymentNumber8No
    - DivisionDivisionDocumentAdvancePaymentNumber6No
    - PersonInChargePerson in chargeDocumentAdvancePaymentNumber10No
    - CostGroupCost groupDocumentAdvancePaymentNumber8No
    - ReminderAreaReminder rangeDocumentAdvancePaymentNumber6No
    - ReminderProcedureReminder procedureDocumentAdvancePaymentText4No
    - GroupNumber1Free Number 1DocumentAdvancePaymentNumber10No
    - PaymentOrderProcedurePayment procedureDocumentAdvancePaymentNumber4No
    - DebitAccountDebit accountDocumentAdvancePaymentNumber11No
    - DebitCostCentre1Debit CC1DocumentAdvancePaymentNumber11No
    - DebitCostCentre2Debit CC2DocumentAdvancePaymentNumber11No
    - CreditAccountCredit accountDocumentAdvancePaymentNumber12No
    - CreditCostCentre1Credit CC1DocumentAdvancePaymentNumber12No
    - CreditCostCentre2Credit CC2DocumentAdvancePaymentNumber12No
    - TaxCodeVAT codeDocumentAdvancePaymentText3No
    - StatusIdentificationDocument statusDocumentAdvancePaymentAbaCon Enum1No
    - ContractualRelationShipNumberContractual relationshipDocumentAdvancePaymentNumber12No
    - ChargingTypeREMS offsetting typeDocumentAdvancePaymentNumber2No



Field Information

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

Document type
XML Element Name:DocumentCode
Parent Element:DocumentAdvancePayment
Field Type:Text
Action Type:Export only
Field Length:   4Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Document type		
(The internal field ID for this element is "Belegart")

Customer number
XML Element Name:CustomerNumber
Parent Element:DocumentAdvancePayment
Field Type:Nummer
Action Type:Export only
Field Length:   11Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Customer number
(The internal field ID for this element is "Kundennummer")

Document number
XML Element Name:Number
Parent Element:DocumentAdvancePayment
Field Type:Nummer
Action Type:Export only
Field Length:   10Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   -
Description:
Document number
(The internal field ID for this element is "Belegnummer")

Document reference
XML Element Name:Reference
Parent Element:DocumentAdvancePayment
Field Type:Text
Action Type:Export only
Field Length:   60Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Document reference
(The internal field ID for this element is "Belegreferenz")

Remark
XML Element Name:Text
Parent Element:DocumentAdvancePayment
Field Type:Text
Action Type:Export only
Field Length:   60Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Remark
(The internal field ID for this element is "Bemerkung")

A/R document date
XML Element Name:AccountReceivableDate
Parent Element:DocumentAdvancePayment
Field Type:Datum (2000-03-20)
Action Type:Export only
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
A/R document date
(The internal field ID for this element is "Debidatum")

G/L document date
XML Element Name:GeneralLedgerDate
Parent Element:DocumentAdvancePayment
Field Type:Datum (2000-03-20)
Action Type:Export only
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
G/L document date
(The internal field ID for this element is "Fibudatum")

Currency
XML Element Name:Currency
Parent Element:DocumentAdvancePayment
Field Type:Text
Action Type:Export only
Field Length:   3Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Currency
(The internal field ID for this element is "Waehrung")

Document amount in DC
XML Element Name:Amount
Parent Element:DocumentAdvancePayment
Field Type:Nummer
Action Type:Export only
Field Length:   12Decimal Places:   2Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
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.

Document amount in KC
XML Element Name:KeyAmount
Parent Element:DocumentAdvancePayment
Field Type:Nummer
Action Type:Export only
Field Length:   12Decimal Places:   2Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
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.

OI amount in DC
XML Element Name:AmountOI
Parent Element:DocumentAdvancePayment
Field Type:Nummer
Action Type:Export only
Field Length:   12Decimal Places:   2Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Open amount in document currency
(The internal field ID for this element is "BwOp")
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.

OI amount in KC
XML Element Name:KeyAmountOI
Parent Element:DocumentAdvancePayment
Field Type:Nummer
Action Type:Export only
Field Length:   12Decimal Places:   2Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Open amount in key currency
(The internal field ID for this element is "LwOp")
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.

Business case
XML Element Name:BusinessCase
Parent Element:DocumentAdvancePayment
Field Type:Nummer
Action Type:Export only
Field Length:   8Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Business case number
(The internal field ID for this element is "Geschaeftsfall")

Division
XML Element Name:Division
Parent Element:DocumentAdvancePayment
Field Type:Nummer
Action Type:Export only
Field Length:   6Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Division	
(The internal field ID for this element is "Geschaeftsbereich")

Person in charge
XML Element Name:PersonInCharge
Parent Element:DocumentAdvancePayment
Field Type:Nummer
Action Type:Export only
Field Length:   10Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Person in charge
(The internal field ID for this element is "Verantwortlicher")

Cost group
XML Element Name:CostGroup
Parent Element:DocumentAdvancePayment
Field Type:Nummer
Action Type:Export only
Field Length:   8Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Cost group
(The internal field ID for this element is "Kostengruppe")

Reminder range
XML Element Name:ReminderArea
Parent Element:DocumentAdvancePayment
Field Type:Nummer
Action Type:Export only
Field Length:   6Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Reminder range
(The internal field ID for this element is "Mahnbereich")

Reminder procedure
XML Element Name:ReminderProcedure
Parent Element:DocumentAdvancePayment
Field Type:Text
Action Type:Export only
Field Length:   4Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Reminder procedure
(The internal field ID for this element is "Mahnverfahren")

Free Number 1
XML Element Name:GroupNumber1
Parent Element:DocumentAdvancePayment
Field Type:Nummer
Action Type:Export only
Field Length:   10Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Free document group 1
(The internal field ID for this element is "Beleggruppe1")

Payment procedure
XML Element Name:PaymentOrderProcedure
Parent Element:DocumentAdvancePayment
Field Type:Nummer
Action Type:Export only
Field Length:   4Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Payment procedure
(The internal field ID for this element is "VesrVerfahren")

Debit account
XML Element Name:DebitAccount
Parent Element:DocumentAdvancePayment
Field Type:Nummer
Action Type:Export only
Field Length:   11Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Debit CC1
XML Element Name:DebitCostCentre1
Parent Element:DocumentAdvancePayment
Field Type:Nummer
Action Type:Export only
Field Length:   11Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Debit CC2
XML Element Name:DebitCostCentre2
Parent Element:DocumentAdvancePayment
Field Type:Nummer
Action Type:Export only
Field Length:   11Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Credit account
XML Element Name:CreditAccount
Parent Element:DocumentAdvancePayment
Field Type:Nummer
Action Type:Export only
Field Length:   12Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Credit CC1
XML Element Name:CreditCostCentre1
Parent Element:DocumentAdvancePayment
Field Type:Nummer
Action Type:Export only
Field Length:   12Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Credit CC2
XML Element Name:CreditCostCentre2
Parent Element:DocumentAdvancePayment
Field Type:Nummer
Action Type:Export only
Field Length:   12Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

VAT code
XML Element Name:TaxCode
Parent Element:DocumentAdvancePayment
Field Type:Text
Action Type:Export only
Field Length:   3Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Document status
XML Element Name:StatusIdentification
Parent Element:DocumentAdvancePayment
Field Type:AbaConnect Enum
Action Type:Export only
Field Length:   1Decimal Places:   0Mandatory Field:   NoRevision:   1Ascii ID :   -
Description:
1=Open
5=Neutralised
6=Cancelled
7=Completed
9=Blocked
(The internal field ID for this element is "Status")

Contractual relationship
XML Element Name:ContractualRelationShipNumber
Parent Element:DocumentAdvancePayment
Field Type:Nummer
Action Type:Export only
Field Length:   12Decimal Places:   0Mandatory Field:   NoRevision:   1Ascii ID :   -
Description:

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

REMS offsetting type
XML Element Name:ChargingType
Parent Element:DocumentAdvancePayment
Field Type:Nummer
Action Type:Export only
Field Length:   2Decimal Places:   0Mandatory Field:   NoRevision:   1Ascii ID :   -
Description:

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