Dynamics GP - SSRS - Item Class Lookup View

--For use with Item class parameter selection for SSRS reports

CREATE VIEW [dbo].[BI_ItemClass_Lookup]
AS
SELECT     TOP (100) PERCENT ITMCLSCD, ITMCLSDC, RTRIM(ITMCLSCD) + ' | ' + RTRIM(ITMCLSDC) AS ItemClassLbl
FROM        dbo.IV40400
ORDER BY ITMCLSCD