## 20170724工作內容 #### 火鍋節消息推送 150   #### 物流供應鏈會議 #### 根據短碼補全商品信息 200 SELECT t2.FFullName ,t_ICItem.*,t_ICItem.FStoreUnitID as FCUUnit_ID,t1.FName as FUnitName,t3.FName as FCUUnitName,t4.FName as FSecUnitName, t1.FNumber as FUnitNumber,t3.FNumber as FCUUnitNumber FROM t_ICItem Left Join t_MeasureUnit t1 on t_ICItem.FUnitID=t1.FItemID Inner join t_Item t2 on t_ICItem.FItemID=t2.FItemID Left Join t_MeasureUnit t3 on t_ICItem.FStoreUnitID=t3.FItemID AND t3.FDeleted=0 Left Join t_MeasureUnit t4 on t_ICItem.FSecUnitID=t4.FItemID AND t3.FDeleted=0 Where t2.FDetail=1 AND t_ICItem.FDeleted=0 AND (t_ICItem.FNumber='01.01.01.002' OR t_ICItem.FShortNumber='01.01.01.002' ) and t_ICItem.FErpClsID NOT IN (6,8) #### 部門查詢 SELECT TOP 50 t1.FItemID ,t1.FDeleted ,t1.FNumber,t1.FName,t1.FDetail FROM [AIS20170612094709].[dbo].[t_Item] t1 with(index (uk_Item2)) LEFT JOIN t_Department x2 ON t1.FItemID = x2.FItemID WHERE FItemClassID = 2 AND t1.FDetail=1 AND ((t1.FNumber Like '%01.01.02%' OR t1.FName LIKE '%01.01.02%')) AND t1.FDeleteD=0 ORDER BY t1.FNumber SELECT TOP 50 t1.[FItemID] ,t1.[FDeleted] ,t1.[FNumber],t1.[FName],t1.[FDetail] FROM [stock].[dbo].[t_Item] t1 with(index (uk_Item2)) LEFT JOIN [stock].[dbo].[t_Department] x2 ON t1.FItemID = x2.FItemID WHERE FItemClassID = 2 AND t1.FDetail=1 AND ((t1.FNumber Like '01%' OR t1.FName LIKE '01%')) AND t1.FDeleteD=0 ORDER BY t1.FNumber #### 主管查詢 SELECT TOP 50 t1.FItemID ,t1.FDeleted ,t1.FNumber,t1.FName,t1.FDetail FROM [stock].[dbo].[t_Item] t1 with(index (uk_Item2)) LEFT JOIN [stock].[dbo].[t_Emp] x2 ON t1.FItemID = x2.FItemID WHERE FItemClassID = 3 AND t1.FDetail=1 AND ((t1.FNumber Like '%0102%' OR t1.FName LIKE '%0102%')) AND t1.FDeleteD=0 ORDER BY t1.FNumber #### 業務員查詢 SELECT TOP 50 t1.FItemID ,t1.FDeleted ,t1.FNumber,t1.FName,t1.FDetail FROM [stock].[dbo].[t_Item] t1 with(index (uk_Item2)) LEFT JOIN [stock].[dbo].[t_Emp] x2 ON t1.FItemID = x2.FItemID WHERE FItemClassID = 3 AND t1.FDetail=1 AND ((t1.FNumber Like '%0201%' OR t1.FName LIKE '%0201%')) AND t1.FDeleteD=0 ORDER BY t1.FNumber #### 保管員查詢 SELECT t1.FItemID ,t1.FDeleted FROM t_Item t1 with(index (uk_Item2)) LEFT JOIN t_Emp x2 ON t1.FItemID = x2.FItemID WHERE FItemClassID = 3 AND t1.FDetail=1 AND ((t1.FNumber Like '%0116%' OR t1.FName Like '%0116%')) AND t1.FDeleteD=0 ORDER BY t1.FNumber #### 獲取銷售方式： SELECT FTypeID,FInterID FItemID, FID FNumber,FName,FSpec FROM t_SubMessage Where FInterID>0 AND FDeleted=0 And FTypeID=101 AND (FInterID<> 20296) And (FInterID<> 20296) ORDER BY FID SELECT TOP 1000 [FBrNo] ,[FInterID] ,[FID] ,[FParentID] ,[FName] ,[FTypeID] ,[FDetail] ,[FDeleted] ,[FModifyTime] ,[FSystemType] ,[FSpec] ,[UUID] FROM [AIS20170612094709].[dbo].[t_SubMessage] t1 Where t1.FInterID>0 AND t1.FDeleted=0 And t1.FTypeID=101 AND (t1.FInterID<> 20296) And (t1.FInterID<> 20296) ORDER BY t1.FID #### 獲取購貨單位： SELECT TOP 50 t1.FItemID ,t1.FDeleted ,t1.FNumber,t1.FName,t1.FDetail FROM t_Item t1 with(index (uk_Item2)) LEFT JOIN t_Organization x2 ON t1.FItemID = x2.FItemID WHERE FItemClassID = 1 AND t1.FDetail=1 AND t1.FDeleteD=0 ORDER BY t1.FNumber SELECT TOP 1000 t1.[FItemID] ,t1.[FItemClassID] ,t1.[FExternID] ,t1.[FNumber] ,t1.[FParentID] ,t1.[FLevel] ,t1.[FDetail] ,t1.[FName] ,t1.[FUnUsed] ,t1.[FBrNo] ,t1.[FFullNumber] ,t1.[FDiff] ,t1.[FDeleted] ,t1.[FShortNumber] ,t1.[FFullName] ,t1.[UUID] ,t1.[FGRCommonID] ,t1.[FSystemType] ,t1.[FUseSign] ,t1.[FChkUserID] ,t1.[FAccessory] ,t1.[FGrControl] ,t1.[FModifyTime] ,t1.[FHavePicture] FROM [AIS20170612094709].[dbo].[t_Item]t1 with(index (uk_Item2)) LEFT JOIN [AIS20170612094709].[dbo].t_Organization x2 ON t1.FItemID = x2.FItemID WHERE t1.[FItemClassID] = 1 AND t1.[FDetail]=1 AND t1.[FDeleted]= 0 ORDER BY t1.[FNumber] DESC #### 商品基本信息 100 + 商品編號 + 商品品牌編號 + 商品名稱 + 規格 + 采購規格 * #### 商品品牌 + 品牌編號 + 品牌名稱 + 商戶名稱 #### 商品價格 + 商品編號 + 商品單價 + 參考成本價 + 采購價 #### 商品基本單位 + 基本單位 #### 倉庫 + 倉庫編號 #### 商品庫存清單 + 商品編號 + 倉庫編號 + 庫存數量 #### 商品規格型號 + 規格型號 #### 商品軟屬性 + 商品編號 + 商品標簽