Credit UPDATE ORDER

http://203.155.18.96/BCWEB_SERVICES/JSON_CREDIT_sendRouteSaveNotSelling.aspx?DATE_FROM=20250615&DATE_TO=20250615&TEST=0
2025-06-15

SELECT id FROM report_not_selling WHERE CusCode LIKE '%33110013%' and VisitDate = '2025-06-15 09:40:00 AM' and Route = '11'

SELECT id FROM report_not_selling WHERE CusCode LIKE '%33110025%' and VisitDate = '2025-06-15 02:22:39 PM' and Route = '11'

SELECT id FROM report_not_selling WHERE CusCode LIKE '%23150001%' and VisitDate = '2025-06-15 04:49:51 PM' and Route = '11'

SELECT id FROM report_not_selling WHERE CusCode LIKE '%73110009%' and VisitDate = '2025-06-15 09:32:21 AM' and Route = '25'

SELECT id FROM report_not_selling WHERE CusCode LIKE '%23000017%' and VisitDate = '2025-06-15 04:50:20 PM' and Route = '13'

SELECT id FROM report_not_selling WHERE CusCode LIKE '%23000020%' and VisitDate = '2025-06-15 04:50:39 PM' and Route = '13'

SELECT id FROM report_not_selling WHERE CusCode LIKE '%21170001%' and VisitDate = '2025-06-15 04:51:24 PM' and Route = '14'

SELECT id FROM report_not_selling WHERE CusCode LIKE '%44150004%' and VisitDate = '2025-06-15 12:13:24 PM' and Route = '11'

SELECT id FROM report_not_selling WHERE CusCode LIKE '%44140011%' and VisitDate = '2025-06-15 03:33:24 PM' and Route = '13'

SELECT id FROM report_not_selling WHERE CusCode LIKE '%17130010%' and VisitDate = '2025-06-15 07:14:59 AM' and Route = '03'

SELECT id FROM report_not_selling WHERE CusCode LIKE '%72170005%' and VisitDate = '2025-06-15 07:15:33 AM' and Route = '04'

SELECT id FROM report_not_selling WHERE CusCode LIKE '%72170006%' and VisitDate = '2025-06-15 07:16:00 AM' and Route = '04'

SELECT id FROM report_not_selling WHERE CusCode LIKE '%18000036%' and VisitDate = '2025-06-15 07:16:45 AM' and Route = '14'

SELECT id FROM report_not_selling WHERE CusCode LIKE '%24120014%' and VisitDate = '2025-06-15 09:07:11 AM' and Route = '05'

SELECT id FROM report_not_selling WHERE CusCode LIKE '%12150051%' and VisitDate = '2025-06-15 09:07:17 AM' and Route = '05'

SELECT id FROM report_not_selling WHERE CusCode LIKE '%24120004%' and VisitDate = '2025-06-15 09:07:26 AM' and Route = '05'

SELECT id FROM report_not_selling WHERE CusCode LIKE '%24120028%' and VisitDate = '2025-06-15 09:07:37 AM' and Route = '05'

SELECT id FROM report_not_selling WHERE CusCode LIKE '%12000031%' and VisitDate = '2025-06-15 09:07:44 AM' and Route = '05'

SELECT id FROM report_not_selling WHERE CusCode LIKE '%24120033%' and VisitDate = '2025-06-15 09:07:56 AM' and Route = '05'

SELECT id FROM report_not_selling WHERE CusCode LIKE '%24000031%' and VisitDate = '2025-06-15 02:52:12 PM' and Route = '02'

SELECT id FROM report_not_selling WHERE CusCode LIKE '%41000112%' and VisitDate = '2025-06-15 06:23:43 PM' and Route = '14'

SELECT id FROM report_not_selling WHERE CusCode LIKE '%41000130%' and VisitDate = '2025-06-15 06:24:03 PM' and Route = '14'

SELECT id FROM report_not_selling WHERE CusCode LIKE '%41000137%' and VisitDate = '2025-06-15 06:24:18 PM' and Route = '14'

SELECT id FROM report_not_selling WHERE CusCode LIKE '%%' and VisitDate = '' and Route = ''

INSERT INTO c_log_order_sync (number_row,date_update,sync_name,visit_date) value ('24','2025-06-15 21:07','sync_credit_not_sell','20250615')

Update Order Complete . . . All Rows is -> 24