http://203.155.18.96/BCWEB_SERVICES/back/CREDIT_RouteJsonData.aspx?orderdate=20250906<br>2025-09-06<<<<<	
<br><br>
09/06/2025||||||||||||||||09-06-2025 16:33:14 PM<br>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,'680911015','2025-09-06 00:00:00','Y','193.0','ร้านค้าโทรสั่ง | บิล2:','20250906','1','2','2025-09-03' FROM c_cust_route  WHERE custArea='BE101' and custNo='10800032' and mn='09' and yr='2025'<br><br>09/06/2025||||||||||||||||09-06-2025 16:31:42 PM<br>Update c_cust_route set price_buy='32723.0',orderNo='680911014',visit_date='2025-09-06 00:00:00',is_buy='Y',reason='| บิล1:',fv_date='2025-09-03' WHERE custArea='BE101' and custNo='10800032' and mn='09' and yr='2025' and collection='1' and rount='1';<br><br>09/06/2025||||||||||||||||09-06-2025 16:29:35 PM<br>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,'680911013','2025-09-06 00:00:00','Y','955.0','ร้านค้าโทรสั่ง | บิล2:','20250906','1','2','2025-09-03' FROM c_cust_route  WHERE custArea='BE101' and custNo='10150172' and mn='09' and yr='2025'<br><br>09/06/2025||||||||||||||||09-06-2025 16:29:06 PM<br>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,'680911012','2025-09-06 00:00:00','Y','1910.0','ร้านค้าโทรสั่ง | บิล2:','20250906','1','2','2025-09-03' FROM c_cust_route  WHERE custArea='BE101' and custNo='10150148' and mn='09' and yr='2025'<br><br>09/06/2025||||||||||||||||09-06-2025 16:27:27 PM<br>Update c_cust_route set price_buy='99110.0',orderNo='680922003',visit_date='2025-09-06 00:00:00',is_buy='Y',reason='| บิล1:',fv_date='2025-09-04' WHERE custArea='NE101' and custNo='47160008' and mn='09' and yr='2025' and collection='1' and rount='1';<br><br>09/06/2025||||||||||||||||09-06-2025 15:41:05 PM<br>Update c_cust_route set price_buy='86300.0',orderNo='680930004',visit_date='2025-09-06 00:00:00',is_buy='Y',reason='ร้านค้าโทรสั่ง | โทรนัดก่อนส่ง/ส่งด่วน' WHERE custArea='NH102' and custNo='55000017' and mn='09' and yr='2025' and collection='1' and rount='1';<br><br>09/06/2025||||||||||||||||09-06-2025 15:14:46 PM<br>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)  SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'680936019','2025-09-06 00:00:00','Y','6225.0','| บิล2:อ้างอิง:680936018:ส่ง?วันที่?30/9/68','20250906','1','2' FROM c_cust_route  WHERE custArea='SH111' and custNo='86000050' and mn='09' and yr='2025'<br><br>09/06/2025||||||||||||||||09-06-2025 15:13:04 PM<br>Update c_cust_route set price_buy='7553.0',orderNo='680936018',visit_date='2025-09-06 00:00:00',is_buy='Y',reason='| บิล1:ส่งวันที่?16/9/68' WHERE custArea='SH111' and custNo='86000050' and mn='09' and yr='2025' and collection='1' and rount='1';<br><br>09/06/2025||||||||||||||||09-06-2025 14:45:45 PM<br>Update c_cust_route set price_buy='42202.0',orderNo='680918015',visit_date='2025-09-06 00:00:00',is_buy='Y',reason='|' WHERE custArea='CT121' and custNo='70110040' and mn='09' and yr='2025' and collection='1' and rount='1';<br><br>09/06/2025||||||||||||||||09-06-2025 14:43:15 PM<br>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)  SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'680918014','2025-09-06 00:00:00','Y','15767.0','| บิล2:อ้างอิง:680918013:','20250906','1','2' FROM c_cust_route  WHERE custArea='CT121' and custNo='71130002' and mn='09' and yr='2025'<br><br>09/06/2025||||||||||||||||09-06-2025 14:41:03 PM<br>Update c_cust_route set price_buy='25069.0',orderNo='680918013',visit_date='2025-09-06 00:00:00',is_buy='Y',reason='| บิล1:' WHERE custArea='CT121' and custNo='71130002' and mn='09' and yr='2025' and collection='1' and rount='1';<br><br>09/06/2025||||||||||||||||09-06-2025 14:31:45 PM<br>Update c_cust_route set price_buy='6134.0',orderNo='680936017',visit_date='2025-09-06 00:00:00',is_buy='Y',reason='|' WHERE custArea='SH111' and custNo='86000044' and mn='09' and yr='2025' and collection='1' and rount='1';<br><br>09/06/2025||||||||||||||||09-06-2025 14:12:46 PM<br>Update c_cust_route set price_buy='3946.0',orderNo='680931009',visit_date='2025-09-06 00:00:00',is_buy='Y',reason='| บิล1:' WHERE custArea='NH111' and custNo='51120003' and mn='09' and yr='2025' and collection='1' and rount='1';<br><br>09/06/2025||||||||||||||||09-06-2025 13:38:45 PM<br>Update c_cust_route set price_buy='7506.0',orderNo='680936016',visit_date='2025-09-06 00:00:00',is_buy='Y',reason='|' WHERE custArea='SH111' and custNo='86130024' and mn='09' and yr='2025' and collection='1' and rount='1';<br><br>09/06/2025||||||||||||||||09-06-2025 12:35:14 PM<br>Update c_cust_route set price_buy='139538.0',orderNo='680922002',visit_date='2025-09-06 00:00:00',is_buy='Y',reason='| บิล1:',fv_date='2025-09-04' WHERE custArea='NE101' and custNo='42000003' and mn='09' and yr='2025' and collection='1' and rount='1';<br><br>09/06/2025||||||||||||||||09-06-2025 12:19:36 PM<br>Update c_cust_route set price_buy='7720.0',orderNo='680934006',visit_date='2025-09-06 00:00:00',is_buy='Y',reason='| บิล1:ส่งด่วน' WHERE custArea='SH101' and custNo='84000053' and mn='09' and yr='2025' and collection='1' and rount='1';<br><br>09/06/2025||||||||||||||||09-06-2025 11:56:48 AM<br>Update c_cust_route set price_buy='6400.0',orderNo='680929005',visit_date='2025-09-06 00:00:00',is_buy='Y',reason='| บิล1:',fv_date='2025-09-04' WHERE custArea='NH101' and custNo='50000098' and mn='09' and yr='2025' and collection='1' and rount='1';<br><br>09/06/2025||||||||||||||||09-06-2025 11:02:49 AM<br>Update c_cust_route set price_buy='6670.0',orderNo='680934005',visit_date='2025-09-06 00:00:00',is_buy='Y',reason='| บิล1:โทรแจ้งล่วงหน้า1วัน' WHERE custArea='SH101' and custNo='86220008' and mn='09' and yr='2025' and collection='1' and rount='1';<br><br>09/06/2025||||||||||||||||09-06-2025 10:40:38 AM<br>Update c_cust_route set price_buy='37621.0',orderNo='680939006',visit_date='2025-09-06 00:00:00',is_buy='Y',reason='| บิล1:ส่งด่วน' WHERE custArea='NS111' and custNo='61000023' and mn='09' and yr='2025' and collection='1' and rount='1';<br><br>09/06/2025||||||||||||||||09-06-2025 10:38:58 AM<br>Update c_cust_route set price_buy='150860.0',orderNo='680929004',visit_date='2025-09-06 00:00:00',is_buy='Y',reason='ร้านค้าโทรสั่ง |',fv_date='2025-09-04' WHERE custArea='NH101' and custNo='57140010' and mn='09' and yr='2025' and collection='1' and rount='1';<br><br>09/06/2025||||||||||||||||09-06-2025 10:06:33 AM<br>Update c_cust_route set price_buy='22800.0',orderNo='680936015',visit_date='2025-09-06 00:00:00',is_buy='Y',reason='| บิล1:' WHERE custArea='SH111' and custNo='80160013' and mn='09' and yr='2025' and collection='1' and rount='1';<br><br>09/06/2025||||||||||||||||09-06-2025 10:04:46 AM<br>Update c_cust_route set price_buy='7310.0',orderNo='680918012',visit_date='2025-09-06 00:00:00',is_buy='Y',reason='| บิล1:' WHERE custArea='CT121' and custNo='75000049' and mn='09' and yr='2025' and collection='1' and rount='1';<br><br>09/06/2025||||||||||||||||09-06-2025 09:52:05 AM<br>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)  SELECT DISTINCT custNo,custName,custAddr,custPhono,custZone,custArea,custShop,custRoute,custDay,myDay,mn,yr,'680913011','2025-09-06 00:00:00','Y','193.0','| บิล2:','20250906','1','2' FROM c_cust_route  WHERE custArea='BE112' and custNo='10250090' and mn='09' and yr='2025'<br><br>09/06/2025||||||||||||||||09-06-2025 09:50:54 AM<br>Update c_cust_route set price_buy='4500.0',orderNo='680936014',visit_date='2025-09-06 00:00:00',is_buy='Y',reason='| บิล1:' WHERE custArea='SH111' and custNo='84220001' and mn='09' and yr='2025' and collection='1' and rount='1';<br><br>09/06/2025||||||||||||||||09-06-2025 09:50:41 AM<br>Update c_cust_route set price_buy='12607.0',orderNo='680913010',visit_date='2025-09-06 00:00:00',is_buy='Y',reason='| บิล1:' WHERE custArea='BE112' and custNo='10250090' and mn='09' and yr='2025' and collection='1' and rount='1';<br><br>09/06/2025||||||||||||||||09-06-2025 09:49:40 AM<br>Update c_cust_route set price_buy='2178.0',orderNo='680936013',visit_date='2025-09-06 00:00:00',is_buy='Y',reason='| บิล1:' WHERE custArea='SH111' and custNo='86170001' and mn='09' and yr='2025' and collection='1' and rount='1';<br><br>09/06/2025||||||||||||||||09-06-2025 09:41:13 AM<br>Update c_cust_route set price_buy='225250.0',orderNo='680913009',visit_date='2025-09-06 00:00:00',is_buy='Y',reason='ร้านค้าโทรสั่ง |' WHERE custArea='BE112' and custNo='10520073' and mn='09' and yr='2025' and collection='1' and rount='1';<br><br>09/06/2025||||||||||||||||09-06-2025 09:22:40 AM<br>Update c_cust_route set price_buy='32300.0',orderNo='680917016',visit_date='2025-09-06 00:00:00',is_buy='Y',reason='ร้านค้าโทรสั่ง | บิล1:' WHERE custArea='CT111' and custNo='12110039' and mn='09' and yr='2025' and collection='1' and rount='1';<br><br>INSERT INTO c_log_order_sync (number_row,date_update,sync_name) value ('28','2025-09-06 16:44','sync_visit_credit')<br><HR>Update Visit Complete . . . All Rows is -> 28