UFN_BILLINGITEM_CHARGEEXISTSFORBILLINGITEM

Check whether charge exists for the pass in billing item

Return

Return Type
int

Parameters

Parameter	Parameter Type	Mode
@BILLINGITEMID	uniqueidentifier	IN
@STARTDATE	date	IN
@ENDDATE	date	IN

Definition

Copy



            CREATE function dbo.UFN_BILLINGITEM_CHARGEEXISTSFORBILLINGITEM
(
    @BILLINGITEMID uniqueidentifier=null,
    @STARTDATE date = null,
    @ENDDATE date = null
)
returns int
as begin
    -- do work here and return a value

    declare @retval int;
    set @retval = 0;

    if (exists (select dbo.FINANCIALTRANSACTION.ID
         from  dbo.FINANCIALTRANSACTION 
            inner join dbo.FINANCIALTRANSACTIONLINEITEM
                on FINANCIALTRANSACTION.ID = FINANCIALTRANSACTIONLINEITEM.FINANCIALTRANSACTIONID
            inner join dbo.CHARGELINEITEM
                on CHARGELINEITEM.ID = FINANCIALTRANSACTIONLINEITEM.ID
        where dbo.CHARGELINEITEM.BILLINGITEMID=@BILLINGITEMID AND (@STARTDATE IS NULL OR (@STARTDATE<=dbo.FINANCIALTRANSACTION.[DATE] AND (@ENDDATE IS NULL OR @ENDDATE>= dbo.FINANCIALTRANSACTION.[DATE])))))
        set @retval = 1;

    return @retval;
end