view_vendor_selection.sql

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

if object_id('dbo.view_Vendor_Selection') is not null
drop view dbo.view_Vendor_Selection
go

create view view_Vendor_Selection
as
select a.vendor_id,b.vendor_nm,a.hpn,a.cpn,a.mpn,a.description,convert(numeric(18,8),a.Unit_Price) as Unit_Price,a.Currency,a.basic_uom,a.vendor_uom,a.lead_time,a.model,a.moq,a.sug_vendor_nm,b.payterms,b.deft_currency from po_information_Record a,po_vendor_mstr b
where a.vendor_id = b.vendor_id

--select * from view_Vendor_Selection