Model: General Ledger - Specifications for Dimension Table: CODE M

On this page you will find the specifications regarding the Model: General Ledger and Dimension Table: CODE M.

Attributes

Attribute	Description (where applicable)
Code M	Defined as CODE + ' - ' + DESCRIPTION
Code M Code	Represents the CODE of the dimension, i.e. code part M value
Code M Descr	The DESCRIPTION of code part M value
Company	Represents the natural parent COMPANY
Company Code M	Defined as COMPANY + ' - ' + CODE + ' - ' + DESCRIPTION

Hierarchies

Hierarchy	Level
CodeMHy
	Company
	Code M

USED BY MODEL(S)

Model Name

General Ledger

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
CODE M	DIM_CODE_M_TM	DIM_CODE_M_BI	DIM_CODE_M	On Line