CREATE VIEW dbo.ENDICIA_READ
AS
SELECT MANIFESTENTRIES.SHIPMETHOD, MANIFESTENTRIES.FULLORDERNO, MANIFESTENTRIES.NAMEX, MANIFESTENTRIES.COMPANYNAME,
	MANIFESTENTRIES.STREET AS ADDRESS1, MANIFESTENTRIES.REF1 AS ADDRESS2, MANIFESTENTRIES.REF2 AS ADDRESS3,
	MANIFESTENTRIES.CITY, MANIFESTENTRIES.STATE, MANIFESTENTRIES.ZIP, COUNTRIES.COUNTRYNAME
	FROM MANIFESTENTRIES WITH(NOLOCK)
	INNER JOIN COUNTRIES WITH(NOLOCK) ON COUNTRIES.COUNTRY = MANIFESTENTRIES.COUNTRYCODE