SELECT T0.[AcctCode] AS 科目代码, T0.[AcctName] AS 科目名称, T0.[CurrTotal] AS 本币余额, 'RMB' AS 本币币种, T0.[FcTotal] AS 科目币余额
, T0.[ActCurr]
FROM OACT T0
WHERE T0.[CurrTotal] <> '0'
ORDER BY 科目代码声明：欢迎来到五六零学院。
查询报表：科目余额
SELECT T0.[AcctCode] AS 科目代码, T0.[AcctName] AS 科目名称, T0.[CurrTotal] AS 本币余额, 'RMB' AS 本币币种, T0.[FcTotal] AS 科目币余额
, T0.[ActCurr]
FROM OACT T0
WHERE T0.[CurrTotal] <> '0'
ORDER BY 科目代码