Item Storage Dimensions

Submitted by Nathan Clouse on 09/10/15.

A view that shows storage dimensions and all the elements that compose a storage dimension group. For instance, when using Contoso Data, storage dimension group "SiteWHLoc" has Site, Warehouse and Location enabled.

AX Version:

AX 2012

Module:

Product Information Management

CREATE VIEW [dbo].[vw_pimStorageDimensions] 
AS 
  SELECT *, 
         'WMSLocationEnabled' = (SELECT isactive 
                                 FROM 
         ecoresstoragedimensiongroupfldsetup fld 
                                 WHERE 
         fld.storagedimensiongroup = ers.recid 
         AND fld.dimensionfieldid = 3 
         AND fld.partition = ers.partition), 
         'WMSPalletIdEnabled' = (SELECT isactive 
                                 FROM 
         ecoresstoragedimensiongroupfldsetup fld 
                                 WHERE 
         fld.storagedimensiongroup = ers.recid 
         AND fld.dimensionfieldid = 4 
         AND fld.partition = ers.partition), 
         'InventWarehouseEnabled' = (SELECT isactive 
                                     FROM 
         ecoresstoragedimensiongroupfldsetup fld 
                                     WHERE 
         fld.storagedimensiongroup = ers.recid 
         AND fld.dimensionfieldid = 6 
         AND fld.partition = ers.partition), 
         'InventSiteEnabled' = (SELECT isactive 
                                FROM 
         ecoresstoragedimensiongroupfldsetup fld 
                                WHERE 
         fld.storagedimensiongroup = ers.recid 
         AND fld.dimensionfieldid = 16 
         AND fld.partition = ers.partition), 
         'LicensePlateEnabled' = (SELECT isactive 
                                  FROM 
         ecoresstoragedimensiongroupfldsetup fld 
                                  WHERE 
         fld.storagedimensiongroup = ers.recid 
         AND fld.dimensionfieldid = 20001 
         AND fld.partition = ers.partition), 
         'InventStatusEnabled' = (SELECT isactive 
                                  FROM 
         ecoresstoragedimensiongroupfldsetup fld 
                                  WHERE 
         fld.storagedimensiongroup = ers.recid 
         AND fld.dimensionfieldid = 20001 
         AND fld.partition = ers.partition) 
  FROM   ecoresstoragedimensiongroup ers

quicktab