viw_gl_stock.sql

工厂采购系统,DELPHI+SQL SERVER,三层技术

SET QUOTED_IDENTIFIER ON 
if object_id('Viw_GL_Stock') is not null
drop view Viw_GL_Stock
go

create view Viw_GL_Stock
AS
SELECT TOP 100 PERCENT 
Depot_ItemData.ItemNo as HPN,
 BaseItem.Description, 
      Depot_ItemData.Depot as WareHouse,
      Base_Depot.Depot_Nm as [WareHouse_nm], 
 Depot_ItemData.Stock_Qty,
 Depot_ItemData.Unit as UoM, 
      BaseItem.CPN,
 BaseItem.Cust_No as Customer_ID,
 BaseItem.Item_Typ as Mtl_Type, 
Depot_ItemData.LastInDate, 
      Depot_ItemData.LastOutDate,
 BaseItem.Mpn
FROM Depot_ItemData 
INNER JOIN
      BaseItem ON Depot_ItemData.ItemNo = BaseItem.ItemNo INNER JOIN
      Base_Depot ON Depot_ItemData.Depot = Base_Depot.Depot
ORDER BY Depot_ItemData.ItemNo, Depot_ItemData.Depot