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]