tb_gl_order_type.sql

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

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

 Create Table GL_Order_Type
(
 Order_Type  CHAR(4) NOT NULL constraint GL_ORDER_TYPE_PK primary key,
 Description VARCHAR(30) NOT NULL,
 Module      CHAR(4) NOT NULL constraint GL_Module_Fk references GL_Sys_Module(Module_ID),
 )

insert into GL_Order_Type
(Order_type,Description,Module)
values('NLPO','Normal PO','2000')

insert into GL_Order_Type
(Order_type,Description,Module)
values('TLPO','Toolling PO','2000')

insert into GL_Order_Type
(Order_type,Description,Module)
values('SMPO','Sample PO','2000')

insert into GL_Order_Type
(Order_type,Description,Module)
values('SCPO','Subcontract PO','2000')


insert into GL_Order_Type
(Order_type,Description,Module)
values('DMPO','Dummy PO','2000')

insert into GL_Order_Type
(Order_type,Description,Module)
values('RTPO','Return PO','2000')