• 金蝶云星空SQL 85.47 kB 2024-06-03 22:06
    • Position: 金蝶云星空SQL / 财务凭证.sql

    ��/****** Script for SelectTopNRows command from SSMS  ******/



--SELECT 

--vo.FDOCUMENTSTATUS

--,org.FNUMBER  orgNum

--,acc.FNUMBER  accNum

--,voe.FDEBIT  jie

--,voe.FCREDIT  dai

--,vo.FDATE

SELECT 

voe.FENTRYID as FID

,bu.FCURRENTYEAR S_MRt^�^

,bu.FCRTYEARPERIOD S_MRg�

,book.FNAME ^?|

,vo.FDATE �eg

,vo.FBUSDATE N�R�eg

,vo.FVOUCHERGROUPID �Q��W[

,vo.FVOUCHERGROUPNO �Q���S

,orgl.FNAME 8h�{�~�~

,vo.FATTACHMENTS  D��Npe

,us.FNAME Ǐ&��N

,vo.FPOSTDATE Ǐ&��eg

,vo.FDOCUMENTSTATUS �[8h�r`



,CASE

 WHEN vo.FDOCUMENTSTATUS='A' then 'R�^'

 WHEN vo.FDocumentStatus='B' then '�[8h-N'

 WHEN vo.FDocumentStatus='C' then '�]�[8h'

 WHEN vo.FDocumentStatus='D' then '͑�e�[8h'

 WHEN vo.FDocumentStatus='Z' then '�fX['

else  ' ' end 

as �[8h�r`



,vo.FDEBITTOTAL P�e;`ё��

,vo.FCREDITTOTAL 7��e;`ё��



,voe.FENTRYSEQ f�~�S

,voe.FEXPLANATION  Xd��

,acc.FNUMBER �y�vx

,accl.FNAME �y�v

,(select count(*) from T_BD_ACCOUNTFLEXENTRY where FACCTID=acc.FACCTID)  8h�{�~�^peϑ



,voe.FDETAILID  8h�{�~�^

,dep.FNUMBER 8h�{�~�^��x

,depl.FNAME 8h�{�~�^��



,voe.FDEBIT P�eё��

,voe.FCREDIT 7��eё��

--,org.F_GOLD_SHORTNAME �~�~�{�y



--,voe.*

FROM T_GL_VOUCHER vo --�Q��

left join  T_GL_VOUCHERENTRY voe on voe.FVOUCHERID=vo.FVOUCHERID --�Q��f�~

left join  T_BD_ACCOUNT acc on acc.FACCTID=voe.FACCOUNTID  --�y�v

left join  T_BD_ACCOUNT_L accl on accl.FACCTID=voe.FACCOUNTID and accl.FLOCALEID=2052--�y�v
T�y



left join T_ORG_ORGANIZATIONS_L orgl on orgl.FORGID=vo.FACCTORGID and orgl.FLOCALEID=2052  --�~�~
T�y

left join T_ORG_ORGANIZATIONS org on org.FORGID=vo.FACCTORGID --�~�~

left join T_BD_ACCOUNTBOOK_L book on vo.FACCOUNTBOOKID=book.FBOOKID --^?|

left join  T_BD_ACCOUNTBOOK bu on vo.FACCOUNTBOOKID=bu.FBOOKID --^?|;Nh�

left join  T_SEC_USER us on us.FUSERID=vo.FPOSTERID --Ǐ&�(u7b



left join T_BD_ACCOUNTFLEXENTRY accun on accun.FACCTID=acc.FACCTID --�y�v�v8h�{�~�^

left join T_BD_FLEXITEMDETAILV hswdgl on voe.FDETAILID=hswdgl.FID  --8h�{�~�^9_'`�W�Oo`



left join T_BD_DEPARTMENT  dep on dep.FDEPTID=hswdgl.FFLEX5  --and dep.FUSEORGID=vo.FACCTORGID  --sQT���

left join T_BD_DEPARTMENT_L depl on depl.FDEPTID=hswdgl.FFLEX5 and depl.FLOCALEID=2052



 --where 



--vo.FDATE between '{1}' and '{2}'

 --vo.FDATE between '2024-03-01' and '2024-03-31'

 --and accun.FFLEXITEMPROPERTYID=2 --�y�v�v8h�{�~�^	��b/f��

 -- order by vo.FVOUCHERID,voe.FENTRYSEQ asc 



 --and voe.FDEBIT >0 

 --and voe.FCREDIT >0

  --and acc.FNUMBER like '6001%'--6eeQ

  --and acc.FNUMBER = '6001'--6eeQ

  --and acc.FNUMBER like '6401.09.01%'

  --and acc.FNUMBER like '6401.05%'







--SELECT *  FROM  T_BD_FLEXITEMDETAILV where fiD=102337 --8h�{�~�^9_'`�W�Oo`133914

--SELECT *  FROM  T_BD_DEPARTMENT_L  where FDEPTID=133914





--SELECT *  FROM T_GL_VOUCHERENTRY --�Q��RU_

--SELECT *  FROM T_BD_ACCOUNT_L --�y�v

--SELECT *  FROM T_BD_ACCOUNTFLEXENTRY --�y�v8h�{�~�^

--SELECT FVALUETYPE �~�^{|�W,*  FROM T_BD_FLEXITEMPROPERTY  --�~�^{|�W





--select * FROM T_BD_ACCOUNTBOOK_L



    --select * FROM T_SEC_USER