Interface:
ORDE
-
Calculation scheme
Version
2011.00
This documentation describes the AbaConnect Interface
Calculation scheme
for the
ORDE
Application.
General Information
General information about the AbaConnect interface.
| AbaConnect Interface Information |
| Application : | ORDE |
| Interface Name : | Calculation scheme |
| ID : | Kalkulationsschema
(
KAS
)
|
| Version : | 2011.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 : 0 |
Mapping Information
The following displays the Mapping details for this interface.
| Mapping ID : | AbaDefault |
| Mapping Name : | Calculation schema header data |
| 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>ORDE</Application>
<Id>Kalkulationsschema</Id>
<MapId>AbaDefault</MapId>
<Version>2011.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>
<CalculationSchemeHeader mode='SAVE'>
<!-- The specific data fields for the AbaConnect interface are included here. -->
</CalculationSchemeHeader>
</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"
"-aORDE"
"-version2011.00"
"-M7777"
"-acidKalkulationsschema"
"-mapidAbaDefault"
"-datamodeXML"
"-responseYES"
"-responsefileX:\response.xml"
"-exportfileX:\data.xml"
Import :
abaconnectimportconsole.exe "/USRuser" "/PWxxx"
"-aORDE"
"-version2011.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:
No | Revision:
0 | Ascii ID :
- |
| XML Element Name: | SchemeType |
| Parent Element: | CalculationSchemeHeaderFields |
| 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 "SCHEMATYP")
|
| XML Element Name: | SchemeNumber |
| Parent Element: | CalculationSchemeHeaderFields |
| Action Type: | Import und Export |
| Field Length:
8 | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
- |
| Description: |
Calculation schema designation in OTX
(The internal field ID for this element is "SCHEMANR")
|
| XML Element Name: | Currency |
| Parent Element: | CalculationSchemeHeaderFields |
| 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")
|
| XML Element Name: | Rounding |
| Parent Element: | CalculationSchemeHeaderFields |
| 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 "RUNDUNG")
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.
|
| XML Element Name: | StockLocation |
| Parent Element: | CalculationSchemeHeaderFields |
| 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")
|
| XML Element Name: | BinLocation |
| Parent Element: | CalculationSchemeHeaderFields |
| 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")
|
| XML Element Name: | CreationUser |
| Parent Element: | CalculationSchemeHeaderFields |
| Field Length:
6 | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
- |
| Description: |
(The internal field ID for this element is "ERSTELLTDURCH")
|
| XML Element Name: | CreationDate |
| Parent Element: | CalculationSchemeHeaderFields |
| Field Type: | Datum/Zeit (2006-08-08T10:16:54.509+02:00) |
| Field Length:
- | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
- |
| Description: |
(The internal field ID for this element is "ERSTELLTAM")
|
| Field Length:
6 | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
- |
| Description: |
(The internal field ID for this element is "MUTIERTDURCH")
|
| Field Type: | Datum/Zeit (2006-08-08T10:16:54.509+02:00) |
| Field Length:
- | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
- |
| Description: |
(The internal field ID for this element is "MUTIERTAM")
|
| XML Element Name: | Locked |
| Parent Element: | CalculationSchemeHeaderFields |
| Field Type: | Boolean (true oder false) |
| Field Length:
- | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
- |
| Description: |
(The internal field ID for this element is "GESPERRT")
|
| XML Element Name: | LockUser |
| Parent Element: | CalculationSchemeHeaderFields |
| Field Length:
6 | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
- |
| Description: |
(The internal field ID for this element is "GESPERRTDURCH")
|
| XML Element Name: | RateType |
| Parent Element: | CalculationSchemeHeaderFields |
| 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 "KURSART")
|
| XML Element Name: | Designation |
| Parent Element: | CalculationSchemeHeaderFields |
| 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")
|
| 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_ANSATZ1")
|
| 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_ANSATZ2")
|
| 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_ANSATZ3")
|
| 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 "KOSTEN1_RESANSATZ1")
|
| 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 "KOSTEN1_RESANSATZ2")
|
| 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 "KOSTEN1_RESANSATZ3")
|
| 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 "KOSTEN2_RESANSATZ1")
|
| 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 "KOSTEN2_RESANSATZ2")
|
| 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 "KOSTEN2_RESANSATZ3")
|
| 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 "KOSTEN3_RESANSATZ1")
|
| 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 "KOSTEN3_RESANSATZ2")
|
| 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 "KOSTEN3_RESANSATZ3")
|
| XML Element Name: | Item |
| Parent Element: | CalculationSchemeHeader |
| Action Type: | Import und Export |
| Field Length:
- | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
- |
| Action Type: | Import und Export |
| Field Length:
- | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
- |
| XML Element Name: | LineNumber |
| Parent Element: | ItemFields |
| Action Type: | Import und Export |
| Field Length:
4 | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
- |
| Description: |
Together with SCHEMANR reference to the
OTX-entry for the line designation:
OTX.BEREICH = 'SD', OTX.TYP = 'KZ', OTX.KOPF_ID = SCHEMANR, OTX.POS_NR = ZEILENNR
(The internal field ID for this element is "ZEILENNR")
|
| XML Element Name: | LineType |
| Parent Element: | ItemFields |
| 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 "ZEILENTYP")
|
| XML Element Name: | ValueType |
| Parent Element: | ItemFields |
| 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 "WERTETYP")
|
| Action Type: | Import und Export |
| Field Length:
12 | Decimal Places:
4 | Mandatory Field:
No | Revision:
0 | Ascii ID :
- |
| Description: |
Value or percentage
(The internal field ID for this element is "MANWERT")
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.
|
| XML Element Name: | Expression |
| Parent Element: | ItemFields |
| Field Length:
10 | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
- |
| Description: |
Formula
(The internal field ID for this element is "EXPRESSION")
|
| 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")
|
| 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 "BEZUGSZEILE")
|
| 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 "STANDARDLAGER")
|
| 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 "FIXPREISNR")
|
| XML Element Name: | Formula |
| Parent Element: | ItemFields |
| Action Type: | Import und Export |
| Field Length:
4048 | Decimal Places:
0 | Mandatory Field:
No | Revision:
0 | Ascii ID :
- |
| Description: |
(The internal field ID for this element is "FORMEL")
|