MS SQL w9BlCUZs04FsaKFcS9zpXoQqaSlma3vdelih8WEN6Gf8DJ/rX09p8Mdr4VDowOFe8gxpL15cUfDDGBWZTkzhL8PEd8NYXUN1/WG9hA== MS SQL DataSource1 gcifname,System.String ACTUAL_ACCOUNT_NUMBER,System.String GCIFNO,System.String CUSTOMER_VA_IDENTIFIER,System.String VIRTUAL_ACCOUNT_NUMBER,System.String VIRTUAL_ACCOUNT_NAME,System.String HIERARCHY_LEVEL,System.Decimal HIERARCHY_NAME,System.String CREATED_BY,System.String CREATED_ON,System.String Authorized_By_x002F_Rejected_By,System.String Authorized_On_x002F_Rejected_On,System.String REJECTREASON,System.String STATUS,System.String hierarchytype,System.String VACUSTTYPE,System.String payerid,System.String 30 89479c37457744418e5dfec081c93442 DataSource1 MS SQL SELECT cust.custname as gcifname, acc.accno AS ACTUAL_ACCOUNT_NUMBER, vaa.gcifno AS GCIFNO, vaa.vacustidnt + ' - ' + vaa.entityname AS CUSTOMER_VA_IDENTIFIER, vacc.vaiban AS VIRTUAL_ACCOUNT_NUMBER, vacc.vaaccname AS VIRTUAL_ACCOUNT_NAME, vacc.hierarchylvl AS HIERARCHY_LEVEL, vacc.hierarchyname AS HIERARCHY_NAME, isnull(req.LOGINID,req1.loginid) AS CREATED_BY, convert(varchar,vacc.crtdate,103) AS CREATED_ON, isnull(app.LOGINID,app1.loginid) as "Authorized_By/Rejected_By", convert(varchar,vacc.appdate,103) as "Authorized_On/Rejected_On", '' AS REJECTREASON, vacc.VACHNACTSTATUSDESC AS STATUS, case when vacc.hierarchytype = 'P' then 'Parent' else 'Child' end as hierarchytype, ( CASE WHEN vacc.vacusttype = 'P' THEN 'Payment' WHEN vacc.vacusttype = 'B' THEN 'Payment and Collection' WHEN vacc.vacusttype = 'C' THEN 'Collection' END ) AS VACUSTTYPE, vacc.payerid FROM vtsmvaacc vaa INNER JOIN vtcmcustacc acc ON vaa.accid = acc.accid INNER JOIN vtcmcustacccif cif ON cif.accid = acc.accid INNER JOIN vtcmcust cust ON cust.custid = cif.custid inner JOIN vtsmvaccounts vacc ON vacc.vaaccid = vaa.vaaccid left outer JOIN vtamuser req ON req.userid = vacc.crtby left outer JOIN vtamuser app ON app.userid = vacc.appby left outer join vtampcuser req1 on req1.userid = vacc.crtby left outer join vtampcuser app1 on app1.userid = vacc.appby left outer join VTSMVACHNMAP vm on vacc.VAIBANID = vm.VAIBANID WHERE cust.custid = 22 and vacc.VACHNACTSTATUSDESC = (case when isnull('','')='' then isnull(null,vacc.VACHNACTSTATUSDESC) else '' end) and convert(date,vacc.crtdate,103) BETWEEN isnull( convert(date,'01-01-2020',103), vacc.crtdate) AND isnull( convert(date,'10-04-2020',103), vacc.crtdate) and ACC.ACCID in (SELECT VALUE FROM FN_SPLIT(case when isnull('','') = '' then ( select stuff((SELECT ','+ cast( acc.ACCID as varchar) FROM vtcmcustacc acc group by acc.accid for xml path('')),1,1,'') ) else '' end,',')) and VAA.VACUSTIDNT in (SELECT VALUE FROM FN_SPLIT(case when isnull('','') = '' then ( select stuff((SELECT ','+ cast( vaa.vacustidnt as varchar) FROM vtsmvaacc vaa group by vaa.vacustidnt for xml path('')),1,1,'') ) else '' end,',')) AND vacc.CRTBY=(case when isnull('','')='' then isnull(null,vacc.CRTBY) else '' end) AND vacc.APPBY=(case when isnull('','')='' then isnull(null,vacc.APPBY) else '' end) AND vacc.vaiban in (SELECT VALUE FROM FN_SPLIT(case when isnull('','') = '' then ( select stuff((SELECT ','+ cast( vacc.vaiban as varchar) FROM vtsmvaccounts vacc group by vacc.vaiban for xml path('')),1,1,'') ) else '' end,',')) group by vaa.entityname, cust.custname , acc.accno , vaa.gcifno, vaa.vacustidnt, vacc.vaiban , vacc.vaaccname, vacc.hierarchylvl, vacc.hierarchyname, req.LOGINID,req1.loginid, vacc.crtdate, app.LOGINID,app1.loginid, vacc.appdate, vacc.VACHNACTSTATUSDESC , vacc.hierarchytype, vacc.vacusttype, vacc.payerid UNION SELECT cust.custname as gcifname, ACC.ACCNO as ACTUAL_ACCOUNT_NUMBER, VAA.GCIFNO, VAA.VACUSTIDNT + ' - ' + vaa.entityname as CUSTOMER_VA_IDENTIFIER, pay.VAIBAN as VIRTUAL_ACCOUNT_NUMBER, pay.VANAME as VIRTUAL_ACCOUNT_NAME, pay.HIERARCHYLVL as HIERARCHY_LEVEL, pay.HIERARCHYNAME as HIERARCHY_NAME, ISNULL(req.loginid,REQ1.LOGINID) AS CREATED_BY, convert(varchar,pay.REQDATE ,103) as CREATED_ON, CASE WHEN TRN.WFSTATUSID=210 THEN NULL ELSE ISNULL(REJ.LOGINID,REJ1.LOGINID) END as "Authorized_By/Rejected_By", CASE WHEN TRN.WFSTATUSID=210 THEN NULL ELSE convert(varchar,TRN.CRTDATE ,103) END as "Authorized_On/Rejected_On", ENG.REJECTREASON AS REJECTREASON , ST.WFSTATUSDESC AS STATUS, case when pay.hierarchytype = 'P' then 'Parent' else 'Child' end as hierarchytype, ( CASE WHEN pay.vacusttype = 'P' THEN 'Payment' WHEN pay.vacusttype = 'B' THEN 'Payment and Collection' WHEN pay.vacusttype = 'C' THEN 'Collection' END ) AS VACUSTTYPE, pay.payerid FROM WRK_VTSMPAYER pay INNER JOIN VTXMENGNE ENG ON ENG.WFID=pay.WFID INNER JOIN VTXMSTATUS ST ON ST.WFSTATUSID=ENG.CURRWFSTATUSID inner JOIN VTXTENGNETRN TRN ON TRN.WFSTATUSID=ENG.CURRWFSTATUSID AND TRN.WFID=ENG.WFID inner join vtsmvaacc vaa on vaa.VAACCID = pay.VAACCID INNER JOIN VTCMCUSTACC ACC ON VAA.ACCID=ACC.ACCID INNER JOIN VTCMCUSTACCCIF CIF ON CIF.ACCID=ACC.ACCID INNER JOIN VTCMCUST CUST ON CUST.CUSTID=CIF.CUSTID left JOIN VTAMUSER REQ ON REQ.USERID=PAY.REQBY left JOIN VTAMUSER REJ ON TRN.CRTBY=REJ.USERID LEFT JOIN VTAMPCUSER REQ1 ON REQ1.USERID = PAY.REQBY LEFT JOIN VTAMPCUSER REJ1 ON TRN.CRTBY = REJ1.USERID WHERE CUST.CUSTID = 22 AND ENG.CURRWFSTATUSID IN (210,260) AND cast(ENG.CURRWFSTATUSID as varchar)=(case when isnull('','')='' then isnull(null,CAST(ENG.CURRWFSTATUSID AS VARCHAR)) else '' end) and convert(date,pay.REQDATE,103) BETWEEN isnull( convert(date,'01-01-2020',103), pay.REQDATE) AND isnull( convert(date,'10-04-2020',103), pay.REQDATE) and ACC.ACCID in (SELECT VALUE FROM FN_SPLIT(case when isnull('','') = '' then ( select stuff((SELECT ','+ cast( acc.ACCID as varchar) FROM VTCMCUSTACC ACC group by acc.accid for xml path('')),1,1,'') ) else '' end,',')) and VAA.VACUSTIDNT in (SELECT VALUE FROM FN_SPLIT(case when isnull('','') = '' then ( select stuff((SELECT ','+ cast( vaa.vacustidnt as varchar) FROM WRK_VTSMVAACC VAA group by vaa.vacustidnt for xml path('')),1,1,'') ) else '' end,',')) AND pay.reqby=(case when isnull('','')='' then isnull(null,pay.reqby) else '' end) and TRN.CRTBY=(case when isnull('','')='' then isnull(null,TRN.CRTBY) else '' end) AND pay.vaiban in (SELECT VALUE FROM FN_SPLIT(case when isnull('','') = '' then ( select stuff((SELECT ','+ cast( pay.vaiban as varchar) FROM wrk_vtsmpayer pay group by pay.vaiban for xml path('')),1,1,'') ) else '' end,',')) group by VAA.entityname, cust.custname, ACC.ACCNO , VAA.GCIFNO, VAA.VACUSTIDNT, pay.VAIBAN , pay.VANAME , pay.HIERARCHYLVL, pay.HIERARCHYNAME, req.loginid,REQ1.LOGINID, pay.REQDATE , REJ.LOGINID,REJ1.LOGINID, TRN.CRTDATE, ENG.REJECTREASON , ST.WFSTATUSDESC ,TRN.WFSTATUSID, pay.hierarchytype, pay.vacusttype, pay.payerid ORDER BY CREATED_ON DESC EngineV2 da2df571b0814475a421d20568d90c8d None;Black;2;Solid;False;4;Black Transparent Transparent 0,0.2,7.72,0.5 Transparent 0,0,7.72,0.5 Arial,20,Bold Center 0,0,0,0 ReportTitleText DataSource1 Black Center ReportTitle Transparent 0,1.1,7.72,0.9 3 White 0,0,2.6,0.3 Arial,10,Bold 0 1,1,1,1 Data_Cell1 AllowMove, AllowSelect, AllowChange ACTUAL_ACCOUNT_NUMBER Black ,,,,WordWrap=True,A=0 Center White 2.6,0,2.6,0.3 Arial,10,Bold 1 1,1,1,1 Data_Cell2 AllowMove, AllowSelect, AllowChange GCIFNO Black ,,,,WordWrap=True,A=0 Center White 5.2,0,2.52,0.3 Arial,10,Bold 2 1,1,1,1 Data_Cell3 AllowMove, AllowSelect, AllowChange CUSTOMER_VA_IDENTIFIER Black ,,,,WordWrap=True,A=0 Center White True 0,0.3,2.6,0.3 Arial,9 True 3 0,0,0,0 Data_Cell4 AllowMove, AllowSelect, AllowChange {DataSource1.ACTUAL_ACCOUNT_NUMBER} Black ,,,,WordWrap=True,A=0 Center White True 2.6,0.3,2.6,0.3 Arial,9 True 4 0,0,0,0 Data_Cell5 AllowMove, AllowSelect, AllowChange {DataSource1.GCIFNO} Black ,,,,WordWrap=True,A=0 Center White True 5.2,0.3,2.52,0.3 Arial,9 True 5 0,0,0,0 Data_Cell6 AllowMove, AllowSelect, AllowChange {DataSource1.CUSTOMER_VA_IDENTIFIER} Black ,,,,WordWrap=True,A=0 Center White 0,0.6,2.6,0.3 Arial,9 6 0,0,0,0 Data_Cell7 AllowMove, AllowSelect, AllowChange Black White 2.6,0.6,2.6,0.3 Arial,9 7 0,0,0,0 Data_Cell8 AllowMove, AllowSelect, AllowChange Black White 5.2,0.6,2.52,0.3 Arial,9 8 0,0,0,0 Data_Cell9 AllowMove, AllowSelect, AllowChange Black DataSource1 1 1 Data 9 3 0ea0b6e9e83547b78bf114f99d236f21 0.39,0.39,0.39,0.39 Page1 11 8.5 Letter System.Dll System.Drawing.Dll System.Windows.Forms.Dll System.Data.Dll System.Xml.Dll Stimulsoft.Controls.Dll Stimulsoft.Base.Dll Stimulsoft.Report.Dll Report 4/16/2020 5:48:58 PM 4/16/2020 5:48:30 PM W:\MindGate\Stimulsoft\TableReport.mrt 0deccf0d6eb046e9b05907fb4238821d Report Inches 2019.4.1.0 CSharp