USE [befri_Goldhoo]
GO

/****** Object:  View [basedata].[V_OrderClerkShops]    Script Date: 2021/5/13-���� 17:22:11 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE VIEW [basedata].[V_OrderClerkVendors]
AS
SELECT   ocv.EmployeeId, ocv.VendorId, v.VendorNumber, v.VendorName, v.ShortName, ocv.ValidatedOn, ocv.InvalidatedOn, 
                ocv.CreatedBy, ocv.CreatedOn, ocv.ModifiedBy, ocv.ModifiedOn, ocv.Description
FROM      basedata.OrderClerkVendor AS ocv INNER JOIN
                basedata.Vendor AS v ON v.VendorId = ocv.VendorId

GO