CREATE VIEW [dbo].[RPMViewItem]
AS
SELECT  dbo.IV00101.ITEMNMBR, dbo.IV00101.ITEMDESC, dbo.IV00101.UOMSCHDL, dbo.IV40201.UMSCHDSC, dbo.IV00101.ITMCLSCD, 
	dbo.IV00101.PRCLEVEL, dbo.IV00101.PriceGroup, dbo.IV00101.LOCNCODE, dbo.IV00101.PRCHSUOM, dbo.IV00101.SELNGUOM, 
	dbo.IV00101.ITMSHNAM, dbo.IV00101.ITMGEDSC, dbo.IV00101.USCATVLS_1, dbo.IV00101.USCATVLS_2, dbo.IV00101.USCATVLS_3, 
	dbo.IV00101.USCATVLS_4, dbo.IV00101.USCATVLS_5, dbo.IV00101.USCATVLS_6, dbo.IV00101.CREATDDT, dbo.IV00101.MODIFDT, dbo.IV40400.ITMCLSDC
FROM     dbo.IV00101 
	LEFT JOIN
		dbo.IV40400 ON dbo.IV00101.ITMCLSCD = dbo.IV40400.ITMCLSCD
	LEFT JOIN
		dbo.IV40201 ON dbo.IV00101.UOMSCHDL = dbo.IV40201.UOMSCHDL
