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 fieldnameis a property in the item list.
sumq.fieldname The sum of the value of the specified field for each item, where fieldnameis 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.

Copyright © 2005 Microsoft Corporation.
All rights reserved.