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)
Company Represents the natural parent COMPANY
Accounting Project Code Represents the CODE of the dimension, i.e. accounting projects
Accounting Project Built as CODE + ' - ' + DESCRIPTION
Accounting Project Desc Represents the DESCRIPTION of an accounting project
Accounting Project Group Code Accounting project group code
Accounting Project Status Represents the PROJECT_STATUS_DESC, i.e. description of the project status
Accounting Project Type Represents the PROJECT_TYPE_DESC, i.e. the project type description
Notes Text
Completion Date Ready date
Valid From Valid from date
Valid Until Valid to date
Category 1 ID Category 1 ID
Category 2 ID Category 2 ID
Category 1 Desc Category 1 Description
Category 2 Desc Category 2 Description
Financial Project Manager Financial Project Manager
POC Method Percentage of completion Method
Project Program ID Project Program ID
Accounting Project Group Desc Accounting Project Group Description
Contribution Margin Contribution Margin
Project Origin Project Origin Description
Revision Accounting Revision Accounting Description
Project Program Desc Project Program Description
Revenue Recog Method Revenue Recognition Method
Project Progress Method Project Progress Method Description

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 PROJECT DIM_ACCOUNTING_PROJECT_BI DIM_ACCOUNTING_PROJECT On Line