USP_DATALIST_UNSETTLEDCREDITCARDTRANSACTION

            CREATE procedure dbo.USP_DATALIST_UNSETTLEDCREDITCARDTRANSACTION
            (
                @FROMDATE date,
                @TODATE date,
                @VENDORID nvarchar(50) = null,
                @ALLOWEDVENDORS xml = null
            )
            as
                set nocount on;

                if @VENDORID = '0'
                    set @VENDORID = '';
                else if @VENDORID = ''
                    set @VENDORID = null;

                declare @ALLOWEDVENDOR table (VENDORID nvarchar(50));
                if not @ALLOWEDVENDORS is null
                    insert into @ALLOWEDVENDOR(VENDORID)
                    select T.c.value('(VENDORID)[1]', 'nvarchar(50)')
                    from @ALLOWEDVENDORS.nodes('/ALLOWEDVENDORS/ITEM') T(c)

                declare @ORGCURRENCYID uniqueidentifier = (select ID from dbo.CURRENCY where ISORGANIZATIONCURRENCY = 1);

                select 
                    UNSETTLEDCREDITCARDTRANSACTION.ID,
                    TRANSACTIONDATE,
                    CARDTYPE,
                    CARDHOLDERNAME,
                    AUTHORIZATIONCODE,
                    CREDITCARDPARTIALNUMBER,
                    AMOUNT,
                    PROCESSORTRANSACTIONSETTLEMENTIMPORTID,
                    CHANGEAGENT.USERNAME,
                    UNSETTLEDCREDITCARDTRANSACTION.DATEADDED IMPORTDATE,
                    isnull(UNSETTLEDCREDITCARDTRANSACTION.CURRENCYID, @ORGCURRENCYID) CURRENCYID,
                    VENDORID
                from dbo.UNSETTLEDCREDITCARDTRANSACTION
                inner join dbo.CHANGEAGENT
                    on CHANGEAGENT.ID = UNSETTLEDCREDITCARDTRANSACTION.ADDEDBYID
                where UNSETTLEDCREDITCARDTRANSACTION.TRANSACTIONDATE between @FROMDATE and @TODATE
                    and (@VENDORID is null or UNSETTLEDCREDITCARDTRANSACTION.VENDORID = @VENDORID)
                    and (@ALLOWEDVENDORS is null or UNSETTLEDCREDITCARDTRANSACTION.VENDORID in (select VENDORID from @ALLOWEDVENDOR))
                order by TRANSACTIONDATE asc