科目余额

示例代码

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 科目代码