Model: Maintenance - Specifications for Dimension Table: ACCOUNT

On this page you will find the specifications regarding the Model: Maintenance and Dimension Table: ACCOUNT.

This model dimension represents financial accounts and is based on the IFS Cloud dimension DIM_ACCOUNT. Most models that refer to this dimension will have the attributes and hierarchies as described below. One exception is the General Ledger model that also contains structure information related to:

Attributes

Attribute Description (where applicable)
CompanyRepresents the natural parent COMPANY
Account CodeRepresents the CODE of the dimension, i.e. account
Account DescRepresents the description of the Account
Account Group CodeRepresents the account group code
Account Group DescRepresents the account group description
Account Type CodeRepresents the account type code
Account Type DescRepresents the account type description
Group AccountRepresents the Group Account
Account GroupRepresents COMPANY + ' - ' + ACCOUNT_GROUP + ' - ' + ACCOUNT_GROUP_DESC
Account TypeRepresents the COMPANY + ' - ' + ACCOUT_TYPE + ' - ' + ACCOUNT_TYPE_DESC
AccountBuilt as CODE + ' - ' + DESCRIPTION
Company - AccountBuilt as COMPANY + ' - ' CODE + ' - ' + DESCRIPTION
Statement Type CodeRepresents Statement Type Code
Statement TypeRepresents Statement Type Description

Hierarchies

Hierarchy Level
AccountHy
Company
Account
AccountGroupHy
Company
Account Group
Account
AccountTypeHy
Company
Account Type
Account

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
ACCOUNTDIM_ACCOUNT_BIDIM_ACCOUNTOn Line