lcParameter : Select Distinct Contract.Exchange as Exchange, Exgroup.Booktype as Booktype, Contract.Vallan as Settle, Contract.Contract as Contract, Contract.ContractDate as ContDate, Tblproduct.Cproductdescription as PRODDESCRIPTION, Tblproduct.NPRODUCTCODE as PRODUCT, Contract.Code as Clientcode From Exgroup, Contract, Tblproduct where Contract.Firmnumber = 'REN-000001' and Contract.Code = 'S4171' and Contract.Contractdate >= to_date('30/08/2019', 'dd/mm/yyyy') and Contract.Contractdate <= to_date('30/08/2019', 'dd/mm/yyyy') and Tblproduct.cFirmnumber = Contract.Firmnumber and Contract.Nproductcode = Tblproduct.NPRODUCTCODE and Contract.Exchange = Exgroup.Code and Contract.Egroup = Exgroup.Groupcode and substr(Contract, 1, 1) <> '-' Order By ContDate Enter Here lcParameter : Select Distinct Contract.Exchange as Exchange, Exgroup.Booktype as Booktype, Contract.Vallan as Settle, Contract.Contract as Contract, Contract.ContractDate as ContDate, Tblproduct.Cproductdescription as PRODDESCRIPTION, Tblproduct.NPRODUCTCODE as PRODUCT, Contract.Code as Clientcode From Exgroup, Contract, Tblproduct where Contract.Firmnumber = 'REN-000001' and Contract.Code = 'S4171' and Contract.Contractdate >= to_date('30/08/2019', 'dd/mm/yyyy') and Contract.Contractdate <= to_date('30/08/2019', 'dd/mm/yyyy') and Tblproduct.cFirmnumber = Contract.Firmnumber and Contract.Nproductcode = Tblproduct.NPRODUCTCODE and Contract.Exchange = Exgroup.Code and Contract.Egroup = Exgroup.Groupcode and substr(Contract, 1, 1) <> '-' Order By ContDate Enter Here lcParameter : Data Source=131.107.2.226/dig1920;User Id=CLLVL;Password=CLLVL;Enlist=false;Pooling=TRUE; lcParameter : Select Pscannedimage,CFilename From tblscannedimage tblscannedimage Where cFirmnumber='REN-000001' And cClientcode='S4171 ' And (cFilename='CN_20190830_S4171_BSE68569_0.zip' Or cFilename like 'CN_20190830_S4171_%MER%' Or cFilename like 'CN_S4171_20190830_BSE%' Or cFilename='CN_20190830_S4171_NSE68569_0.zip' Or cFilename like 'CN_20190830_S4171_%MER%' Or cFilename like 'CN_S4171_20190830_NSE%' ) lcParameter : 1 lcParameter : 1 FileName : D:\INETPUB\WWWROOT\WPF_ADDON\WHATSAPPAPI\\DOWNLOAD\CN_20190830_S4171_MER637039780238228923.PDF ZipFileDet : D:\INETPUB\WWWROOT\WPF_ADDON\WHATSAPPAPI\\DOWNLOAD\CN_20190830_S4171_MER.PDF lcParameter : Select Distinct Contract.Exchange as Exchange, Exgroup.Booktype as Booktype, Contract.Vallan as Settle, Contract.Contract as Contract, Contract.ContractDate as ContDate, Tblproduct.Cproductdescription as PRODDESCRIPTION, Tblproduct.NPRODUCTCODE as PRODUCT, Contract.Code as Clientcode From Exgroup, Contract, Tblproduct where Contract.Firmnumber = 'REN-000001' and Contract.Code = 'S4171' and Contract.Contractdate >= to_date('17/05/2019', 'dd/mm/yyyy') and Contract.Contractdate <= to_date('17/05/2019', 'dd/mm/yyyy') and Tblproduct.cFirmnumber = Contract.Firmnumber and Contract.Nproductcode = Tblproduct.NPRODUCTCODE and Contract.Exchange = Exgroup.Code and Contract.Egroup = Exgroup.Groupcode and substr(Contract, 1, 1) <> '-' Order By ContDate Enter Here lcParameter : Data Source=131.107.2.226/dig1920;User Id=CLLVL;Password=CLLVL;Enlist=false;Pooling=TRUE; lcParameter : Select Pscannedimage,CFilename From tblscannedimage tblscannedimage Where cFirmnumber='REN-000001' And cClientcode='S4171 ' And (cFilename='CN_20190517_S4171_NSE22400_0.zip' Or cFilename like 'CN_20190517_S4171_%MER%' Or cFilename like 'CN_S4171_20190517_NSE%' ) lcParameter : 1 lcParameter : 1 FileName : D:\INETPUB\WWWROOT\WPF_ADDON\WHATSAPPAPI\\DOWNLOAD\CN_20190517_S4171_MER637039787543996789.PDF ZipFileDet : D:\INETPUB\WWWROOT\WPF_ADDON\WHATSAPPAPI\\DOWNLOAD\CN_20190517_S4171_MER.PDF lcParameter : Select Distinct Contract.Exchange as Exchange, Exgroup.Booktype as Booktype, Contract.Vallan as Settle, Contract.Contract as Contract, Contract.ContractDate as ContDate, Tblproduct.Cproductdescription as PRODDESCRIPTION, Tblproduct.NPRODUCTCODE as PRODUCT, Contract.Code as Clientcode From Exgroup, Contract, Tblproduct where Contract.Firmnumber = 'REN-000001' and Contract.Code = 'S4171' and Contract.Contractdate >= to_date('30/08/2019', 'dd/mm/yyyy') and Contract.Contractdate <= to_date('30/08/2019', 'dd/mm/yyyy') and Tblproduct.cFirmnumber = Contract.Firmnumber and Contract.Nproductcode = Tblproduct.NPRODUCTCODE and Contract.Exchange = Exgroup.Code and Contract.Egroup = Exgroup.Groupcode and substr(Contract, 1, 1) <> '-' Order By ContDate Enter Here lcParameter : Data Source=131.107.2.226/dig1920;User Id=CLLVL;Password=CLLVL;Enlist=false;Pooling=TRUE; lcParameter : Select Pscannedimage,CFilename From tblscannedimage tblscannedimage Where cFirmnumber='REN-000001' And cClientcode='S4171 ' And (cFilename='CN_20190830_S4171_BSE68569_0.zip' Or cFilename like 'CN_20190830_S4171_%MER%' Or cFilename like 'CN_S4171_20190830_BSE%' Or cFilename='CN_20190830_S4171_NSE68569_0.zip' Or cFilename like 'CN_20190830_S4171_%MER%' Or cFilename like 'CN_S4171_20190830_NSE%' ) lcParameter : 1 lcParameter : 1 FileName : D:\INETPUB\WWWROOT\WPF_ADDON\WHATSAPPAPI\\DOWNLOAD\CN_20190830_S4171_MER637039792780196282.PDF ZipFileDet : D:\INETPUB\WWWROOT\WPF_ADDON\WHATSAPPAPI\\DOWNLOAD\CN_20190830_S4171_MER.PDF lcParameter : Select Distinct Contract.Exchange as Exchange, Exgroup.Booktype as Booktype, Contract.Vallan as Settle, Contract.Contract as Contract, Contract.ContractDate as ContDate, Tblproduct.Cproductdescription as PRODDESCRIPTION, Tblproduct.NPRODUCTCODE as PRODUCT, Contract.Code as Clientcode From Exgroup, Contract, Tblproduct where Contract.Firmnumber = 'REN-000001' and Contract.Code = 'S3203 ' and Contract.Contractdate >= to_date('11/06/2019', 'dd/mm/yyyy') and Contract.Contractdate <= to_date('11/06/2019', 'dd/mm/yyyy') and Tblproduct.cFirmnumber = Contract.Firmnumber and Contract.Nproductcode = Tblproduct.NPRODUCTCODE and Contract.Exchange = Exgroup.Code and Contract.Egroup = Exgroup.Groupcode and substr(Contract, 1, 1) <> '-' Order By ContDate Enter Here lcParameter : Data Source=131.107.2.226/dig1920;User Id=CLLVL;Password=CLLVL;Enlist=false;Pooling=TRUE; lcParameter : Select Pscannedimage,CFilename From tblscannedimage tblscannedimage Where cFirmnumber='REN-000001' And cClientcode='S3203 ' And (cFilename='CN_20190611_S3203_BSE33686_0.zip' Or cFilename like 'CN_20190611_S3203_%MER%' Or cFilename like 'CN_S3203_20190611_BSE%' ) lcParameter : 1 lcParameter : 1 FileName : D:\INETPUB\WWWROOT\WPF_ADDON\WHATSAPPAPI\\DOWNLOAD\CN_20190611_S3203_MER637039813732854706.PDF ZipFileDet : D:\INETPUB\WWWROOT\WPF_ADDON\WHATSAPPAPI\\DOWNLOAD\CN_20190611_S3203_MER.PDF lcParameter : Select Distinct Contract.Exchange as Exchange, Exgroup.Booktype as Booktype, Contract.Vallan as Settle, Contract.Contract as Contract, Contract.ContractDate as ContDate, Tblproduct.Cproductdescription as PRODDESCRIPTION, Tblproduct.NPRODUCTCODE as PRODUCT, Contract.Code as Clientcode From Exgroup, Contract, Tblproduct where Contract.Firmnumber = 'REN-000001' and Contract.Code = 'C90K300' and Contract.Contractdate >= to_date('17/09/2019', 'dd/mm/yyyy') and Contract.Contractdate <= to_date('17/09/2019', 'dd/mm/yyyy') and Tblproduct.cFirmnumber = Contract.Firmnumber and Contract.Nproductcode = Tblproduct.NPRODUCTCODE and Contract.Exchange = Exgroup.Code and Contract.Egroup = Exgroup.Groupcode and substr(Contract, 1, 1) <> '-' Order By ContDate Enter Here lcParameter : Data Source=131.107.2.226/dig1920;User Id=CLLVL;Password=CLLVL;Enlist=false;Pooling=TRUE; lcParameter : Select Pscannedimage,CFilename From tblscannedimage tblscannedimage Where cFirmnumber='REN-000001' And cClientcode='C90K300 ' And (cFilename='CN_20190917_C90K300_NSEF75444_0.zip' Or cFilename like 'CN_20190917_C90K300_%MER%' Or cFilename like 'CN_C90K300_20190917_NSEF%' ) lcParameter : 1 lcParameter : 1 FileName : D:\INETPUB\WWWROOT\WPF_ADDON\WHATSAPPAPI\\DOWNLOAD\CN_20190917_C90K300_MER637043585884991584.PDF ZipFileDet : D:\INETPUB\WWWROOT\WPF_ADDON\WHATSAPPAPI\\DOWNLOAD\CN_20190917_C90K300_MER.PDF lcParameter : Select Distinct Contract.Exchange as Exchange, Exgroup.Booktype as Booktype, Contract.Vallan as Settle, Contract.Contract as Contract, Contract.ContractDate as ContDate, Tblproduct.Cproductdescription as PRODDESCRIPTION, Tblproduct.NPRODUCTCODE as PRODUCT, Contract.Code as Clientcode From Exgroup, Contract, Tblproduct where Contract.Firmnumber = 'REN-000001' and Contract.Code = 'B081038' and Contract.Contractdate >= to_date('03/10/2019', 'dd/mm/yyyy') and Contract.Contractdate <= to_date('03/10/2019', 'dd/mm/yyyy') and Tblproduct.cFirmnumber = Contract.Firmnumber and Contract.Nproductcode = Tblproduct.NPRODUCTCODE and Contract.Exchange = Exgroup.Code and Contract.Egroup = Exgroup.Groupcode and substr(Contract, 1, 1) <> '-' Order By ContDate Enter Here lcParameter : Data Source=131.107.2.226/dig1920;User Id=CLLVL;Password=CLLVL;Enlist=false;Pooling=TRUE; lcParameter : Select Pscannedimage,CFilename From tblscannedimage tblscannedimage Where cFirmnumber='REN-000001' And cClientcode='B081038 ' And (cFilename='CN_20191003_B081038_BSE83205_0.zip' Or cFilename like 'CN_20191003_B081038_%MER%' Or cFilename like 'CN_B081038_20191003_BSE%' Or cFilename='CN_20191003_B081038_NSE83205_0.zip' Or cFilename like 'CN_20191003_B081038_%MER%' Or cFilename like 'CN_B081038_20191003_NSE%' ) lcParameter : 0 lcParameter : Select Distinct Contract.Exchange as Exchange, Exgroup.Booktype as Booktype, Contract.Vallan as Settle, Contract.Contract as Contract, Contract.ContractDate as ContDate, Tblproduct.Cproductdescription as PRODDESCRIPTION, Tblproduct.NPRODUCTCODE as PRODUCT, Contract.Code as Clientcode From Exgroup, Contract, Tblproduct where Contract.Firmnumber = 'REN-000001' and Contract.Code = 'B081038' and Contract.Contractdate >= to_date('03/10/2019', 'dd/mm/yyyy') and Contract.Contractdate <= to_date('03/10/2019', 'dd/mm/yyyy') and Tblproduct.cFirmnumber = Contract.Firmnumber and Contract.Nproductcode = Tblproduct.NPRODUCTCODE and Contract.Exchange = Exgroup.Code and Contract.Egroup = Exgroup.Groupcode and substr(Contract, 1, 1) <> '-' Order By ContDate Enter Here lcParameter : Data Source=131.107.2.226/dig1920;User Id=CLLVL;Password=CLLVL;Enlist=false;Pooling=TRUE; lcParameter : Select Pscannedimage,CFilename From tblscannedimage tblscannedimage Where cFirmnumber='REN-000001' And cClientcode='B081038 ' And (cFilename='CN_20191003_B081038_BSE83205_0.zip' Or cFilename like 'CN_20191003_B081038_%MER%' Or cFilename like 'CN_B081038_20191003_BSE%' Or cFilename='CN_20191003_B081038_NSE83205_0.zip' Or cFilename like 'CN_20191003_B081038_%MER%' Or cFilename like 'CN_B081038_20191003_NSE%' ) lcParameter : 0 lcParameter : Select Distinct Contract.Exchange as Exchange, Exgroup.Booktype as Booktype, Contract.Vallan as Settle, Contract.Contract as Contract, Contract.ContractDate as ContDate, Tblproduct.Cproductdescription as PRODDESCRIPTION, Tblproduct.NPRODUCTCODE as PRODUCT, Contract.Code as Clientcode From Exgroup, Contract, Tblproduct where Contract.Firmnumber = 'REN-000001' and Contract.Code = 'S32110' and Contract.Contractdate >= to_date('04/10/2019', 'dd/mm/yyyy') and Contract.Contractdate <= to_date('04/10/2019', 'dd/mm/yyyy') and Tblproduct.cFirmnumber = Contract.Firmnumber and Contract.Nproductcode = Tblproduct.NPRODUCTCODE and Contract.Exchange = Exgroup.Code and Contract.Egroup = Exgroup.Groupcode and substr(Contract, 1, 1) <> '-' Order By ContDate Enter Here lcParameter : Data Source=131.107.2.226/dig1920;User Id=CLLVL;Password=CLLVL;Enlist=false;Pooling=TRUE; lcParameter : Select Pscannedimage,CFilename From tblscannedimage tblscannedimage Where cFirmnumber='REN-000001' And cClientcode='S32110 ' And (cFilename='CN_20191004_S32110_NSE84334_0.zip' Or cFilename like 'CN_20191004_S32110_%MER%' Or cFilename like 'CN_S32110_20191004_NSE%' Or cFilename='CN_20191004_S32110_BSE84334_0.zip' Or cFilename like 'CN_20191004_S32110_%MER%' Or cFilename like 'CN_S32110_20191004_BSE%' ) lcParameter : 0 lcParameter : Select Distinct Contract.Exchange as Exchange, Exgroup.Booktype as Booktype, Contract.Vallan as Settle, Contract.Contract as Contract, Contract.ContractDate as ContDate, Tblproduct.Cproductdescription as PRODDESCRIPTION, Tblproduct.NPRODUCTCODE as PRODUCT, Contract.Code as Clientcode From Exgroup, Contract, Tblproduct where Contract.Firmnumber = 'REN-000001' and Contract.Code = 'S32110 ' and Contract.Contractdate >= to_date('04/10/2019', 'dd/mm/yyyy') and Contract.Contractdate <= to_date('04/10/2019', 'dd/mm/yyyy') and Tblproduct.cFirmnumber = Contract.Firmnumber and Contract.Nproductcode = Tblproduct.NPRODUCTCODE and Contract.Exchange = Exgroup.Code and Contract.Egroup = Exgroup.Groupcode and substr(Contract, 1, 1) <> '-' Order By ContDate Enter Here lcParameter : Data Source=131.107.2.226/dig1920;User Id=CLLVL;Password=CLLVL;Enlist=false;Pooling=TRUE; lcParameter : Select Pscannedimage,CFilename From tblscannedimage tblscannedimage Where cFirmnumber='REN-000001' And cClientcode='S32110 ' And (cFilename='CN_20191004_S32110_NSE84334_0.zip' Or cFilename like 'CN_20191004_S32110_%MER%' Or cFilename like 'CN_S32110_20191004_NSE%' Or cFilename='CN_20191004_S32110_BSE84334_0.zip' Or cFilename like 'CN_20191004_S32110_%MER%' Or cFilename like 'CN_S32110_20191004_BSE%' ) lcParameter : 0 lcParameter : Select Distinct Contract.Exchange as Exchange, Exgroup.Booktype as Booktype, Contract.Vallan as Settle, Contract.Contract as Contract, Contract.ContractDate as ContDate, Tblproduct.Cproductdescription as PRODDESCRIPTION, Tblproduct.NPRODUCTCODE as PRODUCT, Contract.Code as Clientcode From Exgroup, Contract, Tblproduct where Contract.Firmnumber = 'REN-000001' and Contract.Code = 'S32110 ' and Contract.Contractdate >= to_date('04/10/2019', 'dd/mm/yyyy') and Contract.Contractdate <= to_date('04/10/2019', 'dd/mm/yyyy') and Tblproduct.cFirmnumber = Contract.Firmnumber and Contract.Nproductcode = Tblproduct.NPRODUCTCODE and Contract.Exchange = Exgroup.Code and Contract.Egroup = Exgroup.Groupcode and substr(Contract, 1, 1) <> '-' Order By ContDate Enter Here lcParameter : Data Source=131.107.2.226/dig1920;User Id=CLLVL;Password=CLLVL;Enlist=false;Pooling=TRUE; lcParameter : Select Pscannedimage,CFilename From tblscannedimage tblscannedimage Where cFirmnumber='REN-000001' And cClientcode='S32110 ' And (cFilename='CN_20191004_S32110_NSE84334_0.zip' Or cFilename like 'CN_20191004_S32110_%MER%' Or cFilename like 'CN_S32110_20191004_NSE%' Or cFilename='CN_20191004_S32110_BSE84334_0.zip' Or cFilename like 'CN_20191004_S32110_%MER%' Or cFilename like 'CN_S32110_20191004_BSE%' ) lcParameter : 0 lcParameter : Select Distinct Contract.Exchange as Exchange, Exgroup.Booktype as Booktype, Contract.Vallan as Settle, Contract.Contract as Contract, Contract.ContractDate as ContDate, Tblproduct.Cproductdescription as PRODDESCRIPTION, Tblproduct.NPRODUCTCODE as PRODUCT, Contract.Code as Clientcode From Exgroup, Contract, Tblproduct where Contract.Firmnumber = 'REN-000001' and Contract.Code = 'B33147' and Contract.Contractdate >= to_date('14/10/2019', 'dd/mm/yyyy') and Contract.Contractdate <= to_date('14/10/2019', 'dd/mm/yyyy') and Tblproduct.cFirmnumber = Contract.Firmnumber and Contract.Nproductcode = Tblproduct.NPRODUCTCODE and Contract.Exchange = Exgroup.Code and Contract.Egroup = Exgroup.Groupcode and substr(Contract, 1, 1) <> '-' Order By ContDate Enter Here lcParameter : Data Source=131.107.2.226/dig1920;User Id=CLLVL;Password=CLLVL;Enlist=false;Pooling=TRUE; lcParameter : Select Pscannedimage,CFilename From tblscannedimage tblscannedimage Where cFirmnumber='REN-000001' And cClientcode='B33147 ' And (cFilename='CN_20191014_B33147_NSEF86864_0.zip' Or cFilename like 'CN_20191014_B33147_%MER%' Or cFilename like 'CN_B33147_20191014_NSEF%' ) lcParameter : 1 lcParameter : 1 FileName : D:\INETPUB\WWWROOT\WPF_ADDON\WHATSAPPAPI\\DOWNLOAD\CN_20191014_B33147_MER637067601467908122.PDF ZipFileDet : D:\INETPUB\WWWROOT\WPF_ADDON\WHATSAPPAPI\\DOWNLOAD\CN_20191014_B33147_MER.PDF lcParameter : Select Distinct Contract.Exchange as Exchange, Exgroup.Booktype as Booktype, Contract.Vallan as Settle, Contract.Contract as Contract, Contract.ContractDate as ContDate, Tblproduct.Cproductdescription as PRODDESCRIPTION, Tblproduct.NPRODUCTCODE as PRODUCT, Contract.Code as Clientcode From Exgroup, Contract, Tblproduct where Contract.Firmnumber = 'REN-000001' and Contract.Code = 'B33888 ' and Contract.Contractdate >= to_date('14/10/2019', 'dd/mm/yyyy') and Contract.Contractdate <= to_date('14/10/2019', 'dd/mm/yyyy') and Tblproduct.cFirmnumber = Contract.Firmnumber and Contract.Nproductcode = Tblproduct.NPRODUCTCODE and Contract.Exchange = Exgroup.Code and Contract.Egroup = Exgroup.Groupcode and substr(Contract, 1, 1) <> '-' Order By ContDate Enter Here lcParameter : Data Source=131.107.2.226/dig1920;User Id=CLLVL;Password=CLLVL;Enlist=false;Pooling=TRUE; lcParameter : Select Pscannedimage,CFilename From tblscannedimage tblscannedimage Where cFirmnumber='REN-000001' And cClientcode='B33888 ' And (cFilename='CN_20191014_B33888_NSEF86866_0.zip' Or cFilename like 'CN_20191014_B33888_%MER%' Or cFilename like 'CN_B33888_20191014_NSEF%' ) lcParameter : 1 lcParameter : 1 FileName : D:\INETPUB\WWWROOT\WPF_ADDON\WHATSAPPAPI\\DOWNLOAD\CN_20191014_B33888_MER637067602555356268.PDF ZipFileDet : D:\INETPUB\WWWROOT\WPF_ADDON\WHATSAPPAPI\\DOWNLOAD\CN_20191014_B33888_MER.PDF lcParameter : Select Distinct Contract.Exchange as Exchange, Exgroup.Booktype as Booktype, Contract.Vallan as Settle, Contract.Contract as Contract, Contract.ContractDate as ContDate, Tblproduct.Cproductdescription as PRODDESCRIPTION, Tblproduct.NPRODUCTCODE as PRODUCT, Contract.Code as Clientcode From Exgroup, Contract, Tblproduct where Contract.Firmnumber = 'REN-000001' and Contract.Code = 'B33147 ' and Contract.Contractdate >= to_date('14/10/2019', 'dd/mm/yyyy') and Contract.Contractdate <= to_date('14/10/2019', 'dd/mm/yyyy') and Tblproduct.cFirmnumber = Contract.Firmnumber and Contract.Nproductcode = Tblproduct.NPRODUCTCODE and Contract.Exchange = Exgroup.Code and Contract.Egroup = Exgroup.Groupcode and substr(Contract, 1, 1) <> '-' Order By ContDate Enter Here lcParameter : Data Source=131.107.2.226/dig1920;User Id=CLLVL;Password=CLLVL;Enlist=false;Pooling=TRUE; lcParameter : Select Pscannedimage,CFilename From tblscannedimage tblscannedimage Where cFirmnumber='REN-000001' And cClientcode='B33147 ' And (cFilename='CN_20191014_B33147_NSEF86864_0.zip' Or cFilename like 'CN_20191014_B33147_%MER%' Or cFilename like 'CN_B33147_20191014_NSEF%' ) lcParameter : 1 lcParameter : 1 FileName : D:\INETPUB\WWWROOT\WPF_ADDON\WHATSAPPAPI\\DOWNLOAD\CN_20191014_B33147_MER637067603037771835.PDF ZipFileDet : D:\INETPUB\WWWROOT\WPF_ADDON\WHATSAPPAPI\\DOWNLOAD\CN_20191014_B33147_MER.PDF lcParameter : Select Distinct Contract.Exchange as Exchange, Exgroup.Booktype as Booktype, Contract.Vallan as Settle, Contract.Contract as Contract, Contract.ContractDate as ContDate, Tblproduct.Cproductdescription as PRODDESCRIPTION, Tblproduct.NPRODUCTCODE as PRODUCT, Contract.Code as Clientcode From Exgroup, Contract, Tblproduct where Contract.Firmnumber = 'REN-000001' and Contract.Code = 'B33923 ' and Contract.Contractdate >= to_date('16/10/2019', 'dd/mm/yyyy') and Contract.Contractdate <= to_date('16/10/2019', 'dd/mm/yyyy') and Tblproduct.cFirmnumber = Contract.Firmnumber and Contract.Nproductcode = Tblproduct.NPRODUCTCODE and Contract.Exchange = Exgroup.Code and Contract.Egroup = Exgroup.Groupcode and substr(Contract, 1, 1) <> '-' Order By ContDate Enter Here lcParameter : Data Source=131.107.2.226/dig1920;User Id=CLLVL;Password=CLLVL;Enlist=false;Pooling=TRUE; lcParameter : Select Pscannedimage,CFilename From tblscannedimage tblscannedimage Where cFirmnumber='REN-000001' And cClientcode='B33923 ' And (cFilename='CN_20191016_B33923_NSEF88664_0.zip' Or cFilename like 'CN_20191016_B33923_%MER%' Or cFilename like 'CN_B33923_20191016_NSEF%' ) lcParameter : 1 lcParameter : 1 FileName : D:\INETPUB\WWWROOT\WPF_ADDON\WHATSAPPAPI\\DOWNLOAD\CN_20191016_B33923_MER637068534241800582.PDF ZipFileDet : D:\INETPUB\WWWROOT\WPF_ADDON\WHATSAPPAPI\\DOWNLOAD\CN_20191016_B33923_MER.PDF lcParameter : Select Distinct Contract.Exchange as Exchange, Exgroup.Booktype as Booktype, Contract.Vallan as Settle, Contract.Contract as Contract, Contract.ContractDate as ContDate, Tblproduct.Cproductdescription as PRODDESCRIPTION, Tblproduct.NPRODUCTCODE as PRODUCT, Contract.Code as Clientcode From Exgroup, Contract, Tblproduct where Contract.Firmnumber = 'REN-000001' and Contract.Code = 'B33923 ' and Contract.Contractdate >= to_date('16/10/2019', 'dd/mm/yyyy') and Contract.Contractdate <= to_date('16/10/2019', 'dd/mm/yyyy') and Tblproduct.cFirmnumber = Contract.Firmnumber and Contract.Nproductcode = Tblproduct.NPRODUCTCODE and Contract.Exchange = Exgroup.Code and Contract.Egroup = Exgroup.Groupcode and substr(Contract, 1, 1) <> '-' Order By ContDate Enter Here lcParameter : Data Source=131.107.2.226/dig1920;User Id=CLLVL;Password=CLLVL;Enlist=false;Pooling=TRUE; lcParameter : Select Pscannedimage,CFilename From tblscannedimage tblscannedimage Where cFirmnumber='REN-000001' And cClientcode='B33923 ' And (cFilename='CN_20191016_B33923_NSEF88664_0.zip' Or cFilename like 'CN_20191016_B33923_%MER%' Or cFilename like 'CN_B33923_20191016_NSEF%' ) lcParameter : 1 lcParameter : 1 FileName : D:\INETPUB\WWWROOT\WPF_ADDON\WHATSAPPAPI\\DOWNLOAD\CN_20191016_B33923_MER637068535829061325.PDF ZipFileDet : D:\INETPUB\WWWROOT\WPF_ADDON\WHATSAPPAPI\\DOWNLOAD\CN_20191016_B33923_MER.PDF lcParameter : Select Distinct Contract.Exchange as Exchange, Exgroup.Booktype as Booktype, Contract.Vallan as Settle, Contract.Contract as Contract, Contract.ContractDate as ContDate, Tblproduct.Cproductdescription as PRODDESCRIPTION, Tblproduct.NPRODUCTCODE as PRODUCT, Contract.Code as Clientcode From Exgroup, Contract, Tblproduct where Contract.Firmnumber = 'REN-000001' and Contract.Code = 'B33147 ' and Contract.Contractdate >= to_date('16/10/2019', 'dd/mm/yyyy') and Contract.Contractdate <= to_date('16/10/2019', 'dd/mm/yyyy') and Tblproduct.cFirmnumber = Contract.Firmnumber and Contract.Nproductcode = Tblproduct.NPRODUCTCODE and Contract.Exchange = Exgroup.Code and Contract.Egroup = Exgroup.Groupcode and substr(Contract, 1, 1) <> '-' Order By ContDate Enter Here lcParameter : Data Source=131.107.2.226/dig1920;User Id=CLLVL;Password=CLLVL;Enlist=false;Pooling=TRUE; lcParameter : Select Pscannedimage,CFilename From tblscannedimage tblscannedimage Where cFirmnumber='REN-000001' And cClientcode='B33147 ' And (cFilename='CN_20191016_B33147_NSEF88661_0.zip' Or cFilename like 'CN_20191016_B33147_%MER%' Or cFilename like 'CN_B33147_20191016_NSEF%' ) lcParameter : 1 lcParameter : 1 FileName : D:\INETPUB\WWWROOT\WPF_ADDON\WHATSAPPAPI\\DOWNLOAD\CN_20191016_B33147_MER637068539912144647.PDF ZipFileDet : D:\INETPUB\WWWROOT\WPF_ADDON\WHATSAPPAPI\\DOWNLOAD\CN_20191016_B33147_MER.PDF lcParameter : Select Distinct Contract.Exchange as Exchange, Exgroup.Booktype as Booktype, Contract.Vallan as Settle, Contract.Contract as Contract, Contract.ContractDate as ContDate, Tblproduct.Cproductdescription as PRODDESCRIPTION, Tblproduct.NPRODUCTCODE as PRODUCT, Contract.Code as Clientcode From Exgroup, Contract, Tblproduct where Contract.Firmnumber = 'REN-000001' and Contract.Code = 'B33147 ' and Contract.Contractdate >= to_date('17/10/2019', 'dd/mm/yyyy') and Contract.Contractdate <= to_date('17/10/2019', 'dd/mm/yyyy') and Tblproduct.cFirmnumber = Contract.Firmnumber and Contract.Nproductcode = Tblproduct.NPRODUCTCODE and Contract.Exchange = Exgroup.Code and Contract.Egroup = Exgroup.Groupcode and substr(Contract, 1, 1) <> '-' Order By ContDate Enter Here lcParameter : Data Source=131.107.2.226/dig1920;User Id=CLLVL;Password=CLLVL;Enlist=false;Pooling=TRUE; lcParameter : Select Pscannedimage,CFilename From tblscannedimage tblscannedimage Where cFirmnumber='REN-000001' And cClientcode='B33147 ' And (cFilename='CN_20191017_B33147_NSEF89432_0.zip' Or cFilename like 'CN_20191017_B33147_%MER%' Or cFilename like 'CN_B33147_20191017_NSEF%' ) lcParameter : 0 lcParameter : Select Distinct Contract.Exchange as Exchange, Exgroup.Booktype as Booktype, Contract.Vallan as Settle, Contract.Contract as Contract, Contract.ContractDate as ContDate, Tblproduct.Cproductdescription as PRODDESCRIPTION, Tblproduct.NPRODUCTCODE as PRODUCT, Contract.Code as Clientcode From Exgroup, Contract, Tblproduct where Contract.Firmnumber = 'REN-000001' and Contract.Code = 'B33923 ' and Contract.Contractdate >= to_date('17/10/2019', 'dd/mm/yyyy') and Contract.Contractdate <= to_date('17/10/2019', 'dd/mm/yyyy') and Tblproduct.cFirmnumber = Contract.Firmnumber and Contract.Nproductcode = Tblproduct.NPRODUCTCODE and Contract.Exchange = Exgroup.Code and Contract.Egroup = Exgroup.Groupcode and substr(Contract, 1, 1) <> '-' Order By ContDate Enter Here lcParameter : Data Source=131.107.2.226/dig1920;User Id=CLLVL;Password=CLLVL;Enlist=false;Pooling=TRUE; lcParameter : Select Pscannedimage,CFilename From tblscannedimage tblscannedimage Where cFirmnumber='REN-000001' And cClientcode='B33923 ' And (cFilename='CN_20191017_B33923_NSEF89435_0.zip' Or cFilename like 'CN_20191017_B33923_%MER%' Or cFilename like 'CN_B33923_20191017_NSEF%' ) lcParameter : 0 lcParameter : Select Distinct Contract.Exchange as Exchange, Exgroup.Booktype as Booktype, Contract.Vallan as Settle, Contract.Contract as Contract, Contract.ContractDate as ContDate, Tblproduct.Cproductdescription as PRODDESCRIPTION, Tblproduct.NPRODUCTCODE as PRODUCT, Contract.Code as Clientcode From Exgroup, Contract, Tblproduct where Contract.Firmnumber = 'REN-000001' and Contract.Code = 'S46201' and Contract.Contractdate >= to_date('16/10/2019', 'dd/mm/yyyy') and Contract.Contractdate <= to_date('16/10/2019', 'dd/mm/yyyy') and Tblproduct.cFirmnumber = Contract.Firmnumber and Contract.Nproductcode = Tblproduct.NPRODUCTCODE and Contract.Exchange = Exgroup.Code and Contract.Egroup = Exgroup.Groupcode and substr(Contract, 1, 1) <> '-' Order By ContDate Enter Here lcParameter : Data Source=131.107.2.226/dig1920;User Id=CLLVL;Password=CLLVL;Enlist=false;Pooling=TRUE; lcParameter : Select Pscannedimage,CFilename From tblscannedimage tblscannedimage Where cFirmnumber='REN-000001' And cClientcode='S46201 ' And (cFilename='CN_20191016_S46201_BSE89580_0.zip' Or cFilename like 'CN_20191016_S46201_%MER%' Or cFilename like 'CN_S46201_20191016_BSE%' ) lcParameter : 0 lcParameter : Select Distinct Contract.Exchange as Exchange, Exgroup.Booktype as Booktype, Contract.Vallan as Settle, Contract.Contract as Contract, Contract.ContractDate as ContDate, Tblproduct.Cproductdescription as PRODDESCRIPTION, Tblproduct.NPRODUCTCODE as PRODUCT, Contract.Code as Clientcode From Exgroup, Contract, Tblproduct where Contract.Firmnumber = 'REN-000001' and Contract.Code = 'S46201 ' and Contract.Contractdate >= to_date('16/10/2019', 'dd/mm/yyyy') and Contract.Contractdate <= to_date('16/10/2019', 'dd/mm/yyyy') and Tblproduct.cFirmnumber = Contract.Firmnumber and Contract.Nproductcode = Tblproduct.NPRODUCTCODE and Contract.Exchange = Exgroup.Code and Contract.Egroup = Exgroup.Groupcode and substr(Contract, 1, 1) <> '-' Order By ContDate Enter Here lcParameter : Data Source=131.107.2.226/dig1920;User Id=CLLVL;Password=CLLVL;Enlist=false;Pooling=TRUE; lcParameter : Select Pscannedimage,CFilename From tblscannedimage tblscannedimage Where cFirmnumber='REN-000001' And cClientcode='S46201 ' And (cFilename='CN_20191016_S46201_BSE89580_0.zip' Or cFilename like 'CN_20191016_S46201_%MER%' Or cFilename like 'CN_S46201_20191016_BSE%' ) lcParameter : 0 lcParameter : Select Distinct Contract.Exchange as Exchange, Exgroup.Booktype as Booktype, Contract.Vallan as Settle, Contract.Contract as Contract, Contract.ContractDate as ContDate, Tblproduct.Cproductdescription as PRODDESCRIPTION, Tblproduct.NPRODUCTCODE as PRODUCT, Contract.Code as Clientcode From Exgroup, Contract, Tblproduct where Contract.Firmnumber = 'REN-000001' and Contract.Code = 'S46201 ' and Contract.Contractdate >= to_date('16/10/2019', 'dd/mm/yyyy') and Contract.Contractdate <= to_date('16/10/2019', 'dd/mm/yyyy') and Tblproduct.cFirmnumber = Contract.Firmnumber and Contract.Nproductcode = Tblproduct.NPRODUCTCODE and Contract.Exchange = Exgroup.Code and Contract.Egroup = Exgroup.Groupcode and substr(Contract, 1, 1) <> '-' Order By ContDate Enter Here lcParameter : Data Source=131.107.2.226/dig1920;User Id=CLLVL;Password=CLLVL;Enlist=false;Pooling=TRUE; lcParameter : Select Pscannedimage,CFilename From tblscannedimage tblscannedimage Where cFirmnumber='REN-000001' And cClientcode='S46201 ' And (cFilename='CN_20191016_S46201_BSE89580_0.zip' Or cFilename like 'CN_20191016_S46201_%MER%' Or cFilename like 'CN_S46201_20191016_BSE%' ) lcParameter : 0 lcParameter : Select Distinct Contract.Exchange as Exchange, Exgroup.Booktype as Booktype, Contract.Vallan as Settle, Contract.Contract as Contract, Contract.ContractDate as ContDate, Tblproduct.Cproductdescription as PRODDESCRIPTION, Tblproduct.NPRODUCTCODE as PRODUCT, Contract.Code as Clientcode From Exgroup, Contract, Tblproduct where Contract.Firmnumber = 'REN-000001' and Contract.Code = 'B33147 ' and Contract.Contractdate >= to_date('22/10/2019', 'dd/mm/yyyy') and Contract.Contractdate <= to_date('22/10/2019', 'dd/mm/yyyy') and Tblproduct.cFirmnumber = Contract.Firmnumber and Contract.Nproductcode = Tblproduct.NPRODUCTCODE and Contract.Exchange = Exgroup.Code and Contract.Egroup = Exgroup.Groupcode and substr(Contract, 1, 1) <> '-' Order By ContDate Enter Here lcParameter : Data Source=131.107.2.226/dig1920;User Id=CLLVL;Password=CLLVL;Enlist=false;Pooling=TRUE; lcParameter : Select Pscannedimage,CFilename From tblscannedimage tblscannedimage Where cFirmnumber='REN-000001' And cClientcode='B33147 ' And (cFilename='CN_20191022_B33147_BSE90621_0.zip' Or cFilename like 'CN_20191022_B33147_%MER%' Or cFilename like 'CN_B33147_20191022_BSE%' Or cFilename='CN_20191022_B33147_NSEF90621_0.zip' Or cFilename like 'CN_20191022_B33147_%MER%' Or cFilename like 'CN_B33147_20191022_NSEF%' ) lcParameter : 1 lcParameter : 1 FileName : D:\INETPUB\WWWROOT\WPF_ADDON\WHATSAPPAPI\\DOWNLOAD\CN_20191022_B33147_MER637073785634593093.PDF ZipFileDet : D:\INETPUB\WWWROOT\WPF_ADDON\WHATSAPPAPI\\DOWNLOAD\CN_20191022_B33147_MER.PDF lcParameter : Select Distinct Contract.Exchange as Exchange, Exgroup.Booktype as Booktype, Contract.Vallan as Settle, Contract.Contract as Contract, Contract.ContractDate as ContDate, Tblproduct.Cproductdescription as PRODDESCRIPTION, Tblproduct.NPRODUCTCODE as PRODUCT, Contract.Code as Clientcode From Exgroup, Contract, Tblproduct where Contract.Firmnumber = 'REN-000001' and Contract.Code = 'B33147 ' and Contract.Contractdate >= to_date('22/10/2019', 'dd/mm/yyyy') and Contract.Contractdate <= to_date('22/10/2019', 'dd/mm/yyyy') and Tblproduct.cFirmnumber = Contract.Firmnumber and Contract.Nproductcode = Tblproduct.NPRODUCTCODE and Contract.Exchange = Exgroup.Code and Contract.Egroup = Exgroup.Groupcode and substr(Contract, 1, 1) <> '-' Order By ContDate Enter Here lcParameter : Data Source=131.107.2.226/dig1920;User Id=CLLVL;Password=CLLVL;Enlist=false;Pooling=TRUE; lcParameter : Select Pscannedimage,CFilename From tblscannedimage tblscannedimage Where cFirmnumber='REN-000001' And cClientcode='B33147 ' And (cFilename='CN_20191022_B33147_BSE90621_0.zip' Or cFilename like 'CN_20191022_B33147_%MER%' Or cFilename like 'CN_B33147_20191022_BSE%' Or cFilename='CN_20191022_B33147_NSEF90621_0.zip' Or cFilename like 'CN_20191022_B33147_%MER%' Or cFilename like 'CN_B33147_20191022_NSEF%' ) lcParameter : 1 lcParameter : 1 FileName : D:\INETPUB\WWWROOT\WPF_ADDON\WHATSAPPAPI\\DOWNLOAD\CN_20191022_B33147_MER637073787352425183.PDF ZipFileDet : D:\INETPUB\WWWROOT\WPF_ADDON\WHATSAPPAPI\\DOWNLOAD\CN_20191022_B33147_MER.PDF lcParameter : Select Distinct Contract.Exchange as Exchange, Exgroup.Booktype as Booktype, Contract.Vallan as Settle, Contract.Contract as Contract, Contract.ContractDate as ContDate, Tblproduct.Cproductdescription as PRODDESCRIPTION, Tblproduct.NPRODUCTCODE as PRODUCT, Contract.Code as Clientcode From Exgroup, Contract, Tblproduct where Contract.Firmnumber = 'REN-000001' and Contract.Code = 'B33923 ' and Contract.Contractdate >= to_date('22/10/2019', 'dd/mm/yyyy') and Contract.Contractdate <= to_date('22/10/2019', 'dd/mm/yyyy') and Tblproduct.cFirmnumber = Contract.Firmnumber and Contract.Nproductcode = Tblproduct.NPRODUCTCODE and Contract.Exchange = Exgroup.Code and Contract.Egroup = Exgroup.Groupcode and substr(Contract, 1, 1) <> '-' Order By ContDate Enter Here lcParameter : Data Source=131.107.2.226/dig1920;User Id=CLLVL;Password=CLLVL;Enlist=false;Pooling=TRUE; lcParameter : Select Pscannedimage,CFilename From tblscannedimage tblscannedimage Where cFirmnumber='REN-000001' And cClientcode='B33923 ' And (cFilename='CN_20191022_B33923_NSEF91156_0.zip' Or cFilename like 'CN_20191022_B33923_%MER%' Or cFilename like 'CN_B33923_20191022_NSEF%' ) lcParameter : 1 lcParameter : 1 FileName : D:\INETPUB\WWWROOT\WPF_ADDON\WHATSAPPAPI\\DOWNLOAD\CN_20191022_B33923_MER637073791713180292.PDF ZipFileDet : D:\INETPUB\WWWROOT\WPF_ADDON\WHATSAPPAPI\\DOWNLOAD\CN_20191022_B33923_MER.PDF lcParameter : Select Distinct Contract.Exchange as Exchange, Exgroup.Booktype as Booktype, Contract.Vallan as Settle, Contract.Contract as Contract, Contract.ContractDate as ContDate, Tblproduct.Cproductdescription as PRODDESCRIPTION, Tblproduct.NPRODUCTCODE as PRODUCT, Contract.Code as Clientcode From Exgroup, Contract, Tblproduct where Contract.Firmnumber = 'REN-000001' and Contract.Code = 'B33147 ' and Contract.Contractdate >= to_date('23/10/2019', 'dd/mm/yyyy') and Contract.Contractdate <= to_date('23/10/2019', 'dd/mm/yyyy') and Tblproduct.cFirmnumber = Contract.Firmnumber and Contract.Nproductcode = Tblproduct.NPRODUCTCODE and Contract.Exchange = Exgroup.Code and Contract.Egroup = Exgroup.Groupcode and substr(Contract, 1, 1) <> '-' Order By ContDate Enter Here lcParameter : Data Source=131.107.2.226/dig1920;User Id=CLLVL;Password=CLLVL;Enlist=false;Pooling=TRUE; lcParameter : Select Pscannedimage,CFilename From tblscannedimage tblscannedimage Where cFirmnumber='REN-000001' And cClientcode='B33147 ' And (cFilename='CN_20191023_B33147_NSEF91905_0.zip' Or cFilename like 'CN_20191023_B33147_%MER%' Or cFilename like 'CN_B33147_20191023_NSEF%' ) lcParameter : 1 lcParameter : 1 FileName : D:\INETPUB\WWWROOT\WPF_ADDON\WHATSAPPAPI\\DOWNLOAD\CN_20191023_B33147_MER637074586543621647.PDF ZipFileDet : D:\INETPUB\WWWROOT\WPF_ADDON\WHATSAPPAPI\\DOWNLOAD\CN_20191023_B33147_MER.PDF lcParameter : Select Distinct Contract.Exchange as Exchange, Exgroup.Booktype as Booktype, Contract.Vallan as Settle, Contract.Contract as Contract, Contract.ContractDate as ContDate, Tblproduct.Cproductdescription as PRODDESCRIPTION, Tblproduct.NPRODUCTCODE as PRODUCT, Contract.Code as Clientcode From Exgroup, Contract, Tblproduct where Contract.Firmnumber = 'REN-000001' and Contract.Code = 'B33923 ' and Contract.Contractdate >= to_date('23/10/2019', 'dd/mm/yyyy') and Contract.Contractdate <= to_date('23/10/2019', 'dd/mm/yyyy') and Tblproduct.cFirmnumber = Contract.Firmnumber and Contract.Nproductcode = Tblproduct.NPRODUCTCODE and Contract.Exchange = Exgroup.Code and Contract.Egroup = Exgroup.Groupcode and substr(Contract, 1, 1) <> '-' Order By ContDate Enter Here lcParameter : Data Source=131.107.2.226/dig1920;User Id=CLLVL;Password=CLLVL;Enlist=false;Pooling=TRUE; lcParameter : Select Pscannedimage,CFilename From tblscannedimage tblscannedimage Where cFirmnumber='REN-000001' And cClientcode='B33923 ' And (cFilename='CN_20191023_B33923_NSEF91907_0.zip' Or cFilename like 'CN_20191023_B33923_%MER%' Or cFilename like 'CN_B33923_20191023_NSEF%' ) lcParameter : 1 lcParameter : 1 FileName : D:\INETPUB\WWWROOT\WPF_ADDON\WHATSAPPAPI\\DOWNLOAD\CN_20191023_B33923_MER637074586659878296.PDF ZipFileDet : D:\INETPUB\WWWROOT\WPF_ADDON\WHATSAPPAPI\\DOWNLOAD\CN_20191023_B33923_MER.PDF lcParameter : Select Distinct Contract.Exchange as Exchange, Exgroup.Booktype as Booktype, Contract.Vallan as Settle, Contract.Contract as Contract, Contract.ContractDate as ContDate, Tblproduct.Cproductdescription as PRODDESCRIPTION, Tblproduct.NPRODUCTCODE as PRODUCT, Contract.Code as Clientcode From Exgroup, Contract, Tblproduct where Contract.Firmnumber = 'REN-000001' and Contract.Code = 'B33923 ' and Contract.Contractdate >= to_date('24/10/2019', 'dd/mm/yyyy') and Contract.Contractdate <= to_date('24/10/2019', 'dd/mm/yyyy') and Tblproduct.cFirmnumber = Contract.Firmnumber and Contract.Nproductcode = Tblproduct.NPRODUCTCODE and Contract.Exchange = Exgroup.Code and Contract.Egroup = Exgroup.Groupcode and substr(Contract, 1, 1) <> '-' Order By ContDate Enter Here lcParameter : Data Source=131.107.2.226/dig1920;User Id=CLLVL;Password=CLLVL;Enlist=false;Pooling=TRUE; lcParameter : Select Pscannedimage,CFilename From tblscannedimage tblscannedimage Where cFirmnumber='REN-000001' And cClientcode='B33923 ' And (cFilename='CN_20191024_B33923_NSEF92583_0.zip' Or cFilename like 'CN_20191024_B33923_%MER%' Or cFilename like 'CN_B33923_20191024_NSEF%' ) lcParameter : 1 lcParameter : 1 FileName : D:\INETPUB\WWWROOT\WPF_ADDON\WHATSAPPAPI\\DOWNLOAD\CN_20191024_B33923_MER637075450397466149.PDF ZipFileDet : D:\INETPUB\WWWROOT\WPF_ADDON\WHATSAPPAPI\\DOWNLOAD\CN_20191024_B33923_MER.PDF lcParameter : Select Distinct Contract.Exchange as Exchange, Exgroup.Booktype as Booktype, Contract.Vallan as Settle, Contract.Contract as Contract, Contract.ContractDate as ContDate, Tblproduct.Cproductdescription as PRODDESCRIPTION, Tblproduct.NPRODUCTCODE as PRODUCT, Contract.Code as Clientcode From Exgroup, Contract, Tblproduct where Contract.Firmnumber = 'REN-000001' and Contract.Code = 'B33147 ' and Contract.Contractdate >= to_date('24/10/2019', 'dd/mm/yyyy') and Contract.Contractdate <= to_date('24/10/2019', 'dd/mm/yyyy') and Tblproduct.cFirmnumber = Contract.Firmnumber and Contract.Nproductcode = Tblproduct.NPRODUCTCODE and Contract.Exchange = Exgroup.Code and Contract.Egroup = Exgroup.Groupcode and substr(Contract, 1, 1) <> '-' Order By ContDate Enter Here lcParameter : Data Source=131.107.2.226/dig1920;User Id=CLLVL;Password=CLLVL;Enlist=false;Pooling=TRUE; lcParameter : Select Pscannedimage,CFilename From tblscannedimage tblscannedimage Where cFirmnumber='REN-000001' And cClientcode='B33147 ' And (cFilename='CN_20191024_B33147_NSEF92580_0.zip' Or cFilename like 'CN_20191024_B33147_%MER%' Or cFilename like 'CN_B33147_20191024_NSEF%' ) lcParameter : 1 lcParameter : 1 FileName : D:\INETPUB\WWWROOT\WPF_ADDON\WHATSAPPAPI\\DOWNLOAD\CN_20191024_B33147_MER637075450897800628.PDF ZipFileDet : D:\INETPUB\WWWROOT\WPF_ADDON\WHATSAPPAPI\\DOWNLOAD\CN_20191024_B33147_MER.PDF lcParameter : Select Distinct Contract.Exchange as Exchange, Exgroup.Booktype as Booktype, Contract.Vallan as Settle, Contract.Contract as Contract, Contract.ContractDate as ContDate, Tblproduct.Cproductdescription as PRODDESCRIPTION, Tblproduct.NPRODUCTCODE as PRODUCT, Contract.Code as Clientcode From Exgroup, Contract, Tblproduct where Contract.Firmnumber = 'REN-000001' and Contract.Code = 'B33147 ' and Contract.Contractdate >= to_date('25/10/2019', 'dd/mm/yyyy') and Contract.Contractdate <= to_date('25/10/2019', 'dd/mm/yyyy') and Tblproduct.cFirmnumber = Contract.Firmnumber and Contract.Nproductcode = Tblproduct.NPRODUCTCODE and Contract.Exchange = Exgroup.Code and Contract.Egroup = Exgroup.Groupcode and substr(Contract, 1, 1) <> '-' Order By ContDate Enter Here lcParameter : Select Distinct Contract.Exchange as Exchange, Exgroup.Booktype as Booktype, Contract.Vallan as Settle, Contract.Contract as Contract, Contract.ContractDate as ContDate, Tblproduct.Cproductdescription as PRODDESCRIPTION, Tblproduct.NPRODUCTCODE as PRODUCT, Contract.Code as Clientcode From Exgroup, Contract, Tblproduct where Contract.Firmnumber = 'REN-000001' and Contract.Code = 'B33147 ' and Contract.Contractdate >= to_date('25/10/2019', 'dd/mm/yyyy') and Contract.Contractdate <= to_date('25/10/2019', 'dd/mm/yyyy') and Tblproduct.cFirmnumber = Contract.Firmnumber and Contract.Nproductcode = Tblproduct.NPRODUCTCODE and Contract.Exchange = Exgroup.Code and Contract.Egroup = Exgroup.Groupcode and substr(Contract, 1, 1) <> '-' Order By ContDate Enter Here lcParameter : Select Distinct Contract.Exchange as Exchange, Exgroup.Booktype as Booktype, Contract.Vallan as Settle, Contract.Contract as Contract, Contract.ContractDate as ContDate, Tblproduct.Cproductdescription as PRODDESCRIPTION, Tblproduct.NPRODUCTCODE as PRODUCT, Contract.Code as Clientcode From Exgroup, Contract, Tblproduct where Contract.Firmnumber = 'REN-000001' and Contract.Code = 'B33147 ' and Contract.Contractdate >= to_date('24/10/2019', 'dd/mm/yyyy') and Contract.Contractdate <= to_date('24/10/2019', 'dd/mm/yyyy') and Tblproduct.cFirmnumber = Contract.Firmnumber and Contract.Nproductcode = Tblproduct.NPRODUCTCODE and Contract.Exchange = Exgroup.Code and Contract.Egroup = Exgroup.Groupcode and substr(Contract, 1, 1) <> '-' Order By ContDate Enter Here lcParameter : Data Source=131.107.2.226/dig1920;User Id=CLLVL;Password=CLLVL;Enlist=false;Pooling=TRUE; lcParameter : Select Pscannedimage,CFilename From tblscannedimage tblscannedimage Where cFirmnumber='REN-000001' And cClientcode='B33147 ' And (cFilename='CN_20191024_B33147_NSEF92580_0.zip' Or cFilename like 'CN_20191024_B33147_%MER%' Or cFilename like 'CN_B33147_20191024_NSEF%' ) lcParameter : 1 lcParameter : 1 FileName : D:\INETPUB\WWWROOT\WPF_ADDON\WHATSAPPAPI\\DOWNLOAD\CN_20191024_B33147_MER637075461824989284.PDF ZipFileDet : D:\INETPUB\WWWROOT\WPF_ADDON\WHATSAPPAPI\\DOWNLOAD\CN_20191024_B33147_MER.PDF lcParameter : Select Distinct Contract.Exchange as Exchange, Exgroup.Booktype as Booktype, Contract.Vallan as Settle, Contract.Contract as Contract, Contract.ContractDate as ContDate, Tblproduct.Cproductdescription as PRODDESCRIPTION, Tblproduct.NPRODUCTCODE as PRODUCT, Contract.Code as Clientcode From Exgroup, Contract, Tblproduct where Contract.Firmnumber = 'REN-000001' and Contract.Code = 'B33147 ' and Contract.Contractdate >= to_date('24/10/2019', 'dd/mm/yyyy') and Contract.Contractdate <= to_date('24/10/2019', 'dd/mm/yyyy') and Tblproduct.cFirmnumber = Contract.Firmnumber and Contract.Nproductcode = Tblproduct.NPRODUCTCODE and Contract.Exchange = Exgroup.Code and Contract.Egroup = Exgroup.Groupcode and substr(Contract, 1, 1) <> '-' Order By ContDate Enter Here lcParameter : Data Source=131.107.2.226/dig1920;User Id=CLLVL;Password=CLLVL;Enlist=false;Pooling=TRUE; lcParameter : Select Pscannedimage,CFilename From tblscannedimage tblscannedimage Where cFirmnumber='REN-000001' And cClientcode='B33147 ' And (cFilename='CN_20191024_B33147_NSEF92580_0.zip' Or cFilename like 'CN_20191024_B33147_%MER%' Or cFilename like 'CN_B33147_20191024_NSEF%' ) lcParameter : 1 lcParameter : 1 FileName : D:\INETPUB\WWWROOT\WPF_ADDON\WHATSAPPAPI\\DOWNLOAD\CN_20191024_B33147_MER637075463862995375.PDF ZipFileDet : D:\INETPUB\WWWROOT\WPF_ADDON\WHATSAPPAPI\\DOWNLOAD\CN_20191024_B33147_MER.PDF lcParameter : Select Distinct Contract.Exchange as Exchange, Exgroup.Booktype as Booktype, Contract.Vallan as Settle, Contract.Contract as Contract, Contract.ContractDate as ContDate, Tblproduct.Cproductdescription as PRODDESCRIPTION, Tblproduct.NPRODUCTCODE as PRODUCT, Contract.Code as Clientcode From Exgroup, Contract, Tblproduct where Contract.Firmnumber = 'REN-000001' and Contract.Code = 'B33147 ' and Contract.Contractdate >= to_date('25/10/2019', 'dd/mm/yyyy') and Contract.Contractdate <= to_date('25/10/2019', 'dd/mm/yyyy') and Tblproduct.cFirmnumber = Contract.Firmnumber and Contract.Nproductcode = Tblproduct.NPRODUCTCODE and Contract.Exchange = Exgroup.Code and Contract.Egroup = Exgroup.Groupcode and substr(Contract, 1, 1) <> '-' Order By ContDate Enter Here lcParameter : Data Source=131.107.2.226/dig1920;User Id=CLLVL;Password=CLLVL;Enlist=false;Pooling=TRUE; lcParameter : Select Pscannedimage,CFilename From tblscannedimage tblscannedimage Where cFirmnumber='REN-000001' And cClientcode='B33147 ' And (cFilename='CN_20191025_B33147_NSEF92792_0.zip' Or cFilename like 'CN_20191025_B33147_%MER%' Or cFilename like 'CN_B33147_20191025_NSEF%' ) lcParameter : 1 lcParameter : 1 FileName : D:\INETPUB\WWWROOT\WPF_ADDON\WHATSAPPAPI\\DOWNLOAD\CN_20191025_B33147_MER637076803105080243.PDF ZipFileDet : D:\INETPUB\WWWROOT\WPF_ADDON\WHATSAPPAPI\\DOWNLOAD\CN_20191025_B33147_MER.PDF lcParameter : Select Distinct Contract.Exchange as Exchange, Exgroup.Booktype as Booktype, Contract.Vallan as Settle, Contract.Contract as Contract, Contract.ContractDate as ContDate, Tblproduct.Cproductdescription as PRODDESCRIPTION, Tblproduct.NPRODUCTCODE as PRODUCT, Contract.Code as Clientcode From Exgroup, Contract, Tblproduct where Contract.Firmnumber = 'REN-000001' and Contract.Code = 'B33923 ' and Contract.Contractdate >= to_date('25/10/2019', 'dd/mm/yyyy') and Contract.Contractdate <= to_date('25/10/2019', 'dd/mm/yyyy') and Tblproduct.cFirmnumber = Contract.Firmnumber and Contract.Nproductcode = Tblproduct.NPRODUCTCODE and Contract.Exchange = Exgroup.Code and Contract.Egroup = Exgroup.Groupcode and substr(Contract, 1, 1) <> '-' Order By ContDate Enter Here lcParameter : Data Source=131.107.2.226/dig1920;User Id=CLLVL;Password=CLLVL;Enlist=false;Pooling=TRUE; lcParameter : Select Pscannedimage,CFilename From tblscannedimage tblscannedimage Where cFirmnumber='REN-000001' And cClientcode='B33923 ' And (cFilename='CN_20191025_B33923_NSEF92795_0.zip' Or cFilename like 'CN_20191025_B33923_%MER%' Or cFilename like 'CN_B33923_20191025_NSEF%' ) lcParameter : 1 lcParameter : 1 FileName : D:\INETPUB\WWWROOT\WPF_ADDON\WHATSAPPAPI\\DOWNLOAD\CN_20191025_B33923_MER637076803649373315.PDF ZipFileDet : D:\INETPUB\WWWROOT\WPF_ADDON\WHATSAPPAPI\\DOWNLOAD\CN_20191025_B33923_MER.PDF lcParameter : Select Distinct Contract.Exchange as Exchange, Exgroup.Booktype as Booktype, Contract.Vallan as Settle, Contract.Contract as Contract, Contract.ContractDate as ContDate, Tblproduct.Cproductdescription as PRODDESCRIPTION, Tblproduct.NPRODUCTCODE as PRODUCT, Contract.Code as Clientcode From Exgroup, Contract, Tblproduct where Contract.Firmnumber = 'REN-000001' and Contract.Code = 'B33147 ' and Contract.Contractdate >= to_date('30/10/2019', 'dd/mm/yyyy') and Contract.Contractdate <= to_date('30/10/2019', 'dd/mm/yyyy') and Tblproduct.cFirmnumber = Contract.Firmnumber and Contract.Nproductcode = Tblproduct.NPRODUCTCODE and Contract.Exchange = Exgroup.Code and Contract.Egroup = Exgroup.Groupcode and substr(Contract, 1, 1) <> '-' Order By ContDate Enter Here lcParameter : Data Source=131.107.2.226/dig1920;User Id=CLLVL;Password=CLLVL;Enlist=false;Pooling=TRUE; lcParameter : Select Pscannedimage,CFilename From tblscannedimage tblscannedimage Where cFirmnumber='REN-000001' And cClientcode='B33147 ' And (cFilename='CN_20191030_B33147_NSEF95395_0.zip' Or cFilename like 'CN_20191030_B33147_%MER%' Or cFilename like 'CN_B33147_20191030_NSEF%' ) lcParameter : 0 lcParameter : Select Distinct Contract.Exchange as Exchange, Exgroup.Booktype as Booktype, Contract.Vallan as Settle, Contract.Contract as Contract, Contract.ContractDate as ContDate, Tblproduct.Cproductdescription as PRODDESCRIPTION, Tblproduct.NPRODUCTCODE as PRODUCT, Contract.Code as Clientcode From Exgroup, Contract, Tblproduct where Contract.Firmnumber = 'REN-000001' and Contract.Code = 'B33923 ' and Contract.Contractdate >= to_date('30/10/2019', 'dd/mm/yyyy') and Contract.Contractdate <= to_date('30/10/2019', 'dd/mm/yyyy') and Tblproduct.cFirmnumber = Contract.Firmnumber and Contract.Nproductcode = Tblproduct.NPRODUCTCODE and Contract.Exchange = Exgroup.Code and Contract.Egroup = Exgroup.Groupcode and substr(Contract, 1, 1) <> '-' Order By ContDate Enter Here lcParameter : Data Source=131.107.2.226/dig1920;User Id=CLLVL;Password=CLLVL;Enlist=false;Pooling=TRUE; lcParameter : Select Pscannedimage,CFilename From tblscannedimage tblscannedimage Where cFirmnumber='REN-000001' And cClientcode='B33923 ' And (cFilename='CN_20191030_B33923_NSEF95397_0.zip' Or cFilename like 'CN_20191030_B33923_%MER%' Or cFilename like 'CN_B33923_20191030_NSEF%' ) lcParameter : 0 lcParameter : Select Distinct Contract.Exchange as Exchange, Exgroup.Booktype as Booktype, Contract.Vallan as Settle, Contract.Contract as Contract, Contract.ContractDate as ContDate, Tblproduct.Cproductdescription as PRODDESCRIPTION, Tblproduct.NPRODUCTCODE as PRODUCT, Contract.Code as Clientcode From Exgroup, Contract, Tblproduct where Contract.Firmnumber = 'REN-000001' and Contract.Code = 'B33147 ' and Contract.Contractdate >= to_date('30/10/2019', 'dd/mm/yyyy') and Contract.Contractdate <= to_date('30/10/2019', 'dd/mm/yyyy') and Tblproduct.cFirmnumber = Contract.Firmnumber and Contract.Nproductcode = Tblproduct.NPRODUCTCODE and Contract.Exchange = Exgroup.Code and Contract.Egroup = Exgroup.Groupcode and substr(Contract, 1, 1) <> '-' Order By ContDate Enter Here lcParameter : Data Source=131.107.2.226/dig1920;User Id=CLLVL;Password=CLLVL;Enlist=false;Pooling=TRUE; lcParameter : Select Pscannedimage,CFilename From tblscannedimage tblscannedimage Where cFirmnumber='REN-000001' And cClientcode='B33147 ' And (cFilename='CN_20191030_B33147_NSEF95395_0.zip' Or cFilename like 'CN_20191030_B33147_%MER%' Or cFilename like 'CN_B33147_20191030_NSEF%' ) lcParameter : 0 lcParameter : Select Distinct Contract.Exchange as Exchange, Exgroup.Booktype as Booktype, Contract.Vallan as Settle, Contract.Contract as Contract, Contract.ContractDate as ContDate, Tblproduct.Cproductdescription as PRODDESCRIPTION, Tblproduct.NPRODUCTCODE as PRODUCT, Contract.Code as Clientcode From Exgroup, Contract, Tblproduct where Contract.Firmnumber = 'REN-000001' and Contract.Code = 'B33923 ' and Contract.Contractdate >= to_date('30/10/2019', 'dd/mm/yyyy') and Contract.Contractdate <= to_date('30/10/2019', 'dd/mm/yyyy') and Tblproduct.cFirmnumber = Contract.Firmnumber and Contract.Nproductcode = Tblproduct.NPRODUCTCODE and Contract.Exchange = Exgroup.Code and Contract.Egroup = Exgroup.Groupcode and substr(Contract, 1, 1) <> '-' Order By ContDate Enter Here lcParameter : Data Source=131.107.2.226/dig1920;User Id=CLLVL;Password=CLLVL;Enlist=false;Pooling=TRUE; lcParameter : Select Pscannedimage,CFilename From tblscannedimage tblscannedimage Where cFirmnumber='REN-000001' And cClientcode='B33923 ' And (cFilename='CN_20191030_B33923_NSEF95397_0.zip' Or cFilename like 'CN_20191030_B33923_%MER%' Or cFilename like 'CN_B33923_20191030_NSEF%' ) lcParameter : 0 lcParameter : Select Distinct Contract.Exchange as Exchange, Exgroup.Booktype as Booktype, Contract.Vallan as Settle, Contract.Contract as Contract, Contract.ContractDate as ContDate, Tblproduct.Cproductdescription as PRODDESCRIPTION, Tblproduct.NPRODUCTCODE as PRODUCT, Contract.Code as Clientcode From Exgroup, Contract, Tblproduct where Contract.Firmnumber = 'REN-000001' and Contract.Code = 'B33147 ' and Contract.Contractdate >= to_date('30/10/2019', 'dd/mm/yyyy') and Contract.Contractdate <= to_date('30/10/2019', 'dd/mm/yyyy') and Tblproduct.cFirmnumber = Contract.Firmnumber and Contract.Nproductcode = Tblproduct.NPRODUCTCODE and Contract.Exchange = Exgroup.Code and Contract.Egroup = Exgroup.Groupcode and substr(Contract, 1, 1) <> '-' Order By ContDate Enter Here lcParameter : Data Source=131.107.2.226/dig1920;User Id=CLLVL;Password=CLLVL;Enlist=false;Pooling=TRUE; lcParameter : Select Pscannedimage,CFilename From tblscannedimage tblscannedimage Where cFirmnumber='REN-000001' And cClientcode='B33147 ' And (cFilename='CN_20191030_B33147_NSEF95395_0.zip' Or cFilename like 'CN_20191030_B33147_%MER%' Or cFilename like 'CN_B33147_20191030_NSEF%' ) lcParameter : 0 lcParameter : Select Distinct Contract.Exchange as Exchange, Exgroup.Booktype as Booktype, Contract.Vallan as Settle, Contract.Contract as Contract, Contract.ContractDate as ContDate, Tblproduct.Cproductdescription as PRODDESCRIPTION, Tblproduct.NPRODUCTCODE as PRODUCT, Contract.Code as Clientcode From Exgroup, Contract, Tblproduct where Contract.Firmnumber = 'REN-000001' and Contract.Code = 'B33923 ' and Contract.Contractdate >= to_date('30/10/2019', 'dd/mm/yyyy') and Contract.Contractdate <= to_date('30/10/2019', 'dd/mm/yyyy') and Tblproduct.cFirmnumber = Contract.Firmnumber and Contract.Nproductcode = Tblproduct.NPRODUCTCODE and Contract.Exchange = Exgroup.Code and Contract.Egroup = Exgroup.Groupcode and substr(Contract, 1, 1) <> '-' Order By ContDate Enter Here lcParameter : Data Source=131.107.2.226/dig1920;User Id=CLLVL;Password=CLLVL;Enlist=false;Pooling=TRUE; lcParameter : Select Pscannedimage,CFilename From tblscannedimage tblscannedimage Where cFirmnumber='REN-000001' And cClientcode='B33923 ' And (cFilename='CN_20191030_B33923_NSEF95397_0.zip' Or cFilename like 'CN_20191030_B33923_%MER%' Or cFilename like 'CN_B33923_20191030_NSEF%' ) lcParameter : 0 lcParameter : Select Distinct Contract.Exchange as Exchange, Exgroup.Booktype as Booktype, Contract.Vallan as Settle, Contract.Contract as Contract, Contract.ContractDate as ContDate, Tblproduct.Cproductdescription as PRODDESCRIPTION, Tblproduct.NPRODUCTCODE as PRODUCT, Contract.Code as Clientcode From Exgroup, Contract, Tblproduct where Contract.Firmnumber = 'REN-000001' and Contract.Code = 'B33923 ' and Contract.Contractdate >= to_date('04/11/2019', 'dd/mm/yyyy') and Contract.Contractdate <= to_date('04/11/2019', 'dd/mm/yyyy') and Tblproduct.cFirmnumber = Contract.Firmnumber and Contract.Nproductcode = Tblproduct.NPRODUCTCODE and Contract.Exchange = Exgroup.Code and Contract.Egroup = Exgroup.Groupcode and substr(Contract, 1, 1) <> '-' Order By ContDate Enter Here lcParameter : Data Source=131.107.2.226/dig1920;User Id=CLLVL;Password=CLLVL;Enlist=false;Pooling=TRUE; lcParameter : Select Pscannedimage,CFilename From tblscannedimage tblscannedimage Where cFirmnumber='REN-000001' And cClientcode='B33923 ' And (cFilename='CN_20191104_B33923_NSEF97862_0.zip' Or cFilename like 'CN_20191104_B33923_%MER%' Or cFilename like 'CN_B33923_20191104_NSEF%' ) lcParameter : 0 lcParameter : Select Distinct Contract.Exchange as Exchange, Exgroup.Booktype as Booktype, Contract.Vallan as Settle, Contract.Contract as Contract, Contract.ContractDate as ContDate, Tblproduct.Cproductdescription as PRODDESCRIPTION, Tblproduct.NPRODUCTCODE as PRODUCT, Contract.Code as Clientcode From Exgroup, Contract, Tblproduct where Contract.Firmnumber = 'REN-000001' and Contract.Code = 'B33147 ' and Contract.Contractdate >= to_date('04/11/2019', 'dd/mm/yyyy') and Contract.Contractdate <= to_date('04/11/2019', 'dd/mm/yyyy') and Tblproduct.cFirmnumber = Contract.Firmnumber and Contract.Nproductcode = Tblproduct.NPRODUCTCODE and Contract.Exchange = Exgroup.Code and Contract.Egroup = Exgroup.Groupcode and substr(Contract, 1, 1) <> '-' Order By ContDate Enter Here lcParameter : Data Source=131.107.2.226/dig1920;User Id=CLLVL;Password=CLLVL;Enlist=false;Pooling=TRUE; lcParameter : Select Pscannedimage,CFilename From tblscannedimage tblscannedimage Where cFirmnumber='REN-000001' And cClientcode='B33147 ' And (cFilename='CN_20191104_B33147_NSEF97859_0.zip' Or cFilename like 'CN_20191104_B33147_%MER%' Or cFilename like 'CN_B33147_20191104_NSEF%' ) lcParameter : 0 lcParameter : Select Distinct Contract.Exchange as Exchange, Exgroup.Booktype as Booktype, Contract.Vallan as Settle, Contract.Contract as Contract, Contract.ContractDate as ContDate, Tblproduct.Cproductdescription as PRODDESCRIPTION, Tblproduct.NPRODUCTCODE as PRODUCT, Contract.Code as Clientcode From Exgroup, Contract, Tblproduct where Contract.Firmnumber = 'REN-000001' and Contract.Code = 'B33923 ' and Contract.Contractdate >= to_date('07/11/2019', 'dd/mm/yyyy') and Contract.Contractdate <= to_date('07/11/2019', 'dd/mm/yyyy') and Tblproduct.cFirmnumber = Contract.Firmnumber and Contract.Nproductcode = Tblproduct.NPRODUCTCODE and Contract.Exchange = Exgroup.Code and Contract.Egroup = Exgroup.Groupcode and substr(Contract, 1, 1) <> '-' Order By ContDate Enter Here lcParameter : Data Source=131.107.2.226/dig1920;User Id=CLLVL;Password=CLLVL;Enlist=false;Pooling=TRUE; lcParameter : Select Pscannedimage,CFilename From tblscannedimage tblscannedimage Where cFirmnumber='REN-000001' And cClientcode='B33923 ' And (cFilename='CN_20191107_B33923_NSEF100066_0.zip' Or cFilename like 'CN_20191107_B33923_%MER%' Or cFilename like 'CN_B33923_20191107_NSEF%' ) lcParameter : 1 lcParameter : 1 FileName : D:\INETPUB\WWWROOT\WPF_ADDON\WHATSAPPAPI\\DOWNLOAD\CN_20191107_B33923_MER637087651945290355.PDF ZipFileDet : D:\INETPUB\WWWROOT\WPF_ADDON\WHATSAPPAPI\\DOWNLOAD\CN_20191107_B33923_MER.PDF lcParameter : Select Distinct Contract.Exchange as Exchange, Exgroup.Booktype as Booktype, Contract.Vallan as Settle, Contract.Contract as Contract, Contract.ContractDate as ContDate, Tblproduct.Cproductdescription as PRODDESCRIPTION, Tblproduct.NPRODUCTCODE as PRODUCT, Contract.Code as Clientcode From Exgroup, Contract, Tblproduct where Contract.Firmnumber = 'REN-000001' and Contract.Code = 'S4532' and Contract.Contractdate >= to_date('14/11/2019', 'dd/mm/yyyy') and Contract.Contractdate <= to_date('14/11/2019', 'dd/mm/yyyy') and Tblproduct.cFirmnumber = Contract.Firmnumber and Contract.Nproductcode = Tblproduct.NPRODUCTCODE and Contract.Exchange = Exgroup.Code and Contract.Egroup = Exgroup.Groupcode and substr(Contract, 1, 1) <> '-' Order By ContDate Enter Here lcParameter : Data Source=131.107.2.226/dig1920;User Id=CLLVL;Password=CLLVL;Enlist=false;Pooling=TRUE; lcParameter : Select Pscannedimage,CFilename From tblscannedimage tblscannedimage Where cFirmnumber='REN-000001' And cClientcode='S4532 ' And (cFilename='CN_20191114_S4532_NSE102901_0.zip' Or cFilename like 'CN_20191114_S4532_%MER%' Or cFilename like 'CN_S4532_20191114_NSE%' Or cFilename='CN_20191114_S4532_BSE102901_0.zip' Or cFilename like 'CN_20191114_S4532_%MER%' Or cFilename like 'CN_S4532_20191114_BSE%' ) lcParameter : 1 lcParameter : 1 FileName : D:\INETPUB\WWWROOT\WPF_ADDON\WHATSAPPAPI\\DOWNLOAD\CN_20191114_S4532_MER637093579693996679.PDF ZipFileDet : D:\INETPUB\WWWROOT\WPF_ADDON\WHATSAPPAPI\\DOWNLOAD\CN_20191114_S4532_MER.PDF lcParameter : Select Distinct Contract.Exchange as Exchange, Exgroup.Booktype as Booktype, Contract.Vallan as Settle, Contract.Contract as Contract, Contract.ContractDate as ContDate, Tblproduct.Cproductdescription as PRODDESCRIPTION, Tblproduct.NPRODUCTCODE as PRODUCT, Contract.Code as Clientcode From Exgroup, Contract, Tblproduct where Contract.Firmnumber = 'REN-000001' and Contract.Code = 'C75006' and Contract.Contractdate >= to_date('29/07/2019', 'dd/mm/yyyy') and Contract.Contractdate <= to_date('29/07/2019', 'dd/mm/yyyy') and Tblproduct.cFirmnumber = Contract.Firmnumber and Contract.Nproductcode = Tblproduct.NPRODUCTCODE and Contract.Exchange = Exgroup.Code and Contract.Egroup = Exgroup.Groupcode and substr(Contract, 1, 1) <> '-' Order By ContDate Enter Here lcParameter : Select Distinct Contract.Exchange as Exchange, Exgroup.Booktype as Booktype, Contract.Vallan as Settle, Contract.Contract as Contract, Contract.ContractDate as ContDate, Tblproduct.Cproductdescription as PRODDESCRIPTION, Tblproduct.NPRODUCTCODE as PRODUCT, Contract.Code as Clientcode From Exgroup, Contract, Tblproduct where Contract.Firmnumber = 'REN-000001' and Contract.Code = 'C75006' and Contract.Contractdate >= to_date('27/07/2019', 'dd/mm/yyyy') and Contract.Contractdate <= to_date('27/07/2019', 'dd/mm/yyyy') and Tblproduct.cFirmnumber = Contract.Firmnumber and Contract.Nproductcode = Tblproduct.NPRODUCTCODE and Contract.Exchange = Exgroup.Code and Contract.Egroup = Exgroup.Groupcode and substr(Contract, 1, 1) <> '-' Order By ContDate Enter Here lcParameter : Select Distinct Contract.Exchange as Exchange, Exgroup.Booktype as Booktype, Contract.Vallan as Settle, Contract.Contract as Contract, Contract.ContractDate as ContDate, Tblproduct.Cproductdescription as PRODDESCRIPTION, Tblproduct.NPRODUCTCODE as PRODUCT, Contract.Code as Clientcode From Exgroup, Contract, Tblproduct where Contract.Firmnumber = 'REN-000001' and Contract.Code = 'S4532' and Contract.Contractdate >= to_date('02/12/2019', 'dd/mm/yyyy') and Contract.Contractdate <= to_date('02/12/2019', 'dd/mm/yyyy') and Tblproduct.cFirmnumber = Contract.Firmnumber and Contract.Nproductcode = Tblproduct.NPRODUCTCODE and Contract.Exchange = Exgroup.Code and Contract.Egroup = Exgroup.Groupcode and substr(Contract, 1, 1) <> '-' Order By ContDate Enter Here lcParameter : Data Source=131.107.2.226/dig1920;User Id=CLLVL;Password=CLLVL;Enlist=false;Pooling=TRUE; lcParameter : Select Pscannedimage,CFilename From tblscannedimage tblscannedimage Where cFirmnumber='REN-000001' And cClientcode='S4532 ' And (cFilename='CN_20191202_S4532_BSE111371_0.zip' Or cFilename like 'CN_20191202_S4532_%MER%' Or cFilename like 'CN_S4532_20191202_BSE%' ) lcParameter : 1 lcParameter : 1 FileName : D:\INETPUB\WWWROOT\WPF_ADDON\WHATSAPPAPI\\DOWNLOAD\CN_20191202_S4532_MER637109144664748346.PDF ZipFileDet : D:\INETPUB\WWWROOT\WPF_ADDON\WHATSAPPAPI\\DOWNLOAD\CN_20191202_S4532_MER.PDF lcParameter : Select Distinct Contract.Exchange as Exchange, Exgroup.Booktype as Booktype, Contract.Vallan as Settle, Contract.Contract as Contract, Contract.ContractDate as ContDate, Tblproduct.Cproductdescription as PRODDESCRIPTION, Tblproduct.NPRODUCTCODE as PRODUCT, Contract.Code as Clientcode From Exgroup, Contract, Tblproduct where Contract.Firmnumber = 'REN-000001' and Contract.Code = 'S32110' and Contract.Contractdate >= to_date('26/02/2020', 'dd/mm/yyyy') and Contract.Contractdate <= to_date('26/02/2020', 'dd/mm/yyyy') and Tblproduct.cFirmnumber = Contract.Firmnumber and Contract.Nproductcode = Tblproduct.NPRODUCTCODE and Contract.Exchange = Exgroup.Code and Contract.Egroup = Exgroup.Groupcode and substr(Contract, 1, 1) <> '-' Order By ContDate Enter Here lcParameter : Data Source=131.107.2.226/dig1920;User Id=CLLVL;Password=CLLVL;Enlist=false;Pooling=TRUE; lcParameter : Select Pscannedimage,CFilename From tblscannedimage tblscannedimage Where cFirmnumber='REN-000001' And cClientcode='S32110 ' And (cFilename='CN_20200226_S32110_NSE153487_0.zip' Or cFilename like 'CN_20200226_S32110_%MER%' Or cFilename like 'CN_S32110_20200226_NSE%' Or cFilename='CN_20200226_S32110_BSE153487_0.zip' Or cFilename like 'CN_20200226_S32110_%MER%' Or cFilename like 'CN_S32110_20200226_BSE%' ) lcParameter : 0 lcParameter : Select Distinct Contract.Exchange as Exchange, Exgroup.Booktype as Booktype, Contract.Vallan as Settle, Contract.Contract as Contract, Contract.ContractDate as ContDate, Tblproduct.Cproductdescription as PRODDESCRIPTION, Tblproduct.NPRODUCTCODE as PRODUCT, Contract.Code as Clientcode From Exgroup, Contract, Tblproduct where Contract.Firmnumber = 'REN-000001' and Contract.Code = 'S32110' and Contract.Contractdate >= to_date('24/02/2020', 'dd/mm/yyyy') and Contract.Contractdate <= to_date('24/02/2020', 'dd/mm/yyyy') and Tblproduct.cFirmnumber = Contract.Firmnumber and Contract.Nproductcode = Tblproduct.NPRODUCTCODE and Contract.Exchange = Exgroup.Code and Contract.Egroup = Exgroup.Groupcode and substr(Contract, 1, 1) <> '-' Order By ContDate Enter Here lcParameter : Select Distinct Contract.Exchange as Exchange, Exgroup.Booktype as Booktype, Contract.Vallan as Settle, Contract.Contract as Contract, Contract.ContractDate as ContDate, Tblproduct.Cproductdescription as PRODDESCRIPTION, Tblproduct.NPRODUCTCODE as PRODUCT, Contract.Code as Clientcode From Exgroup, Contract, Tblproduct where Contract.Firmnumber = 'REN-000001' and Contract.Code = 'S4532' and Contract.Contractdate >= to_date('28/02/2020', 'dd/mm/yyyy') and Contract.Contractdate <= to_date('28/02/2020', 'dd/mm/yyyy') and Tblproduct.cFirmnumber = Contract.Firmnumber and Contract.Nproductcode = Tblproduct.NPRODUCTCODE and Contract.Exchange = Exgroup.Code and Contract.Egroup = Exgroup.Groupcode and substr(Contract, 1, 1) <> '-' Order By ContDate Enter Here lcParameter : Data Source=131.107.2.226/dig1920;User Id=CLLVL;Password=CLLVL;Enlist=false;Pooling=TRUE; lcParameter : Select Pscannedimage,CFilename From tblscannedimage tblscannedimage Where cFirmnumber='REN-000001' And cClientcode='S4532 ' And (cFilename='CN_20200228_S4532_BSE155009_0.zip' Or cFilename like 'CN_20200228_S4532_%MER%' Or cFilename like 'CN_S4532_20200228_BSE%' ) lcParameter : 1 lcParameter : 1 FileName : D:\INETPUB\WWWROOT\WPF_ADDON\WHATSAPPAPI\\DOWNLOAD\CN_20200228_S4532_MER637185274683676333.PDF ZipFileDet : D:\INETPUB\WWWROOT\WPF_ADDON\WHATSAPPAPI\\DOWNLOAD\CN_20200228_S4532_MER.PDF lcParameter : Select Distinct Contract.Exchange as Exchange, Exgroup.Booktype as Booktype, Contract.Vallan as Settle, Contract.Contract as Contract, Contract.ContractDate as ContDate, Tblproduct.Cproductdescription as PRODDESCRIPTION, Tblproduct.NPRODUCTCODE as PRODUCT, Contract.Code as Clientcode From Exgroup, Contract, Tblproduct where Contract.Firmnumber = 'REN-000001' and Contract.Code = 'C45010' and Contract.Contractdate >= to_date('13/03/2020', 'dd/mm/yyyy') and Contract.Contractdate <= to_date('13/03/2020', 'dd/mm/yyyy') and Tblproduct.cFirmnumber = Contract.Firmnumber and Contract.Nproductcode = Tblproduct.NPRODUCTCODE and Contract.Exchange = Exgroup.Code and Contract.Egroup = Exgroup.Groupcode and substr(Contract, 1, 1) <> '-' Order By ContDate Enter Here lcParameter : Select Distinct Contract.Exchange as Exchange, Exgroup.Booktype as Booktype, Contract.Vallan as Settle, Contract.Contract as Contract, Contract.ContractDate as ContDate, Tblproduct.Cproductdescription as PRODDESCRIPTION, Tblproduct.NPRODUCTCODE as PRODUCT, Contract.Code as Clientcode From Exgroup, Contract, Tblproduct where Contract.Firmnumber = 'REN-000001' and Contract.Code = 'S3231 ' and Contract.Contractdate >= to_date('30/03/2020', 'dd/mm/yyyy') and Contract.Contractdate <= to_date('30/03/2020', 'dd/mm/yyyy') and Tblproduct.cFirmnumber = Contract.Firmnumber and Contract.Nproductcode = Tblproduct.NPRODUCTCODE and Contract.Exchange = Exgroup.Code and Contract.Egroup = Exgroup.Groupcode and substr(Contract, 1, 1) <> '-' Order By ContDate Enter Here lcParameter : Data Source=131.107.2.226/dig1920;User Id=CLLVL;Password=CLLVL;Enlist=false;Pooling=TRUE; lcParameter : Select Pscannedimage,CFilename From tblscannedimage tblscannedimage Where cFirmnumber='REN-000001' And cClientcode='S3231 ' And (cFilename='CN_20200330_S3231_BSE170108_0.zip' Or cFilename like 'CN_20200330_S3231_%MER%' Or cFilename like 'CN_S3231_20200330_BSE%' Or cFilename='CN_20200330_S3231_NSE170108_0.zip' Or cFilename like 'CN_20200330_S3231_%MER%' Or cFilename like 'CN_S3231_20200330_NSE%' ) lcParameter : 0 lcParameter : Select Distinct Contract.Exchange as Exchange, Exgroup.Booktype as Booktype, Contract.Vallan as Settle, Contract.Contract as Contract, Contract.ContractDate as ContDate, Tblproduct.Cproductdescription as PRODDESCRIPTION, Tblproduct.NPRODUCTCODE as PRODUCT, Contract.Code as Clientcode From Exgroup, Contract, Tblproduct where Contract.Firmnumber = 'REN-000001' and Contract.Code = 'S32110' and Contract.Contractdate >= to_date('04/03/2020', 'dd/mm/yyyy') and Contract.Contractdate <= to_date('04/03/2020', 'dd/mm/yyyy') and Tblproduct.cFirmnumber = Contract.Firmnumber and Contract.Nproductcode = Tblproduct.NPRODUCTCODE and Contract.Exchange = Exgroup.Code and Contract.Egroup = Exgroup.Groupcode and substr(Contract, 1, 1) <> '-' Order By ContDate Enter Here lcParameter : Data Source=131.107.2.226/dig1920;User Id=CLLVL;Password=CLLVL;Enlist=false;Pooling=TRUE; lcParameter : Select Pscannedimage,CFilename From tblscannedimage tblscannedimage Where cFirmnumber='REN-000001' And cClientcode='S32110 ' And (cFilename='CN_20200304_S32110_NSE156959_0.zip' Or cFilename like 'CN_20200304_S32110_%MER%' Or cFilename like 'CN_S32110_20200304_NSE%' Or cFilename='CN_20200304_S32110_BSE156959_0.zip' Or cFilename like 'CN_20200304_S32110_%MER%' Or cFilename like 'CN_S32110_20200304_BSE%' ) lcParameter : 1 lcParameter : 1 FileName : D:\INETPUB\WWWROOT\WPF_ADDON\WHATSAPPAPI\\DOWNLOAD\CN_20200304_S32110_MER637213577149712024.PDF ZipFileDet : D:\INETPUB\WWWROOT\WPF_ADDON\WHATSAPPAPI\\DOWNLOAD\CN_20200304_S32110_MER.PDF lcParameter : Select Distinct Contract.Exchange as Exchange, Exgroup.Booktype as Booktype, Contract.Vallan as Settle, Contract.Contract as Contract, Contract.ContractDate as ContDate, Tblproduct.Cproductdescription as PRODDESCRIPTION, Tblproduct.NPRODUCTCODE as PRODUCT, Contract.Code as Clientcode From Exgroup, Contract, Tblproduct where Contract.Firmnumber = 'REN-000001' and Contract.Code = 'B24506' and Contract.Contractdate >= to_date('30/04/2020', 'dd/mm/yyyy') and Contract.Contractdate <= to_date('30/04/2020', 'dd/mm/yyyy') and Tblproduct.cFirmnumber = Contract.Firmnumber and Contract.Nproductcode = Tblproduct.NPRODUCTCODE and Contract.Exchange = Exgroup.Code and Contract.Egroup = Exgroup.Groupcode and substr(Contract, 1, 1) <> '-' Order By ContDate Enter Here lcParameter : Data Source=131.107.2.226/dig1920;User Id=CLLVL;Password=CLLVL;Enlist=false;Pooling=TRUE; lcParameter : Select Pscannedimage,CFilename From tblscannedimage tblscannedimage Where cFirmnumber='REN-000001' And cClientcode='B24506 ' And (cFilename='CN_20200430_B24506_BSE12039_0.zip' Or cFilename like 'CN_20200430_B24506_%MER%' Or cFilename like 'CN_B24506_20200430_BSE%' ) lcParameter : 1 lcParameter : 1 FileName : D:\INETPUB\WWWROOT\WPF_ADDON\WHATSAPPAPI\\DOWNLOAD\CN_20200430_B24506_MER637241912564418965.PDF ZipFileDet : D:\INETPUB\WWWROOT\WPF_ADDON\WHATSAPPAPI\\DOWNLOAD\CN_20200430_B24506_MER.PDF lcParameter : Select Distinct Contract.Exchange as Exchange, Exgroup.Booktype as Booktype, Contract.Vallan as Settle, Contract.Contract as Contract, Contract.ContractDate as ContDate, Tblproduct.Cproductdescription as PRODDESCRIPTION, Tblproduct.NPRODUCTCODE as PRODUCT, Contract.Code as Clientcode From Exgroup, Contract, Tblproduct where Contract.Firmnumber = 'REN-000001' and Contract.Code = 'B05032' and Contract.Contractdate >= to_date('23/04/2020', 'dd/mm/yyyy') and Contract.Contractdate <= to_date('23/04/2020', 'dd/mm/yyyy') and Tblproduct.cFirmnumber = Contract.Firmnumber and Contract.Nproductcode = Tblproduct.NPRODUCTCODE and Contract.Exchange = Exgroup.Code and Contract.Egroup = Exgroup.Groupcode and substr(Contract, 1, 1) <> '-' Order By ContDate Enter Here lcParameter : Select Distinct Contract.Exchange as Exchange, Exgroup.Booktype as Booktype, Contract.Vallan as Settle, Contract.Contract as Contract, Contract.ContractDate as ContDate, Tblproduct.Cproductdescription as PRODDESCRIPTION, Tblproduct.NPRODUCTCODE as PRODUCT, Contract.Code as Clientcode From Exgroup, Contract, Tblproduct where Contract.Firmnumber = 'REN-000001' and Contract.Code = 'B05034 ' and Contract.Contractdate >= to_date('23/04/2020', 'dd/mm/yyyy') and Contract.Contractdate <= to_date('23/04/2020', 'dd/mm/yyyy') and Tblproduct.cFirmnumber = Contract.Firmnumber and Contract.Nproductcode = Tblproduct.NPRODUCTCODE and Contract.Exchange = Exgroup.Code and Contract.Egroup = Exgroup.Groupcode and substr(Contract, 1, 1) <> '-' Order By ContDate Enter Here lcParameter : Data Source=131.107.2.226/dig1920;User Id=CLLVL;Password=CLLVL;Enlist=false;Pooling=TRUE; lcParameter : Select Pscannedimage,CFilename From tblscannedimage tblscannedimage Where cFirmnumber='REN-000001' And cClientcode='B05034 ' And (cFilename='CN_20200423_B05034_BSE8224_0.zip' Or cFilename like 'CN_20200423_B05034_%MER%' Or cFilename like 'CN_B05034_20200423_BSE%' Or cFilename='CN_20200423_B05034_NSE8224_0.zip' Or cFilename like 'CN_20200423_B05034_%MER%' Or cFilename like 'CN_B05034_20200423_NSE%' ) lcParameter : 1 lcParameter : 1 FileName : D:\INETPUB\WWWROOT\WPF_ADDON\WHATSAPPAPI\\DOWNLOAD\CN_20200423_B05034_MER637244496618689579.PDF ZipFileDet : D:\INETPUB\WWWROOT\WPF_ADDON\WHATSAPPAPI\\DOWNLOAD\CN_20200423_B05034_MER.PDF lcParameter : Select Distinct Contract.Exchange as Exchange, Exgroup.Booktype as Booktype, Contract.Vallan as Settle, Contract.Contract as Contract, Contract.ContractDate as ContDate, Tblproduct.Cproductdescription as PRODDESCRIPTION, Tblproduct.NPRODUCTCODE as PRODUCT, Contract.Code as Clientcode From Exgroup, Contract, Tblproduct where Contract.Firmnumber = 'REN-000001' and Contract.Code = 'R011698' and Contract.Contractdate >= to_date('24/04/2020', 'dd/mm/yyyy') and Contract.Contractdate <= to_date('24/04/2020', 'dd/mm/yyyy') and Tblproduct.cFirmnumber = Contract.Firmnumber and Contract.Nproductcode = Tblproduct.NPRODUCTCODE and Contract.Exchange = Exgroup.Code and Contract.Egroup = Exgroup.Groupcode and substr(Contract, 1, 1) <> '-' Order By ContDate Enter Here lcParameter : Select Distinct Contract.Exchange as Exchange, Exgroup.Booktype as Booktype, Contract.Vallan as Settle, Contract.Contract as Contract, Contract.ContractDate as ContDate, Tblproduct.Cproductdescription as PRODDESCRIPTION, Tblproduct.NPRODUCTCODE as PRODUCT, Contract.Code as Clientcode From Exgroup, Contract, Tblproduct where Contract.Firmnumber = 'REN-000001' and Contract.Code = 'S46992 ' and Contract.Contractdate >= to_date('08/05/2020', 'dd/mm/yyyy') and Contract.Contractdate <= to_date('08/05/2020', 'dd/mm/yyyy') and Tblproduct.cFirmnumber = Contract.Firmnumber and Contract.Nproductcode = Tblproduct.NPRODUCTCODE and Contract.Exchange = Exgroup.Code and Contract.Egroup = Exgroup.Groupcode and substr(Contract, 1, 1) <> '-' Order By ContDate Enter Here lcParameter : Data Source=131.107.2.226/dig1920;User Id=CLLVL;Password=CLLVL;Enlist=false;Pooling=TRUE; lcParameter : Select Pscannedimage,CFilename From tblscannedimage tblscannedimage Where cFirmnumber='REN-000001' And cClientcode='S46992 ' And (cFilename='CN_20200508_S46992_NSE16284_0.zip' Or cFilename like 'CN_20200508_S46992_%MER%' Or cFilename like 'CN_S46992_20200508_NSE%' Or cFilename='CN_20200508_S46992_BSE16284_0.zip' Or cFilename like 'CN_20200508_S46992_%MER%' Or cFilename like 'CN_S46992_20200508_BSE%' ) lcParameter : 1 lcParameter : 1 FileName : D:\INETPUB\WWWROOT\WPF_ADDON\WHATSAPPAPI\\DOWNLOAD\CN_20200508_S46992_MER637248115185648475.PDF ZipFileDet : D:\INETPUB\WWWROOT\WPF_ADDON\WHATSAPPAPI\\DOWNLOAD\CN_20200508_S46992_MER.PDF lcParameter : Select Distinct Contract.Exchange as Exchange, Exgroup.Booktype as Booktype, Contract.Vallan as Settle, Contract.Contract as Contract, Contract.ContractDate as ContDate, Tblproduct.Cproductdescription as PRODDESCRIPTION, Tblproduct.NPRODUCTCODE as PRODUCT, Contract.Code as Clientcode From Exgroup, Contract, Tblproduct where Contract.Firmnumber = 'REN-000001' and Contract.Code = 'S4532' and Contract.Contractdate >= to_date('01/06/2020', 'dd/mm/yyyy') and Contract.Contractdate <= to_date('01/06/2020', 'dd/mm/yyyy') and Tblproduct.cFirmnumber = Contract.Firmnumber and Contract.Nproductcode = Tblproduct.NPRODUCTCODE and Contract.Exchange = Exgroup.Code and Contract.Egroup = Exgroup.Groupcode and substr(Contract, 1, 1) <> '-' Order By ContDate Enter Here lcParameter : Data Source=131.107.2.226/dig1920;User Id=CLLVL;Password=CLLVL;Enlist=false;Pooling=TRUE; lcParameter : Select Pscannedimage,CFilename From tblscannedimage tblscannedimage Where cFirmnumber='REN-000001' And cClientcode='S4532 ' And (cFilename='CN_20200601_S4532_BSE28091_0.zip' Or cFilename like 'CN_20200601_S4532_%MER%' Or cFilename like 'CN_S4532_20200601_BSE%' ) lcParameter : 1 lcParameter : 1 FileName : D:\INETPUB\WWWROOT\WPF_ADDON\WHATSAPPAPI\\DOWNLOAD\CN_20200601_S4532_MER637267692914571565.PDF ZipFileDet : D:\INETPUB\WWWROOT\WPF_ADDON\WHATSAPPAPI\\DOWNLOAD\CN_20200601_S4532_MER.PDF lcParameter : Select Distinct Contract.Exchange as Exchange, Exgroup.Booktype as Booktype, Contract.Vallan as Settle, Contract.Contract as Contract, Contract.ContractDate as ContDate, Tblproduct.Cproductdescription as PRODDESCRIPTION, Tblproduct.NPRODUCTCODE as PRODUCT, Contract.Code as Clientcode From Exgroup, Contract, Tblproduct where Contract.Firmnumber = 'REN-000001' and Contract.Code = 'B43007' and Contract.Contractdate >= to_date('02/06/2020', 'dd/mm/yyyy') and Contract.Contractdate <= to_date('02/06/2020', 'dd/mm/yyyy') and Tblproduct.cFirmnumber = Contract.Firmnumber and Contract.Nproductcode = Tblproduct.NPRODUCTCODE and Contract.Exchange = Exgroup.Code and Contract.Egroup = Exgroup.Groupcode and substr(Contract, 1, 1) <> '-' Order By ContDate Enter Here lcParameter : Select Distinct Contract.Exchange as Exchange, Exgroup.Booktype as Booktype, Contract.Vallan as Settle, Contract.Contract as Contract, Contract.ContractDate as ContDate, Tblproduct.Cproductdescription as PRODDESCRIPTION, Tblproduct.NPRODUCTCODE as PRODUCT, Contract.Code as Clientcode From Exgroup, Contract, Tblproduct where Contract.Firmnumber = 'REN-000001' and Contract.Code = 'B43037 ' and Contract.Contractdate >= to_date('02/06/2020', 'dd/mm/yyyy') and Contract.Contractdate <= to_date('02/06/2020', 'dd/mm/yyyy') and Tblproduct.cFirmnumber = Contract.Firmnumber and Contract.Nproductcode = Tblproduct.NPRODUCTCODE and Contract.Exchange = Exgroup.Code and Contract.Egroup = Exgroup.Groupcode and substr(Contract, 1, 1) <> '-' Order By ContDate Enter Here lcParameter : Data Source=131.107.2.226/dig1920;User Id=CLLVL;Password=CLLVL;Enlist=false;Pooling=TRUE; lcParameter : Select Pscannedimage,CFilename From tblscannedimage tblscannedimage Where cFirmnumber='REN-000001' And cClientcode='B43037 ' And (cFilename='CN_20200602_B43037_BSE28594_0.zip' Or cFilename like 'CN_20200602_B43037_%MER%' Or cFilename like 'CN_B43037_20200602_BSE%' ) lcParameter : 1 lcParameter : 1 FileName : D:\INETPUB\WWWROOT\WPF_ADDON\WHATSAPPAPI\\DOWNLOAD\CN_20200602_B43037_MER637268781968341878.PDF ZipFileDet : D:\INETPUB\WWWROOT\WPF_ADDON\WHATSAPPAPI\\DOWNLOAD\CN_20200602_B43037_MER.PDF lcParameter : Select Distinct Contract.Exchange as Exchange, Exgroup.Booktype as Booktype, Contract.Vallan as Settle, Contract.Contract as Contract, Contract.ContractDate as ContDate, Tblproduct.Cproductdescription as PRODDESCRIPTION, Tblproduct.NPRODUCTCODE as PRODUCT, Contract.Code as Clientcode From Exgroup, Contract, Tblproduct where Contract.Firmnumber = 'REN-000001' and Contract.Code = 'B43037 ' and Contract.Contractdate >= to_date('02/06/2020', 'dd/mm/yyyy') and Contract.Contractdate <= to_date('02/06/2020', 'dd/mm/yyyy') and Tblproduct.cFirmnumber = Contract.Firmnumber and Contract.Nproductcode = Tblproduct.NPRODUCTCODE and Contract.Exchange = Exgroup.Code and Contract.Egroup = Exgroup.Groupcode and substr(Contract, 1, 1) <> '-' Order By ContDate Enter Here lcParameter : Data Source=131.107.2.226/dig1920;User Id=CLLVL;Password=CLLVL;Enlist=false;Pooling=TRUE; lcParameter : Select Pscannedimage,CFilename From tblscannedimage tblscannedimage Where cFirmnumber='REN-000001' And cClientcode='B43037 ' And (cFilename='CN_20200602_B43037_BSE28594_0.zip' Or cFilename like 'CN_20200602_B43037_%MER%' Or cFilename like 'CN_B43037_20200602_BSE%' ) lcParameter : 1 lcParameter : 1 FileName : D:\INETPUB\WWWROOT\WPF_ADDON\WHATSAPPAPI\\DOWNLOAD\CN_20200602_B43037_MER637268785230668472.PDF ZipFileDet : D:\INETPUB\WWWROOT\WPF_ADDON\WHATSAPPAPI\\DOWNLOAD\CN_20200602_B43037_MER.PDF lcParameter : Select Distinct Contract.Exchange as Exchange, Exgroup.Booktype as Booktype, Contract.Vallan as Settle, Contract.Contract as Contract, Contract.ContractDate as ContDate, Tblproduct.Cproductdescription as PRODDESCRIPTION, Tblproduct.NPRODUCTCODE as PRODUCT, Contract.Code as Clientcode From Exgroup, Contract, Tblproduct where Contract.Firmnumber = 'REN-000001' and Contract.Code = 'B24506' and Contract.Contractdate >= to_date('28/05/2020', 'dd/mm/yyyy') and Contract.Contractdate <= to_date('28/05/2020', 'dd/mm/yyyy') and Tblproduct.cFirmnumber = Contract.Firmnumber and Contract.Nproductcode = Tblproduct.NPRODUCTCODE and Contract.Exchange = Exgroup.Code and Contract.Egroup = Exgroup.Groupcode and substr(Contract, 1, 1) <> '-' Order By ContDate Enter Here lcParameter : Data Source=131.107.2.226/dig1920;User Id=CLLVL;Password=CLLVL;Enlist=false;Pooling=TRUE; lcParameter : Select Pscannedimage,CFilename From tblscannedimage tblscannedimage Where cFirmnumber='REN-000001' And cClientcode='B24506 ' And (cFilename='CN_20200528_B24506_BSE25799_0.zip' Or cFilename like 'CN_20200528_B24506_%MER%' Or cFilename like 'CN_B24506_20200528_BSE%' ) lcParameter : 1 lcParameter : 1 FileName : D:\INETPUB\WWWROOT\WPF_ADDON\WHATSAPPAPI\\DOWNLOAD\CN_20200528_B24506_MER637268934653084946.PDF ZipFileDet : D:\INETPUB\WWWROOT\WPF_ADDON\WHATSAPPAPI\\DOWNLOAD\CN_20200528_B24506_MER.PDF