Interface: FIBU - Extended Budgeting Version 2022.00

This documentation describes the AbaConnect Interface Extended Budgeting for the FIBU Application.


General Information

General information about the AbaConnect interface.

AbaConnect Interface Information
Application :FIBU
Interface Name :Extended Budgeting
ID :ExtendedBudgeting ( Saldozahlen )
Version :2022.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 :Extended Budgeting
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>FIBU</Application>
      <Id>ExtendedBudgeting</Id>
      <MapId>AbaDefault</MapId>
      <Version>2022.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>
      <Detail mode='SAVE'>
          <!-- The specific data fields for the AbaConnect interface are included here. -->
      </Detail>
    </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"  "-aFIBU"  "-version2022.00"  "-M7777"  "-acidExtendedBudgeting"  "-mapidAbaDefault"  "-datamodeXML"  "-responseYES"  "-responsefileX:\response.xml"  "-exportfileX:\data.xml"

Import :
abaconnectimportconsole.exe "/USRuser" "/PWxxx"  "-aFIBU"  "-version2022.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
DetailExtended Budgeting---No
    MonthMonthDetail--No
        - YearYearMonthNumber4No
        MonthMonthMonth--No
            - YearYearMonthNumber4No
            - DebitBalanceDebit balanceMonthNumber14No
            - CreditBalanceCredit balanceMonthNumber14No
        - DebitBalanceDebit balanceMonthNumber14No
        - CreditBalanceCredit balanceMonthNumber14No
    - YearYearDetailNumber4No
    - VariantNumberBudget variant no.DetailNumber6No
    - InstanceNumberInstanceDetailNumber2No
    - DivisionDivisionDetailNumber6No
    - AccountAccountDetailNumber12No
    - CostCentre1Cost centre 1DetailNumber12No
    - CostCentre2Cost centre 2DetailNumber12No
    - DetailTypeDetail typeDetailNumber2No
    - DetailNumberDetail budget item numberDetailNumber4No
    - DesignationDesignationDetailText90No
    - AnnualTotalDebitDebit annual totalDetailNumber14No
    - AnnualTotalCreditCredit annual totalDetailNumber14No
    - AnnualTotalFactorAnnual total factorDetailNumber12No
    - AnnualTotalRateAnnual total rateDetailNumber10No
    - AnnualTotalNumberAnnual total numberDetailNumber10No
    - FreeIndexASCIIFree Index ASCIIDetailText20No
    - FreeIndexNumericalFree Index NumericalDetailNumber10No
    - UserUserDetailGUID36No
    - EntryModificationDateEntry / modification dateDetailDate-No
    - OneTimeOne-time budget itemDetailNumber2No
    - NewExpenditureNew expenditureDetailNumber2No
    - AutomaticallyGeneratedAutomaticallyDetailNumber2No
    - NoteNoteDetailText4032No
    - DetailNoteDetail noteDetailText4032No
    - PolicyMeasureDetailText6No
    - PolicyTypeMeasure typeDetailText3No
    - OverchargeAllowedOverbooking allowedDetailBoolean-No
    - ReservedBound budget itemsDetailBoolean-No



Field Information

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

Month
XML Element Name:Month
Parent Element:Detail
Field Type:ID
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                

