Model Table ACCOUNT

This model dimension represents the financial voucher related account and is based on the IFS Cloud dimension DIM_ACCOUNT. 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 account values.

Attributes

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

Hierarchies

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

USED BY MODEL(S)

Model Name
Procurement

Data source Information

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