Hi Kapil,

Please find sample data.

File_List

File_ID File_Status Customer_NameDirectionFirst_DirectoryOriginal_FileName

1 Active P&G I \\XYZ MonthlyReport

2 Passive Dabur I \\XYZ WeeklyReport

3 Active Nirma O \\abc DailyReport

File_Dest

File_Dest_ID File_ID Final_DirectoryOutput_FileNameDelivery_Type

1 1\\GHI MonthlyReport FTP

2 3\\KLM WeeklyReport FTP

3 1\\GHI DailyReportSFTP

File_Schedule

File_Sche_ID File_ID Start_Date First_Notify Second_Notify Due_Day Schedule_Type

1 112/30/13 0:00 Y N Last MondayEvery 28 Days

2 112/30/13 0:00 Y Y Last Day-1Day(s) EachMonth

3 312/30/13 0:00 N N Thursday

Weekly

Thanks,

Debajit