2024/1/10 14:56:47 {"Head":{"relevantOrder":"2600892003683025253","ORDERSN":"TK202401101456382238","ORIGINALNUMBER":"FZ202401101438309436","USERID":"","STOREGUID":"hzhzk301","ADDRESS":"金叶小区6号楼一单元","CONSIGNEE":"王(**)","PHONE":"18416708121_2381","CREATETIME":"2024-01-10 14:38:31","FTYPE":"送货","NOTES":"收货人隐私号 18416708121_2381,手机号 183****6832 ,备用隐私号码: [\"17854132448_1845\"]","CSNOTES":"测试订单","BILLTYPE":"美团外卖","PRY":"在线支付","WEBJSFS":"50","ISFP":"0","ecsOrderID":"2600892003683025253","SPARE3":"hzhzk301"},"Entry":[{"HH":"DYY1050104","HYJ":"25.00","QUANTITY":"-1","PRICE":"-25.00","LSJ":"0.00","ZZF2":""},{"HH":"440012","HYJ":"2.00","QUANTITY":"-1","PRICE":"-2.00","LSJ":"2.00"}]} 2024/1/10 14: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 ('TK202401101456382238', 'TK202401101456382238', 'FZ202401101438309436', '', '', '', '301', '', '金叶小区6号楼一单元', '王(**)', '18416708121_2381', '2024-01-10 14:38:31', '送货', '收货人隐私号 18416708121_2381,手机号 183****6832 ,备用隐私号码: ["17854132448_1845"]', '测试订单', '美团外卖', '在线支付', '50', '', '', '0', '', '', '','','2600892003683025253',getdate(),'HYBRIS', '','hzhzk301','','','','','','', '','','','','','','','','','') 2024/1/10 14: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 ('ef9f083a31e2492283732a329a1a66ec', 'TK202401101456382238', '', 'DYY1050104', '0.00', '25.00', '-1', '-25.00', '','','','','','','','','','','') 2024/1/10 14: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 ('c0aaad793e8e42e890b8db129c3c005e', 'TK202401101456382238', '', '440012', '2.00', '2.00', '-1', '-2.00', '','','','','','','','','','','') 2024/1/10 15:01:21 {"Head":{"relevantOrder":"2600892261207095118","orignalTotal":"28.50","ORDERSN":"MT202401101501097211","STOREGUID":"hzhzk301","SUBPHONE":"","ADDRESS":"金叶小区6号楼一单元","CONSIGNEE":"王(**)","PHONE":"17854132436_1142","CREATETIME":"2024-01-10 15:00:59","FTYPE":"送货","NOTES":"收货人隐私号 17854132436_1142,手机号 183****6832 ,备用隐私号码: [\"18416708109_3825\"]","BILLTYPE":"美团外卖","PRY":"在线支付","WEBJSFS":"50","ISFP":"0","ecsOrderID":"2600892261207095118","SPARE3":"hzhzk301"},"Entry":[{"HH":"DYY1050104","HYJ":"25.00","QUANTITY":"1","PRICE":"25.00","LSJ":"0.00"},{"HH":"440012","HYJ":"2.00","QUANTITY":"1","PRICE":"2.00","LSJ":"2.00"}]} 2024/1/10 15:01:22 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 ('MT202401101501097211', 'MT202401101501097211', '', '', '', '', '301', '', '金叶小区6号楼一单元', '王(**)', '17854132436_1142', '2024-01-10 15:00:59', '送货', '收货人隐私号 17854132436_1142,手机号 183****6832 ,备用隐私号码: ["18416708109_3825"]', '', '美团外卖', '在线支付', '50', '', '', '0', '', '', '','','2600892261207095118',getdate(),'HYBRIS', '','hzhzk301','','','','','','', '','','','','','','','','','') 2024/1/10 15:01:22 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 ('030d3f7bbadd415380ad02d2a4322d79', 'MT202401101501097211', '', 'DYY1050104', '0.00', '25.00', '1', '25.00', '','','','','','','','','','','') 2024/1/10 15:01:22 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 ('5a164e79da5843969ddc1a3d59ef79a2', 'MT202401101501097211', '', '440012', '2.00', '2.00', '1', '2.00', '','','','','','','','','','','') 2024/1/10 15:11:41 {"Head":{"relevantOrder":"600892261337524775","orignalTotal":"23.00","ORDERSN":"MT202401101511291995","STOREGUID":"hzhzk301","SUBPHONE":"","ADDRESS":"曹县中医院-病房楼 (中间病房楼 8楼骨一科28床)","CONSIGNEE":"李勤(**)","PHONE":"18416703256_1031","CREATETIME":"2024-01-10 15:09:22","FTYPE":"送货","NOTES":"收货人隐私号 18416703256_1031,手机号 176****2881 ,备用隐私号码: [\"18416721023_2068\"]","BILLTYPE":"美团外卖","PRY":"在线支付","WEBJSFS":"50","ISFP":"0","ecsOrderID":"600892261337524775","SPARE3":"hzhzk301"},"Entry":[{"HH":"DYY1031322","HYJ":"5.71","QUANTITY":"1","PRICE":"5.71","LSJ":"0.00"},{"HH":"DYY1030045","HYJ":"4.77","QUANTITY":"3","PRICE":"14.29","LSJ":"0.00"},{"HH":"440012","HYJ":"2.00","QUANTITY":"1","PRICE":"2.00","LSJ":"2.00"}]} 2024/1/10 15:11:41 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 ('MT202401101511291995', 'MT202401101511291995', '', '', '', '', '301', '', '曹县中医院-病房楼 (中间病房楼 8楼骨一科28床)', '李勤(**)', '18416703256_1031', '2024-01-10 15:09:22', '送货', '收货人隐私号 18416703256_1031,手机号 176****2881 ,备用隐私号码: ["18416721023_2068"]', '', '美团外卖', '在线支付', '50', '', '', '0', '', '', '','','600892261337524775',getdate(),'HYBRIS', '','hzhzk301','','','','','','', '','','','','','','','','','') 2024/1/10 15:11:41 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 ('f2cedb68ed4c4021950a0cabd1d6cbd7', 'MT202401101511291995', '', 'DYY1031322', '0.00', '5.71', '1', '5.71', '','','','','','','','','','','') 2024/1/10 15:11:41 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 ('1fdb7c36060642cf80e0330e274f41a1', 'MT202401101511291995', '', 'DYY1030045', '0.00', '4.77', '3', '14.29', '','','','','','','','','','','') 2024/1/10 15:11:41 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 ('8649330693eb4b26aba43bb050f3e493', 'MT202401101511291995', '', '440012', '2.00', '2.00', '1', '2.00', '','','','','','','','','','','')