2024/3/12 11:04:09 {"Head":{"relevantOrder":"2700981300388428626","orignalTotal":"27.50","ORDERSN":"MT202403121103561896","STOREGUID":"hzhzk324","SUBPHONE":"","ADDRESS":"非繁城品·菏泽曹县马金凤大戏楼店 (8851)","CONSIGNEE":"战(**)","PHONE":"17854132382_6492","CREATETIME":"2024-03-12 11:03:51","FTYPE":"送货","NOTES":"收货人隐私号 17854132382_6492,手机号 139****7261 ,备用隐私号码: [\"18854108491_8663\"]","BILLTYPE":"美团外卖","PRY":"在线支付","WEBJSFS":"50","ISFP":"0","ecsOrderID":"2700981300388428626","SPARE3":"hzhzk324"},"Entry":[{"HH":"DYY20201070","HYJ":"8.39","QUANTITY":"3","PRICE":"25.16","LSJ":"0.00"},{"HH":"440012","HYJ":"2.00","QUANTITY":"1","PRICE":"2.00","LSJ":"2.00"}]} 2024/3/12 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 ('MT202403121103561896', 'MT202403121103561896', '', '', '', '', '324', '', '非繁城品·菏泽曹县马金凤大戏楼店 (8851)', '战(**)', '17854132382_6492', '2024-03-12 11:03:51', '送货', '收货人隐私号 17854132382_6492,手机号 139****7261 ,备用隐私号码: ["18854108491_8663"]', '', '美团外卖', '在线支付', '50', '', '', '0', '', '', '','','2700981300388428626',getdate(),'HYBRIS', '','hzhzk324','','','','','','', '','','','','','','','','','') 2024/3/12 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 ('ab07f94110734890827a1979cc137140', 'MT202403121103561896', '', 'DYY20201070', '0.00', '8.39', '3', '25.16', '','','','','','','','','','','') 2024/3/12 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 ('4beec984086a4c0692788e87ea427087', 'MT202403121103561896', '', '440012', '2.00', '2.00', '1', '2.00', '','','','','','','','','','','') 2024/3/12 12:16:49 {"Head":{"relevantOrder":"2700981373433664515","orignalTotal":"26.60","ORDERSN":"MT202403121216369980","STOREGUID":"hzhzk340","SUBPHONE":"","ADDRESS":"永泰和顺园 (19号楼一单元1402)","CONSIGNEE":"曹(**)","PHONE":"18416720911_5037","CREATETIME":"2024-03-12 12:15:45","FTYPE":"送货","NOTES":"收货人隐私号 18416720911_5037,手机号 151****3725 ,备用隐私号码: [\"18416712978_5623\"]","BILLTYPE":"美团外卖","PRY":"在线支付","WEBJSFS":"50","ISFP":"0","ecsOrderID":"2700981373433664515","SPARE3":"hzhzk340"},"Entry":[{"HH":"DYY1010573","HYJ":"22.86","QUANTITY":"1","PRICE":"22.86","LSJ":"0.00"},{"HH":"440012","HYJ":"2.00","QUANTITY":"1","PRICE":"2.00","LSJ":"2.00"}]} 2024/3/12 12:16:49 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 ('MT202403121216369980', 'MT202403121216369980', '', '', '', '', '340', '', '永泰和顺园 (19号楼一单元1402)', '曹(**)', '18416720911_5037', '2024-03-12 12:15:45', '送货', '收货人隐私号 18416720911_5037,手机号 151****3725 ,备用隐私号码: ["18416712978_5623"]', '', '美团外卖', '在线支付', '50', '', '', '0', '', '', '','','2700981373433664515',getdate(),'HYBRIS', '','hzhzk340','','','','','','', '','','','','','','','','','') 2024/3/12 12:16:49 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 ('0953a987bcec41aab7cb59a9763340d6', 'MT202403121216369980', '', 'DYY1010573', '0.00', '22.86', '1', '22.86', '','','','','','','','','','','') 2024/3/12 12:16:49 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 ('7103062dda1a47d7a5a5df1d2c0b31fe', 'MT202403121216369980', '', '440012', '2.00', '2.00', '1', '2.00', '','','','','','','','','','','') 2024/3/12 13:42:05 {"Head":{"relevantOrder":"2600981463145898333","orignalTotal":"27.50","ORDERSN":"MT202403121340474578","USERID":"","STOREGUID":"hzhzk432","SUBPHONE":"","ADDRESS":"银座佳驿(菏泽曹县湘江东路磐石新城店)","CONSIGNEE":"白(**)","PHONE":"17854132475_0239","CREATETIME":"2024-03-12 13:40:44","FTYPE":"送货","NOTES":"收货人隐私号 17854132475_0239,手机号 159****3351 ,备用隐私号码: [\"18854154695_9862\"]","BILLTYPE":"美团外卖","PRY":"在线支付","WEBJSFS":"50","ISFP":"0","ecsOrderID":"2600981463145898333","SPARE3":"hzhzk432"},"Entry":[{"HH":"DYY1010018","HYJ":"2.34","QUANTITY":"1","PRICE":"2.34","LSJ":"0.00"},{"HH":"DYY2020414","HYJ":"19.99","QUANTITY":"1","PRICE":"19.99","LSJ":"0.00"},{"HH":"440012","HYJ":"2.00","QUANTITY":"1","PRICE":"2.00","LSJ":"2.00"}]} 2024/3/12 13:42:05 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 ('MT202403121340474578', 'MT202403121340474578', '', '', '', '', '432', '', '银座佳驿(菏泽曹县湘江东路磐石新城店)', '白(**)', '17854132475_0239', '2024-03-12 13:40:44', '送货', '收货人隐私号 17854132475_0239,手机号 159****3351 ,备用隐私号码: ["18854154695_9862"]', '', '美团外卖', '在线支付', '50', '', '', '0', '', '', '','','2600981463145898333',getdate(),'HYBRIS', '','hzhzk432','','','','','','', '','','','','','','','','','') 2024/3/12 13:42:05 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 ('daefd4a31df1423696285caa291a78f2', 'MT202403121340474578', '', 'DYY1010018', '0.00', '2.34', '1', '2.34', '','','','','','','','','','','') 2024/3/12 13:42:05 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 ('6ad2a15a752e4b9aa44351afe39d74da', 'MT202403121340474578', '', 'DYY2020414', '0.00', '19.99', '1', '19.99', '','','','','','','','','','','') 2024/3/12 13:42:05 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 ('0c1d9bbd39fa469da5be3e22392df9a3', 'MT202403121340474578', '', '440012', '2.00', '2.00', '1', '2.00', '','','','','','','','','','','') 2024/3/12 13:42:37 {"Head":{"relevantOrder":"2600981463145898333","orignalTotal":"27.50","ORDERSN":"MT202403121340474578","STOREGUID":"hzhzk432","SUBPHONE":"","ADDRESS":"银座佳驿(菏泽曹县湘江东路磐石新城店)","CONSIGNEE":"白(**)","PHONE":"17854132475_0239","CREATETIME":"2024-03-12 13:40:44","FTYPE":"送货","NOTES":"收货人隐私号 17854132475_0239,手机号 159****3351 ,备用隐私号码: [\"18854154695_9862\"]","BILLTYPE":"美团外卖","PRY":"在线支付","WEBJSFS":"50","ISFP":"0","ecsOrderID":"2600981463145898333","SPARE3":"hzhzk432"},"Entry":[{"HH":"DYY1010018","HYJ":"2.34","QUANTITY":"1","PRICE":"2.34","LSJ":"0.00"},{"HH":"DYY2020414","HYJ":"19.99","QUANTITY":"1","PRICE":"19.99","LSJ":"0.00"},{"HH":"440012","HYJ":"2.00","QUANTITY":"1","PRICE":"2.00","LSJ":"2.00"}]} 2024/3/12 13:42:37 O2O订单接口异常:O2O订单号:MT202403121340474578已存在 2024/3/12 17:37:37 {"Head":{"relevantOrder":"2700981691227142638","orignalTotal":"30.00","ORDERSN":"MT202403121737259891","STOREGUID":"hzhzk433","SUBPHONE":"","ADDRESS":"银座精宿(菏泽曹县青岛南路财富城店) (4楼411)","CONSIGNEE":"戚(**)","PHONE":"18416721115_2300","CREATETIME":"2024-03-12 17:36:40","FTYPE":"送货","NOTES":"收货人隐私号 18416721115_2300,手机号 135****4147 ,备用隐私号码: [\"18416708191_6275\"]","BILLTYPE":"美团外卖","PRY":"在线支付","WEBJSFS":"50","ISFP":"0","ecsOrderID":"2700981691227142638","SPARE3":"hzhzk433"},"Entry":[{"HH":"DYY10119798","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/12 17:37: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 ('MT202403121737259891', 'MT202403121737259891', '', '', '', '', '433', '', '银座精宿(菏泽曹县青岛南路财富城店) (4楼411)', '戚(**)', '18416721115_2300', '2024-03-12 17:36:40', '送货', '收货人隐私号 18416721115_2300,手机号 135****4147 ,备用隐私号码: ["18416708191_6275"]', '', '美团外卖', '在线支付', '50', '', '', '0', '', '', '','','2700981691227142638',getdate(),'HYBRIS', '','hzhzk433','','','','','','', '','','','','','','','','','') 2024/3/12 17:37: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 ('e207a0115415420290c4dc25cd6f8d71', 'MT202403121737259891', '', 'DYY10119798', '0.00', '26.44', '1', '26.44', '','','','','','','','','','','') 2024/3/12 17:37: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 ('8dbb8d2ad72843958c6c78c64351659c', 'MT202403121737259891', '', '440012', '2.00', '2.00', '1', '2.00', '','','','','','','','','','','') 2024/3/12 18:56:47 {"Head":{"relevantOrder":"2700981773346172010","orignalTotal":"27.56","ORDERSN":"MT202403121856347000","STOREGUID":"hzhzk403","SUBPHONE":"","ADDRESS":"曹县天润城 (一期18栋2单元102)","CONSIGNEE":"唐(**)","PHONE":"17854132390_8180","CREATETIME":"2024-03-12 18:56:30","FTYPE":"送货","NOTES":"收货人隐私号 17854132390_8180,手机号 155****0993 ,备用隐私号码: [\"18854168045_1334\"]","BILLTYPE":"美团外卖","PRY":"在线支付","WEBJSFS":"50","ISFP":"0","ecsOrderID":"2700981773346172010","SPARE3":"hzhzk403"},"Entry":[{"HH":"DYY11000777","HYJ":"9.82","QUANTITY":"1","PRICE":"9.82","LSJ":"0.00"},{"HH":"DYY10400067","HYJ":"14.12","QUANTITY":"1","PRICE":"14.12","LSJ":"0.00"},{"HH":"440012","HYJ":"2.00","QUANTITY":"1","PRICE":"2.00","LSJ":"2.00"}]} 2024/3/12 18: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 ('MT202403121856347000', 'MT202403121856347000', '', '', '', '', '403', '', '曹县天润城 (一期18栋2单元102)', '唐(**)', '17854132390_8180', '2024-03-12 18:56:30', '送货', '收货人隐私号 17854132390_8180,手机号 155****0993 ,备用隐私号码: ["18854168045_1334"]', '', '美团外卖', '在线支付', '50', '', '', '0', '', '', '','','2700981773346172010',getdate(),'HYBRIS', '','hzhzk403','','','','','','', '','','','','','','','','','') 2024/3/12 18: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 ('b0b3c19366c74142b59e09dad30d5a47', 'MT202403121856347000', '', 'DYY11000777', '0.00', '9.82', '1', '9.82', '','','','','','','','','','','') 2024/3/12 18: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 ('5c929f9ca22d470697bd2deb953457f9', 'MT202403121856347000', '', 'DYY10400067', '0.00', '14.12', '1', '14.12', '','','','','','','','','','','') 2024/3/12 18: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 ('8aa7b45507454febbebbda6fcbf7c452', 'MT202403121856347000', '', '440012', '2.00', '2.00', '1', '2.00', '','','','','','','','','','','') 2024/3/12 19:32:10 {"Head":{"relevantOrder":"3000981813263405663","orignalTotal":"41.80","ORDERSN":"MT202403121931578122","STOREGUID":"hzhzk324","SUBPHONE":"","ADDRESS":"月星家居 (月星家居西门穗宝床垫电梯口处)","CONSIGNEE":"李梦(**)","PHONE":"18416713112_6228","CREATETIME":"2024-03-12 19:31:53","FTYPE":"送货","NOTES":"收货人隐私号 18416713112_6228,手机号 132****3619 ,备用隐私号码: [\"17854131586_8102\"]","BILLTYPE":"美团外卖","PRY":"在线支付","WEBJSFS":"50","ISFP":"0","ecsOrderID":"3000981813263405663","SPARE3":"hzhzk324"},"Entry":[{"HH":"DYY1040058","HYJ":"20.81","QUANTITY":"1","PRICE":"20.81","LSJ":"0.00"},{"HH":"DYY1031513","HYJ":"17.19","QUANTITY":"1","PRICE":"17.19","LSJ":"0.00"},{"HH":"440012","HYJ":"2.00","QUANTITY":"1","PRICE":"2.00","LSJ":"2.00"}]} 2024/3/12 19:32:10 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 ('MT202403121931578122', 'MT202403121931578122', '', '', '', '', '324', '', '月星家居 (月星家居西门穗宝床垫电梯口处)', '李梦(**)', '18416713112_6228', '2024-03-12 19:31:53', '送货', '收货人隐私号 18416713112_6228,手机号 132****3619 ,备用隐私号码: ["17854131586_8102"]', '', '美团外卖', '在线支付', '50', '', '', '0', '', '', '','','3000981813263405663',getdate(),'HYBRIS', '','hzhzk324','','','','','','', '','','','','','','','','','') 2024/3/12 19:32:10 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 ('432c0489a0c744a995014c8b7e53c931', 'MT202403121931578122', '', 'DYY1040058', '0.00', '20.81', '1', '20.81', '','','','','','','','','','','') 2024/3/12 19:32:10 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 ('a4e72f1008f74b708ad60905ca5d5449', 'MT202403121931578122', '', 'DYY1031513', '0.00', '17.19', '1', '17.19', '','','','','','','','','','','') 2024/3/12 19:32:10 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 ('1b8e6ceaf4a845de9cb68da04b7b7c62', 'MT202403121931578122', '', '440012', '2.00', '2.00', '1', '2.00', '','','','','','','','','','','') 2024/3/12 19:33:50 {"Head":{"relevantOrder":"2700981814224217499","orignalTotal":"41.00","ORDERSN":"MT202403121933388753","STOREGUID":"hzhzk382","SUBPHONE":"","ADDRESS":"水岸城邦A区 (23号楼1单元四楼402室)","CONSIGNEE":"宋(**)","PHONE":"18854164725_1587","CREATETIME":"2024-03-12 19:33:26","FTYPE":"送货","NOTES":"收货人隐私号 18854164725_1587,手机号 158****3807 ,备用隐私号码: [\"18416720907_1653\"]","BILLTYPE":"美团外卖","PRY":"在线支付","WEBJSFS":"50","ISFP":"0","ecsOrderID":"2700981814224217499","SPARE3":"hzhzk382"},"Entry":[{"HH":"DYY20300085","HYJ":"37.22","QUANTITY":"1","PRICE":"37.22","LSJ":"0.00"},{"HH":"440012","HYJ":"2.00","QUANTITY":"1","PRICE":"2.00","LSJ":"2.00"}]} 2024/3/12 19:33:50 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 ('MT202403121933388753', 'MT202403121933388753', '', '', '', '', '382', '', '水岸城邦A区 (23号楼1单元四楼402室)', '宋(**)', '18854164725_1587', '2024-03-12 19:33:26', '送货', '收货人隐私号 18854164725_1587,手机号 158****3807 ,备用隐私号码: ["18416720907_1653"]', '', '美团外卖', '在线支付', '50', '', '', '0', '', '', '','','2700981814224217499',getdate(),'HYBRIS', '','hzhzk382','','','','','','', '','','','','','','','','','') 2024/3/12 19:33:50 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 ('5ece23b08e8d4c1aa81543219b213243', 'MT202403121933388753', '', 'DYY20300085', '0.00', '37.22', '1', '37.22', '','','','','','','','','','','') 2024/3/12 19:33:50 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 ('0add5950e24b43f49f44c712e9530686', 'MT202403121933388753', '', '440012', '2.00', '2.00', '1', '2.00', '','','','','','','','','','','') 2024/3/12 19:36:56 {"Head":{"relevantOrder":"2700981814224217499","ORDERSN":"TK202403121936334369","ORIGINALNUMBER":"MT202403121933388753","USERID":"","STOREGUID":"hzhzk382","ADDRESS":"水岸城邦A区 (23号楼1单元四楼402室)","CONSIGNEE":"宋(**)","PHONE":"18854164725_1587","CREATETIME":"2024-03-12 19:33:26","FTYPE":"送货","NOTES":"收货人隐私号 18854164725_1587,手机号 158****3807 ,备用隐私号码: [\"18416720907_1653\"]","BILLTYPE":"美团外卖","PRY":"在线支付","WEBJSFS":"50","ISFP":"0","ecsOrderID":"2700981814224217499","SPARE3":"hzhzk382"},"Entry":[{"HH":"DYY20300085","HYJ":"37.22","QUANTITY":"-1","PRICE":"-37.22","LSJ":"0.00","ZZF2":""},{"HH":"440012","HYJ":"2.00","QUANTITY":"-1","PRICE":"-2.00","LSJ":"2.00"}]} 2024/3/12 19:36:56 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 ('TK202403121936334369', 'TK202403121936334369', 'MT202403121933388753', '', '', '', '382', '', '水岸城邦A区 (23号楼1单元四楼402室)', '宋(**)', '18854164725_1587', '2024-03-12 19:33:26', '送货', '收货人隐私号 18854164725_1587,手机号 158****3807 ,备用隐私号码: ["18416720907_1653"]', '', '美团外卖', '在线支付', '50', '', '', '0', '', '', '','','2700981814224217499',getdate(),'HYBRIS', '','hzhzk382','','','','','','', '','','','','','','','','','') 2024/3/12 19:36:56 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 ('de86d46cc6e0439791b0be94a2328db9', 'TK202403121936334369', '', 'DYY20300085', '0.00', '37.22', '-1', '-37.22', '','','','','','','','','','','') 2024/3/12 19:36:56 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 ('6aed2005d6324c14b068d2647749a710', 'TK202403121936334369', '', '440012', '2.00', '2.00', '-1', '-2.00', '','','','','','','','','','','') 2024/3/12 20:49:17 {"Head":{"relevantOrder":"2600981873091567601","orignalTotal":"34.00","ORDERSN":"MT202403122049040998","STOREGUID":"hzhzk433","SUBPHONE":"","ADDRESS":"尚客优精选酒店(曹县迎宾大道店) (405)","CONSIGNEE":"潘崇震(**)","PHONE":"18416721185_7439","CREATETIME":"2024-03-12 20:38:13","FTYPE":"送货","NOTES":"收货人隐私号 18416721185_7439,手机号 176****8275 ,备用隐私号码: [\"18416708168_6710\"]","BILLTYPE":"美团外卖","PRY":"在线支付","WEBJSFS":"50","ISFP":"0","ecsOrderID":"2600981873091567601","SPARE3":"hzhzk433"},"Entry":[{"HH":"DYY1011206","HYJ":"30.36","QUANTITY":"1","PRICE":"30.36","LSJ":"0.00"},{"HH":"440012","HYJ":"2.00","QUANTITY":"1","PRICE":"2.00","LSJ":"2.00"}]} 2024/3/12 20:49: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 ('MT202403122049040998', 'MT202403122049040998', '', '', '', '', '433', '', '尚客优精选酒店(曹县迎宾大道店) (405)', '潘崇震(**)', '18416721185_7439', '2024-03-12 20:38:13', '送货', '收货人隐私号 18416721185_7439,手机号 176****8275 ,备用隐私号码: ["18416708168_6710"]', '', '美团外卖', '在线支付', '50', '', '', '0', '', '', '','','2600981873091567601',getdate(),'HYBRIS', '','hzhzk433','','','','','','', '','','','','','','','','','') 2024/3/12 20:49: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 ('7f4806af59b94ece9330cd562a305703', 'MT202403122049040998', '', 'DYY1011206', '0.00', '30.36', '1', '30.36', '','','','','','','','','','','') 2024/3/12 20:49: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 ('06d1416f78464f5c8086f262fe4c59c9', 'MT202403122049040998', '', '440012', '2.00', '2.00', '1', '2.00', '','','','','','','','','','','')