| |
EDI Viewer - Query Parameters |
EDI Viewer allows you the ability to query your data with many different combinations.
The query parameters are found at the top of the Crown Royalty Annual Invoice window. These selections will be enabled/disabled depending on which report tab you are on. For example, when you are on the CCA Summary report tab, you cannot choose a Product code because it is not on the report.
These query parameters can be used individually or in conjunction with each other. The query parameters determine what data is retrieved from the database. Once the data has been retrieved, the Filter button on the toolbar can be used to further refine the data.
If more that one parameter is entered, AND is always used to build the query for retrieving data. If only the facility parameter was entered and all the others were blank, the report would show data for the facility you choose for every invoice that has been imported. This could take a long time.
The more parameters you enter, the faster the data is retrieved because you are being specific on what you want.
To clear out all of the query parameters,
click on the pencil icon on the right side of the screen.
To clear out only one query parameter, click on
that parameter, eg Product, and press the Delete key on your
keyboard. This will only clear out the parameter you are on.
The list showing Facility indicates that the list to the right of it will show facilities you can choose.
The Facility list contains other values and when they are chosen, the list the to right will show the corresponding data. By choosing FCC, the list to the right will contain all Facility Cost Centers.
The values in the Facility list are: