金蝶云星空采购入库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,'' 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,u1.FRealQty As FStockQty,u1.F_PAEZ_DECIMAL As FOtherQty,v1.FCreateDate,v1.FModifyDate,st226_L.FName As FExtUnitName,st27_L.FName As FStockUnitName

From t_STK_InStock v1 Inner Join t_STK_InStockEntry u1 On v1.FID = u1.FID

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

Left Join V_GetK3CloudPOMan t3 On v1.FPurchaserID = t3.FItemID

Left Join V_GetK3CloudMaterial t4