Understanding Column Layouts
After you set up column definitions, you use the Project Status Inquiry Column Layout program (P51X91) to group column definitions together to form a column layout. After you set up column layouts, you can use them to instruct the system what to include in your data selection. The system saves the column layouts to the Column Layout table (F51X91).
You can select up to 40 column definitions to include in a column layout, and you can use each column definition in more than one column layout. The order in which you select the columns determines the order in which the columns appear in the Summary and Account Details subform of the Project Status Inquiry form.
The order in which you place the columns in the Project Status Inquiry Column Layout program also determines the order of the columns in the Chart section in the Project Status Inquiry program. If you want to change which columns appear in the chart, you can use the check boxes next to the column names on the Selection tab of the Chart section to select the columns to display on the Display tab. You cannot change the order of the columns in the Display and Selection tabs of the Chart section. Carefully consider how you want charts to appear in the Project Status Inquiry form before you set up your column layouts. Visual alert columns do not appear in the Charts section.
The Column 01–Column 40 fields include a small orange square in the upper left corner. After you select a column to include in the layout, you can click the orange square to view additional column information. See Column Information Hover Forms.
You can set a processing option in the Work with Project Status Inquiry program (P51X0200) to suppress billing amount information to prevent unauthorized users from viewing billing amounts. If you set up a column layout that includes billing lines and assign that column layout to a version that you assign to an unauthorized user, the user receives an error message on the Work with Project Status Inquiry form. Likewise, if a user is assigned to use a version of the Work with Project Status Inquiry program for which access to billing lines is restricted, the user cannot manually add columns for billing lines in the Work with Project Status Inquiry program. If a user receives an error message that billing lines are not enabled, the user must clear the billing columns from the Work with Project Status Inquiry program before continuing the process.
The Submit Project Status Inquiry View program (R51X0300) requires that you specify a column layout in the processing options for the program. Before you use the Submit Project Status Inquiry View program to generate a saved collection of job data, you must set up a column layout to use in the Project Status Inquiry Column Layout program.
See Setting Processing Options for Submit Project Status Inquiry View (R51X0300).