tb_po_vendor_mstr.sql

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

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

CREATE TABLE PO_Vendor_Mstr (
	item int NOT NULL ,
	Vendor_ID char (8) Constraint pk_Vendor_id primary key  not NULL,
	Status    Char(1) null default 'A',
	title	  varchar(30) not null default 'Company',	
	Vendor_class char (1) NULL,
	Vendor_Type_cd CHAR(2) NOT NULL default '01',
	Vendor_nm varchar (255) not null,
	Vendor_nm1 varchar(255) null,	
	search_terms1 varchar(30) null,
	search_terms2 varchar(30) null,
	street 	      varchar(120) null,
	house_number  varchar(30) null,
	postal_code   varchar(7) null,
	city	      varchar(30) null,
	country	      varchar(30) null,
	language      varchar(30) null,
	TEL varchar (30)  NULL ,
	FAX varchar (30)  NULL ,
	cont1 varchar (30)  NULL ,
	address  varchar(255) not null,
	address1  varchar(255) null,
	address2  varchar(255) null,
	deft_Address varchar (255)  NULL ,
	Deft_Currency  CHAR(3) NULL,
	Mult_Currency  bit null default 0,
	Currency1      CHAR(3) null,
	Currency2      CHAR(3) null,
	inv_verify_flag bit null default 0,
	MOQ	       Numeric(18,3) default 0.00,
	Deliv_Plant    CHAR(4) null,
	Pur_org	       CHAR(4) null,
	Plant	       CHAR(4) NULL,
	Pur_grp	       CHAR(4) NULL,
	payterms varchar (125)  NULL ,
	Deliv_Local CHAR(3) NULL,
	Account_no	VARCHAR(8) NULL,
	discount	numeric(18,3) null default 0.00,
	handling_chrg   numeric(18,3) null default 0.00,
	website varchar (80)  NULL ,
	email varchar (80)  NULL ,
	email2  VARCHAR(80) NULL,
	Remark varchar (255) null,
        Controller varchar(15) null,
	creation_dt datetime NULL, 
	created_by  varchar(15) not null,
	update_dt datetime not null default getdate(),
	updated_by varchar(15) not null)
GO

alter table PO_Vendor_mstr
drop column TEL1
go

/*
alter table PO_Vendor_mstr
drop column fax1
go
alter table PO_Vendor_mstr
drop column Extersion
go

alter table PO_Vendor_mstr
drop column mobile_phone1
go

alter table PO_Vendor_mstr
drop column mobile_phone2
go

alter table PO_Vendor_mstr
drop column cont2
go


sp_help po_vendor_mstr
*/