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 __ReferenceID0 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 [Reader] [New IO.StringReader(Pad_Text)] True [Line] [Reader.ReadLine()] [Sentinel] False True True True [Fields] [Line.Trim.Split(" "C)] [Company_Number] 416 True False [Pad_Amount] [Fields(1)] 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]