SALESORDERITEM

Stores items that can be placed in a sales order.

For the full definition of the SALESORDERITEM table, see SALESORDERITEM.

Fields

Field Change Field Type Null Notes Description
TOTAL Changed money (Computed) yes convert(money, case PRICINGSTRUCTURECODE when 0 then QUANTITY * PRICE else FLATRATEPRICE end ) Expression changed from convert(money, case PRICINGSTRUCTURECODE when 0 then QUANTITY * PRICE else FLATRATEPRICE end ) to convert(money, case PRICINGSTRUCTURECODE when 0 then QUANTITY * PRICE else FLATRATEPRICE end )