UFN_MEMBERSHIP_GETBASEAMOUNTDISCOUNT
Return
| Return Type |
|---|
| money |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @MEMBERSHIPTRANSACTIONID | uniqueidentifier | IN |
Definition
Copy
create function dbo.UFN_MEMBERSHIP_GETBASEAMOUNTDISCOUNT(@MEMBERSHIPTRANSACTIONID uniqueidentifier)
returns money
with execute as caller
as begin
return (select coalesce(sum(SOIMIP.AMOUNT), 0)
from dbo.SALESORDERITEMMEMBERSHIPITEMPROMOTION SOIMIP
inner join dbo.SALESORDERITEMMEMBERSHIP SOIM on SOIMIP.SALESORDERITEMID = SOIM.ID
where SOIM.MEMBERSHIPTRANSACTIONID = @MEMBERSHIPTRANSACTIONID )
end