1. Home
  2. Documentation
  3. Onventis Buyer
  4. Administration
  5. Interfaces
  6. openTRANS

openTRANS

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
INTERNATIONAL_RESTRICTIONS Element not used
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
SOURCING_INFO procurement information
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:

  • Customer order number in format “CustomerNr_” + number
  • Commission number in the format “CommissionNr_” + number
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
INTERNATIONAL_RESTRICTIONS International delivery restrictions
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:

  • Customer order number in format “CustomerNr_” + number
  • Commission number in the format “CommissionNr_” + number
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
INTERNATIONAL_RESTRICTIONS International delivery restrictions
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:

  • Customer order number in format “CustomerNr_” + number
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 _scroll_external/icons/help_16-76f497e85dd24204935137d91394f235515dc4206d3fc8c6103c50c7ec4682d9.svg
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:

  • “Canceled” if the item was cancelled
  • “Added” when position was added
  • “Confirmed” when the position was confirmed
  • “NotConfirmed” if the position was not confirmed.
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
BUYER_PARTY
SUPPLIER_PARTY
SHIPMENT_PARTIES
MEANS_OF_TRANSPORT
PACKAGE_INFO
INTERNATIONAL_RESTRICTIONS
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
SUPPLIER_PARTY
SHIPMENT_PARTIES
PACKAGE_INFO
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
COST_ACCOUNT General ledger account

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:

  • For BUYER_PARTY, the ordering user
  • For DELIVERY_PARTY, the ordering user if configured accordingly (only for ORDER)
  • For SUPPLIER_PARTY, the supplier’s contact person, if defined
  • Not available for INVOICE_PARTY
STREET String Street name and house number 100
ZIP String Zip code 20
BOXNO String P.O. Box number 20
ZIPBOX String Zip code for P.O. Box
CITY String City 50
COUNTRY String Country 50
STATE String Federal state

Only available for ORDER AND ORDERCHANGE

_scroll_external/icons/help_16-76f497e85dd24204935137d91394f235515dc4206d3fc8c6103c50c7ec4682d9.svg
VAT_ID String Tax number

Not available for BUYER_PARTY

_scroll_external/icons/help_16-76f497e85dd24204935137d91394f235515dc4206d3fc8c6103c50c7ec4682d9.svg
PHONE type=”office” String Telephone number 50
FAX String Fax number 50
EMAIL String Email address 200
PUBLIC_KEY String Public key
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_FLAG Boolean Price indicator (e.g. with/without freight charges)
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
EMAIL String Email address 200
PUBLIC_KEY type=”LoginName”* String Login name 100
PUBLIC_KEY type=”UserNr”* String User number _scroll_external/icons/help_16-76f497e85dd24204935137d91394f235515dc4206d3fc8c6103c50c7ec4682d9.svg
URL Homepage of the contact person

CONTROL_INFO

CONTROL_INFO
Element Data type Description Length
STOP_AUTOMATIC_PROCESSING String Interruption of automatic processing in the target system  
GENERATOR_INFO String Information on the document’s creator

Fixed value: “Onventis GmbH openTRANS .Net Generator V1.0”

_scroll_external/icons/help_16-76f497e85dd24204935137d91394f235515dc4206d3fc8c6103c50c7ec4682d9.svg
GENERATION_DATE DateTime Time stamp of document creation 19
MIME_ROOT String Mime base directory

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
MANUFACTURER_TYPE_DESCR Manufacturer’s type designation

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 _scroll_external/icons/help_16-76f497e85dd24204935137d91394f235515dc4206d3fc8c6103c50c7ec4682d9.svg _scroll_external/icons/help_16-76f497e85dd24204935137d91394f235515dc4206d3fc8c6103c50c7ec4682d9.svg
ONV-MULTI_ACCOUNTING_QUANTITY   _scroll_external/icons/help_16-76f497e85dd24204935137d91394f235515dc4206d3fc8c6103c50c7ec4682d9.svg _scroll_external/icons/help_16-76f497e85dd24204935137d91394f235515dc4206d3fc8c6103c50c7ec4682d9.svg   _scroll_external/icons/help_16-76f497e85dd24204935137d91394f235515dc4206d3fc8c6103c50c7ec4682d9.svg
ONV-MULTI_ACCOUNTING_PERCENTAGE _scroll_external/icons/help_16-76f497e85dd24204935137d91394f235515dc4206d3fc8c6103c50c7ec4682d9.svg _scroll_external/icons/help_16-76f497e85dd24204935137d91394f235515dc4206d3fc8c6103c50c7ec4682d9.svg _scroll_external/icons/help_16-76f497e85dd24204935137d91394f235515dc4206d3fc8c6103c50c7ec4682d9.svg
ONV-MULTI_ACCOUNTING_COST_CATEGORY_ID type=”cost_center” _scroll_external/icons/help_16-76f497e85dd24204935137d91394f235515dc4206d3fc8c6103c50c7ec4682d9.svg _scroll_external/icons/help_16-76f497e85dd24204935137d91394f235515dc4206d3fc8c6103c50c7ec4682d9.svg _scroll_external/icons/help_16-76f497e85dd24204935137d91394f235515dc4206d3fc8c6103c50c7ec4682d9.svg
ONV-MULTI_ACCOUNTING_COST_TYPE _scroll_external/icons/help_16-76f497e85dd24204935137d91394f235515dc4206d3fc8c6103c50c7ec4682d9.svg _scroll_external/icons/help_16-76f497e85dd24204935137d91394f235515dc4206d3fc8c6103c50c7ec4682d9.svg _scroll_external/icons/help_16-76f497e85dd24204935137d91394f235515dc4206d3fc8c6103c50c7ec4682d9.svg

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. _scroll_external/icons/help_16-76f497e85dd24204935137d91394f235515dc4206d3fc8c6103c50c7ec4682d9.svg

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
PARTIAL_SHIPMENT_ALLOWED Partial shipment is allowed (only at header level)
TRANSPORT Transport conditions (only at header level)
INTERNATIONAL_RESTRICTIONS International shipping restrictions
SPECIAL_TREATMENT_CLASS type=”…” String Dangerous goods class

