• 金蝶云星空SQL 84.89 kB 2024-06-03 22:06
    • Position: 金蝶云星空SQL / 采购订单查询[星空].sql

    ��--declare @begdate date,@enddate date

--set @begdate='2022-08-01'

--set @enddate='2023-08-30'





select 

poe.FENTRYID as fid

,org.FNAME  Ǒ-��~�~

,po.FBILLNO USncx

,CONVERT(varchar(230), po.FDATE, 23) �eg

,CONVERT(VARCHAR(20),YEAR(po.FDATE)) +'-'+ CONVERT(VARCHAR(20),MONTH(po.FDATE)) t^g

,m.FNUMBER ir�ex

,mg_L.[FNAME] ir�eR�~

,ml.[FNAME] ir�e
T�y

,ml.F_QZYN_MULLANGTEXT4 ��O
T

,ml.[FSPECIFICATION] ĉ<h�W�S

,sup_L.[FNAME] �O�^FU

,dep_L.FNAME Ǒ-���

,dep_L2.FNAME �Bl��

,poe.FQTY ��USpeϑ

,poef.FTAXPRICE +TzUS�N

,(poe.FQTY * poef.FTAXPRICE) �NzT��

 from

t_PUR_POOrder po --Ǒ-���US

left join t_PUR_POOrderEntry poe on poe.FID=po.FID --Ǒ-���USf�~

left join T_PUR_POORDERENTRY_F poef on poe.FENTRYID=poef.FENTRYID --Ǒ-���US"��Rh�

left join T_PUR_POORDERENTRY_D poed on poe.FENTRYID=poed.FENTRYID --Ǒ-���USirAmh�

left join T_BD_MATERIAL m on poe.FMATERIALID=m.FMATERIALID --ir�e

left join T_BD_MATERIALGROUP_L mg_L on m.FMATERIALGROUP=mg_L.FID --ir�eR�~

left join T_BD_SUPPLIER_L sup_L on sup_L.FSUPPLIERID=po.FSUPPLIERID --�O�^FU

left join T_BD_MATERIAL_L ml on ml.FMATERIALID=poe.FMATERIALID--ir�eY��

left join T_BD_DEPARTMENT_L dep_L on dep_L.FDEPTID=po.FPURCHASEDEPTID--Ǒ-���

left join T_BD_DEPARTMENT_L dep_L2 on dep_L2.FDEPTID=FREQUIREDEPTID--�Bl��

left join T_ORG_ORGANIZATIONS_L org on org.FORGID=po.FPURCHASEORGID  and org.FLOCALEID=2052--�~�~



where po.FDOCUMENTSTATUS='C'--�]�[8h

and po.FCANCELSTATUS='A' --*g\O�^

--and po.FCREATEDATE between @begdate and @enddate