<?xml version="1.0" standalone="yes"?> <NewDataSet> <xs:schema id="NewDataSet" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop"> <xs:element name="NewDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true"> <xs:complexType> <xs:choice minOccurs="0" maxOccurs="unbounded"> <xs:element name="ClientList" msprop:BaseTable.0="LDFIBS" msprop:BaseTable.1="ACCOUNTADDRESSDETAIL"> <xs:complexType> <xs:sequence> <xs:element name="ClientCode" msprop:BaseColumn="OOWNCODE" msprop:OraDbType="104" type="xs:string" minOccurs="0" /> <xs:element name="CBRANCHCODE" msprop:BaseColumn="BRCODE" msprop:OraDbType="104" type="xs:string" minOccurs="0" /> <xs:element name="ClientName" msprop:OraDbType="126" type="xs:string" minOccurs="0" /> <xs:element name="CFAMILYCODE" msprop:BaseColumn="FAMILY" msprop:OraDbType="104" type="xs:string" minOccurs="0" /> <xs:element name="CSUBGROUP" msprop:BaseColumn="SUBCODE" msprop:OraDbType="104" type="xs:string" minOccurs="0" /> <xs:element name="TermCode" msprop:BaseColumn="CTERMCODE" msprop:OraDbType="104" type="xs:string" minOccurs="0" /> <xs:element name="CSUBFAMILY" msprop:BaseColumn="SUBFAMILY" msprop:OraDbType="104" type="xs:string" minOccurs="0" /> <xs:element name="CDEALERCODE" msprop:BaseColumn="DEALERCODE" msprop:OraDbType="104" type="xs:string" minOccurs="0" /> <xs:element name="CTEAMLEADER" msprop:BaseColumn="CTEAMLEADER" msprop:OraDbType="104" type="xs:string" minOccurs="0" /> <xs:element name="CINTRODUCERCODE" msprop:BaseColumn="CINTRODUCERCODE" msprop:OraDbType="104" type="xs:string" minOccurs="0" /> <xs:element name="CRELATIONSHIPCODE" msprop:BaseColumn="CRELATIONSHIPCODE" msprop:OraDbType="104" type="xs:string" minOccurs="0" /> <xs:element name="Address1" msprop:OraDbType="126" type="xs:string" minOccurs="0" /> <xs:element name="Address2" msprop:OraDbType="126" type="xs:string" minOccurs="0" /> <xs:element name="Address3" msprop:OraDbType="126" type="xs:string" minOccurs="0" /> <xs:element name="CSTATE" msprop:OraDbType="126" type="xs:string" minOccurs="0" /> <xs:element name="CITY" msprop:OraDbType="126" type="xs:string" minOccurs="0" /> <xs:element name="PINCODE" msprop:BaseColumn="PINCODE" msprop:OraDbType="112" type="xs:int" minOccurs="0" /> <xs:element name="COUNTRY" msprop:OraDbType="126" type="xs:string" minOccurs="0" /> <xs:element name="CorrespondenceAddress1" msprop:OraDbType="126" type="xs:string" minOccurs="0" /> <xs:element name="CorrespondenceAddress2" msprop:OraDbType="126" type="xs:string" minOccurs="0" /> <xs:element name="CorrespondenceAddress3" msprop:OraDbType="126" type="xs:string" minOccurs="0" /> <xs:element name="CorrespondenceCity" msprop:OraDbType="126" type="xs:string" minOccurs="0" /> <xs:element name="CorrespondencePincode" msprop:BaseColumn="NCORRPINCODE" msprop:OraDbType="112" type="xs:int" minOccurs="0" /> <xs:element name="CorrespondenceCountry" msprop:OraDbType="126" type="xs:string" minOccurs="0" /> <xs:element name="CorrespondenceState" msprop:OraDbType="126" type="xs:string" minOccurs="0" /> <xs:element name="TEL1" msprop:OraDbType="126" type="xs:string" minOccurs="0" /> <xs:element name="TEL2" msprop:OraDbType="126" type="xs:string" minOccurs="0" /> <xs:element name="TEL3" msprop:OraDbType="126" type="xs:string" minOccurs="0" /> <xs:element name="MOBILE" msprop:OraDbType="126" type="xs:string" minOccurs="0" /> <xs:element name="FAX" msprop:OraDbType="126" type="xs:string" minOccurs="0" /> <xs:element name="CSTDNO" msprop:BaseColumn="CSTDNO" msprop:OraDbType="104" type="xs:string" minOccurs="0" /> <xs:element name="NISDNUMBER" msprop:BaseColumn="NISDNUMBER" msprop:OraDbType="113" type="xs:long" minOccurs="0" /> <xs:element name="CREFERREDBY" msprop:OraDbType="126" type="xs:string" minOccurs="0" /> <xs:element name="CPANGIR" msprop:BaseColumn="PANGIR" msprop:OraDbType="104" type="xs:string" minOccurs="0" /> <xs:element name="CPREFIX" msprop:BaseColumn="PREFIX" msprop:OraDbType="104" type="xs:string" minOccurs="0" /> <xs:element name="CONDELSTATUS" msprop:BaseColumn="CONDELSTATUS" msprop:OraDbType="104" type="xs:string" minOccurs="0" /> <xs:element name="BILDELSTATUS" msprop:BaseColumn="BILDELSTATUS" msprop:OraDbType="104" type="xs:string" minOccurs="0" /> <xs:element name="SHADELSTATUS" msprop:BaseColumn="SHADELSTATUS" msprop:OraDbType="104" type="xs:string" minOccurs="0" /> <xs:element name="SEBIREGNO" msprop:OraDbType="126" type="xs:string" minOccurs="0" /> <xs:element name="CMAPINID" msprop:OraDbType="126" type="xs:string" minOccurs="0" /> <xs:element name="CFIRSTNAME" msprop:OraDbType="126" type="xs:string" minOccurs="0" /> <xs:element name="CSECONDNAME" msprop:OraDbType="126" type="xs:string" minOccurs="0" /> <xs:element name="CLASTNAME" msprop:OraDbType="126" type="xs:string" minOccurs="0" /> <xs:element name="CREFERREDCODE1" msprop:OraDbType="126" type="xs:string" minOccurs="0" /> <xs:element name="CREFERREDCODE2" msprop:OraDbType="126" type="xs:string" minOccurs="0" /> <xs:element name="CREFERREDCODE3" msprop:OraDbType="126" type="xs:string" minOccurs="0" /> <xs:element name="CORAEFINCODE" msprop:BaseColumn="CORAEFINCODE" msprop:OraDbType="104" type="xs:string" minOccurs="0" /> <xs:element name="EMAIL" msprop:OraDbType="126" type="xs:string" minOccurs="0" /> </xs:sequence> </xs:complexType> </xs:element> <xs:element name="FinBal" msprop:BaseTable.0="TBLLEDGER"> <xs:complexType> <xs:sequence> <xs:element name="DTOFTRAN" msprop:OraDbType="106" msprop:BaseColumn="DDTOFTRAN" type="xs:dateTime" minOccurs="0" /> <xs:element name="VOUCHER" msprop:OraDbType="126" msprop:BaseColumn="CVOUCHER" type="xs:string" minOccurs="0" /> <xs:element name="DAMOUNT" msprop:OraDbType="107" type="xs:decimal" minOccurs="0" /> <xs:element name="CAMOUNT" msprop:OraDbType="107" type="xs:decimal" minOccurs="0" /> <xs:element name="NRUNNINGBALANCE" msprop:OraDbType="107" type="xs:decimal" minOccurs="0" /> <xs:element name="NDRRUNNING" msprop:OraDbType="107" type="xs:decimal" minOccurs="0" /> <xs:element name="NCRRUNNING" msprop:OraDbType="107" type="xs:decimal" minOccurs="0" /> <xs:element name="DESCRIPT" msprop:OraDbType="126" type="xs:string" minOccurs="0" /> <xs:element name="EXCHANGE" msprop:OraDbType="104" type="xs:string" minOccurs="0" /> <xs:element name="CBOOKTYPECODE" msprop:OraDbType="126" type="xs:string" minOccurs="0" /> <xs:element name="VALLAN" msprop:OraDbType="107" type="xs:decimal" minOccurs="0" /> <xs:element name="BOOKTYPE" msprop:OraDbType="126" type="xs:string" minOccurs="0" /> <xs:element name="DTRANSACTIONDATE" msprop:OraDbType="106" type="xs:dateTime" minOccurs="0" /> <xs:element name="SPECIAL" msprop:OraDbType="104" type="xs:string" minOccurs="0" /> <xs:element name="CHEQUE" msprop:OraDbType="126" type="xs:string" minOccurs="0" /> <xs:element name="BANKCODE" msprop:OraDbType="126" type="xs:string" minOccurs="0" /> <xs:element name="BANKRECO" msprop:OraDbType="107" type="xs:decimal" minOccurs="0" /> <xs:element name="OOWNCODE" msprop:OraDbType="104" type="xs:string" minOccurs="0" /> <xs:element name="NPRODUCTCODE" msprop:OraDbType="111" type="xs:short" minOccurs="0" /> <xs:element name="CBRANCHCODE" msprop:OraDbType="104" type="xs:string" minOccurs="0" /> <xs:element name="NENTRYCODE" msprop:OraDbType="107" type="xs:decimal" minOccurs="0" /> <xs:element name="CDRCR" msprop:OraDbType="126" type="xs:string" minOccurs="0" /> <xs:element name="NVCNUMBER" msprop:OraDbType="107" type="xs:decimal" minOccurs="0" /> <xs:element name="NDESCRIPTTYPE" msprop:OraDbType="107" type="xs:decimal" minOccurs="0" /> </xs:sequence> </xs:complexType> </xs:element> <xs:element name="ClientSegment"> <xs:complexType> <xs:sequence> <xs:element name="CCLIENTCODE" type="xs:string" minOccurs="0" /> <xs:element name="CEXCHANGE" type="xs:string" minOccurs="0" /> <xs:element name="CSEGMENT" type="xs:string" minOccurs="0" /> <xs:element name="CACTIVATION" type="xs:string" minOccurs="0" /> </xs:sequence> </xs:complexType> </xs:element> <xs:element name="COMPLIANCEOFFICER" msdata:CaseSensitive="False" msdata:Locale="en-GB"> <xs:complexType> <xs:sequence> <xs:element name="CFIRMCODE" msprop:OraDbType="104" msprop:BaseColumn="CFIRMCODE" type="xs:string" minOccurs="0" /> <xs:element name="CFIRMNAME" msprop:OraDbType="104" msprop:BaseColumn="CFIRMNAME" type="xs:string" minOccurs="0" /> <xs:element name="CUSERFIRMCODE" msprop:OraDbType="104" msprop:BaseColumn="CUSERFIRMCODE" type="xs:string" minOccurs="0" /> <xs:element name="CADDRESS1" msprop:OraDbType="104" msprop:BaseColumn="CADDRESS1" type="xs:string" minOccurs="0" /> <xs:element name="CADDRESS2" msprop:OraDbType="104" msprop:BaseColumn="CADDRESS2" type="xs:string" minOccurs="0" /> <xs:element name="CADDRESS3" msprop:OraDbType="104" msprop:BaseColumn="CADDRESS3" type="xs:string" minOccurs="0" /> <xs:element name="CBACKUPREMINDER" msprop:OraDbType="104" msprop:BaseColumn="CBACKUPREMINDER" type="xs:string" minOccurs="0" /> <xs:element name="CSTARTFINANCIALYEAR" msprop:OraDbType="104" msprop:BaseColumn="CSTARTFINANCIALYEAR" type="xs:string" minOccurs="0" /> <xs:element name="CENDFINANCIALYEAR" msprop:OraDbType="104" msprop:BaseColumn="CENDFINANCIALYEAR" type="xs:string" minOccurs="0" /> <xs:element name="CDATADRIVE" msprop:OraDbType="104" msprop:BaseColumn="CDATADRIVE" type="xs:string" minOccurs="0" /> <xs:element name="CDATADIRECTORY" msprop:OraDbType="104" msprop:BaseColumn="CDATADIRECTORY" type="xs:string" minOccurs="0" /> <xs:element name="CCONNECTION" msprop:OraDbType="104" msprop:BaseColumn="CCONNECTION" type="xs:string" minOccurs="0" /> <xs:element name="CDATASOURCENAME" msprop:OraDbType="104" msprop:BaseColumn="CDATASOURCENAME" type="xs:string" minOccurs="0" /> <xs:element name="CDATASTORE" msprop:OraDbType="104" msprop:BaseColumn="CDATASTORE" type="xs:string" minOccurs="0" /> <xs:element name="CSHORTNAME" msprop:OraDbType="104" msprop:BaseColumn="CSHORTNAME" type="xs:string" minOccurs="0" /> <xs:element name="CREGADDRESS1" msprop:OraDbType="104" msprop:BaseColumn="CREGADDRESS1" type="xs:string" minOccurs="0" /> <xs:element name="CREGADDRESS2" msprop:OraDbType="104" msprop:BaseColumn="CREGADDRESS2" type="xs:string" minOccurs="0" /> <xs:element name="CREGADDRESS3" msprop:OraDbType="104" msprop:BaseColumn="CREGADDRESS3" type="xs:string" minOccurs="0" /> <xs:element name="NCOMMODITY" msprop:OraDbType="111" msprop:BaseColumn="NCOMMODITY" type="xs:short" minOccurs="0" /> <xs:element name="CEMAILID" msprop:OraDbType="104" msprop:BaseColumn="CEMAILID" type="xs:string" minOccurs="0" /> <xs:element name="CFAXNUMBER" msprop:OraDbType="104" msprop:BaseColumn="CFAXNUMBER" type="xs:string" minOccurs="0" /> <xs:element name="CTELEPHONENUMBER" msprop:OraDbType="104" msprop:BaseColumn="CTELEPHONENUMBER" type="xs:string" minOccurs="0" /> <xs:element name="NIGNORERISKTRADE" msprop:OraDbType="111" msprop:BaseColumn="NIGNORERISKTRADE" type="xs:short" minOccurs="0" /> <xs:element name="NIGNORERISKFINANCIAL" msprop:OraDbType="111" msprop:BaseColumn="NIGNORERISKFINANCIAL" type="xs:short" minOccurs="0" /> <xs:element name="NIGNORERISKBENEFICIARY" msprop:OraDbType="111" msprop:BaseColumn="NIGNORERISKBENEFICIARY" type="xs:short" minOccurs="0" /> <xs:element name="NIGNOREMASTERPICKUP" msprop:OraDbType="111" msprop:BaseColumn="NIGNOREMASTERPICKUP" type="xs:short" minOccurs="0" /> <xs:element name="CCOMPLIANCEOFFICER" msprop:OraDbType="104" msprop:BaseColumn="CCOMPLIANCEOFFICER" type="xs:string" minOccurs="0" /> <xs:element name="CCOMPLIANCEEMAILID" msprop:OraDbType="104" msprop:BaseColumn="CCOMPLIANCEEMAILID" type="xs:string" minOccurs="0" /> <xs:element name="CCOMPLIANCECONTACT" msprop:OraDbType="104" msprop:BaseColumn="CCOMPLIANCECONTACT" type="xs:string" minOccurs="0" /> <xs:element name="NNBFCFIRM" msprop:OraDbType="111" msprop:BaseColumn="NNBFCFIRM" type="xs:short" minOccurs="0" /> <xs:element name="CTECHTELNUMBER" msprop:OraDbType="104" msprop:BaseColumn="CTECHTELNUMBER" type="xs:string" minOccurs="0" /> <xs:element name="CTECHEMAILID" msprop:OraDbType="104" msprop:BaseColumn="CTECHEMAILID" type="xs:string" minOccurs="0" /> <xs:element name="CCUSTTELNUMBER" msprop:OraDbType="104" msprop:BaseColumn="CCUSTTELNUMBER" type="xs:string" minOccurs="0" /> <xs:element name="CCUSTEMAILID" msprop:OraDbType="104" msprop:BaseColumn="CCUSTEMAILID" type="xs:string" minOccurs="0" /> <xs:element name="NCLIENTLEVEL" msprop:OraDbType="111" msprop:BaseColumn="NCLIENTLEVEL" type="xs:short" minOccurs="0" /> <xs:element name="NIGNORETERMINALPICKUP" msprop:OraDbType="111" msprop:BaseColumn="NIGNORETERMINALPICKUP" type="xs:short" minOccurs="0" /> </xs:sequence> </xs:complexType> </xs:element> <xs:element name="COMFIRMATION" msprop:BaseTable.0="TBLSETUPPARAMETERS"> <xs:complexType> <xs:sequence> <xs:element name="FIRM_CODE" msprop:BaseColumn="CFIRMNUMBER" msprop:OraDbType="104" type="xs:string" minOccurs="0" /> <xs:element name="BACKUPDRIVE" msprop:BaseColumn="CBACKUPDRIVE" msprop:OraDbType="104" type="xs:string" minOccurs="0" /> <xs:element name="RUNDATE" msprop:BaseColumn="CRUNDATE" msprop:OraDbType="104" type="xs:string" minOccurs="0" /> <xs:element name="RUNTIME" msprop:BaseColumn="CRUNTIME" msprop:OraDbType="104" type="xs:string" minOccurs="0" /> <xs:element name="HELPON" msprop:BaseColumn="CHELPON" msprop:OraDbType="104" type="xs:string" minOccurs="0" /> <xs:element name="CITY" msprop:BaseColumn="CCITY" msprop:OraDbType="104" type="xs:string" minOccurs="0" /> <xs:element name="JURISDICTION" msprop:BaseColumn="CJURISDICTION" msprop:OraDbType="104" type="xs:string" minOccurs="0" /> <xs:element name="CONTBILLHEAD" msprop:BaseColumn="CCONTRACTBILLHEADER" msprop:OraDbType="104" type="xs:string" minOccurs="0" /> <xs:element name="TRADETIMEPRINT" msprop:BaseColumn="CTRADETIMEPRINT" msprop:OraDbType="104" type="xs:string" minOccurs="0" /> <xs:element name="FINSTARTDATE" msprop:BaseColumn="DFINANCIALSTARTDATE" msprop:OraDbType="106" type="xs:dateTime" minOccurs="0" /> <xs:element name="FINENDDATE" msprop:BaseColumn="DFINANCIALENDDATE" msprop:OraDbType="106" type="xs:dateTime" minOccurs="0" /> <xs:element name="PRT80132" msprop:BaseColumn="CPRT80132" msprop:OraDbType="104" type="xs:string" minOccurs="0" /> <xs:element name="LDSTARTDATE" msprop:BaseColumn="DLDSTARTDATE" msprop:OraDbType="106" type="xs:dateTime" minOccurs="0" /> <xs:element name="LDENDDATE" msprop:BaseColumn="DLDENDDATE" msprop:OraDbType="106" type="xs:dateTime" minOccurs="0" /> <xs:element name="DOSPRINTOUT" msprop:BaseColumn="CDOSPRINTOUT" msprop:OraDbType="104" type="xs:string" minOccurs="0" /> <xs:element name="FAYEAR" msprop:BaseColumn="CFAYEAR" msprop:OraDbType="104" type="xs:string" minOccurs="0" /> <xs:element name="PANGIR" msprop:BaseColumn="CPANGIR" msprop:OraDbType="104" type="xs:string" minOccurs="0" /> <xs:element name="LLASTPAGE" msprop:BaseColumn="CLASTPAGE" msprop:OraDbType="104" type="xs:string" minOccurs="0" /> <xs:element name="CFINSTATEMENT1" msprop:OraDbType="126" type="xs:string" minOccurs="0" /> <xs:element name="CFINSTATEMENT2" msprop:OraDbType="126" type="xs:string" minOccurs="0" /> <xs:element name="CFINSTATEMENT3" msprop:OraDbType="126" type="xs:string" minOccurs="0" /> <xs:element name="CFINSTATEMENT4" msprop:OraDbType="126" type="xs:string" minOccurs="0" /> <xs:element name="CFINSTATEMENT5" msprop:OraDbType="126" type="xs:string" minOccurs="0" /> <xs:element name="LSPECIAL" msprop:BaseColumn="CSPECIAL" msprop:OraDbType="104" type="xs:string" minOccurs="0" /> <xs:element name="CASPEMAIL" msprop:BaseColumn="CASPEMAIL" msprop:OraDbType="104" type="xs:string" minOccurs="0" /> <xs:element name="LNEWVERSION" msprop:BaseColumn="CNEWVERSION" msprop:OraDbType="104" type="xs:string" minOccurs="0" /> <xs:element name="CFINSTATEMENT6" msprop:OraDbType="126" type="xs:string" minOccurs="0" /> <xs:element name="CFINSTATEMENT7" msprop:OraDbType="126" type="xs:string" minOccurs="0" /> <xs:element name="CFINSTATEMENT8" msprop:OraDbType="126" type="xs:string" minOccurs="0" /> <xs:element name="LDMARKSAME" msprop:BaseColumn="CDMARKSAME" msprop:OraDbType="104" type="xs:string" minOccurs="0" /> <xs:element name="LROUNDOFFNETAMOUNT" msprop:BaseColumn="CROUNDOFFNETAMOUNT" msprop:OraDbType="104" type="xs:string" minOccurs="0" /> <xs:element name="LTURNOVERBROKJV" msprop:BaseColumn="CTURNOVERBROKJV" msprop:OraDbType="104" type="xs:string" minOccurs="0" /> <xs:element name="LEXCLUDEAUCTION" msprop:BaseColumn="CEXCLUDEAUCTION" msprop:OraDbType="104" type="xs:string" minOccurs="0" /> <xs:element name="LCONTRACTGENERATIONATEND" msprop:BaseColumn="CCONTRACTGENERATIONATEND" msprop:OraDbType="104" type="xs:string" minOccurs="0" /> <xs:element name="CHDFCEPAY" msprop:BaseColumn="CHDFCEPAY" msprop:OraDbType="104" type="xs:string" minOccurs="0" /> <xs:element name="LIGNOREPRODR" msprop:BaseColumn="CIGNOREPRODR" msprop:OraDbType="104" type="xs:string" minOccurs="0" /> <xs:element name="LMARGINACROSSCOMPANIES" msprop:BaseColumn="CMARGINACROSSCOMPANIES" msprop:OraDbType="104" type="xs:string" minOccurs="0" /> <xs:element name="LHYPERTHREADEDMODE" msprop:BaseColumn="CHYPERTHREADEDMODE" msprop:OraDbType="104" type="xs:string" minOccurs="0" /> <xs:element name="CWEBSITE" msprop:OraDbType="126" type="xs:string" minOccurs="0" /> <xs:element name="LALLOWSPECIALJV" msprop:BaseColumn="CALLOWSPECIALJV" msprop:OraDbType="104" type="xs:string" minOccurs="0" /> <xs:element name="LPOASTOCKACROSSCOMPANIES" msprop:BaseColumn="CPOASTOCKACROSSCOMPANIES" msprop:OraDbType="104" type="xs:string" minOccurs="0" /> <xs:element name="LPARTNERSHIPFIRM" msprop:BaseColumn="CPARTNERSHIPFIRM" msprop:OraDbType="104" type="xs:string" minOccurs="0" /> <xs:element name="LLDCDSLBACKOFFICE" msprop:BaseColumn="CLDCDSLBACKOFFICE" msprop:OraDbType="104" type="xs:string" minOccurs="0" /> <xs:element name="LLDNSDLBACKOFFICE" msprop:BaseColumn="CLDNSDLBACKOFFICE" msprop:OraDbType="104" type="xs:string" minOccurs="0" /> <xs:element name="LBILLABOVE10000" msprop:BaseColumn="CBILLABOVE10000" msprop:OraDbType="104" type="xs:string" minOccurs="0" /> <xs:element name="CDEMSTATEMENT1" msprop:OraDbType="126" type="xs:string" minOccurs="0" /> <xs:element name="CDEMSTATEMENT2" msprop:OraDbType="126" type="xs:string" minOccurs="0" /> <xs:element name="CDEMSTATEMENT3" msprop:OraDbType="126" type="xs:string" minOccurs="0" /> <xs:element name="LPRODUCTSEPERATEBROKERAGE" msprop:BaseColumn="CPRODUCTSEPERATEBROKERAGE" msprop:OraDbType="104" type="xs:string" minOccurs="0" /> <xs:element name="NNBFCNETWORTH" msprop:BaseColumn="NNBFCNETWORTH" msprop:OraDbType="108" type="xs:double" minOccurs="0" /> <xs:element name="NNBFCCLIENTLIMIT" msprop:BaseColumn="NNBFCCLIENTLIMIT" msprop:OraDbType="122" type="xs:float" minOccurs="0" /> <xs:element name="NNBFCMINIMUMBALANCE" msprop:BaseColumn="NNBFCMINIMUMBALANCE" msprop:OraDbType="108" type="xs:double" minOccurs="0" /> <xs:element name="NNBFCBREAKUPVALUE" msprop:BaseColumn="NNBFCBREAKUPVALUE" msprop:OraDbType="108" type="xs:double" minOccurs="0" /> <xs:element name="CNFDSTARTTIME" msprop:BaseColumn="CNFDSTARTTIME" msprop:OraDbType="104" type="xs:string" minOccurs="0" /> <xs:element name="CNFDENDTIME" msprop:BaseColumn="CNFDENDTIME" msprop:OraDbType="104" type="xs:string" minOccurs="0" /> <xs:element name="DGLOBALSTARTDATE" msprop:BaseColumn="DGLOBALSTARTDATE" msprop:OraDbType="106" type="xs:dateTime" minOccurs="0" /> <xs:element name="DGLOBALENDDATE" msprop:BaseColumn="DGLOBALENDDATE" msprop:OraDbType="106" type="xs:dateTime" minOccurs="0" /> <xs:element name="CASIANSEGMENTACCOUNT" msprop:BaseColumn="CASIANSEGMENTACCOUNT" msprop:OraDbType="104" type="xs:string" minOccurs="0" /> <xs:element name="LCHANGEMASTERACCTPOSTING" msprop:BaseColumn="CCHANGEMASTERACCTPOSTING" msprop:OraDbType="104" type="xs:string" minOccurs="0" /> <xs:element name="LMAINTAINSCRIPWISECHARGES" msprop:BaseColumn="CMAINTAINSCRIPWISECHARGES" msprop:OraDbType="104" type="xs:string" minOccurs="0" /> <xs:element name="CEMAILID" msprop:OraDbType="126" type="xs:string" minOccurs="0" /> <xs:element name="CINSTITUTIONBROKERCODE" msprop:BaseColumn="CINSTITUTIONBROKERCODE" msprop:OraDbType="104" type="xs:string" minOccurs="0" /> <xs:element name="CSTPPATHFORFT" msprop:OraDbType="126" type="xs:string" minOccurs="0" /> <xs:element name="CSTPPATHFORNSDL" msprop:OraDbType="126" type="xs:string" minOccurs="0" /> <xs:element name="CSTPPATHFORNSEIT" msprop:OraDbType="126" type="xs:string" minOccurs="0" /> <xs:element name="CCOUNTRYNAME" msprop:OraDbType="126" type="xs:string" minOccurs="0" /> <xs:element name="NALLOWMULTILOGIN" msprop:BaseColumn="NALLOWMULTILOGIN" msprop:OraDbType="111" type="xs:short" minOccurs="0" /> <xs:element name="NALLOWSINGLESIGNON" msprop:BaseColumn="NALLOWSINGLESIGNON" msprop:OraDbType="111" type="xs:short" minOccurs="0" /> <xs:element name="NALLOWSINGLESESSION" msprop:BaseColumn="NALLOWSINGLESESSION" msprop:OraDbType="111" type="xs:short" minOccurs="0" /> <xs:element name="NSMSPROVIDER" msprop:BaseColumn="NSMSPROVIDER" msprop:OraDbType="111" type="xs:short" minOccurs="0" /> <xs:element name="CASIANFOSEGMENTACCOUNT" msprop:OraDbType="126" type="xs:string" minOccurs="0" /> <xs:element name="CASIANCURSEGMENTACCOUNT" msprop:OraDbType="126" type="xs:string" minOccurs="0" /> <xs:element name="CKRACOMPANYCODE" msprop:BaseColumn="CKRACOMPANYCODE" msprop:OraDbType="104" type="xs:string" minOccurs="0" /> <xs:element name="CMARSTATEMENT1" msprop:OraDbType="126" type="xs:string" minOccurs="0" /> <xs:element name="CMARSTATEMENT2" msprop:OraDbType="126" type="xs:string" minOccurs="0" /> <xs:element name="CMARSTATEMENT3" msprop:OraDbType="126" type="xs:string" minOccurs="0" /> <xs:element name="CMARSTATEMENT4" msprop:OraDbType="126" type="xs:string" minOccurs="0" /> <xs:element name="CMARSTATEMENT5" msprop:OraDbType="126" type="xs:string" minOccurs="0" /> <xs:element name="COMGEOBROKERACRONYM" msprop:BaseColumn="COMGEOBROKERACRONYM" msprop:OraDbType="104" type="xs:string" minOccurs="0" /> <xs:element name="CSTPPATHFORDERFT" msprop:OraDbType="126" type="xs:string" minOccurs="0" /> <xs:element name="CSTPPATHFORDERNSDL" msprop:OraDbType="126" type="xs:string" minOccurs="0" /> <xs:element name="CSTPPATHFORDERNSEIT" msprop:OraDbType="126" type="xs:string" minOccurs="0" /> <xs:element name="CSTPPATHFOROMGEODER" msprop:OraDbType="126" type="xs:string" minOccurs="0" /> <xs:element name="CSTPPATHFOROMGEOCASH" msprop:OraDbType="126" type="xs:string" minOccurs="0" /> <xs:element name="COMGEOMACHINEID" msprop:OraDbType="126" type="xs:string" minOccurs="0" /> <xs:element name="CNSDLKRACOMPANYCODE" msprop:BaseColumn="CNSDLKRACOMPANYCODE" msprop:OraDbType="104" type="xs:string" minOccurs="0" /> <xs:element name="CDOTEXKRACOMPANYCODE" msprop:BaseColumn="CDOTEXKRACOMPANYCODE" msprop:OraDbType="104" type="xs:string" minOccurs="0" /> <xs:element name="CPATHFORCAMS" msprop:BaseColumn="CPATHFORCAMS" msprop:OraDbType="126" type="xs:string" minOccurs="0" /> <xs:element name="CCINNUMBER" msprop:BaseColumn="CCINNUMBER" msprop:OraDbType="126" type="xs:string" minOccurs="0" /> <xs:element name="CDELREQUESTENDTIME" msprop:BaseColumn="CDELREQUESTENDTIME" msprop:OraDbType="104" type="xs:string" minOccurs="0" /> <xs:element name="CCHEQUEPATH" msprop:BaseColumn="CCHEQUEPATH" msprop:OraDbType="126" type="xs:string" minOccurs="0" /> <xs:element name="CNEFTPATH" msprop:BaseColumn="CNEFTPATH" msprop:OraDbType="126" type="xs:string" minOccurs="0" /> <xs:element name="CTRANSFERPATH" msprop:BaseColumn="CTRANSFERPATH" msprop:OraDbType="126" type="xs:string" minOccurs="0" /> <xs:element name="CFICODE" msprop:BaseColumn="CFICODE" msprop:OraDbType="104" type="xs:string" minOccurs="0" /> <xs:element name="CREGIONCODE" msprop:BaseColumn="CREGIONCODE" msprop:OraDbType="104" type="xs:string" minOccurs="0" /> <xs:element name="CBRANCHCODE" msprop:BaseColumn="CBRANCHCODE" msprop:OraDbType="104" type="xs:string" minOccurs="0" /> <xs:element name="CIPVORGCODE" msprop:BaseColumn="CIPVORGCODE" msprop:OraDbType="126" type="xs:string" minOccurs="0" /> <xs:element name="CEMPCODE" msprop:BaseColumn="CEMPCODE" msprop:OraDbType="104" type="xs:string" minOccurs="0" /> <xs:element name="CDEMSTATEMENT4" msprop:BaseColumn="CDEMSTATEMENT4" msprop:OraDbType="104" type="xs:string" minOccurs="0" /> <xs:element name="NSEBIMTFNETWORTH" msprop:BaseColumn="NSEBIMTFNETWORTH" msprop:OraDbType="108" type="xs:double" minOccurs="0" /> <xs:element name="CIGNOREPANVERIFICATION" msprop:BaseColumn="CIGNOREPANVERIFICATION" msprop:OraDbType="104" type="xs:string" minOccurs="0" /> <xs:element name="CPLEDGEREQUESTSTARTTIME" msprop:BaseColumn="CPLEDGEREQUESTSTARTTIME" msprop:OraDbType="104" type="xs:string" minOccurs="0" /> <xs:element name="CPLEDGEREQUESTENDTIME" msprop:BaseColumn="CPLEDGEREQUESTENDTIME" msprop:OraDbType="104" type="xs:string" minOccurs="0" /> </xs:sequence> </xs:complexType> </xs:element> </xs:choice> </xs:complexType> <xs:unique name="Constraint1"> <xs:selector xpath=".//ClientList" /> <xs:field xpath="ClientCode" /> </xs:unique> <xs:keyref name="loSecondRelation" refer="Constraint1"> <xs:selector xpath=".//ClientSegment" /> <xs:field xpath="CCLIENTCODE" /> </xs:keyref> <xs:keyref name="loFirstRelation" refer="Constraint1"> <xs:selector xpath=".//FinBal" /> <xs:field xpath="OOWNCODE" /> </xs:keyref> </xs:element> </xs:schema> <ClientList> <ClientCode>B84078 </ClientCode> <CBRANCHCODE>B84 </CBRANCHCODE> <ClientName>DHARMESH ASHOK SHAH</ClientName> <CFAMILYCODE>B84 </CFAMILYCODE> <CSUBGROUP>B84 </CSUBGROUP> <TermCode>B84078 </TermCode> <CSUBFAMILY xml:space="preserve"> </CSUBFAMILY> <CDEALERCODE xml:space="preserve"> </CDEALERCODE> <CTEAMLEADER xml:space="preserve"> </CTEAMLEADER> <CINTRODUCERCODE xml:space="preserve"> </CINTRODUCERCODE> <CRELATIONSHIPCODE xml:space="preserve"> </CRELATIONSHIPCODE> <Address1>BLDG NO 6 FLAT NO 102, KILBIL</Address1> <Address2>1ST FLR, S.V. ROAD, NR KRISHNA</Address2> <Address3>MANDIR PRABHAT NAGAR DAHISAR E</Address3> <CSTATE>MAHARASHTRA</CSTATE> <CITY>MUMBAI</CITY> <PINCODE>400068</PINCODE> <COUNTRY>INDIA</COUNTRY> <CorrespondenceAddress1>BLDG NO 6 FLAT NO 102, KILBIL</CorrespondenceAddress1> <CorrespondenceAddress2>1ST FLR, S.V. ROAD, NR KRISHNA</CorrespondenceAddress2> <CorrespondenceAddress3>MANDIR PRABHAT NAGAR DAHISAR E</CorrespondenceAddress3> <CorrespondenceCity>MUMBAI</CorrespondenceCity> <CorrespondencePincode>400068</CorrespondencePincode> <CorrespondenceCountry>INDIA</CorrespondenceCountry> <CorrespondenceState>MAHARASHTRA</CorrespondenceState> <TEL1>9833940509</TEL1> <TEL2 xml:space="preserve"> </TEL2> <TEL3 xml:space="preserve"> </TEL3> <MOBILE>9833940509</MOBILE> <FAX xml:space="preserve"> </FAX> <CSTDNO>091 </CSTDNO> <NISDNUMBER>0</NISDNUMBER> <CREFERREDBY xml:space="preserve"> </CREFERREDBY> <CPANGIR>ANKPS4163K </CPANGIR> <CPREFIX>Mr </CPREFIX> <CONDELSTATUS xml:space="preserve"> </CONDELSTATUS> <BILDELSTATUS xml:space="preserve"> </BILDELSTATUS> <SHADELSTATUS xml:space="preserve"> </SHADELSTATUS> <SEBIREGNO xml:space="preserve"> </SEBIREGNO> <CMAPINID xml:space="preserve"> </CMAPINID> <CFIRSTNAME>DHARMESH</CFIRSTNAME> <CSECONDNAME>ASHOK</CSECONDNAME> <CLASTNAME>SHAH</CLASTNAME> <CREFERREDCODE1 xml:space="preserve"> </CREFERREDCODE1> <CREFERREDCODE2 xml:space="preserve"> </CREFERREDCODE2> <CREFERREDCODE3 xml:space="preserve"> </CREFERREDCODE3> <CORAEFINCODE xml:space="preserve"> </CORAEFINCODE> <EMAIL>spectramindbs@gmail.com</EMAIL> </ClientList> <COMPLIANCEOFFICER> <CFIRMCODE>Fm-0000555</CFIRMCODE> <CFIRMNAME>MEHTA EQUITIES LTD. </CFIRMNAME> <CUSERFIRMCODE>REN-000001</CUSERFIRMCODE> <CADDRESS1>903, LODHA SUPREMUS, </CADDRESS1> <CADDRESS2>OFF,DR.E.MOSES ROAD, WORLI NAKA,MUMBAI-400018</CADDRESS2> <CADDRESS3>SEBI REGN NO. : INZ000175334 </CADDRESS3> <CBACKUPREMINDER>Yes</CBACKUPREMINDER> <CSTARTFINANCIALYEAR>2019</CSTARTFINANCIALYEAR> <CENDFINANCIALYEAR>2020</CENDFINANCIALYEAR> <CDATADRIVE>D:</CDATADRIVE> <CDATADIRECTORY>\REN0304\ </CDATADIRECTORY> <CCONNECTION>Apexld </CCONNECTION> <CDATASOURCENAME>REN0304ODBC </CDATASOURCENAME> <CDATASTORE>Oracle </CDATASTORE> <CSHORTNAME>MEHTAGROUP</CSHORTNAME> <CREGADDRESS1>903, LODHA SUPREMUS, </CREGADDRESS1> <CREGADDRESS2>OFF,DR. E. MOSES ROAD, WORLI NAKA, </CREGADDRESS2> <CREGADDRESS3>MUMBAI -400018 </CREGADDRESS3> <NCOMMODITY>0</NCOMMODITY> <CEMAILID>info@mehtagroup.in </CEMAILID> <CFAXNUMBER>022-61507100 </CFAXNUMBER> <CTELEPHONENUMBER>022-61507100 </CTELEPHONENUMBER> <NIGNORERISKTRADE>0</NIGNORERISKTRADE> <NIGNORERISKFINANCIAL>0</NIGNORERISKFINANCIAL> <NIGNORERISKBENEFICIARY>0</NIGNORERISKBENEFICIARY> <NIGNOREMASTERPICKUP>0</NIGNOREMASTERPICKUP> <CCOMPLIANCEOFFICER>REEMA SHAH </CCOMPLIANCEOFFICER> <CCOMPLIANCEEMAILID>compliance@mehtagroup.in </CCOMPLIANCEEMAILID> <CCOMPLIANCECONTACT>02261507100 </CCOMPLIANCECONTACT> <NNBFCFIRM>0</NNBFCFIRM> <CTECHTELNUMBER>02261507100 </CTECHTELNUMBER> <CTECHEMAILID>it@mehtagroup.in </CTECHEMAILID> <CCUSTTELNUMBER>02261507100 </CCUSTTELNUMBER> <CCUSTEMAILID>info@mehtagroup.in </CCUSTEMAILID> <NCLIENTLEVEL>1</NCLIENTLEVEL> <NIGNORETERMINALPICKUP>0</NIGNORETERMINALPICKUP> </COMPLIANCEOFFICER> <COMFIRMATION> <FIRM_CODE>REN-000001</FIRM_CODE> <BACKUPDRIVE>A:</BACKUPDRIVE> <RUNDATE>Y</RUNDATE> <RUNTIME>Y</RUNTIME> <HELPON>Y</HELPON> <CITY>MUMBAI </CITY> <JURISDICTION>MUMBAI </JURISDICTION> <CONTBILLHEAD xml:space="preserve"> </CONTBILLHEAD> <TRADETIMEPRINT>N</TRADETIMEPRINT> <FINSTARTDATE>2020-03-27T00:00:00+05:30</FINSTARTDATE> <FINENDDATE>2021-03-31T00:00:00+05:30</FINENDDATE> <PRT80132>N</PRT80132> <LDSTARTDATE>2020-03-31T00:00:00+05:30</LDSTARTDATE> <LDENDDATE>2021-03-31T00:00:00+05:30</LDENDDATE> <DOSPRINTOUT>Y</DOSPRINTOUT> <FAYEAR>2020-2021</FAYEAR> <PANGIR>AAACR4143C </PANGIR> <LLASTPAGE>Y</LLASTPAGE> <CFINSTATEMENT1 xml:space="preserve"> </CFINSTATEMENT1> <CFINSTATEMENT2 xml:space="preserve"> </CFINSTATEMENT2> <CFINSTATEMENT3 xml:space="preserve"> </CFINSTATEMENT3> <CFINSTATEMENT4 xml:space="preserve"> </CFINSTATEMENT4> <CFINSTATEMENT5 xml:space="preserve"> </CFINSTATEMENT5> <LSPECIAL>N</LSPECIAL> <CASPEMAIL>Microsoft Outlook</CASPEMAIL> <LNEWVERSION>Y</LNEWVERSION> <CFINSTATEMENT6>Please find herewith Statement of Accounts as per our books. Confirm the same and RETURN one copy at the earliest.</CFINSTATEMENT6> <CFINSTATEMENT7>If you have any discrepancies/queries/Error you are requested to report receipt of this statement within 30 Days</CFINSTATEMENT7> <CFINSTATEMENT8>from receipt of this statement. Your running account authorisation would continue until it is revoked by you.</CFINSTATEMENT8> <LDMARKSAME>Y</LDMARKSAME> <LROUNDOFFNETAMOUNT>Y</LROUNDOFFNETAMOUNT> <LTURNOVERBROKJV>N</LTURNOVERBROKJV> <LEXCLUDEAUCTION>Y</LEXCLUDEAUCTION> <LCONTRACTGENERATIONATEND>Y</LCONTRACTGENERATIONATEND> <CHDFCEPAY>HDFC</CHDFCEPAY> <LIGNOREPRODR>Y</LIGNOREPRODR> <LMARGINACROSSCOMPANIES>Y</LMARGINACROSSCOMPANIES> <LHYPERTHREADEDMODE>N</LHYPERTHREADEDMODE> <CWEBSITE>www.mehtagroup.in</CWEBSITE> <LALLOWSPECIALJV>Y</LALLOWSPECIALJV> <LPOASTOCKACROSSCOMPANIES>Y</LPOASTOCKACROSSCOMPANIES> <LPARTNERSHIPFIRM>N</LPARTNERSHIPFIRM> <LLDCDSLBACKOFFICE>Y</LLDCDSLBACKOFFICE> <LLDNSDLBACKOFFICE>N</LLDNSDLBACKOFFICE> <LBILLABOVE10000>Y</LBILLABOVE10000> <CDEMSTATEMENT1>Please find herewith Statement of Securities as per our books. Confirm the same and RETURN one copy at the earliest.</CDEMSTATEMENT1> <CDEMSTATEMENT2>If you have any discrepancies/queries/Error you are requested to report receipt of this statement within 30 Days</CDEMSTATEMENT2> <CDEMSTATEMENT3>from receipt of this statement. Your running account authorisation would continue until it is revoked by you.</CDEMSTATEMENT3> <LPRODUCTSEPERATEBROKERAGE>Y</LPRODUCTSEPERATEBROKERAGE> <NNBFCNETWORTH>51586000</NNBFCNETWORTH> <NNBFCCLIENTLIMIT>100</NNBFCCLIENTLIMIT> <NNBFCMINIMUMBALANCE>100</NNBFCMINIMUMBALANCE> <NNBFCBREAKUPVALUE>1000000</NNBFCBREAKUPVALUE> <CNFDSTARTTIME xml:space="preserve"> </CNFDSTARTTIME> <CNFDENDTIME xml:space="preserve"> </CNFDENDTIME> <DGLOBALSTARTDATE>2000-01-01T00:00:00+05:30</DGLOBALSTARTDATE> <DGLOBALENDDATE>2021-03-31T00:00:00+05:30</DGLOBALENDDATE> <CASIANSEGMENTACCOUNT xml:space="preserve"> </CASIANSEGMENTACCOUNT> <LCHANGEMASTERACCTPOSTING>N</LCHANGEMASTERACCTPOSTING> <LMAINTAINSCRIPWISECHARGES>Y</LMAINTAINSCRIPWISECHARGES> <CEMAILID>grievance@mehtagroup.in</CEMAILID> <CINSTITUTIONBROKERCODE xml:space="preserve"> </CINSTITUTIONBROKERCODE> <CSTPPATHFORFT xml:space="preserve"> </CSTPPATHFORFT> <CSTPPATHFORNSDL xml:space="preserve"> </CSTPPATHFORNSDL> <CSTPPATHFORNSEIT xml:space="preserve"> </CSTPPATHFORNSEIT> <CCOUNTRYNAME>INDIA</CCOUNTRYNAME> <NALLOWMULTILOGIN>0</NALLOWMULTILOGIN> <NALLOWSINGLESIGNON>0</NALLOWSINGLESIGNON> <NALLOWSINGLESESSION>0</NALLOWSINGLESESSION> <NSMSPROVIDER>10</NSMSPROVIDER> <CASIANFOSEGMENTACCOUNT xml:space="preserve"> </CASIANFOSEGMENTACCOUNT> <CASIANCURSEGMENTACCOUNT xml:space="preserve"> </CASIANCURSEGMENTACCOUNT> <CKRACOMPANYCODE xml:space="preserve"> </CKRACOMPANYCODE> <CMARSTATEMENT1 xml:space="preserve"> </CMARSTATEMENT1> <CMARSTATEMENT2 xml:space="preserve"> </CMARSTATEMENT2> <CMARSTATEMENT3 xml:space="preserve"> </CMARSTATEMENT3> <CMARSTATEMENT4 xml:space="preserve"> </CMARSTATEMENT4> <CMARSTATEMENT5 xml:space="preserve"> </CMARSTATEMENT5> <COMGEOBROKERACRONYM xml:space="preserve"> </COMGEOBROKERACRONYM> <CSTPPATHFORDERFT xml:space="preserve"> </CSTPPATHFORDERFT> <CSTPPATHFORDERNSDL xml:space="preserve"> </CSTPPATHFORDERNSDL> <CSTPPATHFORDERNSEIT xml:space="preserve"> </CSTPPATHFORDERNSEIT> <CSTPPATHFOROMGEODER xml:space="preserve"> </CSTPPATHFOROMGEODER> <CSTPPATHFOROMGEOCASH xml:space="preserve"> </CSTPPATHFOROMGEOCASH> <COMGEOMACHINEID xml:space="preserve"> </COMGEOMACHINEID> <CNSDLKRACOMPANYCODE xml:space="preserve"> </CNSDLKRACOMPANYCODE> <CDOTEXKRACOMPANYCODE xml:space="preserve"> </CDOTEXKRACOMPANYCODE> <CPATHFORCAMS xml:space="preserve"> </CPATHFORCAMS> <CCINNUMBER>U65990MH1994PLC078478</CCINNUMBER> <CDELREQUESTENDTIME xml:space="preserve"> </CDELREQUESTENDTIME> <CCHEQUEPATH xml:space="preserve"> </CCHEQUEPATH> <CNEFTPATH xml:space="preserve"> </CNEFTPATH> <CTRANSFERPATH xml:space="preserve"> </CTRANSFERPATH> <CFICODE xml:space="preserve"> </CFICODE> <CREGIONCODE xml:space="preserve"> </CREGIONCODE> <CBRANCHCODE xml:space="preserve"> </CBRANCHCODE> <CIPVORGCODE xml:space="preserve"> </CIPVORGCODE> <CEMPCODE xml:space="preserve"> </CEMPCODE> <CDEMSTATEMENT4 xml:space="preserve"> </CDEMSTATEMENT4> <NSEBIMTFNETWORTH>0</NSEBIMTFNETWORTH> <CIGNOREPANVERIFICATION>Y</CIGNOREPANVERIFICATION> <CPLEDGEREQUESTSTARTTIME>08:00:00</CPLEDGEREQUESTSTARTTIME> <CPLEDGEREQUESTENDTIME>20:00:00</CPLEDGEREQUESTENDTIME> </COMFIRMATION> </NewDataSet>