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 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
NotesText
Completion DateReady date
Valid FromValid from date
Valid UntilValid to date
Category 1 IDCategory 1 ID
Category 2 IDCategory 2 ID
Category 1 DescCategory 1 Description
Category 2 DescCategory 2 Description
Financial Project ManagerFinancial Project Manager
POC MethodPercentage of completion Method
Project Program IDProject Program ID
Accounting Project Group DescAccounting Project Group Description
Contribution MarginContribution Margin
Project OriginProject Origin Description
Revision AccountingRevision Accounting Description
Project Program DescProject Program Description
Revenue Recog MethodRevenue Recognition Method
Project Progress MethodProject 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 PROJECTDIM_ACCOUNTING_PROJECT_BIDIM_ACCOUNTING_PROJECTOn Line