用友u8系统，总账下面的现金流量凭证查询，查询出来的数据导出来之后没有对方科目这一列。

谁能帮忙写个语句调出来的，1-6月份，好像用到2个表gl_accvouch,gl_cashtable

select a.iperiod as 月份,a.csign as 凭证类别,a.ino_id as 凭证号,a.inid as 分录,a.dbill_date as 制单日期,a.cdigest as 摘要,a.ccode as 科目,a.md as 借,a.mc as 贷,a.ccode_equal as 对方科目,b.cCashItem as 流量编码,c.citemname as 流量名称 from dbo.GL_accvouch a,dbo.GL_CashTable b,dbo.fitemss98 c
where ((a.iperiod between 1 and 12) and a.ino_id =b.ino_id and a.iperiod = b.iperiod) and b.cCashItem = c.citemcode

这个语句最后两列非现金流量分录也有项目了 你导出来后自己修改下表吧
如果要1-6的 就把 12 改成6

现金流量凭证 再看看别人怎么说的。

输入：现金流量凭证即可