摘要:
/* Formatted on 2020/12/08 18:04:07 (QP5 v5.326) */ SELECT temp.DCLIENTDATE AS 最后未交班日期, temp.VSITENAME AS 对应店铺名称, temp.USER_NAME AS 公司收银员, temp.USER_C 阅读全文
摘要:
/* Formatted on 2020/12/08 17:49:34 (QP5 v5.326) */ DECLARE CURSOR c_ic_onhandnum_withoutVLot IS SELECT * FROM IC_ONHANDNUM WHERE pk_corp <> '1001' AN 阅读全文
摘要:
/* Formatted on 2020/12/08 17:46:58 (QP5 v5.326) */ DECLARE CURSOR c_rmb_onhandnum_withnocode IS SELECT * FROM rmb_onhandnum WHERE (nonhandnum > 0) AN 阅读全文
摘要:
/* Formatted on 2020/12/08 17:31:50 (QP5 v5.326) */ SELECT DISTINCT head.VBILLCODE AS 单据号, head.DBILLDATE AS 单据日期, head.CBILLTYPECODE AS 业务类型, head.co 阅读全文
摘要:
/*注:以下查询语句直接运行,对执行完毕检查批次行,对于全数字的信息,在系统中检查。 查询结果显示:批次号,库存数量,存货名称*/ SELECT sb.vbatchcode, ro.NONHANDNUM, bi.INVNAME FROM scm_batchcode sb INNER JOIN bd_ 阅读全文
摘要:
2020-12-26重新更新的代码: /* Formatted on 2020/12/25 星期五 21:29:35 (QP5 v5.326) */ DECLARE /*以下定义开始日期,每次查询时请自行修改*/ startdate CHAR (10) := '2020-10-01'; /* 以下语 阅读全文