Warning: include(../function.php) [function.include]: failed to open stream: No such file or directory in E:\www\ck\no\_ps\ps_sync_visit_credit.php on line 11

Warning: include() [function.include]: Failed opening '../function.php' for inclusion (include_path='.;C:\php5\pear') in E:\www\ck\no\_ps\ps_sync_visit_credit.php on line 11
http://203.155.18.96/BCWEB_SERVICES/back/CREDIT_RouteJsonData.aspx?orderdate=201704126
1970-01-01<<<<<

04/26/2017||||||||||||||||04-26-2017 23:36:19 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'600462086','2017-04-26 00:00:00','Y','92020.0','|','20250429','1','2','2017-04-06' FROM c_cust_route WHERE custArea='S103' and custNo='96000010' and mn='04' and yr='2017'

04/26/2017||||||||||||||||04-26-2017 23:31:29 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'600462085','2017-04-26 00:00:00','Y','103620.0','|','20250429','1','2','2017-04-06' FROM c_cust_route WHERE custArea='S103' and custNo='96120021' and mn='04' and yr='2017'

04/26/2017||||||||||||||||04-26-2017 23:16:58 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'600462084','2017-04-26 00:00:00','Y','1194700.0','|','20250429','1','2','2017-04-06' FROM c_cust_route WHERE custArea='S103' and custNo='95000026' and mn='04' and yr='2017'

04/26/2017||||||||||||||||04-26-2017 22:58:32 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'600462083','2017-04-26 00:00:00','Y','682500.0','| บิล3 อ้างอิง 600462012/600462047 /ยกเลิกรายการเพราะ ยกเลิกบิล 600462078 หลังจากปิดบิลไปแล้ว','20250429','1','3','2017-04-06' FROM c_cust_route WHERE custArea='S103' and custNo='96120017' and mn='04' and yr='2017'

04/26/2017||||||||||||||||04-26-2017 21:08:22 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'600411139','2017-04-26 00:00:00','Y','43500.0','| บิล1','20250429','2','1','2017-04-05' FROM c_cust_route WHERE custArea='B102' and custNo='12150026' and mn='04' and yr='2017'

04/26/2017||||||||||||||||04-26-2017 20:32:42 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'600411138','2017-04-26 00:00:00','Y','7304.0','|','20250429','2','1','2017-04-05' FROM c_cust_route WHERE custArea='B102' and custNo='11110001' and mn='04' and yr='2017'

04/26/2017||||||||||||||||04-26-2017 20:00:43 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'600431084','2017-04-26 00:00:00','Y','193600.0','| บิล3 อ้างอิง600431055,069','20250429','1','3','2017-04-05' FROM c_cust_route WHERE custArea='E102' and custNo='20000016' and mn='04' and yr='2017'

04/26/2017||||||||||||||||04-26-2017 18:31:46 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'600412105','2017-04-26 00:00:00','Y','6924.0','| ด่วน','20250429','2','1','2017-04-07' FROM c_cust_route WHERE custArea='B103' and custNo='10310023' and mn='04' and yr='2017'

04/26/2017||||||||||||||||04-26-2017 18:29:00 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'600412104','2017-04-26 00:00:00','Y','4800.0','|','20250429','2','2','2017-04-07' FROM c_cust_route WHERE custArea='B103' and custNo='10520069' and mn='04' and yr='2017'

04/26/2017||||||||||||||||04-26-2017 18:28:02 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'600412103','2017-04-26 00:00:00','Y','23281.0','|','20250429','2','1','2017-04-07' FROM c_cust_route WHERE custArea='B103' and custNo='10520069' and mn='04' and yr='2017'

04/26/2017||||||||||||||||04-26-2017 18:25:00 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'600412102','2017-04-26 00:00:00','Y','10660.32','| ด่วน','20250429','2','1','2017-04-07' FROM c_cust_route WHERE custArea='B103' and custNo='10540088' and mn='04' and yr='2017'

04/26/2017||||||||||||||||04-26-2017 18:22:09 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'600412101','2017-04-26 00:00:00','Y','15530.0','| ด่วน','20250429','2','1','2017-04-07' FROM c_cust_route WHERE custArea='B103' and custNo='10130121' and mn='04' and yr='2017'

04/26/2017||||||||||||||||04-26-2017 18:20:36 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'600461075','2017-04-26 00:00:00','Y','61245.0','| บิล3อ้างอิง','20250429','1','3','2017-04-08' FROM c_cust_route WHERE custArea='S102' and custNo='84160003' and mn='04' and yr='2017'

04/26/2017||||||||||||||||04-26-2017 18:20:04 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'600412100','2017-04-26 00:00:00','Y','2700.0','| ด่วน','20250429','2','2','2017-04-07' FROM c_cust_route WHERE custArea='B103' and custNo='10150114' and mn='04' and yr='2017'

04/26/2017||||||||||||||||04-26-2017 18:19:15 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'600412099','2017-04-26 00:00:00','Y','11574.09','| ด่วน','20250429','2','1','2017-04-07' FROM c_cust_route WHERE custArea='B103' and custNo='10150115' and mn='04' and yr='2017'

04/26/2017||||||||||||||||04-26-2017 18:12:22 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'600461074','2017-04-26 00:00:00','Y','38400.0','|','20250429','1','3','2017-04-08' FROM c_cust_route WHERE custArea='S102' and custNo='80000037' and mn='04' and yr='2017'

04/26/2017||||||||||||||||04-26-2017 18:11:31 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'600461073','2017-04-26 00:00:00','Y','41850.0','|','20250429','1','2','2017-04-08' FROM c_cust_route WHERE custArea='S102' and custNo='80000037' and mn='04' and yr='2017'

