2024/1/16 9:54:41 {"Head":{"relevantOrder":"2600900593683025253","orignalTotal":"42.00","ORDERSN":"MT202401160954293199","STOREGUID":"hzhzk301","SUBPHONE":"","ADDRESS":"金叶小区6号楼一单元","CONSIGNEE":"王(**)","PHONE":"18416708320_7644","CREATETIME":"2024-01-16 09:54:16","FTYPE":"送货","NOTES":"收货人隐私号 18416708320_7644,手机号 183****6832 ,备用隐私号码: [\"18416721189_6072\"]","BILLTYPE":"美团外卖","PRY":"在线支付","WEBJSFS":"50","ISFP":"0","ecsOrderID":"2600900593683025253","SPARE3":"hzhzk301"},"Entry":[{"HH":"DYY20300100","HYJ":"19.50","QUANTITY":"1","PRICE":"19.50","LSJ":"0.00"},{"HH":"DYY20300098","HYJ":"19.50","QUANTITY":"1","PRICE":"19.50","LSJ":"0.00"},{"HH":"440012","HYJ":"2.00","QUANTITY":"1","PRICE":"2.00","LSJ":"2.00"}]} 2024/1/16 9:54:42 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 ('MT202401160954293199', 'MT202401160954293199', '', '', '', '', '301', '', '金叶小区6号楼一单元', '王(**)', '18416708320_7644', '2024-01-16 09:54:16', '送货', '收货人隐私号 18416708320_7644,手机号 183****6832 ,备用隐私号码: ["18416721189_6072"]', '', '美团外卖', '在线支付', '50', '', '', '0', '', '', '','','2600900593683025253',getdate(),'HYBRIS', '','hzhzk301','','','','','','', '','','','','','','','','','') 2024/1/16 9:54:42 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 ('9152d75d971a40ecadbc0d4241c93d44', 'MT202401160954293199', '', 'DYY20300100', '0.00', '19.50', '1', '19.50', '','','','','','','','','','','') 2024/1/16 9:54:42 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 ('be5e865d798b4709811b3c8f1e6b4367', 'MT202401160954293199', '', 'DYY20300098', '0.00', '19.50', '1', '19.50', '','','','','','','','','','','') 2024/1/16 9:54:42 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 ('b0bb397552044407a8293b194cb2981e', 'MT202401160954293199', '', '440012', '2.00', '2.00', '1', '2.00', '','','','','','','','','','','') 2024/1/16 16:38:04 {"Head":{"relevantOrder":"2600900593683025253","ORDERSN":"TK202401161038584741","ORIGINALNUMBER":"MT202401160954293199","USERID":"","STOREGUID":"hzhzk301","ADDRESS":"金叶小区6号楼一单元","CONSIGNEE":"王(**)","PHONE":"18416708320_7644","CREATETIME":"2024-01-16 09:54:16","FTYPE":"送货","NOTES":"收货人隐私号 18416708320_7644,手机号 183****6832 ,备用隐私号码: [\"18416721189_6072\"]","BILLTYPE":"美团外卖","PRY":"在线支付","WEBJSFS":"50","ISFP":"0","ecsOrderID":"2600900593683025253","SPARE3":"hzhzk301"},"Entry":[{"HH":"DYY20300100","HYJ":"19.50","QUANTITY":"-1","PRICE":"-19.50","LSJ":"0.00","ZZF2":""},{"HH":"DYY20300098","HYJ":"19.50","QUANTITY":"-1","PRICE":"-19.50","LSJ":"0.00","ZZF2":""},{"HH":"440012","HYJ":"2.00","QUANTITY":"-1","PRICE":"-2.00","LSJ":"2.00"}]} 2024/1/16 16:38:04 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 ('TK202401161038584741', 'TK202401161038584741', 'MT202401160954293199', '', '', '', '301', '', '金叶小区6号楼一单元', '王(**)', '18416708320_7644', '2024-01-16 09:54:16', '送货', '收货人隐私号 18416708320_7644,手机号 183****6832 ,备用隐私号码: ["18416721189_6072"]', '', '美团外卖', '在线支付', '50', '', '', '0', '', '', '','','2600900593683025253',getdate(),'HYBRIS', '','hzhzk301','','','','','','', '','','','','','','','','','') 2024/1/16 16:38:04 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 ('629c54d973c84a91979ee56fdef539f9', 'TK202401161038584741', '', 'DYY20300100', '0.00', '19.50', '-1', '-19.50', '','','','','','','','','','','') 2024/1/16 16:38:04 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 ('9e33be2b41dc4f3499bc1ae640b21a68', 'TK202401161038584741', '', 'DYY20300098', '0.00', '19.50', '-1', '-19.50', '','','','','','','','','','','') 2024/1/16 16:38:04 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 ('c15072ef6ace4f6a9f037c48b88be64e', 'TK202401161038584741', '', '440012', '2.00', '2.00', '-1', '-2.00', '','','','','','','','','','','')