Interface: ADRE - Activities Version 2014.00

This documentation describes the AbaConnect Interface Activities for the ADRE Application.

General Information

General information about the AbaConnect interface.

AbaConnect Interface Information

Application :	ADRE
Interface Name :	Activities
ID :	Activities ( FlatIntf )
Version :	2014.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 :	Activities
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>ADRE</Application>
      <Id>Activities</Id>
      <MapId>AbaDefault</MapId>
      <Version>2014.00</Version>
      
      
      
      <Mandant>7777</Mandant>
    </Parameter>
    <Transaction>
      <Activity mode='SAVE'>
          
      </Activity>
    </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" "-aADRE" "-version2014.00" "-M7777" "-acidActivities" "-mapidAbaDefault" "-datamodeXML" "-responseYES" "-responsefileX:\response.xml" "-exportfileX:\data.xml"

Import :
abaconnectimportconsole.exe "/USRuser" "/PWxxx" "-aADRE" "-version2014.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
+ Activity	Activity	-	-	-	No
+ ActivityNote	Note	Activity	-	-	No
- NoteNumber	Notice number	ActivityNote	Number	2	No
- Text	Text	ActivityNote	Text	8192	No
- AddressNumber	Act address no.	Activity	Number	10	No
- ContactNumber	Act contact no.	Activity	Number	4	No
- EmployeeNumber	Mitarbeiter-Nummer	Activity	Number	10	No
- ActivityType	Activitytype	Activity	Text	6	No
- EmployeeInitials	Employee	Activity	Text	10	No
- StartDate	Start date	Activity	Date/Time	-	No
- PlanDate	Planning date	Activity	Date/Time	-	No
- Text	Akt-Bemerkung	Activity	Text	80	No
- FreeDate	Freies Datum	Activity	Date/Time	-	No
- Amount	Betrag	Activity	Number	12	No
- Priority	Priority	Activity	Text	1	No
- AdditionalExpenses	Expenditure	Activity	Number	12	No
- Quantity	Menge	Activity	Number	8	No
- CreditAdviceNumber	Gutschrift-Nummer	Activity	Text	20	No
- Done	Done	Activity	Boolean	-	No
- CompletionDate	Activity done	Activity	Date/Time	-	No
- Invoiced	Act. facturée	Activity	Boolean	-	No
- InvoiceDate	Act invoice date	Activity	Date	-	No
- EntryDate	Activity documented	Activity	Date/Time	-	No
- ModificationDate	Activity modified	Activity	Date/Time	-	No
- Number1	Zahl 1	Activity	Number	12	No
- Number2	Zahl 2	Activity	Number	12	No
- DossierNumber	Activity key	Activity	Text	26	No
- ModificationUser	Mutations-Benutzer	Activity	Number	8	No
- DocumentReference	Document	Activity	Text	128	No
- SubjectNumber	Subject number	Activity	Number	10	No
- PlanDateUntil	Planning until date	Activity	Date/Time	-	No
- SendTask	Create task	Activity	Boolean	-	No

Field Information

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

Note

XML Element Name:	ActivityNote
Parent Element:	Activity

Field Type:

Action Type:

Import und Export

Field Length: 2

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : -

Description:

Notice number

XML Element Name:	NoteNumber
Parent Element:	ActivityNote

Field Type:

Nummer

Action Type:

Import und Export

Field Length: 2

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : -

Description:

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

Text

XML Element Name:	Text
Parent Element:	ActivityNote

Field Type:

Text

Action Type:

Import und Export

Field Length: 8192

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : -

Description:

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

Act address no.

XML Element Name:	AddressNumber
Parent Element:	Activity

Field Type:

Nummer

Action Type:

Import und Export

Field Length: 10

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : -

Description:

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

Act contact no.

XML Element Name:	ContactNumber
Parent Element:	Activity

Field Type:

Nummer

Action Type:

Import und Export

Field Length: 4

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : -

Description:

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

Mitarbeiter-Nummer

XML Element Name:	EmployeeNumber
Parent Element:	Activity

Field Type:

Nummer

Action Type:

Import und Export

Field Length: 10

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : -

Description:

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

Activitytype

XML Element Name:	ActivityType
Parent Element:	Activity

Field Type:

Text

Action Type:

Import und Export

Field Length: 6

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : -

Description:

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

Employee

XML Element Name:	EmployeeInitials
Parent Element:	Activity

Field Type:

Text

Action Type:

Import und Export

Field Length: 10

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : -

Description:

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

Start date

XML Element Name:	StartDate
Parent Element:	Activity

Field Type:

Datum/Zeit (2006-08-08T10:16:54.509+02:00)

Action Type:

Import und Export

Field Length: -

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : -

Description:

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

Planning date

XML Element Name:	PlanDate
Parent Element:	Activity

