云星空采购退料单SQL查询语句

Select Convert(nvarchar(50),'采购退料单') As FBillTypeName,v1.FStockOrgID,v1.FDate,v1.FID As FInterID,v1.FBillNo,'' As FCodeNo,'' As FShiftType,

       t2.FShortName As FSupplyShortName,t2.FName As FSupplyName,'' As FCustShortName,'' As FCustName,t3.FName As FEmpName,'' As FSenderName,v1.FDescription As FNote,

       Convert(nvarchar(50),Case When v1.FDocumentStatus = 'Z' then '暂存' When v1.FDocumentStatus = 'A' then '创建' When v1.FDocumentStatus = 'B' then '审核中' When v1.FDocumentStatus = 'C' then '已审核' When v1.FDocumentStatus = 'D' then '重新审核' End) As FStatus,

   u1.FEntryID,u1.FSeq,t4.FNumber,t4.FMaterialName,t4.FSpecification,'' As FWorkShopName,'' As FSrcStockName,'' As FDestStockName,t9.FStockName,'' As FDataValue,u1.FExtAuxUnitQty As FExtAuxUnitQty,u1.FRMRealQty As FStockQty,u1.F_PAEZ_DECIMAL As FOtherQty,v1.FCreateDate,v1.FModifyDate,st226_L.FName As FExtUnitName,st27_L.FName As FStockUnitName

From t_PUR_MRB v1 Inner Join t_PUR_MRBEntry u1 On v1.FID = u1.FID

Left Join V_GetK3CloudSupplier t2 On v1.FSupplierID = t2.FItemID

Left Join V_GetK3CloudPOMan t3 On v1.FPurchaserID =