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 MeasureDefault Buying Unit of Measure Code
DEFAULT_BUY_UNIT_MEAS
Purchase PartBuilt as CONTRACT + ' - ' + CODE + ' - ' + DESCRIPTION
Purchase Part CodeRepresents the DESCRIPTION of a purchase part.
Purchase Part Code DescriptionBuilt as CODE + ' - ' + DESCRIPTION
Purchase Part DescriptionBuilt as CODE + ' - ' + DESCRIPTION
Purchase Part Description - NumberBuilt as DESCRIPTION + ' - ' +( CODE)
SiteThe 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 PARTDIM_PURCHASE_PART_PQ_BIDIM_PURCHASE_PART_PQOn Line