Infinium Build a Template for GXL

Click the drop-down list, and select the balance type. Valid values are:

• M (Monetary)
• S (Statistical)
• D (Debit Balances)
• C (Credit Balances)
• 1 (Numeric User Field 1)
• 2 (Numeric User Field 2)

Specify whether to retrieve actual or budget data. Valid values are: ACTUALS, or the name of the budget.

Click the drop-down list, and select the reporting year.

Click the drop-down list and select the time range for which to retrieve data. Valid formats are:

• PER
• QTR
• DQTR
• YTD
• LTD
• RANGE

Click the drop-down list, and select the corresponding period, quarter number, or range of periods (for example, 1.5 for periods 1 through 5) for the specified format.

Specify a valid currency code, or leave blank if retrieving statistical balances. Enter * to retrieve all currencies.

If applicable, specify the database library from which to retrieve the data. The library entered overrides the default library in Application Configurator, or the library specified during the sign in process.

If selected, adds an AND/OR user list comparison to the account string criteria.

If Append is selected, specify the appropriate user list criteria operand. Valid values are: AND (the account must meet both the account string and user list criteria), or OR (the account must meet either the account string or user list criteria).

If Append is selected, specify the user list to be used by the formula.

Note: The user list must be established in the segment list file (see Create or Maintain Segment Lists for more information). The syntax used for entering the user list is: @nnnn (where nnnn is the user list name).

Click the drop-down list, and select whether to toggle the account segments to user fields. Valid values are:

• NA (use account segments)
• Y (use user fields)
• N (use account segments)

If not specified, NA is assumed.