问题描述：

现金流量查询后台sql 查询

解决方案：

1.现金流量查询   选中下方分割线内的内容，不包含分割线，而后点击屏幕左上角【执行sql】，即可查出现金流量指定明细。在表格上右键，选择【export to excel】即可导出全部

-----------------------------分割线-----------------------------下方为现金流量查询

SELECT

"PERIOD".FPeriodYear AS 年份,

"PERIOD".FPeriodNumber AS 月份,

((TO_CHAR("PERIOD".FPeriodYear) || '.') || TO_CHAR("PERIOD".FPeriodNumber)) AS 期间编码,

"VOUCHER".FNumber AS 凭证号,

"ENTRIES".FSeq AS 行号,

"ENTRIES".FDescription AS 摘要,

"ACCOUNT".FNumber AS 科目编码,

"ACCOUNT".FName_l2 AS 科目名称,

"CURRENCY".FName_l2 AS 币别,

"ENTRIES".FOriginalAmount AS 原币金额,

CASE "ENTRIES".FEntryDC WHEN 1 THEN "ENTRIES".FLocalAmount ELSE NULL END AS 借方金额,

CASE "ENTRIES".FEntryDC WHEN 1 THEN NULL ELSE "ENTRIES".FLocalAmount END AS 贷分金额,

CASE  WHEN ("CASHFLOWRECORDS".FPrimaryItemID IS NULL) THEN 0 ELSE ("CASHFLOWRECORDS".FPrimaryCoeffient * "CASHFLOWRECORDS".FLocalAmount) END AS 现金流量金额,

(("PRIMARYITEM".FNumber || ' ') || "PRIMARYITEM".FName_l2) AS 主表项目,

(("SUPPLEMENTARYITEM".FNumber || ' ') || "SUPPLEMENTARYITEM".FName_l2) AS 附表项目

FROM T_GL_Voucher AS "VOUCHER"

LEFT OUTER JOIN T_GL_VoucherEntry AS "ENTRIES"

ON "VOUCHER".FID = "ENTRIES".FBillID

LEFT OUTER JOIN T_BD_Period AS "PERIOD"

ON "VOUCHER".FPeriodID = "PERIOD".FID

LEFT OUTER JOIN T_ORG_BaseUnit AS "COMPANY"

ON "VOUCHER".FCompanyID = "COMPANY".FID

LEFT OUTER JOIN T_BD_VoucherTypes AS "VOUCHERTYPE"

ON "VOUCHER".FVoucherTypeID = "VOUCHERTYPE".FID

INNER JOIN T_PM_User AS "CREATOR"

ON "VOUCHER".FCreatorID = "CREATOR".FID

LEFT OUTER JOIN T_BD_AccountView AS "ACCOUNT"

ON "ENTRIES".FAccountID = "ACCOUNT".FID

LEFT OUTER JOIN T_BD_Currency AS "CURRENCY"

ON "ENTRIES".FCurrencyID = "CURRENCY".FID

LEFT OUTER JOIN T_GL_CashflowRecord AS "CASHFLOWRECORDS"

ON "ENTRIES".FID = "CASHFLOWRECORDS".FOpposingAccountEntryID AND (cashflowRecords.FItemFlag <> 5)

LEFT OUTER JOIN T_BD_CashFlowItem AS "PRIMARYITEM"

ON "CASHFLOWRECORDS".FPrimaryItemID = "PRIMARYITEM".FID

LEFT OUTER JOIN T_BD_CashFlowItem AS "SUPPLEMENTARYITEM"

ON "CASHFLOWRECORDS".FSupplementaryItemID = "SUPPLEMENTARYITEM".FID

LEFT OUTER JOIN T_BD_CashFlowItem AS "FULLINFOITEM"

ON "CASHFLOWRECORDS".FFullInfoItemID = "FULLINFOITEM".FID

LEFT OUTER JOIN T_BD_AssistantHG AS "ASSGRP"

ON "CASHFLOWRECORDS".FAssGrpId = "ASSGRP".FID

where "COMPANY".Fnumber = 'ZZZ01-01' -- 组织编码

and "PERIOD".FNUMBER = '201704'  --期间编码

and "VOUCHER".fnumber = '0055'  -- 凭证号

-----------------------------分割线-----------------------------上方为现金流量查询-------------------------------