Interface: DF - Tax codes Version 2017.00

This documentation describes the AbaConnect Interface Tax codes for the DF Application.


General Information

General information about the AbaConnect interface.

AbaConnect Interface Information
Application :DF
Interface Name :Tax codes
ID :MwstCodes ( Stammdaten )
Version :2017.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 :Tax codes
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>DF</Application>
      <Id>MwstCodes</Id>
      <MapId>AbaDefault</MapId>
      <Version>2017.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>
      <TaxData mode='SAVE'>
          <!-- The specific data fields for the AbaConnect interface are included here. -->
      </TaxData>
    </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"  "-aDF"  "-version2017.00"  "-M7777"  "-acidMwstCodes"  "-mapidAbaDefault"  "-datamodeXML"  "-responseYES"  "-responsefileX:\response.xml"  "-exportfileX:\data.xml"

Import :
abaconnectimportconsole.exe "/USRuser" "/PWxxx"  "-aDF"  "-version2017.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
TaxDataVAT data---Yes
    - CodeCodeTaxDataText3Yes
    - CountryCountryTaxDataText3Yes
    DesignationDataDesignation dataTaxData--No
        - DesignationDesignationDesignationDataText50Yes
        - LanguageLanguageDesignationDataText6Yes
    - FlatRateCodeFlat rate codeTaxDataNumber2No
    - FormNumberForm numberTaxDataNumber4No
    - FormNumber2010Form number 2010TaxDataNumber4No
    - FormNumber2010AForm number 2010ATaxDataNumber4No
    - IdTax code identificationTaxDataText15No
    - InclusiveInclusiveTaxDataNumber1No
    - OptedOptedTaxDataNumber2No
    - ProposalIncludedExcludedIncl./excl. proposalTaxDataText1No
    RangeDataRange dataTaxData--Yes
        - AccountAccountRangeDataNumber11No
        - Account2Contra accountRangeDataNumber11No
        - Account2DesignationContra account designationRangeDataText100No
        - AccountDesignationAccount designationRangeDataText100No
        EnterpriseDataCompany dataRangeData--No
            - AccountAccountEnterpriseDataNumber11Yes
            - Account2Contra accountEnterpriseDataNumber11Yes
            - Account2DesignationContra account designationEnterpriseDataText100No
            - AccountDesignationAccount designationEnterpriseDataText100No
            - EnterpriseCompany numberEnterpriseDataNumber8Yes
        - FlatRateFlat rateRangeDataNumber4Yes
        - TAXKEYDatev tax keyRangeDataNumber4No
        - TaxLiabilityVAT liabilityRangeDataNumber4Yes
        - TaxRateTax rateRangeDataNumber4Yes
        - ValidFromValid fromRangeDataDate-Yes
    - SubsequenceCodeSubsequent codeTaxDataText3No
    - TypeTypeTaxDataNumber1No
    - UseCodeTurnover typeTaxDataNumber1No
    - ValidToValid toTaxDataDate-No
    - TaxNumberForeignCountriesTax number foreign countriesTaxDataText8No
    - TaxNumberTax numberTaxDataText8No
    - UsedSwitchUsed switchTaxDataNumber1No
    - EntryDateEntry dateTaxDataDate-No
    - ModificationDateModification dateTaxDataDate-No
    - IdCheckTax-Id no checkTaxDataBoolean-Yes
    - ConstructionServiceFactActiveIssue §13b activeTaxDataBoolean-No
    - ConstructionServiceFactProposalProposal issue §13bTaxDataNumber2No
    - DivisionConstraintDivisionsTaxDataText50No



Field Information

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

Code
XML Element Name:Code
Parent Element:TaxData
Field Type:Text
Action Type:Import und Export
Field Length:   3Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   1
Description:

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

Country
XML Element Name:Country
Parent Element:TaxData
Field Type:Text
Action Type:Import und Export
Field Length:   3Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   2
Description:

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

Designation data
XML Element Name:DesignationData
Parent Element:TaxData
Field Type:Array List
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   4
Description:

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

Designation
XML Element Name:Designation
Parent Element:DesignationData
Field Type:Text
Action Type:Import und Export
Field Length:   50Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   2
Description:

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

Language
XML Element Name:Language
Parent Element:DesignationData
Field Type:Text
Action Type:Import und Export
Field Length:   6Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   1
Description:

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

Flat rate code
XML Element Name:FlatRateCode
Parent Element:TaxData
Field Type:Nummer
Action Type:Import und Export
Field Length:   2Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   8
Description:

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

Form number
XML Element Name:FormNumber
Parent Element:TaxData
Field Type:Nummer
Action Type:Import und Export
Field Length:   4Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   7
Description:

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

Form number 2010
XML Element Name:FormNumber2010
Parent Element:TaxData
Field Type:Nummer
Action Type:Import und Export
Field Length:   4Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   14
Description:

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

Form number 2010A
XML Element Name:FormNumber2010A
Parent Element:TaxData
Field Type:Nummer
Action Type:Import und Export
Field Length:   4Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   15
Description:

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

Tax code identification
XML Element Name:Id
Parent Element:TaxData
Field Type:Text
Action Type:Import und Export
Field Length:   15Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   3
Description:

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

