UFN_REVENUERECEIPTRERECEIPTDETAIL_OBEYSREGULATEDRECEIPTING

Determines if the supplied reason code id is valid based on condition settings

Return

Return Type
bit

Parameters

Parameter Parameter Type Mode Description
@REASONCODEID uniqueidentifier IN

Definition

Copy


create function dbo.UFN_REVENUERECEIPTRERECEIPTDETAIL_OBEYSREGULATEDRECEIPTING
(
@REASONCODEID uniqueidentifier
)
returns bit
with execute as caller
as begin
    if @REASONCODEID is null and exists (select * from dbo.CONDITIONSETTING where NAME = N'RegulatedReceipting' )
        return 0

    return 1
end