UFN_REVENUE_ISPOSTED

Validates that the revenue is a posted.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@REVENUEID	uniqueidentifier	IN

Definition

Copy



CREATE function dbo.UFN_REVENUE_ISPOSTED (@REVENUEID uniqueidentifier)
returns bit
  with execute as caller
as
begin
  if exists (
      select 1
      from dbo.FINANCIALTRANSACTION
      where ID = @REVENUEID
        and (POSTSTATUSCODE = 2)
        and (TYPECODE in (0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 15))
        and (DELETEDON is null)
      )
    return 1;

  return 0;
end