UFN_PLANNEDGIFT_AUTOCALCULATE_REALIZEDAMOUNT
Checks if an planned gift's realized amount should be auto-calculated.
Return
| Return Type |
|---|
| bit |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @PLANNEDGIFTID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.UFN_PLANNEDGIFT_AUTOCALCULATE_REALIZEDAMOUNT
(
@PLANNEDGIFTID as uniqueidentifier
)
returns bit
with execute as caller
as
begin
declare @AUTOCALCULATE as bit
set @AUTOCALCULATE = 0;
select
@AUTOCALCULATE = 1
from
dbo.PLANNEDGIFT
left join dbo.PLANNEDGIFTVEHICLEOPTIONS on
PLANNEDGIFTVEHICLEOPTIONS.VEHICLECODE = PLANNEDGIFT.VEHICLECODE
where
PLANNEDGIFT.ID = @PLANNEDGIFTID and
PLANNEDGIFTVEHICLEOPTIONS.AUTOCALCULATEREALIZEDAMOUNT = 1 and
PLANNEDGIFT.AUTOCALCULATEREALIZEDAMOUNT = 1
return @AUTOCALCULATE
end