On this page you will find the specifications regarding the Model: Revenue Recognition 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) |
| Accounting Project | Accounting Project Code and Description |
| Accounting Project Code | Accounting Project Code |
| Accounting Project Desc | Accounting Project Description |
| Accounting Project Group Code | Accounting Project Group Code |
| Accounting Project Group Desc | Accounting Project Group Description |
| Accounting Project Status | Accounting Project Status |
| Accounting Project Type | Accounting Project Type Description |
| Category 1 Desc | Category 1 Description |
| Category 1 ID | Category 1 ID |
| Category 2 Desc | Category 2 Description |
| Category 2 ID | Category 2 ID |
| Company | Company Code |
| Completion Date | Ready date |
| Contribution Margin | Contribution Margin |
| Notes | Text |
| POC Method | Percentage of completion Method |
| Project Origin | Project Origin Description |
| Project Program Desc | Project Program Description |
| Project Program ID | Project Program ID |
| Project Progress Method | Project Progress Method |
| Revenue Recog Method | Revenue Recognition Method |
| Revision Accounting | Revision Accounting |
| Valid From | Valid from date |
| Valid Until | Valid to date |
| Model Name |
| Cash Planning |
| General Ledger |
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 |
| ACCOUNTING PROJECT | DIM_ACCOUNTING_PROJECT_TM | DIM_ACCOUNTING_PROJECT_BI | DIM_ACCOUNTING_PROJECT | On Line |