WILLIAMS GENERAL LEDGER 2/27/95
DSP01 ANALYSIS REPORT SPEC FILE MAINTENANCE CELL SPEC
REVIEW
Report WKCAP
Page 1
Line No 9
Column 6
Edit Code L
Underscore L
Dollar Sign L
Print Flg Y
Oper Factor Oper Factor Oper Factor Oper Factor Oper Factor Oper Factor
ACTTQ
F3=Exit F5=Previous Rec F6=Next Rec F7=Cell Defn
F8=Extract Defn F10=Search F19=Mass Maint F24=More Keys
This screen is used to enter or display the cell specification records used to prepare Analysis Reports. These records specify how the amounts printed in each cell on a report are calculated. Extracted data from the Account Master File and Budget Master File is manipulated based on these specifications and then printed on the Analysis Reports.
REPORT
Required. This identifies the name of the report that will contain the extracted record(s). The name of the report must exist on the Analysis Report Title File and Reference File category 130.
PAGE
Required. Identifies the page of the report on which this cell specification will be printed. Must be a valid value between 1 and 5.
LINE NUMBER
Required. Identifies the line number where the cell specification will be placed. Must be a valid number between 1 and 50.
COLUMN
Required. Identifies the column where the cell specification will be placed. Valid values depend on whether the report width will be 132 characters or 198 characters (as specified on Reference File category 025.
For 132-character reports:
1 - 6: Columns that are printed
7 - 12: Columns used for calculations only
For 198-character reports:
1 - 8 : Columns that are printed
9 - 12: Columns used for calculations only
EDIT CODE
Required. Specifies special print characters for use with dollar amounts. Valid edit codes are:
Y - Print CR for credit amounts;
N - Print DR for debit amounts;
L - Default to the value on the line description record.
This field will default to L if no value is entered.
UNDERSCORE
Required. This field determines if each value printed should be underlined or not. Valid values are:
Y - Underscore all amounts;
N - Do not underscore all amounts;
L - Default to the value on the line description record.
This field will default to L if no value is entered.
DOLLAR SIGN
Required. This field determines if a dollar sign should precede each amount on the specified line. Valid values are:
Y - Print all amounts with a dollar sign;
N - Do not print all amounts with a dollar sign;
L - Default to the value on the line description record.
This field will default to L if no value is entered.
PRINT FLAG
Required. This field determines if the cell value will be printed on the report. Valid values are:
Y - Print cell value on the report;
N - Do not print the cell value on the report.
This field will default to Y if no value is entered.
OPERATION
Optional. Identifies the mathematical operation to be performed as part of the calculations for this cell specification.
FACTOR
Optional. This field determines the amount included in factor one of the cell specification.
COMMAND KEYS
F2 - Display a window where a fast path option or mnemonic can be entered. Fast path allows the next menu selection to be made directly from this screen. When the window is displayed, pressing F3 will remove it.
F3 - Exit program without processing the entered data.
F4 - Display a list of values for the field where the cursor is positioned. If you select one of the items from the list, it will be returned to the application screen.
F8 - Display the Analysis Report Extract Definition screen.
F19 - Display the Analysis Report Specification File Mass Maintenance screen, which allows you to duplicate or change existing records.
F20 - Display the Analysis Report Specification Search screen, which allows you to select cell or extract specification records that have already been created.
|