在哪个后台表中可以看到各科目的借贷和余额数据啊？

beatit

大家好，请问在哪个后台表中可以看到各科目的借贷和余额数据啊？

另外，在四班中查看科目余额是哪个屏幕，请各位老师指教。非常感谢。

FrankXu

GLDQ屏幕

SELECT                FiscalYear AS AccYear,
ActivityType AS [Type],
CASE ActivityType WHEN 'AA' THEN N'实际' ELSE N'预算' END AS TypeDesc,
ma.MasterAccount,
Period0ActivityAmount AS Period_Initial, --期初余额
Period1ActivityAmount AS Period1,   --各会计期间净发生额(已过帐)
Period2ActivityAmount AS Period2,
Period3ActivityAmount AS Period3, Period4ActivityAmount AS Period4,
Period5ActivityAmount AS Period5, Period6ActivityAmount AS Period6,
Period7ActivityAmount AS Period7, Period8ActivityAmount AS Period8,
Period9ActivityAmount AS Period9, Period10ActivityAmount AS Period10,
Period11ActivityAmount AS Period11, Period12ActivityAmount AS Period12,
Period13ActivityAmount AS Period_End,
ActivityLastMaintainedDate AS LastMaintained,
GLActualBudgetActivityKey

FROM        FSDBMR.dbo.FS_GLActualBudgetActivity bu
INNER JOIN FSDBMR.dbo.FS_GLMasterAccount ma
ON bu.GLMasterAccountKey=ma.GLMasterAccountKey

beatit

非常感谢FrankXu 的热心帮忙

herogao

过账前的余额如何提取？

FrankXu

按会计期间和会计主帐号进行分类汇总,就可以查询过帐前净发生额
用上期末余额,加上当前净发生额,即为当前余额

SELECT
                gh.AccountingYear AS AccYear,
                gh.AccountingPeriod AS AccMonth,
                STR(gh.AccountingYear,4) +'-' + REPLACE(STR(gh.AccountingPeriod,2),' ','0') AS Period,
                gh.BatchStatus ,
                gh.BatchJournalNumber AS Journal,
                br.BatchNumber AS BatchNo,
                br.BatchSourceCode AS SURCODE,
                br.RecapAccount AS MasterAccount,
                brd.RecapAccountDebitAmount AS DebitAmount,
                brd.RecapAccountCreditAmount AS CreditAmount,
                brd.RecapAccountDebitAmount - brd.RecapAccountCreditAmount AS NetGeneralAmount,
                brd.RecapLastMaintainedDate AS LastMaintained
               
FROM        FSDBMR.dbo.FS_GLBatchRecap br
                INNER JOIN FSDBMR.dbo.FS_GLBatchRecapData brd
                ON br.GLBatchRecapKey=brd.GLBatchRecapKey
                INNER JOIN FSDBMR.dbo.FS_GLBatchHeader gh
                ON br.GLBatchHeaderKey=gh.GLBatchHeaderKey

herogao

谢谢。我再测试一下。。

songhua_Leon

徐先生好厉害

chinzys

我们的 FrankXu就是位高人！

yyss88

xiexie gaoren