Select A.fMaterielNo As fMaterielNo3/* 物料编号 */, A.fBarCode As fBarCode25/* 条码 */, A.fManSign As fManSign39/* 自定义标识码 */, A.fMaterielName As fMaterielName4/* 物料名称 */, A.ZJM As ZJM24/* 助记码 */, A.fForeignName As fForeignName6/* 外文名称 */, A.fMaterielSpec As fMaterielSpec5/* 物料规格 */, A.fBaseUnit As fBaseUnit17/* 基础单位 */, A.fPurchaseSprice As fPurchaseSprice19/* 标准进价 */, A.fLastTaxPrice As fLastTaxPrice46/* 最新进价 */, A.fSaleSprice As fSaleSprice18/* 标准售价 */, A.fBalance As fBalance0/* 售价与进价比 */, A.fMaterielID As fMaterielID1/* 物料ID */ From (select A.*,B.fTypeNo+' '+B.fTypeName as fTypeNoName, C.fPardNo+' '+C.fPardName as fPardNoName, (case when fLastTaxPrice<>0 then fSaleSprice/fLastTaxPrice else 0 end) as fBalance from PCode_Materiel as A left join PCode_MaterielType as B on A.fLineType=B.fTypeId left join OpPard_Pard as C on A.fProviderID=C.fPardID) As A /*查询.PCode_物料管理*/ Where 1=1and ((A.SignDelete IS NULL) or (A.SignDelete <> 1) ) |