About the Order History Part Message Part

This part uses a SQL statement to specify that the Data Table Base Part should display a table of the orders where the message recipient is the Ship To person. See Creating a Derived Part for more information on this type of message part.

This part provides these input values for the Data Table:

• SQL: SELECT ID, OrderDate 'Order Date', Line1_ProductName 'Product Name', CALC_GrandTotal 'Grand Total' FROM APTIFY.dbo.vwOrders WHERE ShipToID=<%ID%>
• Title: This is your order history

Note that the other optional input properties are not specified and they use default HTML settings.