SELECT po.FBILLTYPEID, po.FID '采购订单内码' ,po.FBILLNO '采购订单编码',po.FDATE , po1.FMATERIALID '明细物料内码' ,mat.FNUMBER '物料编码' ,mat_l.FNAME '物料名称' ,
       aux.FF100001 '保税类型内码' , tFF100001.FNUMBER '保税类型编码' , tFF100001_l.FDATAVALUE '保税类型名称',po1.FQTY,po1.FENTRYID
FROM   T_PUR_POORDER po
       LEFT JOIN T_PUR_POORDERENTRY po1 ON ( po.FID = po1.FID )
       LEFT JOIN T_BD_MATERIAL mat ON ( po1.FMATERIALID = mat.FMATERIALID )
       LEFT JOIN T_BD_MATERIAL_L mat_l ON (   mat.FMATERIALID = mat_l.FMATERIALID
                                              AND mat_l.FLOCALEID = 2052
                                          )
       LEFT JOIN T_BD_FLEXSITEMDETAILV aux ON po1.FAUXPROPID = aux.FID
       LEFT JOIN T_BAS_ASSISTANTDATAENTRY tFF100001 ON aux.FF100001 = tFF100001.FENTRYID
       LEFT JOIN T_BAS_ASSISTANTDATAENTRY_L tFF100001_l ON (   tFF100001.FENTRYID = tFF100001_l.FENTRYID
                                                               AND tFF100001_l.FLOCALEID = 2052
                                                           )
WHERE po.FBILLNO='CGDD000006'

SELECT a.FBILLTYPEID, a.FID,a.FBILLNO,a.FDATE,b.FMATERIALID,mat.FNUMBER '物料编码' , mat_l.FNAME '物料名称' , aux.FF100001 '保税类型内码' ,
       tFF100001.FNUMBER '保税类型编码' , tFF100001_l.FDATAVALUE '保税类型名称',b.FLOT,b.FLOT_TEXT,b.FSTOCKID,b.FSTOCKLOCID,
    b.FActReceiveQty '交货数量' ,c.FREJECTQTY '拒收数量',c.FCHECKQTY '检验数量',c.FCHECKJOINQTY '检验关联数量',c.FRETURNQTY'退料数量',c.FRETURNJOINQTY'退料关联数量',
    c.FINSTOCKQTY'入库数量',c.FINSTOCKJOINQTY'合格入库关联数量',c.FCSNRECEIVEQTY'让步接收数量',c.FCSNRECEIVEJOINQTY'让步接收关联数量',
    c.FREFUSEQTY'判退数量',c.FREFUSEJOINQTY'不合格关联数量',c.FRECEIVEQTY'合格数量',
    b.FORDERBILLNO,b.FPOORDERENTRYID,b.FSRCID,b.FSRCFORMID,b.FSRCBILLNO,b.FSRCENTRYID,b.FENTRYID
FROM dbo.T_PUR_RECEIVE a
INNER JOIN dbo.T_PUR_RECEIVEENTRY b ON b.FID=a.FID
LEFT JOIN dbo.T_PUR_RECEIVEENTRY_S c ON c.FID=b.FID AND c.FENTRYID=b.FENTRYID
 LEFT JOIN T_BD_MATERIAL mat ON ( b.FMATERIALID = mat.FMATERIALID )
       LEFT JOIN T_BD_MATERIAL_L mat_l ON (   mat.FMATERIALID = mat_l.FMATERIALID
                                              AND mat_l.FLOCALEID = 2052
                                          )
       LEFT JOIN T_BD_FLEXSITEMDETAILV aux ON b.FAUXPROPID = aux.FID
       LEFT JOIN T_BAS_ASSISTANTDATAENTRY tFF100001 ON aux.FF100001 = tFF100001.FENTRYID
       LEFT JOIN T_BAS_ASSISTANTDATAENTRY_L tFF100001_l ON (   tFF100001.FENTRYID = tFF100001_l.FENTRYID
                                                               AND tFF100001_l.FLOCALEID = 2052
                                                           )
WHERE a.FBILLNO='CGSL000013' --AND c.FCHECKQTY=c.FCHECKJOINQTY --检验数量=检验关联数量 表示收料单的整体检验流程完成
 

SELECT a.FBILLTYPEID,a.FFORMID,a.FID,a.FBILLNO,a.FDATE,a.FMODIFYDATE,b.FSUPPLIERID,c.FMATERIALID,b.FLOT,b.FLOT_TEXT,b.FSTOCKID,b.FSTOCKLOCID,
 b.FINSPECTQTY,b.FQUALIFIEDQTY,b.FUNQUALIFIEDQTY,d.FSEQ,CASE WHEN d.FSTATUS=1 THEN '合格' WHEN d.FSTATUS=2 THEN '不合格'END FSTATUS,d1.FMEMO,
 CASE WHEN d.FUSEPOLICY='A' THEN '合格' WHEN d.FUSEPOLICY='B' THEN '让步接收' WHEN d.FUSEPOLICY='E' THEN '挑选使用' WHEN d.FUSEPOLICY='F' THEN '拒收'   END FUSEPOLICY,d.FQTY,
 CASE WHEN d.FUSEPOLICY='A' THEN 0 WHEN d.FUSEPOLICY='B' THEN 1 WHEN d.FUSEPOLICY='E' THEN 2 WHEN d.FUSEPOLICY='F' THEN 4  END FQCType,
 c.FSRCBILLTYPE,c.FSRCBILLNO,c.FSRCINTERID,c.FSRCENTRYID,e.FORDERTYPE,e.FORDERBILLNO,e.FORDERID,e.FORDERENTRYID,
 r.FCHECKQTY,r.FCHECKJOINQTY
FROM dbo.T_QM_INSPECTBILL a
INNER JOIN dbo.T_QM_INSPECTBILLENTRY b ON b.FID=a.FID
LEFT JOIN T_QM_INSPECTBILLENTRY_A c ON c.FENTRYID=b.FENTRYID
INNER JOIN T_QM_IBPOLICYDETAIL d ON d.FENTRYID=b.FENTRYID
INNER JOIN T_QM_IBPOLICYDETAIL_L d1 ON d1.FDETAILID=d.FDETAILID
INNER JOIN T_QM_IBREFERDETAIL e ON e.FENTRYID=b.FENTRYID
INNER JOIN T_PUR_RECEIVEENTRY_S r ON r.FID=c.FSRCINTERID AND r.FENTRYID=c.FSRCENTRYID
WHERE a.FBILLNO='IQC000005'
 --AND r.FCHECKQTY=r.FCHECKJOINQTY --检验数量=检验关联数量 表示收料单的整体检验流程完成