use befri_Goldhoo
go

CREATE VIEW [basedata].[V_Vendor] as
SELECT VendorId, VendorType, VendorNumber, VendorName, ShortName, Contact, Telephone1, Telephone2, Telephone3, Fax, EMail, DefaultCapacity, Postalcode,Address, Opened, OpenedBy, OpenedOn, VersionNumber, CreatedBy, CreatedOn, ModifiedBy, ModifiedOn, Description FROM basedata.Vendor
go