PD Customer Pricing Report CSV output

This table shows the fields included in the CSV output file created by the PD Customer Pricing Report.
Note: Most prices, costs, rebates, margins, and discounts can be validated in Sales Customer Pricing Inquiry.
Field Source
Cust No Customer Setup
CPT Customer Price Type in Customer Setup or Customer Ship To Setup
Ship To Customer Ship To Setup
Product Product Setup
Description 1 Product Setup
Description 2 Product Setup
Cust Prod Customer Product in Product Extended Product Cross Reference Setup
UOM Unit of Measure in Product Setup
Price Base Price in Product Warehouse Product Setup or Product Catalog Setup
Cost Replacement Cost in Product Warehouse Product Setup or Product Cost in Product Catalog Setup
Margin % Calculated based on Net Price, Actual Cost and Rebate Amount
Vendor ARP Vendor in Product Warehouse Product Setup or Vendor in Product Catalog Setup
Product Line Product Warehouse Product Setup or Product Catalog Setup
PPT Price Type in Product Warehouse Product Setup or Product Catalog Setup
RBT Rebate Type in Product Warehouse Product Setup or Product Catalog Setup
Sub RBT Sub Rebate Type in Product Warehouse Product Setup or Product Catalog Setup
PDSC # Record # in PD Pricing Setup
Level PD Pricing Setup
End Date PD Pricing Setup
PDSR # Rebate Record # in PD Pricing Setup
Level Rebate Level in PD Pricing Setup
End Date Rebate End Date in PD Pricing Setup
Disc Amt Discount percent for the Rebate Level in PD Pricing Setup
Net Price Calculated price based on selling UOM, with discounts applied. If no selling UOM, stocking UOM is used.
Rebate Calculated rebate amount (as calculated in Sales Customer Pricing Inquiry). If tied to a pricing worksheet, the cost from the pricing sheet is used.
UPC# Vendor UPC in Product UPC Number Setup, based on product and ARP or catalog vendor
List Price Product Warehouse Product Setup or Product Catalog Setup
Base Price List Price in Product Warehouse Product Setup or Product Catalog Setup
Average Cost Average Cost in Product Warehouse Product Setup or Product Cost in Product Catalog Setup
Standard Cost Product Warehouse Product Setup or Product Catalog Setup
Replacement Cost Replacement Cost in Product Warehouse Product Setup or Product Cost in Product Catalog Setup
Last Cost Last Cost in Product Warehouse Product Setup or Product Cost in Product Catalog Setup
Vendor Product Product Warehouse Product Setup or Product Catalog Setup
Catalog Yes or No; Product Catalog Setup