0
一:删除
二:新增
insert into master_ter values ('H31040600534','1701959',NULL)
insert into master_ter values ('H31040600560','1701959',NULL)
insert into master_ter values ('H31040602729','1701959',NULL)
insert into master_ter values ('H31040600563','1701959',NULL)
insert into master_ter values ('H31040602955','1701959',NULL)
insert into master_ter values ('H31040600530','1701959',NULL)
insert into master_ter values ('H31040600536','1701959',NULL)
insert into master_ter values ('H31040603440','1701959',NULL)
insert into master_ter values ('H31040603011','1701959',NULL)
insert into master_ter values ('H31040600553','1701959',NULL)
insert into master_ter values ('H31040603010','1701959',NULL)
insert into master_ter values ('H31040600527','1701959',NULL)
insert into master_ter values ('H16441309050134','1701959',NULL)
insert into master_ter values ('H31040600538','1701959',NULL)
insert into master_ter values ('H31040600517','1701959',NULL)
insert into master_ter values ('H31040600557','1701959',NULL)
insert into master_ter values ('H31040600504','1701959',NULL)
insert into master_ter values ('H31040601036','1701959',NULL)
insert into master_ter values ('H31040600505','1701959',NULL)
insert into master_ter values ('H31040601038','1701959',NULL)
insert into master_ter values ('H31040602823','1701959',NULL)
insert into master_ter values ('H31040602951','1701959',NULL)
insert into master_ter values ('H31040600544','1701959',NULL)
insert into master_ter values ('H31040600524','1701959',NULL)
insert into master_ter values ('H31040603015','1701959',NULL)
insert into master_ter values ('H31040600528','1701959',NULL)
insert into master_ter values ('H31040602957','1701959',NULL)
insert into master_ter values ('H31040600930','1701959',NULL)
insert into master_ter values ('H31040600551','1701959',NULL)
insert into master_ter values ('H31040601060','1701959',NULL)
insert into master_ter values ('H31040600929','1701959',NULL)
insert into master_ter values ('H31040600554','1701959',NULL)
insert into master_ter values ('H31040600559','1701959',NULL)
insert into master_ter values ('H31040600928','1701959',NULL)
insert into master_ter values ('H31040600555','1701959',NULL)
insert into master_ter values ('H31040600564','1701959',NULL)
insert into master_ter values ('H31040600899','1701959',NULL)
insert into master_ter values ('H31040600539','1701959',NULL)
insert into master_ter values ('H31040601032','1701959',NULL)
insert into master_ter values ('H31040600542','1701959',NULL)
insert into master_ter values ('H31040600526','1701959',NULL)
insert into master_ter values ('H31040600533','1701959',NULL)
insert into master_ter values ('H31040602838','1701959',NULL)
insert into master_ter values ('H31040601061','1701959',NULL)
insert into master_ter values ('H31040600510','1701959',NULL)
insert into master_ter values ('H31040600535','1701959',NULL)
insert into master_ter values ('H31040600565','1701959',NULL)
insert into master_ter values ('H31040602730','1701959',NULL)
insert into master_ter values ('H16441309050133','1701959',NULL)
insert into master_ter values ('H31040600529','1701959',NULL)
insert into master_ter values ('H31040600545','1701959',NULL)
insert into master_ter values ('H31040600926','1701959',NULL)
insert into master_ter values ('H31040602956','1701959',NULL)
insert into master_ter values ('H31040603441','1701959',NULL)
insert into master_ter values ('H31040602958','1701959',NULL)
insert into master_ter values ('H31040602952','1701959',NULL)
insert into master_ter values ('H31040602954','1701959',NULL)
insert into master_ter values ('H31040603014','1701959',NULL)
insert into master_ter values ('H31040601035','1701959',NULL)
insert into master_ter values ('H31040600537','1701959',NULL)
insert into master_ter values ('H31040600502','1701959',NULL)
insert into master_ter values ('H31040602275','1701959',NULL)
insert into master_ter values ('H31040600562','1701959',NULL)
insert into master_ter values ('H31040600550','1701959',NULL)
insert into master_ter values ('H31040600532','1701959',NULL)
insert into master_ter values ('H31040602953','1701959',NULL)
insert into master_ter values ('H31040601041','1701959',NULL)
insert into master_ter values ('H31040600552','1701959',NULL)
insert into master_ter values ('H31040600925','1701959',NULL)
insert into master_ter values ('H31040601040','1701959',NULL)
insert into master_ter values ('H31040603013','1701959',NULL)
insert into master_ter values ('H31040601031','1701959',NULL)
insert into master_ter values ('H31040602731','1701959',NULL)
insert into master_ter values ('H31040600558','1701959',NULL)
insert into master_ter values ('H31040600547','1701959',NULL)
insert into master_ter values ('H31040603298','1701959',NULL)
insert into master_ter values ('H31040600546','1701959',NULL)
insert into master_ter values ('H16441312280060','1701959',NULL)
insert into master_ter values ('H31040600522','1701959',NULL)
insert into master_ter values ('H16441311300340','1701959',NULL)
insert into master_ter values ('H16441312150063','1701959',NULL)
insert into master_ter values ('H31040602728','1701959',NULL)
insert into master_ter values ('H31040203001','1701965',NULL)
insert into master_ter values ('H17441304052968','1701965',NULL)
insert into master_ter values ('H17441304053071','1701965',NULL)
insert into master_ter values ('H31040600884','1701965',NULL)
insert into master_ter values ('H17441304250346','1701965',NULL)
insert into master_ter values ('H17441304250331','1701965',NULL)
insert into master_ter values ('H17441304250335','1701965',NULL)
insert into master_ter values ('H17441304250339','1701965',NULL)
insert into master_ter values ('H17441304250340','1701965',NULL)
insert into master_ter values ('H31040202846','1701965',NULL)
insert into master_ter values ('H31040202997','1701965',NULL)
insert into master_ter values ('H17441304250337','1701965',NULL)
insert into master_ter values ('H17441304250344','1701965',NULL)
insert into master_ter values ('H17441304053202','1701965',NULL)
insert into master_ter values ('H17441304053199','1701965',NULL)
insert into master_ter values ('H17441304052969','1701965',NULL)
insert into master_ter values ('H17441304070006','1701965',NULL)
insert into master_ter values ('H17441304250333','1701965',NULL)
insert into master_ter values ('H17441304052965','1701965',NULL)
insert into master_ter values ('H17441304250348','1701965',NULL)
insert into master_ter values ('H17441304250334','1701965',NULL)
insert into master_ter values ('H31040602061','1701965',NULL)
insert into master_ter values ('H31040202873','1701965',NULL)
insert into master_ter values ('H31040202995','1701965',NULL)
insert into master_ter values ('H17441304053204','1701965',NULL)
insert into master_ter values ('H31040202994','1701965',NULL)
insert into master_ter values ('H17441304250341','1701965',NULL)
insert into master_ter values ('H31040202844','1701965',NULL)
insert into master_ter values ('H31040202843','1701965',NULL)
insert into master_ter values ('H17441304250345','1701965',NULL)
insert into master_ter values ('H17441304053197','1701965',NULL)
insert into master_ter values ('H17441304250342','1701965',NULL)
insert into master_ter values ('H17441304250338','1701965',NULL)
insert into master_ter values ('H17441304250329','1701965',NULL)
insert into master_ter values ('H17441304250343','1701965',NULL)
insert into master_ter values ('H17441304250349','1701965',NULL)
insert into master_ter values ('H31040202851','1701965',NULL)
insert into master_ter values ('H31040202835','1701965',NULL)
insert into master_ter values ('H17441304052966','1701965',NULL)
insert into master_ter values ('H17441304052967','1701965',NULL)
insert into master_ter values ('H17441304250332','1701965',NULL)
insert into master_ter values ('H17441304250330','1701965',NULL)
insert into master_ter values ('H17441304250336','1701965',NULL)
insert into master_ter values ('H17441304250347','1701965',NULL)
insert into master_ter values ('H17441304070008','1701965',NULL)
insert into master_ter values ('H31040202842','1701965',NULL)
insert into master_ter values ('H17441304070003','1701965',NULL)
insert into master_ter values ('H31040203356','1701963',NULL)
insert into master_ter values ('H31040203376','1701963',NULL)
insert into master_ter values ('H31040203323','1701963',NULL)
insert into master_ter values ('H31040203342','1701963',NULL)
insert into master_ter values ('H31040203340','1701963',NULL)
insert into master_ter values ('H31040203348','1701963',NULL)
insert into master_ter values ('H31040203351','1701963',NULL)
insert into master_ter values ('H31040203358','1701963',NULL)
insert into master_ter values ('H31040203374','1701963',NULL)
insert into master_ter values ('H31040203345','1701963',NULL)
insert into master_ter values ('H31040203377','1701963',NULL)
insert into master_ter values ('H31040203326','1701963',NULL)
insert into master_ter values ('H31040203324','1701963',NULL)
insert into master_ter values ('H31040203361','1701963',NULL)
insert into master_ter values ('H31040203375','1701963',NULL)
insert into master_ter values ('H31040203368','1701963',NULL)
insert into master_ter values ('H31040203331','1701963',NULL)
insert into master_ter values ('H31040203365','1701963',NULL)
insert into master_ter values ('H31040203366','1701963',NULL)
insert into master_ter values ('H31040203339','1701963',NULL)
insert into master_ter values ('H31040203330','1701963',NULL)
insert into master_ter values ('H31040603245','1701963',NULL)
insert into master_ter values ('H31040203378','1701963',NULL)
insert into master_ter values ('H31040203335','1701963',NULL)
insert into master_ter values ('H31040203371','1701963',NULL)
insert into master_ter values ('H16441308220460','1701963',NULL)
insert into master_ter values ('H31040203373','1701963',NULL)
insert into master_ter values ('H31040203364','1701963',NULL)
insert into master_ter values ('H31040203360','1701963',NULL)
insert into master_ter values ('H31040203353','1701963',NULL)
insert into master_ter values ('H31040203357','1701963',NULL)
insert into master_ter values ('H31040203359','1701963',NULL)
insert into master_ter values ('H16441308220456','1701963',NULL)
insert into master_ter values ('H31040203328','1701963',NULL)
insert into master_ter values ('H31040203343','1701963',NULL)
insert into master_ter values ('H31040203325','1701963',NULL)
insert into master_ter values ('H31040203337','1701963',NULL)
insert into master_ter values ('H16441308220350','1701963',NULL)
insert into master_ter values ('H31040203341','1701963',NULL)
insert into master_ter values ('H31040603246','1701963',NULL)
insert into master_ter values ('H16441308220385','1701963',NULL)
insert into master_ter values ('H31040203372','1701963',NULL)
insert into master_ter values ('H31040203354','1701963',NULL)
insert into master_ter values ('H31040203379','1701963',NULL)
insert into master_ter values ('H31040203327','1701963',NULL)
insert into master_ter values ('H31040203344','1701963',NULL)
insert into master_ter values ('H16441308170160','1701963',NULL)
insert into master_ter values ('H16441308220319','1701963',NULL)
insert into master_ter values ('H31040203355','1701963',NULL)
insert into master_ter values ('H31040203336','1701963',NULL)
insert into master_ter values ('H31040203363','1701963',NULL)
insert into master_ter values ('H16441308220417','1701963',NULL)
insert into master_ter values ('H31040203362','1701963',NULL)
insert into master_ter values ('H31040203338','1701963',NULL)
insert into master_ter values ('H31040203367','1701963',NULL)
insert into master_ter values ('H31040203370','1701963',NULL)
insert into master_ter values ('H17441305151150','1701963',NULL)
insert into master_ter values ('H17331007136449','1605493',NULL)
insert into master_ter values ('H17331007136586','1605493',NULL)
insert into master_ter values ('H17331007136524','1605493',NULL)
insert into master_ter values ('H17331007136245','1605493',NULL)
insert into master_ter values ('H17331007136428','1605493',NULL)
insert into master_ter values ('H17331007136433','1605493',NULL)
insert into master_ter values ('H17331007136511','1605493',NULL)
insert into master_ter values ('H17331007136527','1605493',NULL)
insert into master_ter values ('H17331007136528','1605493',NULL)
insert into master_ter values ('H17331007136445','1605493',NULL)
insert into master_ter values ('H31160111841','1701347',NULL)
insert into master_ter values ('H31160203555','1701347',NULL)
insert into master_ter values ('H31160203556','1701347',NULL)
insert into master_ter values ('H31160201205','1701347',NULL)
insert into master_ter values ('H16441911200449','1701347',NULL)
insert into master_ter values ('H31160201203','1701347',NULL)
insert into master_ter values ('H31160201200','1701347',NULL)
insert into master_ter values ('H31160201202','1701347',NULL)
insert into master_ter values ('H31160204723','1701347',NULL)
insert into master_ter values ('H31160201201','1701347',NULL)
insert into master_ter values ('H31160201208','1701347',NULL)
insert into master_ter values ('H31160100074','1703134',NULL)
insert into master_ter values ('H31160102162','1703134',NULL)
insert into master_ter values ('H31160104412','1703134',NULL)
insert into master_ter values ('H31160104380','1703134',NULL)
insert into master_ter values ('H31160104802','1703134',NULL)
insert into master_ter values ('H31160109274','1703134',NULL)
insert into master_ter values ('H31160111725','1703134',NULL)
insert into master_ter values ('H31160111311','1703134',NULL)
insert into master_ter values ('H31160111321','1703134',NULL)
insert into master_ter values ('H31160111268','1703134',NULL)
insert into master_ter values ('H31160111257','1703134',NULL)
insert into master_ter values ('H31160111272','1703134',NULL)
insert into master_ter values ('H31160203563','1703134',NULL)
insert into master_ter values ('H31160202428','1703134',NULL)
insert into master_ter values ('H31160204702','1703134',NULL)
insert into master_ter values ('H31160204681','1703134',NULL)
insert into master_ter values ('H31160204680','1703134',NULL)
insert into master_ter values ('H31160204701','1703134',NULL)
insert into master_ter values ('H31010101377','1703134',NULL)
insert into master_ter values ('H31160202907','1703134',NULL)
insert into master_ter values ('H31160202909','1703134',NULL)
insert into master_ter values ('H31160202911','1703134',NULL)
insert into master_ter values ('H31160202910','1703134',NULL)
insert into master_ter values ('H31160201204','1703134',NULL)
insert into master_ter values ('H31160202913','1703134',NULL)
insert into master_ter values ('H31160100103','1701348',NULL)
insert into master_ter values ('H31160102117','1701348',NULL)
insert into master_ter values ('H31160109373','1701348',NULL)
insert into master_ter values ('H31160111719','1701348',NULL)
insert into master_ter values ('H31160111848','1701348',NULL)
insert into master_ter values ('H31160111378','1701348',NULL)
insert into master_ter values ('H31160203578','1701348',NULL)
insert into master_ter values ('H16441911190631','1701348',NULL)
insert into master_ter values ('H16441911250740','1701348',NULL)
insert into master_ter values ('H16441911250743','1701348',NULL)
insert into master_ter values ('H16441911250741','1701348',NULL)
insert into master_ter values ('H16441911250744','1701348',NULL)
insert into master_ter values ('H16441912260902','1701348',NULL)
insert into master_ter values ('H16441911250742','1701348',NULL)
insert into master_ter values ('H31160201862','1701348',NULL)
insert into master_ter values ('H31160201863','1701348',NULL)
insert into master_ter values ('H31160201864','1701348',NULL)
insert into master_ter values ('H31160203577','1701348',NULL)
insert into master_ter values ('H31160203576','1701348',NULL)
insert into master_ter values ('H31160200691','1701348',NULL)
insert into master_ter values ('H31160201392','1701348',NULL)
insert into master_ter values ('H31160201214','1701348',NULL)
insert into master_ter values ('H31160200791','1701348',NULL)
insert into master_ter values ('H31160203501','1701348',NULL)
insert into master_ter values ('H31160201167','1701348',NULL)
insert into master_ter values ('H31160201215','1701348',NULL)
insert into master_ter values ('H31160201231','1701348',NULL)
insert into master_ter values ('H31160203574','1701348',NULL)
insert into master_ter values ('H31160204765','1701348',NULL)
insert into master_ter values ('H31160201229','1701348',NULL)
insert into master_ter values ('H31160201227','1701348',NULL)
insert into master_ter values ('H31160201177','1701348',NULL)
insert into master_ter values ('H31160201213','1701348',NULL)
insert into master_ter values ('H31160200872','1701348',NULL)
insert into master_ter values ('H16441911190630','1701348',NULL)
insert into master_ter values ('H31160202919','1701348',NULL)
insert into master_ter values ('H31160201230','1701348',NULL)
insert into master_ter values ('H31160203575','1701348',NULL)
insert into master_ter values ('H31160203502','1701348',NULL)
insert into master_ter values ('H31160111287','1701565',NULL)
insert into master_ter values ('H31160111292','1701565',NULL)
insert into master_ter values ('H16441910251974','1701565',NULL)
insert into master_ter values ('H31160102142','1700921',NULL)
insert into master_ter values ('H31160100234','1700921',NULL)
insert into master_ter values ('H31160100383','1700921',NULL)
insert into master_ter values ('H31160104319','1700921',NULL)
insert into master_ter values ('H31160102781','1700921',NULL)
insert into master_ter values ('H31160109229','1700921',NULL)
insert into master_ter values ('H31160111382','1700921',NULL)
insert into master_ter values ('H31160111303','1700921',NULL)
insert into master_ter values ('H31160111372','1700921',NULL)
insert into master_ter values ('H31160111301','1700921',NULL)
insert into master_ter values ('H31160111374','1700921',NULL)
insert into master_ter values ('H31160111299','1700921',NULL)
insert into master_ter values ('H31160100235','1700921',NULL)
insert into master_ter values ('H31160100325','1700921',NULL)
insert into master_ter values ('H31160100326','1700921',NULL)
insert into master_ter values ('H31160104750','1700921',NULL)
insert into master_ter values ('H31160111380','1700921',NULL)
insert into master_ter values ('H31160111385','1700921',NULL)
insert into master_ter values ('H31160111375','1700921',NULL)
insert into master_ter values ('H31160111371','1700921',NULL)
insert into master_ter values ('H31160111386','1700921',NULL)
insert into master_ter values ('H31160200004','1700921',NULL)
insert into master_ter values ('H31160111872','1700921',NULL)
insert into master_ter values ('H16441911250734','1700921',NULL)
insert into master_ter values ('H16441911250749','1700921',NULL)
insert into master_ter values ('H16441911250747','1700921',NULL)
insert into master_ter values ('H16441911250732','1700921',NULL)
insert into master_ter values ('H16441911250746','1700921',NULL)
insert into master_ter values ('H16441911250733','1700921',NULL)
insert into master_ter values ('H16441911190629','1700921',NULL)
insert into master_ter values ('H16441911250745','1700921',NULL)
insert into master_ter values ('H16441911250731','1700921',NULL)
insert into master_ter values ('H16441911250748','1700921',NULL)
insert into master_ter values ('H16441911250730','1700921',NULL)
insert into master_ter values ('H31160204076','1700921',NULL)
insert into master_ter values ('H31160204079','1700921',NULL)
insert into master_ter values ('H31160204080','1700921',NULL)
insert into master_ter values ('H31160204070','1700921',NULL)
insert into master_ter values ('H31160109102','1701563',NULL)
insert into master_ter values ('H31160200002','1701563',NULL)
insert into master_ter values ('H31160111267','1701563',NULL)
insert into master_ter values ('H31160200040','1701563',NULL)
insert into master_ter values ('H31160204641','1701563',NULL)
insert into master_ter values ('K17441906190249','1701563',NULL)
insert into master_ter values ('K17441906190244','1701563',NULL)
insert into master_ter values ('H16441911040684','1701563',NULL)
insert into master_ter values ('H16441911040687','1701563',NULL)
insert into master_ter values ('H16441911100834','1701563',NULL)
insert into master_ter values ('H16441911140907','1701563',NULL)
insert into master_ter values ('H31160111445','1701350',NULL)
insert into master_ter values ('H31160111764','1701350',NULL)
insert into master_ter values ('H31160200033','1701350',NULL)
insert into master_ter values ('H31160111861','1701350',NULL)
insert into master_ter values ('H31160111862','1701350',NULL)
insert into master_ter values ('H31160111858','1701350',NULL)
insert into master_ter values ('H31160111260','1701350',NULL)
insert into master_ter values ('H31160111399','1701350',NULL)
insert into master_ter values ('H31160111406','1701350',NULL)
insert into master_ter values ('H31160200144','1701350',NULL)
insert into master_ter values ('H31160200044','1701350',NULL)
insert into master_ter values ('H31160200034','1701350',NULL)
insert into master_ter values ('H31160202801','1701350',NULL)
insert into master_ter values ('H31160202785','1701350',NULL)
insert into master_ter values ('H31160200145','1701350',NULL)
insert into master_ter values ('H31160200668','1701350',NULL)
insert into master_ter values ('H31160200214','1701350',NULL)
insert into master_ter values ('H31160201390','1701350',NULL)
insert into master_ter values ('H31160203560','1701350',NULL)
insert into master_ter values ('H31160203559','1701350',NULL)
insert into master_ter values ('H16441911200448','1701350',NULL)
insert into master_ter values ('H31160202643','1701350',NULL)
insert into master_ter values ('H31160200753','1701350',NULL)
insert into master_ter values ('H16441909060198','1701350',NULL)
insert into master_ter values ('H31160201389','1701350',NULL)
insert into master_ter values ('H31160201250','1701350',NULL)
insert into master_ter values ('H31160201246','1701350',NULL)
insert into master_ter values ('H31160204044','1701350',NULL)
insert into master_ter values ('H31160204713','1701350',NULL)
insert into master_ter values ('H31160204714','1701350',NULL)
insert into master_ter values ('H16441911200450','1701350',NULL)
insert into master_ter values ('H31160201248','1701350',NULL)
insert into master_ter values ('T17440306262007','1702425',NULL)
insert into master_ter values ('T17440306293151','1702423',NULL)
insert into master_ter values ('T17440306300578','1702428',NULL)
insert into master_ter values ('T17440306300530','1702428',NULL)
insert into master_ter values ('T17440306300564','1702428',NULL)
insert into master_ter values ('T17440306300586','1702428',NULL)
insert into master_ter values ('T17440306300504','1702428',NULL)
insert into master_ter values ('T17440306293178','1702423',NULL)
insert into master_ter values ('T17440306293157','1702423',NULL)
insert into master_ter values ('T17440306293183','1702423',NULL)
insert into master_ter values ('T17440306300558','1702428',NULL)
insert into master_ter values ('T17440306300589','1702428',NULL)
insert into master_ter values ('T17440306300506','1702428',NULL)
insert into master_ter values ('T17440306300572','1702428',NULL)
insert into master_ter values ('T17440306300549','1702428',NULL)
insert into master_ter values ('T17440306300526','1702428',NULL)
insert into master_ter values ('T17440306300544','1702428',NULL)
insert into master_ter values ('T17440306300536','1702428',NULL)
insert into master_ter values ('T17440306300496','1702428',NULL)
insert into master_ter values ('T17440306300537','1702428',NULL)
insert into master_ter values ('T17440306300588','1702428',NULL)
insert into master_ter values ('T17440306300542','1702428',NULL)
insert into master_ter values ('T17440306300548','1702428',NULL)
insert into master_ter values ('T17440306300570','1702428',NULL)
insert into master_ter values ('T17440306300524','1702428',NULL)
insert into master_ter values ('T17440306300555','1702428',NULL)
insert into master_ter values ('T17440306300543','1702428',NULL)
insert into master_ter values ('T17440306300554','1702428',NULL)
insert into master_ter values ('T17440306300563','1702428',NULL)
insert into master_ter values ('T17440306300575','1702428',NULL)
insert into master_ter values ('T17440306300587','1702428',NULL)
insert into master_ter values ('T17440306300514','1702428',NULL)
insert into master_ter values ('T17440306300498','1702428',NULL)
insert into master_ter values ('T17440306300568','1702428',NULL)
insert into master_ter values ('T17440306300565','1702428',NULL)
insert into master_ter values ('T17440306300523','1702428',NULL)
insert into master_ter values ('T17440306300522','1702428',NULL)
insert into master_ter values ('T17440306300512','1702428',NULL)
insert into master_ter values ('T17440306300534','1702428',NULL)
insert into master_ter values ('T17440306300535','1702428',NULL)
insert into master_ter values ('T17440306261985','1702425',NULL)
insert into master_ter values ('T17440306293193','1702423',NULL)
insert into master_ter values ('T17440306293159','1702423',NULL)
insert into master_ter values ('T17440306293177','1702423',NULL)
insert into master_ter values ('T17440306300539','1702428',NULL)
insert into master_ter values ('T17440306293147','1702423',NULL)
insert into master_ter values ('T17440306293172','1702423',NULL)
insert into master_ter values ('T17440306293154','1702423',NULL)
insert into master_ter values ('T17440306293196','1702423',NULL)
insert into master_ter values ('T17440306293162','1702423',NULL)
insert into master_ter values ('T17440306300494','1702428',NULL)
insert into master_ter values ('T17440306300560','1702428',NULL)
insert into master_ter values ('T17440306300500','1702428',NULL)
insert into master_ter values ('T17440306300545','1702428',NULL)
insert into master_ter values ('T17440306300547','1702428',NULL)
insert into master_ter values ('T17440306300562','1702428',NULL)
insert into master_ter values ('T17440306300508','1702428',NULL)
insert into master_ter values ('T17440306300584','1702428',NULL)
insert into master_ter values ('T17440306300527','1702428',NULL)
insert into master_ter values ('T17440306293145','1702423',NULL)
insert into master_ter values ('T17440306261988','1702425',NULL)
insert into master_ter values ('T17440306301066','1702424',NULL)
insert into master_ter values ('T17440306300827','1702424',NULL)
insert into master_ter values ('T17440306301081','1702424',NULL)
insert into master_ter values ('T17440306300819','1702424',NULL)
insert into master_ter values ('T17440306300822','1702424',NULL)
insert into master_ter values ('T17440306301080','1702424',NULL)
insert into master_ter values ('T17440306293141','1702423',NULL)
insert into master_ter values ('T17440306261335','1702427',NULL)
insert into master_ter values ('T17440306261306','1702427',NULL)
insert into master_ter values ('T17440306261307','1702427',NULL)
insert into master_ter values ('T17440306261239','1702427',NULL)
insert into master_ter values ('T17440306261310','1702427',NULL)
insert into master_ter values ('T17440306261324','1702427',NULL)
insert into master_ter values ('T17440306261297','1702427',NULL)
insert into master_ter values ('T17440306261311','1702427',NULL)
insert into master_ter values ('T17440306261345','1702427',NULL)
insert into master_ter values ('T17440306261265','1702427',NULL)
insert into master_ter values ('T17440306261295','1702427',NULL)
insert into master_ter values ('T17440306261246','1702427',NULL)
insert into master_ter values ('T17440306261290','1702427',NULL)
insert into master_ter values ('T17440306261256','1702427',NULL)
insert into master_ter values ('T17440306261242','1702427',NULL)
insert into master_ter values ('T17440306261286','1702427',NULL)
insert into master_ter values ('T17440306261340','1702427',NULL)
insert into master_ter values ('T17440306261280','1702427',NULL)
insert into master_ter values ('T17440306261315','1702427',NULL)
insert into master_ter values ('T17440306261308','1702427',NULL)
insert into master_ter values ('T17440306261281','1702427',NULL)
insert into master_ter values ('T17440306261323','1702427',NULL)
insert into master_ter values ('T17440306261344','1702427',NULL)
insert into master_ter values ('T17440306261272','1702427',NULL)
insert into master_ter values ('T17440306261316','1702427',NULL)
insert into master_ter values ('T17440306261341','1702427',NULL)
insert into master_ter values ('T17440306261303','1702427',NULL)
insert into master_ter values ('T17440306261268','1702427',NULL)
insert into master_ter values ('T17440306261991','1702425',NULL)
insert into master_ter values ('T17440306261992','1702425',NULL)
insert into master_ter values ('T17440306261271','1702427',NULL)
insert into master_ter values ('T17440306261352','1702427',NULL)
insert into master_ter values ('T17440306261248','1702427',NULL)
insert into master_ter values ('T17440306261285','1702427',NULL)
insert into master_ter values ('T17440306261314','1702427',NULL)
insert into master_ter values ('T17440306261292','1702427',NULL)
insert into master_ter values ('T17440306261234','1702427',NULL)
insert into master_ter values ('T17440306261237','1702427',NULL)
insert into master_ter values ('T17440306261241','1702427',NULL)
insert into master_ter values ('T17440306261313','1702427',NULL)
insert into master_ter values ('T17440306261276','1702427',NULL)
insert into master_ter values ('T17440306261355','1702427',NULL)
insert into master_ter values ('T17440306261300','1702427',NULL)
insert into master_ter values ('T17440306261288','1702427',NULL)
insert into master_ter values ('T17440306261354','1702427',NULL)
insert into master_ter values ('T17440306261236','1702427',NULL)
insert into master_ter values ('T17440306261325','1702427',NULL)
insert into master_ter values ('T17440306261243','1702427',NULL)
insert into master_ter values ('T17440306261334','1702427',NULL)
insert into master_ter values ('T17440306261318','1702427',NULL)
insert into master_ter values ('T17440306261299','1702427',NULL)
insert into master_ter values ('T17440306261351','1702427',NULL)
insert into master_ter values ('T17440306261339','1702427',NULL)
insert into master_ter values ('T17440306261282','1702427',NULL)
insert into master_ter values ('T17440306261251','1702427',NULL)
insert into master_ter values ('T17440306261273','1702427',NULL)
insert into master_ter values ('T17440306261260','1702427',NULL)
insert into master_ter values ('T17440306261274','1702427',NULL)
insert into master_ter values ('T17440306261294','1702427',NULL)
insert into master_ter values ('T17440306261347','1702427',NULL)
insert into master_ter values ('T17440306261993','1702425',NULL)
insert into master_ter values ('T17440306261995','1702425',NULL)
insert into master_ter values ('T17440306261986','1702425',NULL)
insert into master_ter values ('T17440306261997','1702425',NULL)
insert into master_ter values ('T17440306261994','1702425',NULL)
insert into master_ter values ('T17440306261989','1702425',NULL)
insert into master_ter values ('T17440306262000','1702425',NULL)
insert into master_ter values ('T17440306262003','1702425',NULL)
insert into master_ter values ('T17440306261996','1702425',NULL)
insert into master_ter values ('T17440306261999','1702425',NULL)
insert into master_ter values ('T17440306293140','1702423',NULL)
insert into master_ter values ('T17440306293195','1702423',NULL)
insert into master_ter values ('T17440306293161','1702423',NULL)
insert into master_ter values ('T17440306293175','1702423',NULL)
insert into master_ter values ('T17440306293139','1702423',NULL)
insert into master_ter values ('T17440306293184','1702423',NULL)
insert into master_ter values ('T17440306261269','1702427',NULL)
insert into master_ter values ('T17440306261346','1702427',NULL)
insert into master_ter values ('T17440306300574','1702428',NULL)
insert into master_ter values ('T17440306300540','1702428',NULL)
insert into master_ter values ('T17440306300507','1702428',NULL)
insert into master_ter values ('T17440306261275','1702427',NULL)
insert into master_ter values ('T17440306300814','1702424',NULL)
insert into master_ter values ('T17440306301083','1702424',NULL)
insert into master_ter values ('T17440306301127','1702424',NULL)
insert into master_ter values ('T17440306300840','1702424',NULL)
insert into master_ter values ('T17440306300863','1702424',NULL)
insert into master_ter values ('T17440306293189','1702423',NULL)
insert into master_ter values ('T17440306293146','1702423',NULL)
insert into master_ter values ('T17440306293165','1702423',NULL)
insert into master_ter values ('T17440306293190','1702423',NULL)
insert into master_ter values ('T17440306293186','1702423',NULL)
insert into master_ter values ('T17440306300538','1702428',NULL)
insert into master_ter values ('T17440306300517','1702428',NULL)
insert into master_ter values ('T17440306300566','1702428',NULL)
insert into master_ter values ('T17440306300551','1702428',NULL)
insert into master_ter values ('T17440306300525','1702428',NULL)
insert into master_ter values ('T17440306300518','1702428',NULL)
insert into master_ter values ('T17440306300559','1702428',NULL)
insert into master_ter values ('T17440306261422','1702426',NULL)
insert into master_ter values ('T17440306261437','1702426',NULL)
insert into master_ter values ('T17440306261454','1702426',NULL)
insert into master_ter values ('T17440306300557','1702428',NULL)
insert into master_ter values ('T17440306300501','1702428',NULL)
insert into master_ter values ('T17440306300493','1702428',NULL)
insert into master_ter values ('T17440306300541','1702428',NULL)
insert into master_ter values ('T17440306300499','1702428',NULL)
insert into master_ter values ('T17440306300497','1702428',NULL)
insert into master_ter values ('T17440306300585','1702428',NULL)
insert into master_ter values ('T17440306261254','1702427',NULL)
insert into master_ter values ('T17440306261257','1702427',NULL)
insert into master_ter values ('T17440306261258','1702427',NULL)
insert into master_ter values ('T17440306261250','1702427',NULL)
insert into master_ter values ('T17440306261342','1702427',NULL)
insert into master_ter values ('T17440306261336','1702427',NULL)
insert into master_ter values ('T17440306261245','1702427',NULL)
insert into master_ter values ('T17440306261331','1702427',NULL)
insert into master_ter values ('T17440306261244','1702427',NULL)
insert into master_ter values ('T17440306261277','1702427',NULL)
insert into master_ter values ('T17440306261284','1702427',NULL)
insert into master_ter values ('T17440306261348','1702427',NULL)
insert into master_ter values ('T17440306261283','1702427',NULL)
insert into master_ter values ('T17440306261407','1702426',NULL)
insert into master_ter values ('T17440306261392','1702426',NULL)
insert into master_ter values ('T17440306261388','1702426',NULL)
insert into master_ter values ('T17440306261427','1702426',NULL)
insert into master_ter values ('T17440306261382','1702426',NULL)
insert into master_ter values ('T17440306261384','1702426',NULL)
insert into master_ter values ('T17440306261460','1702426',NULL)
insert into master_ter values ('T17440306261396','1702426',NULL)
insert into master_ter values ('T17440306261441','1702426',NULL)
insert into master_ter values ('T17440306261423','1702426',NULL)
insert into master_ter values ('T17440306261452','1702426',NULL)
insert into master_ter values ('T17440306261444','1702426',NULL)
insert into master_ter values ('T17440306293160','1702423',NULL)
insert into master_ter values ('T17440306261461','1702426',NULL)
insert into master_ter values ('T17440306261981','1702426',NULL)
insert into master_ter values ('T17440306261414','1702426',NULL)
insert into master_ter values ('T17440306261442','1702426',NULL)
insert into master_ter values ('T17440306261433','1702426',NULL)
insert into master_ter values ('T17440306261368','1702426',NULL)
insert into master_ter values ('T17440306261980','1702426',NULL)
insert into master_ter values ('T17440306261381','1702426',NULL)
insert into master_ter values ('T17440306261418','1702426',NULL)
insert into master_ter values ('T17440306261391','1702426',NULL)
insert into master_ter values ('T17440306261416','1702426',NULL)
insert into master_ter values ('T17440306261413','1702426',NULL)
insert into master_ter values ('T17440306261373','1702426',NULL)
insert into master_ter values ('T17440306261404','1702426',NULL)
insert into master_ter values ('T17440306261400','1702426',NULL)
insert into master_ter values ('T17440306261459','1702426',NULL)
insert into master_ter values ('T17440306261387','1702426',NULL)
insert into master_ter values ('T17440306261371','1702426',NULL)
insert into master_ter values ('T17440306261375','1702426',NULL)
insert into master_ter values ('T17440306261438','1702426',NULL)
insert into master_ter values ('T17440306261395','1702426',NULL)
insert into master_ter values ('T17440306261458','1702426',NULL)
insert into master_ter values ('T17440306261403','1702426',NULL)
insert into master_ter values ('T17440306261408','1702426',NULL)
insert into master_ter values ('T17440306262002','1702425',NULL)
insert into master_ter values ('T17440306261425','1702426',NULL)
insert into master_ter values ('T17440306261394','1702426',NULL)
insert into master_ter values ('T17440306261380','1702426',NULL)
insert into master_ter values ('T17440306261443','1702426',NULL)
insert into master_ter values ('T17440306261383','1702426',NULL)
insert into master_ter values ('T17440306261399','1702426',NULL)
insert into master_ter values ('T17440306261426','1702426',NULL)
insert into master_ter values ('T17440306261435','1702426',NULL)
insert into master_ter values ('T17440306261376','1702426',NULL)
insert into master_ter values ('T17440306261424','1702426',NULL)
insert into master_ter values ('T17440306261428','1702426',NULL)
insert into master_ter values ('T17440306261450','1702426',NULL)
insert into master_ter values ('T17440306261385','1702426',NULL)
insert into master_ter values ('T17440306261456','1702426',NULL)
insert into master_ter values ('T17440306261455','1702426',NULL)
insert into master_ter values ('T17440306261393','1702426',NULL)
insert into master_ter values ('T17440306261419','1702426',NULL)
insert into master_ter values ('T17440306261446','1702426',NULL)
insert into master_ter values ('T17440306261379','1702426',NULL)
insert into master_ter values ('T17440306261982','1702426',NULL)
insert into master_ter values ('T17440306261462','1702426',NULL)
insert into master_ter values ('T17440306261378','1702426',NULL)
insert into master_ter values ('T17440306261406','1702426',NULL)
insert into master_ter values ('T17440306261402','1702426',NULL)
insert into master_ter values ('T17440306293142','1702423',NULL)
insert into master_ter values ('T17440306293164','1702423',NULL)
insert into master_ter values ('T17440306293180','1702423',NULL)
insert into master_ter values ('T17440306293150','1702423',NULL)
insert into master_ter values ('T17440306293181','1702423',NULL)
insert into master_ter values ('T17440306293152','1702423',NULL)
insert into master_ter values ('T17440306293188','1702423',NULL)
insert into master_ter values ('T17440306293198','1702423',NULL)
insert into master_ter values ('T17440306293179','1702423',NULL)
insert into master_ter values ('T17440306293143','1702423',NULL)
insert into master_ter values ('T17440306293171','1702423',NULL)
insert into master_ter values ('T17440306293197','1702423',NULL)
insert into master_ter values ('T17440306261420','1702426',NULL)
insert into master_ter values ('T17440306261429','1702426',NULL)
insert into master_ter values ('T17440306261430','1702426',NULL)
insert into master_ter values ('T17440306261409','1702426',NULL)
insert into master_ter values ('T17440306261434','1702426',NULL)
insert into master_ter values ('T17440306261417','1702426',NULL)
insert into master_ter values ('T17440306261411','1702426',NULL)
insert into master_ter values ('T17440306261415','1702426',NULL)
insert into master_ter values ('T17440306261372','1702426',NULL)
insert into master_ter values ('T17440306261421','1702426',NULL)
insert into master_ter values ('T17440306300868','1702424',NULL)
insert into master_ter values ('T17440306301145','1702424',NULL)
insert into master_ter values ('T17440306300845','1702424',NULL)
insert into master_ter values ('T17440306301095','1702424',NULL)
insert into master_ter values ('T17440306300799','1702424',NULL)
insert into master_ter values ('T17440306301102','1702424',NULL)
insert into master_ter values ('T17440306300794','1702424',NULL)
insert into master_ter values ('T17440306300871','1702424',NULL)
insert into master_ter values ('T17440306301143','1702424',NULL)
insert into master_ter values ('T17440306301151','1702424',NULL)
insert into master_ter values ('T17440306301092','1702424',NULL)
insert into master_ter values ('T17440306300804','1702424',NULL)
insert into master_ter values ('T17440306301100','1702424',NULL)
insert into master_ter values ('T17440306300818','1702424',NULL)
insert into master_ter values ('T17440306300809','1702424',NULL)
insert into master_ter values ('T17440306300844','1702424',NULL)
insert into master_ter values ('T17440306301137','1702424',NULL)
insert into master_ter values ('T17440306300805','1702424',NULL)
insert into master_ter values ('T17440306301084','1702424',NULL)
insert into master_ter values ('T17440306300870','1702424',NULL)
insert into master_ter values ('T17440306300847','1702424',NULL)
insert into master_ter values ('T17440306301068','1702424',NULL)
insert into master_ter values ('T17440306300859','1702424',NULL)
insert into master_ter values ('T17440306301117','1702424',NULL)
insert into master_ter values ('T17440306300803','1702424',NULL)
insert into master_ter values ('T17440306301112','1702424',NULL)
insert into master_ter values ('T17440306300850','1702424',NULL)
insert into master_ter values ('T17440306301140','1702424',NULL)
insert into master_ter values ('T17440306300865','1702424',NULL)
insert into master_ter values ('T17440306301134','1702424',NULL)
insert into master_ter values ('T17440306300846','1702424',NULL)
insert into master_ter values ('T17440306300820','1702424',NULL)
insert into master_ter values ('T17440306300825','1702424',NULL)
insert into master_ter values ('T17440306301073','1702424',NULL)
insert into master_ter values ('T17440306301131','1702424',NULL)
insert into master_ter values ('T17440306300838','1702424',NULL)
insert into master_ter values ('T17440306301067','1702424',NULL)
insert into master_ter values ('T17440306301086','1702424',NULL)
insert into master_ter values ('T17440306300786','1702424',NULL)
insert into master_ter values ('T17440306301106','1702424',NULL)
insert into master_ter values ('T17440306301103','1702424',NULL)
insert into master_ter values ('T17440306300833','1702424',NULL)
insert into master_ter values ('T17440306301123','1702424',NULL)
insert into master_ter values ('T17440306301130','1702424',NULL)
insert into master_ter values ('T17440306301059','1702424',NULL)
insert into master_ter values ('T17440306300854','1702424',NULL)
insert into master_ter values ('T17440306300783','1702424',NULL)
insert into master_ter values ('T17440306300790','1702424',NULL)
insert into master_ter values ('T17440306301149','1702424',NULL)
insert into master_ter values ('T17440306300816','1702424',NULL)
insert into master_ter values ('T17440306301142','1702424',NULL)
insert into master_ter values ('T17440306300866','1702424',NULL)
insert into master_ter values ('T17440306300796','1702424',NULL)
insert into master_ter values ('T17440306301062','1702424',NULL)
insert into master_ter values ('T17440306301079','1702424',NULL)
insert into master_ter values ('T17440306301088','1702424',NULL)
insert into master_ter values ('T17440306300807','1702424',NULL)
insert into master_ter values ('T17440306300875','1702424',NULL)
insert into master_ter values ('T17440306301085','1702424',NULL)
insert into master_ter values ('T17440306301072','1702424',NULL)
insert into master_ter values ('T17440306300826','1702424',NULL)
insert into master_ter values ('T17440306301076','1702424',NULL)
insert into master_ter values ('T17440306300873','1702424',NULL)
insert into master_ter values ('T17440306301064','1702424',NULL)
insert into master_ter values ('T17440306300832','1702424',NULL)
insert into master_ter values ('T17440306301096','1702424',NULL)
insert into master_ter values ('T17440306300793','1702424',NULL)
insert into master_ter values ('T17440306300867','1702424',NULL)
insert into master_ter values ('T17440306300837','1702424',NULL)
insert into master_ter values ('T17440306300872','1702424',NULL)
insert into master_ter values ('T17440306300797','1702424',NULL)
insert into master_ter values ('T17440306300789','1702424',NULL)
insert into master_ter values ('T17440306300823','1702424',NULL)
insert into master_ter values ('T17440306301110','1702424',NULL)
insert into master_ter values ('T17440306300801','1702424',NULL)
insert into master_ter values ('T17440306300831','1702424',NULL)
insert into master_ter values ('T17440306301065','1702424',NULL)
insert into master_ter values ('T17440306300815','1702424',NULL)
insert into master_ter values ('T17440306301107','1702424',NULL)
insert into master_ter values ('T17440306301118','1702424',NULL)
insert into master_ter values ('T17440306300810','1702424',NULL)
insert into master_ter values ('T17440306301078','1702424',NULL)
insert into master_ter values ('T17440306300808','1702424',NULL)
insert into master_ter values ('T17440306300780','1702424',NULL)
insert into master_ter values ('T17440306301082','1702424',NULL)
insert into master_ter values ('T17440306301114','1702424',NULL)
insert into master_ter values ('T17440306301122','1702424',NULL)
insert into master_ter values ('T17440306300856','1702424',NULL)
insert into master_ter values ('T17440306300855','1702424',NULL)
insert into master_ter values ('T17440306301152','1702424',NULL)
insert into master_ter values ('T17440306301074','1702424',NULL)
insert into master_ter values ('T17440306301063','1702424',NULL)
insert into master_ter values ('T17440306301105','1702424',NULL)
insert into master_ter values ('T17440306300864','1702424',NULL)
insert into master_ter values ('T17440306301153','1702424',NULL)
insert into master_ter values ('T17440306300787','1702424',NULL)
insert into master_ter values ('T17440306301139','1702424',NULL)
insert into master_ter values ('T17440306300795','1702424',NULL)
insert into master_ter values ('T17440306301094','1702424',NULL)
insert into master_ter values ('T17440306300860','1702424',NULL)
insert into master_ter values ('T17440306301141','1702424',NULL)
insert into master_ter values ('T17440306301056','1702424',NULL)
insert into master_ter values ('T17440306301113','1702424',NULL)
insert into master_ter values ('T17440306300852','1702424',NULL)
insert into master_ter values ('T17440306301058','1702424',NULL)
insert into master_ter values ('T17440306301120','1702424',NULL)
insert into master_ter values ('T17440306301071','1702424',NULL)
insert into master_ter values ('T17440306301138','1702424',NULL)
insert into master_ter values ('T17440306301098','1702424',NULL)
insert into master_ter values ('T17440306301111','1702424',NULL)
insert into master_ter values ('T17440306300858','1702424',NULL)
insert into master_ter values ('T17440306301144','1702424',NULL)
insert into master_ter values ('T17440306300824','1702424',NULL)
insert into master_ter values ('T17440306300836','1702424',NULL)
insert into master_ter values ('T17440306301124','1702424',NULL)
insert into master_ter values ('T17440306300798','1702424',NULL)
insert into master_ter values ('T17440306300791','1702424',NULL)
insert into master_ter values ('T17440306300839','1702424',NULL)
insert into master_ter values ('T17440306300857','1702424',NULL)
insert into master_ter values ('T17440306301061','1702424',NULL)
insert into master_ter values ('T17440306300830','1702424',NULL)
insert into master_ter values ('T17440306301070','1702424',NULL)
insert into master_ter values ('T17440306301128','1702424',NULL)
insert into master_ter values ('T17440306301075','1702424',NULL)
insert into master_ter values ('T17440306261987','1702425',NULL)
insert into master_ter values ('T17440306293149','1702423',NULL)
insert into master_ter values ('T17440306293167','1702423',NULL)
insert into master_ter values ('T17440306301135','1702424',NULL)
insert into master_ter values ('T17440306300848','1702424',NULL)
insert into master_ter values ('T17440306300842','1702424',NULL)
insert into master_ter values ('T17440306301077','1702424',NULL)
insert into master_ter values ('T17440306300843','1702424',NULL)
insert into master_ter values ('T17440306300513','1702428',NULL)
insert into master_ter values ('T17440306300573','1702428',NULL)
insert into master_ter values ('T17440306300553','1702428',NULL)
insert into master_ter values ('T17440306261440','1702426',NULL)
insert into master_ter values ('T17440306300510','1702428',NULL)
insert into master_ter values ('T17440306300531','1702428',NULL)
insert into master_ter values ('T17440306300569','1702428',NULL)
insert into master_ter values ('T17440306300505','1702428',NULL)
insert into master_ter values ('T17440306300813','1702424',NULL)
insert into master_ter values ('T17440306300792','1702424',NULL)
insert into master_ter values ('T17440306301093','1702424',NULL)
insert into master_ter values ('T17440306301115','1702424',NULL)
insert into master_ter values ('T17440306301057','1702424',NULL)
insert into master_ter values ('T17440306300841','1702424',NULL)
insert into master_ter values ('T17440306300869','1702424',NULL)
insert into master_ter values ('T17440306301116','1702424',NULL)
insert into master_ter values ('T17440306300849','1702424',NULL)
insert into master_ter values ('T17440306301091','1702424',NULL)
insert into master_ter values ('T17440306261374','1702426',NULL)
insert into master_ter values ('T17440306300817','1702424',NULL)
insert into master_ter values ('T17440306301148','1702424',NULL)
insert into master_ter values ('T17440306261369','1702426',NULL)
insert into master_ter values ('T17440306261445','1702426',NULL)
insert into master_ter values ('T17440306261447','1702426',NULL)
insert into master_ter values ('T17440306261377','1702426',NULL)
insert into master_ter values ('T17440306261983','1702426',NULL)
insert into master_ter values ('T17440306261448','1702426',NULL)
insert into master_ter values ('T17440306261439','1702426',NULL)
insert into master_ter values ('T17440306261410','1702426',NULL)
insert into master_ter values ('T17440306261366','1702426',NULL)
insert into master_ter values ('T17440306261432','1702426',NULL)
insert into master_ter values ('T17440306261287','1702427',NULL)
insert into master_ter values ('T17440306261291','1702427',NULL)
insert into master_ter values ('T17440306261253','1702427',NULL)
insert into master_ter values ('T17440306261298','1702427',NULL)
insert into master_ter values ('T17440306261302','1702427',NULL)
insert into master_ter values ('T17440306261356','1702427',NULL)
insert into master_ter values ('T17440306261264','1702427',NULL)
insert into master_ter values ('T17440306261350','1702427',NULL)
insert into master_ter values ('T17440306261312','1702427',NULL)
insert into master_ter values ('T17440306261304','1702427',NULL)
insert into master_ter values ('T17440306261319','1702427',NULL)
insert into master_ter values ('T17440306261235','1702427',NULL)
insert into master_ter values ('T17440306261320','1702427',NULL)
insert into master_ter values ('T17440306293155','1702423',NULL)
insert into master_ter values ('T17440306293182','1702423',NULL)
insert into master_ter values ('T17440306300576','1702428',NULL)
insert into master_ter values ('T17440306300571','1702428',NULL)
insert into master_ter values ('T17440306300509','1702428',NULL)
insert into master_ter values ('T17440306301121','1702424',NULL)
insert into master_ter values ('T17440306293158','1702423',NULL)
insert into master_ter values ('T17440306261267','1702427',NULL)
insert into master_ter values ('T17440306261293','1702427',NULL)
insert into master_ter values ('T17440306261247','1702427',NULL)
insert into master_ter values ('T17440306261329','1702427',NULL)
insert into master_ter values ('T17440306261338','1702427',NULL)
insert into master_ter values ('T17440306261249','1702427',NULL)
insert into master_ter values ('T17440306261405','1702426',NULL)
insert into master_ter values ('T17440306301097','1702424',NULL)
insert into master_ter values ('T17440306300802','1702424',NULL)
insert into master_ter values ('T17440306300503','1702428',NULL)
insert into master_ter values ('T17440306300532','1702428',NULL)
insert into master_ter values ('T17440306300561','1702428',NULL)
insert into master_ter values ('T17440306300550','1702428',NULL)
insert into master_ter values ('T17440306300529','1702428',NULL)
insert into master_ter values ('T17440306293191','1702423',NULL)
insert into master_ter values ('T17440306293185','1702423',NULL)
insert into master_ter values ('T17440306261401','1702426',NULL)
insert into master_ter values ('T17440306261289','1702427',NULL)
insert into master_ter values ('T17440306261296','1702427',NULL)
insert into master_ter values ('T17440306261240','1702427',NULL)
insert into master_ter values ('T17440306261322','1702427',NULL)
insert into master_ter values ('T17440306261337','1702427',NULL)
insert into master_ter values ('T17440306261333','1702427',NULL)
insert into master_ter values ('T17440306293166','1702423',NULL)
insert into master_ter values ('T17440306293174','1702423',NULL)
insert into master_ter values ('T17440306261397','1702426',NULL)
insert into master_ter values ('T17440306261984','1702426',NULL)
insert into master_ter values ('T17440306261451','1702426',NULL)
insert into master_ter values ('T17440306300781','1702424',NULL)
insert into master_ter values ('T17440306301132','1702424',NULL)
insert into master_ter values ('T17440306301146','1702424',NULL)
insert into master_ter values ('T17440306293194','1702423',NULL)
insert into master_ter values ('T17440306301101','1702424',NULL)
insert into master_ter values ('T17440306300800','1702424',NULL)
insert into master_ter values ('T17440306300533','1702428',NULL)
insert into master_ter values ('T17440306300582','1702428',NULL)
insert into master_ter values ('T17440306262005','1702425',NULL)
insert into master_ter values ('T17440306262006','1702425',NULL)
insert into master_ter values ('T17440306261279','1702427',NULL)
insert into master_ter values ('T17440306261353','1702427',NULL)
insert into master_ter values ('T17440306261238','1702427',NULL)
insert into master_ter values ('T17440306261263','1702427',NULL)
insert into master_ter values ('T17440306261349','1702427',NULL)
insert into master_ter values ('T17440306261262','1702427',NULL)
insert into master_ter values ('T17440306300877','1702424',NULL)
insert into master_ter values ('T17440306300853','1702424',NULL)
insert into master_ter values ('T17440306301069','1702424',NULL)
insert into master_ter values ('T17440306301089','1702424',NULL)
insert into master_ter values ('T17440306300829','1702424',NULL)
insert into master_ter values ('T17440306300828','1702424',NULL)
insert into master_ter values ('T17440306300521','1702428',NULL)
insert into master_ter values ('T17440306293170','1702423',NULL)
insert into master_ter values ('T17440306293144','1702423',NULL)
insert into master_ter values ('T17440306293163','1702423',NULL)
insert into master_ter values ('T17440306293168','1702423',NULL)
insert into master_ter values ('T17440306293176','1702423',NULL)
insert into master_ter values ('T17440306261398','1702426',NULL)
insert into master_ter values ('T17440306261390','1702426',NULL)
insert into master_ter values ('T17440306261252','1702427',NULL)
insert into master_ter values ('T17440306261449','1702426',NULL)
insert into master_ter values ('T17440306261386','1702426',NULL)
insert into master_ter values ('T17440306261365','1702426',NULL)
insert into master_ter values ('T17440306261431','1702426',NULL)
insert into master_ter values ('T17440306301125','1702424',NULL)
insert into master_ter values ('T17440306301104','1702424',NULL)
insert into master_ter values ('T17440306300579','1702428',NULL)
insert into master_ter values ('T17440306300495','1702428',NULL)
insert into master_ter values ('T17440306300516','1702428',NULL)
insert into master_ter values ('T17440306261261','1702427',NULL)
insert into master_ter values ('T17440306261327','1702427',NULL)
insert into master_ter values ('T17440306261326','1702427',NULL)
insert into master_ter values ('T17440306261278','1702427',NULL)
insert into master_ter values ('T17440306261389','1702426',NULL)
insert into master_ter values ('T17440306301119','1702424',NULL)
insert into master_ter values ('T17440306300876','1702424',NULL)
insert into master_ter values ('T17440306301087','1702424',NULL)
insert into master_ter values ('T17440306301108','1702424',NULL)
insert into master_ter values ('T17440306293153','1702423',NULL)
insert into master_ter values ('T17440306293173','1702423',NULL)
insert into master_ter values ('T17440306300784','1702424',NULL)
insert into master_ter values ('T17440306301090','1702424',NULL)
insert into master_ter values ('T17440306300806','1702424',NULL)
insert into master_ter values ('T17440306261321','1702427',NULL)
insert into master_ter values ('T17440306261259','1702427',NULL)
insert into master_ter values ('T17440306261270','1702427',NULL)
insert into master_ter values ('T17440306293192','1702423',NULL)
insert into master_ter values ('T17440306293138','1702423',NULL)
insert into master_ter values ('T17440306261998','1702425',NULL)
insert into master_ter values ('T17440306262001','1702425',NULL)
insert into master_ter values ('T17440306261367','1702426',NULL)
insert into master_ter values ('T17440306261453','1702426',NULL)
insert into master_ter values ('T17440306261370','1702426',NULL)
insert into master_ter values ('T17440306261457','1702426',NULL)
insert into master_ter values ('T17440306293187','1702423',NULL)
insert into master_ter values ('T17440306301147','1702424',NULL)
insert into master_ter values ('T17440306300834','1702424',NULL)
insert into master_ter values ('T17440306300811','1702424',NULL)
insert into master_ter values ('T17440306300861','1702424',NULL)
insert into master_ter values ('T17440306300874','1702424',NULL)
insert into master_ter values ('T17440306300590','1702428',NULL)
insert into master_ter values ('T17440306300502','1702428',NULL)
insert into master_ter values ('T17440306301060','1702424',NULL)
insert into master_ter values ('T17440306301129','1702424',NULL)
insert into master_ter values ('T17440306300821','1702424',NULL)
insert into master_ter values ('T17440306301109','1702424',NULL)
insert into master_ter values ('T17440306261309','1702427',NULL)
insert into master_ter values ('T17440306261357','1702427',NULL)
insert into master_ter values ('T17440306300580','1702428',NULL)
insert into master_ter values ('T17440306300556','1702428',NULL)
insert into master_ter values ('T17440306300528','1702428',NULL)
insert into master_ter values ('T17440306261436','1702426',NULL)
insert into master_ter values ('T17440306261328','1702427',NULL)
insert into master_ter values ('T17440306300577','1702428',NULL)
insert into master_ter values ('T17440306300519','1702428',NULL)
insert into master_ter values ('T17440306300581','1702428',NULL)
insert into master_ter values ('T17440306261301','1702427',NULL)
insert into master_ter values ('T17440306261266','1702427',NULL)
insert into master_ter values ('T17440306261317','1702427',NULL)
insert into master_ter values ('T17440306300782','1702424',NULL)
insert into master_ter values ('T17440306300812','1702424',NULL)
insert into master_ter values ('T17440306301136','1702424',NULL)
insert into master_ter values ('T17440306301099','1702424',NULL)
insert into master_ter values ('T17440306300511','1702428',NULL)
insert into master_ter values ('T17440306300546','1702428',NULL)
insert into master_ter values ('T17440306293148','1702423',NULL)
insert into master_ter values ('T17440306293169','1702423',NULL)
insert into master_ter values ('T17440306261990','1702425',NULL)
insert into master_ter values ('T17440306261330','1702427',NULL)
insert into master_ter values ('T17440306300862','1702424',NULL)
insert into master_ter values ('T17440306300835','1702424',NULL)
insert into master_ter values ('T17440306300785','1702424',NULL)
insert into master_ter values ('T17440306300788','1702424',NULL)
insert into master_ter values ('T17440306300851','1702424',NULL)
insert into master_ter values ('T17440306301126','1702424',NULL)
insert into master_ter values ('T17440306301150','1702424',NULL)
insert into master_ter values ('T17440306301133','1702424',NULL)
insert into master_ter values ('T17440306300567','1702428',NULL)
insert into master_ter values ('T17440306300520','1702428',NULL)
insert into master_ter values ('T17440306300552','1702428',NULL)
insert into master_ter values ('T17440306300583','1702428',NULL)
insert into master_ter values ('T17440306300515','1702428',NULL)
insert into master_ter values ('T17440306293156','1702423',NULL)
insert into master_ter values ('T17440306262004','1702425',NULL)
insert into master_ter values ('T17440306261255','1702427',NULL)
insert into master_ter values ('T17440306261305','1702427',NULL)
insert into master_ter values ('T17440306261343','1702427',NULL)
insert into master_ter values ('T17440306261412','1702426',NULL)
insert into master_ter values ('H17331007136449','1605493',NULL)
insert into master_ter values ('H17331007136586','1605493',NULL)
insert into master_ter values ('H17331007136524','1605493',NULL)
insert into master_ter values ('H17331007136245','1605493',NULL)
insert into master_ter values ('H17331007136428','1605493',NULL)
insert into master_ter values ('H17331007136433','1605493',NULL)
insert into master_ter values ('H17331007136511','1605493',NULL)
insert into master_ter values ('H17331007136527','1605493',NULL)
insert into master_ter values ('H17331007136528','1605493',NULL)
insert into master_ter values ('H17331007136445','1605493',NULL)
第三步:
select mt.atom_code,orgn.type
from ORGANIZATION orgn ,master_ter mt,Territory ter
where mt.ser_ter_id = ter.ter_name and ter.org_id = orgn.id and orgn.type != 4;
--如果关联的出来的架构(ORGANIZATION的type='4')是DSS=====================
UPDATE m SET m.REC_TIME_STAMP=GETDATE(),m.Unit=NULL,
m.DSS=s.code,m.sel_ter_id=s.id,m.Dealer_Code=s.customer_code,
m.Sharp_ID=s.sharp_id,m.Customer_Person=s.employee_name_cn
FROM Master_Store m,
(SELECT o.code,o.customer_code,t.id,mt.atom_code,
s.sharp_id,s.employee_name_cn FROM master_ter mt join Territory t on mt.ser_ter_id = t.ter_name join ORGANIZATION o
on t.org_id=o.id and type =4 left join SYS_USER s on t.sharp_id=s.sharp_id) s
where m.ATOM_CODE=s.atom_code
UPDATE m SET m.REC_TIME_STAMP=GETDATE(),m.Unit=NULL,
m.DSS=s.code,m.mer_ter_id=s.id,m.Dealer_Code=s.customer_code,
m.Sharp_ID=s.sharp_id,m.Customer_Person=s.employee_name_cn
FROM Master_Store m,
(SELECT o.code,o.customer_code,t.id,mt.atom_code,
s.sharp_id,s.employee_name_cn FROM master_ter mt join Territory t on mt.mer_ter_id= t.ter_name join ORGANIZATION o
on t.org_id=o.id left join SYS_USER s on t.sharp_id=s.sharp_id ) s
where m.ATOM_CODE=s.atom_code
--如果关联的出来的架构(ORGANIZATION的type='1')是UNIT===================
UPDATE m SET m.REC_TIME_STAMP=GETDATE(),m.Unit=s.code,m.DSS=NULL,
m.sel_ter_id=s.id,m.Sharp_ID=s.sharp_id,m.Customer_Person=s.employee_name_cn
FROM Master_Store m,
(SELECT o.code,o.customer_code,t.id,mt.atom_code,
s.sharp_id,s.employee_name_cn FROM master_ter mt join Territory t on mt.ser_ter_id = t.ter_name join ORGANIZATION o
on t.org_id=o.id and type =1 left join SYS_USER s on t.sharp_id=s.sharp_id ) s
where m.ATOM_CODE=s.atom_code
--select m.sel_ter_id,m.Atom_code,mt.atom_code,mt.ser_ter_id from Master_Store m,master_ter mt where m.Atom_code = mt.atom_code;