tb_gl_job_type.sql

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

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

Create table GL_JOB_Type
(
 module_id varchar(4) not null default '2000',
 JOB_TYPE VARCHAR(3) NOT NULL,
 Description varchar(30) not null
)
go


insert into GL_JOB_TYPE values('2000','J01','Digital Signature')
insert into GL_JOB_TYPE values('2000','J02','New Source List Record')
insert into GL_JOB_TYPE values('2000','J03','Source List Modification')
insert into GL_JOB_TYPE values('2000','J04','PO Record Modification')
insert into GL_JOB_TYPE values('2000','J05','New Vendor Record')
insert into GL_JOB_TYPE values('2000','J06','Vendor Record Modification')
insert into GL_JOB_TYPE values('2000','J07','New Price Record')