MAC-PAC Homecontact ussupport login 
Documentation > MAC-PAC Reference Library > Financials > General Ledger > Screens > Analysis Report Specifications > GL500S02 - Extract Specification Review

GL500S02 - Extract Specification Review

 

 

WILLIAMS                        GENERAL LEDGER                         2/27/95

 DSP01              ANALYSIS REPORT SPEC FILE MAINTENANCE         EXTRACT SPEC

                                                                         REVIEW

                                                                               

      Report           WKCAP                                                   

      Page             1                                                       

      Line No          9                                                       

      Column           1                                                       

      Sequence No      1                                                        

                                                                               

           Company/Location         001  ITL                                   

           From Account/Center      1CASH                                      

           To Account/Center                                                   

           Fin or Stat              F                                          

           Sequence Code            A                                          

           Budget Year/Sequence                                                

                                                                               

                                                                               

                                                                               

                                                                               

                                                                               

 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 extract specification records used to prepare Analysis Reports.  These records specify the Account/Center or range of Account/Centers to select from the Account Master File or Budget Master File.  This screen also specifies in what sequence Account/Centers will be read and the cell of the Analysis Report on which they will be printed.

REPORT

Required.  Identifies which report these extract records belong to.  The report must exist on the Analysis Report Title File and on Reference File category 130.

PAGE

Required.  Identifies the page number that this extract record belongs on.  The page number must be a valid number between 1 and 9.

LINE NUMBER

Required.  Identifies the line number where this extract record belongs.  The line number must be a valid number between 1 and 50.

COLUMN

Required.  This filed determines the column where this extract record belongs.  Valid values depend on whether the report will be 132 characters wide 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

SEQUENCE NUMBER

Required.  Determines the sequence in which cell extract records will be processed.

COMPANY/LOCATION

Required.  Determines for which company/location that records will be extracted.  The company/location combination must exist on Reference File category 002.

FROM ACCOUNT/CENTER

Required.  Enter a valid account or account/center combination for either a single account or a range of accounts.

TO ACCOUNT/CENTER

Optional.  Enter the last account to be processed for a range of accounts.  If only a single account is selected, then this field may be left blank.

FINANCIAL/STATISTICAL

Required.  This field determines if financial or statistical types of account/centers should be selected for processing.  Valid values are:

F - Financial

S - Statistical

SEQUENCE CODE

Required.  Determines how account/center records are processed for a range of accounts.  Valid values are:

A - Process the next record in account number sequence;

C - Process the next record in center number sequence.

BUDGET YEAR/SEQUENCE

Optional.  Enter a valid budget year and sequence combination.

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.

F7    - Display the Analysis Report Cell 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.