On this page you will find the specifications regarding the Model: Cash Planning 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 | Represents the Accounting Project Code |
| Accounting Project Code | Represents the Accounting Project Name |
| Accounting Project Desc | Represents the description of the Accounting Project |
| Accounting Project Group | Represents the PROJECT_GROUP_DESC, i.e. description of the project group |
| 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 |
| Accounting Project Type Code | Accounting project type code |
| Company | Represents the Company Code of the company where the accounting project is defined |
| ID | Built as ACCOUNTING PROJECT GROUP CODE + '^' + ACCOUNTING PROJECT CODE |
| Project Origin Desc | Represents the origin of the project |
| 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_BI | DIM_ACCOUNTING_PROJECT_BI | DIM_ACCOUNTING_PROJECT | On Line |