Required XML Transaction Data

When creating maps between XML elements and Eclipse database elements, some transaction types have data that is required to send the transaction through the system.

Required Data for Customer Transactions

The following data is required for transactions you send to or receive from your customers:

Transaction Type

Required Data Mapped to Eclipse

Order Submit

Request for Quote

  • ShipTo – Can be either the Eclipse ID or the customer e-commerce ID.

  • ProductIdentifier – Can be the UPC, product keywords, product ID, or the customer part number.

  • TotalQty – Defaults to one each for each product if you do not map data to this element, or if this element is mapped but the XML document contains no data.

Product Inquiry

  • ProductIdentifier – Can be the UPC, product keywords, product ID, or customer part number.

Order Inquiry

  • OrderID.

Change Order Request

  • ChangeType – Free form text is allowed.

  • OrderID or CustomerPONumber.

  • Any elements that identify the changes to the order.

Required Data for Vendor Transactions

The following data is required for transactions you send to or receive from your vendors:

Transaction Type

Required Data Mapped to Eclipse

Order Acknowledgement

Advance Ship Notice

Invoice

  • OrderID.

  • PayTo or ShipFrom.

  • ProductIdentifier – Can be the UPC code, product ID, customer part number, or vendor catalog number.

  • TotalQty – The total quantity on the order.

    When creating a transaction map for an order acknowledgement that you receive from your vendor, map the full ordered quantity from the vendor's DTD to TotalQty in Eclipse. If the full order quantity is not filled in and not correct, the system cannot match the acknowledgement to an order in your system.

    When creating a transaction map for an invoice that you receive from your vendor, map the number being shipped from the vendor's DTD to TotalQty in Eclipse.

Note: TotalQty and InStockShipQty are located under OrderDetail in the Vendor Order Acknowledgement transaction type.

  • InStockShipQty - Quantity available for shipment.

    When creating a transaction map for ab order acknowledgements that you receive from your vendor, map the total number of items being acknowledged from the vendor's DTD to the InStockShipQty in Eclipse. If the full order quantity is not filled in and not correct, the system cannot match the acknowledgement to an order in your system.

Note: TotalQty and InStockShipQty are located under OrderDetail in the Vendor Order Acknowledgement transaction type.

Direct Order Submit

  • ShipTo. Located under the CustomerSalesOrderID element in a vendor direct order submit transaction. The CustomerSalesOrderID element references the header information specific to the customer receiving the items on the direct order.

  • BillTo.  Located under the CustomerSalesOrderID element in a vendor direct order submit transaction. The CustomerSalesOrderID element references the header information specific to the customer receiving the items on the direct order.

See Also:

Creating XML Transaction Maps

Valid XML Mappings and Precautions