【分享】科目核算维度SQL脚本
云社区用户9E211234
4人赞赏了该文章
1,230次浏览
编辑于2019年01月15日 11:34:53
create view view_AccountDetail
as
select t3.FNUMBER FCreateOrgId ,t.FNUMBER,t1.FNAME,t4.FNAME FDetailID,t4.FFLEXNUMBER FDetailNo From T_BD_ACCOUNT t inner join T_BD_ACCOUNT_L t1 on t.FACCTID=t1.FACCTID
inner join T_ORG_ORGANIZATIONS t3 on t.FCREATEORGID=t3.FORGID
left join (
select FACCTID,FFLEXNUMBER,FNAME From T_BD_ACCOUNTFLEXENTRY TA
left join (SELECT t0.FID,FFLEXNUMBER,t0_L.FNAME FROM T_BD_FLEXITEMPROPERTY t0 LEFT OUTER JOIN T_BD_FLEXITEMPROPERTY_L t0_L ON (t0.FID = t0_L.FID AND t0_L.FLocaleId = 2052)) TAd
on TA.FFlEXITEMPROPERTYID=TAd.FID) T4 on t.FACCTID=t4.FACCTID
as
select t3.FNUMBER FCreateOrgId ,t.FNUMBER,t1.FNAME,t4.FNAME FDetailID,t4.FFLEXNUMBER FDetailNo From T_BD_ACCOUNT t inner join T_BD_ACCOUNT_L t1 on t.FACCTID=t1.FACCTID
inner join T_ORG_ORGANIZATIONS t3 on t.FCREATEORGID=t3.FORGID
left join (
select FACCTID,FFLEXNUMBER,FNAME From T_BD_ACCOUNTFLEXENTRY TA
left join (SELECT t0.FID,FFLEXNUMBER,t0_L.FNAME FROM T_BD_FLEXITEMPROPERTY t0 LEFT OUTER JOIN T_BD_FLEXITEMPROPERTY_L t0_L ON (t0.FID = t0_L.FID AND t0_L.FLocaleId = 2052)) TAd
on TA.FFlEXITEMPROPERTYID=TAd.FID) T4 on t.FACCTID=t4.FACCTID
推荐阅读