tb_po_quo_references.sql

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

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


create table PO_Quo_References
(
 Vendor_ID  varchar(10) not null,
 Order_Number varchar(30) not null,
 HPN          varchar(18) not null,
 CPN          varchar(32) null,
 MOQ          numeric(18,2) not null default 0.00,
 Unit_Price   float  not null default 0.000,
 Currency     CHAR(3) not null,
 Modify_dt  datetime not null default getdate()
)