System.Activities System.Activities.Statements System.Activities.Expressions System.Activities.Validation System.Activities.XamlIntegration Microsoft.VisualBasic Microsoft.VisualBasic.Activities System System.Collections System.Collections.Generic System.Data System.Diagnostics System.Drawing System.IO System.Linq System.Net.Mail System.Xml System.Xml.Linq UiPath.Core UiPath.Core.Activities System.Windows.Markup UiPath.Excel System.Xml.Serialization Microsoft.VisualBasic.CompilerServices System.Activities Microsoft.VisualBasic mscorlib System.Data System System.Drawing System.Core System.Xml System.Xml.Linq PresentationFramework WindowsBase PresentationCore System.Xaml UiPath.System.Activities UiPath.UiAutomation.Activities UiPath.Excel.Activities UiPath.Excel System.ValueTuple True 270,2.5 60,75 300,77.5 300,97.5 __ReferenceID14 200,97.5 200,66 True True False False True False False False False False False [Day] [DateTime.Today.DayOfWeek.ToString] True [BAI_File_XLSX] ["S:\Data\UMBFS\General\fincrtl\RECON\RECON_REPORT_BOT_ARCHIVES\BAI2."+DateTime.Today.AddDays(-2).ToString("yyyyMMdd")+".MILTRANS.xlsx"] [BAI_File_Name] ["BAI2."+DateTime.Today.AddDays(-2).ToString("yyyyMMdd")+".MILTRANS.xlsx"] True [BAI_File_XLSX] ["S:\Data\UMBFS\General\fincrtl\RECON\RECON_REPORT_BOT_ARCHIVES\BAI2."+DateTime.Today.ToString("yyyyMMdd")+".MILTRANS.xlsx"] [BAI_File_Name] ["BAI2."+DateTime.Today.ToString("yyyyMMdd")+".MILTRANS.xlsx"] True True False [0] [3] False False [Outstanding_Checks_File] ["S:\Data\UMBFS\General\fincrtl\RECON\RECON_REPORT_BOT_ARCHIVES\DailySumOfOutstandingReport-"+DateTime.Today.ToString("yyyyMMdd")+".xls"] True False False [Undeliverable_File] ["S:\Data\UMBFS\General\fincrtl\RECON\RECON_REPORT_BOT_ARCHIVES\DailySumOfUndeliverableReport-"+DateTime.Today.ToString("yyyyMMdd")+".xls"] True True False False False [Day] [DateTime.Today.DayOfWeek.ToString] False False True [RPO_File] ["S:\Data\UMBFS\General\fincrtl\RECON\RECON_REPORT_BOT_ARCHIVES\RPO_Cash_Summary-"+DateTime.Today.AddDays(-3).ToString("yyyyMMdd")+".xls"] [RPO_Tab] ["RPO_Cash_Summary-"+DateTime.Today.AddDays(-3).ToString("yyyyMMdd")] True [RPO_File] ["S:\Data\UMBFS\General\fincrtl\RECON\RECON_REPORT_BOT_ARCHIVES\RPO_Cash_Summary-"+DateTime.Today.AddDays(-1).ToString("yyyyMMdd")+".xls"] [RPO_Tab] ["RPO_Cash_Summary-"+DateTime.Today.AddDays(-1).ToString("yyyyMMdd")] True True False [0] True False False False [Day] [DateTime.Today.DayOfWeek.ToString] False False True [Fees_Redeemed_File] ["S:\Data\UMBFS\General\fincrtl\RECON\RECON_REPORT_BOT_ARCHIVES\Daily_Fees_Redeemed_-_All_Companies_ex_CS_Summary-"+DateTime.Today.AddDays(-3).ToString("yyyyMMdd")+".xls"] False False True [Fees_Redeemed_File] ["S:\Data\UMBFS\General\fincrtl\RECON\RECON_REPORT_BOT_ARCHIVES\Daily_Fees_Redeemed_-_All_Companies_ex_CS_Summary-"+DateTime.Today.AddDays(-3).ToString("yyyyMMdd")+".xls"] [Fees_Redeemed_File] ["S:\Data\UMBFS\General\fincrtl\RECON\RECON_REPORT_BOT_ARCHIVES\Daily_Fees_Redeemed_-_All_Companies_ex_CS_Summary-"+DateTime.Today.AddDays(-1).ToString("yyyyMMdd")+".xls"] True True False [1] True False False False [Day] [DateTime.Today.DayOfWeek.ToString] False False True [Fees_Paid_File] ["S:\Data\UMBFS\General\fincrtl\RECON\RECON_REPORT_BOT_ARCHIVES\Daily_Fees_Paid_-_All_Companies_ex_CS_Summary-"+DateTime.Today.AddDays(-3).ToString("yyyyMMdd")+".xls"] False False True [Fees_Paid_File] ["S:\Data\UMBFS\General\fincrtl\RECON\RECON_REPORT_BOT_ARCHIVES\Daily_Fees_Paid_-_All_Companies_ex_CS_Summary-"+DateTime.Today.AddDays(-3).ToString("yyyyMMdd")+".xls"] [Fees_Paid_File] ["S:\Data\UMBFS\General\fincrtl\RECON\RECON_REPORT_BOT_ARCHIVES\Daily_Fees_Paid_-_All_Companies_ex_CS_Summary-"+DateTime.Today.AddDays(-1).ToString("yyyyMMdd")+".xls"] True True False [1] False False True False False True [Company_Name] [row(0).ToString] [Company_Number] [row(1).ToString] [DDA_Number] [row(3).ToString] [File_Path] [row(6).ToString] [Tab_Name] [row(7).ToString] False False True True False False [Closing_Ledger] [row(4).ToString] False False False False True True True [Outstanding_Check_Amount] ["-"+Row(3).ToString] False False False False True True True [Undeliverable_Amount] ["-"+Row(3).ToString] False False False False True True True False True [RPO_Cash] ["-"+Row(2).ToString] False False False False True True True False True [Fee_Redeemed_Amount] ["-"+Row(6).ToString] False False False False True True True False True [Fees_Paid_Amount] ["-"+Row(6).ToString] False False False False False False [Check_Deposit_Path] ["\\umb.corp.umb.com\dfs1$\Data\UMBFS\General\mfact1\Workflow\PIReports\"] [Year] [DateTime.Today.ToString("yyyy")] [Month] [DateTime.Today.ToString("MM")] [Day_of_Week] [DateTime.now.DayOfWeek.ToString] False False [Day] [DateTime.Today.AddDays(-3).ToString("dd")] [Day] [DateTime.Today.AddDays(-1).ToString("dd")] [Date_Exists] [Directory.Exists(Check_Deposit_Path+"\"+Company_Number+"\"+Year+"\"+Month+"\"+Day)] True False True [Check_Deposit_File] [Check_Deposit_Path+"\"+Company_Number+"\"+Year+"\"+Month+"\"+Day+"\Complete-Summary.xls"] True True True [Check_Deposit_Amount] ["-"+Row(4).ToString] False False True True False [Pad_File_Path] [“\\wsys5010a\DATA$\PrinterMgr\PlanetPress_OUT\ACHControl\”+DateTime.Today.ToString("yyyy-MM-dd")] [Pad_File_Name] True False 270,2.5 60,75 300,77.5 300,107.5 299.895,107.5 299.895,240 1163 1537.5 __ReferenceID13 169,487.5 262,60 300,547.5 300,577.5 [Reader] [New IO.StringReader(Pad_Text)] 169,577.5 262,60 300,637.5 300,697.5 [Line] [Reader.ReadLine()] True 265,697.5 70,87 265,741 115,741 115,855.02 335,741 476,741 476,851 15,855.02 200,52 True 345,851 262,60 476,911 476,961 [Fields] [Line.Trim.Split(" "C)] True 441,961 70,87 False 441,1004.5 366,1004.5 366,1311 511,1004.5 696,1004.5 696,1106.5 True 331,1311 70,87 331,1354.5 301,1354.5 301,1174.5 131,1174.5 131,1204.5 False 401,1354.5 930.239522138655,1354.5 930.239522138655,607.5 431,607.5 0,1204.5 262,60 131,1264.5 131,1294.5 130,1294.5 130,1314.5 [Pad_Amount] [Fields(1)] 15,1314.5 230,62 130,1376.5 130,1425.5 30,1425.5 200,52 True __ReferenceID0 True 659.5,1106.5 73,87 659.5,1150 529,1150 529,1290 559,1290 732.5,1150 762.5,1150 762.5,607.5 431,607.5 559,1260 262,60 821,1290 851,1290 851,607.5 431,607.5 [Company_Number] [Fields(0).Trim] True __ReferenceID0 __ReferenceID0 __ReferenceID0 __ReferenceID1 __ReferenceID2 __ReferenceID3 __ReferenceID4 __ReferenceID5 __ReferenceID6 __ReferenceID7 __ReferenceID8 __ReferenceID9 __ReferenceID10 168.895,240 262,91 299.895,331 299.895,357.5 [Company_Number] True True 168.895,357.5 262,91 299.895,448.5 299.895,478.5 300,478.5 300,487.5 [Searched_Company_Number] ["416"] True True __ReferenceID11 __ReferenceID12 False False False False True [Closing_Ledger] 0 False False True [RPO_Cash] 0 False False True [Outstanding_Check_Amount] 0 False False True [Undeliverable_Amount] 0 False False True [Fee_Redeemed_Amount] 0 False False True [Fees_Paid_Amount] 0 True False True [Fees_Paid_Amount] 0 False False True False True False False False False True True [Balance] [row(2).ToString] False False False False True True True False False False [Daily_Recon_File] ["S:\Data\UMBFS\General\fincrtl\RECON\RECON_REPORT_BOT_ARCHIVES\Daily Recon Reports\MF Oper without Comms Daily Recon Report-"+DateTime.Today.ToString("MM-dd-yyyy")+".xlsx"] True False True False [Balanced_Items] [Balanced_DT.Rows.Count-1] [Unbalanced_Items] [Unbalanced_DT.rows.count-1] [Total_Items] [Balanced_Items+Unbalanced_Items] [Daily_Recon_File]