网赌网站怎么建设,温州气象权威发布,网站开发要,flashfxp与Wordpress金蝶K3一直缺少完整的跟踪报表#xff0c;所以我们开发了一张完整的跟踪报表#xff0c;通过查询分析工具直接生成。代码#xff08;WIN2008 R2SQL 2008 R2环境#xff0c;K3 WISE 12.3#xff09;#xff1a;select t1.fname1 客户,t1.fname2 业务员,t1.f_102 款号,t1.f… 金蝶K3一直缺少完整的跟踪报表所以我们开发了一张完整的跟踪报表通过查询分析工具直接生成。 代码WIN2008 R2SQL 2008 R2环境K3 WISE 12.3 select t1.fname1 客户,t1.fname2 业务员,t1.f_102 款号,t1.fbillno 订单号,t1.fdate 订单日期,t1.fqty 订单数量,t5.fqty 生产数量,t10.fnumber BOM材料代码,t10.fname BOM材料名称,t6.fnumber 投料单材料代码,t6.fqty 投料单数量,t7.fqty 领料单数量,t7.soutfprice 领料单价,t7.soutfamount 领料金额,t2.fdate 申请日期,t2.SEEfbillno 申请单号,t2.fnumber 申请物料代码,t2.fqty 申请数量,t3.fdate 采购日期,t3.sefbillno 采购订单号,t3.fqty 采购订单数量,t3.fprice 采购单价,t3.famount 采购金额,t4.fdate 入库日期,t4.fbillno 入库单号,t4.fqty 入库数量,t8.cpfdate 成品入库日期,t8.fqty 产品入库数,t8.cpfprice 入库单价,t8.cpfamount 入库金额,t9.fqty 出库数量,t9.fqtyinvoice 开票数量 FROM (select t5.f_102,t3.fname fname1,t4.fname fname2,t1.fbillno,sum(t2.fqty) fqty,t1.fdate,t1.finterid from seorder t1inner join seorderentry t2 on t1.finteridt2.finteridinner join t_organization t3 on t1.fcustidt3.fitemidinner join t_emp t4 on t1.fempidt4.fitemidinner join t_icitem t5 on t2.fitemidt5.fitemid where t1.fcancellation0group by t5.f_102,t3.fname,t4.fname,t1.fbillno,t1.fdate,t1.finterid) t1--生产任务单left join (select t2.f_102,t1.forderinterid,sum(t1.fqty) fqty from icmo t1inner join t_icitem t2 on t1.fitemidt2.fitemidgroup by t2.f_102,t1.forderinterid) t5 on t1.f_102t5.f_102 and t1.finteridt5.forderinterid--产品入库单left join (select t3.f_102,t2.fentryselfa0240,sum(fqty) fqty,t1.fdate cpfdate,t2.fprice cpfprice,t2.famount cpfamount from icstockbill t1inner join icstockbillentry t2 on t1.finteridt2.finteridinner join t_icitem t3 on t2.fitemidt3.fitemid where t1.ftrantype2group by t3.f_102,t2.fentryselfa0240,t2.fprice,t2.famount,t1.fdate) t8 on t1.f_102t8.f_102 and t1.fbillnot8.fentryselfa0240--销售出库left join (select t3.f_102,t2.forderbillno,sum(fqty) fqty,sum(fqtyinvoice) fqtyinvoice from icstockbill t1inner join icstockbillentry t2 on t1.finteridt2.finteridinner join t_icitem t3 on t2.fitemidt3.fitemid where t1.ftrantype21group by t3.f_102,t2.forderbillno) t9 on t1.f_102t9.f_102 and t1.fbillnot9.forderbillno--BOM单left join (select distinct t3.f_102,t4.fnumber,t4.fname from icbom t1inner join ICBOMCHILD t2 on t1.finteridt2.finteridinner join t_icitem t3 on t3.fitemidt1.fitemidinner join t_icitem t4 on t2.fitemidt4.fitemid) t10 on t10.f_102t1.f_102--投料单left join (select t3.f_102,t1.forderbillno,t4.fnumber,t4.fname,sum(t2.fqtymust) fqty from ppbom t1inner join ppbomentry t2 on t1.finteridt2.finteridinner join t_icitem t3 on t1.fitemidt3.fitemidinner join t_icitem t4 on t2.fitemidt4.fitemidgroup by t3.f_102,t1.forderbillno,t4.fnumber,t4.fname) t6 on t1.f_102t6.f_102 and t1.fbillnot6.forderbillno and t6.fnumbert10.fnumber--领料单left join (select fentryselfb0453,fentryselfb0454,t3.fnumber,sum(fqty) fqty,t2.fprice soutfprice,t2.famount soutfamount from icstockbill t1inner join icstockbillentry t2 on t1.finteridt2.finteridinner join t_icitem t3 on t2.fitemidt3.fitemid where t1.ftrantype24group by fentryselfb0453,fentryselfb0454,t3.fnumber,t2.fprice,t2.famount) t7 on t1.f_102t7.fentryselfb0453 and t1.fbillnot7.fentryselfb0454 and t6.fnumbert7.fnumber--采购申请left join (select t1.fheadselfp0136,t2.fentryselfp0137,t3.fnumber,t3.fname,sum(t2.fqty) fqty,t1.fdate fdate,t1.fbillno SEEfbillno from porequest t1inner join porequestentry t2 on t1.finteridt2.finteridinner join t_icitem t3 on t2.fitemidt3.fitemidgroup by t1.fheadselfp0136,t2.fentryselfp0137,t3.fnumber,t3.fname,t1.fdate,t1.fbillno) t2 on t1.fbillnot2.fheadselfp0136 and t1.f_102t2.fentryselfp0137 and t10.fnumbert2.fnumber--采购订单left join (select t2.fentryselfp0270,t2.fentryselfp0269,t3.fnumber,t3.fname,sum(t2.fqty) fqty,t2.fprice fprice,t2.famount famount,t2.fdate fdate,t1.fbillno sefbillno from poorder t1inner join poorderentry t2 on t1.finteridt2.finteridinner join t_icitem t3 on t2.fitemidt3.fitemidgroup by t2.fentryselfp0270,t2.fentryselfp0269,t3.fnumber,t3.fname,t2.fprice,t2.famount,t2.fdate,t1.fbillno) t3 on t1.fbillnot3.fentryselfp0270 and t1.f_102t3.fentryselfp0269 and t10.fnumbert3.fnumber--外购入库单left join (select t2.fentryselfa0158,t2.fentryselfa0159,t1.fdate,t3.fnumber,t3.fname,t1.fdate fdate1,t1.fbillno fbillno,sum(t2.fqty) fqty from icstockbill t1inner join icstockbillentry t2 on t1.finteridt2.finteridinner join t_icitem t3 on t3.fitemidt2.fitemidwhere t1.ftrantype1 group by t2.fentryselfa0158,t2.fentryselfa0159,t1.fdate,t3.fnumber,t3.fname,t1.fdate,t1.fbillno) t4 on t1.fbillnot4.fentryselfa0159 and t1.f_102t4.fentryselfa0158 and t10.fnumbert4.fnumberwhere t1.f_102 like %*kuanghao*% and t1.fbillno like %*FBillNoCommon*%order by t1.fdate 转载于:https://blog.51cto.com/t4513/1917723
