Interface: PROJ - External service provider contract creditor amount Version 2018.00

This documentation describes the AbaConnect Interface External service provider contract creditor amount for the PROJ Application.


General Information

General information about the AbaConnect interface.

AbaConnect Interface Information
Application :PROJ
Interface Name :External service provider contract creditor amount
ID :N381KredDocument ( N381 )
Version :2018.00
Status:Productive


Displays the possible import and export features for this interface.

Export / Import Modus
Export :No Export
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 :External service provider contract creditor amount
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>PROJ</Application>
      <Id>N381KredDocument</Id>
      <MapId>AbaDefault</MapId>
      <Version>2018.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>
      <Document mode='SAVE'>
          <!-- The specific data fields for the AbaConnect interface are included here. -->
      </Document>
    </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
Import :
abaconnectimportconsole.exe "/USRuser" "/PWxxx"  "-aPROJ"  "-version2018.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
+ DocumentDocument---No
    - NumberDocument numberDocumentNumber10Yes
    - ContractIDExternal service provider contractDocumentNumber8Yes
    - InvoiceTypeInvoice typeDocumentNumber2Yes
    - PaymentTermNumberPayment conditionDocumentNumber6No
    - ClaimedRetentionDeduction requiredDocumentNumber4No
    - AcceptedRetentionDeduction acceptedDocumentNumber4No
    - CommentCommentDocumentText99999999No
    + LineItemItemDocument--No
        - ElementIDElement IDLineItemNumber8Yes
        - ClaimedAmountAmount requiredLineItemNumber14Yes
        - AcceptedAmountAmount acceptedLineItemNumber14Yes
        - CommentCommentLineItemText99999999No



Field Information

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

Document number
XML Element Name:Number
Parent Element:Document
Field Type:Nummer
Action Type:Import only
Field Length:   10Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   1
Description:

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

External service provider contract
XML Element Name:ContractID
Parent Element:Document
Field Type:Nummer
Action Type:Import only
Field Length:   8Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   2
Description:

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

Invoice type
XML Element Name:InvoiceType
Parent Element:Document
Field Type:Nummer
Action Type:Import only
Field Length:   2Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   3
Description:
3 = Deduction invoice, 4 = Partial final invoice, 5 = Final invoice, 6 = Single invoice
(The internal field ID for this element is "InvoiceTypeId")

Payment condition
XML Element Name:PaymentTermNumber
Parent Element:Document
Field Type:Nummer
Action Type:Import only
Field Length:   6Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   4
Description:

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

Deduction required
XML Element Name:ClaimedRetention
Parent Element:Document
Field Type:Nummer
Action Type:Import only
Field Length:   4Decimal Places:   4Mandatory Field:   NoRevision:   0Ascii ID :   5
Description:
Deduction required in percent
(The internal field ID for this element is "ClaimedRetainedPercentage")
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.

Deduction accepted
XML Element Name:AcceptedRetention
Parent Element:Document
Field Type:Nummer
Action Type:Import only
Field Length:   4Decimal Places:   4Mandatory Field:   NoRevision:   0Ascii ID :   6
Description:
Deduction accepted in percent
(The internal field ID for this element is "AcceptedRetainedPercentage")
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.

Comment
XML Element Name:Comment
Parent Element:Document
Field Type:Text
Action Type:Import only
Field Length:   99999999Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   7
Description:

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

Item
XML Element Name:LineItem
Parent Element:Document
Field Type:Array List
Action Type:Import only
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Element ID
XML Element Name:ElementID
Parent Element:LineItem
Field Type:Nummer
Action Type:Import only
Field Length:   8Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   1
Description:
Element ID of the item in the external service provider contract
(The internal field ID for this element is "ElementId")

Amount required
XML Element Name:ClaimedAmount
Parent Element:LineItem
Field Type:Nummer
Action Type:Import only
Field Length:   14Decimal Places:   4Mandatory Field:   YesRevision:   0Ascii ID :   2
Description:

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

Amount accepted
XML Element Name:AcceptedAmount
Parent Element:LineItem
Field Type:Nummer
Action Type:Import only
Field Length:   14Decimal Places:   4Mandatory Field:   YesRevision:   0Ascii ID :   3
Description:

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

Comment
XML Element Name:Comment
Parent Element:LineItem
Field Type:Text
Action Type:Import only
Field Length:   99999999Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   4
Description:

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