USP_SIMPLEDATALIST_BILLINGITEM

Simple list of billing items.

Parameters

Parameter	Parameter Type	Mode
@TRANSACTIONDATE	date	IN
@EXCLUDEVARYBYGRADELEVEL	tinyint	IN
@EXCLUDEVARYBYSCHOOL	tinyint	IN
@PRICETYPECODE	tinyint	IN

Definition

Copy



            CREATE procedure dbo.USP_SIMPLEDATALIST_BILLINGITEM    
            (@TRANSACTIONDATE date = null,
            @EXCLUDEVARYBYGRADELEVEL tinyint = 0,
            @EXCLUDEVARYBYSCHOOL tinyint = 0,
            @PRICETYPECODE tinyint = 0)            
            as                            
                    select 
                        dbo.BILLINGITEM.[ID] as VALUE, 
                        dbo.PRODUCT.[NAME] as LABEL
                    from dbo.BILLINGITEM
                    inner join dbo.PRODUCT on BILLINGITEM.[ID] = PRODUCT.[ID]
                    where BILLINGITEM.[ISINACTIVE] = 0 and dbo.UFN_BILLINGITEM_VALIDFORSPECIFIEDDATE(BILLINGITEM.[ID], @TRANSACTIONDATE)=1 and (not @TRANSACTIONDATE is null)
                    and ((@EXCLUDEVARYBYGRADELEVEL = 1 and PRICETYPECODE <> 2) or (@EXCLUDEVARYBYGRADELEVEL <> 1))
                    and ((@EXCLUDEVARYBYSCHOOL = 1 and PRICETYPECODE <> 3) or (@EXCLUDEVARYBYSCHOOL <> 1))
                    and ((@PRICETYPECODE = PRICETYPECODE) or (@PRICETYPECODE = 0))
                    order by dbo.PRODUCT.[NAME]