tb_po_quorec_hdr.sql

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

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

create table PO_QuoRec_Hdr
(
 HPN          VARCHAR(18) NOT NULL constraint PK_PO_Quo_Mstr primary key,
 Status       CHAR(1) NOT NULL,
 Vendor_ID    CHAR(10) NOT NULL,
 CPN	      varchar(30) NULL,
 MPN	      VARCHAR(30) NULL,
 MODEL        VARCHAR(80) NULL,
 UoM	      CHAR(3) NOT NULL,
 Last_Price   float  not null default 0.000001,
 Currency     CHAR(3) NOT NULL,
 Last_PO      VARCHAR(30) NULL,
 Blocked      CHAR(1) NOT NULL default 'N'
)
Go
insert into PO_QuoRec_Hdr SELECT * from PO_Master_Record_Hdr