UFN_BILLINGITEM_GETLATESTCHARGEDATEFORBILLINGITEM

Get latest charge date which is using the specified billing item

Return

Return Type
date

Parameters

Parameter	Parameter Type	Mode	Description
@BILLINGITEMID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_BILLINGITEM_GETLATESTCHARGEDATEFORBILLINGITEM
            (
                @BILLINGITEMID uniqueidentifier=null
            )
            returns date
            as begin
                -- do work here and return a value

                declare @retval date;

                select @retval = max(dbo.FINANCIALTRANSACTION.[DATE])
                from dbo.FINANCIALTRANSACTION 
                    inner join dbo.FINANCIALTRANSACTIONLINEITEM
                        on FINANCIALTRANSACTION.ID = FINANCIALTRANSACTIONLINEITEM.FINANCIALTRANSACTIONID
                    inner join dbo.CHARGELINEITEM
                        on FINANCIALTRANSACTIONLINEITEM.ID = CHARGELINEITEM.ID
                where dbo.CHARGELINEITEM.BILLINGITEMID = @BILLINGITEMID

                return @retval;
            end