04/26/2017||||||||||||||||04-26-2017 18:10:17 PM
Update c_cust_route set price_buy='4615.0',orderNo='600420067',visit_date='2017-04-26 00:00:00',is_buy='Y',reason='|',fv_date='-' WHERE custArea='C101' and custNo='60130001' and mn='04' and yr='2017' and collection='1' and rount='1';

04/26/2017||||||||||||||||04-26-2017 18:06:05 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'600420066','2017-04-26 00:00:00','Y','263840.0','|','20250429','1','3','-' FROM c_cust_route WHERE custArea='C101' and custNo='62000013' and mn='04' and yr='2017'

04/26/2017||||||||||||||||04-26-2017 18:01:36 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'600411137','2017-04-26 00:00:00','Y','12652.0','| บิล3อ้างอิงod6004-11041,11077','20250429','2','3','2017-04-05' FROM c_cust_route WHERE custArea='B102' and custNo='11120039' and mn='04' and yr='2017'

04/26/2017||||||||||||||||04-26-2017 18:00:40 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'600453075','2017-04-26 00:00:00','Y','3450.0','| ร้านโรจเจริญ','20250429','1','2','2017-04-05' FROM c_cust_route WHERE custArea='N/E104' and custNo='33110013' and mn='04' and yr='2017'

04/26/2017||||||||||||||||04-26-2017 17:58:28 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'600453074','2017-04-26 00:00:00','Y','24960.0','|','20250429','1','3','2017-04-05' FROM c_cust_route WHERE custArea='N/E104' and custNo='33110010' and mn='04' and yr='2017'

04/26/2017||||||||||||||||04-26-2017 17:54:50 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'600453073','2017-04-26 00:00:00','Y','5000.0','|','20250429','1','2','2017-04-05' FROM c_cust_route WHERE custArea='N/E104' and custNo='33110003' and mn='04' and yr='2017'

04/26/2017||||||||||||||||04-26-2017 17:45:03 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'600411136','2017-04-26 00:00:00','Y','130500.0','|','20250429','2','1','2017-04-05' FROM c_cust_route WHERE custArea='B102' and custNo='10210042' and mn='04' and yr='2017'

04/26/2017||||||||||||||||04-26-2017 17:43:42 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'600411135','2017-04-26 00:00:00','Y','19200.0','|','20250429','2','1','2017-04-05' FROM c_cust_route WHERE custArea='B102' and custNo='12120081' and mn='04' and yr='2017'

04/26/2017||||||||||||||||04-26-2017 17:11:35 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'600430069','2017-04-26 00:00:00','Y','26280.0','|','20250429','1','2','2017-04-23' FROM c_cust_route WHERE custArea='E101' and custNo='25110015' and mn='04' and yr='2017'

04/26/2017||||||||||||||||04-26-2017 17:08:26 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'600430068','2017-04-26 00:00:00','Y','14040.0','|','20250429','1','2','2017-04-23' FROM c_cust_route WHERE custArea='E101' and custNo='25110007' and mn='04' and yr='2017'

04/26/2017||||||||||||||||04-26-2017 17:05:12 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'600430067','2017-04-26 00:00:00','Y','30054.36','|','20250429','1','2','2017-04-23' FROM c_cust_route WHERE custArea='E101' and custNo='25110010' and mn='04' and yr='2017'

04/26/2017||||||||||||||||04-26-2017 17:03:35 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'600430066','2017-04-26 00:00:00','Y','12100.0','|','20250429','1','2','2017-04-23' FROM c_cust_route WHERE custArea='E101' and custNo='25140004' and mn='04' and yr='2017'

04/26/2017||||||||||||||||04-26-2017 17:01:27 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'600430065','2017-04-26 00:00:00','Y','58420.0','| บิล2อ้างอิง600430022 บิลด่วน','20250429','1','2','2017-04-23' FROM c_cust_route WHERE custArea='E101' and custNo='30000064' and mn='04' and yr='2017'

04/26/2017||||||||||||||||04-26-2017 16:53:05 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'600410136','2017-04-26 00:00:00','Y','19200.0','|','20250429','2','5','2017-04-07' FROM c_cust_route WHERE custArea='B101' and custNo='74120020' and mn='04' and yr='2017'

04/26/2017||||||||||||||||04-26-2017 16:45:16 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'600421125','2017-04-26 00:00:00','Y','80000.0','| ส่งวันที่5/5/2560','20250429','1','2','2017-04-10' FROM c_cust_route WHERE custArea='C102' and custNo='72110007' and mn='04' and yr='2017'

04/26/2017||||||||||||||||04-26-2017 16:45:03 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'600432067','2017-04-26 00:00:00','Y','128780.0','| บิล2 อ้างอิง600432066','20250429','1','2','2017-04-10' FROM c_cust_route WHERE custArea='E103' and custNo='22000011' and mn='04' and yr='2017'

04/26/2017||||||||||||||||04-26-2017 16:41:06 PM
Update c_cust_route set price_buy='200130.0',orderNo='600432066',visit_date='2017-04-26 00:00:00',is_buy='Y',reason='| บิล1',fv_date='2017-04-10' WHERE custArea='E103' and custNo='22000011' and mn='04' and yr='2017' and collection='1' and rount='1';

04/26/2017||||||||||||||||04-26-2017 16:37:03 PM
Update c_cust_route set price_buy='78600.0',orderNo='600421123',visit_date='2017-04-26 00:00:00',is_buy='Y',reason='| ส่งด่วน',fv_date='2017-04-10' WHERE custArea='C102' and custNo='72110007' and mn='04' and yr='2017' and collection='1' and rount='1';

04/26/2017||||||||||||||||04-26-2017 16:29:32 PM
Update c_cust_route set price_buy='20076.0',orderNo='600442087',visit_date='2017-04-26 00:00:00',is_buy='Y',reason='| บิล1',fv_date='2017-04-07' WHERE custArea='N103' and custNo='52000045' and mn='04' and yr='2017' and collection='1' and rount='1';