Year
XML Element Name:Year
Parent Element:Month
Field Type:Nummer
Action Type:Import und Export
Field Length:   4Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Month
XML Element Name:Month
Parent Element:Month
Field Type:Nummer
Action Type:Import und Export
Field Length:   2Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Debit balance
XML Element Name:DebitBalance
Parent Element:Month
Field Type:Nummer
Action Type:Import und Export
Field Length:   14Decimal Places:   2Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Credit balance
XML Element Name:CreditBalance
Parent Element:Month
Field Type:Nummer
Action Type:Import und Export
Field Length:   14Decimal Places:   2Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Year
XML Element Name:Year
Parent Element:Detail
Field Type:Nummer
Action Type:Import und Export
Field Length:   4Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Budget variant no.
XML Element Name:VariantNumber
Parent Element:Detail
Field Type:Nummer
Action Type:Import und Export
Field Length:   6Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Instance
XML Element Name:InstanceNumber
Parent Element:Detail
Field Type:Nummer
Action Type:Import und Export
Field Length:   2Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Division
XML Element Name:Division
Parent Element:Detail
Field Type:Nummer
Action Type:Import und Export
Field Length:   6Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Account
XML Element Name:Account
Parent Element:Detail
Field Type:Nummer
Action Type:Import und Export
Field Length:   12Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Cost centre 1
XML Element Name:CostCentre1
Parent Element:Detail
Field Type:Nummer
Action Type:Import und Export
Field Length:   12Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Cost centre 2
XML Element Name:CostCentre2
Parent Element:Detail
Field Type:Nummer
Action Type:Import und Export
Field Length:   12Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Detail type
XML Element Name:DetailType
Parent Element:Detail
Field Type:Nummer
Action Type:Import und Export
Field Length:   2Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Detail budget item number
XML Element Name:DetailNumber
Parent Element:Detail
Field Type:Nummer
Action Type:Import und Export
Field Length:   4Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Designation
XML Element Name:Designation
Parent Element:Detail
Field Type:Text
Action Type:Import und Export
Field Length:   90Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Debit annual total
XML Element Name:AnnualTotalDebit
Parent Element:Detail
Field Type:Nummer
Action Type:Import und Export
Field Length:   14Decimal Places:   2Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Credit annual total
XML Element Name:AnnualTotalCredit
Parent Element:Detail
Field Type:Nummer
Action Type:Import und Export
Field Length:   14Decimal Places:   2Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Annual total factor
XML Element Name:AnnualTotalFactor
Parent Element:Detail
Field Type:Nummer
Action Type:Import und Export
Field Length:   12Decimal Places:   4Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Annual total rate
XML Element Name:AnnualTotalRate
Parent Element:Detail
Field Type:Nummer
Action Type:Import und Export
Field Length:   10Decimal Places:   4Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Annual total number
XML Element Name:AnnualTotalNumber
Parent Element:Detail
Field Type:Nummer
Action Type:Import und Export
Field Length:   10Decimal Places:   4Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Free Index ASCII
XML Element Name:FreeIndexASCII
Parent Element:Detail
Field Type:Text
Action Type:Import und Export
Field Length:   20Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Free Index Numerical
XML Element Name:FreeIndexNumerical
Parent Element:Detail
Field Type:Nummer
Action Type:Import und Export
Field Length:   10Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

User
XML Element Name:User
Parent Element:Detail
Field Type:GUID
Action Type:Export only
Field Length:   36Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Entry / modification date
XML Element Name:EntryModificationDate
Parent Element:Detail
Field Type:Datum (2000-03-20)
Action Type:Export only
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

One-time budget item
XML Element Name:OneTime
Parent Element:Detail
Field Type:Nummer
Action Type:Import und Export
Field Length:   2Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

New expenditure
XML Element Name:NewExpenditure
Parent Element:Detail
Field Type:Nummer
Action Type:Import und Export
Field Length:   2Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Automatically
XML Element Name:AutomaticallyGenerated
Parent Element:Detail
Field Type:Nummer
Action Type:Export only
Field Length:   2Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Note
XML Element Name:Note
Parent Element:Detail
Field Type:Text
Action Type:Import und Export
Field Length:   4032Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Detail note
XML Element Name:DetailNote
Parent Element:Detail
Field Type:Text
Action Type:Import und Export
Field Length:   4032Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Measure
XML Element Name:Policy
Parent Element:Detail
Field Type:Text
Action Type:Import und Export
Field Length:   6Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   2
Description:

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

Measure type
XML Element Name:PolicyType
Parent Element:Detail
Field Type:Text
Action Type:Import und Export
Field Length:   3Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   3
Description:

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

Overbooking allowed
XML Element Name:OverchargeAllowed
Parent Element:Detail
Field Type:Boolean (true oder false)
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   4
Description:

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

Bound budget items
XML Element Name:Reserved
Parent Element:Detail
Field Type:Boolean (true oder false)
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   5
Description:

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