UFN_BILLINGITEM_GETSCHOOLENTRIES

Returns school entries linked to a billing item.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@BILLINGITEMDATESID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_BILLINGITEM_GETSCHOOLENTRIES
            (
                @BILLINGITEMDATESID uniqueidentifier
            )
            returns table
            as
            return
            (
                select TOP 1000
                    BIPS.ID,
                    BIPS.SCHOOLID,
                    BIPS.PRICE
                from
                    dbo.BILLINGITEMPRICEBYSCHOOL BIPS
                where
                    BIPS.BILLINGITEMDATESID = @BILLINGITEMDATESID
            )