04/26/2017||||||||||||||||04-26-2017 16:25:48 PM
Update c_cust_route set price_buy='13120.0',orderNo='600442086',visit_date='2017-04-26 00:00:00',is_buy='Y',reason='|',fv_date='2017-04-07' WHERE custArea='N103' and custNo='52190004' and mn='04' and yr='2017' and collection='1' and rount='1';

04/26/2017||||||||||||||||04-26-2017 16:23:09 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'600421122','2017-04-26 00:00:00','Y','25285.0','| ส่งวันที่5/5/2560','20250429','1','2','2017-04-10' FROM c_cust_route WHERE custArea='C102' and custNo='14000011' and mn='04' and yr='2017'

04/26/2017||||||||||||||||04-26-2017 16:13:05 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'600421121','2017-04-26 00:00:00','Y','36700.0','|','20250429','1','2','2017-04-10' FROM c_cust_route WHERE custArea='C102' and custNo='15130024' and mn='04' and yr='2017'

04/26/2017||||||||||||||||04-26-2017 16:07:51 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'600421120','2017-04-26 00:00:00','Y','29000.0','| โทรแจ้งลูกค้าก่อน','20250429','1','3','2017-04-10' FROM c_cust_route WHERE custArea='C102' and custNo='15000026' and mn='04' and yr='2017'

04/26/2017||||||||||||||||04-26-2017 16:06:41 PM
Update c_cust_route set price_buy='4800.0',orderNo='600452065',visit_date='2017-04-26 00:00:00',is_buy='Y',reason='|',fv_date='2017-04-06' WHERE custArea='N/E103' and custNo='47000046' and mn='04' and yr='2017' and collection='1' and rount='1';

04/26/2017||||||||||||||||04-26-2017 16:05:58 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'600421119','2017-04-26 00:00:00','Y','11682.0','| ส่งวันที่5/5/2560','20250429','1','3','2017-04-10' FROM c_cust_route WHERE custArea='C102' and custNo='15000018' and mn='04' and yr='2017'

04/26/2017||||||||||||||||04-26-2017 16:05:13 PM
Update c_cust_route set price_buy='11452.32',orderNo='600452064',visit_date='2017-04-26 00:00:00',is_buy='Y',reason='|',fv_date='2017-04-06' WHERE custArea='N/E103' and custNo='47000028' and mn='04' and yr='2017' and collection='1' and rount='1';

04/26/2017||||||||||||||||04-26-2017 16:02:23 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'600452063','2017-04-26 00:00:00','Y','29360.0','| ด่วนครับ','20250429','1','2','2017-04-06' FROM c_cust_route WHERE custArea='N/E103' and custNo='37000028' and mn='04' and yr='2017'

04/26/2017||||||||||||||||04-26-2017 16:00:57 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'600422158','2017-04-26 00:00:00','Y','27426.0','|','20250429','1','2','2017-04-06' FROM c_cust_route WHERE custArea='C103' and custNo='71000022' and mn='04' and yr='2017'

04/26/2017||||||||||||||||04-26-2017 16:00:54 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'600453072','2017-04-26 00:00:00','Y','15340.0','| บิล2อ้าง600453057','20250429','1','2','2017-04-05' FROM c_cust_route WHERE custArea='N/E104' and custNo='33110007' and mn='04' and yr='2017'

04/26/2017||||||||||||||||04-26-2017 15:58:47 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'600452062','2017-04-26 00:00:00','Y','42266.0','| บิล2อ้างอิงOD.600452011','20250429','1','2','2017-04-06' FROM c_cust_route WHERE custArea='N/E103' and custNo='34190016' and mn='04' and yr='2017'

04/26/2017||||||||||||||||04-26-2017 15:57:25 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'600421118','2017-04-26 00:00:00','Y','25000.0','|','20250429','1','3','2017-04-10' FROM c_cust_route WHERE custArea='C102' and custNo='15000030' and mn='04' and yr='2017'

04/26/2017||||||||||||||||04-26-2017 15:56:15 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'600421117','2017-04-26 00:00:00','Y','17950.0','|','20250429','1','3','2017-04-10' FROM c_cust_route WHERE custArea='C102' and custNo='15000039' and mn='04' and yr='2017'

04/26/2017||||||||||||||||04-26-2017 15:54:00 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'600453071','2017-04-26 00:00:00','Y','29800.0','| บิล3อ้าง600453006/058','20250429','1','3','2017-04-05' FROM c_cust_route WHERE custArea='N/E104' and custNo='33110004' and mn='04' and yr='2017'

04/26/2017||||||||||||||||04-26-2017 15:52:52 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'600421116','2017-04-26 00:00:00','Y','71800.0','| ส่งวันที่5/5/2560','20250429','1','5','2017-04-10' FROM c_cust_route WHERE custArea='C102' and custNo='15000002' and mn='04' and yr='2017'

04/26/2017||||||||||||||||04-26-2017 15:39:10 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'600422157','2017-04-26 00:00:00','Y','38400.0','|','20250429','1','2','2017-04-06' FROM c_cust_route WHERE custArea='C103' and custNo='76130017' and mn='04' and yr='2017'

04/26/2017||||||||||||||||04-26-2017 15:37:33 PM
Update c_cust_route set price_buy='31130.0',orderNo='600422156',visit_date='2017-04-26 00:00:00',is_buy='Y',reason='|',fv_date='2017-04-06' WHERE custArea='C103' and custNo='73000051' and mn='04' and yr='2017' and collection='1' and rount='1';

