科目余额表过滤框有个是否包含未过账,如果只关联科目余额表只会有过账的数据,要包含未过账要从凭证取然后拼接起来

SELECT

TBAL.FNAME 账簿,

TBCL.FNAME 币别,

TGB.FYear 年,

TGB.FPeriod 期,

-- TGB.FAdjustPeriod 调整期,

1 是否过账0未过账1已过账,

TGB.FDebit 借方本位币金额,

TBACL.FNAME 科目名称,

TBF.FFLEX9 FFLEX9内码,

TBEL.FNAME 费用项目名称,

TBF.FFLEX5 FFLEX5内码,

TBDL.FNAME 部门名称,

TBF.FF100003 FF100003内码,

TBOEL.FNAME 业务组名称,

TBF.FFLEX6 FFLEX6内码,

TBCTL.FNAME 客户名称

FROM

T_GL_BALANCE TGB--科目余额表

LEFT JOIN T_BD_ACCOUNTBOOK TBA ON TGB.FACCOUNTBOOKID = TBA.FBOOKID --账簿

LEFT JOIN T_BD_ACCOUNTBOOK_L TBAL ON TBA.FBOOKID = TBAL.FBOOKID AND TBAL.FLOCALEID = '2052' --账簿多语言

LEFT JOIN T_BD_CURRENCY TBC ON TGB.FCurrencyID = TBC.FCURRENCYID --币别

LEFT JOIN T_BD_CURRENCY_L TBCL ON TBC.FCURRENCYID = TBCL.FCURRENCYID AND TBCL.FLOCALEID = '2052' --币别多语言

LEFT JOIN T_BD_ACCOUNT TBAC ON TGB.FAccountID = TBAC.FACCTID --科目

LEFT JOIN T_BD_ACCOUNT_L TBACL ON TBAC.FACCTID = TBACL.FACCTID AND TBACL.FLOCALEID = '2052' --科目多语言

LEFT JOIN T_BD_FLEXITEMDETAILV TBF ON TGB.FDetailID = TBF.FID --核算维度数据表

LEFT JOIN T_BD_EXPENSE TBE ON TBF.FFLEX9 = TBE.FEXPID --费用项目

LEFT JOIN T_BD_EXPENSE_L TBEL ON TBE.FEXPID = TBEL.FEXPID AND TBEL.FLOCALEID = '2052' --费用项目多语言

LEFT JOIN T_BD_DEPARTMENT TBD ON TBF.FFLEX5 = TBD.FDEPTID --部门

LEFT JOIN T_BD_DEPARTMENT_L TBDL ON TBD.FDEPTID = TBDL.FDEPTID AND TBDL.FLOCALEID = '2052' --部门多语言

LEFT JOIN T_BD_OPERATORGROUPENTRY_L TBOEL ON TBF.FF100003 = TBOEL.FEntryId AND TBOEL.FLocaleId = '2052' --业务组分录多语言

LEFT JOIN T_BD_CUSTOMER TBCT ON TBF.FFLEX6 = TBCT.FCUSTID --客户

LEFT JOIN T_BD_CUSTOMER_L TBCTL ON TBCT.FCUSTID = TBCTL.FCUSTID AND TBCTL.FLocaleId = '2052' --客户多语言

WHERE TBACL.FNAME = '销售费用' --科目

AND TBCL.FNAME = '人民币'

UNION ALL

SELECT

TBAL.FNAME 账簿,

TBCL.FNAME 币别,

TGV.FYEAR 年,

TGV.FPERIOD 期,

TGV.FPOSTED 是否过账0未过账1已过账,

TGVE.fdebit 借方本位币金额,

TBACL.FNAME 科目名称,

TBF.FFLEX9 FFLEX9内码,

TBEL.FNAME 费用项目名称,

TBF.FFLEX5 FFLEX5内码,

TBDL.FNAME 部门名称,

TBF.FF100003 FF100003内码,

TBOEL.FNAME 业务组名称,

TBF.FFLEX6 FFLEX6内码,

TBCTL.FNAME 客户名称

FROM

T_GL_VOUCHER TGV --凭证

LEFT JOIN T_BD_ACCOUNTBOOK TBA ON TGV.FACCOUNTBOOKID = TBA.FBOOKID --账簿

LEFT JOIN T_BD_ACCOUNTBOOK_L TBAL ON TBA.FBOOKID = TBAL.FBOOKID AND TBAL.FLOCALEID = '2052' --账簿多语言

LEFT JOIN T_GL_VOUCHERENTRY TGVE ON TGV.FVoucherID = TGVE.FVoucherID --凭证分录

LEFT JOIN T_BD_ACCOUNT TBAC ON TGVE.FAccountID = TBAC.FACCTID --科目

LEFT JOIN T_BD_ACCOUNT_L TBACL ON TBAC.FACCTID = TBACL.FACCTID AND TBACL.FLOCALEID = '2052' --科目多语言

LEFT JOIN T_BD_CURRENCY TBC ON TGVE.FCURRENCYID = TBC.FCURRENCYID --币别

LEFT JOIN T_BD_CURRENCY_L TBCL ON TBC.FCURRENCYID = TBCL.FCURRENCYID AND TBCL.FLOCALEID = '2052' --币别多语言

LEFT JOIN T_BD_FLEXITEMDETAILV TBF ON TGVE.FDetailID = TBF.FID --核算维度数据表

LEFT JOIN T_BD_EXPENSE TBE ON TBF.FFLEX9 = TBE.FEXPID --费用项目

LEFT JOIN T_BD_EXPENSE_L TBEL ON TBE.FEXPID = TBEL.FEXPID AND TBEL.FLOCALEID = '2052' --费用项目多语言

LEFT JOIN T_BD_DEPARTMENT TBD ON TBF.FFLEX5 = TBD.FDEPTID --部门

LEFT JOIN T_BD_DEPARTMENT_L TBDL ON TBD.FDEPTID = TBDL.FDEPTID AND TBDL.FLOCALEID = '2052' --部门多语言

LEFT JOIN T_BD_OPERATORGROUPENTRY_L TBOEL ON TBF.FF100003 = TBOEL.FEntryId AND TBOEL.FLocaleId = '2052' --业务组分录多语言

LEFT JOIN T_BD_CUSTOMER TBCT ON TBF.FFLEX6 = TBCT.FCUSTID --客户

LEFT JOIN T_BD_CUSTOMER_L TBCTL ON TBCT.FCUSTID = TBCTL.FCUSTID AND TBCTL.FLocaleId = '2052' --客户多语言

WHERE TGV.FPOSTED = '0' --是否过账

--AND TGV.FYEAR = '2023' --年

--AND TGV.FDOCUMENTSTATUS = 'C' --数据状态

AND TGV.FACCOUNTBOOKID = '255790' --账簿内码

产品问题求一份科目余额表的sql,我取出来和前台对不上

66 产品问题 求一份科目余额表的sql,我取出来和前台对不上

恭喜您！

产品问题
求一份科目余额表的sql,我取出来和前台对不上

66 产品问题求一份科目余额表的sql,我取出来和前台对不上