UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 40000 AND Type_ = 1;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 67697 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 69272 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 69450 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 69942 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 72694 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 75416 AND Type_ = 10;
UPDATE data_universe_rkd SET RkdIssueStatus = 0, Ticker = NULL, RIC = '0007.HK^I26' WHERE SecCode = 77609 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'BMG8571C2643', SEDOL = 'BX7YSQ', CUSIP = 'G8571C26' WHERE SecCode = 80202 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 81438 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 82108 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 82146 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 83142 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 84445 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 84719 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 86093 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 89534 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 90471 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 91901 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 92181 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 93815 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 94213 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 94745 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 94891 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 97022 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 97525 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 99138 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 99172 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 115142 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 115317 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 119591 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 126810 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 127092 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 132080 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 135763 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 255424 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 258786 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 258792 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 302310 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 302433 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 383497 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 396138 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 450695 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 521135 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 550827 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 692769 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 787656 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 898133 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 1024323 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 1153561 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 1237137 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 1316139 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 1401827 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 1641430 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 2065778 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 2294756 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 2373426 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 2462091 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 2533380 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 2848454 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 2959530 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 2961761 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3011192 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3018641 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3031568 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3032282 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3037819 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3046333 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3049345 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3051792 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3051797 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3067181 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3085532 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3087022 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3113761 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3127007 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3127082 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3133501 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3145978 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3162862 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3172341 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3212151 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3213023 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3222837 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3225973 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3226002 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3234669 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3242484 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3245594 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3275685 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3283859 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3283969 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3283974 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3295160 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3304243 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3306836 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3339577 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3339666 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3347459 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3347763 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3353718 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3357855 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3392350 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3393831 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3395184 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3395338 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3401731 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3402856 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3403072 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3403339 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3405600 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3406470 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3407187 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3416760 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3427864 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3429138 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3429801 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3435135 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3436252 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3436905 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3439907 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3440960 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3441470 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3445582 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3445583 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3446987 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3519863 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3550496 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3586927 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3588090 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3612339 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3619208 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3625884 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3634356 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3656302 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3658717 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3658723 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3658724 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3666898 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3750914 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3769450 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3796473 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3799576 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3845935 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3854679 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3858210 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3885183 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3888346 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3894813 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3901787 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3913168 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3955673 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3956843 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 3961764 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4041277 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4041393 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4060785 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4310593 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4313231 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4335862 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4335864 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4339145 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4341610 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4429539 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4449598 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4482176 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4485806 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4501951 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4507736 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4524357 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4527808 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4539148 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4557733 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4603473 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4615787 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4620153 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4632973 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4639757 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4724707 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4728954 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4746790 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4800505 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4838034 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4893249 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4897803 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 4940655 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5168288 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5223194 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5283335 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5316691 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5349586 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5401708 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5443484 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5601206 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5658429 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5808106 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5953916 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5958664 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5981831 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5981833 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5987986 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5987988 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5988063 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5996598 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 5999070 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6039879 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6159015 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6160908 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6167085 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6203257 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6342559 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6383728 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6538858 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6578038 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6626024 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6631798 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6645652 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6674462 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6699549 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6728353 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6748888 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6755622 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6755623 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6755624 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6756397 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6806143 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6806170 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6806189 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6806193 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6813227 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6846841 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6887836 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6930668 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6937617 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6939101 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6939106 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6941637 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6945360 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6948298 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6957660 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6967198 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6967201 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6977549 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6985946 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6989185 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 6997056 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 7006693 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 7006701 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 7006703 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 7009112 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 7040613 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 7044192 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 7044707 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 7050896 AND Type_ = 10;
UPDATE data_universe_rkd SET ISIN = 'CNE100007WT4', CUSIP = 'Y9910G10' WHERE SecCode = 7055217 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 7055221 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 7058577 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = 'IND' WHERE SecCode = 7061740 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 7061742 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 7064157 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 7067499 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 7067656 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 7075702 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 7077875 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 7077877 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 7080319 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 7080326 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 7088931 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 7088935 AND Type_ = 10;
UPDATE data_universe_rkd SET COATypeCode = '' WHERE SecCode = 11266729 AND Type_ = 1;