USP_DATAFORMTEMPLATE_VIEW_REVENUETRANSACTIONPROFILETA_2

Parameters

Parameter Parameter Type Mode Description
@ID uniqueidentifier IN
@DATALOADED bit INOUT
@TYPE tinyint INOUT
@AMOUNT money INOUT
@BALANCE money INOUT
@TOTALPAID money INOUT
@PASTDUE money INOUT
@MATCHEDREVENUE nvarchar(255) INOUT
@MATCHEDREVENUEID uniqueidentifier INOUT
@PAYMENTID uniqueidentifier INOUT
@NEXTTRANSACTION datetime INOUT
@ISPENDING bit INOUT
@PENDINGBATCHNUMBER nvarchar(50) INOUT
@DATE datetime INOUT
@PAYMENTMETHOD nvarchar(13) INOUT
@PAYMENTMETHODCODE tinyint INOUT
@CHECKDATE UDT_FUZZYDATE INOUT
@CHECKNUMBER nvarchar(20) INOUT
@REFERENCENUMBER nvarchar(20) INOUT
@REFERENCEDATE UDT_FUZZYDATE INOUT
@CARDHOLDERNAME nvarchar(255) INOUT
@CREDITCARDNUMBER nvarchar(20) INOUT
@CREDITTYPE nvarchar(100) INOUT
@AUTHORIZATIONCODE nvarchar(20) INOUT
@EXPIRESON UDT_FUZZYDATE INOUT
@ISSUER nvarchar(100) INOUT
@NUMBEROFUNITS decimal(20, 3) INOUT
@SYMBOL nvarchar(4) INOUT
@MEDIANPRICE decimal(19, 4) INOUT
@SALEAMOUNT money INOUT
@GIFTINKINDSUBTYPE nvarchar(100) INOUT
@PROPERTYSUBTYPE nvarchar(100) INOUT
@ACCOUNT nvarchar(255) INOUT
@POSTDATE datetime INOUT
@POSTSTATUS nvarchar(50) INOUT
@BATCHNUMBER nvarchar(50) INOUT
@ISSOLDSTOCK bit INOUT
@ISSOLDPROPERTY bit INOUT
@ISPOSTEDSOLDSTOCK bit INOUT
@ISPOSTEDSOLDPROPERTY bit INOUT
@APPEAL nvarchar(100) INOUT
@SENDPLEDGEREMINDER bit INOUT
@FREQUENCY nvarchar(100) INOUT
@ENDDATE datetime INOUT
@STARTDATE datetime INOUT
@STATUS nvarchar(255) INOUT
@SOURCECODE nvarchar(50) INOUT
@RECEIPTAMOUNT money INOUT
@GIVENANONYMOUSLY bit INOUT
@MAILING nvarchar(100) INOUT
@CHANNEL nvarchar(100) INOUT
@PLEDGESUBTYPE nvarchar(100) INOUT
@RECEIPTNUMBER int INOUT
@RECEIPTSTATUS nvarchar(50) INOUT
@RECEIPTDATE datetime INOUT
@ACKNOWLEDGEMENTSTATUS nvarchar(50) INOUT
@MGSTATUSCODE tinyint INOUT
@RECEIPTTYPE nvarchar(30) INOUT
@OTHERPAYMENTMETHODCODE nvarchar(100) INOUT
@FISCALYEARMONTH UDT_FUZZYDATE INOUT
@PLEDGESTATUS nvarchar(100) INOUT
@GIFTTYPE nvarchar(100) INOUT
@CATEGORYDESCRIPTION nvarchar(100) INOUT
@GIFTFEEAMOUNT money INOUT
@GIFTFEE_ENABLED bit INOUT
@ELIGIBLEFORMATCHINGGIFTCLAIM bit INOUT
@ORDERNUMBER nvarchar(30) INOUT
@TAXCLAIMNUMBER nvarchar(10) INOUT
@TAXCLAIMAMOUNT money INOUT
@GROSSAMOUNT money INOUT
@SHOWPOTENTIAL bit INOUT
@RECURRINGGIFTTOTALWITHGIFTAID money INOUT
@PLEDGETOTALWITHGIFTAID money INOUT
@PLEDGERECURRINGGIFTGROSSAMOUNT money INOUT
@CONSTITUENTISGROUP bit INOUT
@VATAMOUNT money INOUT
@ISMISCELLANEOUSPAYMENT bit INOUT
@DEPOSITID uniqueidentifier INOUT
@DEPOSITNAME nvarchar(100) INOUT
@REFERENCE nvarchar(255) INOUT
@ISREIMBURSABLE bit INOUT
@LOOKUPID nvarchar(100) INOUT
@RGHASINSTALLMENTS bit INOUT
@GIFTINKINDITEMNAME nvarchar(100) INOUT
@GIFTINKINDDISPOSITION nvarchar(50) INOUT
@GIFTINKINDNUMBEROFUNITS int INOUT
@GIFTINKINDFAIRMARKETVALUE money INOUT
@GIFTINKINDAPPRAISALREQUIRED bit INOUT
@DIRECTDEBITRESULTCODE nvarchar(10) INOUT
@DIRECTDEBITISREJECTED bit INOUT
@OPPORTUNITYNAME nvarchar(250) INOUT
@OPPORTUNITYID uniqueidentifier INOUT
@FUNDINGREQUESTNAME nvarchar(150) INOUT
@FUNDINGREQUESTID uniqueidentifier INOUT
@SHOWRGPASTDUE bit INOUT
@HASGIFTAIDSPLITONPENDINGR68PROCESS bit INOUT
@GLBATCHLOOKUPID nvarchar(100) INOUT
@GLBATCHLINKID uniqueidentifier INOUT
@REVENUEID uniqueidentifier INOUT
@AUCTIONITEMNAME nvarchar(100) INOUT
@AUCTIONITEMID uniqueidentifier INOUT
@AUCTIONITEMCATEGORY nvarchar(100) INOUT
@AUCTIONITEMSUBCATEGORY nvarchar(100) INOUT
@AUCTIONEXPIRATIONDATE datetime INOUT
@BASECURRENCYID uniqueidentifier INOUT
@TRANSACTIONCURRENCYID uniqueidentifier INOUT
@BASEAMOUNT money INOUT
@CONSTITUENTNAME nvarchar(255) INOUT
@TRANSACTIONTYPE nvarchar(100) INOUT
@GIFTFEESANDGIFTFEEDISTRIBUTIONAMOUNTSNOTEQUAL bit INOUT
@PLANNEDGIFTVEHICLECODE int INOUT
@PLANNEDGIFTISREVOCABLE bit INOUT
@ISPLANNEDGIFTADDITION bit INOUT
@UNIQUERECEIPTNUMBER nvarchar(20) INOUT
@HASINVALIDPAPERLESSMANDATES bit INOUT
@PLANNEDGIFT_TRUSTHELDOUTSIDE bit INOUT
@ISSOLDGIFTINKIND bit INOUT
@ISPOSTEDSOLDGIFTINKIND bit INOUT
@ACKNOWLEDGEMENTDATE datetime INOUT
@POSTSTATUSCODE tinyint INOUT

