Dynamics GP - SQL View - Item Class, Inventory Class Accounts

/****** Object:  View [dbo].[BI_InvClass]    Script Date: 09/20/2014 08:12:04 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE VIEW [dbo].[BI_InvClass]
AS
SELECT     dbo.IV40400.ITMCLSCD, dbo.IV40400.ITMCLSDC, GL00105_1.ACTNUMST AS Inv, GL00105_10.ACTNUMST AS InvOffset, GL00105_2.ACTNUMST AS InvCOGS,
                      GL00105_3.ACTNUMST AS InvSls, GL00105_4.ACTNUMST AS InvMarkdown, GL00105_5.ACTNUMST AS SlsReturns, GL00105_6.ACTNUMST AS InvInUse,
                      GL00105_7.ACTNUMST AS InvInSvc, GL00105_8.ACTNUMST AS Damaged, GL00105_9.ACTNUMST AS InvVariance, GL00105_15.ACTNUMST AS DropShip,
                      GL00105_13.ACTNUMST AS PurchPriceVar, GL00105_14.ACTNUMST AS UnrPurchPriceVar, GL00105_12.ACTNUMST AS InvReturns,
                      GL00105_11.ACTNUMST AS AssemblyVar, dbo.GL00105.ACTNUMST AS StdCostReval
FROM         dbo.GL00105 AS GL00105_6 RIGHT OUTER JOIN
                      dbo.GL00105 AS GL00105_8 RIGHT OUTER JOIN
                      dbo.GL00105 RIGHT OUTER JOIN
                      dbo.IV40400 ON dbo.GL00105.ACTINDX = dbo.IV40400.IVSCRVIX LEFT OUTER JOIN
                      dbo.GL00105 AS GL00105_11 ON dbo.IV40400.ASMVRIDX = GL00105_11.ACTINDX LEFT OUTER JOIN
                      dbo.GL00105 AS GL00105_12 ON dbo.IV40400.IVRETIDX = GL00105_12.ACTINDX LEFT OUTER JOIN
                      dbo.GL00105 AS GL00105_14 ON dbo.IV40400.UPPVIDX = GL00105_14.ACTINDX LEFT OUTER JOIN
                      dbo.GL00105 AS GL00105_13 ON dbo.IV40400.PURPVIDX = GL00105_13.ACTINDX LEFT OUTER JOIN
                      dbo.GL00105 AS GL00105_15 ON dbo.IV40400.DPSHPIDX = GL00105_15.ACTINDX LEFT OUTER JOIN
                      dbo.GL00105 AS GL00105_9 ON dbo.IV40400.IVVARIDX = GL00105_9.ACTINDX ON GL00105_8.ACTINDX = dbo.IV40400.IVDMGIDX LEFT OUTER JOIN
                      dbo.GL00105 AS GL00105_7 ON dbo.IV40400.IVINSVIX = GL00105_7.ACTINDX ON GL00105_6.ACTINDX = dbo.IV40400.IVINUSIX LEFT OUTER JOIN
                      dbo.GL00105 AS GL00105_5 ON dbo.IV40400.IVSLRNIX = GL00105_5.ACTINDX LEFT OUTER JOIN
                      dbo.GL00105 AS GL00105_4 ON dbo.IV40400.IVSLDSIX = GL00105_4.ACTINDX LEFT OUTER JOIN
                      dbo.GL00105 AS GL00105_3 ON dbo.IV40400.IVSLSIDX = GL00105_3.ACTINDX LEFT OUTER JOIN
                      dbo.GL00105 AS GL00105_2 ON dbo.IV40400.IVCOGSIX = GL00105_2.ACTINDX LEFT OUTER JOIN
                      dbo.GL00105 AS GL00105_10 ON dbo.IV40400.IVIVOFIX = GL00105_10.ACTINDX LEFT OUTER JOIN
                      dbo.GL00105 AS GL00105_1 ON dbo.IV40400.IVIVINDX = GL00105_1.ACTINDX

GO