Mapping PDW Price Elements to Eclipse Pricing Basis Names

Use the PDW Price Export screen to map Product Data Warehouse (PDW) pricing elements to Basis Names defined in Pricing Maintenance and define pricing formulas for the pricing values that are being exported into the Eclipse Product File.

Note: If you are not familiar with Eclipse's Pricing utility, see Pricing Maintenance.

Like the data Export Maintenance screen, you can have both default and override maps for pricing exports. The default pricing export map provides 20 basis names to which you can map PDW pricing elements. For each basis name, you can define calculation formulas to modify the pricing element value, as necessary. These calculation formulas work much like translate statements for data elements.

For example, you can double a list cost when you export it into your Eclipse Product File by entering a formula that tells the system to multiply the pricing element value by two.

Also like data export maps, you can assign priority to multiple price elements mapped to the same basis, and you can see a sample export before running the actual export.

You can edit the default map, as necessary.

To create the default map for PDW pricing elements:

From the Tools > Product Data Warehouse (PDW) > PDW Export Maintenance menu, select PDW Price Export Maintenance to display the PDW Price Export Maintenance screen.

In the Line field, use the Edit Default hot key to display the default map.

In the Basis Names column, press F10 and select Basis 1 to define your first price export.

Note: For the default map, you can use Basis 1-20 consecutively to define your pricing export map.

In the Calc Base column, enter one of the following calculation basis:

Enter - Manually assign a new default value to the basis name.
Previous - Assign the same cost or price for the new effective export date as was assigned to the previous effective export date.
No Update - Keep the cost or price as it is.
Another basis name associated with this price line in order to use its formula.

In the Formula column, enter a pricing formula, like the ones explained in the table below:

Formula	Specifies...
+n	Basis plus the number that follows (for example, +1).
-n	Basis minus the number that follows (for example, -1).
*n	Basis multiplied by the number that follows (for example, 2). Use 1 to indicate that you want the value to remain as it is.
dn	Basis divided by the number that follows (for example, d2).

In the R column, enter the number of places to round the number.
In the Pr column, if you are assigning more than one price element to a basis, enter a priority number for the pricing elements so that the system knows which element to export when both elements exist in the PDW Catalog. Higher numbers have higher priority; however, the system considers a line with a blank priority as the highest priority.
In the Meta Item column, enter the metadata pricing element that you want to map to the basis.

In the Zone/Sht column, the system enters ******** because pricing zones are not associated with the default map. You can enter pricing zones on override maps.

Press Esc to save changes and exit the screen.
Run the Eclipse Product File Batch Update Utility.

More Options for Creating the Default Pricing Export Map

The PDW Price Export Maintenance screen also offers these options.

Hot Key	Function
Sample Item	Shows the actual data elements that will be mapped according to the defined map.
Copy	Copies the current map to a new map. At the New Price Line prompt, enter the price line to use for the new map.
Delete	Deletes the currently displayed export map. The system prompts you to confirm the deletion.