Interface: DF - Payment terms Version 2007.00

This documentation describes the AbaConnect Interface Payment terms for the DF Application.


General Information

General information about the AbaConnect interface.

AbaConnect Interface Information
Application :DF
Interface Name :Payment terms
ID :Zahlungskonditionen ( Konditionen )
Version :2007.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
Payment terms for Account Receivable and Order Processing, or Account Payable, respectively		
Highest field Revision for this interface : 0



Mapping Information

The following displays the Mapping details for this interface.

Mapping Information
Mapping ID :AbaZahlungskondition
Mapping Name :Payment terms
Description :
Payment terms for Account Receivable and Order Processing, or Account Payable, respectively	



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>Zahlungskonditionen</Id>
      <MapId>AbaZahlungskondition</MapId>
      <Version>2007.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>
      <PaymentTerm mode='SAVE'>
          <!-- The specific data fields for the AbaConnect interface are included here. -->
      </PaymentTerm>
    </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"  "-version2007.00"  "-M7777"  "-acidZahlungskonditionen"  "-mapidAbaZahlungskondition"  "-datamodeXML"  "-responseYES"  "-responsefileX:\response.xml"  "-exportfileX:\data.xml"

Import :
abaconnectimportconsole.exe "/USRuser" "/PWxxx"  "-aDF"  "-version2007.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
PaymentTermRoot-Element Zahlungskonditionen---Yes
    - NumberTerm no.PaymentTermNumber6Yes
    - TypePayment term typePaymentTermAbaCon Enum1Yes
    - PartialPaymentMonthlyPartial payments monthlyPaymentTermBoolean-No
    - NumberOfPartialPaymentsNumber of partial paymentsPaymentTermNumber2No
    - DeadlineInDaysDeadlinePaymentTermNumber4No
    - DiscountDays1Discount 1 daysPaymentTermNumber4No
    - DiscountPercentage1Discount 1 percentagePaymentTermNumber2No
    - DiscountDays2Discount 2 daysPaymentTermNumber4No
    - DiscountPercentage2Discount 2 percentagePaymentTermNumber2No
    - DiscountDays3Discount 3 daysPaymentTermNumber4No
    - DiscountPercentage3Discount 3 percentagePaymentTermNumber2No
    - OwnTypeType_OwnPaymentTermBoolean-Yes
    - AccountPayableTypeType_Account PayablePaymentTermBoolean-Yes
    - ApplicationApplicationPaymentTermText4Yes
    DesignationDesignationPaymentTerm--No
        - LanguageLanguage codeDesignationText6Yes
        - TextTextDesignationText50Yes
    NoteDataNote to the payment termPaymentTerm--No
        - LanguageLanguage codeNoteDataText6Yes
        - NoteTextNoteDataText4032Yes
    PartialPaymentTermPartial payment termPaymentTerm--No
        - NumberPartial paymentPartialPaymentTermNumber2Yes
        - DeadlineInDaysDeadlinePartialPaymentTermNumber4No
        - DiscountDaysDiscount daysPartialPaymentTermNumber4No
        - DiscountPercentageDiscount percentagePartialPaymentTermNumber2No
        - PercentagePercentagePartialPaymentTermNumber4Yes
        PartialPaymentDesignationPartial payment designationPartialPaymentTerm--No
            - LanguageLanguage codePartialPaymentDesignationText6Yes
            - TextTextPartialPaymentDesignationText50Yes



Field Information

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

Term no.
XML Element Name:Number
Parent Element:PaymentTerm
Field Type:Nummer
Action Type:Import und Export
Field Length:   6Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   -
Description:
Partial payment term number
(The internal field ID for this element is "Konditionsnummer")

Payment term type
XML Element Name:Type
Parent Element:PaymentTerm
Field Type:AbaConnect Enum
Action Type:Import und Export
Field Length:   1Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   -
Description:
Term type 
0 = Standard (one payment term, 3 discount levels) 
1 = Partial payments (several payment terms, one discount level each) 
2 = Combination (Overall payment term or partial payment terms)	
(The internal field ID for this element is "Konditionstyp")

Partial payments monthly
XML Element Name:PartialPaymentMonthly
Parent Element:PaymentTerm
Field Type:Boolean (true oder false)
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Flag for partial payments "monthly", i.e. the partial payment terms are fixed to 30 days from the 2nd condition
(The internal field ID for this element is "TeilzahlungenMonatlich")

Number of partial payments
XML Element Name:NumberOfPartialPayments
Parent Element:PaymentTerm
Field Type:Nummer
Action Type:Import und Export
Field Length:   2Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Number of partial payments for this payment term
(The internal field ID for this element is "AnzahlTeilzahlungen")

Deadline
XML Element Name:DeadlineInDays
Parent Element:PaymentTerm
Field Type:Nummer
Action Type:Import und Export
Field Length:   4Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
The "net deadline" in days
(The internal field ID for this element is "Frist_in_Tagen")

Discount 1 days
XML Element Name:DiscountDays1
Parent Element:PaymentTerm
Field Type:Nummer
Action Type:Import und Export
Field Length:   4Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Definition of the discount days for level 1	
(The internal field ID for this element is "Skonto_1_Tage")

Discount 1 percentage
XML Element Name:DiscountPercentage1
Parent Element:PaymentTerm
Field Type:Nummer
Action Type:Import und Export
Field Length:   2Decimal Places:   2Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Definition of the discount percentages for level 1
(The internal field ID for this element is "Skonto_1_Prozent")
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.

