Creating a Data Row Definition
Access the Revise Row Definitions form, enter a row definition name and description, and select Data from the Row Definition Type list.
- Row Definition Name
An alphanumeric string that defines the name of a row definition configuration. In addition to displaying this name in the forms of the Row Definitions program, the system uses this name in the data selection that you associate with the row if you set up data selection for the row.
Spaces and certain special characters are not allowed in the definition name. See Row Definition Names, Descriptions, and Titles.
- Row Definition Description
An alphanumeric string for the description of the row definition name.
Certain special characters are not allowed in the definition description. See Row Definition Names, Descriptions, and Titles.
- Row Definition Type
A value that identifies a row definition as a data row definition or an entered value row definition. Select one of these values from the Row Definition Type (09/GT) UDC table:
Data
Numeric Value
Subtotal
Text Value
Note: The list on the Revise Row Definitions form includes the descriptions from the 09/GT UDC table instead of the codes. You can view both the codes and the descriptions on the Work with Row Definitions form.- Row Definition Grouping
A check box that determines whether to use grouping elements for a data row-definition type. Select this check box if you want the system to summarize the account balances by each unique combination of the grouping elements selected. Clear the check box to create a data row definition without grouping. For data row definitions without grouping elements, the system calculates the total for the account balances based on the data selection set up for the row, data selection set up for the columns associated with the row in the statement definition, and the data selection in the version that you run.
You select or clear this check box only when creating or modifying a data row definition.
- Definition Status
A user-defined code (09/SM) that indicates whether a Financial Statement component definition is active, a work in progress, or inactive. This code serves as an informational message; no validations are applied. The list shows the descriptions of the codes in the 09/SM UDC table. Values are:
Work In Progress
Active
Inactive
When you add a Financial Statement component definition, the system completes this field with the default value of Work in Progress.
- Reverse Sign
An option that instructs the system to reverse the sign of the balances retrieved for the row definition. As an example, if this option is selected and the balances for the accounts are stored in the Account Balances table (F0902) as a negative number, then the system reverses the sign and displays the account balances as a positive number in the BI Publisher Layout Editor. Note that negative balances in the F0902 table include a minus sign (-) and balances without the minus sign are positive balances.
The system writes the value 1 to the OVFS Row Definition Setup (F09310) table to indicate that the sign will be reversed.
- Row Definition Title
The title that appears on the statement for a data row definition that does not have grouping elements.
This field appears only when you select Data in the Row Definition Type field and you clear the Row Definition Grouping check box; or when you select Numeric Value or Subtotal in the Row Definition Type field.
Certain special characters are not allowed in the definition title. See Row Definition Names, Descriptions, and Titles.
- Enable Level of Detail Rollup
A check box that instructs the system to sum the account balances at the level of detail that you specify in the version of the statement that you run. You must select this check box and then specify the level of detail in the version to have the system sum the account balances.
To enable this check box, you must include the account ID (AID) or the object account (OBJ) as a grouping element.
See Also: Enabling Level Of Detail (LOD) Rollup
- Include GLG AAI Item Number (include general ledger automatic accounting instruction number)
A check box that instructs the system to retrieve the GLG AAI item number associated with the accounts that are retrieved for the statement. Select the check box to retrieve the GLG AAIs item numbers. When you retrieve the AAIs, you can subtotal or format by the AAI groups in your statement.
To enable this check box, you must include the account ID (data item AID) or the object account (data item OBJ) as a grouping element.
See Also: Including GLG AAI Item Numbers
- Sequence Number
A system-assigned or user-assigned value used to order the grouping elements selected in the grid for a data row definition.
The sequence numbers exist to assist you in visualizing the order of the grouping elements; the system does not save the value that you enter and does not use it for sequencing in the statement.
- Grouping Element
A code to identify a data row definition grouping element. Grouping elements specify how financial data is grouped to provide account balance totals. For example, to include balance amount totals for business units and business unit category code 1, select MCU (Business Unit) as one grouping element and select RP01 (Business Unit Category Code 1) as a second grouping element. When you use the row definition in a financial statement, the system will provide a total of the accounts specified in the data selection for each unique combination of the grouping elements that you selected.
You can select as many as 10 grouping elements for each row definition.
- Return Description
A check box that instructs the system to retrieve the description of the items in the grouping, such as the object account description, business unit description, or category code description.