Model: CRM - Specifications for Dimension Table: RETURN MATERIAL LINE

On this page you will find the specifications regarding the Model: CRM and Dimension Table: RETURN MATERIAL LINE.

This model fact represents return material charges in Customer Order and is based on the IFS Cloud fact FACT_RETURN_MATERIAL_LINE. All models that refer to this table will have the attributes and hierarchies as described below

Attributes

Attribute Description (where applicable)
Return Material Line The Return Material Authorization line.
Return Material Line No The identity number of the Return Material Authorization line.
Return Material Line State The status of the Return Material Authorization line.
Return Material Line State Descr The status of the Return Material Authorization line.
Return Material No The identity number of the Return Material Authorization.

USED BY MODEL(S)

Model Name
CRM
Sales

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
RETURN MATERIAL LINE FACT_RETURN_MATERIAL_LINE_TM FACT_RETURN_MATERIAL_LINE FACT_RETURN_MATERIAL_LINE Data Mart