General information about the AbaConnect interface.
| AbaConnect Interface Information |
| Application : | PROJ |
| Interface Name : | Project booking |
| ID : | N11 ( N11 ) |
| Version : | 2025.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 |
The following displays the Mapping details for this interface.
| Mapping Information |
| Mapping ID : | AbaDefault |
| Mapping Name : | Project booking |
| Description : |
The following is an example of an XML Header structure. This information is also visible in an AbaConnect XML Export file, that has been exported via the Abacus AbaConnect User Interface.
| AbaConnect XML Struktur | |
|
<?xml version='1.0' encoding='UTF-8'?>
<AbaConnectContainer> <TaskCount>1</TaskCount> <Task> <Parameter> <Application>PROJ</Application> <Id>N11</Id> <MapId>AbaDefault</MapId> <Version>2025.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> <ProjectBooking mode='SAVE'> <!-- The specific data fields for the AbaConnect interface are included here. --> </ProjectBooking> </Transaction> </Task> </AbaConnectContainer> |
|
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" "-aPROJ" "-version2025.00" "-M7777" "-acidN11" "-mapidAbaDefault" "-datamodeXML" "-responseYES" "-responsefileX:\response.xml" "-exportfileX:\data.xml" Import : abaconnectimportconsole.exe "/USRuser" "/PWxxx" "-aPROJ" "-version2025.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. |
|
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.
The following is a detailed description of the fields used in this interface.
| Texts |
| XML Element Name: | TextFormated |
| Parent Element: | ProjectBooking |
| Field Type: | ID |
| Action Type: | Import und Export |
| Field Length: 1 | Decimal Places: 0 | Mandatory Field: No | Revision: 0 | Ascii ID : - |
| Description: |
Tabelle mit allen Notizblockfeldern von AbaProject |
| Text intern |
| XML Element Name: | TextInternal |
| Parent Element: | TextFormated |
| Field Type: | Text |
| Action Type: | Import und Export |
| Field Length: 99999999 | Decimal Places: 0 | Mandatory Field: No | Revision: 0 | Ascii ID : 4 |
| Description: |
(The internal field ID for this element is "TextInt")
|
| Text extern |
| XML Element Name: | TextExternal |
| Parent Element: | TextFormated |
| Field Type: | Text |
| Action Type: | Import und Export |
| Field Length: 99999999 | Decimal Places: 0 | Mandatory Field: No | Revision: 0 | Ascii ID : 4 |
| Description: |
(The internal field ID for this element is "TextExt")
|
| Texts |
| XML Element Name: | TextPlain |
| Parent Element: | ProjectBooking |
| Field Type: | ID |
| Action Type: | Import und Export |
| Field Length: 1 | Decimal Places: 0 | Mandatory Field: No | Revision: 0 | Ascii ID : - |
| Description: |
Tabelle mit allen Notizblockfeldern von AbaProject |
| Text intern |
| XML Element Name: | TextInternal |
| Parent Element: | TextPlain |
| Field Type: | Text |
| Action Type: | Import und Export |
| Field Length: 99999999 | Decimal Places: 0 | Mandatory Field: No | Revision: 0 | Ascii ID : 4 |
| Description: |
(The internal field ID for this element is "TextInt")
|
| Text extern |
| XML Element Name: | TextExternal |
| Parent Element: | TextPlain |
| Field Type: | Text |
| Action Type: | Import und Export |
| Field Length: 99999999 | Decimal Places: 0 | Mandatory Field: No | Revision: 0 | Ascii ID : 4 |
| Description: |
(The internal field ID for this element is "TextExt")
|
| Entry type |
| XML Element Name: | RecordType |
| Parent Element: | ProjectBooking |
| Field Type: | AbaConnect Enum |
| Action Type: | Import und Export |
| Field Length: 2 | Decimal Places: 0 | Mandatory Field: No | Revision: 0 | Ascii ID : 4 |
| Description: |
For surcharges/deductions, AnsatzInt and AnsatzExt is always 0(The internal field ID for this element is "DataSet") |
| Split no. |
| XML Element Name: | SplittingNumber |
| Parent Element: | ProjectBooking |
| Field Type: | Nummer |
| Action Type: | Import und Export |
| Field Length: 2 | Decimal Places: 0 | Mandatory Field: Yes | Revision: 0 | Ascii ID : - |
| Description: |
SplittingNumber exists when a cost centre distribution is defined for a Project/Service. For the main entry the SplittingNumber is always 0. For the corresponding cost centre distribution entries the value is > 0. The field can never be manually filled out. Split entries can also not be edited. The SplittingNumber must always be filled out with 0. The exception being if someone wants to query exactly this cost centre distribution.(The internal field ID for this element is "SplitNr") |
| Entry no. |
| XML Element Name: | RecordNumber |
| Parent Element: | ProjectBooking |
| Field Type: | Nummer |
| Action Type: | Import und Export |
| Field Length: 10 | Decimal Places: 0 | Mandatory Field: Yes | Revision: 0 | Ascii ID : - |
| Description: |
For a new entry the RecordNumber may/should be entered with 0 and for a modification of an existing entry with the corresponding number.(The internal field ID for this element is "RefNr") |
| Project number |
| XML Element Name: | Project |
| Parent Element: | ProjectBooking |
| Field Type: | Nummer |
| Action Type: | Import und Export |
| Field Length: 12 | Decimal Places: 0 | Mandatory Field: No | Revision: 0 | Ascii ID : - |
| Description: |
Please enter the project number.(The internal field ID for this element is "ProjNr") |
| Date |
| XML Element Name: | Date |
| Parent Element: | ProjectBooking |
| 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 "ProjDat")
|
| Service code |
| XML Element Name: | ServiceCode |
| Parent Element: | ProjectBooking |
| 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 "LeArtNr")
|
| Service Categorie |
| XML Element Name: | ServiceCategory |
| Parent Element: | ProjectBooking |
| 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 "LeKatNr")
|
| Service type |
| XML Element Name: | ServiceType |
| Parent Element: | ProjectBooking |
| 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 "LeTypNr")
|
| Currency |
| XML Element Name: | Currency |
| Parent Element: | ProjectBooking |
| Field Type: | Text |
| Action Type: | Import und Export |
| Field Length: 3 | Decimal Places: 0 | Mandatory Field: No | Revision: 0 | Ascii ID : - |
| Description: |
(The internal field ID for this element is "IsoCode")
|
| Unit |
| XML Element Name: | Unit |
| Parent Element: | ProjectBooking |
| 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 "Menge")
|
| Internal rate |
| XML Element Name: | InternalRate |
| Parent Element: | ProjectBooking |
| Field Type: | Nummer |
| Action Type: | Import und Export |
| Field Length: 14 | Decimal Places: 4 | Mandatory Field: No | Revision: 0 | Ascii ID : - |
| Description: |
(The internal field ID for this element is "AnsatzInt")
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C. |
| Quantity |
| XML Element Name: | InternalQuantity |
| Parent Element: | ProjectBooking |
| Field Type: | Nummer |
| Action Type: | Import und Export |
| Field Length: 10 | Decimal Places: 4 | Mandatory Field: No | Revision: 0 | Ascii ID : - |
| Description: |
(The internal field ID for this element is "Anzahl")
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C. |
| Int. amount (VC) |
| XML Element Name: | InternalAmount |
| Parent Element: | ProjectBooking |
| Field Type: | Nummer |
| Action Type: | Import und Export |
| Field Length: 14 | Decimal Places: 4 | Mandatory Field: No | Revision: 0 | Ascii ID : - |
| Description: |
(The internal field ID for this element is "ValOwInt")
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C. |
| External rate |
| XML Element Name: | ExternalRate |
| Parent Element: | ProjectBooking |
| Field Type: | Nummer |
| Action Type: | Import und Export |
| Field Length: 14 | Decimal Places: 4 | Mandatory Field: No | Revision: 0 | Ascii ID : - |
| Description: |
(The internal field ID for this element is "AnsatzExt")
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C. |
| Ext. amount (VC) |
| XML Element Name: | ExternalAmount |
| Parent Element: | ProjectBooking |
| Field Type: | Nummer |
| Action Type: | Import und Export |
| Field Length: 14 | Decimal Places: 4 | Mandatory Field: No | Revision: 0 | Ascii ID : - |
| Description: |
(The internal field ID for this element is "ValOwExt")
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C. |
| Rate |
| XML Element Name: | Rate |
| Parent Element: | ProjectBooking |
| Field Type: | Nummer |
| Action Type: | Import und Export |
| Field Length: 6 | Decimal Places: 8 | Mandatory Field: No | Revision: 0 | Ascii ID : - |
| Description: |
(The internal field ID for this element is "Kurs")
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C. |
| Booking text |
| XML Element Name: | Text |
| Parent Element: | ProjectBooking |
| 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 "Text")
|
| Invoice code |
| XML Element Name: | SettlementCode |
| Parent Element: | ProjectBooking |
| 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 "AbrCode")
|
| Visa |
| XML Element Name: | VisaStatus |
| Parent Element: | ProjectBooking |
| Field Type: | Nummer |
| Action Type: | Import und Export |
| Field Length: 4 | Decimal Places: 0 | Mandatory Field: No | Revision: 0 | Ascii ID : - |
| Description: |
Until version 2003
For non-approved entries, the field is 0. For approved entries, it is the number of the user who approved the entry.
From version 2004
Values greater than 0: User who approved the entry.
Value equal to 0: Entry not approved
Values less than 0:
0 = Not approved by instance 1
-1 = Approved by instance 1
-2 = Visa refused by instance 1
0 = Not approved by instance 2
-10 = Approved by instance 2
-20 = Visa refused by instance 2
0 = Not approved by instance 2
-100 = Approved by instance 2
-200 = Visa refused by instance 2
(The internal field ID for this element is "Visum")
|
| Payroll type |
| XML Element Name: | PayrollType |
| Parent Element: | ProjectBooking |
| 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 "LoArtNr")
|
| CC no. |
| XML Element Name: | CostCentre1 |
| Parent Element: | ProjectBooking |
| 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 "KstNr")
|
| Contra CC |
| XML Element Name: | CreditCostCentre1 |
| Parent Element: | ProjectBooking |
| 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 "GKstNr")
|
| CC no. 2 |
| XML Element Name: | CostCentre2 |
| Parent Element: | ProjectBooking |
| 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 "KstNr2")
|
| Contra CC 2 |
| XML Element Name: | CreditCostCentre2 |
| Parent Element: | ProjectBooking |
| 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 "GKstNr2")
|
| Split rate |
| XML Element Name: | SplittingRate |
| Parent Element: | ProjectBooking |
| Field Type: | Nummer |
| Action Type: | Import und Export |
| Field Length: 4 | Decimal Places: 4 | Mandatory Field: No | Revision: 0 | Ascii ID : - |
| Description: |
(The internal field ID for this element is "SplitSatz")
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C. |
| VAT code |
| XML Element Name: | TaxCode |
| Parent Element: | ProjectBooking |
| Field Type: | Text |
| Action Type: | Import und Export |
| Field Length: 3 | Decimal Places: 0 | Mandatory Field: No | Revision: 0 | Ascii ID : - |
| Description: |
(The internal field ID for this element is "MwstCode")
|
| VAT rate |
| XML Element Name: | TaxRate |
| Parent Element: | ProjectBooking |
| Field Type: | Nummer |
| Action Type: | Import und Export |
| Field Length: 4 | Decimal Places: 4 | Mandatory Field: No | Revision: 0 | Ascii ID : - |
| Description: |
(The internal field ID for this element is "MwstSatz")
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C. |
| User |
| XML Element Name: | ModificationUser |
| Parent Element: | ProjectBooking |
| Field Type: | Nummer |
| Action Type: | Import und Export |
| Field Length: 8 | Decimal Places: 0 | Mandatory Field: No | Revision: 0 | Ascii ID : - |
| Description: |
Number of the ABACUS user who last modified the record.(The internal field ID for this element is "User") |
| Modification |
| XML Element Name: | ModificationDate |
| Parent Element: | ProjectBooking |
| 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 "MutDat")
|
| Person no. |
| XML Element Name: | EmployeeNumber |
| Parent Element: | ProjectBooking |
| 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 "MANr")
|
| Key |
| XML Element Name: | KeyField |
| Parent Element: | ProjectBooking |
| 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 "KeyField")
|
| Consecut. serv. of |
| XML Element Name: | ConsecutiveServiceOf |
| Parent Element: | ProjectBooking |
| 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 "IstFLAvon")
|
| Account |
| XML Element Name: | Account |
| Parent Element: | ProjectBooking |
| 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 "BelKonNr")
|
| Contra account |
| XML Element Name: | CreditAccount |
| Parent Element: | ProjectBooking |
| 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 "EntlKonNr")
|
| Debit |
| XML Element Name: | IsExpense |
| Parent Element: | ProjectBooking |
| 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 "IstBel")
|
| Division |
| XML Element Name: | Division |
| Parent Element: | ProjectBooking |
| 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 "GB")
|
| Book. type |
| XML Element Name: | BookingType |
| Parent Element: | ProjectBooking |
| 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 "VerbTyp")
|
| Invoice type |
| XML Element Name: | InvoiceType |
| Parent Element: | ProjectBooking |
| 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 "AbrTyp")
|
| Invoice number |
| XML Element Name: | InvoiceNumber |
| Parent Element: | ProjectBooking |
| Field Type: | Nummer |
| Action Type: | Import und Export |
| Field Length: 8 | Decimal Places: 0 | Mandatory Field: No | Revision: 0 | Ascii ID : - |
| Description: |
If the entry is invoiced (AbrTyp=3), PeriodeNr is the relation to the invoice table.
Invoice header:
NAB.DataSet = 2, NAB.AbrNr = PeriodeNr
Invoice item:
NAB.DataSet = 3, NAB.AbrNr = PeriodeNr, NAB.ProjNr = ProjNr, NAB.AbrCode = AbrCode, NAB.BuchArt = ...., NAB.RefNr = RefNr and NAB.SplitNr = SplitNr
(The internal field ID for this element is "PeriodeNr")
|
| Cancellation date |
| XML Element Name: | CancellationDate |
| Parent Element: | ProjectBooking |
| 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 "StornoDat")
|
| Customer address |
| XML Element Name: | CustomerAddressNumber |
| Parent Element: | ProjectBooking |
| 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 "KDINR")
|
| Doc. no. |
| XML Element Name: | DocumentNumber |
| Parent Element: | ProjectBooking |
| 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 "BelegNr")
|
| Reference 1 |
| XML Element Name: | Reference1 |
| Parent Element: | ProjectBooking |
| Field Type: | Nummer |
| Action Type: | Import und Export |
| Field Length: 8 | Decimal Places: 0 | Mandatory Field: No | Revision: 0 | Ascii ID : - |
| Description: |
Field for reference in external application(The internal field ID for this element is "SamNr") |
| Reference 2 |
| XML Element Name: | Reference2 |
| Parent Element: | ProjectBooking |
| Field Type: | Nummer |
| Action Type: | Import und Export |
| Field Length: 8 | Decimal Places: 0 | Mandatory Field: No | Revision: 0 | Ascii ID : - |
| Description: |
Entries from Project management: See radiovalues 0 = Standard entry 1 = Revenue entry from invoice program 2 = Surcharges/deductions from invoice program 3 = Automatic entry from deadline control 5 = Entry from activity 10 = Holiday carry-forward from prev. year 11 = Holiday credit for current year 12 = Holiday correction 14 = Budget entry from payment plan. In this case, ProjNo = NPM.ProjNo, SeqNo = NPM.Budget and SamNo = NPM.ID 15 = Budget entry from rough planning 16 = Budget entry from detailed planning 17 = Entry generated with report proposal 18 = Entry generated by task. In this case, [Reference3] = Task ID 20 = Entries generated from project contract 21 = Entries generated by activity from project contract 22 = Booking entered on AbaClik 3 or higher 23 = Booking entered on MyAbacus with DeepBox recognition 24 = Flat-rate expense 25 = Manual flat-rate 30 = Entries generated by archiving program. In this case, [Reference1] = Archiving run number 31 = Flextime carry-forward 32 = Difference entry for time control 33 = Entry recorded in iPad 34 = Entry recorded in AbaClik 35 = Entry recorded in work report app 36 = Absence entry from the service schedule 37 = In&Out entry from the service schedule 38 = Entry from AbaPoint 39 = Entry from AbaUnit 40 = Contract link to contract with periodic invoicing 41 = Contract link to contract with invoicing at execution 42 = Correction entry from fee invoice. In this case [Reference1] = NAB.AbrNr and [Reference3] = NIV.VertragId 43 = Entry generated by E-Business 44 = Booking a time surcharge 45 = Booking a monetary surcharge 46 = Contract booking for a periodical. In this case, the [Reference1] = the periodical number. 47 = Booking created from a periodical. In this case, the [Reference1] = the periodical number. 48 = Booking a paid break 49 = Booking of an NCA surcharge 50 = Incident booking from the home administration. In this case [Reference1] = NHW.event [Reference3] = Resident entry no. and BelPosNr = NES.SetNr 51 = Precalculated incident booking from the home administration. In this case [Reference1] = NHW.event [Reference3] = Resident entry no. and BelPosNr = NES.SetNr 60 = Entry generated by allocations. In this case [Reference3] = NES.SetNr and [Reference1] = NES.EntryNr 70 = Entry generated by travel costs 80 = Entry generated by absence 90 = Holiday balance carried forward from the previous year 91 = Public holiday credit for current year 92 = Rest day balance carried forward WHA 93 = Rest day credit WHA for current year 94 = Time supplement carryforward 95 = Rest day carried forward 96 = AbaClock booking 97 = Booking an on-call lump sum from the AbaPlan 98 = Booking of an on-call flat rate from the difference booking 99 = Booking from Outlook integration Entries from ORDE: 1 = Debit entry from ORDE purchase. In this case, BelegNr = BPO.LeiErfVerdNum (version 2001 or older) 2 = Debit entry from ORDE sales. In this case, BelegNr = DPO.LeiErfVerdNum 3 = Revenue entry from ORDE sales. In this case, BelegNr = DPO.LeiErfVerdNum 4 = Debit entry from ORDE purchase. In this case, BelegNr = BPO.LeiErfVerdNum (from version 2002) 5 = Debit entry from ORDE purchase procurement costs. In this case, BelegNr = BPO.LeiErfVerdNum (from version 2002) Entries from Account Payable [Reference1] = KPS.FVbLfNr [Reference2] = KPS.FVbLfDat [Reference3] = KPS.FVbTrNr Until version 2000: [Reference1] = GIK.SAMNRSL [Reference2] = GIK.BU_SEQGR [Reference3] = GIK.BU_SEQNR Entries from Account Receivable [Reference1] = Digits 3 - 10 of document no. (Trunc(BelegNr / 100)) [Reference2] = Digits 1 + 2 of document number (BelegNr - (Trunc(BelegNr / 100) * 100.0)) [Reference3] = BelPosNr; For reposted entries, the fields [Reference1], [Reference2] and [Reference3] = 0 Entries from General Ledger [Reference1] = Journal reference, digits 1+2 letter, digits 3+4 year or 00, e.g. E04 is 0504 [Reference2] = Division [Reference3] = Entry number (REC)(The internal field ID for this element is "SeqGr") |
| Reference 3 |
| XML Element Name: | Reference3 |
| Parent Element: | ProjectBooking |
| Field Type: | Nummer |
| Action Type: | Import und Export |
| Field Length: 8 | Decimal Places: 0 | Mandatory Field: No | Revision: 0 | Ascii ID : - |
| Description: |
Field for reference in external application(The internal field ID for this element is "SeqNr") |
| Doc. date |
| XML Element Name: | DocumentDate |
| Parent Element: | ProjectBooking |
| 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 "BelDatum")
|
| Quantity ext. |
| XML Element Name: | ExternalQuantity |
| Parent Element: | ProjectBooking |
| Field Type: | Nummer |
| Action Type: | Import und Export |
| Field Length: 10 | Decimal Places: 4 | Mandatory Field: No | Revision: 0 | Ascii ID : - |
| Description: |
(The internal field ID for this element is "AnzahlExt")
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C. |
| Asset |
| XML Element Name: | InventoryNumber |
| Parent Element: | ProjectBooking |
| 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 "Anlage")
|
| Asset transaction type |
| XML Element Name: | InventoryTransactionType |
| Parent Element: | ProjectBooking |
| 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 "AnlBewArt")
|
| Supplier |
| XML Element Name: | SupplierAddressNumber |
| Parent Element: | ProjectBooking |
| 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 "Lieferant")
|
| Author |
| XML Element Name: | CreatedBy |
| Parent Element: | ProjectBooking |
| Field Type: | Nummer |
| Action Type: | Import und Export |
| Field Length: 8 | Decimal Places: 0 | Mandatory Field: No | Revision: 0 | Ascii ID : - |
| Description: |
User who entered the booking(The internal field ID for this element is "CreaUser") |
| Has consecut. serv. |
| XML Element Name: | HasConsecutiveService |
| Parent Element: | ProjectBooking |
| 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 "HasFolgeL")
|
| Texts |
| XML Element Name: | HasText |
| Parent Element: | ProjectBooking |
| Field Type: | Nummer |
| Action Type: | Import und Export |
| Field Length: 2 | Decimal Places: 0 | Mandatory Field: No | Revision: 0 | Ascii ID : - |
| Description: |
The comments are saved in table NTB.
Reference:
NTB.Prg = 11
NTB.Bez = RefNr
(The internal field ID for this element is "HasComment")
|
| Warn. |
| XML Element Name: | HasWarnings |
| Parent Element: | ProjectBooking |
| Field Type: | Nummer |
| Action Type: | Import und Export |
| Field Length: 2 | Decimal Places: 0 | Mandatory Field: No | Revision: 0 | Ascii ID : - |
| Description: |
Warnings(The internal field ID for this element is "HasFlags") |
| Start time |
| XML Element Name: | TimeFrom |
| Parent Element: | ProjectBooking |
| 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 "AzVon")
|
| End time |
| XML Element Name: | TimeTo |
| Parent Element: | ProjectBooking |
| 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 "AzBis")
|
| Euro coefficient |
| XML Element Name: | EuroCoefficient |
| Parent Element: | ProjectBooking |
| Field Type: | Nummer |
| Action Type: | Import und Export |
| Field Length: 6 | Decimal Places: 8 | Mandatory Field: No | Revision: 0 | Ascii ID : - |
| Description: |
(The internal field ID for this element is "EuroKoeff")
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C. |
| Payr. book. type |
| XML Element Name: | PayrollBookingType |
| Parent Element: | ProjectBooking |
| 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 "LVerbTyp")
|
| G/L book. type |
| XML Element Name: | GeneralLedgerBookingType |
| Parent Element: | ProjectBooking |
| 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 "FVerbTyp")
|
| Asset book. type |
| XML Element Name: | InventoryBookingType |
| Parent Element: | ProjectBooking |
| 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 "IVerbTyp")
|
| Free number 1 |
| XML Element Name: | FreeNumber1 |
| Parent Element: | ProjectBooking |
| 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 "UserNum1")
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C. |
| Free number 2 |
| XML Element Name: | FreeNumber2 |
| Parent Element: | ProjectBooking |
| 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 "UserNum2")
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C. |
| Free text 1 |
| XML Element Name: | FreeText1 |
| Parent Element: | ProjectBooking |
| 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 "UserASCII1")
|
| Free text 2 |
| XML Element Name: | FreeText2 |
| Parent Element: | ProjectBooking |
| 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 "UserASCII2")
|
| Free text 3 |
| XML Element Name: | FreeText3 |
| Parent Element: | ProjectBooking |
| 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 "UserASCII3")
|
| Employee group |
| XML Element Name: | EmployeeGroup |
| Parent Element: | ProjectBooking |
| 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 "EmplGroup")
|
| Inv. addr. |
| XML Element Name: | InvoiceAddress |
| Parent Element: | ProjectBooking |
| 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 "Fakturaadr")
|
| State |
| XML Element Name: | FreeNumber3 |
| Parent Element: | ProjectBooking |
| 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 "UserStatus")
|
| Rough plan |
| XML Element Name: | GeneralPlanNumber |
| Parent Element: | ProjectBooking |
| 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 "GrobPlan")
|
| Detailed plan |
| XML Element Name: | DetailPlanNumber |
| Parent Element: | ProjectBooking |
| 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 "DetailPlan")
|
| Entry set number |
| XML Element Name: | SetNumber |
| Parent Element: | ProjectBooking |
| 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 "SetNr")
|
| Sequence entry set number |
| XML Element Name: | SubSetNumber |
| Parent Element: | ProjectBooking |
| 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 "FSetNr")
|
| Repetition |
| XML Element Name: | Repetition |
| Parent Element: | ProjectBooking |
| 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 "Wiederholung")
|
| Order / contract no. |
| XML Element Name: | OrderNumber |
| Parent Element: | ProjectBooking |
| Field Type: | Nummer |
| Action Type: | Import und Export |
| Field Length: 10 | Decimal Places: 0 | Mandatory Field: No | Revision: 0 | Ascii ID : - |
| Description: |
Reference to ORDE order
Reference to SCM contract
(The internal field ID for this element is "AufNr")
|
| Backlog/sequence no. |
| XML Element Name: | OrderBacklogNumber |
| Parent Element: | ProjectBooking |
| Field Type: | Nummer |
| Action Type: | Import und Export |
| Field Length: 4 | Decimal Places: 0 | Mandatory Field: No | Revision: 0 | Ascii ID : - |
| Description: |
Reference to ORDE order
Reference to SCM contract
(The internal field ID for this element is "AufRNr")
|
| Item no. |
| XML Element Name: | OrderProcessingNumber |
| Parent Element: | ProjectBooking |
| Field Type: | Nummer |
| Action Type: | Import und Export |
| Field Length: 8 | Decimal Places: 0 | Mandatory Field: No | Revision: 0 | Ascii ID : - |
| Description: |
Reference to ORDE order
Reference to SCM contract
(The internal field ID for this element is "PosNr")
|
| Set / installation item no. |
| XML Element Name: | OrderProcessingSetNumber |
| Parent Element: | ProjectBooking |
| Field Type: | Nummer |
| Action Type: | Import und Export |
| Field Length: 8 | Decimal Places: 0 | Mandatory Field: No | Revision: 0 | Ascii ID : - |
| Description: |
Reference to ORDE order
Reference to SCM contract
(The internal field ID for this element is "SetPNr")
|
| Variant item no. |
| XML Element Name: | OrderProcessingSubNumber |
| Parent Element: | ProjectBooking |
| Field Type: | Nummer |
| Action Type: | Import und Export |
| Field Length: 8 | Decimal Places: 0 | Mandatory Field: No | Revision: 0 | Ascii ID : - |
| Description: |
Reference to ORDE order
Reference to SCM contract
(The internal field ID for this element is "SubPosNr")
|
| Operation centre |
| XML Element Name: | OperationCentre |
| Parent Element: | ProjectBooking |
| 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 "Werkhof")
|
| Inventory no. |
| XML Element Name: | OperationCentreInventoryNumber |
| Parent Element: | ProjectBooking |
| 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 "InventarNr")
|
| Service object |
| XML Element Name: | ObjectNumber |
| Parent Element: | ProjectBooking |
| 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 "ObjectNr")
|
| Credit no. |
| XML Element Name: | CreditNumber |
| Parent Element: | ProjectBooking |
| 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 "GuthabenNr")
|
| Credit item no. |
| XML Element Name: | CreditItemNumber |
| Parent Element: | ProjectBooking |
| 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 "GuthabenPosNr")
|
| Internal construction rate |
| XML Element Name: | InternalConstructionRate |
| Parent Element: | ProjectBooking |
| 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 "BauAsInt")
|
| External construction rate |
| XML Element Name: | ExternalConstructionRate |
| Parent Element: | ProjectBooking |
| 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 "BauAsExt")
|
| Product number |
| XML Element Name: | ProductNumber |
| Parent Element: | ProjectBooking |
| 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 "Produkt")
|
| Storage loc. |
| XML Element Name: | StockLocation |
| Parent Element: | ProjectBooking |
| Field Type: | Text |
| 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 "LagerOrt")
|
| Storage area |
| XML Element Name: | BinLocation |
| Parent Element: | ProjectBooking |
| Field Type: | Text |
| 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 "LagerPlatz")
|
| Constr. type |
| XML Element Name: | ConstructionType |
| Parent Element: | ProjectBooking |
| 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 "BauTyp")
|
| Price scheme |
| XML Element Name: | PriceScheme |
| Parent Element: | ProjectBooking |
| 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 "PreisSchema")
|
| Fixed price |
| XML Element Name: | FixPrice |
| Parent Element: | ProjectBooking |
| 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 "FixPreis")
|
| Rebooking from/to |
| XML Element Name: | RebookingFromTo |
| Parent Element: | ProjectBooking |
| Field Type: | Nummer |
| Action Type: | Import und Export |
| Field Length: 10 | Decimal Places: 0 | Mandatory Field: No | Revision: 0 | Ascii ID : - |
| Description: |
If an entry is rebooked, the reference number for the resulting entry/original entry is saved in the field.(The internal field ID for this element is "CorrectOfRefNr") |
| Employment |
| XML Element Name: | EmployeeContract |
| Parent Element: | ProjectBooking |
| Field Type: | Nummer |
| Action Type: | Import und Export |
| Field Length: 8 | Decimal Places: 0 | Mandatory Field: No | Revision: 0 | Ascii ID : - |
| Description: |
Terms of employment of employee(The internal field ID for this element is "EmplContract") |
| Date of origin |
| XML Element Name: | EmployeePeriodeDate |
| Parent Element: | ProjectBooking |
| Field Type: | Datum (2000-03-20) |
| Action Type: | Import und Export |
| Field Length: - | Decimal Places: 0 | Mandatory Field: No | Revision: 0 | Ascii ID : - |
| Description: |
If this date is filled in, the date is passed to the payroll.
This can be used when the date per the current month must be included in the G/L but per the older date in the payroll settlement.
(The internal field ID for this element is "EmplPeriodeDate")
|
| Accident insurance (unit number) |
| XML Element Name: | UnitNumberOfAccidentInsurance |
| Parent Element: | ProjectBooking |
| 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 "UV_BBNR")
|
| Accident insurance (risk tariff position) |
| XML Element Name: | RiskTariffPositionOfAccidentInsurance |
| Parent Element: | ProjectBooking |
| 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 "UV_GTS_ID")
|
| Stack number |
| XML Element Name: | StackNumber |
| Parent Element: | ProjectBooking |
| 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 "Stapel")
|
| Project management books cross-divisionally |
| XML Element Name: | CrossDivisionStock |
| Parent Element: | ProjectBooking |
| Field Type: | Boolean (true oder false) |
| Action Type: | Import und Export |
| Field Length: - | Decimal Places: 0 | Mandatory Field: No | Revision: 0 | Ascii ID : - |
| Description: |
Project Management stock entries trigger cross-divisional entries, the stock accounting creates the stock outgoing entry.(The internal field ID for this element is "CrossDivisionStock") |
| Company credit card |
| XML Element Name: | CreditCardId |
| Parent Element: | ProjectBooking |
| 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 "CreditCardId")
|
| Unique key |
| XML Element Name: | UID |
| Parent Element: | ProjectBooking |
| 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")
|
| Job |
| XML Element Name: | BuildJob |
| Parent Element: | ProjectBooking |
| Field Type: | Text |
| Action Type: | Import und Export |
| Field Length: 12 | Decimal Places: 0 | Mandatory Field: No | Revision: 0 | Ascii ID : - |
| Description: |
Job detail from AbaBuild(The internal field ID for this element is "BauJob") |