UFN_PLANNEDGIFT_ISRECEIPTABLE
Checks planned gift setup to see if a vehicle type is included in the receipt settings.
Return
| Return Type |
|---|
| bit |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @VEHICLECODE | tinyint | IN |
Definition
Copy
create function dbo.UFN_PLANNEDGIFT_ISRECEIPTABLE
(
@VEHICLECODE tinyint
)
returns bit
with execute as caller
as begin
declare @ISRECEIPTABLE as bit
if exists (select 1 from dbo.PLANNEDGIFTRECEIPTVEHICLE where VEHICLECODE = @VEHICLECODE)
select @ISRECEIPTABLE = 1
else
select @ISRECEIPTABLE = 0
return @ISRECEIPTABLE
end