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 , ldfibs.ctermcode as cTermCode From Exgroup, Contract, Tblproduct , ldfibs where Contract.Firmnumber = 'REN-000001' and Contract.Code = 'B08010' and Contract.Contractdate >= to_date('06/08/2019', 'dd/mm/yyyy') and Contract.Contractdate <= to_date('06/08/2019', 'dd/mm/yyyy') and contract.code = ldfibs.oowncode and contract.Firmnumber = ldfibs.firmnumber 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 Select Pscannedimage,CFilename From tblscannedimage tblscannedimage Where cFirmnumber='REN-000001' And cClientcode='B08010 ' And (cFilename='CN_20190806_B08010_BSE59040_0.zip' Or cFilename like 'CN_20190806_B08010_%MER%' Or cFilename like 'CN_B08010_20190806_BSE%' Or cFilename like 'CN_20190806_B08010_%MER%' ) 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 , ldfibs.ctermcode as cTermCode From Exgroup, Contract, Tblproduct , ldfibs where Contract.Firmnumber = 'REN-000001' and Contract.Code = 'B08010' and Contract.Contractdate >= to_date('04/01/2021', 'dd/mm/yyyy') and Contract.Contractdate <= to_date('04/01/2021', 'dd/mm/yyyy') and contract.code = ldfibs.oowncode and contract.Firmnumber = ldfibs.firmnumber 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 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 , ldfibs.ctermcode as cTermCode From Exgroup, Contract, Tblproduct , ldfibs where Contract.Firmnumber = 'REN-000001' and Contract.Code = 'S3653' and Contract.Contractdate >= to_date('12/01/2021', 'dd/mm/yyyy') and Contract.Contractdate <= to_date('12/01/2021', 'dd/mm/yyyy') and contract.code = ldfibs.oowncode and contract.Firmnumber = ldfibs.firmnumber 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 Select Pscannedimage,CFilename From tblscannedimage tblscannedimage Where cFirmnumber='REN-000001' And cClientcode='S3653 ' And (cFilename='CN_20210112_S3653_BSE175687_0.zip' Or cFilename like 'CN_20210112_S3653_%MER%' Or cFilename like 'CN_S3653_20210112_BSE%' Or cFilename like 'CN_20210112_S3653_%MER%' ) 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 , ldfibs.ctermcode as cTermCode From Exgroup, Contract, Tblproduct , ldfibs where Contract.Firmnumber = 'REN-000001' and Contract.Code = 'S3653 ' and Contract.Contractdate >= to_date('12/01/2021', 'dd/mm/yyyy') and Contract.Contractdate <= to_date('12/01/2021', 'dd/mm/yyyy') and contract.code = ldfibs.oowncode and contract.Firmnumber = ldfibs.firmnumber 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 Select Pscannedimage,CFilename From tblscannedimage tblscannedimage Where cFirmnumber='REN-000001' And cClientcode='S3653 ' And (cFilename='CN_20210112_S3653_BSE175687_0.zip' Or cFilename like 'CN_20210112_S3653_%MER%' Or cFilename like 'CN_S3653_20210112_BSE%' Or cFilename like 'CN_20210112_S3653_%MER%' ) 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 , ldfibs.ctermcode as cTermCode From Exgroup, Contract, Tblproduct , ldfibs where Contract.Firmnumber = 'REN-000001' and Contract.Code = 'S3653 ' and Contract.Contractdate >= to_date('11/01/2021', 'dd/mm/yyyy') and Contract.Contractdate <= to_date('11/01/2021', 'dd/mm/yyyy') and contract.code = ldfibs.oowncode and contract.Firmnumber = ldfibs.firmnumber 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 Select Pscannedimage,CFilename From tblscannedimage tblscannedimage Where cFirmnumber='REN-000001' And cClientcode='S3653 ' And (cFilename='CN_20210111_S3653_BSE174500_0.zip' Or cFilename like 'CN_20210111_S3653_%MER%' Or cFilename like 'CN_S3653_20210111_BSE%' Or cFilename like 'CN_20210111_S3653_%MER%' ) 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 , ldfibs.ctermcode as cTermCode From Exgroup, Contract, Tblproduct , ldfibs where Contract.Firmnumber = 'REN-000001' and Contract.Code = 'S4532' and Contract.Contractdate >= to_date('23/02/2021', 'dd/mm/yyyy') and Contract.Contractdate <= to_date('23/02/2021', 'dd/mm/yyyy') and contract.code = ldfibs.oowncode and contract.Firmnumber = ldfibs.firmnumber 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 Select Pscannedimage,CFilename From tblscannedimage tblscannedimage Where cFirmnumber='REN-000001' And cClientcode='S4532 ' And (cFilename='CN_20210223_S4532_BSE207815_0.zip' Or cFilename like 'CN_20210223_S4532_%MER%' Or cFilename like 'CN_S4532_20210223_BSE%' Or cFilename like 'CN_20210223_S4532_%MER%' or cFilename='CN_20210223_S4532_NSE207815_0.zip' Or cFilename like 'CN_20210223_S4532_%MER%' Or cFilename like 'CN_S4532_20210223_NSE%' Or cFilename like 'CN_20210223_S4532_%MER%' ) 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 , ldfibs.ctermcode as cTermCode From Exgroup, Contract, Tblproduct , ldfibs where Contract.Firmnumber = 'REN-000001' and Contract.Code = 'S1529 ' and Contract.Contractdate >= to_date('14/05/2021', 'dd/mm/yyyy') and Contract.Contractdate <= to_date('14/05/2021', 'dd/mm/yyyy') and contract.code = ldfibs.oowncode and contract.Firmnumber = ldfibs.firmnumber 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 Select Pscannedimage,CFilename From tblscannedimage tblscannedimage Where cFirmnumber='REN-000001' And cClientcode='S1529 ' And (cFilename='CN_20210514_S1529_BSE31523_0.zip' Or cFilename like 'CN_20210514_S1529_%MER%' Or cFilename like 'CN_S1529_20210514_BSE%' Or cFilename like 'CN_20210514_S1529_%MER%' or cFilename='CN_20210514_S1529_NSEF31523_0.zip' Or cFilename like 'CN_20210514_S1529_%MER%' Or cFilename like 'CN_S1529_20210514_NSEF%' Or cFilename like 'CN_20210514_S1529_%MER%' or cFilename='CN_20210514_S1529_NSE31523_0.zip' Or cFilename like 'CN_20210514_S1529_%MER%' Or cFilename like 'CN_S1529_20210514_NSE%' Or cFilename like 'CN_20210514_S1529_%MER%' ) 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 , ldfibs.ctermcode as cTermCode From Exgroup, Contract, Tblproduct , ldfibs where Contract.Firmnumber = 'REN-000001' and Contract.Code = 'S1529 ' and Contract.Contractdate >= to_date('12/05/2021', 'dd/mm/yyyy') and Contract.Contractdate <= to_date('12/05/2021', 'dd/mm/yyyy') and contract.code = ldfibs.oowncode and contract.Firmnumber = ldfibs.firmnumber 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 Select Pscannedimage,CFilename From tblscannedimage tblscannedimage Where cFirmnumber='REN-000001' And cClientcode='S1529 ' And (cFilename='CN_20210512_S1529_NSE30209_0.zip' Or cFilename like 'CN_20210512_S1529_%MER%' Or cFilename like 'CN_S1529_20210512_NSE%' Or cFilename like 'CN_20210512_S1529_%MER%' or cFilename='CN_20210512_S1529_NSEF30209_0.zip' Or cFilename like 'CN_20210512_S1529_%MER%' Or cFilename like 'CN_S1529_20210512_NSEF%' Or cFilename like 'CN_20210512_S1529_%MER%' or cFilename='CN_20210512_S1529_BSE30209_0.zip' Or cFilename like 'CN_20210512_S1529_%MER%' Or cFilename like 'CN_S1529_20210512_BSE%' Or cFilename like 'CN_20210512_S1529_%MER%' ) 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 , ldfibs.ctermcode as cTermCode From Exgroup, Contract, Tblproduct , ldfibs where Contract.Firmnumber = 'REN-000001' and Contract.Code = 'S1529 ' and Contract.Contractdate >= to_date('14/05/2021', 'dd/mm/yyyy') and Contract.Contractdate <= to_date('14/05/2021', 'dd/mm/yyyy') and contract.code = ldfibs.oowncode and contract.Firmnumber = ldfibs.firmnumber 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 Select Pscannedimage,CFilename From tblscannedimage tblscannedimage Where cFirmnumber='REN-000001' And cClientcode='S1529 ' And (cFilename='CN_20210514_S1529_BSE31523_0.zip' Or cFilename like 'CN_20210514_S1529_%MER%' Or cFilename like 'CN_S1529_20210514_BSE%' Or cFilename like 'CN_20210514_S1529_%MER%' or cFilename='CN_20210514_S1529_NSEF31523_0.zip' Or cFilename like 'CN_20210514_S1529_%MER%' Or cFilename like 'CN_S1529_20210514_NSEF%' Or cFilename like 'CN_20210514_S1529_%MER%' or cFilename='CN_20210514_S1529_NSE31523_0.zip' Or cFilename like 'CN_20210514_S1529_%MER%' Or cFilename like 'CN_S1529_20210514_NSE%' Or cFilename like 'CN_20210514_S1529_%MER%' ) 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 , ldfibs.ctermcode as cTermCode From Exgroup, Contract, Tblproduct , ldfibs where Contract.Firmnumber = 'REN-000001' and Contract.Code = 'S1529' and Contract.Contractdate >= to_date('12/05/2021', 'dd/mm/yyyy') and Contract.Contractdate <= to_date('12/05/2021', 'dd/mm/yyyy') and contract.code = ldfibs.oowncode and contract.Firmnumber = ldfibs.firmnumber 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 Select Pscannedimage,CFilename From tblscannedimage tblscannedimage Where cFirmnumber='REN-000001' And cClientcode='S1529 ' And (cFilename='CN_20210512_S1529_NSE30209_0.zip' Or cFilename like 'CN_20210512_S1529_%MER%' Or cFilename like 'CN_S1529_20210512_NSE%' Or cFilename like 'CN_20210512_S1529_%MER%' or cFilename='CN_20210512_S1529_NSEF30209_0.zip' Or cFilename like 'CN_20210512_S1529_%MER%' Or cFilename like 'CN_S1529_20210512_NSEF%' Or cFilename like 'CN_20210512_S1529_%MER%' or cFilename='CN_20210512_S1529_BSE30209_0.zip' Or cFilename like 'CN_20210512_S1529_%MER%' Or cFilename like 'CN_S1529_20210512_BSE%' Or cFilename like 'CN_20210512_S1529_%MER%' ) 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 , ldfibs.ctermcode as cTermCode From Exgroup, Contract, Tblproduct , ldfibs where Contract.Firmnumber = 'REN-000001' and Contract.Code = 'S1529' and Contract.Contractdate >= to_date('12/05/2021', 'dd/mm/yyyy') and Contract.Contractdate <= to_date('12/05/2021', 'dd/mm/yyyy') and contract.code = ldfibs.oowncode and contract.Firmnumber = ldfibs.firmnumber 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 Select Pscannedimage,CFilename From tblscannedimage tblscannedimage Where cFirmnumber='REN-000001' And cClientcode='S1529 ' And (cFilename='CN_20210512_S1529_NSE30209_0.zip' Or cFilename like 'CN_20210512_S1529_%MER%' Or cFilename like 'CN_S1529_20210512_NSE%' Or cFilename like 'CN_20210512_S1529_%MER%' or cFilename='CN_20210512_S1529_NSEF30209_0.zip' Or cFilename like 'CN_20210512_S1529_%MER%' Or cFilename like 'CN_S1529_20210512_NSEF%' Or cFilename like 'CN_20210512_S1529_%MER%' or cFilename='CN_20210512_S1529_BSE30209_0.zip' Or cFilename like 'CN_20210512_S1529_%MER%' Or cFilename like 'CN_S1529_20210512_BSE%' Or cFilename like 'CN_20210512_S1529_%MER%' ) 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 , ldfibs.ctermcode as cTermCode From Exgroup, Contract, Tblproduct , ldfibs where Contract.Firmnumber = 'REN-000001' and Contract.Code = 'S1529' and Contract.Contractdate >= to_date('12/05/2021', 'dd/mm/yyyy') and Contract.Contractdate <= to_date('12/05/2021', 'dd/mm/yyyy') and contract.code = ldfibs.oowncode and contract.Firmnumber = ldfibs.firmnumber 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 Select Pscannedimage,CFilename From tblscannedimage tblscannedimage Where cFirmnumber='REN-000001' And cClientcode='S1529 ' And (cFilename='CN_20210512_S1529_NSE30209_0.zip' Or cFilename like 'CN_20210512_S1529_%MER%' Or cFilename like 'CN_S1529_20210512_NSE%' Or cFilename like 'CN_20210512_S1529_%MER%' or cFilename='CN_20210512_S1529_NSEF30209_0.zip' Or cFilename like 'CN_20210512_S1529_%MER%' Or cFilename like 'CN_S1529_20210512_NSEF%' Or cFilename like 'CN_20210512_S1529_%MER%' or cFilename='CN_20210512_S1529_BSE30209_0.zip' Or cFilename like 'CN_20210512_S1529_%MER%' Or cFilename like 'CN_S1529_20210512_BSE%' Or cFilename like 'CN_20210512_S1529_%MER%' ) 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 , ldfibs.ctermcode as cTermCode From Exgroup, Contract, Tblproduct , ldfibs where Contract.Firmnumber = 'REN-000001' and Contract.Code = 'S1529' and Contract.Contractdate >= to_date('12/05/2021', 'dd/mm/yyyy') and Contract.Contractdate <= to_date('12/05/2021', 'dd/mm/yyyy') and contract.code = ldfibs.oowncode and contract.Firmnumber = ldfibs.firmnumber 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 Select Pscannedimage,CFilename From tblscannedimage tblscannedimage Where cFirmnumber='REN-000001' And cClientcode='S1529 ' And (cFilename='CN_20210512_S1529_NSE30209_0.zip' Or cFilename like 'CN_20210512_S1529_%MER%' Or cFilename like 'CN_S1529_20210512_NSE%' Or cFilename like 'CN_20210512_S1529_%MER%' or cFilename='CN_20210512_S1529_NSEF30209_0.zip' Or cFilename like 'CN_20210512_S1529_%MER%' Or cFilename like 'CN_S1529_20210512_NSEF%' Or cFilename like 'CN_20210512_S1529_%MER%' or cFilename='CN_20210512_S1529_BSE30209_0.zip' Or cFilename like 'CN_20210512_S1529_%MER%' Or cFilename like 'CN_S1529_20210512_BSE%' Or cFilename like 'CN_20210512_S1529_%MER%' ) 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 , ldfibs.ctermcode as cTermCode From Exgroup, Contract, Tblproduct , ldfibs where Contract.Firmnumber = 'REN-000001' and Contract.Code = 'S1529 ' and Contract.Contractdate >= to_date('14/05/2021', 'dd/mm/yyyy') and Contract.Contractdate <= to_date('14/05/2021', 'dd/mm/yyyy') and contract.code = ldfibs.oowncode and contract.Firmnumber = ldfibs.firmnumber 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 Select Pscannedimage,CFilename From tblscannedimage tblscannedimage Where cFirmnumber='REN-000001' And cClientcode='S1529 ' And (cFilename='CN_20210514_S1529_BSE31523_0.zip' Or cFilename like 'CN_20210514_S1529_%MER%' Or cFilename like 'CN_S1529_20210514_BSE%' Or cFilename like 'CN_20210514_S1529_%MER%' or cFilename='CN_20210514_S1529_NSEF31523_0.zip' Or cFilename like 'CN_20210514_S1529_%MER%' Or cFilename like 'CN_S1529_20210514_NSEF%' Or cFilename like 'CN_20210514_S1529_%MER%' or cFilename='CN_20210514_S1529_NSE31523_0.zip' Or cFilename like 'CN_20210514_S1529_%MER%' Or cFilename like 'CN_S1529_20210514_NSE%' Or cFilename like 'CN_20210514_S1529_%MER%' )