Interface: ADRE - Activities Version 2017.10

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 :	2017.10
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>2017.10</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" "-version2017.10" "-M7777" "-acidActivities" "-mapidAbaDefault" "-datamodeXML" "-responseYES" "-responsefileX:\response.xml" "-exportfileX:\data.xml"

Import :
abaconnectimportconsole.exe "/USRuser" "/PWxxx" "-aADRE" "-version2017.10" "-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	16	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	GUID	36	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
- CreateCalendarEvent	Create entry in central calendar	Activity	Boolean	-	No
+ ActivityDossier	Archive	Activity	-	-	No
- Name	Archive name	ActivityDossier	Text	50	Yes
- Type	Archive type	ActivityDossier	Text	7	Yes
- ArchiveYear	Year of archive	ActivityDossier	Number	4	No
- Description	File description	ActivityDossier	Text	200	No
- Application	Application	ActivityDossier	Text	4	No
- Object	File object ID	ActivityDossier	Number	8	No
- UDK	UDK	ActivityDossier	Text	26	No
- DocumentId	Document ID	ActivityDossier	Text	36	No
- ArchiveID	Archive ID	ActivityDossier	Text	36	No
- HashModified	Modification hash	ActivityDossier	Text	40	No
- ModifiedTimestamp	Modification date	ActivityDossier	Text	30	No
- FileSize	File size	ActivityDossier	Number	12	No
- FileName	File name	ActivityDossier	Text	250	No
- OriginalFilename	Original file name	ActivityDossier	Text	250	Yes
+ ExchangeNotes	Exchange notes	Activity	-	-	No
- Content	Content	ExchangeNotes	Text	99999999	No
+ NoteAttachment	Attachments	ExchangeNotes	-	-	No
- ContentId	Content id	NoteAttachment	Text	180	No
- Attachmentname	Attachment name	NoteAttachment	Text	255	No
- FilePath	File path	NoteAttachment	Binary	-	Yes
- DocumentReferenceApplication	Document application	Activity	Number	2	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: 16

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:

GUID

Action Type:

Import und Export

Field Length: 36

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")

Create entry in central calendar

XML Element Name:	CreateCalendarEvent
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 "CREATE_PKT_ENTRY")

Archive

XML Element Name:	ActivityDossier
Parent Element:	Activity

Field Type:

Action Type:

Import und Export

Field Length: -

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : -

Description:

Archive name

XML Element Name:	Name
Parent Element:	ActivityDossier

Field Type:

Text

Action Type:

Import und Export

Field Length: 50

Decimal Places: 0

Mandatory Field: Yes

Revision: 0

Ascii ID : -

Description:

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

Archive type

XML Element Name:	Type
Parent Element:	ActivityDossier

Field Type:

Text

Action Type:

Import und Export

Field Length: 7

Decimal Places: 0

Mandatory Field: Yes

Revision: 0

Ascii ID : -

Description:

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

Year of archive

XML Element Name:	ArchiveYear
Parent Element:	ActivityDossier

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 "ArchiveYear")

File description

XML Element Name:	Description
Parent Element:	ActivityDossier

Field Type:

Text

Action Type:

Import und Export

Field Length: 200

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : -

Description:

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

Application

XML Element Name:	Application
Parent Element:	ActivityDossier

Field Type:

Text

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 "Application")

File object ID

XML Element Name:	Object
Parent Element:	ActivityDossier

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 "Object")

UDK

XML Element Name:	UDK
Parent Element:	ActivityDossier

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 "UDK")

Document ID

XML Element Name:	DocumentId
Parent Element:	ActivityDossier

Field Type:

Text

Action Type:

Import und Export

Field Length: 36

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : -

Description:

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

Archive ID

XML Element Name:	ArchiveID
Parent Element:	ActivityDossier

Field Type:

Text

Action Type:

Import und Export

Field Length: 36

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : -

Description:

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

Modification hash

XML Element Name:	HashModified
Parent Element:	ActivityDossier

Field Type:

Text

Action Type:

Import und Export

Field Length: 40

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : -

Description:

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

Modification date

XML Element Name:	ModifiedTimestamp
Parent Element:	ActivityDossier

Field Type:

Text

Action Type:

Import und Export

Field Length: 30

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : -

Description:

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

File size

XML Element Name:	FileSize
Parent Element:	ActivityDossier

Field Type:

Nummer

Action Type:

Import und Export

Field Length: 12

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : -

Description:

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

File name

XML Element Name:	FileName
Parent Element:	ActivityDossier

Field Type:

Text

Action Type:

Import und Export

Field Length: 250

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : -

Description:

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

Original file name

XML Element Name:	OriginalFilename
Parent Element:	ActivityDossier

Field Type:

Text

Action Type:

Import und Export

Field Length: 250

Decimal Places: 0

Mandatory Field: Yes

Revision: 0

Ascii ID : -

Description:

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

Exchange notes

XML Element Name:	ExchangeNotes
Parent Element:	Activity

Field Type:

Action Type:

Import und Export

Field Length: -

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : -

Description:

Content

XML Element Name:	Content
Parent Element:	ExchangeNotes

Field Type:

Text

Action Type:

Import und Export

Field Length: 99999999

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : -

Description:

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

Attachments

XML Element Name:	NoteAttachment
Parent Element:	ExchangeNotes

Field Type:

Action Type:

Import und Export

Field Length: -

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : -

Description:

Content id

XML Element Name:	ContentId
Parent Element:	NoteAttachment

Field Type:

Text

Action Type:

Import und Export

Field Length: 180

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : -

Description:

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

Attachment name

XML Element Name:	Attachmentname
Parent Element:	NoteAttachment

Field Type:

Text

Action Type:

Import und Export

Field Length: 255

Decimal Places: 0

Mandatory Field: No

Revision: 0

Ascii ID : -

Description:

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

File path

XML Element Name:	FilePath
Parent Element:	NoteAttachment

Field Type:

Binary data

Action Type:

Import und Export

Field Length: -

Decimal Places: 0

Mandatory Field: Yes

Revision: 0

Ascii ID : 1

Description:

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

Document application

XML Element Name:	DocumentReferenceApplication
Parent Element:	Activity

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 "LINK_APPL")