UFN_INSTALLMENTSPLIT_REVENUESPLITIDVALID
Return
Return Type |
---|
bit |
Parameters
Parameter | Parameter Type | Mode | Description |
---|---|---|---|
@REVENUESPLITID | uniqueidentifier | IN |
Definition
Copy
create function dbo.UFN_INSTALLMENTSPLIT_REVENUESPLITIDVALID
(
@REVENUESPLITID uniqueidentifier
)
returns bit
with execute as caller
as begin
if @REVENUESPLITID is null
return 1
if exists(select ID from dbo.FINANCIALTRANSACTIONLINEITEM where ID = @REVENUESPLITID)
return 1
return 0
end