Specifying the Basis Item Key
Many of the Order Processing pipeline components use a Basis Item Key to determine applicable rates. For this key, you can use any of the values in the following table.
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 the value of the specified field for each item, where fieldname is a property in the item list. |
sumq.fieldname |
The sum of the 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 shows some useful values for the 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 the QueryProdInfoADO component includes this field.) |
For example, if the sumq.
_product
_weight
key 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.