tb_gl_vendor_type.sql

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

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

Create table GL_Vendor_Type
(
  Vendor_Type_cd CHAR(2) not null constraint GL_vendor_pk primary key,
  Description   varchar(80) not null,
  Alt_nm        varchar(80) null,
  Lang          char(3) null
)
go

insert into GL_Vendor_Type values
('01','External Vendor ','外部供应商','EN')

insert into GL_Vendor_Type values
('02','Interal  Vendor ','内部供应商','EN')
insert into GL_Vendor_Type values
('03','Company Internal Department ','公司部门','EN')