Inclusive
XML Element Name:Inclusive
Parent Element:TaxData
Field Type:Nummer
Action Type:Import und Export
Field Length:   1Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   9
Description:

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

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

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

Incl./excl. proposal
XML Element Name:ProposalIncludedExcluded
Parent Element:TaxData
Field Type:Text
Action Type:Import und Export
Field Length:   1Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   10
Description:

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

Range data
XML Element Name:RangeData
Parent Element:TaxData
Field Type:Array List
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   13
Description:

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

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

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

Contra account
XML Element Name:Account2
Parent Element:RangeData
Field Type:Nummer
Action Type:Import und Export
Field Length:   11Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   3
Description:

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

Contra account designation
XML Element Name:Account2Designation
Parent Element:RangeData
Field Type:Text
Action Type:Export only
Field Length:   100Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   9
Description:

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

Account designation
XML Element Name:AccountDesignation
Parent Element:RangeData
Field Type:Text
Action Type:Export only
Field Length:   100Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   8
Description:

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

Company data
XML Element Name:EnterpriseData
Parent Element:RangeData
Field Type:Array List
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   7
Description:

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

Account
XML Element Name:Account
Parent Element:EnterpriseData
Field Type:Nummer
Action Type:Import und Export
Field Length:   11Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   2
Description:

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

Contra account
XML Element Name:Account2
Parent Element:EnterpriseData
Field Type:Nummer
Action Type:Import und Export
Field Length:   11Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   3
Description:

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

Contra account designation
XML Element Name:Account2Designation
Parent Element:EnterpriseData
Field Type:Text
Action Type:Export only
Field Length:   100Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   5
Description:

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

Account designation
XML Element Name:AccountDesignation
Parent Element:EnterpriseData
Field Type:Text
Action Type:Export only
Field Length:   100Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   4
Description:

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

Company number
XML Element Name:Enterprise
Parent Element:EnterpriseData
Field Type:Nummer
Action Type:Import und Export
Field Length:   8Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   1
Description:

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

Flat rate
XML Element Name:FlatRate
Parent Element:RangeData
Field Type:Nummer
Action Type:Import und Export
Field Length:   4Decimal Places:   2Mandatory Field:   YesRevision:   0Ascii ID :   5
Description:

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

Datev tax key
XML Element Name:TAXKEY
Parent Element:RangeData
Field Type:Nummer
Action Type:Import und Export
Field Length:   4Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   4
Description:

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

VAT liability
XML Element Name:TaxLiability
Parent Element:RangeData
Field Type:Nummer
Action Type:Import und Export
Field Length:   4Decimal Places:   2Mandatory Field:   YesRevision:   0Ascii ID :   6
Description:

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

Tax rate
XML Element Name:TaxRate
Parent Element:RangeData
Field Type:Nummer
Action Type:Import und Export
Field Length:   4Decimal Places:   4Mandatory Field:   YesRevision:   0Ascii ID :   4
Description:

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

Valid from
XML Element Name:ValidFrom
Parent Element:RangeData
Field Type:Datum (2000-03-20)
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   1
Description:

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

Subsequent code
XML Element Name:SubsequenceCode
Parent Element:TaxData
Field Type:Text
Action Type:Import und Export
Field Length:   3Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   12
Description:

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

Type
XML Element Name:Type
Parent Element:TaxData
Field Type:Nummer
Action Type:Import und Export
Field Length:   1Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   5
Description:

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

Turnover type
XML Element Name:UseCode
Parent Element:TaxData
Field Type:Nummer
Action Type:Import und Export
Field Length:   1Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   6
Description:

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

Valid to
XML Element Name:ValidTo
Parent Element:TaxData
Field Type:Datum (2000-03-20)
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   11
Description:

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

Tax number foreign countries
XML Element Name:TaxNumberForeignCountries
Parent Element:TaxData
Field Type:Text
Action Type:Import und Export
Field Length:   8Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   1
Description:

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

Tax number
XML Element Name:TaxNumber
Parent Element:TaxData
Field Type:Text
Action Type:Import und Export
Field Length:   8Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   17
Description:

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

Used switch
XML Element Name:UsedSwitch
Parent Element:TaxData
Field Type:Nummer
Action Type:Export only
Field Length:   1Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   18
Description:

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

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

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

Modification date
XML Element Name:ModificationDate
Parent Element:TaxData
Field Type:Datum (2000-03-20)
Action Type:Export only
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   20
Description:

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

Tax-Id no check
XML Element Name:IdCheck
Parent Element:TaxData
Field Type:Boolean (true oder false)
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   21
Description:

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

Issue §13b active
XML Element Name:ConstructionServiceFactActive
Parent Element:TaxData
Field Type:Boolean (true oder false)
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   22
Description:
Activation issues DATEV interface
(The internal field ID for this element is "SVAKTIV")

Proposal issue §13b
XML Element Name:ConstructionServiceFactProposal
Parent Element:TaxData
Field Type:Nummer
Action Type:Import und Export
Field Length:   2Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   23
Description:
Issues for DATEV interface
(The internal field ID for this element is "SVVORSCHLAG")

Divisions
XML Element Name:DivisionConstraint
Parent Element:TaxData
Field Type:Text
Action Type:Import und Export
Field Length:   50Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   24
Description:

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