SFTP account: #sftpAccountLabel# (agency #dedicatedAgencyId#) — current directory: #cfftp.returnvalue#

FTP Directory Listing

Name	Path	URL	Length	LastModified	IsDirectory
#name#	#path#	#url#	#length#	#DateFormat(LastModified, "yyyy-mm-dd")# #TimeFormat(LastModified, "hh:mm:ss")#	#IsDirectory#

SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = SELECT Invoice_ID FROM #targetAgencyDb#.Invoices WHERE Internal_control_number = UPDATE #targetAgencyDb#.Invoices SET claim_status = , errors = , Error_description = , claim_rejected_date = ,Record_Modified_By = ,Record_Modified_Date = WHERE Internal_control_number = AND (IFNULL(Invoice_Lock,0) <> 1) UPDATE #targetAgencyDb#.Invoices SET claim_status = , errors = , Error_description = , claim_received_date = ,Record_Modified_By = ,Record_Modified_Date = WHERE Internal_control_number = AND (IFNULL(Invoice_Lock,0) <> 1) SELECT * FROM #Request.prefix_db_agency#.Invoices Where Internal_control_number='#controlnumber#' UPDATE #Request.prefix_db_agency#.Invoices SET claim_status ='A2', errors = '#error#', claim_received_date ='#Accepteddate#' ,Record_Modified_By = '#Session.EmployeeId#' ,Record_Modified_Date = #now()# Where Internal_control_number='#controlnumber#' AND (IFNULL(Invoice_Lock,0) <> 1) Select errors from #Request.prefix_db_agency#.Invoices Where Internal_control_number='#controlnumber#' SELECT * FROM #Request.prefix_db_agency#.Invoices Where Internal_control_number='#controlnumber#' UPDATE #Request.prefix_db_agency#.Invoices SET claim_status ='Rejected', errors = '#temp2#', claim_rejected_date = '#Rejecteddate#' ,Record_Modified_By = '#Session.EmployeeId#' ,Record_Modified_Date = #now()# Where Internal_control_number='#controlnumber#' AND (IFNULL(Invoice_Lock,0) <> 1) SELECT * FROM #Request.prefix_db_agency#.Invoices Where Internal_control_number='#controlnumber#' UPDATE #Request.prefix_db_agency#.Invoices SET claim_status ='Rejected', errors = '#error#', claim_rejected_date = '#Rejecteddate#' ,Record_Modified_By = '#Session.EmployeeId#' ,Record_Modified_Date = #now()# Where Internal_control_number='#controlnumber#' AND (IFNULL(Invoice_Lock,0) <> 1)