04/26/2017||||||||||||||||04-26-2017 15:35:13 PM
Update c_cust_route set price_buy='1205.0',orderNo='600422155',visit_date='2017-04-26 00:00:00',is_buy='Y',reason='|',fv_date='2017-04-06' WHERE custArea='C103' and custNo='71110015' and mn='04' and yr='2017' and collection='1' and rount='1';

04/26/2017||||||||||||||||04-26-2017 15:34:07 PM
Update c_cust_route set price_buy='14967.3',orderNo='600422154',visit_date='2017-04-26 00:00:00',is_buy='Y',reason='|',fv_date='2017-04-06' WHERE custArea='C103' and custNo='71120019' and mn='04' and yr='2017' and collection='1' and rount='1';

04/26/2017||||||||||||||||04-26-2017 15:32:03 PM
Update c_cust_route set price_buy='26340.0',orderNo='600422153',visit_date='2017-04-26 00:00:00',is_buy='Y',reason='|',fv_date='2017-04-06' WHERE custArea='C103' and custNo='71120017' and mn='04' and yr='2017' and collection='1' and rount='1';

04/26/2017||||||||||||||||04-26-2017 15:31:11 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'600421115','2017-04-26 00:00:00','Y','550.0','|','20250429','1','2','2017-04-10' FROM c_cust_route WHERE custArea='C102' and custNo='16000030' and mn='04' and yr='2017'

04/26/2017||||||||||||||||04-26-2017 15:26:53 PM
Update c_cust_route set price_buy='10840.5',orderNo='600422152',visit_date='2017-04-26 00:00:00',is_buy='Y',reason='|',fv_date='2017-04-06' WHERE custArea='C103' and custNo='71120012' and mn='04' and yr='2017' and collection='1' and rount='1';

04/26/2017||||||||||||||||04-26-2017 15:25:12 PM
Update c_cust_route set price_buy='1400.0',orderNo='600422151',visit_date='2017-04-26 00:00:00',is_buy='Y',reason='|',fv_date='2017-04-06' WHERE custArea='C103' and custNo='71120011' and mn='04' and yr='2017' and collection='1' and rount='1';

04/26/2017||||||||||||||||04-26-2017 15:24:11 PM
Update c_cust_route set price_buy='6200.0',orderNo='600422150',visit_date='2017-04-26 00:00:00',is_buy='Y',reason='|',fv_date='2017-04-06' WHERE custArea='C103' and custNo='71120005' and mn='04' and yr='2017' and collection='1' and rount='1';

04/26/2017||||||||||||||||04-26-2017 15:20:49 PM
Update c_cust_route set price_buy='6184.0',orderNo='600422149',visit_date='2017-04-26 00:00:00',is_buy='Y',reason='|',fv_date='2017-04-06' WHERE custArea='C103' and custNo='71110012' and mn='04' and yr='2017' and collection='1' and rount='1';

04/26/2017||||||||||||||||04-26-2017 15:17:52 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'600421114','2017-04-26 00:00:00','Y','69200.0','| โทรแจ้งลูกค้าก่อนส่งร้านเฮียพ้ง','20250429','1','2','2017-04-10' FROM c_cust_route WHERE custArea='C102' and custNo='72110008' and mn='04' and yr='2017'

04/26/2017||||||||||||||||04-26-2017 15:15:41 PM
Update c_cust_route set price_buy='31170.0',orderNo='600432065',visit_date='2017-04-26 00:00:00',is_buy='Y',reason='|',fv_date='2017-04-10' WHERE custArea='E103' and custNo='21110014' and mn='04' and yr='2017' and collection='1' and rount='1';

04/26/2017||||||||||||||||04-26-2017 15:14:06 PM
Update c_cust_route set price_buy='19900.0',orderNo='600432064',visit_date='2017-04-26 00:00:00',is_buy='Y',reason='|',fv_date='2017-04-10' WHERE custArea='E103' and custNo='21110006' and mn='04' and yr='2017' and collection='1' and rount='1';

04/26/2017||||||||||||||||04-26-2017 15:13:48 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'600421113','2017-04-26 00:00:00','Y','966.0','| ส่งวันที่5/5/2560','20250429','1','3','2017-04-10' FROM c_cust_route WHERE custArea='C102' and custNo='16110001' and mn='04' and yr='2017'

04/26/2017||||||||||||||||04-26-2017 15:12:35 PM
Update c_cust_route set price_buy='4800.0',orderNo='600432063',visit_date='2017-04-26 00:00:00',is_buy='Y',reason='|',fv_date='2017-04-10' WHERE custArea='E103' and custNo='27210010' and mn='04' and yr='2017' and collection='1' and rount='1';

04/26/2017||||||||||||||||04-26-2017 15:03:05 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'600421112','2017-04-26 00:00:00','Y','11700.0','| ส่งวันที่5/5/2556','20250429','1','2','2017-04-10' FROM c_cust_route WHERE custArea='C102' and custNo='16110001' and mn='04' and yr='2017'

04/26/2017||||||||||||||||04-26-2017 13:58:48 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'600410135','2017-04-26 00:00:00','Y','12680.8506','|','20250429','2','4','2017-04-07' FROM c_cust_route WHERE custArea='B101' and custNo='10160282' and mn='04' and yr='2017'

04/26/2017||||||||||||||||04-26-2017 13:50:40 PM
Update c_cust_route set price_buy='10743.0',orderNo='600451099',visit_date='2017-04-26 00:00:00',is_buy='Y',reason='|',fv_date='2017-04-08' WHERE custArea='N/E102' and custNo='46110012' and mn='04' and yr='2017' and collection='1' and rount='1';