Discount 2 days
XML Element Name:DiscountDays2
Parent Element:PaymentTerm
Field Type:Nummer
Action Type:Import und Export
Field Length:   4Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Definition of the discount days for level 2 
(The internal field ID for this element is "Skonto_2_Tage")

Discount 2 percentage
XML Element Name:DiscountPercentage2
Parent Element:PaymentTerm
Field Type:Nummer
Action Type:Import und Export
Field Length:   2Decimal Places:   2Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Definition of the discount percentages for level 2 
(The internal field ID for this element is "Skonto_2_Prozent")
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.

Discount 3 days
XML Element Name:DiscountDays3
Parent Element:PaymentTerm
Field Type:Nummer
Action Type:Import und Export
Field Length:   4Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Definition of the discount days for level 3
(The internal field ID for this element is "Skonto_3_Tage")

Discount 3 percentage
XML Element Name:DiscountPercentage3
Parent Element:PaymentTerm
Field Type:Nummer
Action Type:Import und Export
Field Length:   2Decimal Places:   2Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Definition of the discount percentages for level 3 
(The internal field ID for this element is "Skonto_3_Prozent")
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.

Type_Own
XML Element Name:OwnType
Parent Element:PaymentTerm
Field Type:Boolean (true oder false)
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   -
Description:
Identification as a term for Account Receivable or Order Processing 
(see element "AccountPayableType")
(The internal field ID for this element is "Typ_Eigene")

Type_Account Payable
XML Element Name:AccountPayableType
Parent Element:PaymentTerm
Field Type:Boolean (true oder false)
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   -
Description:
Identification as a term for Account Payable. 
Such terms must be of type "Standard" 
(see element "OwnType" or "Type")
(The internal field ID for this element is "Typ_Kredi")

Application
XML Element Name:Application
Parent Element:PaymentTerm
Field Type:Text
Action Type:Import und Export
Field Length:   4Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   -
Description:
The application being the "owner" of this payment term
(The internal field ID for this element is "ApplikationAC")

Designation
XML Element Name:Designation
Parent Element:PaymentTerm
Field Type:ID
Action Type:Import und Export
Field Length:   2Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Designation of the main term (sub-element)

Language code
XML Element Name:Language
Parent Element:Designation
Field Type:Text
Action Type:Import und Export
Field Length:   6Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   -
Description:
Language code as a string 
(see A/R, prg. 419)	
(The internal field ID for this element is "CODE")

Text
XML Element Name:Text
Parent Element:Designation
Field Type:Text
Action Type:Import und Export
Field Length:   50Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   -
Description:
Designation of the main term
(The internal field ID for this element is "BEZEICHNUNG")

Note to the payment term
XML Element Name:NoteData
Parent Element:PaymentTerm
Field Type:ID
Action Type:Import und Export
Field Length:   2Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Note to this payment term (sub-element)

Language code
XML Element Name:Language
Parent Element:NoteData
Field Type:Text
Action Type:Import und Export
Field Length:   6Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   -
Description:
Language code as a string 
(see A/R, prg. 419)	
(The internal field ID for this element is "CODE")

Text
XML Element Name:Note
Parent Element:NoteData
Field Type:Text
Action Type:Import und Export
Field Length:   4032Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   -
Description:
Note to the main term
(The internal field ID for this element is "BEZEICHNUNG")

Partial payment term
XML Element Name:PartialPaymentTerm
Parent Element:PaymentTerm
Field Type:ID
Action Type:Import und Export
Field Length:   1Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Partial payment term (sub-element)

Partial payment
XML Element Name:Number
Parent Element:PartialPaymentTerm
Field Type:Nummer
Action Type:Import und Export
Field Length:   2Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   -
Description:
Partial payment term number
(The internal field ID for this element is "Teilzahlungsnummer")

Deadline
XML Element Name:DeadlineInDays
Parent Element:PartialPaymentTerm
Field Type:Nummer
Action Type:Import und Export
Field Length:   4Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
The "net deadline" in days
(The internal field ID for this element is "Frist_in_Tagen")

Discount days
XML Element Name:DiscountDays
Parent Element:PartialPaymentTerm
Field Type:Nummer
Action Type:Import und Export
Field Length:   4Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Definition of the discount days
(The internal field ID for this element is "Skonto_1_Tage")

Discount percentage
XML Element Name:DiscountPercentage
Parent Element:PartialPaymentTerm
Field Type:Nummer
Action Type:Import und Export
Field Length:   2Decimal Places:   2Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Definition of the discount percentages
(The internal field ID for this element is "Skonto_1_Prozent")
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.

Percentage
XML Element Name:Percentage
Parent Element:PartialPaymentTerm
Field Type:Nummer
Action Type:Import und Export
Field Length:   4Decimal Places:   4Mandatory Field:   YesRevision:   0Ascii ID :   -
Description:
Amount in percent for this partial payment term
(The internal field ID for this element is "Prozent")
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.

Partial payment designation
XML Element Name:PartialPaymentDesignation
Parent Element:PartialPaymentTerm
Field Type:ID
Action Type:Import und Export
Field Length:   2Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Partial payment term designation (sub-element)

Language code
XML Element Name:Language
Parent Element:PartialPaymentDesignation
Field Type:Text
Action Type:Import und Export
Field Length:   6Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   -
Description:
Language code as a string 
(see A/R, prg. 419)	
(The internal field ID for this element is "CODE")

Text
XML Element Name:Text
Parent Element:PartialPaymentDesignation
Field Type:Text
Action Type:Import und Export
Field Length:   50Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   -
Description:
Designation of the partial payment term	
(The internal field ID for this element is "BEZEICHNUNG")