view_gl_mm_mstr.sql

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

if object_id('dbo.GL_mm_Mstr') is not null
drop view dbo.GL_mm_Mstr
go

create view  GL_mm_Mstr
as
select itemno as HPN,
CPN,
MPN,
Description,
Cust_no as Customer_ID,
Unit as Basic_UoM,
Item_typ as Material_Type,
Consign_flat as Consign_flag,
Fir_oper as Created_by,
Fir_date as Creation_dt,
cher as Updated_by,
che_date as Update_dt,
che as Approved 
from baseitem