04/26/2017||||||||||||||||04-26-2017 13:49:09 PM
Update c_cust_route set price_buy='6400.0',orderNo='600451098',visit_date='2017-04-26 00:00:00',is_buy='Y',reason='|',fv_date='2017-04-08' WHERE custArea='N/E102' and custNo='46110004' and mn='04' and yr='2017' and collection='1' and rount='1';

04/26/2017||||||||||||||||04-26-2017 13:33:35 PM
Update c_cust_route set price_buy='4800.0',orderNo='600451097',visit_date='2017-04-26 00:00:00',is_buy='Y',reason='|',fv_date='2017-04-08' WHERE custArea='N/E102' and custNo='46000022' and mn='04' and yr='2017' and collection='1' and rount='1';

04/26/2017||||||||||||||||04-26-2017 13:29:32 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'600410134','2017-04-26 00:00:00','Y','47155.0','| บิล2อ้างอิงบิล600410055','20250429','2','2','2017-04-07' FROM c_cust_route WHERE custArea='B101' and custNo='10170097' and mn='04' and yr='2017'

04/26/2017||||||||||||||||04-26-2017 13:12:12 PM
Update c_cust_route set price_buy='4800.0',orderNo='600451096',visit_date='2017-04-26 00:00:00',is_buy='Y',reason='|',fv_date='2017-04-08' WHERE custArea='N/E102' and custNo='44160006' and mn='04' and yr='2017' and collection='1' and rount='1';

04/26/2017||||||||||||||||04-26-2017 13:10:50 PM
Update c_cust_route set price_buy='5364.0',orderNo='600451095',visit_date='2017-04-26 00:00:00',is_buy='Y',reason='|',fv_date='2017-04-08' WHERE custArea='N/E102' and custNo='40000091' and mn='04' and yr='2017' and collection='1' and rount='1';

04/26/2017||||||||||||||||04-26-2017 13:06:44 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'600410133','2017-04-26 00:00:00','Y','35100.0','|','20250429','2','4','2017-04-07' FROM c_cust_route WHERE custArea='B101' and custNo='74120020' and mn='04' and yr='2017'

04/26/2017||||||||||||||||04-26-2017 13:03:36 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'600410131','2017-04-26 00:00:00','Y','71965.0','| บิล2อ้างอิง600410041','20250429','2','2','2017-04-07' FROM c_cust_route WHERE custArea='B101' and custNo='74120020' and mn='04' and yr='2017'

04/26/2017||||||||||||||||04-26-2017 12:27:17 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'600410130','2017-04-26 00:00:00','Y','1170.0','| อ้างอิงบิล600410018','20250429','2','4','2017-04-07' FROM c_cust_route WHERE custArea='B101' and custNo='74000019' and mn='04' and yr='2017'

04/26/2017||||||||||||||||04-26-2017 12:04:18 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'600460070','2017-04-26 00:00:00','Y','76050.0','|','20250429','1','2','2017-04-07' FROM c_cust_route WHERE custArea='S101' and custNo='83000034' and mn='04' and yr='2017'

04/26/2017||||||||||||||||04-26-2017 11:20:54 AM
Update c_cust_route set price_buy='291320.0',orderNo='600450035',visit_date='2017-04-26 00:00:00',is_buy='Y',reason='| ด่วนคับ',fv_date='2017-04-06' WHERE custArea='N/E101' and custNo='41000003' and mn='04' and yr='2017' and collection='1' and rount='1';

04/26/2017||||||||||||||||04-26-2017 11:07:49 PM
Update c_cust_route set price_buy='0',orderNo='',visit_date='2017-04-26 00:00:00',is_buy='N',reason='สินค้าระบายไม่ดี |',fv_date='2017-04-06' WHERE custArea='S103' and custNo='90120034' and mn='04' and yr='2017' and collection='1' and rount='1';

04/26/2017||||||||||||||||04-26-2017 11:07:39 PM
Update c_cust_route set price_buy='0',orderNo='',visit_date='2017-04-26 00:00:00',is_buy='N',reason='สินค้าระบายไม่ดี |',fv_date='2017-04-06' WHERE custArea='S103' and custNo='90120024' and mn='04' and yr='2017' and collection='1' and rount='1';

04/26/2017||||||||||||||||04-26-2017 11:07:26 PM
Update c_cust_route set price_buy='0',orderNo='',visit_date='2017-04-26 00:00:00',is_buy='N',reason='สินค้าระบายไม่ดี |',fv_date='2017-04-06' WHERE custArea='S103' and custNo='90120023' and mn='04' and yr='2017' and collection='1' and rount='1';

04/26/2017||||||||||||||||04-26-2017 11:07:19 PM
Update c_cust_route set price_buy='0',orderNo='',visit_date='2017-04-26 00:00:00',is_buy='N',reason='สินค้าระบายไม่ดี |',fv_date='2017-04-06' WHERE custArea='S103' and custNo='90120022' and mn='04' and yr='2017' and collection='1' and rount='1';

04/26/2017||||||||||||||||04-26-2017 11:06:44 PM
Update c_cust_route set price_buy='0',orderNo='',visit_date='2017-04-26 00:00:00',is_buy='N',reason='สินค้าระบายไม่ดี |',fv_date='2017-04-06' WHERE custArea='S103' and custNo='90110107' and mn='04' and yr='2017' and collection='1' and rount='1';

04/26/2017||||||||||||||||04-26-2017 11:06:36 PM
Update c_cust_route set price_buy='0',orderNo='',visit_date='2017-04-26 00:00:00',is_buy='N',reason='สินค้าระบายไม่ดี |',fv_date='2017-04-06' WHERE custArea='S103' and custNo='90110106' and mn='04' and yr='2017' and collection='1' and rount='1';