Definition

Copy 

                create procedure dbo.USP_DATAFORMTEMPLATE_VIEW_REVENUETRANSACTIONPROFILETA_2
                (
                    @ID uniqueidentifier,    
                    @DATALOADED bit = 0 output,
                    @TYPE tinyint = null output,
                    @AMOUNT money = null output,
                    @BALANCE money = null output,
                    @TOTALPAID money = null output,
                    @PASTDUE money = null output,
                    @MATCHEDREVENUE nvarchar(255) = null output,
                    @MATCHEDREVENUEID uniqueidentifier = null output,
                    @PAYMENTID uniqueidentifier = null output,
                    @NEXTTRANSACTION datetime = null output,
                    @ISPENDING bit = null output,
                    @PENDINGBATCHNUMBER nvarchar(50) = null output,
                    @DATE datetime = null output,
                    @PAYMENTMETHOD nvarchar(13) = null output,
                    @PAYMENTMETHODCODE tinyint = null output,
                    @CHECKDATE dbo.UDT_FUZZYDATE = null output,
                    @CHECKNUMBER nvarchar(20) = null output,
                    @REFERENCENUMBER nvarchar(20) = null output,
                    @REFERENCEDATE dbo.UDT_FUZZYDATE = null output,
                    @CARDHOLDERNAME nvarchar(255) = null output,
                    @CREDITCARDNUMBER nvarchar(20) = null output,
                    @CREDITTYPE nvarchar(100) = null output,
                    @AUTHORIZATIONCODE nvarchar(20) = null output,
                    @EXPIRESON dbo.UDT_FUZZYDATE = null output,
                    @ISSUER  nvarchar(100) = null output,
                    @NUMBEROFUNITS decimal(20,3) = null output, 
                    @SYMBOL nvarchar(4) = null output, 
                    @MEDIANPRICE decimal(19,4) = null output,
                    @SALEAMOUNT money = null output,
                    @GIFTINKINDSUBTYPE nvarchar(100) = null output,
                    @PROPERTYSUBTYPE nvarchar(100) = null output,
                    @ACCOUNT nvarchar(255) = null output,
                    @POSTDATE datetime = null output,
                    @POSTSTATUS nvarchar(50) = null output,
                    @BATCHNUMBER nvarchar(50) = null output,
                    @ISSOLDSTOCK bit = null output,
                    @ISSOLDPROPERTY bit = null output,
                    @ISPOSTEDSOLDSTOCK bit = null output,
                    @ISPOSTEDSOLDPROPERTY bit = null output,
                    @APPEAL nvarchar(100) = null output,
                    @SENDPLEDGEREMINDER bit = null output,
                    @FREQUENCY nvarchar(100) = null output,
                    @ENDDATE datetime = null output,
                    @STARTDATE datetime = null output,
                    @STATUS nvarchar(255) = null output,
                    @SOURCECODE nvarchar(50) = null output,
                    @RECEIPTAMOUNT money = null output,
                    @GIVENANONYMOUSLY bit = null output,
                    @MAILING nvarchar(100) = null output,
                    @CHANNEL nvarchar(100) = null output,
                    @PLEDGESUBTYPE nvarchar(100) = null output,
                    @RECEIPTNUMBER int = null output,
                    @RECEIPTSTATUS nvarchar(50) = null output,
                    @RECEIPTDATE datetime = null output,
                    @ACKNOWLEDGEMENTSTATUS nvarchar(50) = null output,
                    @MGSTATUSCODE tinyint = null output,
                    @RECEIPTTYPE nvarchar(30) = null output,
                    @OTHERPAYMENTMETHODCODE nvarchar(100) = null output,
                    @FISCALYEARMONTH dbo.UDT_FUZZYDATE = null output,
                    @PLEDGESTATUS nvarchar(100) = null output,
                    @GIFTTYPE nvarchar(100) = null output,
                    @CATEGORYDESCRIPTION nvarchar(100) = null output,
                  @GIFTFEEAMOUNT money = null output,
                  @GIFTFEE_ENABLED bit = null output,
                  @ELIGIBLEFORMATCHINGGIFTCLAIM bit = null output,
                  @ORDERNUMBER nvarchar(30) = null output,
                  @TAXCLAIMNUMBER nvarchar(10) = null output,
                  @TAXCLAIMAMOUNT money = null output,
                  @GROSSAMOUNT money = null output,
                  @SHOWPOTENTIAL bit = null output,
                  @RECURRINGGIFTTOTALWITHGIFTAID money = null output,
                  @PLEDGETOTALWITHGIFTAID money = null output,
                  @PLEDGERECURRINGGIFTGROSSAMOUNT money = null output,
                  @CONSTITUENTISGROUP bit = null output,
                  @VATAMOUNT money = null output,
                  @ISMISCELLANEOUSPAYMENT bit = null output,
                  @DEPOSITID uniqueidentifier = null output,
                  @DEPOSITNAME nvarchar(100) = null output,
                  @REFERENCE nvarchar(255) = null output,
                  @ISREIMBURSABLE bit = null output,
                  @LOOKUPID nvarchar(100) = null output,
                  @RGHASINSTALLMENTS bit = null output,
                  @GIFTINKINDITEMNAME nvarchar(100) = null output,
                  @GIFTINKINDDISPOSITION nvarchar(50) = null output,
                  @GIFTINKINDNUMBEROFUNITS int = null output,
                  @GIFTINKINDFAIRMARKETVALUE money = null output,
                  @GIFTINKINDAPPRAISALREQUIRED bit = null output,
                  @DIRECTDEBITRESULTCODE nvarchar(10) = null output,
                  @DIRECTDEBITISREJECTED bit = null output,
                  @OPPORTUNITYNAME nvarchar(250) = null output,
                  @OPPORTUNITYID uniqueidentifier = null output,
                  @FUNDINGREQUESTNAME nvarchar(150) = null output,
                  @FUNDINGREQUESTID uniqueidentifier = null output,
                  @SHOWRGPASTDUE bit = null output,
                  @HASGIFTAIDSPLITONPENDINGR68PROCESS bit = null output,
                  @GLBATCHLOOKUPID nvarchar(100) = null output,
                  @GLBATCHLINKID uniqueidentifier = null output,
                  @REVENUEID uniqueidentifier = null output,
                  @AUCTIONITEMNAME nvarchar(100) = null output,
                  @AUCTIONITEMID uniqueidentifier = null output,
                  @AUCTIONITEMCATEGORY nvarchar(100) = null output,
                  @AUCTIONITEMSUBCATEGORY nvarchar(100) = null output,
                  @AUCTIONEXPIRATIONDATE datetime = null output,
                  @BASECURRENCYID uniqueidentifier = null output,
                  @TRANSACTIONCURRENCYID uniqueidentifier = null output,
                  @BASEAMOUNT money = null output,
                  @CONSTITUENTNAME nvarchar(255) = null output,
                  @TRANSACTIONTYPE nvarchar(100) = null output,
                  @GIFTFEESANDGIFTFEEDISTRIBUTIONAMOUNTSNOTEQUAL bit = null output,
                  @PLANNEDGIFTVEHICLECODE int = null output,
                  @PLANNEDGIFTISREVOCABLE bit = null output,
                  @ISPLANNEDGIFTADDITION bit = null output,
                  @UNIQUERECEIPTNUMBER nvarchar(20) = null output,
                  @HASINVALIDPAPERLESSMANDATES bit = null output,
                  @PLANNEDGIFT_TRUSTHELDOUTSIDE bit = null output,
                  @ISSOLDGIFTINKIND bit = null output,
                  @ISPOSTEDSOLDGIFTINKIND bit = null output,
                  @ACKNOWLEDGEMENTDATE datetime = null output,
                  @POSTSTATUSCODE tinyint = null output                    
                )
                as

                set nocount on;

            begin try
                declare @r int

                exec @r = dbo.USP_DATAFORMTEMPLATE_VIEW_REVENUETRANSACTIONPROFILE
                    @ID = @ID,    
                    @DATALOADED = @DATALOADED output ,
                    @TYPE = @TYPE output,
                    @AMOUNT = @AMOUNT output,
                    @BALANCE = @BALANCE output,
                    @TOTALPAID = @TOTALPAID output,
                    @PASTDUE = @PASTDUE output ,
                    @MATCHEDREVENUE = @MATCHEDREVENUE output,
                    @MATCHEDREVENUEID = @MATCHEDREVENUEID  output,
                    @PAYMENTID = @PAYMENTID output ,
                    @NEXTTRANSACTION = @NEXTTRANSACTION output ,
                    @ISPENDING = @ISPENDING output ,
                    @PENDINGBATCHNUMBER = @PENDINGBATCHNUMBER output ,
                    @DATE = @DATE output ,
                    @PAYMENTMETHOD = @PAYMENTMETHOD output,
                    @PAYMENTMETHODCODE = @PAYMENTMETHODCODE output,
                    @CHECKDATE = @CHECKDATE output,
                    @CHECKNUMBER = @CHECKNUMBER output,
                    @REFERENCENUMBER = @REFERENCENUMBER output ,
                    @REFERENCEDATE = @REFERENCEDATE output,
                    @CARDHOLDERNAME = @CARDHOLDERNAME output,
                    @CREDITCARDNUMBER = @CREDITCARDNUMBER output,
                    @CREDITTYPE = @CREDITTYPE output,
                    @AUTHORIZATIONCODE = @AUTHORIZATIONCODE  output,
                    @EXPIRESON = @EXPIRESON  output,
                    @ISSUER = @ISSUER output,
                    @NUMBEROFUNITS = @NUMBEROFUNITS output, 
                    @SYMBOL = @SYMBOL output,
                    @MEDIANPRICE= @MEDIANPRICE output,
                    @SALEAMOUNT  = @SALEAMOUNT output ,
                    @GIFTINKINDSUBTYPE  = @GIFTINKINDSUBTYPE output,
                    @PROPERTYSUBTYPE  = @PROPERTYSUBTYPE output,
                    @ACCOUNT  = @ACCOUNT output,
                    @POSTDATE  = @POSTDATE output,
                    @POSTSTATUS  = @POSTSTATUS output,
                    @BATCHNUMBER  = @BATCHNUMBER output,
                    @ISSOLDSTOCK  = @ISSOLDSTOCK output ,
                    @ISSOLDPROPERTY  = @ISSOLDPROPERTY output,
                    @ISPOSTEDSOLDSTOCK  = @ISPOSTEDSOLDSTOCK output,
                    @ISPOSTEDSOLDPROPERTY  = @ISPOSTEDSOLDPROPERTY output,
                    @APPEAL  = @APPEAL output,
                    @SENDPLEDGEREMINDER  = @SENDPLEDGEREMINDER output,
                    @FREQUENCY  = @FREQUENCY output,
                    @ENDDATE  = @ENDDATE output,
                    @STARTDATE  = @STARTDATE output,
                    @STATUS  = @STATUS output,
                    @SOURCECODE  = @SOURCECODE output,
                    @RECEIPTAMOUNT  = @RECEIPTAMOUNT output,
                    @GIVENANONYMOUSLY  = @GIVENANONYMOUSLY output,
                    @MAILING  = @MAILING output,
                    @CHANNEL  = @CHANNEL output,
                    @PLEDGESUBTYPE  = @PLEDGESUBTYPE output,
                    @RECEIPTNUMBER = @RECEIPTNUMBER output,
                    @RECEIPTSTATUS  = @RECEIPTSTATUS output,
                    @RECEIPTDATE  = @RECEIPTDATE output,
                    @ACKNOWLEDGEMENTSTATUS  = @ACKNOWLEDGEMENTSTATUS output,
                    @MGSTATUSCODE = @MGSTATUSCODE output,
                    @RECEIPTTYPE = @RECEIPTTYPE output,
                    @OTHERPAYMENTMETHODCODE  = @OTHERPAYMENTMETHODCODE ,
                    @CATEGORYDESCRIPTION  = @CATEGORYDESCRIPTION output,
                  @GIFTFEEAMOUNT  = @GIFTFEEAMOUNT output,
                  @GIFTFEE_ENABLED  = @GIFTFEE_ENABLED output,
                  @ELIGIBLEFORMATCHINGGIFTCLAIM  = @ELIGIBLEFORMATCHINGGIFTCLAIM output,
                  @ORDERNUMBER = @ORDERNUMBER output,
                  @TAXCLAIMNUMBER = @TAXCLAIMNUMBER output,
                  @TAXCLAIMAMOUNT  = @TAXCLAIMAMOUNT output,
                  @GROSSAMOUNT  = @GROSSAMOUNT output,
                  @SHOWPOTENTIAL  = @SHOWPOTENTIAL output,
                  @RECURRINGGIFTTOTALWITHGIFTAID  = @RECURRINGGIFTTOTALWITHGIFTAID output,
                  @PLEDGETOTALWITHGIFTAID  = @PLEDGETOTALWITHGIFTAID output,
                  @PLEDGERECURRINGGIFTGROSSAMOUNT  = @PLEDGERECURRINGGIFTGROSSAMOUNT output,
                  @CONSTITUENTISGROUP  = @CONSTITUENTISGROUP output,
                  @VATAMOUNT  = @VATAMOUNT output,
                  @ISMISCELLANEOUSPAYMENT  = @ISMISCELLANEOUSPAYMENT output,
                  @DEPOSITID  = @DEPOSITID output,
                  @DEPOSITNAME  = @DEPOSITNAME output,
                  @REFERENCE  = @REFERENCE output,
                  @ISREIMBURSABLE  = @ISREIMBURSABLE output,
                  @LOOKUPID  = @LOOKUPID output,
                  @RGHASINSTALLMENTS  = @RGHASINSTALLMENTS output,
                  @GIFTINKINDITEMNAME  = @GIFTINKINDITEMNAME output,
                  @GIFTINKINDDISPOSITION  = @GIFTINKINDDISPOSITION output,
                  @GIFTINKINDNUMBEROFUNITS = @GIFTINKINDNUMBEROFUNITS output,
                  @GIFTINKINDFAIRMARKETVALUE  = @GIFTINKINDFAIRMARKETVALUE output,
                  @GIFTINKINDAPPRAISALREQUIRED  = @GIFTINKINDAPPRAISALREQUIRED output,
                  @DIRECTDEBITRESULTCODE = @DIRECTDEBITRESULTCODE output,
                  @DIRECTDEBITISREJECTED  = @DIRECTDEBITISREJECTED output,
                  @OPPORTUNITYNAME = @OPPORTUNITYNAME output,
                  @OPPORTUNITYID  = @OPPORTUNITYID output,
                  @FUNDINGREQUESTNAME= @FUNDINGREQUESTNAME output,
                  @FUNDINGREQUESTID  = @FUNDINGREQUESTID output,
                  @SHOWRGPASTDUE  = @SHOWRGPASTDUE output,
                  @HASGIFTAIDSPLITONPENDINGR68PROCESS  = @HASGIFTAIDSPLITONPENDINGR68PROCESS output,
                  @GLBATCHLOOKUPID  = @GLBATCHLOOKUPID output,
                  @GLBATCHLINKID  = @GLBATCHLINKID output,
                  @REVENUEID  = @REVENUEID output,
                  @AUCTIONITEMNAME  = @AUCTIONITEMNAME output,
                  @AUCTIONITEMID  = @AUCTIONITEMID output,
                  @AUCTIONITEMCATEGORY  = @AUCTIONITEMCATEGORY output ,
                  @AUCTIONITEMSUBCATEGORY  = @AUCTIONITEMSUBCATEGORY output ,
                  @AUCTIONEXPIRATIONDATE  = @AUCTIONEXPIRATIONDATE output,
                  @BASECURRENCYID  = @BASECURRENCYID output,
                  @TRANSACTIONCURRENCYID  = @TRANSACTIONCURRENCYID output,
                  @BASEAMOUNT  = @BASEAMOUNT output,
                  @CONSTITUENTNAME  = @CONSTITUENTNAME output,
                  @TRANSACTIONTYPE  = @TRANSACTIONTYPE output,
                  @GIFTFEESANDGIFTFEEDISTRIBUTIONAMOUNTSNOTEQUAL  = @GIFTFEESANDGIFTFEEDISTRIBUTIONAMOUNTSNOTEQUAL output,
                  @PLANNEDGIFTVEHICLECODE = @PLANNEDGIFTVEHICLECODE output,
                  @PLANNEDGIFTISREVOCABLE  = @PLANNEDGIFTISREVOCABLE output,
                  @ISPLANNEDGIFTADDITION  = @ISPLANNEDGIFTADDITION output,
                  @UNIQUERECEIPTNUMBER  = @UNIQUERECEIPTNUMBER output,
                  @HASINVALIDPAPERLESSMANDATES  = @HASINVALIDPAPERLESSMANDATES output,
                  @PLANNEDGIFT_TRUSTHELDOUTSIDE  = @PLANNEDGIFT_TRUSTHELDOUTSIDE output,
                  @ISSOLDGIFTINKIND  = @ISSOLDGIFTINKIND output,
                  @ISPOSTEDSOLDGIFTINKIND  = @ISPOSTEDSOLDGIFTINKIND output,
                  @ACKNOWLEDGEMENTDATE  = @ACKNOWLEDGEMENTDATE output,
                  @POSTSTATUSCODE  = @POSTSTATUSCODE  output

                 /*
                 select top 1
                    @DATALOADED = 1,
                    @REVENUEID = FINANCIALTRANSACTION.ID
                 from 
                    dbo.FINANCIALTRANSACTION
                 where 
                    FINANCIALTRANSACTION.ID = @ID
                    and FINANCIALTRANSACTION.TYPECODE in (0,1,2,3,4,5,6,7,8,9,15) 
                    and FINANCIALTRANSACTION.DELETEDON is null
                    */
            end try
            begin catch
                --exec dbo.USP_RAISE_ERROR;

                return 1;
            end catch

                --TAFIELDS
                select
                    @FISCALYEARMONTH = RT.FISCALYEARMONTH,
                    @PLEDGESTATUS = RT.PLEDGESTATUS,
                    @TRANSACTIONTYPE = RTCODE.DESCRIPTION
                from dbo.REVENUETAINTEGRATION RT
                left outer join dbo.REVENUETRANSACTIONTYPECODE RTCODE
                    on RT.TRANSACTIONTYPECODEID = RTCODE.ID
                where RT.ID = @REVENUEID


                return 0;