Group Accounts

The Group Accounts business object reflects the chart of accounts for an entire corporate group. In contrast, the Accounts business object reflects the chart of accounts for a legal entity. Each entity can have a separate, local chart of accounts. Accounts from the Accounts business object can be linked to group accounts from the Group Accounts business object. One local account cannot be linked to multiple group accounts.

You must define a relationship between an account and a group account in Financial Consolidation. Otherwise, data cannot be loaded.

We recommend that you also maintain a group chart of accounts for Budgeting & Planning.

This table shows the business applications in which the use of business data from the Group Accounts business object is required:

Business application Use of the Group Accounts business data
Budgeting & Planning Not used.
Note: In a future release, it will be possible to load data into Business Modeling.
Workforce Budgeting Not used.
Financial Consolidation Required.

This table shows the properties of the Group Accounts business object and uses these abbreviations:

  • BP: Budgeting & Planning
  • WB: Workforce Budgeting
  • CO: Financial Consolidation
  • R: Required
  • U: Used but optional
Field Description Type BP WB CO
ID Unique identifier of an account. nvarchar R
Name Caption that is displayed if no language-specific translation is provided. nvarchar R
ParentID Parent account ID.

If left blank, then Parent ID is by default assigned to the top-level All Accounts (TOTAL_ACCOUNT) value.

Caution: 
In multiple hierarchies, an account can be assigned to multiple parents. Do not assign an account to multiple parents in combination with weight 1 within the top-level All Accounts structure.
nvarchar U
Weight Used to control the roll-up into parents.

Typically set to 1 for the accounts in the chart of accounts.

Must be set to 0 for statistical accounts of S, T, M, and O types. This is to prevent an aggregation of values within the chart of accounts.

Note: Ensure that you prepare your table for import or upload accordingly.

See the "Weight in the Accounts business object" section.

float R
OrderPosition Position of an element in the resulting dimension. integer U
Type Account type that determines whether a debit or a credit has a positive or negative effect on an account.

All accounts must be assigned to an account type to be used in the Infor d/EPM business applications. This applies to finance balance sheets and profit and loss accounts.

Account types use a one-character code.

These types of accounts are available:

  • A: Asset
  • L: Liability
  • Q: Equity. Not used in Financial Consolidation.
  • R: Revenue
  • E: Expense
  • S: Statistical. No roll-up. For example, average price.
  • T: Statistical. For example, KPIs.
  • M: Statistical. No roll-up and no currency conversion. For example, headcount.
  • O: Statistical. No currency conversion. For example, sales volume

The A, L, Q, and R account types are always stored as positive in the database and the E account type is always stored as negative. Users can configure how to display and enter values in the Infor d/EPM applications with the global sign definition.

See "Global sign definition" in the Budgeting & Planning section.

Note: To prevent an aggregation of values within the chart of accounts, the Weight property must be set to 0 for all statistical account types.

See the "Weight in the Accounts business object" section.

nvarchar R
Method1 Used for the calculation of various scenarios.

Method1 uses the currency conversion with these exchange rate types:

  • N: No conversion
  • A: Average rate
  • HI: Historical rate intercompany
  • HS: Historical rate schedule
  • HD: Historical rate intercompany / schedule
  • F: Closing rate
  • H: Historical rate
  • WA: Weighted average rate
nvarchar R
Method2 Used for the calculation of various scenarios.

Method2 uses the currency conversion with these exchange rate types:

  • N: No conversion
  • A: Average rate
  • HI: Historical rate intercompany
  • HS: Historical rate schedule
  • HD: Historical rate intercompany / schedule
  • F: Closing rate
  • H: Historical rate
  • WA: Weighted average rate
nvarchar U
Method3 Used for the calculation of various scenarios.

Method3 uses the currency conversion with these exchange rate types:

  • N: No conversion
  • A: Average rate
  • HI: Historical rate intercompany
  • HS: Historical rate schedule
  • HD: Historical rate intercompany / schedule
  • F: Closing rate
  • H: Historical rate
  • WA: Weighted average rate
nvarchar U
Method4 Used for the calculation of various scenarios.

Method4 uses the currency conversion with these exchange rate types:

  • N: No conversion
  • A: Average rate
  • HI: Historical rate intercompany
  • HS: Historical rate schedule
  • HD: Historical rate intercompany / schedule
  • F: Closing rate
  • H: Historical rate
  • WA: Weighted average rate
nvarchar U
Method5 Used for the calculation of various scenarios.

Method5 uses the currency conversion with these exchange rate types:

  • N: No conversion
  • A: Average rate
  • HI: Historical rate intercompany
  • HS: Historical rate schedule
  • HD: Historical rate intercompany / schedule
  • F: Closing rate
  • H: Historical rate
  • WA: Weighted average rate
nvarchar U
FormatString Used to define different value formats in Self-Service and custom reports. For example, integer values such as headcount are defined in the #,##0 format.

The default format is #,##0.00.

nvarchar
Intercompany Represents internal relationships of an accounting entity or unit and enables the scheduling of the profit and loss, and balance sheet accounts at the intercompany level.

This field can contain one of these values:

  • 0: False. No internal relationships set. 0 is the default value.
  • 1: True. Internal relationships set.
bit U
Schedule Categorizes accounts into, for example, assets, depreciation, receivables, payables, or equity.

The schedule assignment determines in which detail view to use an account. For example, in the schedule with fixed asset movements.

Schedules can be assigned only to the balance sheet accounts of types A, L, and Q.

