UFN_SALESORDERITEM_GETFEES
Gets fees of a sales order item.
Return
| Return Type |
|---|
| money |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SALESORDERITEMID | uniqueidentifier | IN |
Definition
Copy
create function dbo.UFN_SALESORDERITEM_GETFEES(@SALESORDERITEMID uniqueidentifier)
returns money
with execute as caller
as begin
declare @FEES money
select @FEES =
sum(coalesce([FEEITEM].[PRICE] / [SALESORDERITEM].[QUANTITY], 0))
from [SALESORDERITEM]
left join [SALESORDERITEMFEE]
on [SALESORDERITEM].[ID] = [SALESORDERITEMFEE].[SALESORDERITEMID]
left join [SALESORDERITEM] as [FEEITEM]
on [SALESORDERITEMFEE].[ID] = [FEEITEM].[ID]
where [SALESORDERITEM].[ID] = @SALESORDERITEMID
set @FEES = coalesce(@FEES, 0.0)
return @FEES
end