imp_information_record.sql

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

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


CREATE TABLE IMP_Information_Record
(
item		int identity(1,1) not null constraint pk_imp_po_item_mstr primary key,
vendor_id	CHAR(8) NOT NULL,
vendor_nm	VARCHAR(120) NOT NULL,
sug_vendor_id   CHAR(8) NULL,
sug_vendor_nm	VARCHAR(120) NOT NULL,
HPN		VARCHAR(18) NULL,
MTL_TYPE_CD	CHAR(4) NOT NULL DEFAULT 'RMAT',
Priority	CHAR(1) NOT NULL DEFAULT 'H',
Description	VARCHAR(255) NOT NULL,
CPN		VARCHAR(32) NULL,
MPN		VARCHAR(32) NULL,
MODEL		VARCHAR(80) 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.0000001,
Currency	CHAR(3) NOT NULL DEFAULT 'RMB',
Item_Class_cd	CHAR(2) NULL,
Basic_UoM	CHAR(3) NOT NULL DEFAULT 'PCS',
Vendor_UoM	CHAR(3) NOT NULL DEFAULT 'PCS',
Customer_ID	CHAR(5) NULL,
Status          CHAR(1) NOT NULL DEFAULT 'A',
effectived_dt   datetime not null default getdate(),
Expiration_dt   Datetime not null default Getdate(),
Created_by	VARCHAR(15) NOT NULL,
Creation_dt	datetime not null default getdate(),
Updated_by	VARCHAR(15) NOT NULL ,
Update_dt	Datetime not null default getdate()
)
go