用友U6普及版3.1 plus1材料出库单定位过滤出的材料出库单是空白U6普及版3.1 plus1材料出库单定位过滤出的材料出库单是空白
U6普及版3.1 plus1-材料出库单定位过滤出的材料出库单是空白
自动编号: | 19138 | 产品版本: | U6普及版3.1 plus1 | 产品模块: | 库存管理 | 所属行业: | 通用 | 适用产品: | U6 | 关 键 字: | | 问题名称: | 材料出库单定位过滤出的材料出库单是空白 | 问题现象: | 材料出库单定位过滤出的材料出库单是空白 | 原因分析: | 数据库视图recordoutlist损坏 | 解决方案: | 从别的帐套中导出此视图覆盖坏的帐套,或执行语句 SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO CREATE view dbo.recordoutlist as select dbo.recordoutq.id, dbo.recordoutq.brdflag, dbo.recordoutq.cvouchtype, dbo.recordoutq.cwhcode, dbo.recordoutq.ddate, dbo.recordoutq.ccode, dbo.recordoutq.crdcode, dbo.recordoutq.cdepcode, dbo.recordoutq.imquantity, dbo.recordoutq.cpersoncode, dbo.recordoutq.cprobatch, dbo.recordoutq.bpufirst, dbo.recordoutq.biafirst, dbo.recordoutq.chandler, dbo.recordoutq.cmemo, dbo.recordoutq.caccounter, dbo.recordoutq.cmaker, dbo.recordoutq.cdefine1, dbo.recordoutq.cdefine2, dbo.recordoutq.cdefine3, dbo.recordoutq.cdefine4, dbo.recordoutq.cdefine5, dbo.recordoutq.cdefine6, dbo.recordoutq.cdefine7, dbo.recordoutq.cdefine8, dbo.recordoutq.cdefine9, dbo.recordoutq.cdefine10, dbo.recordoutq.cwhname, dbo.recordoutq.cdepname, dbo.recordoutq.cpersonname, dbo.recordoutq.cinvname as cinvname_1, dbo.recordoutq.ufts, dbo.recordoutq.crdname, dbo.recordoutq.csource, dbo.recordoutq.cbustype, dbo.recordoutq.cpspcode,dbo.recordoutq.cmpocode, dbo.recordoutq.ipurorderid, dbo.recordoutq.ipurarriveid, dbo.recordoutq.iproorderid, dbo.recordoutq.iarriveid,dbo.recordoutq.isalebillid, dbo.recordoutsq.autoid, dbo.recordoutsq.id as id_1, dbo.recordoutsq.cinvcode, dbo.recordoutsq.cinvaddcode, dbo.recordoutsq.cinvname, dbo.recordoutsq.cinvstd, dbo.recordoutsq.cinvm_unit, dbo.recordoutsq.cinva_unit, dbo.recordoutsq.creplaceitem, dbo.recordoutsq.cposition, dbo.recordoutsq.cinvdefine1, dbo.recordoutsq.cinvdefine2, dbo.recordoutsq.cinvdefine3, dbo.recordoutsq.cfree1, dbo.recordoutsq.cfree2, dbo.recordoutsq.cbatch, dbo.recordoutsq.iinvexchrate, dbo.recordoutsq.inum, dbo.recordoutsq.iquantity, dbo.recordoutsq.iunitcost, round(dbo.recordoutsq.iprice,2) as iprice, dbo.recordoutsq.ipunitcost, round(dbo.recordoutsq.ipprice,2) as ipprice, dbo.recordoutsq.dvdate, dbo.recordoutsq.cobjcode, dbo.recordoutsq.isoutquantity, dbo.recordoutsq.isoutnum, dbo.recordoutsq.dsdate, dbo.recordoutsq.ifquantity, dbo.recordoutsq.ifnum, dbo.recordoutsq.cvouchcode, dbo.recordoutq.cbuscode, dbo.recordoutsq.cdefine22, dbo.recordoutsq.cdefine23, dbo.recordoutsq.cdefine24, dbo.recordoutsq.cdefine25, dbo.recordoutsq.cdefine26, dbo.recordoutsq.cdefine27, dbo.recordoutsq.citemcode, dbo.recordoutsq.citem_class, dbo.recordoutq.dveridate, dbo.recordoutsq.cname, dbo.recordoutsq.citemcname, dbo.recordoutq.darvdate, dbo.recordoutq.cchkcode, dbo.recordoutq.dchkdate, dbo.recordoutq.cchkperson, dbo.recordoutq.bisstqc, dbo.recordoutq.vt_id, dbo.recordoutq.cdefine11, dbo.recordoutq.cdefine12, dbo.recordoutq.cdefine13, dbo.recordoutq.cdefine14, dbo.recordoutq.cdefine15, dbo.recordoutq.cdefine16, dbo.recordoutq.imquantity as expr1, dbo.recordoutsq.cinvdefine4, dbo.recordoutsq.cinvdefine5, dbo.recordoutsq.cinvdefine6, dbo.recordoutsq.cinvdefine7, dbo.recordoutsq.cinvdefine8, dbo.recordoutsq.cinvdefine9, dbo.recordoutsq.cinvdefine10, dbo.recordoutsq.cinvdefine11, dbo.recordoutsq.cinvdefine12, dbo.recordoutsq.cinvdefine13, dbo.recordoutsq.cinvdefine14, dbo.recordoutsq.cinvdefine15, dbo.recordoutsq.cinvdefine16, dbo.recordoutsq.iid, dbo.recordoutsq.cfree3, dbo.recordoutsq.cfree4, dbo.recordoutsq.cfree5, dbo.recordoutsq.cfree6, dbo.recordoutsq.cfree7, dbo.recordoutsq.cfree8, dbo.recordoutsq.cfree9, dbo.recordoutsq.cfree10, dbo.recordoutsq.cbarcode, dbo.recordoutsq.inquantity, dbo.recordoutsq.innum, dbo.recordoutsq.cassunit, dbo.recordoutsq.dmadedate, dbo.recordoutsq.cdefine28, dbo.recordoutsq.cdefine29, dbo.recordoutsq.cdefine30, dbo.recordoutsq.cdefine31, dbo.recordoutsq.cdefine32, dbo.recordoutsq.cdefine33, dbo.recordoutsq.cdefine34, dbo.recordoutsq.cdefine35, dbo.recordoutsq.cdefine36, dbo.recordoutsq.cdefine37, dbo.recordoutsq.impoids, dbo.recordoutsq.icheckids, dbo.recordoutsq.cbvencode, dbo.recordoutsq.cvenname, dbo.recordoutsq.cinvouchcode, dbo.recordoutsq.imassdate, dbo.recordoutsq.cposname from dbo.recordoutq left outer join dbo.recordoutsq on dbo.recordoutq.id = dbo.recordoutsq.id GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO
温馨提示:如果您的问题还没有解决,欢迎进入用友云基地。 |
|