Interface: SCMM - Resale file Version 2016.00

This documentation describes the AbaConnect Interface Resale file for the SCMM Application.


General Information

General information about the AbaConnect interface.

AbaConnect Interface Information
Application :SCMM
Interface Name :Resale file
ID :RWVK ( R823 )
Version :2016.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 :Resale file
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>SCMM</Application>
      <Id>RWVK</Id>
      <MapId>AbaDefault</MapId>
      <Version>2016.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>
      <SaleCondition mode='SAVE'>
          <!-- The specific data fields for the AbaConnect interface are included here. -->
      </SaleCondition>
    </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"  "-aSCMM"  "-version2016.00"  "-M7777"  "-acidRWVK"  "-mapidAbaDefault"  "-datamodeXML"  "-responseYES"  "-responsefileX:\response.xml"  "-exportfileX:\data.xml"

Import :
abaconnectimportconsole.exe "/USRuser" "/PWxxx"  "-aSCMM"  "-version2016.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
SaleConditionSales partner table---Yes
    SaleConditionPositionSales partner conditionsSaleCondition--No
        - SalesPartnerSales partnerSaleConditionPositionNumber10Yes
        - ConditionGroupTypCondition group typeSaleConditionPositionNumber2Yes
        - ConditionGroupCondition groupSaleConditionPositionNumber14Yes
        - ProductNumberProduct noSaleConditionPositionText30Yes
        - ValidFromValid fromSaleConditionPositionDate-Yes
        - RebateDiscountSaleConditionPositionNumber4No
        - GraduatedDiscountGraduated discountSaleConditionPositionNumber4No
        - SpecialDiscountSpecial discountSaleConditionPositionNumber4No
        - PromotionDiscountPromotion discountSaleConditionPositionNumber4No
        - ProvNr1Representative number 1SaleConditionPositionNumber6No
        - Prov1ProzCommission 1SaleConditionPositionNumber4No
        - ProvNr2Representative number 2SaleConditionPositionNumber6No
        - Prov2ProzCommission 2SaleConditionPositionNumber4No
        - ValidToValid toSaleConditionPositionDate-No
        - DescriptionDescriptionSaleConditionPositionText99999999No
    - SalesPartnerSales partnerSaleConditionNumber10Yes
    - ValidFromValid fromSaleConditionDate-Yes



Field Information

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

Sales partner conditions
XML Element Name:SaleConditionPosition
Parent Element:SaleCondition
Field Type:ID
Action Type:Import und Export
Field Length:   1Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                

Sales partner
XML Element Name:SalesPartner
Parent Element:SaleConditionPosition
Field Type:Nummer
Action Type:Import und Export
Field Length:   10Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   -
Description:

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

Condition group type
XML Element Name:ConditionGroupTyp
Parent Element:SaleConditionPosition
Field Type:Nummer
Action Type:Import und Export
Field Length:   2Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   -
Description:

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

Condition group
XML Element Name:ConditionGroup
Parent Element:SaleConditionPosition
Field Type:Nummer
Action Type:Import und Export
Field Length:   14Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   -
Description:

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

Product no
XML Element Name:ProductNumber
Parent Element:SaleConditionPosition
Field Type:Text
Action Type:Import und Export
Field Length:   30Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   -
Description:

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

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

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

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

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

Graduated discount
XML Element Name:GraduatedDiscount
Parent Element:SaleConditionPosition
Field Type:Nummer
Action Type:Import und Export
Field Length:   4Decimal Places:   4Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Special discount
XML Element Name:SpecialDiscount
Parent Element:SaleConditionPosition
Field Type:Nummer
Action Type:Import und Export
Field Length:   4Decimal Places:   4Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Promotion discount
XML Element Name:PromotionDiscount
Parent Element:SaleConditionPosition
Field Type:Nummer
Action Type:Import und Export
Field Length:   4Decimal Places:   4Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Representative number 1
XML Element Name:ProvNr1
Parent Element:SaleConditionPosition
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 "ProvNr1")
                    

Commission 1
XML Element Name:Prov1Proz
Parent Element:SaleConditionPosition
Field Type:Nummer
Action Type:Import und Export
Field Length:   4Decimal Places:   4Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Representative number 2
XML Element Name:ProvNr2
Parent Element:SaleConditionPosition
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 "ProvNr2")
                    

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

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

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

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

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

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

Sales partner
XML Element Name:SalesPartner
Parent Element:SaleCondition
Field Type:Nummer
Action Type:Import und Export
Field Length:   10Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   -
Description:

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

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

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