Interface: DEBI - Customer balances Version 2010.00

This documentation describes the AbaConnect Interface Customer balances for the DEBI Application.


General Information

General information about the AbaConnect interface.

AbaConnect Interface Information
Application :DEBI
Interface Name :Customer balances
ID :CustomerBalance ( 050 )
Version :2010.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

                                  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 :Customer balances
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"  "-version2010.00"  "-M7777"  "-acidCustomerBalance"  "-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
CustomerBalanceCustomer balances---Yes
    - CodeNameShort nameCustomerBalanceText16No
    - CustomerNumberCustomer numberCustomerBalanceNumber11Yes
    - KeyAmountOITotal OI in key currencyCustomerBalanceNumber12No
    - NumberOfOITotal number of OICustomerBalanceNumber8No
    - AdvancePaymentKeyAmountOITotal advance payment OI in key currencyCustomerBalanceNumber12No
    CurrencyDataSub-element currenciesCustomerBalance--Yes
        - CurrencyCurrency - IdentificationCurrencyDataText3Yes
        - AmountOIOI portion of the currency in document currencyCurrencyDataNumber12No
        - KeyAmountOIOI portion of the currency in key currencyCurrencyDataNumber12No
        - NumberOfOIOI number portion of currencyCurrencyDataNumber8No
        - AdvancePaymentAmountOIAdvance payment OI portion of the currency in document currencyCurrencyDataNumber12No
        - AdvancePaymentKeyAmountOIAdvance payment OI portion of the currency in key currencyCurrencyDataNumber12No



Field Information

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

Short name
XML Element Name:CodeName
Parent Element:CustomerBalance
Field Type:Text
Action Type:Export only
Field Length:   16Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Customer short name
(The internal field ID for this element is "Kurzname")

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

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

Total number of OI
XML Element Name:NumberOfOI
Parent Element:CustomerBalance
Field Type:Nummer
Action Type:Export only
Field Length:   8Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Total number of open items for the customer
(The internal field ID for this element is "OP_Anzahl")

Total advance payment OI in key currency
XML Element Name:AdvancePaymentKeyAmountOI
Parent Element:CustomerBalance
Field Type:Nummer
Action Type:Export only
Field Length:   12Decimal Places:   2Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Total advance payment open items balance of the customer in key currency of the client
(The internal field ID for this element is "VZOP_Betrag_LW")
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.

Sub-element currencies
XML Element Name:CurrencyData
Parent Element:CustomerBalance
Field Type:ID
Action Type:Export only
Field Length:   -Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   -
Description:

                

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

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

OI portion of the currency in key currency
XML Element Name:KeyAmountOI
Parent Element:CurrencyData
Field Type:Nummer
Action Type:Export only
Field Length:   12Decimal Places:   2Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Advance payment open items balance - customer portion in key currency of the client
(The internal field ID for this element is "OP_Betrag_LW")
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.

OI number portion of currency
XML Element Name:NumberOfOI
Parent Element:CurrencyData
Field Type:Nummer
Action Type:Export only
Field Length:   8Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Open items balance - customer portion in respective currency
(The internal field ID for this element is "OP_Anzahl")

Advance payment OI portion of the currency in document currency
XML Element Name:AdvancePaymentAmountOI
Parent Element:CurrencyData
Field Type:Nummer
Action Type:Export only
Field Length:   12Decimal Places:   2Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Advance payment open items balance - customer portion in respective currency
(The internal field ID for this element is "VZOP_Betrag_BW")
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.

Advance payment OI portion of the currency in key currency
XML Element Name:AdvancePaymentKeyAmountOI
Parent Element:CurrencyData
Field Type:Nummer
Action Type:Export only
Field Length:   12Decimal Places:   2Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Advance payment open items balance - customer portion in respective key currency
(The internal field ID for this element is "VZOP_Betrag_LW")
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.