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 
dpt_store.ItemNo as HPN,
 bas_item.Description, 
      dpt_store.Depot as WareHouse,
      Base_Depot.Depot_Nm as [WareHouse_nm], 
 dpt_store.Stock_Qty,
 dpt_store.Unit as UoM, 
      bas_item.CPN,
 bas_item.Cust_No as Customer_ID,
 bas_item.typ_no as Mtl_Type, 
dpt_store.LastIn_Date, 
      dpt_store.LastOut_Date,
 bas_item.Mpn
FROM dpt_store 
INNER JOIN
      Bas_Item ON dpt_store.ItemNo = bas_item.ItemNo INNER JOIN
      Base_Depot ON dpt_store.Depot = Base_Depot.Depot
ORDER BY dpt_store.ItemNo, dpt_store.Depot