Field Type:

Datum/Zeit (2006-08-08T10:16:54.509+02:00)

Action Type:

Import und Export

Field Length: -

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : -

Description:

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

Akt-Bemerkung

XML Element Name:	Text
Parent Element:	Activity

Field Type:

Text

Action Type:

Import und Export

Field Length: 80

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : -

Description:

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

Freies Datum

XML Element Name:	FreeDate
Parent Element:	Activity

Field Type:

Datum/Zeit (2006-08-08T10:16:54.509+02:00)

Action Type:

Import und Export

Field Length: -

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : -

Description:

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

Betrag

XML Element Name:	Amount
Parent Element:	Activity

Field Type:

Nummer

Action Type:

Import und Export

Field Length: 12

Decimal Places: 2

Mandatory Field: No

Revision: 0

Ascii ID : -

Description:

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

Priority

XML Element Name:	Priority
Parent Element:	Activity

Field Type:

Text

Action Type:

Import und Export

Field Length: 1

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : -

Description:

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

Expenditure

XML Element Name:	AdditionalExpenses
Parent Element:	Activity

Field Type:

Nummer

Action Type:

Import und Export

Field Length: 12

Decimal Places: 2

Mandatory Field: No

Revision: 0

Ascii ID : -

Description:

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

Menge

XML Element Name:	Quantity
Parent Element:	Activity

Field Type:

Nummer

Action Type:

Import und Export

Field Length: 8

Decimal Places: 4

Mandatory Field: No

Revision: 0

Ascii ID : -

Description:

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

Gutschrift-Nummer

XML Element Name:	CreditAdviceNumber
Parent Element:	Activity

Field Type:

Text

Action Type:

Import und Export

Field Length: 20

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : -

Description:

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

Done

XML Element Name:	Done
Parent Element:	Activity

Field Type:

Boolean (true oder false)

Action Type:

Import und Export

Field Length: -

Decimal Places: 1

Mandatory Field: No

Revision: 0

Ascii ID : -

Description:

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

Activity done

XML Element Name:	CompletionDate
Parent Element:	Activity

Field Type:

Datum/Zeit (2006-08-08T10:16:54.509+02:00)

Action Type:

Import und Export

Field Length: -

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : -

Description:

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

Act. facturée

XML Element Name:	Invoiced
Parent Element:	Activity

Field Type:

Boolean (true oder false)

Action Type:

Import und Export

Field Length: -

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : -

Description:

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

Act invoice date

XML Element Name:	InvoiceDate
Parent Element:	Activity

Field Type:

Datum (2000-03-20)

Action Type:

Import und Export

Field Length: -

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : -

Description:

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

Activity documented

XML Element Name:	EntryDate
Parent Element:	Activity

Field Type:

Datum/Zeit (2006-08-08T10:16:54.509+02:00)

Action Type:

Import und Export

Field Length: -

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : -

Description:

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

Activity modified

XML Element Name:	ModificationDate
Parent Element:	Activity

Field Type:

Datum/Zeit (2006-08-08T10:16:54.509+02:00)

Action Type:

Import und Export

Field Length: -

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : -

Description:

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

Zahl 1

XML Element Name:	Number1
Parent Element:	Activity

Field Type:

Nummer

Action Type:

Import und Export

Field Length: 12

Decimal Places: 4

Mandatory Field: No

Revision: 0

Ascii ID : -

Description:

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

Zahl 2

XML Element Name:	Number2
Parent Element:	Activity

Field Type:

Nummer

Action Type:

Import und Export

Field Length: 12

Decimal Places: 4

Mandatory Field: No

Revision: 0

Ascii ID : -

Description:

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

Activity key

XML Element Name:	DossierNumber
Parent Element:	Activity

Field Type:

Text

Action Type:

Import und Export

Field Length: 26

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : -

Description:

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

Mutations-Benutzer

XML Element Name:	ModificationUser
Parent Element:	Activity

Field Type:

Nummer

Action Type:

Import und Export

Field Length: 8

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : -

Description:

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

Document

XML Element Name:	DocumentReference
Parent Element:	Activity

Field Type:

Text

Action Type:

Import und Export

Field Length: 128

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : -

Description:

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

Subject number

XML Element Name:	SubjectNumber
Parent Element:	Activity

Field Type:

Nummer

Action Type:

Import und Export

Field Length: 10

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : -

Description:

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

Planning until date

XML Element Name:	PlanDateUntil
Parent Element:	Activity

Field Type:

Datum/Zeit (2006-08-08T10:16:54.509+02:00)

Action Type:

Import und Export

Field Length: -

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : -

Description:

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

Create task

XML Element Name:	SendTask
Parent Element:	Activity

Field Type:

Boolean (true oder false)

Action Type:

Import und Export

Field Length: -

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : -

Description:

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