select
Fnumber   物料代码,
t1.Fname   名称,
t1.FModel   规格型号,
FSecInv    as 安全库存,
FLowLimit  as 最低存量,
FHighLimit as 最高存量,

FErpClsID  物料属性,t3.Fname 物料属性2,

FPlanTrategy  计划策略,t4.Fname 计划策略2,
FPlanClass  计划类型,
FPlanPoint  '计划时界(天)',

FOrderTrategy  订货策略,t2.Fname 订货策略2,
FBatchAppendQty  批量增量,
FBatchQty  订货批量,
FBatFixEconomy  '固定/经济批量',
FOrderInterVal  '订货间隔期(天)',
FOrderMethod  订货方法,
FOrderPoint  再订货点,
FQtyMax   最大订货量,
FQtyMin   最小订货量,
FRequirePoint  '需求时界(天)',

FFixLeadTime  固定提前期,
FLeadTime  提前期,
FLength     长度,
FLowestBomCode  低层码,

FSource   来源,
FTopID   最高级,
FTotalTQQ  累计提前期,

FBatChangeEconomy       变动提前期批量,
FDailyConsume           日消耗量

,t5.FcreateUser 建立人,t5.FcreateDate 建立日期,t5.FLastModUser 修改人,t5.FLastModDate 修改日期
                                                                                                                                              
from t_icitem t1
inner join t_submessage t2 on t1.FOrderTrategy=t2.Finterid
inner join t_submessage t3 on t1.FErpClsID=t3.Finterid
inner join t_submessage t4 on t1.FPlanTrategy=t4.Finterid

left join t_baseproperty t5 on t1.Fitemid=t5.Fitemid

where
--t1.Fnumber like '@FnumberHH@%' and t1.FSecInv > 0  order by t1.FSecInv desc --安全库存 > 0

--t1.Fnumber like '@FnumberHH@%' and
t1.ForderTrategy=334 
order by t1.FNumber --再订货点(ROP)