04/26/2017||||||||||||||||04-26-2017 11:06:23 PM
Update c_cust_route set price_buy='0',orderNo='',visit_date='2017-04-26 00:00:00',is_buy='N',reason='ร้านค้าไม่ซื้อเพราะ เซ้งร้านต่อให้ลูกค้ารายใหม่แล้วครับ |',fv_date='2017-04-06' WHERE custArea='S103' and custNo='90110109' and mn='04' and yr='2017' and collection='1' and rount='1';

04/26/2017||||||||||||||||04-26-2017 11:05:00 PM
Update c_cust_route set price_buy='0',orderNo='',visit_date='2017-04-26 00:00:00',is_buy='N',reason='สินค้าระบายไม่ดี |',fv_date='2017-04-06' WHERE custArea='S103' and custNo='90110090' and mn='04' and yr='2017' and collection='1' and rount='1';

04/26/2017||||||||||||||||04-26-2017 11:04:51 PM
Update c_cust_route set price_buy='0',orderNo='',visit_date='2017-04-26 00:00:00',is_buy='N',reason='สินค้าระบายไม่ดี |',fv_date='2017-04-06' WHERE custArea='S103' and custNo='90110088' and mn='04' and yr='2017' and collection='1' and rount='1';

04/26/2017||||||||||||||||04-26-2017 11:04:40 PM
Update c_cust_route set price_buy='0',orderNo='',visit_date='2017-04-26 00:00:00',is_buy='N',reason='สินค้าระบายไม่ดี |',fv_date='2017-04-06' WHERE custArea='S103' and custNo='90110087' and mn='04' and yr='2017' and collection='1' and rount='1';

04/26/2017||||||||||||||||04-26-2017 11:04:29 PM
Update c_cust_route set price_buy='0',orderNo='',visit_date='2017-04-26 00:00:00',is_buy='N',reason='ร้านค้าไม่ซื้อเพราะ การเงินไม่ดี ผ่อนชำระอยู่ |',fv_date='2017-04-06' WHERE custArea='S103' and custNo='90110085' and mn='04' and yr='2017' and collection='1' and rount='1';

04/26/2017||||||||||||||||04-26-2017 11:03:41 PM
Update c_cust_route set price_buy='0',orderNo='',visit_date='2017-04-26 00:00:00',is_buy='N',reason='สินค้าระบายไม่ดี |',fv_date='2017-04-06' WHERE custArea='S103' and custNo='90110083' and mn='04' and yr='2017' and collection='1' and rount='1';

04/26/2017||||||||||||||||04-26-2017 11:03:18 PM
Update c_cust_route set price_buy='0',orderNo='',visit_date='2017-04-26 00:00:00',is_buy='N',reason='ร้านค้าไม่ซื้อเพราะ สั่งชื้อสินค้าทางเมลแล้ว |',fv_date='2017-04-06' WHERE custArea='S103' and custNo='90280006' and mn='04' and yr='2017' and collection='1' and rount='1';

04/26/2017||||||||||||||||04-26-2017 11:02:16 PM
Update c_cust_route set price_buy='0',orderNo='',visit_date='2017-04-26 00:00:00',is_buy='N',reason='ร้านค้าไม่ซื้อเพราะ สินยังพอใช้อยู่ |',fv_date='2017-04-06' WHERE custArea='S103' and custNo='90110076' and mn='04' and yr='2017' and collection='1' and rount='1';

04/26/2017||||||||||||||||04-26-2017 11:01:10 PM
Update c_cust_route set price_buy='0',orderNo='',visit_date='2017-04-26 00:00:00',is_buy='N',reason='สินค้าระบายไม่ดี |',fv_date='2017-04-06' WHERE custArea='S103' and custNo='90110075' and mn='04' and yr='2017' and collection='1' and rount='1';

04/26/2017||||||||||||||||04-26-2017 11:00:57 PM
Update c_cust_route set price_buy='0',orderNo='',visit_date='2017-04-26 00:00:00',is_buy='N',reason='สินค้าระบายไม่ดี |',fv_date='2017-04-06' WHERE custArea='S103' and custNo='90110074' and mn='04' and yr='2017' and collection='1' and rount='1';

04/26/2017||||||||||||||||04-26-2017 11:00:41 PM
Update c_cust_route set price_buy='0',orderNo='',visit_date='2017-04-26 00:00:00',is_buy='N',reason='สินค้าระบายไม่ดี |',fv_date='2017-04-06' WHERE custArea='S103' and custNo='90110071' and mn='04' and yr='2017' and collection='1' and rount='1';

04/26/2017||||||||||||||||04-26-2017 10:46:53 AM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'600462082','2017-04-26 00:00:00','Y','12234.36','|','20250429','1','2','2017-04-06' FROM c_cust_route WHERE custArea='S103' and custNo='90120032' and mn='04' and yr='2017'

04/26/2017||||||||||||||||04-26-2017 10:43:48 AM
Update c_cust_route set price_buy='23054.1',orderNo='600462081',visit_date='2017-04-26 00:00:00',is_buy='Y',reason='|',fv_date='2017-04-06' WHERE custArea='S103' and custNo='90120025' and mn='04' and yr='2017' and collection='1' and rount='1';

04/26/2017||||||||||||||||04-26-2017 10:41:22 AM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'600462080','2017-04-26 00:00:00','Y','6908.0','|','20250429','1','2','2017-04-06' FROM c_cust_route WHERE custArea='S103' and custNo='90110053' and mn='04' and yr='2017'

04/26/2017||||||||||||||||04-26-2017 10:37:32 AM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'600462079','2017-04-26 00:00:00','Y','23594.64','|','20250429','1','2','2017-04-06' FROM c_cust_route WHERE custArea='S103' and custNo='90110008' and mn='04' and yr='2017'