Default type=”GGVS”

30
MIME_INFO MIME additions (attachments)
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 _scroll_external/icons/help_16-76f497e85dd24204935137d91394f235515dc4206d3fc8c6103c50c7ec4682d9.svg
REMARK type=”Onv-AssetNr1″* String Plant (Field 1) _scroll_external/icons/help_16-76f497e85dd24204935137d91394f235515dc4206d3fc8c6103c50c7ec4682d9.svg
REMARK type=”Onv-AssetNr2″* String Plant (Field 2) _scroll_external/icons/help_16-76f497e85dd24204935137d91394f235515dc4206d3fc8c6103c50c7ec4682d9.svg
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

_scroll_external/icons/help_16-76f497e85dd24204935137d91394f235515dc4206d3fc8c6103c50c7ec4682d9.svg
REMARK type=”Onv-AgreementLineID” Framework agreement line item number

Only in ORDER

_scroll_external/icons/help_16-76f497e85dd24204935137d91394f235515dc4206d3fc8c6103c50c7ec4682d9.svg
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 _scroll_external/icons/help_16-76f497e85dd24204935137d91394f235515dc4206d3fc8c6103c50c7ec4682d9.svg
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 _scroll_external/icons/help_16-76f497e85dd24204935137d91394f235515dc4206d3fc8c6103c50c7ec4682d9.svg

Only in ORDERCHANGE

19 _scroll_external/icons/help_16-76f497e85dd24204935137d91394f235515dc4206d3fc8c6103c50c7ec4682d9.svg
REMARK type=”Onv-IsEndReceived” Boolean _scroll_external/icons/help_16-76f497e85dd24204935137d91394f235515dc4206d3fc8c6103c50c7ec4682d9.svg 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:

  • For BUYER_PARTY: Number of the customer’s organizational unit
  • For SUPPLIER_PARTY: Customer’s number for the supplier
  • For INVOICE_PARTY: Number of the invoicing address
  • For DELIVERY_PARTY: Number of the delivery address, or “default” value in the event of fallback to the main address

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
ACCOUNT Bank details
DEBIT Self-billing procedure
CHECK Check payment
CASH Cash payment

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_AUTH_CODE PIN
CARD_REF_NUM Reference number
CARD_EXPIRATION_DATE DateTime Date of the purchase order 19
CARD_TYPE String Card type, content is always “Onventis” 50
CARD_TYPE_OTHER Another card type
CARD_HOLDER_NAME String User’s last name 100

TRANSPORT

TRANSPORT
Element Data type Description Length
INCOTERM String INCOTERM code of the delivery condition _scroll_external/icons/help_16-76f497e85dd24204935137d91394f235515dc4206d3fc8c6103c50c7ec4682d9.svg
LOCATION String Location where the goods are handed over _scroll_external/icons/help_16-76f497e85dd24204935137d91394f235515dc4206d3fc8c6103c50c7ec4682d9.svg
TRANSPORT_REMARK String Comments

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_DELIVERY_PARTY Final recipient
TRANSPORT_PARTY Logistics service provider

SOURCING_INFO

SOURCING_INFO
Element Data type Description Length
QUOTATION_ID Quotation number (for items from a price inquiry)
AGREEMENT Framework agreement
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