UFN_REGISTRANT_GETCREDITITEMS

            CREATE function dbo.UFN_REGISTRANT_GETCREDITITEMS (
                @ID uniqueidentifier = null
            )
            returns table
            as return
                select
                    LI.ID
                    , FT.ID [CREDITID]
                    , LI.QUANTITY
                    , ((LI.QUANTITY * LI.UNITVALUE) - EXT.DISCOUNTS) [TOTAL]
                    , EXT.SALESORDERITEMID
                from dbo.FINANCIALTRANSACTIONLINEITEM LI
                inner join dbo.CREDITITEM_EXT EXT on EXT.ID = LI.ID
                inner join dbo.FINANCIALTRANSACTION FT on FT.ID = LI.FINANCIALTRANSACTIONID
                inner join dbo.[CREDITITEMEVENTREGISTRATION]
                    on [LI].[ID] = [CREDITITEMEVENTREGISTRATION].[ID]
                where FT.TYPECODE = 23 and [CREDITITEMEVENTREGISTRATION].[REGISTRANTID] = @ID