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.
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 |
Model Name |
General Ledger |
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 |