辅助核算项目余额表穿透查询报错
金蝶云社区-财务老司机
财务老司机
0人赞赏了该文章 672次浏览 未经作者许可,禁止转载编辑于2018年12月15日 14:00:25
辅助明细账查询报错com.kingdee.bos.BOSException: Sql1 execute exception : INSERT INTO VT13L0R9V2KPNN55JUXOGQC0R8GPHCM7DX(KSQL_SEQ,FAccountID,FBookedDate,FPeriod,voucherId,entryID,assistRecordID,FBalSeq) SELECT /*+ LEADING(voucher,entries,assistRecords) USE_HASH(voucher,entries,assistRecords) */ entries.FAccountID FAccountID, voucher.FBookedDate FBookedDate, period.fnumber FPeriod, voucher.FID voucherId, entries.FID entryID, assistRecords.FID assistRecordID, 2 FBalSeq FROM T_GL_Voucher voucher INNER JOIN T_GL_VoucherEntry entries ON voucher.FID = entries.FBillID AND voucher.FCompanyID = entries.FCompanyID AND voucher.FPeriodID = entries.FPeriodID LEFT OUTER JOIN T_BD_Period period ON voucher.FPeriodID = period.FID LEFT OUTER JOIN T_GL_VoucherAssistRecord assistRecords ON entries.FID = assistRecords.FEntryID AND entries.FCompanyID = assistRecords.FCompanyID AND entries.FPeriodID = assistRecords.FPeriodID AND entries.FAccountID = assistRecords.FAccountID WHERE voucher.FCompanyID IN ('2wYAAAAAAFvM567U') AND voucher.FBizStatus IN (1, 3, 5) AND voucher.FPeriodID IN ('2wYAAAAAAH6COIxM') AND entries.FCurrencyID = 'dfd38d11-00fd-1000-e000-1ebdc0a8100dDEB58FDC' AND entries.FAccountID IN ('XXWBIaIwQAeIiQKsVEfEIp2pmCY=') AND assistRecords.FAssGrpId IN ('2wYAAAAAL6dBimy7', '2wYAAAAAL59Bimy7', '2wYAAAAAL6FBimy7') ORDER BY FAccountID ASC, FPeriod ASC, voucher.FCreateTime ASC, voucher.FNumber ASC, entries.FSeq ASC, assistRecords.FSeq ASC
Caused exception message is: A reference to column "FACCOUNTID" is ambiguous.. SQLCODE=-203, SQLSTATE=42702, DRIVER=3.68.61 [Client -- String Serialize]
at com.kingdee.eas.util.app.DbUtil.execute(DbUtil.java:260)
at com.kingdee.eas.fi.gl.rpt.app.dao.AbstractGLRptDao.execute(AbstractGLRptDao.java:1529)
at com.kingdee.eas.fi.gl.rpt.app.dao.AbstractGLRptDao.execute(AbstractGLRptDao.java:1524)