tb_po_rfq_all.sql

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

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

create table PO_RFQ_ALL
(
 Item	 int not null identity(1,1) primary key,
 RFQ_Number varchar(15) null,
 Search_term varchar(30) null,
 Version    int  not null default 1,
 short_Txt  varchar(30) null,
 Status     CHAR(1) not null default 'A',
 Vendor_id  char(10) null,
 Vendor_nm  varchar(120) null,
 RFQ_Date   datetime not null default getdate(),
 Vaild_dt   datetime not null default getdate(),
 Deadline   datetime not null default getdate(),
 HPN varchar(18) null,
 CPN varchar(30) null,
 MPN varchar(30) null,
 Material varchar(120) null,
 Model	   varchar(30) null,
 Mtl_type_cd CHAR(4) not null,
 Mtl_Group   char(4) not null,
 Mtl_Group_nm varchar(30) null,
 basic_uom    char(3) not null,
 Order_UoM    char(3) not null,
 MOQ	     int not null default 0,
 Currency    CHAR(3) not null,
 Unit_Price  float not null default 0.000001,
 Lead_Time   int not null default 0,
 Customer_id char(5) null,
 Customer_nm varchar(120) null,
 Remark	     varchar(120) null,
 Creation_dt datetime not null default getdate(),
 Created_by  varchar(15) not null,
 Update_dt   datetime not null default getdate(),
 Updated_by  varchar(15) not null
)