tb_po_quorec_item.sql

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

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

create table PO_QuoRec_Item
(
 HPN 	varchar(18) not null,
 Vendor_id char(10) not null,
 Lead_Time  int not null default 0,
 MOQ	    int not null default 0,
 MPQ	    int not null default 0,
 Unit_Price float not null default 0.00001,
 Currency   CHAR(3) NOT NULL default 'HKD',
 Priority   CHAR(1) NOT NULL default 'L',
 Active	    BIT  NOT NULL default 1,
 Created_By VARCHAR(15) NOT NULL,
 Creation_dt datetime not null,
 Updated_By  VARCHAR(15) not null,
 Updated_dt  datetime not null
)
go

insert into PO_QuoRec_Item select * from PO_Master_Record_item