Designing an Extract for PDW and Eclipse Pricing

When you download pricing information from the Product Data Warehouse (PDW) Catalog or Eclipse Product File into an ASCII formatted file, you need to define four additional settings on the PDW File Extract Utility screen. Design the rest of the extract as you do for any extract design.

To design an extract for PDW and Eclipse pricing information:

  1. From the Tools > Product Data Warehouse (PDW) menu, select PDW File Extract Utility to display the PDW File Extract Utility screen.

  1. Populate this screen's fields with the necessary data as you do for any extract design.

  2. In the Price Date field, enter the pricing date on which to calculate the prices. This field supports variable dating.

  3. In the Price Branch field, enter the branch whose pricing you want to use.

  4. In the Quantityfield, if you want to price all items based on a unit of measure (UOM), enter the quantity of individual items in that UOM. Define the UOM in the UOM field.

  1. In the UOM field, if you want to price all items based on a UOM, enter that UOM. Enter the quantity of individual items that make up a UOM in the Qty field.

For example: You want to price all items in units of boxes. Ten individual items fill one box. Enter 10 in the Qty field and enter bx for units of boxes in the UOM field. The system will price all items as one box, each holding 10 items.

  1. Complete the design as you do any extract design.

See Also:

PDW File Extract Utility Overview

Extracting PDW and Eclipse Product Data

Tasks Not Available in Solar