Interface:
FIBU
-
XML entries
Version
2018.00
This documentation describes the AbaConnect Interface
XML entries
for the
FIBU
Application.
General Information
General information about the AbaConnect interface.
AbaConnect Interface Information |
Application : | FIBU |
Interface Name : | XML entries |
ID : | XML Buchungen
(
Buchungen
)
|
Version : | 2018.00 |
Status: | Productive |
Displays the possible import and export features for this interface.
Displays additional information for this interface.
Highest field Revision for this interface : 2 |
Mapping Information
The following displays the Mapping details for this interface.
Mapping ID : | AbaDefault |
Mapping Name : | XML entries |
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>FIBU</Application>
<Id>XML Buchungen</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>
<Entry mode='SAVE'>
<!-- The specific data fields for the AbaConnect interface are included here. -->
</Entry>
</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"
"-aFIBU"
"-version2018.00"
"-M7777"
"-acidXML Buchungen"
"-mapidAbaDefault"
"-datamodeXML"
"-responseYES"
"-responsefileX:\response.xml"
"-exportfileX:\data.xml"
Import :
abaconnectimportconsole.exe "/USRuser" "/PWxxx"
"-aFIBU"
"-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.
Field Information
The following is a detailed description of the fields used in this interface.
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 "CompoundPosting")
|
XML Element Name: | EntryLevel |
Parent Element: | CollectiveInformation |
Action Type: | Import und Export |
Field Length:
1 | Decimal Places:
0 | Mandatory Field:
Yes | Revision:
0 | Ascii ID :
1 |
Description: |
Actual or budget
(The internal field ID for this element is "EntryLevel")
|
XML Element Name: | EntryType |
Parent Element: | CollectiveInformation |
Action Type: | Import und Export |
Field Length:
1 | Decimal Places:
0 | Mandatory Field:
Yes | Revision:
0 | Ascii ID :
2 |
Description: |
Single or collective (multiple) entry (value: S/C)
(The internal field ID for this element is "EntryType")
|
XML Element Name: | Type |
Parent Element: | CollectiveInformation |
Action Type: | Import und Export |
Field Length:
8 | Decimal Places:
0 | Mandatory Field:
Yes | Revision:
0 | Ascii ID :
3 |
Description: |
Entry type (e.g. normal or cost centre entry)
(The internal field ID for this element is "Type")
|
XML Element Name: | DebitCredit |
Parent Element: | CollectiveInformation |
Action Type: | Import und Export |
Field Length:
1 | Decimal Places:
0 | Mandatory Field:
Yes | Revision:
0 | Ascii ID :
4 |
Description: |
Debit/credit (value: D / C)
(The internal field ID for this element is "DebitCredit")
|
XML Element Name: | Client |
Parent Element: | CollectiveInformation |
Action Type: | Import und Export |
Field Length:
6 | Decimal Places:
0 | Mandatory Field:
Yes | Revision:
0 | Ascii ID :
5 |
Description: |
Client number
(The internal field ID for this element is "ClientCompanyId")
|
XML Element Name: | Division |
Parent Element: | CollectiveInformation |
Action Type: | Import und Export |
Field Length:
8 | Decimal Places:
0 | Mandatory Field:
Yes | Revision:
0 | Ascii ID :
6 |
Description: |
Division number
(The internal field ID for this element is "BusinessArea")
|
XML Element Name: | KeyCurrency |
Parent Element: | CollectiveInformation |
Action Type: | Import und Export |
Field Length:
3 | Decimal Places:
0 | Mandatory Field:
Yes | Revision:
0 | Ascii ID :
7 |
Description: |
Client key currency
(The internal field ID for this element is "GLCurrency")
|
XML Element Name: | EntryDate |
Parent Element: | CollectiveInformation |
Field Type: | Datum (2000-03-20) |
Action Type: | Import und Export |
Field Length:
- | Decimal Places:
0 | Mandatory Field:
Yes | Revision:
0 | Ascii ID :
8 |
Description: |
Document date
(The internal field ID for this element is "PostingDateValue")
|
XML Element Name: | ValueDate |
Parent Element: | CollectiveInformation |
Field Type: | Datum (2000-03-20) |
Action Type: | Import und Export |
Field Length:
- | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
9 |
Description: |
Value date
(The internal field ID for this element is "ValueDateValue")
|
XML Element Name: | AmountData |
Parent Element: | CollectiveInformation |
Action Type: | Import und Export |
Field Length:
- | Decimal Places:
0 | Mandatory Field:
Yes | Revision:
0 | Ascii ID :
10 |
Description: |
(The internal field ID for this element is "Amount")
|
XML Element Name: | Currency |
Parent Element: | AmountData |
Action Type: | Import und Export |
Field Length:
3 | Decimal Places:
0 | Mandatory Field:
Yes | Revision:
0 | Ascii ID :
1 |
Description: |
ISO code of the foreign currency, EUR = Euro, USD = US dollar
(The internal field ID for this element is "Currency")
|
XML Element Name: | Amount |
Parent Element: | AmountData |
Action Type: | Import und Export |
Field Length:
13 | Decimal Places:
2 | Mandatory Field:
Yes | Revision:
0 | Ascii ID :
2 |
Description: |
Amount in account currency
(The internal field ID for this element is "Value")
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.
|
XML Element Name: | KeyAmount |
Parent Element: | CollectiveInformation |
Action Type: | Import und Export |
Field Length:
13 | Decimal Places:
2 | Mandatory Field:
Yes | Revision:
0 | Ascii ID :
11 |
Description: |
Amount in key currency
(The internal field ID for this element is "AmountInGlCurrency")
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.
|
Action Type: | Import und Export |
Field Length:
- | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
12 |
Description: |
(The internal field ID for this element is "ExchangeRate")
|
XML Element Name: | FromCurrency |
Parent Element: | ExchangeRateData |
Action Type: | Import und Export |
Field Length:
3 | Decimal Places:
0 | Mandatory Field:
Yes | Revision:
0 | Ascii ID :
1 |
Description: |
(The internal field ID for this element is "FromCurrency")
|
XML Element Name: | ToCurrency |
Parent Element: | ExchangeRateData |
Action Type: | Import und Export |
Field Length:
3 | Decimal Places:
0 | Mandatory Field:
Yes | Revision:
0 | Ascii ID :
2 |
Description: |
(The internal field ID for this element is "ToCurrency")
|
XML Element Name: | ExchangeRate |
Parent Element: | ExchangeRateData |
Action Type: | Import und Export |
Field Length:
8 | Decimal Places:
8 | Mandatory Field:
Yes | Revision:
0 | Ascii ID :
3 |
Description: |
Exchange rate for foreign currency
(The internal field ID for this element is "Value")
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.
|
XML Element Name: | Account |
Parent Element: | CollectiveInformation |
Action Type: | Import und Export |
Field Length:
11 | Decimal Places:
0 | Mandatory Field:
Yes | Revision:
0 | Ascii ID :
13 |
Description: |
Left account
(The internal field ID for this element is "AcctNr")
|
XML Element Name: | TaxAccount |
Parent Element: | CollectiveInformation |
Action Type: | Import und Export |
Field Length:
11 | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
14 |
Description: |
(The internal field ID for this element is "TaxAcctNr")
|
Action Type: | Import und Export |
Field Length:
11 | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
15 |
Description: |
(The internal field ID for this element is "IntercompanyId")
|
Action Type: | Import und Export |
Field Length:
8 | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
16 |
Description: |
(The internal field ID for this element is "IntercompanyCode")
|
XML Element Name: | BookingLevel1 |
Parent Element: | CollectiveInformation |
Action Type: | Import und Export |
Field Length:
11 | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
17 |
Description: |
(The internal field ID for this element is "CostCenter")
|
XML Element Name: | BookingLevel2 |
Parent Element: | CollectiveInformation |
Action Type: | Import und Export |
Field Length:
11 | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
18 |
Description: |
(The internal field ID for this element is "ProjectId")
|
XML Element Name: | BookingLevel3 |
Parent Element: | CollectiveInformation |
Action Type: | Import und Export |
Field Length:
11 | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
19 |
Description: |
(The internal field ID for this element is "BookingLevel3")
|
XML Element Name: | Text1 |
Parent Element: | CollectiveInformation |
Action Type: | Import und Export |
Field Length:
80 | Decimal Places:
0 | Mandatory Field:
Yes | Revision:
0 | Ascii ID :
20 |
Description: |
(The internal field ID for this element is "PostingText1")
|
XML Element Name: | Text2 |
Parent Element: | CollectiveInformation |
Action Type: | Import und Export |
Field Length:
80 | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
21 |
Description: |
(The internal field ID for this element is "PostingText2")
|
Action Type: | Import und Export |
Field Length:
10 | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
22 |
Description: |
(The internal field ID for this element is "CompoundPostingReferenceValue")
|
XML Element Name: | SingleCount |
Parent Element: | CollectiveInformation |
Action Type: | Import und Export |
Field Length:
8 | Decimal Places:
0 | Mandatory Field:
Yes | Revision:
0 | Ascii ID :
23 |
Description: |
0 for single entires, actual number of items for a collective (multiple) entry
(The internal field ID for this element is "NumberOfSinglePostings")
|
XML Element Name: | BookingSource |
Parent Element: | CollectiveInformation |
Field Type: | AbaConnect Enum |
Action Type: | Import und Export |
Field Length:
1 | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
24 |
Description: |
D = Account Receivable invoice
d = Account Receivable payment
K = Account Payable invoices
k = Account Payable transfers
L = Payroll
G = G/L Light
F = General Ledger
E = External entry
N = Project Management
! = Profit entry
C = Consolidation
U = Allocation entry
X = WorX
Y = Electronic Banking
Z = Overhead cost entry
M = Assets Ledger
B = PPS stocktaking
b = PPS material/service
O = ORDE stocktaking
o = ORDE expenses
I = Interest entry
W = Rate adjustment entry
l = Payroll Light
H = AbaBuild
h = AbaBuild
R = Debit position (AbaImmo)
r = Heating and incidental costs settlement (AbaImmo)
A = Settlement of fees (AbaImmo)
y = Electronic Banking
J = AbaNinja invoice
j = AbaNinja payment
V = MyAbacus
v = AbaPos
S = Project Management Old
' ' = Unknown
(The internal field ID for this element is "BookingSource")
|
XML Element Name: | JournalID |
Parent Element: | CollectiveInformation |
Action Type: | Import und Export |
Field Length:
3 | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
- |
Description: |
ID of the journal the entry comes from (e.g. E07, EJE, T06).
(The internal field ID for this element is "EjourId")
|
XML Element Name: | CreationDate |
Parent Element: | CollectiveInformation |
Field Type: | Datum (2000-03-20) |
Action Type: | Import und Export |
Field Length:
- | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
- |
Description: |
Entry date of the entry
(The internal field ID for this element is "CreateDate")
|
Action Type: | Import und Export |
Field Length:
8 | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
- |
Description: |
Number of the user who entered/modified the entry
(The internal field ID for this element is "UserId")
|
XML Element Name: | EntryNumber |
Parent Element: | CollectiveInformation |
Action Type: | Import und Export |
Field Length:
11 | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
- |
Description: |
The four values internal record number, journal ID, division and amount type form a unique key to identify the entry.
(The internal field ID for this element is "InternalRecNr")
|
XML Element Name: | ClearingText |
Parent Element: | CollectiveInformation |
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 "ClearingText")
|
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 "KoreBasis")
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.
|
Action Type: | Import und Export |
Field Length:
11 | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
- |
Description: |
Number of the export run if archiving is active.
0 => Not yet exported or archiving not active
> 0 => Number of the export run.
(The internal field ID for this element is "Out")
|
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 "ClearingCredit")
|
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 "ClearingDebit")
|
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 "Zins")
|
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 "Konsmu")
|
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 "Company2")
|
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 "Mwst")
|
Field Length:
2 | Decimal Places:
0 | Mandatory Field:
No | Revision:
2 | Ascii ID :
- |
Description: |
(The internal field ID for this element is "MwstRevision")
|
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 "Konsto")
|
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 "Kurs")
|
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 "Elimination")
|
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 "EliminationGroup")
|
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 "ContraDivArId")
|
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 "ProzWert")
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.
|
XML Element Name: | ID |
Parent Element: | ExternalData |
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 "Id")
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.
|
XML Element Name: | Designation |
Parent Element: | ExternalData |
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 "Bezeichnung")
|
XML Element Name: | RunNumbers |
Parent Element: | CollectiveInformation |
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 "RunObject")
|
XML Element Name: | ExternalData |
Parent Element: | CollectiveInformation |
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 "ExternalValues")
|
Action Type: | Import und Export |
Field Length:
36 | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
25 |
Description: |
(The internal field ID for this element is "UserUCID")
|
XML Element Name: | SelectionCode |
Parent Element: | CollectiveInformation |
Action Type: | Import und Export |
Field Length:
1 | Decimal Places:
0 | Mandatory Field:
No | Revision:
1 | Ascii ID :
18 |
Description: |
(The internal field ID for this element is "SelectionCode")
|
XML Element Name: | EntryKey |
Parent Element: | CollectiveInformation |
Field Length:
36 | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
31 |
Description: |
(The internal field ID for this element is "EntryKey")
|
Action Type: | Import und Export |
Field Length:
- | Decimal Places:
0 | Mandatory Field:
Yes | Revision:
0 | Ascii ID :
2 |
Description: |
(The internal field ID for this element is "SinglePosting")
|
XML Element Name: | Type |
Parent Element: | SingleInformation |
Action Type: | Import und Export |
Field Length:
8 | Decimal Places:
0 | Mandatory Field:
Yes | Revision:
0 | Ascii ID :
1 |
Description: |
Normal entry = Normal
(The internal field ID for this element is "Type")
|
XML Element Name: | DebitCredit |
Parent Element: | SingleInformation |
Action Type: | Import und Export |
Field Length:
1 | Decimal Places:
0 | Mandatory Field:
Yes | Revision:
0 | Ascii ID :
2 |
Description: |
Debit/credit code, must contain 'D' or 'C'
(The internal field ID for this element is "DebitCredit")
|
XML Element Name: | EntryDate |
Parent Element: | SingleInformation |
Field Type: | Datum (2000-03-20) |
Action Type: | Import und Export |
Field Length:
- | Decimal Places:
0 | Mandatory Field:
Yes | Revision:
0 | Ascii ID :
3 |
Description: |
Document date
(The internal field ID for this element is "PostingDateValue")
|
XML Element Name: | ValueDate |
Parent Element: | SingleInformation |
Field Type: | Datum (2000-03-20) |
Action Type: | Import und Export |
Field Length:
- | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
4 |
Description: |
Value date (for interest calculation, it is possible to set the document date = value date in a separate subsequent run)
(The internal field ID for this element is "ValueDateValue")
|
XML Element Name: | AmountData |
Parent Element: | SingleInformation |
Action Type: | Import und Export |
Field Length:
- | Decimal Places:
0 | Mandatory Field:
Yes | Revision:
0 | Ascii ID :
5 |
Description: |
(The internal field ID for this element is "Amount")
|
XML Element Name: | KeyAmount |
Parent Element: | SingleInformation |
Action Type: | Import und Export |
Field Length:
13 | Decimal Places:
2 | Mandatory Field:
Yes | Revision:
0 | Ascii ID :
6 |
Description: |
Amount in key currency
(The internal field ID for this element is "AmountInGlCurrency")
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.
|
Action Type: | Import und Export |
Field Length:
- | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
7 |
Description: |
(The internal field ID for this element is "ExchangeRate")
|
XML Element Name: | Account |
Parent Element: | SingleInformation |
Action Type: | Import und Export |
Field Length:
11 | Decimal Places:
0 | Mandatory Field:
Yes | Revision:
0 | Ascii ID :
8 |
Description: |
Right account number (contra account/cost type/internal settlement)
(The internal field ID for this element is "AcctNr")
|
XML Element Name: | TaxAccount |
Parent Element: | SingleInformation |
Action Type: | Import und Export |
Field Length:
11 | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
9 |
Description: |
(The internal field ID for this element is "TaxAcctNr")
|
Action Type: | Import und Export |
Field Length:
11 | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
10 |
Description: |
Intercompany (number of the external division)
(The internal field ID for this element is "IntercompanyId")
|
Action Type: | Import und Export |
Field Length:
8 | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
11 |
Description: |
(The internal field ID for this element is "IntercompanyCode")
|
Action Type: | Import und Export |
Field Length:
11 | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
12 |
Description: |
Booking level 1 = Cost centre, cost unit or project
(The internal field ID for this element is "CostCenter")
|
Action Type: | Import und Export |
Field Length:
11 | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
13 |
Description: |
Booking level 2 = Cost centre, cost unit or project
(The internal field ID for this element is "ProjectId")
|
Action Type: | Import und Export |
Field Length:
11 | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
14 |
Description: |
Booking level 3 = Project
(The internal field ID for this element is "BookingLevel3")
|
XML Element Name: | Text1 |
Parent Element: | SingleInformation |
Action Type: | Import und Export |
Field Length:
80 | Decimal Places:
0 | Mandatory Field:
Yes | Revision:
0 | Ascii ID :
15 |
Description: |
(The internal field ID for this element is "PostingText1")
|
XML Element Name: | Text2 |
Parent Element: | SingleInformation |
Action Type: | Import und Export |
Field Length:
80 | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
16 |
Description: |
(The internal field ID for this element is "Postingtext2")
|
Action Type: | Import und Export |
Field Length:
10 | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
17 |
Description: |
(The internal field ID for this element is "SinglePostingReferenceValue")
|
Action Type: | Import und Export |
Field Length:
1 | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
18 |
Description: |
(The internal field ID for this element is "SelectionCode")
|
XML Element Name: | QuantityData |
Parent Element: | SingleInformation |
Action Type: | Import und Export |
Field Length:
- | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
19 |
Description: |
(The internal field ID for this element is "Quantity")
|
XML Element Name: | Unit |
Parent Element: | QuantityData |
Action Type: | Import und Export |
Field Length:
4 | Decimal Places:
0 | Mandatory Field:
Yes | Revision:
0 | Ascii ID :
1 |
Description: |
Quantity unit, e.g. kg
(The internal field ID for this element is "Units")
|
XML Element Name: | Quantity |
Parent Element: | QuantityData |
Action Type: | Import und Export |
Field Length:
12 | Decimal Places:
4 | Mandatory Field:
Yes | Revision:
0 | Ascii ID :
2 |
Description: |
Quantity, possible only for entries with cost type or internal settlement, if a quantity unit is kept on the corresponding account.
(The internal field ID for this element is "Value")
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.
|
XML Element Name: | Rate |
Parent Element: | QuantityData |
Action Type: | Import und Export |
Field Length:
8 | Decimal Places:
4 | Mandatory Field:
Yes | Revision:
0 | Ascii ID :
3 |
Description: |
Quantity * rate = amount
(The internal field ID for this element is "Ansatz")
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.
|
XML Element Name: | TaxData |
Parent Element: | SingleInformation |
Action Type: | Import und Export |
Field Length:
- | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
20 |
Description: |
(The internal field ID for this element is "TaxInfo")
|
Action Type: | Import und Export |
Field Length:
1 | Decimal Places:
0 | Mandatory Field:
Yes | Revision:
0 | Ascii ID :
1 |
Description: |
Inclusive or exclusive
(The internal field ID for this element is "InclusiveExclusive")
|
XML Element Name: | TaxType |
Parent Element: | TaxData |
Action Type: | Import und Export |
Field Length:
1 | Decimal Places:
0 | Mandatory Field:
Yes | Revision:
0 | Ascii ID :
2 |
Description: |
(The internal field ID for this element is "TypeOfTax")
|
XML Element Name: | UseCode |
Parent Element: | TaxData |
Action Type: | Import und Export |
Field Length:
1 | Decimal Places:
0 | Mandatory Field:
Yes | Revision:
0 | Ascii ID :
3 |
Description: |
(The internal field ID for this element is "UseCode")
|
XML Element Name: | AmountData |
Parent Element: | TaxData |
Action Type: | Import und Export |
Field Length:
- | Decimal Places:
0 | Mandatory Field:
Yes | Revision:
0 | Ascii ID :
4 |
Description: |
(The internal field ID for this element is "Amount")
|
XML Element Name: | KeyAmount |
Parent Element: | TaxData |
Action Type: | Import und Export |
Field Length:
13 | Decimal Places:
2 | Mandatory Field:
Yes | Revision:
0 | Ascii ID :
5 |
Description: |
(The internal field ID for this element is "AmountInGLCurrency")
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.
|
XML Element Name: | TaxRate |
Parent Element: | TaxData |
Action Type: | Import und Export |
Field Length:
8 | Decimal Places:
8 | Mandatory Field:
Yes | Revision:
0 | Ascii ID :
6 |
Description: |
VAT rate (e.g. 7.6 for the normal rate in Switzerland in 2007)
(The internal field ID for this element is "TaxRate")
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.
|
Action Type: | Import und Export |
Field Length:
8 | Decimal Places:
8 | Mandatory Field:
Yes | Revision:
0 | Ascii ID :
7 |
Description: |
VAT liability. Usually 100.00. Specify corresponding rate for VAT exclusive entries with partial liability.
(The internal field ID for this element is "TaxCoef")
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.
|
XML Element Name: | Country |
Parent Element: | TaxData |
Action Type: | Import und Export |
Field Length:
2 | Decimal Places:
0 | Mandatory Field:
Yes | Revision:
0 | Ascii ID :
8 |
Description: |
VAT country specified on the code (item 36) - according to VAT table. CH for Switzerland
(The internal field ID for this element is "TaxCountry")
|
XML Element Name: | TaxCode |
Parent Element: | TaxData |
Action Type: | Import und Export |
Field Length:
3 | Decimal Places:
0 | Mandatory Field:
Yes | Revision:
0 | Ascii ID :
9 |
Description: |
Code according to the VAT table of the client
(The internal field ID for this element is "TaxCode")
|
XML Element Name: | Number |
Parent Element: | TaxData |
Action Type: | Import und Export |
Field Length:
8 | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
10 |
Description: |
(The internal field ID for this element is "TaxNr")
|
XML Element Name: | FlatRate |
Parent Element: | TaxData |
Action Type: | Import und Export |
Field Length:
8 | Decimal Places:
8 | Mandatory Field:
Yes | Revision:
0 | Ascii ID :
11 |
Description: |
(The internal field ID for this element is "FlatRate")
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.
|
XML Element Name: | Year |
Parent Element: | TaxData |
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 "Year")
|
XML Element Name: | Month |
Parent Element: | TaxData |
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 "Month")
|
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 "Kfr1")
|
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 "Kfr2")
|
XML Element Name: | NoteData |
Parent Element: | SingleInformation |
Action Type: | Import und Export |
Field Length:
- | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
21 |
Description: |
(The internal field ID for this element is "AdditionalText")
|
XML Element Name: | Text |
Parent Element: | NoteData |
Action Type: | Import und Export |
Field Length:
2000 | Decimal Places:
0 | Mandatory Field:
Yes | Revision:
0 | Ascii ID :
1 |
Description: |
Additional text
(The internal field ID for this element is "Line")
|
XML Element Name: | ClearingText |
Parent Element: | SingleInformation |
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 "ClearingText")
|
XML Element Name: | RunNumbers |
Parent Element: | SingleInformation |
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 "RunObject")
|
XML Element Name: | ExternalData |
Parent Element: | SingleInformation |
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 "ExternalValues")
|
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 "NebenbuecherObject")
|
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 "DKObject")
|
XML Element Name: | Approved |
Parent Element: | AccountReceivableOrPayableData |
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 "Visiert")
|
XML Element Name: | DocumentNumber |
Parent Element: | AccountReceivableOrPayableData |
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 "Belegnummer")
|
XML Element Name: | CustomerNumber |
Parent Element: | AccountReceivableOrPayableData |
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 "Kundennummer")
|
XML Element Name: | ItemNumber |
Parent Element: | AccountReceivableOrPayableData |
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 "Positionsnummer")
|
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 "AbeaObject")
|
XML Element Name: | OrderNumber |
Parent Element: | OrderProcessingData |
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 "Auftragsnummer")
|
XML Element Name: | BacklogNumber |
Parent Element: | OrderProcessingData |
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 "Rueckstandsnummer")
|
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 "ImmoObject")
|
XML Element Name: | SettlementType |
Parent Element: | RealEstateManagementData |
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 "AbrechnungsArt")
|
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 "AbrechnungsDatum1")
|
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 "AbrechnungsDatum2")
|
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 "HKNK")
|
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 "InveObject")
|
XML Element Name: | AssetsNumber |
Parent Element: | AssetsProcessingData |
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 "AnlagenNummer")
|
Action Type: | Import und Export |
Field Length:
4 | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
1 |
Description: |
(The internal field ID for this element is "AnlagenBewegungsart")
|
XML Element Name: | AssetsBooking |
Parent Element: | AssetsProcessingData |
Field Type: | Boolean (true oder false) |
Action Type: | Import und Export |
Field Length:
- | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
2 |
Description: |
(The internal field ID for this element is "AnlagenVerbuchung")
|
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 "ProjObject")
|
XML Element Name: | RoughPlan |
Parent Element: | AbaProjectData |
Action Type: | Import und Export |
Field Length:
8 | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
1 |
Description: |
(The internal field ID for this element is "AbaProjectRoughPlan")
|
XML Element Name: | DetailPlan |
Parent Element: | AbaProjectData |
Action Type: | Import und Export |
Field Length:
8 | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
2 |
Description: |
(The internal field ID for this element is "AbaProjectDetailPlan")
|
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 "KoreBasis")
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.
|
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 "ProzWert")
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.
|
XML Element Name: | AccrualsData |
Parent Element: | SingleInformation |
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 "AccrualsObject")
|
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 "AbgrenzungsNr")
|
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 "AbgrenzungVon")
|
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 "AbgrenzungBis")
|
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 "CrossDivisionEntriesObject")
|
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 "ContraDivKto")
|
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 "ContraDivGkto")
|
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 "ContraDivGuid")
|
Action Type: | Import und Export |
Field Length:
3 | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
- |
Description: |
Cross-DIV: Original = DIO; Item = DIP
(The internal field ID for this element is "ContraDivId")
|
Action Type: | Import und Export |
Field Length:
11 | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
- |
Description: |
(The internal field ID for this element is "ZielGBKto")
|
Action Type: | Import und Export |
Field Length:
11 | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
- |
Description: |
(The internal field ID for this element is "ZielGBKst")
|
Action Type: | Import und Export |
Field Length:
11 | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
- |
Description: |
(The internal field ID for this element is "ZielGBPro")
|
Action Type: | Import und Export |
Field Length:
11 | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
- |
Description: |
(The internal field ID for this element is "ZielGBProj")
|
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 "ZielAbgrenzNr")
|
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 "ZielAbgrenzVon")
|
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 "ZielAbgrenzBis")
|
Action Type: | Import und Export |
Field Length:
- | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
30 |
Description: |
(The internal field ID for this element is "MaintenanceDetailObject")
|
Action Type: | Import und Export |
Field Length:
12 | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
1 |
Description: |
(The internal field ID for this element is "RefNum1")
|
Action Type: | Import und Export |
Field Length:
12 | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
2 |
Description: |
(The internal field ID for this element is "Nummer")
|
XML Element Name: | CreationDate |
Parent Element: | MaintenanceDetail |
Field Type: | Datum (2000-03-20) |
Action Type: | Import und Export |
Field Length:
- | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
3 |
Description: |
(The internal field ID for this element is "CreationDate")
|
Action Type: | Import und Export |
Field Length:
30 | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
4 |
Description: |
(The internal field ID for this element is "CreationUserName")
|
XML Element Name: | Date |
Parent Element: | MaintenanceDetail |
Field Type: | Datum (2000-03-20) |
Action Type: | Import und Export |
Field Length:
- | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
5 |
Description: |
(The internal field ID for this element is "Datum")
|
Action Type: | Import und Export |
Field Length:
12 | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
6 |
Description: |
(The internal field ID for this element is "Kategorie")
|
Action Type: | Import und Export |
Field Length:
12 | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
7 |
Description: |
(The internal field ID for this element is "GeraetNr")
|
Action Type: | Import und Export |
Field Length:
12 | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
8 |
Description: |
(The internal field ID for this element is "Art")
|
Field Type: | Boolean (true oder false) |
Action Type: | Import und Export |
Field Length:
- | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
9 |
Description: |
(The internal field ID for this element is "WeiterBelastenAusgf")
|
Field Type: | Boolean (true oder false) |
Action Type: | Import und Export |
Field Length:
- | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
10 |
Description: |
(The internal field ID for this element is "WeiterBelasten")
|
Action Type: | Import und Export |
Field Length:
6 | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
11 |
Description: |
Example:
- Real estate
- Building
- House
- Storey
- Object
(The internal field ID for this element is "VerbindungRecTyp")
|
Field Type: | Datum (2000-03-20) |
Action Type: | Import und Export |
Field Length:
- | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
12 |
Description: |
(The internal field ID for this element is "ModificationDate")
|
Action Type: | Import und Export |
Field Length:
50 | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
13 |
Description: |
(The internal field ID for this element is "ModificationUserName")
|
XML Element Name: | PortionType |
Parent Element: | MaintenanceDetail |
Action Type: | Import und Export |
Field Length:
2 | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
14 |
Description: |
(The internal field ID for this element is "AnteilsArt")
|
Action Type: | Import und Export |
Field Length:
12 | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
15 |
Description: |
(The internal field ID for this element is "ServiceAboNr")
|
XML Element Name: | Tenancy |
Parent Element: | MaintenanceDetail |
Action Type: | Import und Export |
Field Length:
2 | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
16 |
Description: |
(The internal field ID for this element is "MietVerhaeltnis")
|
Action Type: | Import und Export |
Field Length:
12 | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
17 |
Description: |
(The internal field ID for this element is "ImmobilieNr")
|
XML Element Name: | Value |
Parent Element: | MaintenanceDetail |
Action Type: | Import und Export |
Field Length:
12 | Decimal Places:
2 | Mandatory Field:
No | Revision:
0 | Ascii ID :
18 |
Description: |
(The internal field ID for this element is "Wert")
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.
|
XML Element Name: | EntryKey |
Parent Element: | SingleInformation |
Field Length:
36 | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
31 |
Description: |
(The internal field ID for this element is "EntryKey")
|