Interface: DEBI - Auxiliary accounts Version 2011.00

This documentation describes the AbaConnect Interface Auxiliary accounts for the DEBI Application.


General Information

General information about the AbaConnect interface.

AbaConnect Interface Information
Application :DEBI
Interface Name :Auxiliary accounts
ID :AuxiliaryAccounts ( 300 )
Version :2011.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 :Account assignment proposals
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>AuxiliaryAccounts</Id>
      <MapId>AbaDefault</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>
      <AccountProposal mode='SAVE'>
          <!-- The specific data fields for the AbaConnect interface are included here. -->
      </AccountProposal>
    </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"  "-acidAuxiliaryAccounts"  "-mapidAbaDefault"  "-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.

XML Element Name Field Name Parent Name Type Length Mandatory
+ AccountProposalAccountProposal---Yes
    - ValidFromvalid fromAccountProposalDate-Yes
    - CurrencyCurrencyAccountProposalText3Yes
    - EnterpriseEnterpriseAccountProposalNumber6Yes
    - DivisionDivisionAccountProposalNumber8Yes
    - IntercompanyIntercompanyAccountProposalBoolean-Yes
    + AccountElementAccount allocation elementsAccountProposal--Yes
        - AccountIdentificationIdentification account allocation elementAccountElementAbaCon Enum3Yes
        - AccountIdentificationDesignationDesignation of acct assignment elementAccountElementText60No
        - AccountAccount numberAccountElementNumber11Yes
        - AccountDesignationAccount nameAccountElementText60No
        - CostCentre1Cost centre 1 numberAccountElementNumber11Yes
        - CostCentre1DesignationCost centre 1 nameAccountElementText60No
        - CostCentre2Cost centre 2 numberAccountElementNumber11Yes
        - CostCentre2DesignationCost centre 2 nameAccountElementText60No



Field Information

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

valid from
XML Element Name:ValidFrom
Parent Element:AccountProposal
Field Type:Datum (2000-03-20)
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   -
Description:
Account allocation proposal is valid from ...
(The internal field ID for this element is "Datum")

Currency
XML Element Name:Currency
Parent Element:AccountProposal
Field Type:Text
Action Type:Import und Export
Field Length:   3Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   -
Description:
Currency identification, the currency must already exist
(The internal field ID for this element is "Waehrung")

Enterprise
XML Element Name:Enterprise
Parent Element:AccountProposal
Field Type:Nummer
Action Type:Import und Export
Field Length:   6Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   -
Description:
Enterprise, the enterprise must already exist
(The internal field ID for this element is "Enterprise")

Division
XML Element Name:Division
Parent Element:AccountProposal
Field Type:Nummer
Action Type:Import und Export
Field Length:   8Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   -
Description:
Division, the division must already exist
(The internal field ID for this element is "Geschaeftsbereich")

Intercompany
XML Element Name:Intercompany
Parent Element:AccountProposal
Field Type:Boolean (true oder false)
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   -
Description:
Valid for intercompany transactions only
(The internal field ID for this element is "Intercompany")

Account allocation elements
XML Element Name:AccountElement
Parent Element:AccountProposal
Field Type:Array List
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   -
Description:
Sub-elements of acct assignment element for this acct assignment proposal
For a new entry, every account type must be specified once!
(The internal field ID for this element is "Kontierungselemente")

Identification account allocation element
XML Element Name:AccountIdentification
Parent Element:AccountElement
Field Type:AbaConnect Enum
Action Type:Import und Export
Field Length:   3Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   -
Description:
Identification for this acct assignment element:
1 = Auxiliary account G/L
2 = Offsetting of collective payments
3 = Offsetting of credit notes
4 = Offsetting of advance payments
5 = ICN offsetting of documents
6 = ICN offsetting of receipts
7 = ICN offsetting of revenue reductions
8 = FC against FC
9 = Auxiliary account rebooking
10 = Auxiliary account collected Money
11 = Auxiliary account collected Debtors
(The internal field ID for this element is "KontoIdentifikation")

Designation of acct assignment element
XML Element Name:AccountIdentificationDesignation
Parent Element:AccountElement
Field Type:Text
Action Type:Export only
Field Length:   60Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Designation for this acct assignment element (only for export)
(The internal field ID for this element is "KontoIdentifikationBezeichnung")

Account number
XML Element Name:Account
Parent Element:AccountElement
Field Type:Nummer
Action Type:Import und Export
Field Length:   11Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   -
Description:
Account number, if the General Ledger is installed, the account must already exist
(The internal field ID for this element is "Konto")

Account name
XML Element Name:AccountDesignation
Parent Element:AccountElement
Field Type:Text
Action Type:Export only
Field Length:   60Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Account name (only for export)
(The internal field ID for this element is "KontoBezeichnung")

Cost centre 1 number
XML Element Name:CostCentre1
Parent Element:AccountElement
Field Type:Nummer
Action Type:Import und Export
Field Length:   11Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   -
Description:
Cost centre 1 number, if the General Ledger is installed, the cost centre must already exist
(The internal field ID for this element is "Kostenstelle1")

Cost centre 1 name
XML Element Name:CostCentre1Designation
Parent Element:AccountElement
Field Type:Text
Action Type:Export only
Field Length:   60Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Cost centre 1 name (only for export)
(The internal field ID for this element is "Kostenstelle1Bezeichnung")

Cost centre 2 number
XML Element Name:CostCentre2
Parent Element:AccountElement
Field Type:Nummer
Action Type:Import und Export
Field Length:   11Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   -
Description:
Cost centre 2 number, if the General Ledger is installed, the cost centre must already exist
(The internal field ID for this element is "Kostenstelle2")

Cost centre 2 name
XML Element Name:CostCentre2Designation
Parent Element:AccountElement
Field Type:Text
Action Type:Export only
Field Length:   60Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Cost centre 2 name (only for export)
(The internal field ID for this element is "Kostenstelle2Bezeichnung")