UFN_BILLINGINDIVIDUALOPENCHARGES_TOITEMLISTXML

            CREATE function dbo.UFN_BILLINGINDIVIDUALOPENCHARGES_TOITEMLISTXML
            (
                @CONSTITUENTID uniqueidentifier,
                @ASOFDATE datetime = null
            )
            returns xml
            with execute as caller
            as begin

                -- If as of date is null use today's date

                if (@ASOFDATE is null)
                    set @ASOFDATE = getdate();

                -- Make sure we are using the earliest time for this date

                set @ASOFDATE = dbo.UFN_DATE_GETEARLIESTTIME(@ASOFDATE);

                declare @OPENCHARGES xml;
                set @OPENCHARGES = (select ID as CHARGEID,
                                            DUEDATE,
                                            DESCRIPTION,
                                            AMOUNTREMAINING,
                                            DATE
                                    from dbo.UFN_BILLINGINDIVIDUALTRANSACTIONDETAILS(@CONSTITUENTID,
                                                                                    104,  -- Charges

                                                                                    3, -- Open

                                                                                    null,
                                                                                    @ASOFDATE,
                                                                                    null,
                                                                                    null)
                                    for xml raw('ITEM'),type,elements,root('OPENCHARGES'),BINARY BASE64);

                return @OPENCHARGES;
            end