tb_cancel_po.sql

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

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

create table Cancel_PO_Log
(
  Order_Number varchar(30) not null constraint pk_po_log primary key,
  Action_type  VARCHAR(30) NOT NULL,
  Action_dt    datetime not null default getdate(),
  Action_by    varchar(15) not null,
  Reason       varchar(250) not null,
  Remark       varchar(250) null
)