PeopleSoft applications offer a wide range of query and reporting possibilities. PeopleSoft provides standard reports, as well as reporting tools that you can use to create new reports.
This appendix enables you to:
View summary tables of all reports.
View report details.
Note. For samples of these reports, see the Portable Document Format (PDF) files published on CD-ROM with the documentation.
See Also
Enterprise PeopleTools 8.46 PeopleBook: PeopleSoft Process Scheduler
This table lists the Promotions Management reports. The Promotion Contract report that is listed is a Crystal report and the Promotion Forecast Report is an SQR report. If you need more information about these reports, refer to the report details at the end of this appendix.
Report ID and Report Name |
Description |
Navigation |
Run Control Page |
TDC1000 Promotion Contract |
Records the signed acknowledgement of a customer promotion from the customer. |
Promotions, Manage Promotions, Reports, Promotion Contract |
RUN_TD_FORM |
TDS1000 Promotion Forecast |
Provides you with the tool necessary to sync Demand Planning events with planned promotional activities that you create in Promotions Management. |
Promotions, Manage Promotions, Reports, Promotion Forecast |
RUN_TDS1000 |
See Also
PeopleSoft Promotions Management Selected Reports
This section provides detailed information about fields for the individual reports in Promotions Management.
Promotion Code and Description |
References the promotion code and description of the customer promotion offered. The system uses the Promotion Code and Description fields that you defined on the Create Customer-Specific Promo - Promotion Details page for this information. |
Customer Name |
References the customer name to which the promotion is offered. The system uses the Customer ID field that you defined on the customer promotion for this information. |
Broker Name, Broker Phone, and Broker Address |
References the name and address of the broker who is responsible for the customer promotion. The system uses the Contact ID field that you defined on the Create Customer-Specific Promo - Promotion Details page for the broker name. The system uses the location that you defined on the Promotions Options - General Options page for the broker phone and address information. |
From and To Order Dates |
References the valid order dates for this customer promotion. The system uses the First Order Date and Last Order Date fields on the Create Customer-Specific Promo - Promotion Details page for this information. |
From and To Ship Dates |
References the valid scheduled shipment dates for this promotion. The system uses the First Scheduled Ship Date and Last Scheduled Ship Date fields on the Create Customer-Specific Promo - Promotion Details page for this information. |
From and To Delivery Dates |
References the valid requested arrival dates for this customer promotion. The system uses the First Requested Arrival Date and Last Requested Arrival Date fields on the Create Customer-Specific Promo - Promotion Details page for this information. |
From and To Performance Dates |
References the valid performance dates for this customer promotion. The system uses the First Performance Date and Last Performance Date fields on the Create Customer-Specific Promo - Promotion Details page for this information. |
Merchandising Activity |
References the merchandising activities that are defined for the customer promotion. Each merchandising activity's information for the promotion is broken out on the report. The system uses the Merch Type field that you defined on the Create Customer-Specific Promo - Merchandising Activities page to retrieve the syndicated data type that you defined for the merch type on the Merchandising Types page for this information. The syndicated data type is printed next to the Merchandising Activity code. |
For purchasing merchandising activities the following fields appear:
Lump Sum |
References the lump sum costs for any merchandising activities that are associated with the customer promotion. The system uses the Lump Sum Cost field on the Create Customer-Specific Promo - Merchandising Activities page for this information. |
Overhead Costs |
References the overhead costs for any merchandising activities that are associated with the customer promotion. The system uses the Overhead Cost field on the Create Customer-Specific Promo - Merchandising Activities page for this information. |
Period-To-Date |
References the period-to-date option for the merchandising activity associated with the customer promotion. The system uses the Period-to-Date check box on the Create Customer-Specific Promo - Merchandising Activities page for this information. This field is only printed for merchandising activities with an Adjustment Type of Off-Invoice or Bill Back. |
Tiered |
References the tiered pricing option for the merchandising activity associated with the customer promotion. The system uses the Tiered Pricing check box on the Create Customer-Specific Promo - Merchandising Activities page for this information. This field is only printed for merchandising activities with an Adjustment Type of Off-Invoice or Bill Back and a Price Action Type of Discount. |
Mutually Exclusive |
References the mutually exclusive option for the merchandising activity associated with the customer promotion. The system uses the Mutually Exclusive check box on the Create Customer-Specific Promo - Merchandising Activities page for this information. This field is only printed for merchandising activities with an Adjustment Type of Off-Invoice or Bill Back. |
One Time Only |
References the one-time only option for the merchandising activity associated with the customer promotion. The system uses the One-Time Only check box on the Create Customer-Specific Promo - Merchandising Activities page for this information. This field is only printed for merchandising activities with an Adjustment Type of Off-Invoice or Bill Back. |
Buying Agreement |
References the applicable to buying agreement option for the merchandising activity associated with the customer promotion. The system uses the Applicable to Buying Agreement check box on the Create Customer-Specific Promo - Merchandising Activities page for this information. This field is only printed for merchandising activities with an Adjustment Type of Off-Invoice or Bill Back. |
Adjustment Flag |
References the adjustment flag for the merchandising activity associated with the customer promotion. The system uses the Adjustment Flag field for the price formula defined on the Create Customer-Specific Promo - Merchandising Activities page for this information. This field is only printed for merchandising activities with an Adjustment Type of Off-Invoice or Bill Back. |
Off-Invoice |
References the off-invoice discounts for any merchandising activities associated with the customer promotion. The system uses the off-invoice adjustment type Discount field for the price formula defined on the Create Customer-Specific Promo - Merchandising Activities page for this information. |
Bill Back |
References the bill back discounts for any merchandising activities associated with the customer promotion. The system uses the bill back adjustment type Discount field for the price formula defined on the Create Customer-Specific Promo - Merchandising Activities page for this information. |
Low Amount and Upper Amount |
References the low amount and upper amount that must be met on a sales order to receive the discount. The system uses the Low Amount and Upper Amount fields for the price formula defined on the Create Customer-Specific Promo - Merchandising Activities page for this information. |
Low Quantity and Upper Quantity |
References the lower and upper quantity that must be met on a sales order to receive the discount. The system uses the Low Quantity and Upper Quantity fields for the price formula marked as use for metrics on the Create Customer-Specific Promo - Merchandising Activities page for this information. |
Discount |
References the discount amount or percent for the merchandising activity and promotion. The system uses the Discount field for the price formula defined on the Customer-Specific Promo - Merchandising Activities page for this information. This field is only printed for merchandising activities with an Adjustment Type of Off-Invoice or Bill Back. and a Price Action Type of Discount. |
Product Add, Qty/BOGO (quantity/BOGO), and Product Add Adj ( (product add adjustment) |
References the product add product, the quantity/BOGO factor, and the product add adjustment percent or amount of the giveaway for this merchandising activity and promotion. The system uses the Product Add product, Quantity/BOGO Factor, and Product Add Adjustment fields for the price formula defined on the Customer-Specific Promo - Merchandising Activities page for this information. These fields are only printed for merchandising activities with an Adjustment Type of Off-Invoice or Bill Back. and a Price Action Type of Product Add. |
Product ID, Product Description, UPC Code, UOM (unit of measure), Price, and Plan Ship Qty (plan ship quantity) |
References the products and their UPC codes that are offered on the customer promotion. The system uses the Product ID, Unit of Measure, Price, and Plan Ship Qty (plan ship quantity) fields that you defined on the Create Customer-Specific Promo - Product Details page for this information. |
For consumption merchandising activities the following fields appear:
Insertion Costs |
References the insertion costs for the customer promotion and merchandising activity. The system uses the Insertion Costs field on the Create Customer-Specific Promo - Merchandising Activities page for this information. |
Unit Value |
References the value of the offer for the consumption merchandising activity and promotion. The system uses the Unit Value field on the Create Customer-Specific Promo - Merchandising Activities page for this information. |
Unit Handling |
References the per unit cost of running this merchandising activity and promotion. The system uses the Unit Handling Cost field on the Create Customer-Specific Promo - Merchandising Activities page for this information. |
Product ID, Product Description, UPC Code, UOM (unit of measure), Price, and Plan Ship Qty (plan ship quantity) |
References the products and their UPC codes that are offered on the customer promotion. The system uses the Product ID, Unit of Measure, Price, and Plan Ship Qty (plan ship quantity) fields defined on the Create Customer-Specific Promo - Product Details page for this information. |
Information that appears at the bottom of the report:
Signature Block containing Signed, Date, and Comments |
Represents the individual who has agreed to this customer promotion. The system uses the Comments field on the Create Customer-Specific Promo - Merchandising Activities page for this information. The other fields are available so that a signature and date can be entered. |
See Also
Product ID and Item ID |
References the products and items that are forecasted in any Inventory business unit. If a forecaster was entered on the request page, only the products and items that the forecaster is responsible for will print on the report. |
Cust Group (customer group) |
References the forecast customer group (group type = FCST) for the customer ID. |
Prod Group (product group) |
References the forecast product group (group type = FCST) for the product ID. |
Base Qty (base quantity) |
References the base units defined for the promotion. If the promotion is associated with a promotion group, then the weights that you defined for each product determine the base quantity for the individual product. |
Lift Qty (lift quantity) |
References either the target lift quantity or planned lift quantity for the product on the promotion. target lift quantity = (weighted base quantity * incremental lift percent) * participation percent planned lift quantity = weighted planned ship quantity − weighted base quantity |
Lift Pct (lift percent) |
References either the target lift percent or the planned lift percent. target lift percent = ((target plan ship quantity / weighted base quantity) − 1) * 100) planned lift percent = ((planned plan ship quantity / weighted base quantity) − 1) * 100 |
Plan Ship Qty (plan ship quantity) |
References either the target plan ship quantity or the planned plan ship quantity for the product on the promotion. If the promotion is associated with a promotion group then the weights that you defined for each product determine the planned ship quantity for the individual product. target plan ship quantity = weighted base quantity + target lift quantity planned plan ship quantity = weighted planned ship quantity that you defined on the promotion |
Promotion Price |
References the product price for a product after having taken into account all per unit discounts (off-invoice and bill back) for the promotion. |
Total Lift Qty (total lift quantity) |
If either item ID or product ID are selected as a sort option, the total lift quantity by product or item appears. |
Discount Amount |
References the discount amount or percent for the merchandising activity and promotion. The system uses the Discount field for the price formula marked as use for metrics on the Customer-Specific Promo - Merchandising Activities page for this information. |
Lump Sum Cost |
References the lump sum cost for the merchandising activity and promotion. The system uses the Lump Sum Cost field defined on the Customer-Specific Promo - Merchandising Activities page for this information. |
Product Add, Qty/BOGO (quantity/BOGO), and Adjustment |
References the product add product, the quantity or BOGO factor, and the product add adjustment of the product add for this merchandising activity and promotion. The system uses the Product Add, Quantity/BOGO Factor, and Product Add Adjustment fields for the price formula defined on the Customer-Specific Promo - Merchandising Activities page for this information. |
Cnsmptn Unit Value (consumption unit value) |
References the unit value for the consumption merchandising activity and promotion. The system uses the Unit Value field defined on the Customer-Specific Promo - Merchandising Activities page for this information. |
See Also