Model 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:

Balance Sheet Structure
Income Statement Structure

Natural parent is company, i.e. each company has its on set of accounts.

Attributes

Attribute	Description (where applicable)
Account	Built as CODE + ' - ' + DESCRIPTION
Account Code	Represents the CODE of the dimension, i.e. account
Account Desc	Represents the description of the Account
Account Group	Represents COMPANY + ' - ' + ACCOUNT_GROUP + ' - ' + ACCOUNT_GROUP_DESC
Account Group Code	Represents the account group code
Account Group Desc	Represents the account group description
Account Type	Represents the COMPANY + ' - ' + ACCOUT_TYPE + ' - ' + ACCOUNT_TYPE_DESC
Account Type Code	Represents the account type code
Account Type Desc	Represents the account type description
Company	Represents the natural parent COMPANY
Company - Account	Built as COMPANY + ' - ' CODE + ' - ' + DESCRIPTION
Group Account	Represents the Group Account
Statement Type	Represents Statement Type Description
Statement Type Code	Represents 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

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
ACCOUNT	DIM_ACCOUNT_TM	DIM_ACCOUNT_BI	DIM_ACCOUNT	On Line