核算维度相关表原创
1人赞赏了该文章
10次浏览
编辑于2024年09月30日 16:32:54
SELECT * FROM T_BD_FLEXITEMPROPERTY --基础资料属性列表 SELECT * FROM T_BD_FLEXITEMDETAILV WHERE FID = 111242 --核算维度明细表(俗称横表) --select * from T_GL_VOUCHER where fdate = '2023-02-03 00:00:00.000'--凭证 --select * from T_GL_VOUCHERENTRY where FVOUCHERID = 101455--凭证分录 FACCOUNTID(科目编码) FDETAILID(核算维度)112034 --FFLEX7 BD_Empinfo 员工 --FFLEX16 FIN_OTHERS 其他往来单位 --FF100012 --FF100013 SELECT t3.FDATAVALUE AS 资料名称, t2.FENTRYID, t1.* FROM T_BAS_ASSISTANTDATA t0 INNER JOIN T_BAS_ASSISTANTDATA_L t1 ON ( t0.FID = t1.FID AND t1.FLOCALEID = 2052 ) INNER JOIN T_BAS_ASSISTANTDATAENTRY t2 ON (t0.FID = t2.FID) INNER JOIN T_BAS_ASSISTANTDATAENTRY_L t3 ON ( t2.FENTRYID = t3.FENTRYID AND t3.FLOCALEID = 2052 ) where t1.fid = '627b753d478213'