USE [AirTrak]
GO

/****** Object:  View [dbo].[VW_RoutingDetails]    Script Date: 6/15/2021 10:40:27 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO




ALTER view [dbo].[VW_RoutingDetails]
as

select  A.PK_CustomerRoutingCodeNo,A.BillNo as BillTo ,C.CustName as CustName ,A.ConNo as Consignee, D.CustName as ConName  ,A.VendorId as Carrier,V.VendorName as VendorName,A.CustomerCode as Code,A.SpecialInstructions as SpecialInstructions
from tbl_CustomerRoutingLabelCode A 
Left  join tbl_Customers C on C.PK_CustNo=A.BillNo
Left  join tbl_Customers D on D.PK_CustNo=A.ConNo
left join tbl_Vendors V on A.VendorId=V.VendorId





GO