| |  编辑 | 复制 | 删除 DELETE FROM `CompanyMaster` WHERE CONCAT(`CompanyMaster`.`CompanyCode`) = \'0.00\' | 0.00 |
"2016-03-10 14:33:41" |
False
|
0 |
NULL |
0 |
NULL |
NULL |
NULL |
NULL |
NULL |
0 |
NULL |
NULL |
NULL |
0 |
| | 编辑 | 复制 | 删除 DELETE FROM `CompanyMaster` WHERE CONCAT(`CompanyMaster`.`CompanyCode`) = \'10510001.00\' | 10510001.00 |
"Ashok Leyland Ltd." |
"Ashok Leyland" |
51 |
"Auto - LCVs/HCVs" |
10058 |
"Hindujas Group" |
"1948-09-07" |
"1948" |
"" |
"1979" |
1 |
"L34101TN1948PLC000105" |
NULL |
"2016-03-10 14:33:36" |
0 |
| | 编辑 | 复制 | 删除 DELETE FROM `CompanyMaster` WHERE CONCAT(`CompanyMaster`.`CompanyCode`) = \'10510002.00\' | 10510002.00 |
"Force Motors Ltd." |
"Force Motors" |
51 |
"Auto - LCVs/HCVs" |
10048 |
"Firodias Group" |
"1958-09-08" |
"1958" |
"" |
"1964" |
1 |
"L34102PN1958PLC011172" |
NULL |
"2018-07-30 14:12:23" |
0 |
| | 编辑 | 复制 | 删除 DELETE FROM `CompanyMaster` WHERE CONCAT(`CompanyMaster`.`CompanyCode`) = \'10510003.00\' | 10510003.00 |
"Daewoo Motors India Ltd." |
"Daewoo Motors In" |
52 |
"Auto - Cars & Jeeps" |
11169 |
"MNC Associate" |
"1901-01-01" |
"1901" |
"1984-12-31" |
"1984" |
1 |
"U34103DL1901PLC016259" |
NULL |
"2016-03-10 14:34:17" |
0 |
| | 编辑 | 复制 | 删除 DELETE FROM `CompanyMaster` WHERE CONCAT(`CompanyMaster`.`CompanyCode`) = \'10510004.00\' | 10510004.00 |
"Eicher Motors Ltd." |
"Eicher Motors" |
51 |
"Auto - LCVs/HCVs" |
10041 |
"Eicher Group" |
"1982-10-14" |
"1982" |
"" |
"1985" |
1 |
"L34102DL1982PLC129877" |
NULL |
"2016-03-10 14:34:18" |
0 |
| | 编辑 | 复制 | 删除 DELETE FROM `CompanyMaster` WHERE CONCAT(`CompanyMaster`.`CompanyCode`) = \'10510005.00\' | 10510005.00 |
"Hindustan Motors Ltd." |
"Hind. Motor" |
52 |
"Auto - Cars & Jeeps" |
10017 |
"CK Birla Group" |
"1942-02-11" |
"1942" |
"" |
"1945" |
1 |
"L34103WB1942PLC018967" |
NULL |
"2016-03-10 14:33:44" |
0 |
| | 编辑 | 复制 | 删除 DELETE FROM `CompanyMaster` WHERE CONCAT(`CompanyMaster`.`CompanyCode`) = \'10510005.02\' | 10510005.02 |
"HM Export Ltd." |
"HM Export" |
125 |
"Trading" |
10017 |
"CK Birla Group" |
"" |
NULL |
"" |
NULL |
1 |
"U65923WB1961PLC025330" |
NULL |
"2017-01-10 15:10:28" |
0 |
| | 编辑 | 复制 | 删除 DELETE FROM `CompanyMaster` WHERE CONCAT(`CompanyMaster`.`CompanyCode`) = \'10510006.00\' | 10510006.00 |
"Mahindra Nissan Allwyn Ltd." |
"Mahindra Nissan" |
51 |
"Auto - LCVs/HCVs" |
10097 |
"Mahindra Group" |
"1983-07-08" |
"1983" |
"" |
"1984" |
1 |
NULL |
"Merged" |
"2016-08-11 18:28:53" |
0 |
| | 编辑 | 复制 | 删除 DELETE FROM `CompanyMaster` WHERE CONCAT(`CompanyMaster`.`CompanyCode`) = \'10510007.00\' | 10510007.00 |
"SML Isuzu Ltd." |
"SML Isuzu Ltd." |
51 |
"Auto - LCVs/HCVs" |
10514 |
"Not Applicable" |
"1983-07-26" |
"1983" |
"" |
"1985" |
1 |
"L50101PB1983PLC005516" |
NULL |
"2016-03-10 14:32:58" |
0 |
| | 编辑 | 复制 | 删除 DELETE FROM `CompanyMaster` WHERE CONCAT(`CompanyMaster`.`CompanyCode`) = \'10510008.00\' | 10510008.00 |
"Tata Motors Ltd." |
"Tata Motors Ltd." |
51 |
"Auto - LCVs/HCVs" |
10141 |
"Tata Group" |
"1945-09-01" |
"1945" |
"" |
"" |
1 |
"L28920MH1945PLC004520" |
"IR" |
"2016-03-10 14:34:56" |
0 |
| | 编辑 | 复制 | 删除 DELETE FROM `CompanyMaster` WHERE CONCAT(`CompanyMaster`.`CompanyCode`) = \'10510008.02\' | 10510008.02 |
"Tata Technologies Ltd." |
"Tata Technologies" |
319 |
"IT Consulting & Software" |
10141 |
"Tata Group" |
"1994-08-22" |
"1994" |
"1999-12-06" |
"1999" |
1 |
"U72200PN1994PLC013313" |
NULL |
"2018-07-10 19:21:32" |
0 |
| | 编辑 | 复制 | 删除 DELETE FROM `CompanyMaster` WHERE CONCAT(`CompanyMaster`.`CompanyCode`) = \'10520001.00\' | 10520001.00 |
"Premier Ltd." |
"PremierLtd." |
352 |
"Engineering - General" |
10160 |
"Walchand Doshi Group" |
"1944-06-27" |
"1944" |
"" |
"1963" |
1 |
"L34103PN1944PLC020842" |
NULL |
"2016-03-10 14:35:36" |
0 |
| | 编辑 | 复制 | 删除 DELETE FROM `CompanyMaster` WHERE CONCAT(`CompanyMaster`.`CompanyCode`) = \'10520001.02\' | 10520001.02 |
"Pal Hire Purchase Ltd." |
"Pal Hire Purchas" |
409 |
"Finance & Investments" |
10160 |
"Walchand Doshi Group" |
"" |
NULL |
"" |
NULL |
1 |
NULL |
NULL |
"2016-03-10 11:49:07" |
0 |
| | 编辑 | 复制 | 删除 DELETE FROM `CompanyMaster` WHERE CONCAT(`CompanyMaster`.`CompanyCode`) = \'10520002.00\' | 10520002.00 |
"Standard Motor Products of India Ltd." |
"Standard Motors" |
67 |
"Auto Ancl - Others" |
10028 |
"Mac Group" |
"1948-09-02" |
"1948" |
"" |
NULL |
1 |
NULL |
NULL |
"2016-03-10 11:54:31" |
0 |
| | 编辑 | 复制 | 删除 DELETE FROM `CompanyMaster` WHERE CONCAT(`CompanyMaster`.`CompanyCode`) = \'10520003.00\' | 10520003.00 |
"Mahindra & Mahindra Ltd." |
"Mahi. & Mahi" |
52 |
"Auto - Cars & Jeeps" |
10097 |
"Mahindra Group" |
"1945-10-02" |
"1945" |
"" |
"1955" |
1 |
"L65990MH1945PLC004558" |
NULL |
"2016-08-11 18:28:53" |
0 |
| | 编辑 | 复制 | 删除 DELETE FROM `CompanyMaster` WHERE CONCAT(`CompanyMaster`.`CompanyCode`) = \'10520003.01\' | 10520003.01 |
"Tech Mahindra Ltd." |
"Tech Mahindra" |
319 |
"IT Consulting & Software" |
10097 |
"Mahindra Group" |
"1986-10-24" |
"1986" |
"2006-08-01" |
"2006" |
1 |
"L64200MH1986PLC041370" |
NULL |
"2020-07-17 09:07:32" |
0 |
| | 编辑 | 复制 | 删除 DELETE FROM `CompanyMaster` WHERE CONCAT(`CompanyMaster`.`CompanyCode`) = \'10520003.02\' | 10520003.02 |
"Mahindra Engineering & Chemical Products Ltd." |
"Mahindra Enginee" |
701 |
"Diversified" |
10097 |
"Mahindra Group" |
"1954-06-07" |
"1954" |
"" |
NULL |
1 |
"U74999MH1954PLC019908" |
NULL |
"2016-08-11 18:28:53" |
0 |
| | 编辑 | 复制 | 删除 DELETE FROM `CompanyMaster` WHERE CONCAT(`CompanyMaster`.`CompanyCode`) = \'10520003.05\' | 10520003.05 |
"Mahindra Sintered Products Ltd." |
"Mahindra Sintere" |
451 |
"Bearings" |
10097 |
"Mahindra Group" |
"" |
"1960" |
"" |
NULL |
1 |
NULL |
NULL |
"2016-08-11 18:28:53" |
0 |
| | 编辑 | 复制 | 删除 DELETE FROM `CompanyMaster` WHERE CONCAT(`CompanyMaster`.`CompanyCode`) = \'10520003.14\' | 10520003.14 |
"Mahindra & Mahindra Financial Services Ltd." |
"M&M Fin.Services" |
409 |
"Finance & Investments" |
10097 |
"Mahindra Group" |
"1991-01-01" |
"1991" |
"2006-02-21" |
"2006" |
1 |
"L65921MH1991PLC059642" |
NULL |
"2016-08-11 18:28:53" |
0 |
| | 编辑 | 复制 | 删除 DELETE FROM `CompanyMaster` WHERE CONCAT(`CompanyMaster`.`CompanyCode`) = \'10520004.00\' | 10520004.00 |
"Sipani Automobiles Ltd." |
"Sipani Auto" |
52 |
"Auto - Cars & Jeeps" |
10514 |
"Not Applicable" |
"" |
"1974" |
"" |
"1976" |
1 |
NULL |
"Winding-up of the Company" |
"2016-03-10 11:49:00" |
0 |
| | 编辑 | 复制 | 删除 DELETE FROM `CompanyMaster` WHERE CONCAT(`CompanyMaster`.`CompanyCode`) = \'10520005.00\' | 10520005.00 |
"Maruti Suzuki India Ltd." |
"Maruti Suzuki India" |
52 |
"Auto - Cars & Jeeps" |
11169 |
"MNC Associate" |
"1981-02-24" |
"1981" |
"" |
NULL |
1 |
"L34103DL1981PLC011375" |
NULL |
"2016-03-10 14:34:09" |
0 |
| | 编辑 | 复制 | 删除 DELETE FROM `CompanyMaster` WHERE CONCAT(`CompanyMaster`.`CompanyCode`) = \'10520006.00\' | 10520006.00 |
"Pal-Peugeot Ltd." |
"Pal-Peugeot Limi" |
52 |
"Auto - Cars & Jeeps" |
10160 |
"Walchand Doshi Group" |
"1994-07-25" |
"1994" |
"1995-12-18" |
"1995" |
1 |
NULL |
"Winding-up of the Company" |
"2016-03-10 11:48:23" |
0 |
| | 编辑 | 复制 | 删除 DELETE FROM `CompanyMaster` WHERE CONCAT(`CompanyMaster`.`CompanyCode`) = \'10520016.00\' | 10520016.00 |
"French Motor Car Co. Ltd." |
"French Motor Car Co." |
52 |
"Auto - Cars & Jeeps" |
10514 |
"Not Applicable" |
"1920-03-08" |
"1920" |
"" |
"" |
1 |
"L74110WB1920PLC003679" |
NULL |
"2020-12-21 09:40:28" |
0 |
| | 编辑 | 复制 | 删除 DELETE FROM `CompanyMaster` WHERE CONCAT(`CompanyMaster`.`CompanyCode`) = \'10520023.00\' | 10520023.00 |
"Mahindra Engineering Services Ltd." |
"MahindraEngServices" |
52 |
"Auto - Cars & Jeeps" |
10097 |
"Mahindra Group" |
"1995-08-07" |
"1995" |
"" |
NULL |
1 |
"U72400MH1995PLC091404" |
"Removed from ISEC2 List" |
"2016-12-13 14:11:57" |
0 |
| | 编辑 | 复制 | 删除 DELETE FROM `CompanyMaster` WHERE CONCAT(`CompanyMaster`.`CompanyCode`) = \'10530001.00\' | 10530001.00 |
"Eicher Tractors Ltd." |
"Eicher Tractors" |
53 |
"Auto - Tractors" |
10041 |
"Eicher Group" |
"1978-05-04" |
"1978" |
"" |
"1988" |
1 |
NULL |
"Merged" |
"2016-03-10 11:49:13" |
0 |
