A transaction schema is one or more XML database schemas that define an XML transaction type. For example, Business Connect XML includes the following XML database schemas:
Order – Includes items such as the bill-to address and the payment terms.
OrderDetail – Contains the items being ordered, including product ID and total order quantities.
An order in the system includes the information required to ship the order and the information about what is being purchased or sold. The OrderSubmit transaction schema contains both the Order and OrderDetail database schemas to create a complete order submit transaction. An XML database schema can be included in more than one transaction schema. For example, the Order and OrderDetail schemas are also used to create an invoice transaction.
Note: Business Connect XML includes a set of predefined XML transaction types such as order submits and invoices. For a complete list of the supported customer and vendor transactions, see Sending and Receiving Customer Transactions Using XML and Sending and Receiving Vendor Transactions Using XML. You cannot create your own transaction schemas.
A transaction can be one of the following types:
Inbound inquiry, such as a price and availability check.
Inbound update, such as an order submit or change order from a customer or an invoice from a vendor.
Outbound, such as a purchase order you are sending to a vendor.
Transaction schemas defined in Eclipse are available for selection as transaction types in the Business Connect XML mapping utility. When you create a new transaction map in the mapping utility, select the transaction type, or schema, in the Transaction Type fields for both the received and sent documents:
The contents of the transaction schema display as the target or source XML in the mapping utility, depending on the type of transaction you are creating and whether you are viewing the received or sent to map. In the following example, the OrderSubmit transaction schema contains the Order and OrderDetail XML database schemas.
The order detail data is stored in the table called LineItemInfo defined for the OrderDetail XML database schema's properties, and displays nested in the XML mapping utility.
See Also:
XML Schema Maintenance Overview