viw_gl_bcmtl_mstr.sql

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

if object_id('dbo.GL_BCMTL_Mstr')  is not null
drop view dbo.GL_BCMTL_Mstr
go
create view  GL_BCMTL_Mstr
as
select 
Customer_ID,
ItemNo as HPN,
Description,
Packing,
CPN,
MPN,
Unit as UoM,
Item_Style as Procurement_Type,
Cls_No as Mtl_Class,
Typ_No as Mtl_Type,
Depot  as Warehouse,
Safe_Qty as Safe_ Qty,
Max_Qty  as Max_Qty,
Fir_Oper as Created_By,
Fir_Date  as Creation_dt,
Che	as Confirmed,
Cher   as Confirmed_by,
Che_Date as Confirmation_dt,
(case when  cut_date>getdate() then 'D' else 'A' end) as Status  from bas_item