List of Built-in Properties

Designer Administrator
This manual is in pilot operation.

(1) Built-in Properties Common to All Dimensions

Property Description Value List

Member Type
#MEMBER_TYPE

Classifies members from the perspective of management responsibility.

For more details, see "Member Types and Maintenance Responsibility."

System Reserved
(RESERVED)
Template
(TEMPLATE)
User-Defined (UDEF)

Leaf Classification
#LEAF

Indicates whether a member is a leaf member (cannot have children). Ledger cells associated with non-leaf members are not enterable, regardless of whether those members actually have child members. ⚠ There are exceptions to the above. If the account dimension’s data type is other than numeric types (balance, flow), cells associated with non-leaf members are not restricted from input.

Leaf (TRUE)
Non-Leaf (FALSE)

Active Indicator
#ACTIVE

Indicates whether a member is to be used for input.
Setting it to "Inactive" makes the ledger cells tied to that member unenterable.

Generally, cells tied to aggregate members are unenterable regardless of the active indicator, but it’s possible to allow numerical editing at the aggregate level for each scenario. In such cases, the active indicator can specify whether input is allowed or not. Please see "Input and Aggregation of Ledger Cell Values."

Active (TRUE)
Inactive (FALSE)

(2) Dimension-Specific Built-in Properties

1. Relative Period Dimension

Property Description Value List

Period Unit
PERIOD_UNIT

Indicates the "period unit" to which each relative period belongs.

Automatically generated from the "Period Unit" in the "Period Table"
Y,H,Q,M, etc.

Sequential Number Within Period Unit
#SEQ_IN_PERIOD_UNIT

Indicates the sequence number of each relative period within its "period unit" starting from the beginning.
The number of digits depends on the number of the lowest period units (e.g., 2 digits if there are 12 lowest period units).

Same as above
01,02,03…

2. Account Dimension

Property Description Value List

Data Type
#DATA_TYPE

Specifies the type of data each ledger cell holds.
For more details, please see "Data Types of Ledger Cells."

None (NONE)
Flow Value (FLOW)
Balance Value (BAL)
Text Value (TEXT)
Boolean Value (BOOL)
Enumeration (ENUM)

Debit/Credit Type
#DRCR

(Used only if data type = balance value or flow value. Mandatory)

Specifies whether the account is a debit or credit account.
For more details, please see "Subtraction Calculation with Accounts."

Debit (DR)
Credit (CR)

Applicable Change Account Table
#CHAGTAB

(Used only if data type = balance value. Optional) Specifies the type of change detail table to apply to the balance account.
For more details, please see "Managing Change Data - Change Account Table."

(Designers can set labels identifying the change account tables, but the labels must start with #CT_)

Value List Definition
Dimension
#VALUE_DIMENSION

(Used only if data type = enumeration. Mandatory)

Specifies from which dimension’s member list
the value list is to be created.
For more details, please see "Value Lists of Enumerations."

(List of all dimensions)

Value List Definition
Member List
#VALUE_MEMBER_LIST

(Used only if data type = enumeration. Mandatory)

Specifies from which member list in the "Value List Definition Dimension"
the value list is to be created.
For more details, please see "Value Lists of Enumerations."

(List of member lists in the "Value List Definition Dimension")

3. Change Account Dimension

Property Description Value List

Change Account Type
#CHANGE_TYPE

Classifies the type of change account.
For system-reserved members, the value becomes the label of the change account type with the leading # removed.
For all other members, the change account type will always be "Current Change Amount (DTL)."

(Abbreviated)

Sign
#SIGN

Specifies whether the sign for displaying the change account will be the same as the balance or opposite.
For example, for a change account representing increase, setting the sign as "Balance or Increase" displays the increase amount positively, and setting it as "Decrease" displays the decrease amount positively.

Balance or Increase (INC)
Decrease (DEC)

(Change Account Table Property)
(#CT_ starting labels)

The property that specifies whether a change account belongs to each change account table.
As many change account table properties are automatically generated as there are change account tables registered in the Account Dimension.
For more details, please see "Managing Change Data - Change Account Table."

Target (TRUE)
Not Target (FALSE)

4. General Dimension

Property Description Value List

Data Type
#DATA_TYPE
(fusion_place >= 12.2)

Specifies the type of data each ledger cell holds.
For more details, please see "Data Types of Ledger Cells."

Dependent on Account/Note Item (#ACCOUNT)
None (NONE)

5. Note Item Dimension

Property Description Value List

Data Type
#DATA_TYPE

Specifies the type of data each ledger cell holds.
For more details, please see "Data Types of Ledger Cells."

Dependent on Account (#ACCOUNT)
None (NONE)
Text Value (TEXT)
Boolean Value (BOOL)
Enumeration (ENUM)

Value List Definition
Dimension
#VALUE_DIMENSION

(Used only if data type = enumeration. Mandatory)

Specifies from which dimension’s member list
the value list is to be created.
For more details, please see "Value Lists of Enumerations."

(List of all dimensions)

Value List Definition
Member List
#VALUE_MEMBER_LIST

(Used only if data type = enumeration. Mandatory)

Specifies from which member list in the "Value List Definition Dimension"
the value list is to be created.
For more details, please see "Value Lists of Enumerations."

(List of member lists in the "Value List Definition Dimension")