If a schedule is assigned, then detailed planning can be specified for an account as part of the budgeting and planning process.

These standard schedule codes are used to assign to the finance schedule details:

  • A: Assets
  • B: Receivables
  • C: Payables
  • D: Accruals
  • E: Equity
nvarchar U
LineDetail Currently not used in Infor d/EPM business applications. bit
EntityJournal Indicates if the account is displayed in the entity journal editor.

This property is relevant to the base and parent elements.

bit U
GroupJournal Indicates if the account is displayed in the group journal editor.

This property is relevant to the base and parent elements.

bit U
DataEntry Indicates if the account is displayed in the data entry report.

This property is relevant to the base and parent elements.

bit U
EntityReport Indicates if the account is displayed in entity reports.

This property is relevant to the base and parent elements.

bit U
GroupReport Indicates if it the account is displayed in group reports.

This property is relevant to the base and parent elements.

bit U
EquityBuy Detail equity buy.

Defines a schedule detail that presents goodwill changes. Goodwill changes result from acquisitions.

Note: You must post the results of an acquisition manually.

This property is used by specific customized processes.

nvarchar U
EquitySell Detail equity sell.

Defines a schedule detail that presents the sale result. The sale is done by adding the participation change request in Ownership Management in Financial Consolidation.

Note: You must post the results of a sale manually.

This property is used by specific customized processes.

nvarchar U
Equity Enables equity accounts that are displayed in Ownership Management in Financial Consolidation.

This property is relevant only for base elements.

bit U
ReserveBuy Detail Buy Reserve. Used by the participation changes feature.

Defines a schedule detail for a group account that receives information about unrealized reserves if an acquisition is performed. Unrealized reserves result from a GAAP related acquisition.

Note: You must post the results of an acquisition manually.

This property is used by specific customized processes.

nvarchar U
ReserveSell Detail Sell Reserve. Used by the participation changes feature.

Defines a schedule detail for a group account that receives information about unrealized reserves after an entity is sold.

Note: You must post the results of a sale manually.

This property is used by specific customized processes.

nvarchar U
Reserve Enables reserves accounts that are displayed in Ownership Management in Financial Consolidation.

This property is relevant only to the base elements.

bit U
Subgroup Mapping Relevant only if you use the Copy Subgroup Data function in Financial Consolidation. This function transfers data of a group to an entity that represents the whole group. Typically, this is done with a subgroup of the parent group. The entity to which the values are transferred belongs to the parent group and is set as a dummy entity.

If the parent group requires different accounts, then those accounts must be mapped to the parent group. You can select the consolidation group accounts in Financial Consolidation.

This property is relevant only to the base elements.

nvarchar U
NonControllingInterest Non Controlling Interests accounts are assigned to relevant equity accounts. The share that belongs to third parties is then posted through the minority rule from the equity account to the Non Controlling Interests account.

This property is relevant only to the base elements.

nvarchar U
Segment1 Provides account details such as a company, region, or product.

If set, detailed planning must be completed for an account as part of budgeting and planning process.

This field can contain one of these values:

  • 0: False, the Segments 1 business object is not used. 0 is the default value.
  • 1: True, the Segments 1 business object is used.

Segmentation is hierarchical and only one of these options is possible:

  • Segment1 is activated.
  • Segment1 and Segment2 are activated.
  • Segment1, Segment2, and Segment3 are activated.
bit U
Segment2 Provides account details such as a company, region, or product.

If set, detailed planning must be completed for an account as part of the budgeting and planning process.

This field can contain one of these values:

  • 0: False, the Segments 2 business object is not used. 0 is the default value.
  • 1: True, the Segments 2 business object is used.

Segmentation is hierarchical and only one of these options is possible:

  • Segment1 is activated
  • Segment1 and Segment2 are activated
  • Segment1, Segment2, and Segment3 are activated.
bit U
Segment3 Provides account details such as a company, region, or product.

If set, detailed planning must be completed for an account as part of the budgeting and planning process.

This field can contain one of these values:

  • 0: False, the Segments 3 business object is not used. 0 is the default value.
  • 1: True, the Segments 3 business object is used.

Segmentation is hierarchical and only one of these options is possible:

  • Segment1 is activated
  • Segment1 and Segment2 are activated
  • Segment1, Segment2, and Segment3 are activated.
bit U
LangEN Name translated into English. nvarchar U
LangDE Name translated into German. nvarchar U
LangFR Name translated into French. nvarchar U
LangES Name translated into Spanish. nvarchar U
LangJA Name translated into Japanese. nvarchar U
LangPT_BR Name translated into Portuguese (Brazilian). nvarchar U
LangRU Name translated into Russian. nvarchar U
LangIT Name translated into Italian. nvarchar U
LangZH_CHS Name translated into Chinese (Simplified). nvarchar U
LangCS Name translated into Czech. nvarchar U
LangNL Name translated into Dutch. nvarchar U
LangDA Name translated into Danish. nvarchar U
LangSV Name translated into Swedish. nvarchar U
LangNO Name translated into Norwegian. nvarchar U
LangPL Name translated into Polish. nvarchar U
LangTH Name translated into Thai. nvarchar U
LangFI Name translated into Finnish. nvarchar U
LangKO Name translated into Korean. nvarchar U
LangMS Name translated into Malaysian. nvarchar U
LangFR_CA Name translated into French (Canadian). nvarchar U
LangZH_TW Name translated into Chinese (Traditional). nvarchar U
LangID Name translated into Indonesian. nvarchar U
LangVI Name translated into Vietnamese. nvarchar U