View Pricing Data in Reference Data Center Prices

 In the Reference Data Center Prices Summary window, you can view pricing data by:

• Date Type

• Source

• View Data By
  

Date Type. The Date type field default to the effective date. This is the date on which the records will be viewed. You can also choose the Process date.

Source. The Source field defaults to All Sources. This displays all sources with data for the view that you have elected that the business group that you have access to.

View data By. This field defaults to vendor prices. This is the summary view of vendor price records. Additional views are vendor exceptions, gold prices, and gold exceptions.

In the Summary window, default fields display by vendor summary view and gold copy view. Additional fields can also be added to assist with targeting specific data sets. In addition, you can filter fields to display creating a pres-set profile for queries that you will use often. 

See Customize Searches in a Workspace

View Prices or Gold Copy Records

In the prices summary window you can view vendor prices and gold level prices. Vendor records have been managed and scrubbed from scrubbed from the from the RULESDBO_PRICE.STATUS table and the  gold copy prices from the RULES_DBO.PRICE_RULESECURITIES table. Once you select a record, the lower pane populates with a list of exceptions for that record and a list of vendor sources associated with the record. 

To View Vendor Prices or Gold Copy Records:

1. In the Reference Desk workspace, click Prices in the left navigation.
   You see the Prices workspace.

2. In the View Data By Drop Down, select Vendor Prices.

3. The Effective Date defaults to today's date. 

4. Complete the search criteria and click the Search button.

5. Click Search.
   All records matching your search criteria display.

View Exceptions

In the Price Summary window you can view vendor exceptions. This view displays exceptions from the RULESDBO_PRICE_VALIDATION_STATUS_DETAIL table. This is the table where validation results and details are stored after validation tests are applied by a validation rule. Once you select an exception, the lower pane then populates with the price record that this exception applies to.

To View Vendor Exceptions:

1. In the Reference Desk workspace, click Prices in the left navigation.
   You see the Prices workspace.

2. In the View Data By drop down, select one of the following options:
   –   Gold Copy Exceptions
   –   Vendor Exceptions

3. The Effective Date defaults to today's date. 

4. Complete the search criteria and click the Search button.

5. Click Search.
   All records matching your search criteria display.