This documentation describes the openTRANS documents generated by Onventis.
The documents are based on the openTRANS Standard version 1.0 with specific adaptations.
Notes on interpretation
- Since the documents can contain Onventis-specific enhancements (for example, for transferring multiple account assignments), they cannot always be technically validated against the standard definition.
- Fields that are defined as “optional” fields in the standard system are mostly only transmitted if a value exists. If these are missing in the document, this should therefore be interpreted as “empty”.
- Since fields can be added at any time and the sequence of the elements can change, the position of a node within the document should not be used for importing the document.
Legend
The elements and subnodes are listed in the tables. Changes compared to openTRANS Standard 1.0 are highlighted in red.
Subnodes with their own elements are linked to the node description.
Elements of the standard that are not output by Onventis (e.g. because the corresponding information is not used in Onventis) are displayed crossed out.
ADDRESS | |||
Element | data type | Description | length |
NAME | String | Element with deviation in the maximum field length | 100 |
CONTACT | Linked subnode | ||
REMARK type=”Onv-CustomsTariffNumber”* | String | Element that is only output if the corresponding configuration has been made. | 11 |
SAP_DATA | String | Onventis-specific field | 100 |
Purchase order – ORDER
In this chapter all openTRANS fields exported by Onventis in the ORDER document and the deviations from the standard are explained.
ORDER
ORDER | |||
Element | data type | description | length |
ORDER_HEADER | header level | ||
ORDER_ITEM_LIST | item level | ||
ORDER_SUMMARY | summary |
ORDER_HEADER
ORDER_HEADER | |||
Element | data type | description | length |
CONTROL_INFO | control infomation | ||
ORDER_INFO | order information |
ORDER_INFO
ORDER_INFO | |||
Element | data type | description | length |
ORDER_ID | String | order number | 35 |
ALT_CUSTOMER_ORDER_ID | String | Further order numbers of the purchaser:
|
35 |
ORDER_DATE | DateTime | oreder timestamp | 19 |
DELIVERY_DATE type=”optional” | delivery date Depending on whether the field “Delivery date” is filled. |
||
ORDER_PARTIES | business partner | ||
PRICE_CURRENCY | String | Currency, e.g. EUR | 3 |
PAYMENT | payment procedures
Depending on whether the field “Purchase-Card No.” of the customer is filled. |
||
TERMS_AND_CONDITIONS* | String | Terms of delivery | 200 |
PARTIAL_SHIPMENT_ALLOWED | Boolean | Defines whether a partial delivery is possible. | 4 |
TRANSPORT | Terms of delivery | ||
REMARK type=”Onv-Title”* | String | Order title
Organization-specific adjustable by indicator. Only transferred if the fields are filled. |
200 |
REMARK type=”Onv-RemarkExtern”* | String | External comment | 10.000 |
REMARK type=”Onv-RemarkIntern”* | String | Internal comment | 10.000 |
REMARK type=”general” | String | External comment | 10.000 |
REMARK type=”Onv-UserGroup”* | String | Purchasing group no. | 35 |
REMARK type=”Onv-User”* | String | User n. of the creator | 35 |
REMARK type=”Onv-PaymentTerms”* | String | Payment terms | 200 |
REMARK type=”Onv-ShippingTypeName” | String | Delivery terms title | 475 |
REMARK type=”Onv-ShippingTypeNr” | String | Shipping type – Number | 35 |
REMARK type=”Onv-ShippingCostNet” | Decimal | Shipping costs net | 20 |
REMARK type=”Onv-ShippingCostGross” | Decimal | Shipping costs gross | 20 |
REMARK type=”PaymentMethods-Nr” | String | Zahlwege-Nr. | 35 |
REMARK type=”PaymentMethods” | String | Payment method no. | 100 |
REMARK type=”Onv-AddCost1Text”* | String | Additional costs – Text
A total of three additional costs can be indicated (AddCost1, AddCost2, AddCost3). |
200 |
REMARK type=”Onv-AddCost1TaxRate”* |
Decimal | Additional costs – VAT rate | 5 |
REMARK type=”Onv-AddCost1Price”* |
Decimal | Additional costsn – Value | 9 |
REMARK type=”Onv-SapCompCode” | String | SAP-Company code | 35 |
REMARK type=”Onv-SapCoArea” | String | SAP-Controlling area | 35 |
REMARK type=”Onv-SapPurchaseOrg” | String | SAP-Purchasing organization | 35 |
REMARK type=”Onv-PurchaseCardNumber”* | String | Purchase-Card number of the user | 19 |
REMARK type=”User id”* | String | Fixed user name for the connection (parameterizable) | |
REMARK type=”Password”* | String | Fixed password for the connection (parameterizable) | |
REMARK type=”Onv-CustomerNr-By-Provider”* | String | Number of the customer organization at its provider organization | 35 |
REMARK type=”Onv-RFQNr” | String | Number of the RFQ on which the purchase order is based, if any. | 35 |
REMARK type=”Onv-ActionUserName”* | String | Loginname of the sending user | 50 |
REMARK type=”Onv-PackagingInstruction” | String | Number of the RFQ on which the purchase order is based, if exist. | 35 |
ORDER_ITEM_LIST
ORDER_ITEM_LIST consists in the openTRANS standard only of the element ORDER_ITEM which represents an order item and can therefore occur several times.
ORDER_SUMMARY
ORDER_SUMMARY is a (redundant) combination of the purchase order and contains only the two elements TOTAL_ITEM_NUM and TOTAL_AMOUNT.
ORDER_SUMMARY | |||
Element | Data type | Description | Length |
TOTAL_ITEM_NUM | Integer | Number of items | 4 |
TOTAL_AMOUNT | Decimal | Gross total of the order | 9 |
Order change – ORDERCHANGE
This chapter explains all openTRANS fields exported by Onventis in the ORDERCHANGE document and the deviations from the standard.
ORDERCHANGE
The XML file starts with the main element “ORDERCHANGE” and contains the header (“ORDERCHANGE_HEADER”), the position list (“ORDERCHANGE_ITEM_LIST”) and the summary (“ORDERCHANGE_SUMMARY”).
ORDER | |||
Element | Data type | Description | Length |
ORDERCHANGE_HEADER | Header level | ||
ORDERCHANGE_ITEM_LIST | Item level | ||
ORDERCHANGE_SUMMARY | Summary |
ORDERCHANGE_HEADER
ORDERCHANGE_HEADER in the openTRANS standard consists of the elements “CONTROL_INFO” and “ORDERCHANGE_INFO”.
ORDERCHANGE_HEADER | |||
Element | Data type | Description | Length |
CONTROL_INFO | Control information | ||
ORDERCHANGE_INFO | Order information |
ORDERCHANGE_INFO
ORDERCHANGE_INFO | |||
Element | Data type | Desription | Length |
ORDER_ID | String | Order number | 35 |
ALT_CUSTOMER_ORDER_ID | String | Further order numbers of the purchaser:
|
35 |
ORDER_DATE | DateTime | Time stamp of the order | 19 |
SUPPLIER_ORDER_ID | String | Order number of the supplier | 35 |
ORDERCHANGE_DATE | DateTime | Date of order change | 19 |
ORDERCHANGE_SEQUENCE_ID | Integer | Change sequence | 10 |
ORDER_PARTIES | Bussiness partner | ||
PRICE_CURRENCY | String | Currency, e.g. EUR | 3 |
TERMS_AND_CONDITIONS* | String | Delivery terms | 200 |
PARTIAL_SHIPMENT_ALLOWED | Boolean | Defines whether a partial delivery is possible. | 4 |
TRANSPORT | Delivery terms | ||
REMARK type=”Onv-Title”* | String | Order title | 200 |
REMARK type=”Onv-Incoterm”* | String | Delivery terms (Drop-Down) | 50 |
REMARK type=”Onv-DeliveryTermsLocation”* | String | (Delivery-) Location | 200 |
REMARK type=”Onv-RemarkExtern”* | String | External comment | 10.000 |
REMARK type=”Onv-RemarkIntern”* | String | Internal comment | 10.000 |
REMARK type=”general”* | String | External comment | 10.000 |
REMARK type=”Onv-UserGroup”* | String | Purchase group no. | 35 |
REMARK type=”Onv-User”* | String | User no. of the creator | 35 |
REMARK type=”Onv-PaymentTerms”* | String | Payment terms | 200 |
REMARK type=”PaymentMethods-Nr”* | String | Payment method no. | 35 |
REMARK type=”PaymentMethods”* | String | Payment method title | 100 |
REMARK type=”Onv-AddCost1Text”* | String | Additional costs – Text
A total of three additional costs can be specified (AddCost1, AddCost2, AddCost3). |
200 |
REMARK type=”Onv-AddCost1TaxRate”* |
Decimal | Additional costs – VAT rate | 5 |
REMARK type=”Onv-AddCost1Price”* |
Decimal | Additional costs – value | 9 |
REMARK type=”Onv-PurchaseCardNumber”* | String | Purchase-Card number of the user | 19 |
REMARK type=”Onv-ActionUserName” | String | Loginname of the sending user | 50 |
REMARK type=”Onv-PackagingInstruction” | String | Packaging instruction code, if available | 35 |
ORDERCHANGE_ITEM_LIST
ORDERCHANGE_ITEM_LIST consists in the openTRANS standard only of the element ORDER_ITEM which represents an order item as in ORDER_ITEM_LIST and can therefore occur several times.
ORDERCHANGE_SUMMARY
ORDERCHANGE_SUMMARY contains only the two elements TOTAL_ITEM_NUM and TOTAL_AMOUNT.
ORDERCHANGE_ SUMMARY | |||
Element | Data type | Description | Length |
TOTAL_ITEM_NUM | Integer | Number of items | 4 |
TOTAL_AMOUNT | Decimal | Total amount of the order change | 9 |
Order confirmation – ORDERRESPONSE
This chapter explains all openTRANS fields exported by Onventis in the ORDERCHANGE document and the deviations from the standard.
ORDERRESPONSE
ORDERRESPONS | |||
Element | Data type | Description | Length |
ORDERRESPONSE_HEADER | Header level | ||
ORDERRESPONSE_ITEM_LIST | Item level | ||
ORDERRESPONSE_SUMMARY | Summary |
ORDERRESPONSE_HEADER
ORDER_HEADER | |||
Element | Data type | Description | Length |
CONTROL_INFO | Control information | ||
ORDERRESPONSE_INFO | Order information |
ORDERRESPONSE_INFO
ORDERRESPONSE_INFO | |||
Element | Data type | Description | Length |
ORDER_ID | String | Order number | 35 |
ALT_CUSTOMER_ORDER_ID | String | Further order numbers of the purchaser:
|
35 |
SUPPLIER_ORDER_ID | String | Order number of the supplier | 35 |
ORDER_DATE | DateTime | Time stamp of the order | 8 |
ORDERCHANGE_SEQUENCE_ID | Integer | Change sequence | |
ORDERRESPONSE_DATE | DateTime | Date of order confirmation | 8 |
DELIVERY_DATE type=”optional”* | Dalivery date | ||
ORDER_PARTIES | Bussiness partner | ||
PRICE_CURRENCY | String | Currency, e.g. EUR | 3 |
REMARK type=”general” | String | External comment of order confirmation | 10.000 |
REMARK type=”order” | String | External comment of order | 10.000 |
TRANSPORT* | Delivery terms
By configuration, either as “TRANSPORT” or as REMARK fields (see below). |
||
REMARK type=”buyer” | String | Customer comment on the release or rejection of an order change | 10.000 |
REMARK type=”Onv-Incoterm”* | String | Delivery terms (Drop-Down) | 50 |
REMARK type=”Onv-DeliveryTermsLocation”* | String | (Delivery-) Location | 200 |
REMARK type=”Onv-DeliveryTerms”* | String | Delivery terms | 100 |
REMARK type=”Onv-PaymentTerms”* | String | Payment terms | 100 |
REMARK type=”Onv-AddCost1Text” | String | Additional costs – Text
A total of three additional costs can be specified (AddCost1, AddCost2, AddCost3). |
200 |
REMARK type=”Onv-AddCost1TaxRate” |
Decimal | Additional costs – VAT rate | 5 |
REMARK type=”Onv-AddCost1Price” |
Decimal | Additional costs – value | 9 |
REMARK type=”Onv-PackagingInstruction” | String | Packaging instruction code, if available | 35 |
ORDERRESPONSE_ITEM_LIST
ORDERRESPONSE_ITEM_LIST consists in the openTRANS standard only of the element ORDERRESPONSE_ITEM which represents an order item and can therefore occur several times.
ORDERRESPONSE_ITEM
ORDERRESPONSE_ITEM | |||
Element | Data type | Description | Length |
LINE_ITEM_ID | Integer | Item number | 4 |
ARTICLE_ID | Article number | ||
QUANTITY | Decimal | Quantity | 9 |
ORDER_UNIT | String | Unit | 40 |
ARTICLE_PRICE type=”net_list” | Price information | ||
DELIVERY_DATE type=”optional” | Delivery date | ||
ONV-DELIVERY_SCHEDULE | Delivery schedule | ||
SHIPMENT_PARTIES | Item delivery address | ||
REMARK type=”Onv-RemarkExtern”* | String | External comment of the position | 10.000 |
REMARK type=”general” | String | External comment of the position | 10.000 |
REMARK type=”Onv-Title” | String | Title of position | 100 |
REMARK type=”Onv-Description” | String | Description of the item | 10.000 |
REMARK type=”Onv-Modified” | TinyInt | Indicates whether the position was changed (1) or not changed (0). | 1 |
REMARK type=”Onv-Status” | String | Übergibt die folgenden Status:
|
35 |
REMARK type=”Onv-SalesOrderNrIntern” | String | Order number | 35 |
REMARK type=”Onv-ResetTaxRate” | Boolean | Reset tax rate (reverse charge procedure) | |
REMARK type=”Onv-ContentUnit”* | String | Article content unit | 50 |
REMARK type=”Onv-DiscountRelative” | Decimal | Absolute discount (positive value) or surcharge (negative value) | |
REMARK type=”Onv-DiscountAbsolute” | Decimal | Relative discount (positive value) or surcharge (negative value) |
ORDERRESPONSE_SUMMARY
ORDERRESPONSE_SUMMARY contains only the two elements TOTAL_ITEM_NUM and TOTAL_AMOUNT.
ORDERRESPONSE_ SUMMARY | |||
Element | Data type | Description | Length |
TOTAL_ITEM_NUM | Integer | Number of items | 4 |
TOTAL_AMOUNT | Decimal | Net total of the order | 9 |
Delivery note / shipping notification – DISPATCHNOTIFICATION
This chapter explains all openTRANS fields exported by Onventis in the DISPATCHNOTIFICATION document and the deviations from the standard.
DISPATCHNOTIFICATION
A delivery note always refers to an order. The reference is specified in the header in the field REMARK type=”Onv-Order”, and at item level in the nodes ORDER_REFERENCE and SUPPLIER_ORDER_REFERENCE.
DISPATCHNOTIFICATION | |||
Element | Data type | Description | Length |
DISPATCHNOTIFICATION_HEADER | Header level | ||
DISPATCHNOTIFICATION_ITEM_LIST | Item level | ||
DISPATCHNOTIFICATION_SUMMARY | Summary |
DISPATCHNOTIFICATION_HEADER
Element | Data type | Description | Length |
CONTROL_INFO | Control information | ||
DISPATCHNOTIFICATION_INFO | Shipping information |
DISPATCHNOTIFICATION_INFO
DISPATCHNOTIFICATION_INFO | |||
Element | Data type | Description | Length |
DISPATCHNOTIFICATION_ID | String | Shipping number | 35 |
DISPATCHNOTIFICATION_DATE | DateTime | Time stamp of the shipping document | 19 |
ORDER_PARTIES | Businness parnter | ||
REMARK type=”Onv-Order” | String | Order number for delivery note | 35 |
REMARK type=”Onv-SalesOrder” | String | Order number of the supplier | 35 |
REMARK type=”Onv-DeliveryTerms” | String | Delivery terms | 100 |
REMARK type=”general” | String | External comment | 10.000 |
SHIPMENT_ID | String | Tracking-Number | 35 |
REMARK type=”Onv-LogisticsServiceProvider” | String | Parcel service | 250 |
DISPATCHNOTIFICATION_ITEM_LIST
In the openTRANS standard, DISPATCHNOTIFICATION_ITEM_LIST only consists of the element DISPATCHNOTIFICATION_ITEM which represents a position and can therefore occur more than once.
DISPATCHNOTIFICATION_ITEM
DISPATCHNOTIFICATION_ITEM | |||
Element | Data type | Description | Length |
LINE_ITEM_ID | Integer | Item number | 4 |
ARTICLE_ID | Article | ||
QUANTITY | Decimal | Quantity | 9 |
ORDER_UNIT | String | Unit | 40 |
DELIVERY_COMPLETED | Boolean | Indicator whether the item has been finally delivered (TRUE) or not yet completely delivered (FALSE). | |
DELIVERY_DATE type=”fixed” | Deliver date
Only DELIVERY_END_DATE |
||
ORDER_REFERENCE | Reference Information for Ordering the Goods Receipt Confirmation | ||
SUPPLIER_ORDER_REFERENCE | Reference Information for the Order of the Goods Receipt Confirmation | ||
REMARK type=”general” | String | External comment of the position | 10.000 |
DISPATCHNOTIFICATION_SUMMARY
DISPATCHNOTIFICATION_SUMMARY contains only the element TOTAL_ITEM_NUM.
DISPATCHNOTIFICATION_ SUMMARY | |||
Element | Data type | Description | Length |
TOTAL_ITEM_NUM | Integer | Number of items | 4 |
Wareneingang – RECEIPTACKNOWLEDGEMENT
This chapter explains all openTRANS fields exported by Onventis in the RECEIPTACKNOWLEDGEMENT document and the deviations from the standard.
RECEIPTACKNOWLEDGEMENT
RECEIPTACKNOWLEDGEMENT | |||
Element | Data type | Description | Length |
RECEIPTACKNOWLEDGEMENT_HEADER | Header level | ||
RECEIPTACKNOWLEDGEMENT_ITEM_LIST | Item level | ||
RECEIPTACKNOWLEDGEMENT_SUMMARY | Summary |
RECEIPTACKNOWLEDGEMENT _HEADER
RECEIPTACKNOWLEDGEMENT _HEADER | |||
Element | Data type | Description | Length |
CONTROL_INFO | Control information | ||
RECEIPTACKNOWLEDGEMENT_INFO | Order information |
RECEIPTACKNOWLEDGEMENT_HEADER
RECEIPTACKNOWLEDGEMENT_INFO | |||
Element | Data type | Description | Length |
RECEIPTACKNOWLEDGEMENT_ID | String | Goods receipt number | 35 |
RECEIPTACKNOWLEDGEMENT_DATE | DateTime | Time stamp of goods receipt confirmation | 8 |
RECEIPT_DATE | DateTime | Time stamp of the goods receipt confirmation (such as RECEIPTACKNOWLEDGEMENT_DATE) | 8 |
BUYER_PARTY | Customer data | ||
SUPPLIER_PARTY | Supplier data | ||
DELIVERY_PARTY | Delivery adress | ||
REMARK type=”general” | String | External Comment for Goods Receipt Confirmation | 10.000 |
RECEIPTACKNOWLEDGEMENT_ITEM_LIST
RECEIPTACKNOWLEDGEMENT_ITEM_LIST in the openTRANS standard only consists of the element RECEIPTACKNOWLEDGEMENT_ITEM which represents a position and can therefore occur several times.
RECEIPTACKNOWLEDGEMENT_ITEM
RECEIPTACKNOWLEDGEMENT_ITEM | |||
Element | Data type | Description | Length |
LINE_ITEM_ID | Integer | Item number | 4 |
ARTICLE_ID | Article number | ||
QUANTITY | Decimal | Quantity | 9 |
ORDER_UNIT | String | Unit | 40 |
DELIVERY_COMPLETED | Boolean | Indicator whether the item has been finally delivered (TRUE) or not yet completely delivered (FALSE). | |
RECEIPT_DATE | DateTime | Time stamp of goods receipt confirmation | 8 |
ORDER_REFERENCE | Reference Information for Ordering the Goods Receipt Confirmation | ||
SUPPLIER_ORDER_REFERENCE | Reference Information for the Order of the Goods Receipt Confirmation | ||
DELIVERY_REFERENCE | Reference information on the delivery | ||
DELIVERY_PARTY | delivery address | ||
REMARK type=”general” | String | External comment of the position | 10.000 |
SAP_DATA* | SAP-Assignment |
RECEIPTACKNOWLEDGEMENT_SUMMARY
RECEIPTACKNOWLEDGEMENT_SUMMARY contains only the element TOTAL_ITEM_NUM.
RECEIPTACKNOWLEDGEMENT_ SUMMARY | |||
Element | Data type | Description | Length |
TOTAL_ITEM_NUM | Integer | Number of items | 4 |
Common elements
ACCOUNTING_INFO
ACCOUNTING_INFO | |||
Element | Data type | Description | Length |
COST_CATEGORY_ID type=”cost_center” | String | Cost center | 35 |
COST_TYPE | String | General ledger account | 35 |
ADDRESS
ADDRESS | |||
Element | Data type | Description | Length |
NAME | String | Company name | 100 |
NAME2 | String | Name affix | 100 |
NAME3 | String | Building/floor | 100 |
DEPARTMENT | String | Department | 100 |
CONTACT | Details for the contact person:
|
||
STREET | String | Street name and house number | 100 |
ZIP | String | Zip code | 20 |
BOXNO | String | P.O. Box number | 20 |
CITY | String | City | 50 |
COUNTRY | String | Country | 50 |
STATE | String | Federal state
Only available for ORDER AND ORDERCHANGE |
|
VAT_ID | String | Tax number
Not available for BUYER_PARTY |
|
PHONE type=”office” | String | Telephone number | 50 |
FAX | String | Fax number | 50 |
String | Email address | 200 | |
URL | String | Homepage | 100 |
ARTICLE_ID
ARTICLE_ID | |||
Element | Data type | Description | Length |
SUPPLIER_AID | String | Supplier’s item number
Fallback to supplier’s internal item number and manufacturer’s number (configurable) |
35 |
INTERNATIONAL_AID type=”EAN” | String | International item number (EAN)
For ORDER, ORDERCHANGE, ORDERRESPONSE, DISPATCHNOTIFICATION, INVOICE |
35 |
BUYER_AID type=”CommissionNr”* | String | Commission number
For ORDER, ORDERCHANGE, RECEIPTACKNOWLEDGEMENT |
35 |
BUYER_AID type=”OrderPosition/CommissionNr” | String | Commission number
For INVOICE |
|
BUYER_AID type=”Onv-InternalArticleNr” | String | Internal item number
For QUOTATION, ORDER, ORDERCHANGE, ORDERRESPONSE, INVOICE |
35 |
BUYER_AID type=”Owner_NrExtern”* | String | Import number for catalog item
For ORDER, ORDERCHANGE, ORDERRESPONSE, DISPATCHNOTIFICATION, INVOICE |
35 |
BUYER_AID type=”Buyer_InternalArticleNr”* | String | Customer-specific internal item number for catalog item
For ORDER, ORDERCHANGE, ORDERRESPONSE, DISPATCHNOTIFICATION, INVOICE |
35 |
BUYER_AID type=”Buyer_SupplierArticleNr”* | String | Customer-specific supplier item number for catalog item
For ORDER, ORDERCHANGE, ORDERRESPONSE, DISPATCHNOTIFICATION, INVOICE |
35 |
BUYER_AID type=”Seller_InternalArticleNr”* | String | Supplier-specific internal item number for catalog item
For ORDER, ORDERCHANGE, ORDERRESPONSE, DISPATCHNOTIFICATION, INVOICE |
35 |
BUYER_AID type=”Seller_SupplierArticleNr”* | String | Supplier-specific supplier item number for catalog item
For ORDER, ORDERCHANGE, ORDERRESPONSE, DISPATCHNOTIFICATION, INVOICE |
35 |
DESCRIPTION_SHORT | String | Title of line item | 200 |
DESCRIPTION_LONG | String | Description of line item (without HTML) | 10,000 |
MANUFACTURER_INFO | Manufacturer’s item information
Transferred if a manufacturer item number has been stored. |
ARTICLE_PRICE
ARTICLE_PRICE | |||
Element | Data type | Description | Length |
PRICE_AMOUNT | Decimal | Unit price | 9 |
PRICE_LINE_AMOUNT | Decimal | Net line item price | 9 |
TAX | Decimal | Tax rate
Value between 0 and 1, e.g. 0.19 |
5 |
TAX_AMOUNT | Decimal | Tax amount | 9 |
PRICE_QUANTITY | Decimal | Price unit | 9 |
ONV- PRICE_BASE_FIX* | Conversion information for different order quantities and pricing units, based on openTRANS Standard 2.0 with Onventis-specific adjustments | ||
ONV-ALLOW_OR_CHARGES_FIX * | Additional conditions, based on openTRANS Standard 2.0 with Onventis-specific adjustments |
ONV-ALLOW_OR_CHARGES_FIX
Onventis-proprietary node for transmission of additional conditions (discounts/surcharges), based on openTrans 2.0 but with certain minor modifications.
ONV-ALLOW_OR_CHARGES_FIX | |||
Element | Data type | Description | Length |
ALLOW_OR_CHARGE type=”allowance” | Discount | ||
ALLOW_OR_CHARGE type=”surcharge” | Surcharge | ||
ONV-PRICE_BASE_FIX | Conversion information for discounts/surcharges for different order quantities and pricing units |
ALLOW_OR_CHARGE
Onventis-proprietary node for transmission of an additional condition (discount/surcharge), based on openTrans 2.0 but with certain minor modifications.
ALLOW_OR_CHARGE | |||
Element | Data type | Description | Length |
ALLOW_OR_CHARGE_SEQUENCE | Integer | Ranking number for sorting and calculation | 4 |
ALLOW_OR_CHARGE_NAME | String | Number/code of the additional condition | 35 |
ALLOW_OR_CHARGE_DESCR | String | Description of the additional condition | 100 |
ALLOW_OR_CHARGE_BASE | Integer | Indication of the value to be used as the basis for calculations. 1 = basic price (transferred in the field ONV-AOC_BASEPRICE_AMOUNT) 2 = value accumulated up to the condition |
4 |
ALLOW_OR_CHARGE_VALUE | Condition values |
ALLOW_OR_CHARGE_VALUE
Onventis-proprietary node for transmission of the value of an additional condition, based on openTrans 2.0 but with certain minor modifications.
The condition value is transmitted in this node. Depending on the type in question (e.g. percentage) only one of the fields is used.
ALLOW_OR_CHARGE_VALUE | |||
Element | Data type | Description | Length |
AOC_PERCENTAGE _FACTOR | Decimal | Percentage condition value | 18.4 |
AOC_MONETARY_AMOUNT | Decimal | Absolute condition value. | 18.4 |
ONV-AOC_BASEPRICE_AMOUNT | Decimal | Basic price of the line item. | 18.4 |
ONV-AOC_PRICE_UNIT_AMOUNT | Decimal | Absolute condition value per pricing unit (e.g. per 1 piece) | 18.4 |
ONV-PRICE_BASE_FIX
Onventis-proprietary node for transmission of price conversion information, based on openTrans 2.0 but with certain minor modifications.
This node contains all the information needed to carry out conversions between different order quantities and pricing units (e.g. 1 piece corresponds to 150 kg, explained in more detail in the field descriptions below). The fields PRICE_AMOUNT and PRICE_QUANTITY are also required for conversion purposes.
ONV-PRICE_BASE_FIX | |||
Element | Data type | Description | Length |
ONV-PRICE_QUANTITY | Decimal | Pricing unit quantity (only used within ONV-ALLOW_OR_CHARGES_FIX) | 18.4 |
ONV-PRICE_QUANTITY_UNIT | String | Pricing unit, e.g. KG | 40 |
ONV-ORDER_UNIT_FACTOR | Decimal | Conversion factor for the order unit. Defines the number of order quantity units to which the quantity specified in ONV-PRICE_UNIT_FACTOR corresponds (e.g. 1 piece). | 18.4 |
ONV-PRICE_UNIT_FACTOR | Decimal | Conversion factor for the pricing unit. (Based on the example of 150 kg) |
18.4 |
BUYER_PARTY, SUPPLIER_PARTY, INVOICE_PARTY, DELIVERY_PARTY
…_PARTY | |||
Element | Data type | Description | Length |
PARTY | Business partner |
CATALOG_REFERENCE
CATALOG_REFERENCE | |||
Element | Data type | Description | Length |
CATALOG_ID | String | Identification number for the catalog | 35 |
CATALOG_VERSION | String | Always has the value “0.0”! | 35 |
CATALOG_NAME | String | Name of the catalog | 1000 |
CONTACT
CONTACT | |||
Element | Data type | Description | Length |
CONTACT_NAME | String | The first and last name of the contact person (100 characters + spaces each) | 201 |
PHONE type=”office” | String | Telephone number | 50 |
FAX | String | Fax number | 50 |
String | Email address | 200 | |
PUBLIC_KEY type=”LoginName”* | String | Login name | 100 |
PUBLIC_KEY type=”UserNr”* | String | User number | |
CONTROL_INFO
CONTROL_INFO | |||
Element | Data type | Description | Length |
GENERATOR_INFO | String | Information on the document’s creator
Fixed value: “Onventis GmbH openTRANS .Net Generator V1.0” |
|
GENERATION_DATE | DateTime | Time stamp of document creation | 19 |
DELIVERY_DATE
ORDER_ITEM | |||
Element | Data type | Description | Length |
DELIVERY_START_DATE | DateTime | Delivery date
Not supported for DISPATCHNOTIFICATION. |
19 |
DELIVERY_END_DATE | DateTime | Delivery date
Contains the same value as DELIVERY_START_DATE |
19 |
DELIVERY_REFERENCE
DELIVERY_REFERENCE | |||
Element | Data type | Description | Length |
DELIVERYNOTE_ID | String | Delivery note number | 35 |
LINE_ITEM_ID | Integer | Line item number | 4 |
DELIVERY_DATE type=”optional” | Delivery date
Only transferred in INVOICE_ITEM |
MANUFACTURER_INFO
MANUFACTURER_INFO | |||
Element | Data type | Description | Length |
MANUFACTURER_NAME | String | Manufacturer’s name | 100 |
MANUFACTURER_AID | String | Manufacturer’s item number | 70 |
ONV-DELIVERY_SCHEDULE
This node can be used to transmit several pieces of delivery data with associated quantities in connection with split deliveries.
ONV-DELIVERY_SCHEDULE | |||
Element | Data type | Description | Length |
LINE_NR | Integer | Unique split delivery count number. The split deliveries are output in number sequence, in ascending order. Deleted split deliveries are not transferred and can therefore be identified. | 4 |
DELIVERY_DATE | Delivery date | ||
QUANTITY | Decimal | Quantity | 9 |
ONV-MULTI_ACCOUNTING_INFO
This Onventis-specific node is output once per partial account allocation.
ONV-MULTI_ACCOUNTING_INFO | |||
Element | Data type | Description | Length |
ONV-MULTI_ACCOUNTING_LINE_NR | Integer | ||
ONV-MULTI_ACCOUNTING_QUANTITY | |||
ONV-MULTI_ACCOUNTING_PERCENTAGE | |||
ONV-MULTI_ACCOUNTING_COST_CATEGORY_ID type=”cost_center” | |||
ONV-MULTI_ACCOUNTING_COST_TYPE |
ORDER_ITEM
ORDER_ITEM | |||
Element | Data type | Description | Length |
LINE_ITEM_ID | Integer | Line item number | 4 |
ARTICLE_ID | Item number | ||
QUANTITY | Decimal | Quantity | 9 |
ORDER_UNIT | String | Quantity unit | 40 |
ARTICLE_PRICE type=”net_list” | Price information | ||
DELIVERY_DATE type=”optional” | Delivery date
Depends on whether the field “Delivery date” has been filled out. |
||
ONV-DELIVERY_SCHEDULE | Split delivery.
If this element is transferred, DELIVERY_DATE must not be available. |
||
SOURCING_INFO | Catalog reference
Only transferred in the case of catalog items. |
||
SHIPMENT_PARTIES | Line item delivery address | ||
ACCOUNTING_INFO* | Account allocation information
Depends on whether a cost center or cost type has been stored at line item level, not in the case of multiple account allocation. |
||
ONV-MULTI_ACCOUNTING_INFO | Account allocation information in the event of multiple account allocation | ||
SPECIAL_TREATMENT_CLASS type=”…” | String | Dangerous goods class
Default type=”GGVS” |
30 |
REMARK type=”Onv-RemarkExtern” * | String | External remark relating to the line item. | 10,000 |
REMARK type=”Onv-RemarkIntern”* | String | Internal remark relating to the line item | 10,000 |
REMARK type=”Onv-CostCenter2″* | String | Number of additional account 1 | 35 |
REMARK type=”Onv-CostCenter3″* | String | Number of additional account 2 | 35 |
REMARK type=”Onv-SalesOrderNr”* | String | Sales order number | 35 |
REMARK type=”Onv-ProjectNr”* | String | Project number | 35 |
REMARK type=”Onv-PspElementNr”* | String | PSP element number | |
REMARK type=”Onv-AssetNr1″* | String | Plant (Field 1) | |
REMARK type=”Onv-AssetNr2″* | String | Plant (Field 2) | |
REMARK type=”Onv-CostAllocationType”* | String | Account allocation type
Only in ORDER |
|
REMARK type=”Onv-NonChargeableJobNr” | String | Number of the non-chargeable job | 35 |
REMARK type=”Onv-ChargeableJobNr” | String | Number of the chargeable job | 35 |
REMARK type=”Onv-TaskNr” | String | Number of the task | 35 |
REMARK type=”general” | String | External remark relating to the line item | 10,000 |
REMARK type=”Onv-MaterialGroup” | String | Material group (product category)
Only in ORDER |
35 |
REMARK type=”Onv-Status” | String | Transfers “Canceled” if the line item has been canceled. | 35 |
REMARK type=”Onv-Consignee” | String | Goods recipient | 50 |
REMARK type=”Onv-UnloadingPoint”* | String | Unloading point | 50 |
REMARK type=”Onv-AgreementID” | Framework agreement number
Only in ORDER |
||
REMARK type=”Onv-AgreementLineID” | Framework agreement line item number
Only in ORDER |
||
REMARK type=”Onv-CustomsTariffNumber” | String | Customs tariff number | 11 |
REMARK type=”Onv-CountryOfOrigin” | String | Country of origin (ISO code) | 5 |
REMARK type=”Onv-ResetTaxRate” | Boolean | Reset tax rate (reverse charge procedure) | |
REMARK type=”Onv-ContentUnit”* | String | Item content unit | |
REMARK type=”Onv-DiscountRelative” | Decimal | Absolute discount (positive value) or surcharge (negative value) | |
REMARK type=”Onv-DiscountAbsolute” | Decimal | Relative discount (positive value) or surcharge (negative value) | |
REMARK type=”Onv-Modified” | DateTime | Change date for the purchase order
Only in ORDERCHANGE |
19 |
REMARK type=”Onv-IsEndReceived” | Boolean | Receipt of goods has already received final confirmation
Only in ORDERCHANGE |
|
SAP_DATA* | SAP assignment |
ORDER_PARTIES
ORDER_PARTIES is only a node and does not have any elements of its own. It contains up to four subnodes, which also do not have any elements of their own. Elements are only available from the subnode PARTY onwards.
ORDER_PARTIES | |||
Element | Data type | Description | Length |
BUYER_PARTY | Customer data | ||
SUPPLIER_PARTY | Supplier data | ||
INVOICE_PARTY | Invoice recipient | ||
SHIPMENT_PARTIES | Shipment parties |
ORDER_REFERENCE
ORDER_REFERENCE | |||
Element | Data type | Description | Length |
ORDER_ID | String | Order number | 35 |
LINE_ITEM_ID | Integer | Line item number | 4 |
ORDER_DATE | DateTime | Order date
Only transferred for INVOICE_ITEM |
8 |
CATALOG_REFERENCE | Catalog reference
Only transferred for INVOICE_ITEM |
PARTY
PARTY | |||
Element | Data type | Description | Length |
PARTY_ID type=”buyer_specific” | String | Identification number of the party:
The type which is to be transferred can be configured on an organization-specific basis using the indicator. If specified, contains the number of the relevant address. |
35 |
PARTY_ID type=”supplier_specific” | String | “Supplier’s number for customer” or “customer number” in the supplier account.
Only available for BUYER_PARTY. |
35 |
ADDRESS | Address |
PAYMENT
PAYMENT | |||
Element | Data type | Description | Length |
CARD | Purchase card | ||
CARD
This node is used to transfer the purchase card number stored in TradeCore.
The other fields are transferred because they are in mandatory fields in openTRANS, but they do not contain any useful information.
CARD | |||
Element | Data type | Description | Length |
CARD_NUM | String | Card number | 19 |
CARD_EXPIRATION_DATE | DateTime | Date of the purchase order | 19 |
CARD_TYPE | String | Card type, content is always “Onventis” | 50 |
CARD_HOLDER_NAME | String | User’s last name | 100 |
TRANSPORT
TRANSPORT | |||
Element | Data type | Description | Length |
INCOTERM | String | INCOTERM code of the delivery condition | |
LOCATION | String | Location where the goods are handed over | |
SAP_DATA
SAP_DATA | |||
Element | Data type | Description | Length |
SAP_PLANT | String | Number of the SAP plant | 35 |
SAP_WAREHOUSE | String | Number of the SAP storage location | 35 |
SAP_UNLOADPOINT | String | Unloading point | 50 |
SAP_RECIPIENT | String | Goods recipient | 50 |
SHIPMENT_PARTIES
SHIPMENT_PARTIES | |||
Element | Data type | Description | Length |
DELIVERY_PARTY | Delivery address | ||
Final recipient | |||
Logistics service provider |
SOURCING_INFO
SOURCING_INFO | |||
Element | Data type | Description | Length |
QUOTATION_ID | Quotation number (for items from a price inquiry) | ||
CATALOG_REFERENCE | Order reference to a catalog |
SUPPLIER_ORDER_REFERENCE
SUPPLIER_ORDER_REFERENCE | |||
Element | Data type | Description | Length |
SUPPLIER_ORDER_ID | String | Sales order number | 35 |
SUPPLIER_ORDER_ITEM_ID | Integer | Line item number | 4 |