04/26/2017||||||||||||||||04-26-2017 10:25:26 AM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'600461072','2017-04-26 00:00:00','Y','26075.0','| ลูกค้าขอด่วนครับ','20250429','1','2','2017-04-08' FROM c_cust_route WHERE custArea='S102' and custNo='84000026' and mn='04' and yr='2017'

04/26/2017||||||||||||||||04-26-2017 09:53:21 AM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'600441096','2017-04-26 00:00:00','Y','2480.0','|','20250429','1','2','2017-04-05' FROM c_cust_route WHERE custArea='N102' and custNo='57130020' and mn='04' and yr='2017'

04/26/2017||||||||||||||||04-26-2017 09:52:15 AM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'600441095','2017-04-26 00:00:00','Y','142370.0','|','20250429','1','2','2017-04-05' FROM c_cust_route WHERE custArea='N102' and custNo='57130010' and mn='04' and yr='2017'

04/26/2017||||||||||||||||04-26-2017 09:48:04 AM
Update c_cust_route set price_buy='109723.0',orderNo='600441094',visit_date='2017-04-26 00:00:00',is_buy='Y',reason='|',fv_date='2017-04-05' WHERE custArea='N102' and custNo='57000005' and mn='04' and yr='2017' and collection='1' and rount='1';

04/26/2017||||||||||||||||04-26-2017 09:47:48 AM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'600460069','2017-04-26 00:00:00','Y','19200.0','|','20250429','1','4','2017-04-07' FROM c_cust_route WHERE custArea='S101' and custNo='81000024' and mn='04' and yr='2017'

04/26/2017||||||||||||||||04-26-2017 09:17:47 AM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'600440074','2017-04-26 00:00:00','Y','117700.0','| แถมพิเศษค่าบรรทุก80gหมู1หีบ','20250429','1','2','2017-04-06' FROM c_cust_route WHERE custArea='N101' and custNo='50000063' and mn='04' and yr='2017'

04/26/2017||||||||||||||||04-26-2017 09:14:22 AM
Update c_cust_route set price_buy='38400.0',orderNo='600440073',visit_date='2017-04-26 00:00:00',is_buy='Y',reason='| ใช้ขนส่งบริษัท',fv_date='2017-04-06' WHERE custArea='N101' and custNo='50000063' and mn='04' and yr='2017' and collection='1' and rount='1';

04/26/2017||||||||||||||||04-26-2017 09:12:12 AM
Update c_cust_route set price_buy='177420.0',orderNo='600440072',visit_date='2017-04-26 00:00:00',is_buy='Y',reason='| แถมรายการค่าบรรทุกอีก 1 หีบเป็น75กรัมหมู 1 หีบ',fv_date='2017-04-06' WHERE custArea='N101' and custNo='50000034' and mn='04' and yr='2017' and collection='1' and rount='1';

04/26/2017||||||||||||||||04-26-2017 07:16:54 PM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'','2017-04-26 00:00:00','N','0','สินค้าระบายไม่ดี |','20250429','1','2','2017-04-06' FROM c_cust_route WHERE custArea='N/E103' and custNo='47000052' and mn='04' and yr='2017'

04/26/2017||||||||||||||||04-26-2017 07:16:50 PM
Update c_cust_route set price_buy='0',orderNo='',visit_date='2017-04-26 00:00:00',is_buy='N',reason='สินค้าระบายไม่ดี |',fv_date='2017-04-06' WHERE custArea='N/E103' and custNo='47000052' and mn='04' and yr='2017' and collection='1' and rount='1';

04/26/2017||||||||||||||||04-26-2017 07:16:45 PM
Update c_cust_route set price_buy='0',orderNo='',visit_date='2017-04-26 00:00:00',is_buy='N',reason='สินค้าระบายไม่ดี |',fv_date='2017-04-06' WHERE custArea='N/E103' and custNo='47000047' and mn='04' and yr='2017' and collection='1' and rount='1';

04/26/2017||||||||||||||||04-26-2017 07:16:39 PM
Update c_cust_route set price_buy='0',orderNo='',visit_date='2017-04-26 00:00:00',is_buy='N',reason='สินค้าระบายไม่ดี |',fv_date='2017-04-06' WHERE custArea='N/E103' and custNo='47000037' and mn='04' and yr='2017' and collection='1' and rount='1';

04/26/2017||||||||||||||||04-26-2017 07:16:34 PM
Update c_cust_route set price_buy='0',orderNo='',visit_date='2017-04-26 00:00:00',is_buy='N',reason='สินค้าระบายไม่ดี |',fv_date='2017-04-06' WHERE custArea='N/E103' and custNo='47000029' and mn='04' and yr='2017' and collection='1' and rount='1';

04/26/2017||||||||||||||||04-26-2017 07:16:30 PM
Update c_cust_route set price_buy='0',orderNo='',visit_date='2017-04-26 00:00:00',is_buy='N',reason='สินค้าระบายไม่ดี |',fv_date='2017-04-06' WHERE custArea='N/E103' and custNo='47000008' and mn='04' and yr='2017' and collection='1' and rount='1';

04/26/2017||||||||||||||||04-26-2017 07:16:12 PM
Update c_cust_route set price_buy='0',orderNo='',visit_date='2017-04-26 00:00:00',is_buy='N',reason='สินค้าระบายไม่ดี |',fv_date='2017-04-06' WHERE custArea='N/E103' and custNo='47000035' and mn='04' and yr='2017' and collection='1' and rount='1';

04/26/2017||||||||||||||||04-26-2017 07:07:24 AM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'600451094','2017-04-26 00:00:00','Y','134210.0','| บิลปิดor6004/0000099/อ้างอิงod600451091/51092/51093 สำนักงานใหญ่ /ยกเลิกรายการเพราะ ยกเลิกบิล 600451091 หลังจากปิดบิลไปแล้ว','20250429','1','4','2017-04-08' FROM c_cust_route WHERE custArea='N/E102' and custNo='46000018' and mn='04' and yr='2017'

