Many of the OPP components use a Basis Item Key to determine applicable rates. For this field, you can use any of the following values.
| Basis Item Key prefix | Description |
|---|---|
order.fieldname |
The value of the specified field, where fieldname is a property on the order form. |
sum.fieldname |
The sum of value of the specified field for each item, where fieldname is a property in the item list. |
sumq.fieldname |
The sum of value of the specified field for each item, where fieldname is a property in the item list, times the quantity of that item. |
count |
The number of line items in the order form. (Does not depend on quantity of each item.) |
The following table illustrates some useful values for Basis Item Key:
| Example Basis Item Key | Result |
|---|---|
order._oadjust_subtotal |
Subtotal on the order form. |
sum.quantity |
Sum of all quantities (total number of items ordered). |
sum._oadjust_adjustedprice |
Sum of adjusted prices. |
sumq._iadjust_currentprice |
Sum of current price times quantity for all items in the order. |
sumq._product_weight |
Total weight of order. (Assumes that the weight column exists in the product table and that the query used by QueryProdInfoADO includes this field.) |
For example, if sumq._product_weight is specified, and if the order has two items, one item weighing 2 pounds with a quantity of 3 and the other item weighing 4 pounds with a quantity of 1, then the basis value is 10 pounds.