2024/1/23 17:38:01 {"Head":{"relevantOrder":"2600911130660650193","orignalTotal":"28.50","ORDERSN":"MT202401231737471102","STOREGUID":"hzhzk434","SUBPHONE":"","ADDRESS":"金叶小区6号楼一单元","CONSIGNEE":"王(**)","PHONE":"18416718248_9661","CREATETIME":"2024-01-23 17:37:37","FTYPE":"送货","NOTES":"收货人隐私号 18416718248_9661,手机号 183****6832 ,备用隐私号码: [\"18416721149_0542\"]","BILLTYPE":"美团外卖","PRY":"在线支付","WEBJSFS":"50","ISFP":"0","ecsOrderID":"2600911130660650193","SPARE3":"hzhzk434"},"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/23 17:38: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 ('MT202401231737471102', 'MT202401231737471102', '', '', '', '', '434', '', '金叶小区6号楼一单元', '王(**)', '18416718248_9661', '2024-01-23 17:37:37', '送货', '收货人隐私号 18416718248_9661,手机号 183****6832 ,备用隐私号码: ["18416721149_0542"]', '', '美团外卖', '在线支付', '50', '', '', '0', '', '', '','','2600911130660650193',getdate(),'HYBRIS', '','hzhzk434','','','','','','', '','','','','','','','','','') 2024/1/23 17:38: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 ('82ef8d38fcf941238f2c9a91260a5a68', 'MT202401231737471102', '', 'DYY1050104', '0.00', '25.00', '1', '25.00', '','','','','','','','','','','') 2024/1/23 17:38: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 ('de542193b09449488aed63c6472f29bf', 'MT202401231737471102', '', '440012', '2.00', '2.00', '1', '2.00', '','','','','','','','','','','') 2024/1/23 17:57:24 {"Head":{"relevantOrder":"2600911153939289608","orignalTotal":"32.00","ORDERSN":"MT202401231757120223","STOREGUID":"hzhzk434","SUBPHONE":"","ADDRESS":"金叶小区6号楼一单元","CONSIGNEE":"王(**)","PHONE":"18416721131_5043","CREATETIME":"2024-01-23 17:57:02","FTYPE":"送货","NOTES":"收货人隐私号 18416721131_5043,手机号 183****6832 ,备用隐私号码: [\"18416703287_7433\"]","BILLTYPE":"美团外卖","PRY":"在线支付","WEBJSFS":"50","ISFP":"0","ecsOrderID":"2600911153939289608","SPARE3":"hzhzk434"},"Entry":[{"HH":"DYY1010214","HYJ":"29.00","QUANTITY":"1","PRICE":"29.00","LSJ":"0.00"},{"HH":"440012","HYJ":"2.00","QUANTITY":"1","PRICE":"2.00","LSJ":"2.00"}]} 2024/1/23 17:57:24 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 ('MT202401231757120223', 'MT202401231757120223', '', '', '', '', '434', '', '金叶小区6号楼一单元', '王(**)', '18416721131_5043', '2024-01-23 17:57:02', '送货', '收货人隐私号 18416721131_5043,手机号 183****6832 ,备用隐私号码: ["18416703287_7433"]', '', '美团外卖', '在线支付', '50', '', '', '0', '', '', '','','2600911153939289608',getdate(),'HYBRIS', '','hzhzk434','','','','','','', '','','','','','','','','','') 2024/1/23 17:57:24 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 ('7ddd5e9c72e149e5a6b51b52010091dc', 'MT202401231757120223', '', 'DYY1010214', '0.00', '29.00', '1', '29.00', '','','','','','','','','','','') 2024/1/23 17:57:24 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 ('c0bad7fc3d1d44a59fc6973755c34131', 'MT202401231757120223', '', '440012', '2.00', '2.00', '1', '2.00', '','','','','','','','','','','') 2024/1/23 17:59:28 {"Head":{"relevantOrder":"2600911153939289608","ORDERSN":"TK202401231759196199","ORIGINALNUMBER":"MT202401231757120223","USERID":"","STOREGUID":"hzhzk434","ADDRESS":"金叶小区6号楼一单元","CONSIGNEE":"王(**)","PHONE":"18416721131_5043","CREATETIME":"2024-01-23 17:57:02","FTYPE":"送货","NOTES":"收货人隐私号 18416721131_5043,手机号 183****6832 ,备用隐私号码: [\"18416703287_7433\"]","BILLTYPE":"美团外卖","PRY":"在线支付","WEBJSFS":"50","ISFP":"0","ecsOrderID":"2600911153939289608","SPARE3":"hzhzk434"},"Entry":[{"HH":"DYY1010214","HYJ":"29.00","QUANTITY":"-1","PRICE":"-29.00","LSJ":"0.00","ZZF2":""},{"HH":"440012","HYJ":"2.00","QUANTITY":"-1","PRICE":"-2.00","LSJ":"2.00"}]} 2024/1/23 17:59:29 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 ('TK202401231759196199', 'TK202401231759196199', 'MT202401231757120223', '', '', '', '434', '', '金叶小区6号楼一单元', '王(**)', '18416721131_5043', '2024-01-23 17:57:02', '送货', '收货人隐私号 18416721131_5043,手机号 183****6832 ,备用隐私号码: ["18416703287_7433"]', '', '美团外卖', '在线支付', '50', '', '', '0', '', '', '','','2600911153939289608',getdate(),'HYBRIS', '','hzhzk434','','','','','','', '','','','','','','','','','') 2024/1/23 17:59:29 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 ('8b5aff27ffca4807a9b88ebd54b0ce93', 'TK202401231759196199', '', 'DYY1010214', '0.00', '29.00', '-1', '-29.00', '','','','','','','','','','','') 2024/1/23 17:59:29 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 ('677f057abd8e491ca1e3bac6c7f2931b', 'TK202401231759196199', '', '440012', '2.00', '2.00', '-1', '-2.00', '','','','','','','','','','','')