Journal Subsection

This subsection of the Header section provides journal detail information for the Scenario, Period, and Year specified.

Table 24 describes the attributes that are used in the Journal sub-section. These attributes are used for regular journals and recurring and standard templates.

Table 24. Journal Attribute Descriptions  

Attribute

Value

<label>

User-defined label for journal with up to 80 characters

<balancing attribute>

  • U = unbalanced

  • B = balanced in total

  • E = balanced by entity

<type>

  • R = regular journals

  • A = auto-reversing journals

  • V = auto-reversal journal

    Note:

    You cannot load system-generated auto reversals, but you can extract them.

<status>

  • W = Working

  • S = Submitted

  • A = Approved

  • P = Posted

  • R = Rejected

<value dimension>

  • [Contribution Adjs]

  • [Parent Adjs]

  • <Entity Curr Adjs>

  • <Parent Curr Adjs>

<journal group>

Optional: User-defined parameter with up to 20 characters

Note:

Groups need to be preloaded.

<security class>

Optional: Valid security class that is associated with the journal

Note:

If you do not assign a security class, the journal assumes the Default security class. Only users who have access rights to this security class can access the journal.

<singleparent.singleentity>

Optional: Valid parent/entity pair that is used by all the line items in the journal. When you specify a single parent/entity pair for the entire journal, the parent.entity attribute is not used.

<journal description>

Journal description, which can contain up to 255 characters. You can load descriptions with multiple lines, provided each line starts with this syntax: !DESC=

<parent.entity>

Valid member of the Entity dimension. The parent is required only for the Contribution Adjs, Parent Adjs, and ParentCurrency Adjs members of the Value dimension. This attribute is used only if the Single Parent.Single Entity attribute is not used.

<account>

Valid member of the Account dimension. For regular journals, this must be an input account and the account type must be REVENUE, EXPENSE, ASSET, LIABILITY, FLOW, or BALANCE.

<ICP>

Optional: Valid member of the Intercompany Partner dimension. This attribute is optional; however, you must at least specify ICP None.

<C1 - C4>

Optional: Valid members of the Custom1, Custom2, Custom3, and Custom4 dimensions

<amount type>

  • D = debit

  • C = credit

<amount>

Positive amount regardless if the amount type is debit or credit.

<line item description>

Optional: Description of the specific journal detail, which can contain up to 50 characters

This syntax specifies a regular journal:

!JOURNAL = <label>, <balancing attribute>, <type>, <status>, <value dimension>, <journal group>, <SecurityClass>, <SingleParent.SingleEntity>
!DESC=<journal description>
<parent.entity>, <account>, <ICP>, <C1>, <C2>, <C3>, <C4>, <amount type>, <amount>, <line item desc>