Item Tracking Dimensions

Submitted by Nathan Clouse on 09/12/15.

A view that shows all product dimensions and the various elements that compose them. Using Contoso data, you will see that Product DImension Group "BatchSeria" is batch and serial enabled.

AX Version:

AX 2012

Module:

Product Information Management

CREATE VIEW [dbo].[vw_pimTrackingDimensions] 
AS 
  SELECT *, 
         'InventBatchEnabled' = (SELECT isactive 
                                 FROM 
         ecorestrackingdimensiongroupfldsetup fld 
                                 WHERE 
         fld.trackingdimensiongroup = ers.recid 
         AND fld.dimensionfieldid = 2 
         AND fld.partition = ers.partition), 
         'InventSerialEnabled' = (SELECT isactive 
                                  FROM 
         ecorestrackingdimensiongroupfldsetup fld 
                                  WHERE 
         fld.trackingdimensiongroup = ers.recid 
         AND fld.dimensionfieldid = 5 
         AND fld.partition = ers.partition), 
         'InventGTDEnabled' = 
         (SELECT isactive 
          FROM 
         ecorestrackingdimensiongroupfldsetup fld 
                               WHERE 
         fld.trackingdimensiongroup = 
         ers.recid 
         AND 
         fld.dimensionfieldid = 8000 
                                      AND fld.partition = 
                                          ers.partition), 
         'InventProfileEnabled' = (SELECT isactive 
                                   FROM 
         ecorestrackingdimensiongroupfldsetup fld 
                                   WHERE 
         fld.trackingdimensiongroup = ers.recid 
         AND fld.dimensionfieldid = 8001 
         AND fld.partition = ers.partition), 
         'InventOwnerEnabled' = (SELECT isactive 
                                 FROM 
         ecorestrackingdimensiongroupfldsetup fld 
                                 WHERE 
         fld.trackingdimensiongroup = ers.recid 
         AND fld.dimensionfieldid = 8002 
         AND fld.partition = ers.partition) 
  FROM   ecorestrackingdimensiongroup ers

quicktab