9-15 enterprise data updates

Update company_test, no_ic_code set company_test.ic_code = no_ic_code. license registration No.
Where no_ic_code. company name = company_test.name

Update company_test, t_all set company_test.ic_code = t_all. Business Registration Number
Where t_all. company name = company_test.name
And (t_all. 'Business Registration number 'Regexp' ^ [[: blank:] {} ([A-Z] | [[: digit:]) {15} [[: blank:] {0, 3} $ '= 1
Or t_all. 'Business Registration number 'Regexp' ^ [[: blank:] {} ([A-Z] | [: digit:]) {13} [[: blank:] {0, 3} $ '= 1
Or t_all. 'Business Registration number 'Regexp' ^ [[: blank:] {} ([A-Z] | [: digit:]) {13} [[: blank:] {0, 3} $ '= 1
Or t_all. 'Business Registration No. 'regexp' ^ [[: blank:] {0, 3} [BCF] [[: digit:] {5} [[: blank:] {0, 3} $ '= 1
Or t_all. 'Business Registration No. 'regexp' ^ [[: blank:] {} ([[: Alpha:] + No. [[: digit:] + ?) [[: Blank:] {0, 3} $ '= 1
)

Update company_test, ic_ischinese
Set company_test.ic_code = ic_ischinese. 'license Registration No'
Where company_test.name = ic_ischinese. 'Enterprise name'

Create Table irregular_org_code_new as select * From irregular_org_code

Update company_test, irregular_org_code_new set company_test.org_code = Replace (replace (remarks column, "Chaoyang", ""), "Shunyi ","")

Where irregular_org_code_new. Enterprise Name = company_test.name and replace (remarks column, "Chaoyang", ""), "Shunyi", "") Regexp
'^ [[: Blank:] {0, 3} ([A-Z] | [[: digit:]) {9} [[[: blank:] {0, 3} $'

Update company_test, irregular_org_code_new set company_test.org_code_syned = '1'
Where company_test.name = irregular_org_code_new. Enterprise Name
And irregular_org_code_new. remarks column = '√'
-------------------------------------------------------------------

Update no_reg_in_guo_di2 set whether to pay taxes remotely = '1'
Where no_reg_in_guo_di2. Whether to pay taxes remotely like '% is %' or
No_reg_in_guo_di2. Whether to pay taxes in different regions = 'pay taxes in different regions ';

Update no_reg_in_guo_di2 set whether to pay taxes remotely = '-1'
Where no_reg_in_guo_di2. Whether to pay taxes remotely = 'no ';

Update company_test, no_reg_in_guo_di2 set company_test.state_tax_code = no_reg_in_guo_di2. Tax Registration No,
Company_test.local_tax_code = no_reg_in_guo_di2. Local Tax Registration number,
Company_test.ydns = no_reg_in_guo_di2. Whether to pay taxes remotely
Where company_test.name = no_reg_in_guo_di2. Enterprise Name

------------------------------------------------------------------------------

Update no_reg_in_guo_di, company_test set company_test.state_tax_code = no_reg_in_guo_di. National Tax Registration No.
Where company_test.name = no_reg_in_guo_di. Enterprise Name

Update company_test, t_all set company_test.ic_code = Replace (t_all. Business Registration Number, "Export ","")
Where t_all. company name = company_test.name
And (

T_all. 'Business Registration number 'Regexp' ^ [[: blank:] {} Move out ([A-Z] | [[: digit:]) {15 }[[: blank:] {0, 3} $ '= 1
Or t_all. 'Business Registration number 'Regexp' ^ [[: blank:] {} Move out ([A-Z] | [[: digit:]) {13 }[[: blank:] {0, 3} $ '= 1
Or t_all. 'Business Registration number 'Regexp' ^ [[: blank:] {} Move out ([A-Z] | [[: digit:]) {13 }[[: blank:] {0, 3} $ '= 1
Or t_all. 'Business Registration No. 'regexp' ^ [[: blank:] {} Move out of [BCF] [[: digit:] {5} [[: blank:] {0, 3} $ '= 1
Or t_all. 'Business Registration No. 'regexp' ^ [[: blank:] {0, 3} Move out ([[: Alpha:] + [[: digit:] + ?) [[: Blank:] {0, 3} $ '= 1
 

)
Commit;

Select * From company_test where name = 'East US International Air Travel Service Co., Ltd'
775455158

Update company_test set ic_code = '000000' where name = 'East America International Travel Service Co., Ltd'

Select * From company_test where name like '% Beijing beirenyu Co., Ltd. (office) %'
801236427

Update company_test set ic_code = '000000' where name like '% Beijing North people Yu new Co., Ltd. (office) %'