2024/3/8 8:09:27 {"Head":{"relevantOrder":"2700975362575426462","orignalTotal":"23.92","ORDERSN":"MT202403080809150452","STOREGUID":"hzhzk340","SUBPHONE":"","ADDRESS":"曹县磐石医院 (体检中心一楼)","CONSIGNEE":"李(**)","PHONE":"18416719885_6471","CREATETIME":"2024-03-08 08:08:53","FTYPE":"送货","NOTES":"收货人隐私号 18416719885_6471,手机号 187****7887 ,备用隐私号码: [\"18416721170_8040\"]","BILLTYPE":"美团外卖","PRY":"在线支付","WEBJSFS":"50","ISFP":"0","ecsOrderID":"2700975362575426462","SPARE3":"hzhzk340"},"Entry":[{"HH":"DYY1040082","HYJ":"9.54","QUANTITY":"1","PRICE":"9.54","LSJ":"0.00"},{"HH":"DYY2020379","HYJ":"5.42","QUANTITY":"2","PRICE":"10.83","LSJ":"0.00"},{"HH":"440012","HYJ":"2.00","QUANTITY":"1","PRICE":"2.00","LSJ":"2.00"}]} 2024/3/8 8:09:28 INSERT INTO WX_SY_ORDER (GUID, ORDERSN, ORIGINALNUMBER, USERID, WXID, QSTOREGUID, STOREGUID, SUBPHONE, ADDRESS, CONSIGNEE, PHONE, CREATETIME, FTYPE, NOTES, CSNOTES, BILLTYPE, PRY, WEBJSFS, ISPAY, FPNO, ISFP, ywy, RelevantOrder, wishtime, OPERATORGUID, ecsOrderID,BillDate, SPARE5,DSYWY, SPARE3, PSPHONE,shippingCode,orignalTotal,SPARE1,SPARE2,SPARE4, zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('MT202403080809150452', 'MT202403080809150452', '', '', '', '', '340', '', '曹县磐石医院 (体检中心一楼)', '李(**)', '18416719885_6471', '2024-03-08 08:08:53', '送货', '收货人隐私号 18416719885_6471,手机号 187****7887 ,备用隐私号码: ["18416721170_8040"]', '', '美团外卖', '在线支付', '50', '', '', '0', '', '', '','','2700975362575426462',getdate(),'HYBRIS', '','hzhzk340','','','','','','', '','','','','','','','','','') 2024/3/8 8:09:28 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('fb86b6b4889144b9bf60beb509c4a267', 'MT202403080809150452', '', 'DYY1040082', '0.00', '9.54', '1', '9.54', '','','','','','','','','','','') 2024/3/8 8:09:28 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('b74f06b0b5544128a8c8c5556cafeefb', 'MT202403080809150452', '', 'DYY2020379', '0.00', '5.42', '2', '10.83', '','','','','','','','','','','') 2024/3/8 8:09:28 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('6d088dee5e2e4f05846316b7f89443a0', 'MT202403080809150452', '', '440012', '2.00', '2.00', '1', '2.00', '','','','','','','','','','','') 2024/3/8 8:14:20 {"Head":{"relevantOrder":"2700974722575426462","ORDERSN":"TK202403080813262011","ORIGINALNUMBER":"MT202403072121509569","USERID":"","STOREGUID":"hzhzk379","ADDRESS":"曹县磐石医院 (体检中心一楼)","CONSIGNEE":"李(**)","PHONE":"18854168045_8502","CREATETIME":"2024-03-07 21:21:41","FTYPE":"送货","NOTES":"收货人隐私号 18854168045_8502,手机号 187****7887 ,备用隐私号码: [\"17854131626_6018\"]","BILLTYPE":"美团外卖","PRY":"在线支付","WEBJSFS":"50","ISFP":"0","ecsOrderID":"2700974722575426462","SPARE3":"hzhzk379"},"Entry":[{"HH":"DYY1040082","HYJ":"9.61","QUANTITY":"-1","PRICE":"-9.61","LSJ":"0.00","ZZF2":""},{"HH":"DYY1050715","HYJ":"5.17","QUANTITY":"-1","PRICE":"-5.17","LSJ":"0.00","ZZF2":""},{"HH":"DYY30103799","HYJ":"9.42","QUANTITY":"-1","PRICE":"-9.42","LSJ":"0.00","ZZF2":""},{"HH":"440012","HYJ":"2.00","QUANTITY":"-1","PRICE":"-2.00","LSJ":"2.00"}]} 2024/3/8 8:14:20 INSERT INTO WX_SY_ORDER (GUID, ORDERSN, ORIGINALNUMBER, USERID, WXID, QSTOREGUID, STOREGUID, SUBPHONE, ADDRESS, CONSIGNEE, PHONE, CREATETIME, FTYPE, NOTES, CSNOTES, BILLTYPE, PRY, WEBJSFS, ISPAY, FPNO, ISFP, ywy, RelevantOrder, wishtime, OPERATORGUID, ecsOrderID,BillDate, SPARE5,DSYWY, SPARE3, PSPHONE,shippingCode,orignalTotal,SPARE1,SPARE2,SPARE4, zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('TK202403080813262011', 'TK202403080813262011', 'MT202403072121509569', '', '', '', '379', '', '曹县磐石医院 (体检中心一楼)', '李(**)', '18854168045_8502', '2024-03-07 21:21:41', '送货', '收货人隐私号 18854168045_8502,手机号 187****7887 ,备用隐私号码: ["17854131626_6018"]', '', '美团外卖', '在线支付', '50', '', '', '0', '', '', '','','2700974722575426462',getdate(),'HYBRIS', '','hzhzk379','','','','','','', '','','','','','','','','','') 2024/3/8 8:14:20 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('2662b538edc246d48d1b36392164ef1f', 'TK202403080813262011', '', 'DYY1040082', '0.00', '9.61', '-1', '-9.61', '','','','','','','','','','','') 2024/3/8 8:14:20 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('537f388f54fa465293114192a79f0b3d', 'TK202403080813262011', '', 'DYY1050715', '0.00', '5.17', '-1', '-5.17', '','','','','','','','','','','') 2024/3/8 8:14:20 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('c66c38cac45347518d889efd4bbefa1b', 'TK202403080813262011', '', 'DYY30103799', '0.00', '9.42', '-1', '-9.42', '','','','','','','','','','','') 2024/3/8 8:14:20 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('c53e44b64eaf4dbd8aef62bc52c96f45', 'TK202403080813262011', '', '440012', '2.00', '2.00', '-1', '-2.00', '','','','','','','','','','','') 2024/3/8 8:24:21 {"Head":{"relevantOrder":"3100975382904483633","orignalTotal":"31.04","ORDERSN":"MT202403080824098688","STOREGUID":"hzhzk360","SUBPHONE":"","ADDRESS":"新都帝景花园东区回迁区-19号楼 (十九号楼二单元103)","CONSIGNEE":"高(**)","PHONE":"17854132569_5348","CREATETIME":"2024-03-08 08:23:59","FTYPE":"送货","NOTES":"收货人隐私号 17854132569_5348,手机号 170****6789 ,备用隐私号码: [\"18416712981_6817\"]","BILLTYPE":"美团外卖","PRY":"在线支付","WEBJSFS":"50","ISFP":"0","ecsOrderID":"3100975382904483633","SPARE3":"hzhzk360"},"Entry":[{"HH":"DYY1031338","HYJ":"19.42","QUANTITY":"1","PRICE":"19.42","LSJ":"0.00"},{"HH":"DYY1010117","HYJ":"7.75","QUANTITY":"1","PRICE":"7.75","LSJ":"0.00"},{"HH":"440012","HYJ":"2.00","QUANTITY":"1","PRICE":"2.00","LSJ":"2.00"}]} 2024/3/8 8:24:21 INSERT INTO WX_SY_ORDER (GUID, ORDERSN, ORIGINALNUMBER, USERID, WXID, QSTOREGUID, STOREGUID, SUBPHONE, ADDRESS, CONSIGNEE, PHONE, CREATETIME, FTYPE, NOTES, CSNOTES, BILLTYPE, PRY, WEBJSFS, ISPAY, FPNO, ISFP, ywy, RelevantOrder, wishtime, OPERATORGUID, ecsOrderID,BillDate, SPARE5,DSYWY, SPARE3, PSPHONE,shippingCode,orignalTotal,SPARE1,SPARE2,SPARE4, zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('MT202403080824098688', 'MT202403080824098688', '', '', '', '', '360', '', '新都帝景花园东区回迁区-19号楼 (十九号楼二单元103)', '高(**)', '17854132569_5348', '2024-03-08 08:23:59', '送货', '收货人隐私号 17854132569_5348,手机号 170****6789 ,备用隐私号码: ["18416712981_6817"]', '', '美团外卖', '在线支付', '50', '', '', '0', '', '', '','','3100975382904483633',getdate(),'HYBRIS', '','hzhzk360','','','','','','', '','','','','','','','','','') 2024/3/8 8:24:21 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('875c111b094943bca85b84fae9c03e4b', 'MT202403080824098688', '', 'DYY1031338', '0.00', '19.42', '1', '19.42', '','','','','','','','','','','') 2024/3/8 8:24:21 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('98ab51761dcb4118b0e9c78118dab614', 'MT202403080824098688', '', 'DYY1010117', '0.00', '7.75', '1', '7.75', '','','','','','','','','','','') 2024/3/8 8:24:21 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('cc87e718e2584935956c5edf8f2aec59', 'MT202403080824098688', '', '440012', '2.00', '2.00', '1', '2.00', '','','','','','','','','','','') 2024/3/8 11:04:08 {"Head":{"relevantOrder":"2700975540294909075","orignalTotal":"30.00","ORDERSN":"MT202403081103569681","STOREGUID":"hzhzk432","SUBPHONE":"","ADDRESS":"城市印象一站式广告服务 (嘉华大厦往西北门20米,城市印象广告)","CONSIGNEE":"李**(**)","PHONE":"18416708059_7372","CREATETIME":"2024-03-08 11:03:25","FTYPE":"送货","NOTES":"收货人隐私号 18416708059_7372,手机号 133****7085 ,备用隐私号码: [\"18416721006_7211\"]","BILLTYPE":"美团外卖","PRY":"在线支付","WEBJSFS":"50","ISFP":"0","ecsOrderID":"2700975540294909075","SPARE3":"hzhzk432"},"Entry":[{"HH":"DYY11150160","HYJ":"26.44","QUANTITY":"1","PRICE":"26.44","LSJ":"0.00"},{"HH":"440012","HYJ":"2.00","QUANTITY":"1","PRICE":"2.00","LSJ":"2.00"}]} 2024/3/8 11:04:09 INSERT INTO WX_SY_ORDER (GUID, ORDERSN, ORIGINALNUMBER, USERID, WXID, QSTOREGUID, STOREGUID, SUBPHONE, ADDRESS, CONSIGNEE, PHONE, CREATETIME, FTYPE, NOTES, CSNOTES, BILLTYPE, PRY, WEBJSFS, ISPAY, FPNO, ISFP, ywy, RelevantOrder, wishtime, OPERATORGUID, ecsOrderID,BillDate, SPARE5,DSYWY, SPARE3, PSPHONE,shippingCode,orignalTotal,SPARE1,SPARE2,SPARE4, zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('MT202403081103569681', 'MT202403081103569681', '', '', '', '', '432', '', '城市印象一站式广告服务 (嘉华大厦往西北门20米,城市印象广告)', '李**(**)', '18416708059_7372', '2024-03-08 11:03:25', '送货', '收货人隐私号 18416708059_7372,手机号 133****7085 ,备用隐私号码: ["18416721006_7211"]', '', '美团外卖', '在线支付', '50', '', '', '0', '', '', '','','2700975540294909075',getdate(),'HYBRIS', '','hzhzk432','','','','','','', '','','','','','','','','','') 2024/3/8 11:04:09 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('f16727a93d4a4212bbd3f533fe542fbd', 'MT202403081103569681', '', 'DYY11150160', '0.00', '26.44', '1', '26.44', '','','','','','','','','','','') 2024/3/8 11:04:09 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('b84b15f8218949179cd97e4870a79e91', 'MT202403081103569681', '', '440012', '2.00', '2.00', '1', '2.00', '','','','','','','','','','','') 2024/3/8 12:53:48 {"Head":{"relevantOrder":"2000975652115039123","orignalTotal":"292.00","ORDERSN":"MT202403081253348374","STOREGUID":"hzhzk340","SUBPHONE":"","ADDRESS":"天润城二期-8号楼 (2单元1001)","CONSIGNEE":"许(**)","PHONE":"17854132509_4908","CREATETIME":"2024-03-08 12:53:26","FTYPE":"送货","NOTES":"收货人隐私号 17854132509_4908,手机号 133****8210 ,备用隐私号码: []","BILLTYPE":"美团外卖","PRY":"在线支付","WEBJSFS":"50","ISFP":"0","ecsOrderID":"2000975652115039123","SPARE3":"hzhzk340"},"Entry":[{"HH":"DYY1040337","HYJ":"283.20","QUANTITY":"1","PRICE":"283.20","LSJ":"0.00"},{"HH":"440012","HYJ":"2.00","QUANTITY":"1","PRICE":"2.00","LSJ":"2.00"}]} 2024/3/8 12:53:48 INSERT INTO WX_SY_ORDER (GUID, ORDERSN, ORIGINALNUMBER, USERID, WXID, QSTOREGUID, STOREGUID, SUBPHONE, ADDRESS, CONSIGNEE, PHONE, CREATETIME, FTYPE, NOTES, CSNOTES, BILLTYPE, PRY, WEBJSFS, ISPAY, FPNO, ISFP, ywy, RelevantOrder, wishtime, OPERATORGUID, ecsOrderID,BillDate, SPARE5,DSYWY, SPARE3, PSPHONE,shippingCode,orignalTotal,SPARE1,SPARE2,SPARE4, zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('MT202403081253348374', 'MT202403081253348374', '', '', '', '', '340', '', '天润城二期-8号楼 (2单元1001)', '许(**)', '17854132509_4908', '2024-03-08 12:53:26', '送货', '收货人隐私号 17854132509_4908,手机号 133****8210 ,备用隐私号码: []', '', '美团外卖', '在线支付', '50', '', '', '0', '', '', '','','2000975652115039123',getdate(),'HYBRIS', '','hzhzk340','','','','','','', '','','','','','','','','','') 2024/3/8 12:53:48 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('0747d61da6cd422d8985fd429565b0ee', 'MT202403081253348374', '', 'DYY1040337', '0.00', '283.20', '1', '283.20', '','','','','','','','','','','') 2024/3/8 12:53:48 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('61e30cfaf53544f7bb067cf0f9e6d1be', 'MT202403081253348374', '', '440012', '2.00', '2.00', '1', '2.00', '','','','','','','','','','','') 2024/3/8 17:41:30 {"Head":{"relevantOrder":"2900975940391718047","orignalTotal":"24.28","ORDERSN":"MT202403081741173564","STOREGUID":"hzhzk360","SUBPHONE":"","ADDRESS":"阳光城市四区-10号楼","CONSIGNEE":"孔龙(**)","PHONE":"18416721070_1967","CREATETIME":"2024-03-08 17:40:41","FTYPE":"送货","NOTES":"收货人隐私号 18416721070_1967,手机号 156****7651 ,备用隐私号码: [\"18416708219_7689\"]","BILLTYPE":"美团外卖","PRY":"在线支付","WEBJSFS":"50","ISFP":"0","ecsOrderID":"2900975940391718047","SPARE3":"hzhzk360"},"Entry":[{"HH":"DYY1050163","HYJ":"4.88","QUANTITY":"3","PRICE":"14.63","LSJ":"0.00"},{"HH":"DYY1031248","HYJ":"6.36","QUANTITY":"1","PRICE":"6.36","LSJ":"0.00"},{"HH":"440012","HYJ":"2.00","QUANTITY":"1","PRICE":"2.00","LSJ":"2.00"}]} 2024/3/8 17:41:30 INSERT INTO WX_SY_ORDER (GUID, ORDERSN, ORIGINALNUMBER, USERID, WXID, QSTOREGUID, STOREGUID, SUBPHONE, ADDRESS, CONSIGNEE, PHONE, CREATETIME, FTYPE, NOTES, CSNOTES, BILLTYPE, PRY, WEBJSFS, ISPAY, FPNO, ISFP, ywy, RelevantOrder, wishtime, OPERATORGUID, ecsOrderID,BillDate, SPARE5,DSYWY, SPARE3, PSPHONE,shippingCode,orignalTotal,SPARE1,SPARE2,SPARE4, zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('MT202403081741173564', 'MT202403081741173564', '', '', '', '', '360', '', '阳光城市四区-10号楼', '孔龙(**)', '18416721070_1967', '2024-03-08 17:40:41', '送货', '收货人隐私号 18416721070_1967,手机号 156****7651 ,备用隐私号码: ["18416708219_7689"]', '', '美团外卖', '在线支付', '50', '', '', '0', '', '', '','','2900975940391718047',getdate(),'HYBRIS', '','hzhzk360','','','','','','', '','','','','','','','','','') 2024/3/8 17:41:30 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('cae73b35bf7f4aa8982924f7b4816897', 'MT202403081741173564', '', 'DYY1050163', '0.00', '4.88', '3', '14.63', '','','','','','','','','','','') 2024/3/8 17:41:30 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('d21990f510be4b109c5ea3c7de0fb95f', 'MT202403081741173564', '', 'DYY1031248', '0.00', '6.36', '1', '6.36', '','','','','','','','','','','') 2024/3/8 17:41:30 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('3fe07befe4484c19a6233b1d49a83fd1', 'MT202403081741173564', '', '440012', '2.00', '2.00', '1', '2.00', '','','','','','','','','','','') 2024/3/8 18:00:17 {"Head":{"relevantOrder":"2700975950949669271","orignalTotal":"110.20","ORDERSN":"MT202403081800052307","STOREGUID":"hzhzk324","SUBPHONE":"","ADDRESS":"嘉信西湖公馆 (西湖公馆南门9-1-1001)","CONSIGNEE":"叶子(**)","PHONE":"18416712997_7584","CREATETIME":"2024-03-08 17:59:48","FTYPE":"送货","NOTES":"收货人隐私号 18416712997_7584,手机号 178****0062 ,备用隐私号码: [\"17854131631_7780\"]","BILLTYPE":"美团外卖","PRY":"在线支付","WEBJSFS":"50","ISFP":"0","ecsOrderID":"2700975950949669271","SPARE3":"hzhzk324"},"Entry":[{"HH":"DYY1011603020","HYJ":"21.87","QUANTITY":"3","PRICE":"65.59","LSJ":"0.00"},{"HH":"DYY30103742","HYJ":"35.15","QUANTITY":"1","PRICE":"35.15","LSJ":"0.00"},{"HH":"440012","HYJ":"2.00","QUANTITY":"1","PRICE":"2.00","LSJ":"2.00"}]} 2024/3/8 18:00:17 INSERT INTO WX_SY_ORDER (GUID, ORDERSN, ORIGINALNUMBER, USERID, WXID, QSTOREGUID, STOREGUID, SUBPHONE, ADDRESS, CONSIGNEE, PHONE, CREATETIME, FTYPE, NOTES, CSNOTES, BILLTYPE, PRY, WEBJSFS, ISPAY, FPNO, ISFP, ywy, RelevantOrder, wishtime, OPERATORGUID, ecsOrderID,BillDate, SPARE5,DSYWY, SPARE3, PSPHONE,shippingCode,orignalTotal,SPARE1,SPARE2,SPARE4, zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('MT202403081800052307', 'MT202403081800052307', '', '', '', '', '324', '', '嘉信西湖公馆 (西湖公馆南门9-1-1001)', '叶子(**)', '18416712997_7584', '2024-03-08 17:59:48', '送货', '收货人隐私号 18416712997_7584,手机号 178****0062 ,备用隐私号码: ["17854131631_7780"]', '', '美团外卖', '在线支付', '50', '', '', '0', '', '', '','','2700975950949669271',getdate(),'HYBRIS', '','hzhzk324','','','','','','', '','','','','','','','','','') 2024/3/8 18:00:17 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('3ea6190d92f146c3b8d300826f841124', 'MT202403081800052307', '', 'DYY1011603020', '0.00', '21.87', '3', '65.59', '','','','','','','','','','','') 2024/3/8 18:00:17 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('4216bb528f1b438fabaad4968747cbbb', 'MT202403081800052307', '', 'DYY30103742', '0.00', '35.15', '1', '35.15', '','','','','','','','','','','') 2024/3/8 18:00:17 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('8be5712591b74e1d925e0dc438eb75eb', 'MT202403081800052307', '', '440012', '2.00', '2.00', '1', '2.00', '','','','','','','','','','','') 2024/3/8 19:12:25 {"Head":{"relevantOrder":"2700976022431701454","orignalTotal":"24.60","ORDERSN":"MT202403081912123023","STOREGUID":"hzhzk432","SUBPHONE":"","ADDRESS":"丽枫酒店(曹县金砖义乌国际商贸城店) (酒店左边亮灯二楼)","CONSIGNEE":"康(**)","PHONE":"18416708178_8088","CREATETIME":"2024-03-08 19:09:23","FTYPE":"送货","NOTES":"收货人隐私号 18416708178_8088,手机号 175****3090 ,备用隐私号码: [\"17854133442_6043\"]","BILLTYPE":"美团外卖","PRY":"在线支付","WEBJSFS":"50","ISFP":"0","ecsOrderID":"2700976022431701454","SPARE3":"hzhzk432"},"Entry":[{"HH":"DYY1010080","HYJ":"6.11","QUANTITY":"1","PRICE":"6.11","LSJ":"0.00"},{"HH":"DYY1011203036","HYJ":"14.97","QUANTITY":"1","PRICE":"14.97","LSJ":"0.00"},{"HH":"440012","HYJ":"2.00","QUANTITY":"1","PRICE":"2.00","LSJ":"2.00"}]} 2024/3/8 19:12:25 INSERT INTO WX_SY_ORDER (GUID, ORDERSN, ORIGINALNUMBER, USERID, WXID, QSTOREGUID, STOREGUID, SUBPHONE, ADDRESS, CONSIGNEE, PHONE, CREATETIME, FTYPE, NOTES, CSNOTES, BILLTYPE, PRY, WEBJSFS, ISPAY, FPNO, ISFP, ywy, RelevantOrder, wishtime, OPERATORGUID, ecsOrderID,BillDate, SPARE5,DSYWY, SPARE3, PSPHONE,shippingCode,orignalTotal,SPARE1,SPARE2,SPARE4, zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('MT202403081912123023', 'MT202403081912123023', '', '', '', '', '432', '', '丽枫酒店(曹县金砖义乌国际商贸城店) (酒店左边亮灯二楼)', '康(**)', '18416708178_8088', '2024-03-08 19:09:23', '送货', '收货人隐私号 18416708178_8088,手机号 175****3090 ,备用隐私号码: ["17854133442_6043"]', '', '美团外卖', '在线支付', '50', '', '', '0', '', '', '','','2700976022431701454',getdate(),'HYBRIS', '','hzhzk432','','','','','','', '','','','','','','','','','') 2024/3/8 19:12:25 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('20f533c1c1ca48c8b74e19d0e8c45be6', 'MT202403081912123023', '', 'DYY1010080', '0.00', '6.11', '1', '6.11', '','','','','','','','','','','') 2024/3/8 19:12:25 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('7807b95bb1ec4b3fb654a4d288138090', 'MT202403081912123023', '', 'DYY1011203036', '0.00', '14.97', '1', '14.97', '','','','','','','','','','','') 2024/3/8 19:12:25 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('7748a1ddfe0445d0a24f760cdc9bd788', 'MT202403081912123023', '', '440012', '2.00', '2.00', '1', '2.00', '','','','','','','','','','','') 2024/3/8 19:47:00 {"Head":{"relevantOrder":"300976061651338980","orignalTotal":"57.00","ORDERSN":"MT202403081946475650","STOREGUID":"hzhzk360","SUBPHONE":"","ADDRESS":"曹县水邑澳洲酒店(人民公园店) (1301)","CONSIGNEE":"龙(**)","PHONE":"18416713098_7875","CREATETIME":"2024-03-08 19:45:08","FTYPE":"送货","NOTES":"收货人隐私号 18416713098_7875,手机号 151****9741 ,备用隐私号码: [\"17854132434_2035\"]","BILLTYPE":"美团外卖","PRY":"在线支付","WEBJSFS":"50","ISFP":"0","ecsOrderID":"300976061651338980","SPARE3":"hzhzk360"},"Entry":[{"HH":"DYY1010208065","HYJ":"52.90","QUANTITY":"1","PRICE":"52.90","LSJ":"0.00"},{"HH":"440012","HYJ":"2.00","QUANTITY":"1","PRICE":"2.00","LSJ":"2.00"}]} 2024/3/8 19:47:00 INSERT INTO WX_SY_ORDER (GUID, ORDERSN, ORIGINALNUMBER, USERID, WXID, QSTOREGUID, STOREGUID, SUBPHONE, ADDRESS, CONSIGNEE, PHONE, CREATETIME, FTYPE, NOTES, CSNOTES, BILLTYPE, PRY, WEBJSFS, ISPAY, FPNO, ISFP, ywy, RelevantOrder, wishtime, OPERATORGUID, ecsOrderID,BillDate, SPARE5,DSYWY, SPARE3, PSPHONE,shippingCode,orignalTotal,SPARE1,SPARE2,SPARE4, zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('MT202403081946475650', 'MT202403081946475650', '', '', '', '', '360', '', '曹县水邑澳洲酒店(人民公园店) (1301)', '龙(**)', '18416713098_7875', '2024-03-08 19:45:08', '送货', '收货人隐私号 18416713098_7875,手机号 151****9741 ,备用隐私号码: ["17854132434_2035"]', '', '美团外卖', '在线支付', '50', '', '', '0', '', '', '','','300976061651338980',getdate(),'HYBRIS', '','hzhzk360','','','','','','', '','','','','','','','','','') 2024/3/8 19:47:00 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('699e47884bcc432286550acb68393c02', 'MT202403081946475650', '', 'DYY1010208065', '0.00', '52.90', '1', '52.90', '','','','','','','','','','','') 2024/3/8 19:47:00 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('87d4a08a1eae4e779a807f78ec13fa30', 'MT202403081946475650', '', '440012', '2.00', '2.00', '1', '2.00', '','','','','','','','','','','') 2024/3/8 19:47:02 {"Head":{"relevantOrder":"300976061651338980","orignalTotal":"57.00","ORDERSN":"MT202403081946475650","USERID":"","STOREGUID":"hzhzk360","SUBPHONE":"","ADDRESS":"曹县水邑澳洲酒店(人民公园店) (1301)","CONSIGNEE":"龙(**)","PHONE":"18416713098_7875","CREATETIME":"2024-03-08 19:45:08","FTYPE":"送货","NOTES":"收货人隐私号 18416713098_7875,手机号 151****9741 ,备用隐私号码: [\"17854132434_2035\"]","BILLTYPE":"美团外卖","PRY":"在线支付","WEBJSFS":"50","ISFP":"0","ecsOrderID":"300976061651338980","SPARE3":"hzhzk360"},"Entry":[{"HH":"DYY1010208065","HYJ":"52.90","QUANTITY":"1","PRICE":"52.90","LSJ":"0.00"},{"HH":"440012","HYJ":"2.00","QUANTITY":"1","PRICE":"2.00","LSJ":"2.00"}]} 2024/3/8 19:47:02 O2O订单接口异常:O2O订单号:MT202403081946475650已存在 2024/3/8 21:17:15 {"Head":{"relevantOrder":"2700976150679742801","orignalTotal":"24.00","ORDERSN":"MT202403082116424066","USERID":"","STOREGUID":"hzhzk379","SUBPHONE":"","ADDRESS":"环岛花园-东门 (紫竹苑2号楼二单元102)","CONSIGNEE":"薛(**)","PHONE":"18416720913_7722","CREATETIME":"2024-03-08 21:16:31","FTYPE":"送货","NOTES":"收货人隐私号 18416720913_7722,手机号 183****5533 ,备用隐私号码: [\"18854188254_3514\"]","BILLTYPE":"美团外卖","PRY":"在线支付","WEBJSFS":"50","ISFP":"0","ecsOrderID":"2700976150679742801","SPARE3":"hzhzk379"},"Entry":[{"HH":"DYY1040590","HYJ":"20.56","QUANTITY":"1","PRICE":"20.56","LSJ":"0.00"},{"HH":"440012","HYJ":"2.00","QUANTITY":"1","PRICE":"2.00","LSJ":"2.00"}]} 2024/3/8 21:17:16 INSERT INTO WX_SY_ORDER (GUID, ORDERSN, ORIGINALNUMBER, USERID, WXID, QSTOREGUID, STOREGUID, SUBPHONE, ADDRESS, CONSIGNEE, PHONE, CREATETIME, FTYPE, NOTES, CSNOTES, BILLTYPE, PRY, WEBJSFS, ISPAY, FPNO, ISFP, ywy, RelevantOrder, wishtime, OPERATORGUID, ecsOrderID,BillDate, SPARE5,DSYWY, SPARE3, PSPHONE,shippingCode,orignalTotal,SPARE1,SPARE2,SPARE4, zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('MT202403082116424066', 'MT202403082116424066', '', '', '', '', '379', '', '环岛花园-东门 (紫竹苑2号楼二单元102)', '薛(**)', '18416720913_7722', '2024-03-08 21:16:31', '送货', '收货人隐私号 18416720913_7722,手机号 183****5533 ,备用隐私号码: ["18854188254_3514"]', '', '美团外卖', '在线支付', '50', '', '', '0', '', '', '','','2700976150679742801',getdate(),'HYBRIS', '','hzhzk379','','','','','','', '','','','','','','','','','') 2024/3/8 21:17:16 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('ef240dae42f94b06bfe6e7a41004a623', 'MT202403082116424066', '', 'DYY1040590', '0.00', '20.56', '1', '20.56', '','','','','','','','','','','') 2024/3/8 21:17:16 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('3d267d4146794ee498b1fb929d364bf2', 'MT202403082116424066', '', '440012', '2.00', '2.00', '1', '2.00', '','','','','','','','','','','') 2024/3/8 21:26:01 {"Head":{"relevantOrder":"2700976160794759394","orignalTotal":"36.00","ORDERSN":"MT202403082125426316","USERID":"","STOREGUID":"hzhzk379","SUBPHONE":"","ADDRESS":"亿联世家 (亿联世家8号楼一单元2501)","CONSIGNEE":"管玲(**)","PHONE":"18854138410_3556","CREATETIME":"2024-03-08 21:25:01","FTYPE":"送货","NOTES":"收货人隐私号 18854138410_3556,手机号 158****9834 ,备用隐私号码: [\"17854133196_6878\"]","BILLTYPE":"美团外卖","PRY":"在线支付","WEBJSFS":"50","ISFP":"0","ecsOrderID":"2700976160794759394","SPARE3":"hzhzk379"},"Entry":[{"HH":"DYY11000687","HYJ":"32.32","QUANTITY":"1","PRICE":"32.32","LSJ":"0.00"},{"HH":"440012","HYJ":"2.00","QUANTITY":"1","PRICE":"2.00","LSJ":"2.00"}]} 2024/3/8 21:26:01 INSERT INTO WX_SY_ORDER (GUID, ORDERSN, ORIGINALNUMBER, USERID, WXID, QSTOREGUID, STOREGUID, SUBPHONE, ADDRESS, CONSIGNEE, PHONE, CREATETIME, FTYPE, NOTES, CSNOTES, BILLTYPE, PRY, WEBJSFS, ISPAY, FPNO, ISFP, ywy, RelevantOrder, wishtime, OPERATORGUID, ecsOrderID,BillDate, SPARE5,DSYWY, SPARE3, PSPHONE,shippingCode,orignalTotal,SPARE1,SPARE2,SPARE4, zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('MT202403082125426316', 'MT202403082125426316', '', '', '', '', '379', '', '亿联世家 (亿联世家8号楼一单元2501)', '管玲(**)', '18854138410_3556', '2024-03-08 21:25:01', '送货', '收货人隐私号 18854138410_3556,手机号 158****9834 ,备用隐私号码: ["17854133196_6878"]', '', '美团外卖', '在线支付', '50', '', '', '0', '', '', '','','2700976160794759394',getdate(),'HYBRIS', '','hzhzk379','','','','','','', '','','','','','','','','','') 2024/3/8 21:26:01 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('e281731a9dac4610bcc2ad40ae8a6423', 'MT202403082125426316', '', 'DYY11000687', '0.00', '32.32', '1', '32.32', '','','','','','','','','','','') 2024/3/8 21:26:01 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('71c1f18347044439985ecd8a17c0c607', 'MT202403082125426316', '', '440012', '2.00', '2.00', '1', '2.00', '','','','','','','','','','','') 2024/3/8 21:26:03 {"Head":{"relevantOrder":"2700976160794759394","orignalTotal":"36.00","ORDERSN":"MT202403082125426316","USERID":"","STOREGUID":"hzhzk379","SUBPHONE":"","ADDRESS":"亿联世家 (亿联世家8号楼一单元2501)","CONSIGNEE":"管玲(**)","PHONE":"18854138410_3556","CREATETIME":"2024-03-08 21:25:01","FTYPE":"送货","NOTES":"收货人隐私号 18854138410_3556,手机号 158****9834 ,备用隐私号码: [\"17854133196_6878\"]","BILLTYPE":"美团外卖","PRY":"在线支付","WEBJSFS":"50","ISFP":"0","ecsOrderID":"2700976160794759394","SPARE3":"hzhzk379"},"Entry":[{"HH":"DYY11000687","HYJ":"32.32","QUANTITY":"1","PRICE":"32.32","LSJ":"0.00"},{"HH":"440012","HYJ":"2.00","QUANTITY":"1","PRICE":"2.00","LSJ":"2.00"}]} 2024/3/8 21:26:03 O2O订单接口异常:O2O订单号:MT202403082125426316已存在 2024/3/8 21:43:30 {"Head":{"relevantOrder":"2700976182771306465","orignalTotal":"27.00","ORDERSN":"MT202403082143186987","STOREGUID":"hzhzk324","SUBPHONE":"","ADDRESS":"华永小区 (华永公寓 )","CONSIGNEE":"李(**)","PHONE":"18416713043_8128","CREATETIME":"2024-03-08 21:42:29","FTYPE":"送货","NOTES":"收货人隐私号 18416713043_8128,手机号 151****1319 ,备用隐私号码: [\"17854132557_9324\"]","BILLTYPE":"美团外卖","PRY":"在线支付","WEBJSFS":"50","ISFP":"0","ecsOrderID":"2700976182771306465","SPARE3":"hzhzk324"},"Entry":[{"HH":"DYY10100170","HYJ":"23.50","QUANTITY":"1","PRICE":"23.50","LSJ":"0.00"},{"HH":"440012","HYJ":"2.00","QUANTITY":"1","PRICE":"2.00","LSJ":"2.00"}]} 2024/3/8 21:43:30 INSERT INTO WX_SY_ORDER (GUID, ORDERSN, ORIGINALNUMBER, USERID, WXID, QSTOREGUID, STOREGUID, SUBPHONE, ADDRESS, CONSIGNEE, PHONE, CREATETIME, FTYPE, NOTES, CSNOTES, BILLTYPE, PRY, WEBJSFS, ISPAY, FPNO, ISFP, ywy, RelevantOrder, wishtime, OPERATORGUID, ecsOrderID,BillDate, SPARE5,DSYWY, SPARE3, PSPHONE,shippingCode,orignalTotal,SPARE1,SPARE2,SPARE4, zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('MT202403082143186987', 'MT202403082143186987', '', '', '', '', '324', '', '华永小区 (华永公寓 )', '李(**)', '18416713043_8128', '2024-03-08 21:42:29', '送货', '收货人隐私号 18416713043_8128,手机号 151****1319 ,备用隐私号码: ["17854132557_9324"]', '', '美团外卖', '在线支付', '50', '', '', '0', '', '', '','','2700976182771306465',getdate(),'HYBRIS', '','hzhzk324','','','','','','', '','','','','','','','','','') 2024/3/8 21:43:30 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('8313237d24084b11836e56ddd6ae99fb', 'MT202403082143186987', '', 'DYY10100170', '0.00', '23.50', '1', '23.50', '','','','','','','','','','','') 2024/3/8 21:43:30 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('34b92bd5773a47c6b0b13188d9e7ff33', 'MT202403082143186987', '', '440012', '2.00', '2.00', '1', '2.00', '','','','','','','','','','','') 2024/3/8 21:46:07 {"Head":{"relevantOrder":"4031730067281481306","orignalTotal":"40.40","ORDERSN":"EM202403082146018875","STOREGUID":"hzhzk340","SUBPHONE":"","ADDRESS":"[隐私保护]顾客地址已隐藏,您可登录饿了么商家端或骑手端查看","CONSIGNEE":"段**","PHONE":"17895302561,567","CREATETIME":"2024-03-08 21:45:40","FTYPE":"送货","NOTES":"挂门把手上不用敲门 ,备用隐私号码: ","BILLTYPE":"饿了么","PRY":"在线支付","WEBJSFS":"52","ISFP":"0","ecsOrderID":"4031730067281481306","SPARE3":"hzhzk340"},"Entry":[{"HH":"DYY10221186540024","HYJ":"32.00","QUANTITY":"1","PRICE":"32.00","LSJ":"0.00"},{"HH":"DYY1030051","HYJ":"3.40","QUANTITY":"1","PRICE":"3.40","LSJ":"0.00"},{"HH":"440012","HYJ":"5.0","QUANTITY":"1","PRICE":"5.0","LSJ":"5.0"}]} 2024/3/8 21:46:08 INSERT INTO WX_SY_ORDER (GUID, ORDERSN, ORIGINALNUMBER, USERID, WXID, QSTOREGUID, STOREGUID, SUBPHONE, ADDRESS, CONSIGNEE, PHONE, CREATETIME, FTYPE, NOTES, CSNOTES, BILLTYPE, PRY, WEBJSFS, ISPAY, FPNO, ISFP, ywy, RelevantOrder, wishtime, OPERATORGUID, ecsOrderID,BillDate, SPARE5,DSYWY, SPARE3, PSPHONE,shippingCode,orignalTotal,SPARE1,SPARE2,SPARE4, zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('EM202403082146018875', 'EM202403082146018875', '', '', '', '', '340', '', '[隐私保护]顾客地址已隐藏,您可登录饿了么商家端或骑手端查看', '段**', '17895302561,567', '2024-03-08 21:45:40', '送货', '挂门把手上不用敲门 ,备用隐私号码: ', '', '饿了么', '在线支付', '52', '', '', '0', '', '', '','','4031730067281481306',getdate(),'HYBRIS', '','hzhzk340','','','','','','', '','','','','','','','','','') 2024/3/8 21:46:08 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('1189276519d347109e279b07e79343a4', 'EM202403082146018875', '', 'DYY10221186540024', '0.00', '32.00', '1', '32.00', '','','','','','','','','','','') 2024/3/8 21:46:08 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('8cc699a6f77d4e358e617763613c9165', 'EM202403082146018875', '', 'DYY1030051', '0.00', '3.40', '1', '3.40', '','','','','','','','','','','') 2024/3/8 21:46:08 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('721ed19752144284a893986414a94814', 'EM202403082146018875', '', '440012', '5.0', '5.0', '1', '5.0', '','','','','','','','','','','') 2024/3/8 21:48:59 {"Head":{"relevantOrder":"2600976180022970941","orignalTotal":"29.00","ORDERSN":"MT202403082148474648","STOREGUID":"hzhzk324","SUBPHONE":"","ADDRESS":"恒吉新都汇-4号楼-2单元 (504)","CONSIGNEE":"姚(**)","PHONE":"18416721109_4265","CREATETIME":"2024-03-08 21:45:54","FTYPE":"送货","NOTES":"收货人隐私号 18416721109_4265,手机号 199****7080 ,备用隐私号码: [\"18854163432_3655\"]","BILLTYPE":"美团外卖","PRY":"在线支付","WEBJSFS":"50","ISFP":"0","ecsOrderID":"2600976180022970941","SPARE3":"hzhzk324"},"Entry":[{"HH":"DYY1030480","HYJ":"14.14","QUANTITY":"1","PRICE":"14.14","LSJ":"0.00"},{"HH":"DYY1030254","HYJ":"11.20","QUANTITY":"1","PRICE":"11.20","LSJ":"0.00"},{"HH":"440012","HYJ":"2.00","QUANTITY":"1","PRICE":"2.00","LSJ":"2.00"}]} 2024/3/8 21:48:59 INSERT INTO WX_SY_ORDER (GUID, ORDERSN, ORIGINALNUMBER, USERID, WXID, QSTOREGUID, STOREGUID, SUBPHONE, ADDRESS, CONSIGNEE, PHONE, CREATETIME, FTYPE, NOTES, CSNOTES, BILLTYPE, PRY, WEBJSFS, ISPAY, FPNO, ISFP, ywy, RelevantOrder, wishtime, OPERATORGUID, ecsOrderID,BillDate, SPARE5,DSYWY, SPARE3, PSPHONE,shippingCode,orignalTotal,SPARE1,SPARE2,SPARE4, zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('MT202403082148474648', 'MT202403082148474648', '', '', '', '', '324', '', '恒吉新都汇-4号楼-2单元 (504)', '姚(**)', '18416721109_4265', '2024-03-08 21:45:54', '送货', '收货人隐私号 18416721109_4265,手机号 199****7080 ,备用隐私号码: ["18854163432_3655"]', '', '美团外卖', '在线支付', '50', '', '', '0', '', '', '','','2600976180022970941',getdate(),'HYBRIS', '','hzhzk324','','','','','','', '','','','','','','','','','') 2024/3/8 21:48:59 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('bf936530e7b944eab8f902bb1d909eb1', 'MT202403082148474648', '', 'DYY1030480', '0.00', '14.14', '1', '14.14', '','','','','','','','','','','') 2024/3/8 21:48:59 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('fc5c3b20b3f04fb89ef4c9fa578c1f0b', 'MT202403082148474648', '', 'DYY1030254', '0.00', '11.20', '1', '11.20', '','','','','','','','','','','') 2024/3/8 21:48:59 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('f36f432614b04b13804e79365803bc12', 'MT202403082148474648', '', '440012', '2.00', '2.00', '1', '2.00', '','','','','','','','','','','') 2024/3/8 21:56:47 {"Head":{"relevantOrder":"2700976194079767751","orignalTotal":"50.00","ORDERSN":"MT202403082156346532","STOREGUID":"hzhzk324","SUBPHONE":"","ADDRESS":"金源旅社 (金源超市对面 最西边楼梯,顶层西户)","CONSIGNEE":"刘(**)","PHONE":"18416703255_5794","CREATETIME":"2024-03-08 21:52:19","FTYPE":"送货","NOTES":"收货人隐私号 18416703255_5794,手机号 182****0605 ,备用隐私号码: [\"17854132470_0421\"]","BILLTYPE":"美团外卖","PRY":"在线支付","WEBJSFS":"50","ISFP":"0","ecsOrderID":"2700976194079767751","SPARE3":"hzhzk324"},"Entry":[{"HH":"DYY2040273","HYJ":"32.24","QUANTITY":"1","PRICE":"32.24","LSJ":"0.00"},{"HH":"440012","HYJ":"2.00","QUANTITY":"1","PRICE":"2.00","LSJ":"2.00"}]} 2024/3/8 21:56:47 INSERT INTO WX_SY_ORDER (GUID, ORDERSN, ORIGINALNUMBER, USERID, WXID, QSTOREGUID, STOREGUID, SUBPHONE, ADDRESS, CONSIGNEE, PHONE, CREATETIME, FTYPE, NOTES, CSNOTES, BILLTYPE, PRY, WEBJSFS, ISPAY, FPNO, ISFP, ywy, RelevantOrder, wishtime, OPERATORGUID, ecsOrderID,BillDate, SPARE5,DSYWY, SPARE3, PSPHONE,shippingCode,orignalTotal,SPARE1,SPARE2,SPARE4, zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('MT202403082156346532', 'MT202403082156346532', '', '', '', '', '324', '', '金源旅社 (金源超市对面 最西边楼梯,顶层西户)', '刘(**)', '18416703255_5794', '2024-03-08 21:52:19', '送货', '收货人隐私号 18416703255_5794,手机号 182****0605 ,备用隐私号码: ["17854132470_0421"]', '', '美团外卖', '在线支付', '50', '', '', '0', '', '', '','','2700976194079767751',getdate(),'HYBRIS', '','hzhzk324','','','','','','', '','','','','','','','','','') 2024/3/8 21:56:47 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('7fb1a51c80fa462d93805e2a93f20442', 'MT202403082156346532', '', 'DYY2040273', '0.00', '32.24', '1', '32.24', '','','','','','','','','','','') 2024/3/8 21:56:47 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('eb01e20351c04f3d89ae8848eec16e8b', 'MT202403082156346532', '', '440012', '2.00', '2.00', '1', '2.00', '','','','','','','','','','','') 2024/3/8 22:05:38 {"Head":{"relevantOrder":"2700976204079767751","orignalTotal":"50.00","ORDERSN":"MT202403082205268376","STOREGUID":"hzhzk324","SUBPHONE":"","ADDRESS":"金源旅社 (金源超市对面 最西边楼梯,顶层西户)","CONSIGNEE":"刘(**)","PHONE":"18854189084_3725","CREATETIME":"2024-03-08 22:02:30","FTYPE":"送货","NOTES":"收货人隐私号 18854189084_3725,手机号 182****0605 ,备用隐私号码: [\"17854132450_4577\"]","BILLTYPE":"美团外卖","PRY":"在线支付","WEBJSFS":"50","ISFP":"0","ecsOrderID":"2700976204079767751","SPARE3":"hzhzk324"},"Entry":[{"HH":"DYY2040273","HYJ":"32.24","QUANTITY":"1","PRICE":"32.24","LSJ":"0.00"},{"HH":"440012","HYJ":"2.00","QUANTITY":"1","PRICE":"2.00","LSJ":"2.00"}]} 2024/3/8 22:05:38 INSERT INTO WX_SY_ORDER (GUID, ORDERSN, ORIGINALNUMBER, USERID, WXID, QSTOREGUID, STOREGUID, SUBPHONE, ADDRESS, CONSIGNEE, PHONE, CREATETIME, FTYPE, NOTES, CSNOTES, BILLTYPE, PRY, WEBJSFS, ISPAY, FPNO, ISFP, ywy, RelevantOrder, wishtime, OPERATORGUID, ecsOrderID,BillDate, SPARE5,DSYWY, SPARE3, PSPHONE,shippingCode,orignalTotal,SPARE1,SPARE2,SPARE4, zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('MT202403082205268376', 'MT202403082205268376', '', '', '', '', '324', '', '金源旅社 (金源超市对面 最西边楼梯,顶层西户)', '刘(**)', '18854189084_3725', '2024-03-08 22:02:30', '送货', '收货人隐私号 18854189084_3725,手机号 182****0605 ,备用隐私号码: ["17854132450_4577"]', '', '美团外卖', '在线支付', '50', '', '', '0', '', '', '','','2700976204079767751',getdate(),'HYBRIS', '','hzhzk324','','','','','','', '','','','','','','','','','') 2024/3/8 22:05:38 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('6f58d0311a3a466cb7e4f2780ebac048', 'MT202403082205268376', '', 'DYY2040273', '0.00', '32.24', '1', '32.24', '','','','','','','','','','','') 2024/3/8 22:05:38 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('fdb6337276094e789a43d211a132961f', 'MT202403082205268376', '', '440012', '2.00', '2.00', '1', '2.00', '','','','','','','','','','','') 2024/3/8 22:24:02 {"Head":{"relevantOrder":"2600976224259866290","orignalTotal":"36.00","ORDERSN":"MT202403082223496475","STOREGUID":"hzhzk324","SUBPHONE":"","ADDRESS":"运通·聚富中心-9号楼 (聚富中心9号楼203)","CONSIGNEE":"黄(**)","PHONE":"18854151224_3796","CREATETIME":"2024-03-08 22:21:08","FTYPE":"送货","NOTES":"收货人隐私号 18854151224_3796,手机号 150****8772 ,备用隐私号码: [\"17854133201_0878\"]","BILLTYPE":"美团外卖","PRY":"在线支付","WEBJSFS":"50","ISFP":"0","ecsOrderID":"2600976224259866290","SPARE3":"hzhzk324"},"Entry":[{"HH":"DYY1010819","HYJ":"5.70","QUANTITY":"1","PRICE":"5.70","LSJ":"0.00"},{"HH":"DYY1040362","HYJ":"26.62","QUANTITY":"1","PRICE":"26.62","LSJ":"0.00"},{"HH":"440012","HYJ":"2.00","QUANTITY":"1","PRICE":"2.00","LSJ":"2.00"}]} 2024/3/8 22:24:02 INSERT INTO WX_SY_ORDER (GUID, ORDERSN, ORIGINALNUMBER, USERID, WXID, QSTOREGUID, STOREGUID, SUBPHONE, ADDRESS, CONSIGNEE, PHONE, CREATETIME, FTYPE, NOTES, CSNOTES, BILLTYPE, PRY, WEBJSFS, ISPAY, FPNO, ISFP, ywy, RelevantOrder, wishtime, OPERATORGUID, ecsOrderID,BillDate, SPARE5,DSYWY, SPARE3, PSPHONE,shippingCode,orignalTotal,SPARE1,SPARE2,SPARE4, zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('MT202403082223496475', 'MT202403082223496475', '', '', '', '', '324', '', '运通·聚富中心-9号楼 (聚富中心9号楼203)', '黄(**)', '18854151224_3796', '2024-03-08 22:21:08', '送货', '收货人隐私号 18854151224_3796,手机号 150****8772 ,备用隐私号码: ["17854133201_0878"]', '', '美团外卖', '在线支付', '50', '', '', '0', '', '', '','','2600976224259866290',getdate(),'HYBRIS', '','hzhzk324','','','','','','', '','','','','','','','','','') 2024/3/8 22:24:02 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('96154829a2aa468f9e05b58883fbca47', 'MT202403082223496475', '', 'DYY1010819', '0.00', '5.70', '1', '5.70', '','','','','','','','','','','') 2024/3/8 22:24:02 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('846621f91bc54838aacca96518b6294e', 'MT202403082223496475', '', 'DYY1040362', '0.00', '26.62', '1', '26.62', '','','','','','','','','','','') 2024/3/8 22:24:02 INSERT INTO WX_SY_ORDERDETAIL(GUID, WXSYORDERGUID, DETAILNO, HH,LSJ, HYJ, QUANTITY, PRICE, NOTES,zzf1, zzf2, zzf3, zzf4, zzf5, zzf6, zzf7, zzf8, zzf9, zzf10) VALUES ('9013677030a14d879a557308e0ae3279', 'MT202403082223496475', '', '440012', '2.00', '2.00', '1', '2.00', '','','','','','','','','','','')