04/26/2017||||||||||||||||04-26-2017 06:49:46 AM
INSERT INTO c_cust_route (custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,orderNo,visit_date,is_buy,price_buy,reason,last_upd,collection,rount,fv_date) SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'600411134','2017-04-26 00:00:00','Y','27570.0','| บิล2อ้างอิงod6004-11069','20250429','2','2','2017-04-05' FROM c_cust_route WHERE custArea='B102' and custNo='12150023' and mn='04' and yr='2017'

04/26/2017||||||||||||||||04-26-2017 06:47:55 PM
Update c_cust_route set price_buy='0',orderNo='',visit_date='2017-04-26 00:00:00',is_buy='N',reason='ร้านค้าไม่ซื้อเพราะ ซื้อแมคโคร |',fv_date='2017-04-08' WHERE custArea='S102' and custNo='91000034' and mn='04' and yr='2017' and collection='1' and rount='1';

04/26/2017||||||||||||||||04-26-2017 06:47:46 PM
Update c_cust_route set price_buy='0',orderNo='',visit_date='2017-04-26 00:00:00',is_buy='N',reason='ซื้อกับยี่ปั๊ว |',fv_date='2017-04-08' WHERE custArea='S102' and custNo='91000033' and mn='04' and yr='2017' and collection='1' and rount='1';

04/26/2017||||||||||||||||04-26-2017 06:47:42 PM
Update c_cust_route set price_buy='0',orderNo='',visit_date='2017-04-26 00:00:00',is_buy='N',reason='สินค้าระบายไม่ดี |',fv_date='2017-04-08' WHERE custArea='S102' and custNo='91000030' and mn='04' and yr='2017' and collection='1' and rount='1';

04/26/2017||||||||||||||||04-26-2017 06:47:39 PM
Update c_cust_route set price_buy='0',orderNo='',visit_date='2017-04-26 00:00:00',is_buy='N',reason='ซื้อกับยี่ปั๊ว |',fv_date='2017-04-08' WHERE custArea='S102' and custNo='91000029' and mn='04' and yr='2017' and collection='1' and rount='1';

04/26/2017||||||||||||||||04-26-2017 06:47:35 PM
Update c_cust_route set price_buy='0',orderNo='',visit_date='2017-04-26 00:00:00',is_buy='N',reason='ซื้อกับยี่ปั๊ว |',fv_date='2017-04-08' WHERE custArea='S102' and custNo='91000020' and mn='04' and yr='2017' and collection='1' and rount='1';

04/26/2017||||||||||||||||04-26-2017 06:47:32 PM
Update c_cust_route set price_buy='0',orderNo='',visit_date='2017-04-26 00:00:00',is_buy='N',reason='สินค้าระบายไม่ดี |',fv_date='2017-04-08' WHERE custArea='S102' and custNo='91000009' and mn='04' and yr='2017' and collection='1' and rount='1';

04/26/2017||||||||||||||||04-26-2017 06:47:28 PM
Update c_cust_route set price_buy='0',orderNo='',visit_date='2017-04-26 00:00:00',is_buy='N',reason='สินค้าระบายไม่ดี |',fv_date='2017-04-08' WHERE custArea='S102' and custNo='91000001' and mn='04' and yr='2017' and collection='1' and rount='1';

04/26/2017||||||||||||||||04-26-2017 06:47:24 PM
Update c_cust_route set price_buy='0',orderNo='',visit_date='2017-04-26 00:00:00',is_buy='N',reason='ซื้อกับยี่ปั๊ว |',fv_date='2017-04-08' WHERE custArea='S102' and custNo='91000035' and mn='04' and yr='2017' and collection='1' and rount='1';

04/26/2017||||||||||||||||04-26-2017 05:02:50 PM
Update c_cust_route set price_buy='0',orderNo='',visit_date='2017-04-26 00:00:00',is_buy='N',reason='สินค้าระบายไม่ดี |',fv_date='2017-04-23' WHERE custArea='E101' and custNo='25150014' and mn='04' and yr='2017' and collection='1' and rount='1';

04/26/2017||||||||||||||||04-26-2017 05:02:44 PM
Update c_cust_route set price_buy='0',orderNo='',visit_date='2017-04-26 00:00:00',is_buy='N',reason='ซื้อกับยี่ปั๊ว |',fv_date='2017-04-23' WHERE custArea='E101' and custNo='25000026' and mn='04' and yr='2017' and collection='1' and rount='1';

04/26/2017||||||||||||||||04-26-2017 05:02:40 PM
Update c_cust_route set price_buy='0',orderNo='',visit_date='2017-04-26 00:00:00',is_buy='N',reason='สินค้าระบายไม่ดี |',fv_date='2017-04-23' WHERE custArea='E101' and custNo='25000005' and mn='04' and yr='2017' and collection='1' and rount='1';

04/26/2017||||||||||||||||04-26-2017 03:12:24 PM
Update c_cust_route set price_buy='0',orderNo='',visit_date='2017-04-26 00:00:00',is_buy='N',reason='ซื้อกับยี่ปั๊ว |',fv_date='2017-04-07' WHERE custArea='S101' and custNo='92140002' and mn='04' and yr='2017' and collection='1' and rount='1';

04/26/2017||||||||||||||||04-26-2017 03:12:18 PM
Update c_cust_route set price_buy='0',orderNo='',visit_date='2017-04-26 00:00:00',is_buy='N',reason='สินค้าระบายไม่ดี |',fv_date='2017-04-07' WHERE custArea='S101' and custNo='92140011' and mn='04' and yr='2017' and collection='1' and rount='1';

---

Update Visit Complete . . . All Rows is -> 130