快递100物流公司对照表
快递100物流公司是通过 T_BD_KD100LOGISTICSCOM 表示,由于历史原因,通版是分批次添加相关记录(而且不排除后续新还会再添加新的物流公司),很多客户可能在'快递100物流公司列表'中不小心手工删除了通版的记录,或者修改了物流公司名称,但后续可能想恢复回来却找不回对应记录。本文记录了通版的物流公司内码(星空基础资料主键),物流公司编码,物流公司名称对照关系及对应补丁号。
初始添加,由于历史原因初始版本占用了100001+的ID:
-------------------------------------- PT106397_K3CloudV6.0_BD_Data.sql --------------------------------------
DELETE FROM T_BD_KD100LOGISTICSCOM; INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100001,'邮政包裹/平邮','youzhengguonei'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100002,'国际包裹','youzhengguoji'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100003,'EMS','ems'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100004,'EMS-国际件','emsguoji'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100005,'EMS-国际件-英文结果','emsinten'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100006,'北京EMS','bjemstckj'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100007,'顺丰','shunfeng'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100008,'申通','shentong'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100009,'圆通','yuantong'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100010,'中通','zhongtong'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100011,'汇通','huitongkuaidi'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100012,'韵达','yunda'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100013,'宅急送','zhaijisong'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100014,'天天','tiantian'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100015,'德邦','debangwuliu'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100016,'国通','guotongkuaidi'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100017,'增益','zengyisudi'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100018,'速尔','suer'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100019,'中铁物流','ztky'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100020,'中铁快运','zhongtiewuliu'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100021,'能达','ganzhongnengda'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100022,'优速','youshuwuliu'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100023,'全峰','quanfengkuaidi'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100024,'京东','jd'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100025,'FedEx-国际','fedex'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100026,'FedEx-美国','fedexus'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100027,'DHL全球件','dhlen'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100028,'DHL','dhl'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100029,'DHL-德国','dhlde'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100030,'TNT全球件','tnten'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100031,'TNT','tnt'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100032,'UPS全球件','upsen'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100033,'UPS','ups'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100034,'USPS','usps'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100035,'DPD','dpd'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100036,'DPD Germany','dpdgermany'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100037,'DPD Poland','dpdpoland'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100038,'DPD UK','dpduk'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100039,'GLS','gls'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100040,'Toll','dpexen'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100041,'Toll Priority(Toll Online)','tollpriority'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100042,'Aramex','aramex'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100043,'DPEX','dpex'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100044,'宅急便','zhaijibian'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100045,'黑猫雅玛多','yamato'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100046,'香港邮政(HongKong Post)','hkpost'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100047,'英国大包、EMS(Parcel Force)','parcelforce'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100048,'英国小包(Royal Mail)','royalmail'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100049,'澳大利亚邮政-英文','auspost'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100050,'加拿大邮政-英文版','canpost'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100051,'一统飞鸿','yitongfeihong'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100052,'如风达','rufengda'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100053,'海红网送','haihongwangsong'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100054,'通和天下','tonghetianxia'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100055,'郑州建华','zhengzhoujianhua'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100056,'红马甲','sxhongmajia'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100057,'芝麻开门','zhimakaimen'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100058,'乐捷递','lejiedi'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100059,'立即送','lijisong'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100060,'银捷','yinjiesudi'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100061,'门对门','menduimen'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100062,'河北建华','hebeijianhua'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100063,'微特派','weitepai'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100064,'风行天下','fengxingtianxia'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100065,'尚橙','shangcheng'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100066,'新蛋奥硕','neweggozzo'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100067,'鑫飞鸿','xinhongyukuaidi'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100068,'全一','quanyikuaidi'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100069,'彪记','biaojikuaidi'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100070,'星晨急便','xingchengjibian'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100071,'亚风','yafengsudi'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100072,'源伟丰','yuanweifeng'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100073,'全日通','quanritongkuaidi'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100074,'安信达','anxindakuaixi'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100075,'民航','minghangkuaidi'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100076,'凤凰','fenghuangkuaidi'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100077,'京广','jinguangsudikuaijian'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100078,'配思货运','peisihuoyunkuaidi'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100079,'AAE-中国件','aae'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100080,'大田','datianwuliu'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100081,'新邦','xinbangwuliu'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100082,'龙邦','longbanwuliu'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100083,'一邦','yibangwuliu'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100084,'联昊通','lianhaowuliu'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100085,'广东邮政','guangdongyouzhengwuliu'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100086,'中邮','zhongyouwuliu'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100087,'天地华宇','tiandihuayu'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100088,'盛辉','shenghuiwuliu'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100089,'长宇','changyuwuliu'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100090,'飞康达','feikangda'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100091,'元智捷诚','yuanzhijiecheng'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100092,'万家','wanjiawuliu'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100093,'远成','yuanchengwuliu'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100094,'信丰','xinfengwuliu'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100095,'文捷航空','wenjiesudi'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100096,'全晨','quanchenkuaidi'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100097,'佳怡','jiayiwuliu'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100098,'快捷','kuaijiesudi'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100099,'D速','dsukuaidi'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100100,'全际通','quanjitong'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100101,'青岛安捷','anjiekuaidi'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100102,'越丰','yuefengwuliu'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100103,'急先达','jixianda'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100104,'百福东方','baifudongfang'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100105,'BHT','bht'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100106,'伍圆','wuyuansudi'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100107,'蓝镖','lanbiaokuaidi'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100108,'COE','coe'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100109,'南京100','nanjing'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100110,'恒路','hengluwuliu'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100111,'金大','jindawuliu'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100112,'华夏龙','huaxialongwuliu'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100113,'运通中港','yuntongkuaidi'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100114,'佳吉','jiajiwuliu'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100115,'盛丰','shengfengwuliu'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100116,'源安达','yuananda'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100117,'加运美','jiayunmeiwuliu'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100118,'万象','wanxiangwuliu'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100119,'宏品','hongpinwuliu'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100120,'上大','shangda'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100121,'中铁','zhongtiewuliu'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100122,'原飞航','yuanfeihangwuliu'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100123,'海外环球','haiwaihuanqiu'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100124,'三态','santaisudi'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100125,'晋越','jinyuekuaidi'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100126,'联邦','lianbangkuaidi'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100127,'飞快达','feikuaida'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100128,'忠信达','zhongxinda'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100129,'共速达','gongsuda'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100130,'嘉里大通','jialidatong'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100131,'OCS','ocs'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100132,'美国','meiguokuaidi'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100133,'成都立即送','lijisong'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100134,'递四方','disifang'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100135,'康力','kangliwuliu'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100136,'跨越','kuayue'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100137,'海盟','haimengsudi'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100138,'圣安','shenganwuliu'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100139,'中速','zhongsukuaidi'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100140,'OnTrac','ontrac'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100141,'七天连锁','sevendays'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100142,'明亮','mingliangwuliu'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100143,'凡客配送(作废)','vancl'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100144,'华企','huaqikuaiyun'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100145,'城市100','city100'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100146,'穗佳','suijiawuliu'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100147,'飞豹','feibaokuaidi'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100148,'传喜','chuanxiwuliu'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100149,'捷特','jietekuaidi'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100150,'隆浪','longlangkuaidi'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100151,'EMS-英文','emsen'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100152,'中天万运','zhongtianwanyun'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100153,'邦送','bangsongwuliu'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100154,'澳大利亚(Australia Post)','auspost'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100155,'加拿大(Canada Post)','canpost'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100156,'加拿大邮政','canpostfr'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100157,'顺丰-美国件','shunfengen'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100158,'汇强','huiqiangkuaidi'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100159,'希优特','xiyoutekuaidi'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100160,'昊盛','haoshengwuliu'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100161,'亿领','yilingsuyun'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100162,'大洋','dayangwuliu'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100163,'递达','didasuyun'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100164,'易通达','yitongda'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100165,'邮必佳','youbijia'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100166,'亿顺航','yishunhang'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100167,'飞狐','feihukuaidi'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100168,'潇湘晨报','xiaoxiangchenbao'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100169,'巴伦支','balunzhi'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100170,'闽盛','minshengkuaidi'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100171,'佳惠尔','syjiahuier'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100172,'民邦','minbangsudi'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100173,'上海快通','shanghaikuaitong'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100174,'北青小红帽','xiaohongmao'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100175,'GSM','gsm'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100176,'安能','annengwuliu'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100177,'KCS','kcs'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100178,'City-Link','citylink'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100179,'店通','diantongkuaidi'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100180,'凡宇','fanyukuaidi'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100181,'平安达腾飞','pingandatengfei'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100182,'广东通路','guangdongtonglu'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100183,'中睿','zhongruisudi'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100184,'快达','kuaidawuliu'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100185,'ADP国际','adp'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100186,'颿达国际','fardarww'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100187,'颿达国际-英文','fandaguoji'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100188,'林道国际','shlindao'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100189,'中外运-中文','sinoex'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100190,'中外运','zhongwaiyun'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100191,'深圳德创','dechuangwuliu'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100192,'林道国际-英文','ldxpres'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100193,'瑞典(Sweden Post)','ruidianyouzheng'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100194,'PostNord(Posten AB)','postenab'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100195,'偌亚奥国际','nuoyaao'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100196,'祥龙运通','xianglongyuntong'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100197,'品速心达','pinsuxinda'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100198,'宇鑫','yuxinwuliu'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100199,'陪行','peixingwuliu'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100200,'户通','hutongwuliu'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100201,'西安城联','xianchengliansudi'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100202,'煜嘉','yujiawuliu'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100203,'一柒国际','yiqiguojiwuliu'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100204,'Fedex-国际件-中文','fedexcn'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100205,'联邦-英文','lianbangkuaidien'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100206,'中通(带电话)','zhongtongphone'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100207,'赛澳递for买卖宝','saiaodimmb'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100208,'上海无疆for买卖宝','shanghaiwujiangmmb'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100209,'新加坡小包(Singapore Post)','singpost'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100210,'音素','yinsu'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100211,'南方传媒','ndwl'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100212,'速呈宅配','sucheng'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100213,'创一','chuangyi'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100214,'云南滇驿','dianyi'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100215,'重庆星程','cqxingcheng'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100216,'四川星程','scxingcheng'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100217,'贵州星程','gzxingcheng'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100218,'运通中港(作废)','ytkd'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100219,'Gati-英文','gatien'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100220,'Gati-中文','gaticn'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100221,'jcex','jcex'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100222,'派尔','peex'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100223,'凯信达','kxda'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100224,'安达信','advancing'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100225,'汇文','huiwen'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100226,'亿翔','yxexpress'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100227,'东红','donghong'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100228,'飞远配送','feiyuanvipshop'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100229,'好运来','hlyex'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100230,'四川快优达','kuaiyouda'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100231,'日昱','riyuwuliu'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100232,'速通','sutongwuliu'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100233,'晟邦','nanjingshengbang'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100234,'爱尔兰(An Post)','anposten'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100235,'日本(Japan Post)','japanposten'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100236,'丹麦(Post Denmark)','postdanmarken'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100237,'巴西(Brazil Post/Correios)','brazilposten'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100238,'荷兰挂号信(PostNL international registered mail)','postnlcn'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100239,'荷兰挂号信(PostNL international registered mail)','postnl'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100240,'乌克兰EMS-中文(EMS Ukraine)','emsukrainecn'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100241,'乌克兰EMS(EMS Ukraine)','emsukraine'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100242,'乌克兰邮政包裹','ukrpostcn'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100243,'乌克兰小包、大包(UkrPost)','ukrpost'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100244,'海红for买卖宝','haihongmmb'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100245,'FedEx-英国件(FedEx UK)','fedexuk'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100246,'FedEx-英国件','fedexukcn'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100247,'叮咚','dingdong'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100248,'UPS Freight','upsfreight'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100249,'ABF','abf'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100250,'Purolator','purolator'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100251,'比利时(Bpost)','bpost'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100252,'比利时国际(Bpost international)','bpostinter'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100253,'LaserShip','lasership'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100254,'YODEL','yodel'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100255,'DHL-荷兰(DHL Netherlands)','dhlnetherlands'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100256,'MyHermes','myhermes'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100257,'Fastway Ireland','fastway'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100258,'法国大包、EMS-法文(Chronopost France)','chronopostfra'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100259,'Selektvracht','selektvracht'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100260,'蓝弧','lanhukuaidi'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100261,'比利时(Belgium Post)','belgiumpost'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100262,'UPS Mail Innovations','upsmailinno'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100263,'挪威(Posten Norge)','postennorge'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100264,'瑞士邮政','swisspostcn'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100265,'瑞士(Swiss Post)','swisspost'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100266,'英国邮政小包','royalmailcn'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100267,'DHL Benelux','dhlbenelux'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100268,'Nova Poshta','novaposhta'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100269,'DHL-波兰(DHL Poland)','dhlpoland'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100270,'Estes','estes'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100271,'TNT UK','tntuk'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100272,'Deltec Courier','deltec'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100273,'OPEK','opek'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100274,'Italy SDA','italysad'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100275,'MRW','mrw'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100276,'Chronopost Portugal','chronopostport'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100277,'西班牙(Correos de Espa?a)','correosdees'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100278,'Direct Link','directlink'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100279,'ELTA Hellenic Post','eltahell'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100280,'捷克(?eská po?ta)','ceskaposta'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100281,'Siodemka','siodemka'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100282,'International Seur','seur'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100283,'久易','jiuyicn'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100284,'克罗地亚(Hrvatska Posta)','hrvatska'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100285,'保加利亚(Bulgarian Posts)','bulgarian'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100286,'Portugal Seur','portugalseur'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100287,'EC-Firstclass','ecfirstclass'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100288,'DTDC India','dtdcindia'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100289,'Safexpress','safexpress'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100290,'韩国(Korea Post)','koreapost'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100291,'TNT Australia','tntau'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100292,'泰国(Thailand Thai Post)','thailand'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100293,'SkyNet Malaysia','skynetmalaysia'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100294,'马来西亚小包(Malaysia Post(Registered))','malaysiapost'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100295,'马来西亚大包、EMS(Malaysia Post(parcel,EMS))','malaysiaems'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100296,'沙特阿拉伯(Saudi Post)','saudipost'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100297,'南非(South African Post Office)','southafrican'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100298,'OCA Argentina','ocaargen'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100299,'尼日利亚(Nigerian Postal)','nigerianpost'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100300,'智利(Correos Chile)','chile'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100301,'以色列(Israel Post)','israelpost'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100302,'Estafeta','estafeta'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100303,'港快','gdkd'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100304,'墨西哥(Correos de Mexico)','mexico'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100305,'罗马尼亚(Posta Romanian)','romanian'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100306,'TNT Italy','tntitaly'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100307,'Mexico Multipack','multipack'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100308,'葡萄牙(Portugal CTT)','portugalctt'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100309,'Interlink Express','interlink'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100310,'华航','hzpl'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100311,'Gati-KWE','gatikwe'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100312,'Red Express','redexpress'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100313,'Mexico Senda Express','mexicodenda'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100314,'TCI XPS','tcixps'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100315,'高铁','hre'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100316,'新加坡EMS、大包(Singapore Speedpost)','speedpost'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100317,'EMS-国际件-英文','emsinten'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100318,'Asendia USA','asendiausa'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100319,'法国大包、EMS-英文(Chronopost France)','chronopostfren'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100320,'意大利(Poste Italiane)','italiane'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100321,'冠达','gda'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100322,'出口易','chukou1'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100323,'黄马甲','huangmajia'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100324,'新干线','anlexpress'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100325,'飞洋','shipgce'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100326,'贝海国际','xlobo'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100327,'阿联酋(Emirates Post)','emirates'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100328,'新顺丰(NSF)','nsf'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100329,'巴基斯坦(Pakistan Post)','pakistan'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100330,'世运','shiyunkuaidi'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100331,'合众(UCS)','ucs'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100332,'阿富汗(Afghan Post)','afghan'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100333,'白俄罗斯(Belpochta)','belpost'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100334,'全通','quantwl'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100335,'EFS Post','efs'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100336,'TNT Post','tntpostcn'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100337,'英脉','gml'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100338,'广通','gtongsudi'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100339,'东瀚','donghanwl'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100340,'rpx','rpx'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100341,'日日顺','rrs'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100342,'华通','htongexpress'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100343,'吉尔吉斯斯坦(Kyrgyz Post)','kyrgyzpost'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100344,'拉脱维亚(Latvijas Pasts)','latvia'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100345,'黎巴嫩(Liban Post)','libanpost'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100346,'立陶宛(Lietuvos pa?tas)','lithuania'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100347,'马尔代夫(Maldives Post)','maldives'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100348,'马耳他(Malta Post)','malta'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100349,'马其顿(Macedonian Post)','macedonia'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100350,'新西兰(New Zealand Post)','newzealand'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100351,'摩尔多瓦(Posta Moldovei)','moldova'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100352,'孟加拉国(EMS)','bangladesh'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100353,'塞尔维亚(PE Post of Serbia)','serbia'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100354,'塞浦路斯(Cyprus Post)','cypruspost'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100355,'突尼斯EMS(Rapid-Poste)','tunisia'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100356,'乌兹别克斯坦(Post of Uzbekistan)','uzbekistan'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100357,'新喀里多尼亚[法国](New Caledonia)','caledonia'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100358,'叙利亚(Syrian Post)','republic'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100359,'亚美尼亚(Haypost-Armenian Postal)','haypost'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100360,'也门(Yemen Post)','yemen'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100361,'印度(India Post)','india'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100362,'英国(大包,EMS)','england'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100363,'约旦(Jordan Post)','jordan'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100364,'越南小包(Vietnam Posts)','vietnam'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100365,'黑山(Po?ta Crne Gore)','montenegro'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100366,'哥斯达黎加(Correos de Costa Rica)','correos'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100367,'西安喜来','xilaikd'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100368,'格陵兰[丹麦](TELE Greenland A/S)','greenland'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100369,'菲律宾(Philippine Postal)','phlpost'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100370,'厄瓜多尔(Correos del Ecuador)','ecuador'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100371,'冰岛(Iceland Post)','iceland'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100372,'波兰小包(Poczta Polska)','emonitoring'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100373,'阿尔巴尼亚(Posta shqipatre)','albania'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100374,'阿鲁巴[荷兰](Post Aruba)','aruba'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100375,'埃及(Egypt Post)','egypt'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100376,'爱沙尼亚(Eesti Post)','omniva'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100377,'云豹国际货运','leopard'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100378,'中外运空运','sinoairinex'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100379,'上海昊宏国际货物','hyk'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100380,'城晓国际','ckeex'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100381,'匈牙利(Magyar Posta)','hungary'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100382,'澳门(Macau Post)','macao'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100383,'台湾(中华邮政)','postserv'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100384,'快淘','kuaitao'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100385,'秘鲁(SERPOST)','peru'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100386,'印度尼西亚EMS(Pos Indonesia-EMS)','indonesia'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100387,'哈萨克斯坦(Kazpost)','kazpost'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100388,'立白宝凯','lbbk'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100389,'百千诚','bqcwl'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100390,'皇家','pfcexpress'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100391,'法国(La Poste)','csuivi'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100392,'奥地利(Austrian Post)','austria'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100393,'乌克兰小包、大包(UkrPoshta)','ukraine'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100394,'乌干达(Posta Uganda)','uganda'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100395,'阿塞拜疆EMS(EMS AzerExpressPost)','azerbaijan'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100396,'芬兰(Itella Posti Oy)','finland'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100397,'斯洛伐克(Slovenská Posta)','slovak'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100398,'埃塞俄比亚(Ethiopian postal)','ethiopia'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100399,'卢森堡(Luxembourg Post)','luxembourg'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100400,'毛里求斯(Mauritius Post)','mauritius'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100401,'文莱(Brunei Postal)','brunei'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100402,'Quantium','quantium'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100403,'坦桑尼亚(Tanzania Posts)','tanzania'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100404,'阿曼(Oman Post)','oman'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100405,'直布罗陀[英国]( Royal Gibraltar Post)','gibraltar'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100406,'博源恒通','byht'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100407,'越南EMS(VNPost Express)','vnpost'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100408,'安迅','anxl'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100409,'达方','dfpost'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100410,'兰州伙伴','huoban'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100411,'天纵','tianzong'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100412,'波黑(JP BH Posta)','bohei'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100413,'玻利维亚','bolivia'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100414,'柬埔寨(Cambodia Post)','cambodia'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100415,'巴林(Bahrain Post)','bahrain'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100416,'纳米比亚(NamPost)','namibia'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100417,'卢旺达(Rwanda i-posita)','rwanda'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100418,'莱索托(Lesotho Post)','lesotho'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100419,'肯尼亚(POSTA KENYA)','kenya'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100420,'喀麦隆(CAMPOST)','cameroon'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100421,'伯利兹(Belize Postal)','belize'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100422,'巴拉圭(Correo Paraguayo)','paraguay'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100423,'十方通','sfift'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100424,'飞鹰','hnfy'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100425,'UPS i-parcle','iparcel'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100426,'鑫锐达','bjxsrd'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100427,'麦力','mailikuaidi'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100428,'瑞丰','rfsd'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100429,'美联','letseml'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100430,'CNPEX中邮','cnpex'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100431,'鑫世锐达','xsrd'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100432,'同舟行','chinatzx'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100433,'秦邦','qbexpress'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100434,'大达','idada'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100435,'skynet','skynet'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100436,'红马','nedahm'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100437,'云南中诚','czwlyn'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100438,'万博','wanboex'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100439,'腾达','nntengda'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100440,'郑州速捷','sujievip'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100441,'UBI Australia','gotoubi'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100442,'ECMS Express','ecmsglobal'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100443,'速派(FastGo)','fastgo'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100444,'易客满','ecmscn'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100445,'俄顺达','eshunda'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100446,'广东速腾','suteng'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100447,'新鹏','gdxp'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100448,'美国韵达','yundaexus'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100449,'深圳DPEX','szdpex'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100450,'百世','baishiwuliu'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100451,'荷兰包裹(PostNL International Parcels)','postnlpacle'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100452,'乐天','ltexp'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100453,'智通','ztong'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100454,'鑫通宝','xtb'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100455,'airpak expresss','airpak'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100456,'荷兰邮政-中国件','postnlchina'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100457,'法国小包(colissimo)','colissimo'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100458,'PCA Express','pcaexpress'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100459,'韩润','hanrun'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100460,'中远e环球','cosco'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100461,'顺达','sundarexpress'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100462,'捷记方舟','ajexpress'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100463,'方舟','arkexpress'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100464,'明大','adaexpress'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100465,'长江国际','changjiang'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100466,'八达通','bdatong'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100467,'美国申通','stoexpress'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100468,'泛捷国际','epanex'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100469,'顺捷丰达','shunjiefengda'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100470,'华赫','nmhuahe'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100471,'德国(Deutsche Post)','deutschepost'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100472,'百腾','baitengwuliu'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100473,'品骏','pjbest'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100474,'全速通','quansutong'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100475,'中技','zhongjiwuliu'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100476,'九曳供应链','jiuyescm'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100477,'天翼','tykd'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100478,'德意思','dabei'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100479,'城际','chengji'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100480,'程光','chengguangkuaidi'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100481,'佐川急便','sagawa'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100482,'蓝天','lantiankuaidi'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100483,'永昌','yongchangwuliu'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100484,'笨鸟海淘','birdex'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100485,'一正达','yizhengdasuyun'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100486,'优配','sdyoupei'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100487,'TRAKPAK','trakpak'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100488,'GTS','gts'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100489,'AOL澳通','aolau'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100490,'宜送','yiex'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100491,'通达兴','tongdaxing'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100492,'香港(HongKong Post)英文','hkposten'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100493,'飞力士','flysman'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100494,'转运四方','zhuanyunsifang'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100495,'logen路坚','ilogen'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100496,'成都东骏','dongjun'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100497,'日本郵便','japanpost'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100498,'佳家通货运','jiajiatong56'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100499,'吉日优派','jrypex'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100500,'西安胜峰','xaetc'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100501,'CJ','doortodoor'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100502,'信天捷','xintianjie'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100503,'泰国138国际','sd138'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100504,'猴急送','hjs'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100505,'全信通','quanxintong'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100506,'amazon-国际订单','amusorder'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100507,'骏丰国际','junfengguoji'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100508,'货运皇','kingfreight'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100509,'速必达','subida'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100510,'特急便','sucmj'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100511,'亚马逊中国','yamaxunwuliu'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100512,'锦程','jinchengwuliu'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100513,'景光','jgwl'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100514,'御风','yufeng'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100515,'至诚通达','zhichengtongda'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100516,'日益通','rytsd'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100517,'航宇','hangyu'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100518,'急顺通','pzhjst'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100519,'优速通达','yousutongda'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100520,'秦远','qinyuan'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100521,'澳邮中国','auexpress'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100522,'众辉达','zhdwl'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100523,'飞邦','fbkd'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100524,'华达','huada'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100525,'FOX GLOBAL EXPRESS','fox'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100526,'环球','huanqiu'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100527,'辉联','huilian'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100528,'A2U','a2u'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100529,'UEQ','ueq'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100530,'中加国际','scic'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100531,'易达通','yidatong'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100532,'捷网俄全通','ruexp'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100533,'华通务达','htwd'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100534,'申必达','speedoex'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100535,'联运','lianyun'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100536,'捷安达','jieanda'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100537,'SHL畅灵国际','shlexp'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100538,'EWE全球','ewe'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100539,'全球','abcglobal'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100540,'芒果','mangguo'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100541,'金海淘','goldhaitao'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100542,'极光','jiguang'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100543,'富腾达国际','ftd'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100544,'DCS','dcs'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100545,'成达国际','chengda'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100546,'中环','zhonghuan'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100547,'顺邦国际','shunbang'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100548,'启辰国际','qichen'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100549,'澳货通','auex'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100550,'澳速','aosu'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100551,'澳世','aus'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100552,'天马迅达','tianma'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100553,'美龙快递','mjexp'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100554,'香港骏辉物流','chunfai'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100555,'三三国际物流','zenzen'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100556,'淼信快递','mxe56'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100557,'海派通','hipito'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100558,'鹏程快递','pengcheng'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100559,'冠庭国际物流','guanting'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100560,'金岸物流','jinan'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100561,'海带宝','haidaibao'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100562,'澳通华人物流','cllexpress'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100563,'斑马物流','banma'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100564,'友家速递','youjia'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100565,'百通物流','buytong'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100566,'新元快递','xingyuankuaidi'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100567,'全速物流','quansu'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100568,'新杰物流','sunjex'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100569,'鲁通快运','lutong'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100570,'新元国际','xynyc'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100571,'小C海淘','xiaocex'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100572,'航空快递','airgtc'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100573,'叮咚澳洲转运','dindon'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100574,'环球通达','hqtd'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100575,'好又快物流','haoyoukuai'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100576,'永旺达快递','yongwangda'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100577,'木春货运','mchy'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100578,'程光快递','flyway'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100579,'全之鑫物流','qzx56'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100580,'百事亨通','bsht'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100581,'ILYANG','ilyang'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100582,'先锋快递','xianfeng'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100583,'万家通快递','timedg'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100584,'美快国际物流','meiquick'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100585,'泰中物流','tny'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100586,'美通','valueway'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100587,'新速航','sunspeedy'); INSERT INTO T_BD_KD100LOGISTICSCOM VALUES(100588,'速方','bphchina');
-------------------------------------- PT106397_K3CloudV6.0_BD_Data.sql --------------------------------------
德邦物流公司改名成德邦快递,并新增德邦速运,由于历史原因不知道当时提交人为何没直接根据上面的初始版本的德邦ID更新物流公司名称,而是删除再重新添加(这可能存在一个问题,就是德邦的物流公司内码是一个不确定的值,原德邦ID为100015,新的德邦快递和德邦速运在客户没有手工操作'快递100物流公司列表'情况下一般为 100589和100590):
-------------------------------------- PT132327_K3CloudV7.0_SCM_Data.sql --------------------------------------
DELETE T_BD_KD100LOGISTICSCOM WHERE FNAME LIKE N'%德邦%' INSERT INTO T_BD_KD100LOGISTICSCOM(FID,FNAME,FCODE) SELECT MAX(FID)+1,N'德邦快递','debangkuaidi' FROM T_BD_KD100LOGISTICSCOM; INSERT INTO T_BD_KD100LOGISTICSCOM(FID,FNAME,FCODE) SELECT MAX(FID)+1,N'德邦速运','debangwuliu' FROM T_BD_KD100LOGISTICSCOM;
-------------------------------------- PT132327_K3CloudV7.0_SCM_Data.sql --------------------------------------
中铁物流公司改名,快递100官方对外声称不应该再使用带禁用字眼的物流公司(100121那行):
-------------------------------------- PT146863_K3CloudV7.0_SCM_Data.sql --------------------------------------
UPDATE T_BD_KD100LOGISTICSCOM SET FNAME = '中铁快运' WHERE FID = 100019; UPDATE T_BD_KD100LOGISTICSCOM SET FNAME = '中铁飞豹(中铁物流)' WHERE FID = 100020; UPDATE T_BD_KD100LOGISTICSCOM SET FNAME = '中铁(禁用)' WHERE FID = 100121;
-------------------------------------- PT146863_K3CloudV7.0_SCM_Data.sql --------------------------------------
新物流公司添加,本次添加占用10001到10745的ID:
-------------------------------------- PT146893_K3CloudV7.0_SCM_Data.sql --------------------------------------
DELETE T_BD_KD100LOGISTICSCOM WHERE FID >= 10001 AND FID <= 10745; INSERT INTO T_BD_KD100LOGISTICSCOM(FID, FNAME, FCODE) VALUES (10001, '一智通', '1ziton'); INSERT INTO T_BD_KD100LOGISTICSCOM(FID, FNAME, FCODE) VALUES (10002, 'aCommerce', 'acommerce'); INSERT INTO T_BD_KD100LOGISTICSCOM(FID, FNAME, FCODE) VALUES (10003, '安达速递', 'adapost'); INSERT INTO T_BD_KD100LOGISTICSCOM(FID, FNAME, FCODE) VALUES (10004, '安达易国际速递', 'adiexpress'); INSERT INTO T_BD_KD100LOGISTICSCOM(FID, FNAME, FCODE) VALUES (10005, '德国雄鹰速递', 'adlerlogi'); INSERT INTO T_BD_KD100LOGISTICSCOM(FID, FNAME, FCODE) VALUES (10006, 'ADSone', 'adsone'); INSERT INTO T_BD_KD100LOGISTICSCOM(FID, FNAME, FCODE) VALUES (10007, 'AFL', 'afl'); INSERT INTO T_BD_KD100LOGISTICSCOM(FID, FNAME, FCODE) VALUES (10008, '全程快递', 'agopost'); INSERT INTO T_BD_KD100LOGISTICSCOM(FID, FNAME, FCODE) VALUES (10009, '德方物流', 'ahdf'); INSERT INTO T_BD_KD100LOGISTICSCOM(FID, FNAME, FCODE) VAL
快递100物流公司对照表
本文2024-09-16 17:15:54发表“云星空知识”栏目。
本文链接:https://wenku.my7c.com/article/kingdee-k3cloud-14586.html