About the Order Lines Message Part

This part uses a SQL statement to specify that the Meeting Title Base Part should display a table with information the order lines from a particular order. See Creating a Derived Part for more information on this type of message part.

This part uses the following SQL statement to populate the Data Table:

• SQL: SELECT Description, Quantity, Price, Discount, Extended FROM APTIFY..vwOrderDetails WHERE OrderID=<%ID%> ORDER BY Sequence

The remaining input properties specify formatting options for the table. See the Message Parts record's Input Map tab for details.