The Reference Data Center Pricing tool enables you to view pricing data by data type, by sources and by designation.
- Date type defaults to effective date. This is the effective date of the records that will be viewed. The other option is process date. This is the date the record was updated last.
- Source defaults to All Sources. This displays all sources with data for the view the customer has elected that the business group the individual has assigned has access to.
- View data by defaults to vendor prices. This is the summary view of vendor price records. Additional views are vendor exceptions, gold prices, and gold exceptions.
Filters
Filter fields available are controlled by RDC system setting 1038 (Client: Fields to display in pricing summary screen (view by vendor)) and RDC system setting 1037 (Client: Fields to display in pricing summary screen (view by gold copy). Any fields from the SECURITYDBO schema can be added to the default fields in this setting to assist with targeting specific data sets. You can then elect which of these filter fields to display using the green plus sign to the right of the filter fields. The filter fields and pre-set values for each can be saved for an individual’s profile for queries the person will use often.
Summary View
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.
0 Comments