Model: General Ledger - Specifications for Dimension Table: ACCOUNTING PROJECT

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

This model dimension represents accounting projects in Financials and is based on the IFS Cloud dimension DIM_ACCOUNTING_PROJECT. All models that refers to this dimension will have the attributes and hierarchies as described below.

Natural parent is company, i.e. each company has its on set of accounting projects.

Attributes

Attribute Description (where applicable)
CompanyRepresents the natural parent COMPANY
Accounting Project CodeRepresents the CODE of the dimension, i.e. accounting projects
Accounting ProjectBuilt as CODE + ' - ' + DESCRIPTION
Accounting Project DescRepresents the DESCRIPTION of an accounting project
Accounting Project GroupRepresents the PROJECT_GROUP_DESC, i.e. description of the project group
Accounting Project Group CodeAccounting project group code
Accounting Project StatusRepresents the PROJECT_STATUS_DESC, i.e. description of the project status
Accounting Project TypeRepresents the PROJECT_TYPE_DESC, i.e. the project type description
Accounting Project Type CodeAccounting project type code
Project Origin DescRepresents the origin of the project

USED BY MODEL(S)

Model Name
General Ledger

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
ACCOUNTING PROJECTDIM_ACCOUNTING_PROJECT_BIDIM_ACCOUNTING_PROJECTOn Line