• 金蝶云星空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

    Powered by kodbox V1.63

    Copyright © kodcloud.com.

    Files