tb_gl_department.sql

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

if object_id('dbo.GL_Department_Mstr') is not null
drop table dbo.GL_Department_Mstr
go
create table GL_Department_Mstr
(
 dept_no CHAR(3)  not null constraint pk_gl_department primary key,
 Dept_nm varchar(30) not null,
 alt_nm varchar(30) not null
)
go

insert into GL_Department_Mstr values('001','Purchasing Dept.','采购部')
insert into GL_Department_Mstr values('002','Goods Receipt Dept.','收货部')
insert into GL_Department_Mstr values('003','Finance Dept.','财务部')
insert into GL_Department_Mstr values('004','ITS Dept.','电脑部')
insert into GL_Department_Mstr values('005','Engineering Dept.','工程部')
insert into GL_Department_Mstr values('006','Marketing Dept.','营业部')
insert into GL_Department_Mstr values('007','Production control Dept.','物控部')
insert into GL_Department_Mstr values('008','Documentation Control Dept.','文控部')
insert into GL_Department_Mstr values('009','Human Resource Dept.','人事部')
insert into GL_Department_Mstr values('010','Production Dept.','生产部')
insert into GL_Department_Mstr values('011','Quality  Dept.','品质部')
insert into GL_Department_Mstr values('010','Shippment Dept.','报关部')