tb_gl_order_status.sql

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

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

Create table GL_Order_Status
(
 Module_ID   varchar(4) not null default '2000',
 Status_cd   CHAR(1) not null,
 Description varchar(80) not null,
 Alt_nm	     varchar(80) not null
)
go

insert into GL_Order_Status values('2000','O','Opening','活动的')
insert into GL_Order_Status values('2000','R','Released','已发放的')
insert into GL_Order_Status values('2000','B','Blocked',  '锁定的')
insert into GL_Order_Status values('2000','C','Cancelled','已取消的')
insert into GL_Order_Status values('2000','F','Finished','已完成的')
insert into GL_Order_Status values('2000','P','Processing','处理中的')