Model: Procurement - Specifications for Dimension Table: PURCHASE PART

On this page you will find the specifications regarding the Model: Procurement and Dimension Table: PURCHASE PART.

This model dimension represents condition codes and is based on the IFS Cloud dimension DIM_PURCHASE_PART. All models that refer to this dimension will have the attributes and hierarchies as described below.

Attributes

Attribute Description (where applicable)
Def Buying Unit of Measure Default Buying Unit of Measure Code
DEFAULT_BUY_UNIT_MEAS
Purchase Part Built as CONTRACT + ' - ' + CODE + ' - ' + DESCRIPTION
Purchase Part Code Represents the DESCRIPTION of a purchase part.
Purchase Part Code Description Built as CODE + ' - ' + DESCRIPTION
Purchase Part Description Built as CODE + ' - ' + DESCRIPTION
Purchase Part Description - Number Built as DESCRIPTION + ' - ' +( CODE)
Site The Site ID to which the purchase part is delivered

Hierarchies

Hierarchy Level
PurchPartHy
Site
Purchase Part

USED BY MODEL(S)

Model Name

Data source Information

The data source for this object is defined using IFS Developer Tool. Further Transformations are done using Power BI.

Additional information can be found in the online documentation of Information Sources.

Model Table BI Access View Referenced Information Source Recommended Access Type
PURCHASE PART DIM_PURCHASE_PART_PQ_BI DIM_PURCHASE_PART_PQ On Line