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 ) |