tb_gl_number_rule.sql

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

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

create table GL_Number_Rule
(
 Module_ID char(4) not null default '2000',
 PreFix    varchar(4) not null,
 Description varchar(80) not null,
 Alt_nm	     varchar(80) not null
)
go

insert into GL_Number_Rule values ('2000','PO','Gernal PO (HK,China)  ','普通PO(HK,大陆专用)采购单 ')
insert into GL_Number_Rule values('2000','POL','Long Hua Plant PO  ','龙华PO,(龙华专用)采购单 ')
insert into GL_Number_Rule values('2000','POM','Macao Office PO  ','奥门PO(奥门专用)采购单 ')
insert into GL_Number_Rule values('2000','POML','Macao Support Long Hua PO ','奥门支持龙华采购单 ')