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)
DEFAULT_BUY_UNIT_MEAS
Def Buying Unit of Measure	Default Buying Unit of Measure Code
Purchase Part	Built as CONTRACT + ' - ' + CODE + ' - ' + DESCRIPTION
Purchase Part Code	Represents the CODE of the dimension, i.e. the puchase part code.
Purchase Part Code Description	Built as CODE + ' - ' + DESCRIPTION
Purchase Part Description	Represents the DESCRIPTION of a purchase part.
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

Procurement

Data source Information

The data source for this object is defined using IFS Developer Tool. The data source contains a number of transformations where the model reads data from the last step, i.e. the Data source view name (DW Source View Name).

Model Table	DW Source view (SQL Server)	BI Access View	Referenced Information Source	Recommended Access Type
PURCHASE PART	DIM_PURCHASE_PART_BI	DIM_PURCHASE_PART_BI	DIM_PURCHASE_PART	On Line