Setting Up a Column Definition for Non-JU Budget Unit Ledgers
To set up a column definition for non-JU budget unit ledgers:
Access the Project Status Inquiry Column Definitions form.
Form Name
Form ID
Navigation
Project Status Inquiry Column Definitions
W51X90B
Project Status Inquiry (G51411).
Column Definitions (P51X90).
Click Add on the Work with Project Status Inquiry Column Definitions form.
Enter values in these fields and select or clear the options:
- Column Name
Enter a name for the column that you create. This field is required.
- Description
Enter a description for the column that you create. This field is required.
- Column Heading
Enter the name that you want to use for a label for the column when the column name appears in the Work with Project Status Inquiry and Project Status Inquiry forms. This field is required.
- Column Type
Select Non-JA Budget Unit Ledgers.
- Budget Flag
Select an option to specify whether to include original or revised budgets.
Values are:
Original Budget
Revised Budget
- Totaling Method
Select an option to specify whether the system sums or averages the values in the column, or whether the system does not apply any totaling method. See Understanding Totaling Methods.
Values are:
Average - Exclude zero amounts. The system does not include zero amounts when it averages the values in the column.
Average - Include zero amounts. The system includes zero amounts when it averages the values in the column.
None. The system does not apply a totaling method to the column values.
Sum. The system adds the values in the column. This is the default value.
- Display Decimal Override
Enter the number of decimal places to override the default decimal value for the currency amount, unit, or unit price of the column. See Understanding Decimal Display Values.
- Scaling Multiplier
Enter the factor by which the system multiplies amounts or units in a column. The system multiplies the accumulated amounts by the multiplier factor before it displays the result on the Project Status Inquiry form.
For example, if you want to scale large numbers to thousands, enter.001. If you want percentages to appear as whole numbers, enter 100.
- Units Flag
The system selects this check box because the column type is for units.
- Header Units Flag
Select the Header Units Flag check box to use header units instead of account units.
Click OK.