View 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.

View Prices or Gold Copy Records

In the prices summary window you can view vendor level records from the RULESDBO_PRICE.STATUS table. This is the table where gold copy prices are managed, scrubbed and displayed from. In the Summary view, you can also view vendor level records from the RULES_DBO.PRICE_RULESECURITIES table. This is the table where gold level prices are managed, scrubbed and displayed from. 

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 Vendor Exceptions

This view displays vendor 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 an exception record is highlighted by a customer the lower pane populates with the price records that this exception applies to.