On this page you will find the specifications regarding the Model: General Ledger 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:
Natural parent is company, i.e. each company has its on set of accounts.
| Attribute | Description (where applicable) |
| 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 - Account | Built as COMPANY + ' - ' CODE + ' - ' + DESCRIPTION |
| Statement Type | Represents Statement Type Description |
| Statement Type Code | Represents Statement Type Code |
| Logical Account Type Code | Represents the Logical Account Type Code |
| Logical Account Type | Represents the Logical Account Type |
| Group Account | Represents the Group Account |
| Is Structure ID | Income Statement structure |
| Is Value Description | Name of a node or a leaf in the Income Statement structure |
| Company | Represents the natural parent COMPANY |
| Account Code | Represents the CODE of the dimension, i.e. account |
| Account | Built as CODE + ' - ' + DESCRIPTION |
| Bs Structure ID | Identity of the Balance Sheet structure |
| Bs Value Description | Name of a node or a leaf in the Balance Sheet structure |
| Hierarchy | Level |
| BsHy | |
| BSL01 | |
| BSL02 | |
| BSL03 | |
| BSL04 | |
| BSL05 | |
| BSL06 | |
| BSL07 | |
| BSL08 | |
| BSL09 | |
| BSL10 | |
| IsHy | |
| ISL01 | |
| ISL02 | |
| ISL03 | |
| ISL04 | |
| ISL05 | |
| ISL06 | |
| ISL07 | |
| ISL08 | |
| ISL09 | |
| ISL10 |
| Model Name |
| General Ledger |
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 |
| ACCOUNT | DIM_ACC_STRUCT_ACCOUNT_PQ_BI | DIM_ACC_STRUCT_ACCOUNT_PQ | On Line |