UFN_SALESORDER_TOTAL

Gets the total for all items in an order

Return

Return Type
money

Parameters

Parameter Parameter Type Mode Description
@SALESORDERID uniqueidentifier IN

Definition

Copy


CREATE function dbo.UFN_SALESORDER_TOTAL(@SALESORDERID uniqueidentifier)
returns money
with execute as caller
as begin
    return (select TOTAL from dbo.UFN_SALESORDER_TOTALS(@SALESORDERID));
end