BS Account Dimension

image_pdfimage_print

Return to Balance Sheet Model Overview

The version elements can be configured through their attributes:

Attribute

Description

Name

Readable name of the account. Localized translations can be provided. This attribute is visible in the report. There is no hard-coded behavior implemented on this name. (string)

ID_Name

Technical element name of the article as well as the readable name. If localized translations are provided Name attribute, this attribute will also become localized. This attribute is visible in the report. There is no hard-coded behavior implemented on this name. (string, calculated)

Description

Long text description of the account. This attribute can contain a definition of the amounts booked to the account or instructions for the planners. Localized translations can be provided. (string)

Type

Valid values are Assets and Liabilities (which represents equity and lliabilities).

Conversion Type

Defines which exchange rate is used curing currency conversion. Valid values are base elements of the Conversion Type dimension, e.g. Average, Month End, Month Start, and ~. Balance sheet accounts usually use currency conversion with month end rates. Use ~ to suppress the currency conversion, e.g. for statistical figures like number of heads. (string)

See Fact Cube Using Currency Conversion and Configuration of Conversion Types

Intercompany

Indicates whether the account contains intercompany relations. Valid values are:

0: The account does not have intercompany relations

1: The account has intercompany relations.

This flag is currently not used by the Balance Sheet model. Custom reports or interfaces may take advantage of this attribute. (numeric)

Format

Number format for this account to be driven by the database. (string)

PCalculation

Indicates which rule is implemented on the element; only for planning versions.

PCalculationDependencies

Indicates which cube is the source of transferred data; only for planning versions.

ACalculation

Indicates which rule is implemented on element for Actual version.

ACalculationDependencies

Indicates which cube is source of transferred data; only for Actual version.

DCS Check Account

Used to refer to another BS Account to be checked for the condition specified with the DCS Condition attribute (see below). If DCS Condition is not set, this attribute should be empty, too.

DCS Condition

Used to specify a calculated debit-credit-shift account. Valid values are empty, >=0, and <0.

DCS Data Account

Used to refer to another base-level BS Account to define the value of the debit-credit-shift account if the DCS Condition is met. If DCS Condition is not set, this attribute should be empty, too.
image_pdfimage_print
Was this post helpful?
NoYes (+1 rating, 1 votes)
Loading...