Defining Accounts

You define accounts with the attributes described in Table 9.

Table 9. Account Member Attributes  

Attribute

Description

AccountType

(Required) One of these values:

  • ASSET—Store values that represent the assets of a company

  • LIABILITY—Store point-in-time balances that represent the liabilities of a company

  • REVENUE—Store periodic and year-to-date values that increase net worth if the value is positive

    Note:

    In Financial Management releases prior to 4.1, this account type was called Income.

  • EXPENSE—Store periodic and year-to-date values that decrease net worth if the value is positive

  • FLOW—Store periodic and year-to-date values

  • BALANCE— Store unsigned values that relate to a particular point in time

  • BALANCERECURRING—Store unsigned values that relate to a particular point in time and that re-occur in future periods

  • CURRENCYRATE—Store currency rate information

  • GROUPLABEL—Use the account for grouping purposes

  • DYNAMIC—Indicates that the account value is calculated dynamically from the data that you are viewing

See Account Type Behavior.

CalcAttribute

Description of the calculations in the rules file that are done for this account

This information is displayed as part of cell info in data forms and data grids. It can contain up to 80 characters including spaces.

Custom1TopMember, Custom2TopMember, Custom3TopMember, Custom4TopMember

Which top member in the hierarchy of a Custom dimension is valid for the account

Only the specified member, including all descendants, is valid for the account.

DefaultParent

The default parent for the account

Description

The account description

The description can contain up to 80 characters, including spaces, and cannot use an ampersand (&) or slash (\).

EnableCustom1Aggr, EnableCustom2Aggr, EnableCustom3Aggr, EnableCustom4Aggr

Whether aggregation is enabled for intersections of the Account and Custom dimensions

This attribute is used for special totals, not summing. Specify Y if the account can aggregate with Custom dimensions or N if it cannot.

EnableDataAudit

Whether the account can be audited

Specify Y to enable account auditing or N to disable auditing. The default is N. This attribute, when applied to an account or scenario, determines what can be audited.

ICPTopMember

The ICP top member for the account

The specified member, including all descendants, is valid for the account.

IsCalculated

Whether the account is calculated

Only base-level accounts can be calculated. If a base-level account is calculated, you cannot manually enter values. Specify Y if the account is to be calculated; otherwise, specify N.

IsConsolidated

Whether the account is consolidated to a parent account. If the account is not consolidated, it is ignored during consolidation. Specify Y if the account is to be consolidated to a parent account and N if the account is not to be consolidated to a parent account.

IsICP

Specifies whether the account is an intercompany account. If the account is an intercompany account, you must also specify a plug account. Specify one of these values:

  • Y if ICP transactions, including self-ICP transactions, are enabled for the account

  • N if ICP transactions are not enabled for the account

  • R if ICP transactions are enabled for the account, but the account cannot have ICP transactions with itself

Member

Specifies the name for the account. This attribute is required. The name must be unique. It can contain up to 80 characters, including spaces, but cannot start with a space.

Note:

Account names cannot contain spaces if you are using an Oracle database.

Do not use these characters in an account name:

  • Period ( . )

  • Plus sign ( + )

  • Minus sign ( - )

  • Asterisk ( * )

  • Slash mark ( / )

  • Number sign ( # )

  • Comma ( , )

  • Semicolon ( ; )

  • At sign ( @ )

  • Double quote ( “ )

  • Curly brackets ( { } )

NumDecimalPlaces

Specifies the number of digits to be displayed to the right of the decimal point for account values. This attribute is required. Specify a value from 0 to 9 for this attribute.

PlugAcct

Specifies the account name used for identifying discrepancies in intercompany transactions. The PlugAcct attribute is required when the IsICP attribute for the account is selected.

SecurityClass

Specifies the security class that defines the users who can access the account data. Security class names can contain up to 80 characters. Security access applies only to account data.

Submission Group

Specifies the submission group. The value can be a number from 0 to 99.

The default is blank. A blank value defaults to the value of 1.

If you set the submission group to zero (0), the account is not included in the review process.

UserDefined1, UserDefined2, UserDefined3

Stores custom information for the account. You can enter a maximum of 80 characters. The UserDefined1, UserDefined2, and UserDefined3 functions retrieve the text stored in this attribute.

UsesLineItems

Specifies whether an account can have line items. Specify Y if the account uses line items and N if the account does not use line items.

Caution!

If you change this attribute after line-item detail is entered, the stored line-item detail may no longer be valid for the account. These behaviors occur:

  • If the account accepted line items and now it cannot, the line-item detail stored in the database is no longer valid. Only the total is displayed.

  • If the account did not accept line items and now it can, there is a total amount but no corresponding line-item detail information for the account. You can extract the total and then load it as line-item detail data so that the total matches the line-item detail information.

XBRL Tags

Specifies XBRL tags for the account. You can enter a maximum of 225 characters.