| |  编辑 | 复制 | 删除 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`) = \'11320014.00\' | 11320014.00 |
2003 respectively.
|
NULL |
0 |
NULL |
0 |
NULL |
NULL |
NULL |
NULL |
NULL |
0 |
NULL |
NULL |
NULL |
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`) = \'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`) = \'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`) = \'15200013.00\' | 15200013.00 |
"Olectra Greentech Ltd." |
"Olectra Greentech" |
51 |
"Auto - LCVs/HCVs" |
10514 |
"Not Applicable" |
"2000-10-11" |
"2000" |
"" |
"" |
1 |
"L34100TG2000PLC035451" |
"The Telecom division of Goldstone Technologies Lt... |
"2022-07-28 14:24:27" |
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`) = \'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`) = \'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`) = \'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`) = \'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`) = \'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`) = \'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`) = \'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 |
| | 编辑 | 复制 | 删除 DELETE FROM `CompanyMaster` WHERE CONCAT(`CompanyMaster`.`CompanyCode`) = \'17010050.00\' | 17010050.00 |
"HMT Ltd." |
"HMT Ltd." |
53 |
"Auto - Tractors" |
10120 |
"Public Sector" |
"1953-02-07" |
"1953" |
"" |
NULL |
1 |
"L29230KA1953GOI000748" |
NULL |
"2020-09-20 09:15:58" |
0 |
| | 编辑 | 复制 | 删除 DELETE FROM `CompanyMaster` WHERE CONCAT(`CompanyMaster`.`CompanyCode`) = \'10530002.00\' | 10530002.00 |
"Punjab Tractors Ltd. (Merged)" |
"Punj. Tractors" |
53 |
"Auto - Tractors" |
10097 |
"Mahindra Group" |
"1970-06-27" |
"1970" |
"" |
"" |
1 |
"L29211CH1970PLC002942" |
"Merged" |
"2017-09-13 17:35:54" |
0 |
| | 编辑 | 复制 | 删除 DELETE FROM `CompanyMaster` WHERE CONCAT(`CompanyMaster`.`CompanyCode`) = \'10530003.00\' | 10530003.00 |
"Escorts Tractors Ltd." |
"Escorts Tractors" |
53 |
"Auto - Tractors" |
10103 |
"Nanda Group" |
"1969-05-21" |
"1969" |
"" |
"1991" |
1 |
NULL |
"Merged" |
"2016-03-10 11:49:43" |
0 |
| | 编辑 | 复制 | 删除 DELETE FROM `CompanyMaster` WHERE CONCAT(`CompanyMaster`.`CompanyCode`) = \'10540004.00\' | 10540004.00 |
"Escorts Kubota Ltd." |
"Escorts Kubota" |
53 |
"Auto - Tractors" |
10103 |
"Nanda Group" |
"1944-10-17" |
"1944" |
"" |
NULL |
1 |
"L74899HR1944PLC039088" |
NULL |
"2022-06-23 18:26:51" |
0 |
| | 编辑 | 复制 | 删除 DELETE FROM `CompanyMaster` WHERE CONCAT(`CompanyMaster`.`CompanyCode`) = \'10530004.00\' | 10530004.00 |
"Asian Tractors Ltd." |
"Asian Tractors" |
53 |
"Auto - Tractors" |
10514 |
"Not Applicable" |
"1974-12-26" |
"1974" |
"" |
"1990" |
1 |
NULL |
NULL |
"2016-03-10 11:49:00" |
0 |
| | 编辑 | 复制 | 删除 DELETE FROM `CompanyMaster` WHERE CONCAT(`CompanyMaster`.`CompanyCode`) = \'10530005.00\' | 10530005.00 |
"VST Tillers Tractors Ltd." |
"VST Tillers Tr" |
53 |
"Auto - Tractors" |
11366 |
"VST Group" |
"1967-12-18" |
"1967" |
"" |
"" |
1 |
"L34101KA1967PLC001706" |
NULL |
"2016-08-09 15:06:16" |
0 |
| | 编辑 | 复制 | 删除 DELETE FROM `CompanyMaster` WHERE CONCAT(`CompanyMaster`.`CompanyCode`) = \'10530022.00\' | 10530022.00 |
"Escorts Motors Ltd." |
"Escorts Motors Ltd." |
53 |
"Auto - Tractors" |
10514 |
"Not Applicable" |
"1994-07-06" |
"1994" |
"" |
"" |
1 |
"U50100DL1994PTC060077" |
"Removed from ISEC2" |
"2022-07-23 13:18:37" |
0 |
