tb_gl_mtl_type.sql

来自「工厂采购系统,DELPHI+SQL SERVER,三层技术」· SQL 代码 · 共 35 行

if object_id('dbo.GL_MTL_Type') is not null
drop table dbo.GL_MTL_Type
go

Create table GL_MTL_Type
(
 MTL_Type_CD CHAR(4) NOT NULL constraint PK_GL_MTL_Type primary key,
 Description VARCHAR(30) NOT NULL,
)
go

insert into GL_MTL_Type(MTL_Type_CD,Description) values
(
'FINI','Finished Goods	 ')
insert into GL_MTL_Type(MTL_Type_CD,Description) values
('OPSU','Operating Supplies')
insert into GL_MTL_Type(MTL_Type_CD,Description) values
('PHTM','Phantom')
insert into GL_MTL_Type(MTL_Type_CD,Description) values
('PKGD','Packaging Goods')
insert into GL_MTL_Type(MTL_Type_CD,Description) values
('RMAT','Raw Materials')

insert into GL_MTL_Type(MTL_Type_CD,Description) values
('SEMI','Semi-Finished Goods')
insert into GL_MTL_Type(MTL_Type_CD,Description) values
('TLGS','Toolings')
insert into GL_MTL_Type(MTL_Type_CD,Description) values
('TRDG','Trading Goods')

insert into GL_MTL_Type(MTL_Type_CD,Description) values
('SCDS','Subcontract Goods')
go