快递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,'黑
快递100物流公司对照表
快递100物流公司是通过 T_BD_KD100LOGISTICSCOM 表示,由于历史原因,通版是分批次添加相关记录(而且不排除后续新还会再添加新的物流...
点击下载文档文档为doc格式
声明:除非特别标注,否则均为本站原创文章,转载时请以链接形式注明文章出处。如若本站内容侵犯了原著者的合法权益,可联系本站删除。
上一篇
已经是第一篇



