tb_po_rfq_item.sql

工厂采购系统,DELPHI+SQL SERVER,三层技术

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

create table PO_RFQ_Item
(
 RFQ_Number varchar(10) NOT NULL constraint RFQ_fk references PO_RFQ_Hdr(RFQ_Number),
 hpn	    varchar(18) null,
 Material   varchar(120) not null,
 cpn        varchar(30) null,
 mpn	    varchar(30) null,
 model      varchar(30) null,
 VPN        VARCHAR(30) not null,
 RFQ_Qty    numeric(18,2) not null,
 MOQ	    numeric(18,2) null,
 UoM        CHAR(3) not null,
 Unit_Price float not null default 0.00000,
 Currency   CHAR(3) NOT NULL,
 Delivery_dt Datetime not null default getdate(),
 Mtl_Group  CHAR(4) null,
 MTL_TYPE_CD CHAR(4) NULL,
 plant      char(4)  null,
 BA_Code    CHAR(4) NULL,
 PUR_ORG    CHAR(4) NULL, 
 PUR_Group  CHAR(4) NULL,
 Approved_flag bit  not null default 0,
 deleted_flag bit not null default 0,
 Cancelling_flag bit  not null default 0,
 Closed_Flag bit not null default 0, 
 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
)
go