?? tb_gl_mtl_type.sql
字號:
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
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -