/* CustomerOrder.p */
DEFINE TEMP-TABLE OrderDetails FIELD OrderNum LIKE Order.OrderNum FIELD SalesRep LIKE Order.SalesRep FIELD OrderDate LIKE Order.OrderDate FIELD ShipDate LIKE Order.ShipDate FIELD TotalDollars AS DECIMAL FIELD OrderStatus LIKE Order.OrderStatus. |
public class OrderDetailsRow {
private java.lang.Integer orderNum; private java.lang.String salesRep; private java.util.Date orderDate; private java.util.Date shipDate; private java.math.BigDecimal totalDollars; private java.lang.String orderStatus; ...} |