|
|
|
The Budget Query Specifications panel allows you to query the contents of the BUDTAB. Using the prompts provided, you can:
You specify query criteria and the manner in which you want results displayed. The following processing options, located on the Budget Query Specifications panel, determine result format.
These two options work together to display the following results.
|
Summarize |
Break |
Results |
|---|---|---|
|
N |
N |
Detail report of the records that meet any criteria specified in the Budget Query Specifications panel. CA PMA Chargeback displays each record separately. For each record, CA PMA Chargeback provides values for the additional fields Budget Amt and Desc. |
|
Y |
N |
Summary report of the records that meet any criteria specified in the Budget Query Specifications panel. Result fields Budget Amt and Count appear directly on the Budget Query Specifications panel. Budget Amt and Count hold summary information. |
|
Y |
Y |
Summary report of the records that meet any criteria specified in the Budget Query Specifications panel. Result records are broken into groups based on the Brk fields you select. CA PMA Chargeback displays each group separately. For each group of records, CA PMA Chargeback provides values for the additional fields Budget Amt and Count. |
The following panel shows the Budget Query Specifications panel upon entry to Budget Query. The values shown are the defaults.
USERID CA PMA Chargeback MM/DD/YY HH:MM:SS __ Acctdefs Cbdefs Query Data Period Options Exit Help +-- CBQBGTS -- Budget Query Specifications ---------------------------------+ | Panel Exit Help | | ------------------------------------------------------------------------- | | Type information for budget query. Then Execute. | | | | Summarize N Break N Version : PROD PROD | | Brk | | ORD Type . . . . . N | | Charge Element . . N | | Qualifier . . . . N | | Period Number . . thru N | | DIVISION . . . . . N | | DEPARTMENT . . . . N | | | | | | | | | | F2=Exec | +---------------------------------------------------------------------------+ Command ===> ____________________________________________________________ F1=Help F3=Exit F4=Prompt F9=Command F10=Action Bar F12=Cancel PA1=Susp
The Version field specifies the version of the CA PMA Chargeback application being used. Only the last four characters of the version field are available for entry. The default is the version specified using CA PMA Chargeback's Option function. All other fields are available for entry.
The Budget Query Specifications panel appears when one of these events occur:
----------------
| Query |__________
| Pull-Down | |
|>Budget Query | v
---------------- ----------------
| Budget Query |
|Specifications|
| Panel |
----------------
▲
|
-----------------
| Budget Query |
| Result Panels |
|>F3 |
-----------------
The following Budget Query Specification panel fields are available for input. These input fields refer to the sample panel in Budget Query Specifications Panel.
Summarize A one-character field that works with the Break option to determine the format of results. Valid entries for this field are N and Y. The default value is N and appears when you first select the panel.
When you set the Summarize option to Y, results display in summary form, or in summary-with-breaks form (see Budget Query Specifications Processing Options through Budget Query Specifications Processing Options).
Break A one-character field that works with the Summarize field, to determine result format. Valid entries for this field are N and Y. The default value is N and appears when you first select the panel.
When the Break option is Y, the Brk column is active (see C).
Note: At least one field in the Brk column must be set to Y, when you select the Break option. Otherwise, CA PMA Chargeback returns an error message.
CA PMA Chargeback ignores any values entered in the Brk column, if the Break option is not set to Y.
The Break field is valid only with the Summarize option.
Note: You can use the SQL wildcard character % alone or with any alphanumeric character string as selection criteria for these fields.
Version The last four characters of this field are available for data entry. Specify the version of CA PMA Chargeback you want to query.
ORD Type The three-character name of the output record identifier used for selection criteria. CA PMA Chargeback processes only those records with the ORD Type you specify.
Charge Element The name (up to 16 alphanumeric characters) of the Charge Element used for selection criteria. Only those records with Charge Element you specify display.
Qualifier The name (up to 16 alphanumeric characters) of the conditional test applied to the charge unit, used for selection criteria. CA PMA Chargeback selects only those records for which the qualifier applies.
Period Number The start of the range of accounting periods or the accounting period from which CA PMA Chargeback selects records.
thru The end of the range of accounting periods from which CA PMA Chargeback selects records.
The following entry fields indicate the accounting structures you want to query.
Note: CA PMA Chargeback displays only defined accounting structures. The examples presented in this chapter show an accounting structure with two levels. The accounting structures you define can be different.
Division Department Enter the name of a defined accounting level whose budget information you want to query.
Executes the query with the selections made.
| Copyright © 2012 CA. All rights reserved. |
|