用友自定义报表(序时账).doc
文本预览下载声明
select g.dbill_date as 日期,(g.csign +-000+ convert(nvarchar,g.ino_id)) as 凭证号数,
g.ccode as 科目编码,c.ccode_name as 科目名称,g.ccode_equal as 对方科目编码,ec.ccode_name as 对方科目名称, g.cdigest as 摘要,
case when g.md 0 then 借 else 贷 end as 方向,g.cDefine1 as 数量,g.cDefine2 as 外币,
case when g.md 0 then g.md else g.mc end as 金额
from gl_accvouch as g
显示全部