Model: General Ledger - Specifications for Dimension Table: ACCOUNTING PERIOD

On this page you will find the specifications regarding the Model: General Ledger and Dimension Table: ACCOUNTING PERIOD.

This model dimension represents the accounting periods in Fiancials is based on the IFS Cloud dimension DIM_ACCOUNTING_PERIOD. All models that refer 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 periods.

Attributes

Attribute Description (where applicable)
Accounting YearRepresents the year part, i.e. ACCOUNTING_YEAR
CompanyRepresents the natural parent COMPANY
Accounting Year PeriodRepresents the CODE of the dimension, i.e. i.e. 'YYYYPP' where YYYY is the accounting year and PP is the accounting period.
Accounting Period NoRepresents the period part, i.e. ACCOUNTING_PERIOD
Acc Period End DateRepresents the end date (END_DATE) of an accounting period
Acc Period Start DateRepresents the start date (START_DATE) of an accountig period.
Accounting Period DescRepresents the DESCRIPTION of an accounting period.
Accounting Period TypeRepresents the description of the period type (PERIOD_TYPE_DESC)

Hierarchies

Hierarchy Level
Accounting Year Period No
Accounting Year
Accounting Period No
Accounting Year Period Desc
Accounting Year
Accounting Period Desc

USED BY MODEL(S)

Model Name
CRM
Employee Analysis
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 PERIODDIM_ACCOUNTING_PERIOD_BIDIM_ACCOUNTING_PERIODOn Line