PeopleSoft Enterprise Purchasing 9.1 PeopleBook

Analyzing Vendor Rebates

This chapter provides an overview of the vendor rebate analysis workbench and discusses how to:

Define sales organizations.
Establish vendor rebate allocations.
Analyze vendor rebates.

Understanding the Vendor Rebate Analysis Workbench

The vendor rebate analysis workbench is a tool that is used to assist rebate managers with vendor rebate analysis. Using the vendor rebate analysis workbench, a rebate manager can:

Manage earned rebates by keeping track of rebate allocations among sales organizations.
Analyze accumulative purchases and earned rebates for each vendor rebate agreement, which includes details of open purchase orders, receipts, and vouchers that have been associated with the vendor rebate agreement.
View the next rebate level approaching a threshold.
View transactional information from accrued rebate details.
Generate reports of threshold analysis and open purchase order information.
Extract accrued rebate transaction data to a flat file.

Note. The accuracy of the rebate information that is available for vendor rebate analysis depends on the Rebate Accrual process and how often you perform that process. The volume of information to be processed by the Rebate Accrual process can be very large and the processing time could take awhile. You should determine an appropriate frequency for the run of the process so that business requirements are met and the process is able to finish in a reasonable amount of time.

Vendor Rebate Analysis Process

To use the vendor rebate analysis workbench:

Select the vendor rebate agreements that you want to include for analysis using the Vendor Rebate Analysis Workbench - Workbench Filter Options page.
View claim and rebate summary activity using the Vendor Rebate Analysis Workbench page.
Perform additional vendor rebate analysis.
1. Select one or more of the vendor rebate agreements that you want to perform additional analysis processing for by selecting the check box next to each vendor rebate agreement in the List of Vendor Rebates group box on the Vendor Rebate Analysis Workbench page.
2. Select the type of additional processing that you want to perform for the vendor rebates using the Select Row For field on the Vendor Rebate Analysis Workbench page.
  
  Select Threshold & Time Period Anly (threshold and time period analysis) to perform a threshold and time period analysis for the vendor rebates that you selected.
  
  Select PO Not Received Report to generate the PO Not Received report for the vendor rebates that you selected.
  
  Select Rebate Threshold Report to generate the Rebate Threshold report for the vendor rebates selected.
  
  Select Extract Accrued Dtls to File (extract accrued details to file) to generate a flat file containing the accrued details for the vendor rebates that you selected.
3. Select the time period to be used for the threshold and time period analysis using the View Results by Time Period field on the Vendor Rebate Analysis Workbench page.
  
  Note. Time period is applicable only for the threshold and time period analysis.
4. Click the OK button on the Vendor Rebate Analysis Workbench page.
5. View the information that is rendered by the processing action that you requested.
  
  The process that you requested in the Select Row For field determines what page appears next.
  
  Use the Vendor Rebate Analysis Workbench - Rebate Threshold Analysis page to view the vendor rebate threshold and time period analysis for the vendor rebates that you selected.
  
  Use the Vendor Rebate Analysis Workbench - PO Not Received Report page to generate the PO Not Received report for the vendor rebates that you selected.
  
  Use the Vendor Rebate Analysis Workbench - Rebate Threshold Report page to generate the Rebate Threshold report for the vendor rebates that you selected.
  
  Use the Vendor Rebate Analysis Workbench - Flat File Extraction on Rebate Transactions page to generate a flat file of the accrued details for the vendor rebates that you selected.
(Optional) Save this version of the Vendor Rebate Analysis Workbench for use at a later date by clicking the Save Workbench button on the Vendor Rebate Analysis Workbench page.

Defining Sales Organizations

To define sales organizations to be used with vendor rebates, use the Sales Organization Setup component (VRBT_SALES_ORG).

This section discusses how to define sales organizations.

Page Used to Define Sales Organizations

Page Name	Definition Name	Navigation	Usage
Sales Organization Setup	VRBT_SLS_ORG_SETUP	Purchasing, Vendor Rebates, Vendor Rebate Analysis, Sales Organization Setup	Define the sales organizations that you want to allocate earned rebates to in PeopleSoft Purchasing. You can associate a PeopleSoft Order Management business unit to the sales organization if you have also implemented PeopleSoft Order Management.

Defining Sales Organizations

Access the Sales Organization Setup page (Purchasing, Vendor Rebates, Vendor Rebate Analysis, Sales Organization Setup).

OM Business Unit (PeopleSoft Order Management business unit)

Select the PeopleSoft Order Management business unit to associate with the sales organization.

If you want to use a PeopleSoft Order Management business unit for fund allocation, you must create a sales organization and associate this sales organization to the PeopleSoft Order Management business unit to perform vendor rebate allocations.

Note. Only one sales organization can exist per PeopleSoft Order Management business unit and only one set of contact information can exist, which is contact, email, and phone information.

Establishing Vendor Rebate Allocations

This section lists prerequisites and discusses how to establish vendor rebate allocations.

Prerequisites

Before you can establish vendor rebate allocations, you need to define a sales organization.

See Defining Sales Organizations.

Page Used to Establish Vendor Rebate Allocations

Page Name	Definition Name	Navigation	Usage
Vendor Rebate Allocation	VRBT_ALLOC_DTLS	Purchasing, Vendor Rebates, Vendor Rebate Analysis, Vendor Rebate Allocation	Allocate the earned rebate from the supplier to the sales organizations. Use this page to capture the allocation percentage for history and analysis purposes. The accounts allocation itself will be manually done through the PeopleSoft General Ledger.

Establishing Vendor Rebate Allocations

Access the Vendor Rebate Allocation page (Purchasing, Vendor Rebates, Vendor Rebate Analysis, Vendor Rebate Allocation).

Note. If rebate managers do not have unrestricted access, then they can select only vendor rebate agreements assigned to them.

See Defining Vendor Rebate Agreement Authorizations.

Total Accrued Rebate

Displays the total accrued rebate amount for this vendor rebate agreement as of today.

Total Rebate Payment Received

Displays the total rebate payment received amount for this vendor rebate agreement.

Total Allocated Amount

Displays the total allocated amount for this vendor rebate agreement.

Amount Available to Allocate

Displays the amount available to allocate for this vendor rebate agreement.

Amount Available to Allocate = (Total Rebate Payment Received – Total Allocated Amount)

Vendor Rebate Allocation

Allocation Date

The date for today appears by default. You can select another allocation date.

Amount to Allocate and Allocated Amount

Select the amount that you want to allocate to the sales organizations.

When you insert a new allocation row, this field label appears as Amount to Allocate. After you complete the allocation, the field label appears as Allocated Amount.

If no other allocations currently exist for this vendor rebate agreement, the Total Rebate Payment Received amount appears by default. If other allocations exist, the Amount Available to Allocate amount appears by default. You can enter a different amount.

Allocation Line

Alloc Percent (allocation percent)	Select the allocation percent. 100 percent appears by default. The allocation percent for all the allocation lines together must be less than or equal to 100 percent. If you change the allocation percent, the system automatically calculates and displays the new allocated amount for the line in the grid.
Allocated Amount	Displays the allocated amount that you want to associate with this particular sales organization. Allocated Amount = (Allocation Percent × Amt to Allocate or Allocated Amount (in the header portion of page)
Description	Enter a description for this allocation line.
Sales Organization ID	Select the sales organization that you want to associate with this allocation amount.

Analyzing Vendor Rebates

This section discusses how to:

Select vendor rebates for analysis.
Use the vendor rebate analysis workbench.
View accrued rebate details.
View rebate threshold analysis information.
View not received purchase order information.
Extract vendor rebate analysis to a file.

Pages Used to Analyze Vendor Rebates

Page Name	Definition Name	Navigation	Usage
Vendor Rebate Analysis Workbench - Workbench Filter Options	VRBT_ANLY_WB_SRCH	Purchasing, Vendor Rebates, Vendor Rebate Analysis, Rebate Analysis Workbench, Vendor Rebate Analysis Workbench - Workbench Filter Options	Enter filter options for the Vendor Rebate Analysis Workbench.
Vendor Search	VENDOR_LOOKUP_SEC	Click the Vendor Search link on the Vendor Rebate Analysis Workbench - Workbench Filter Options page.	Search for available vendors.
Vendor Rebate Analysis Workbench	VRBT_ANLY_WB	Click the View Workbench button on the Vendor Rebate Analysis Workbench - Workbench Filter Options page.	Perform analysis on a vendor rebate agreement.
Rebate Agreement - Rebate Agreement	VRBT_HDR	Click a Rebate ID link in the List of Vendor Rebates group box on the Claim to date Activity tab on the Vendor Rebate Analysis Workbench page. After selecting transactions, then select Threshold & Time Period Anly in the Select Rows For field and click the OK button on the Vendor Rebate Analysis Workbench page. Click a Rebate ID link in the List of Vendor Rebates group box on the Vendor Rebate Analysis Workbench - Rebate Threshold Analysis page.	View the complete vendor rebate agreement.
Vendor Rebate Analysis Workbench - Accrued Rebate Details	VRBT_ACCR_INQ	Click the Accrued Rebate Details link in the List of Vendor Rebates group box on the Claim to date Activity tab on the Vendor Rebate Analysis Workbench page. After selecting transactions, then select Threshold & Time Period Anly in the Select Rows For field and click the OK button on the Vendor Rebate Analysis Workbench page. Click the Accrued Rebate Details for Rule link in the List of Vendor Rebates group box on the Rebate Rule Details tab on the Vendor Rebate Analysis Workbench - Rebate Threshold Analysis page.	View accrued rebate transaction details.
Purchase Order Inquiry - Purchase Order	PO_LINE_INQ	Click a Purchase Order link on the PO tab on the Vendor Rebate Analysis Workbench - Accrued Rebate Details page. After selecting transactions, then select Threshold & Time Period Anly in the Select Rows For field and click the OK button on the Vendor Rebate Analysis Workbench page. Click the Total Open PO Amount link in the List of Vendor Rebates group box on the Vendor Rebate Analysis Workbench - Rebate Threshold Analysis page. Click a Purchase Order link on the Vendor Rebate Analysis Workbench - PO Not Received Analysis page.	View the complete purchase order with all its details.
Receipts	RECV_INQ	Click a Receiver ID Number link on the Receipt tab on the Vendor Rebate Analysis Workbench - Accrued Rebate Details page.	View the receipt details.
Vendor Rebate Allocation	VRBT_ALLOC_DTLS	Click the Vendor Rebate Allocation Details link in the List of Vendor Rebates group box on the Claim to date Activity tab on the Vendor Rebate Analysis Workbench page.	View the vendor rebate allocation to the sales organizations.
Vendor Rebate Analysis Workbench - Rebate Threshold Analysis	VRBT_THRSHLD_ANLY	After selecting transactions, then select Threshold & Time Period Anly in the Select Rows For field and click the OK button on the Vendor Rebate Analysis Workbench page.	Perform threshold analysis for a rebate agreement. Threshold analysis assists rebate managers in analyzing the extent of additional purchases that are required to optimize the rebate amount.
Vendor Rebate Analysis Workbench - PO Not Received Analysis	VRBT_PO_NRCVD	Click the Total Open PO Amount link in the List of Vendor Rebates group box on the Vendor Rebate Analysis Workbench - Rebate Threshold Analysis page.	View purchase orders that are still open that are associated with the vendor rebate agreements.
Vendor Rebate Analysis Workbench - Rebate Threshold Report	VRBT_SERVER_RPT2	After selecting transactions, then select Rebate Threshold Report in the Select Rows For field and click the OK button on the Vendor Rebate Analysis Workbench page.	Initiate the Rebate Threshold Report SQR Report process (POVRB200).
Vendor Rebate Analysis Workbench - PO Not Received Report	VRBT_SERVER_RPT2	After selecting transactions, then select PO Not Received Report in the Select Rows For field and click the OK button on the Vendor Rebate Analysis Workbench page.	Initiate the PO Not Received Report SQR Report process (POVRB300).
Vendor Rebate Analysis Workbench - Flat File Extraction on Rebate Transactions	VRBT_PRINT_OPTION	After selecting transactions, then select Extract Accrued Dtls to File in the Select Rows For field and click the OK button on the Vendor Rebate Analysis Workbench page.	Initiate the Flat File Extraction Application Engine process (VRBT_FILEXT), which creates a flat file containing the vendor rebate transactions.
Save Workbench	VRBT_SAVE_WB_SBP	Click the Save Workbench button on the Vendor Rebate Analysis Workbench page.	Save a vendor rebate analysis workbench for later retrieval and use.

Selecting Vendor Rebates for Analysis

Access the Vendor Rebate Analysis Workbench - Workbench Filter Options page (Purchasing, Vendor Rebates, Vendor Rebate Analysis, Rebate Analysis Workbench, Vendor Rebate Analysis Workbench - Workbench Filter Options).

Vendor Search	Click this link to access the Vendor Search page. Use this page to search for vendors.
Transaction Accrued From	Select the from date on which to search for vendor rebate accrued transactions. In Add mode, January 1st of the current year appears by default.
Transaction Accrued To	Select the to date on which to search for vendor rebate accrued transactions. In Add mode, the current date appears by default.
Rebate ID	Select the vendor rebate agreement that you want to analyze on the workbench. Only approved vendor rebate agreements are available for selection. Also, the vendor rebate agreements that are available for selection is determined by the rebate manager's access right. If you are a rebate manager who does not have unrestricted access, then you can view and select only your rebate agreements. If you are a rebate manager and have unrestricted access, then you can view and select any rebate agreements that are associated with any rebate manager.
Rebate Rule Type	Select the rebate rule type. Leave this field blank to have the system retrieve all transactions for all rebate rule types that are associated with the vendor rebate agreement on the Vendor Rebate Analysis Workbench.
Claim Status	Select the claim status. Leave this field blank to have the system retrieve all transactions for all claim statuses that are associated with the vendor rebate agreement on the Vendor Rebate Analysis Workbench page.
View Workbench	After you enter filter options, click this button to display the vendor rebate analysis workbench populated with the information that matches the filter options that you selected.

Using the Vendor Rebate Analysis Workbench

Access the Vendor Rebate Analysis Workbench page (click the View Workbench button on the Vendor Rebate Analysis Workbench - Workbench Filter Options page).

Select Rows For

Select the type of activity that you want to perform for the vendor rebates that you select. Activities are:

Extract Accrued Dtls to File: When you select this activity, the Vendor Rebate Analysis Workbench - Flat File Extraction on Rebate Transactions page appears.

Use this page to extract the accrued rebate details to a flat file.

See Extracting Vendor Rebate Analysis to a File.

PO Not Received Report (purchase order not received report): When you select this activity, the Vendor Rebate Analysis Workbench - PO Not Received Report page appears.

Use this page to initiate the PO Not Received SQR Report process (POVRB300).

See PeopleSoft Purchasing Reports.

Rebate Threshold Report: When you select this activity, the Vendor Rebate Analysis Workbench - Rebate Threshold Report page appears.

Use this page to generate the Rebate Threshold Report SQR Report process (POVRB200).

See PeopleSoft Purchasing Reports.

Threshold & Time Period Anly (threshold and time period analysis): When you select this activity along with a view results by time period option, the Rebate Threshold and Time Period Analysis page appears populated with the vendor rebate information that is associated with the vendor rebates that you selected.

Use this page to perform threshold and time period analysis for vendor rebates.

See Viewing Rebate Threshold Analysis Information.

OK

Click this button to have the system perform the process that you requested in the Select Rows For field.

Note. You must select at least one vendor rebate agreement in the List of Vendor Rebates group box before any process occurs.

View Results by Time Period

Select the time period that you want to use to view the vendor rebate analysis. Time periods are:

Monthly.

Quarterly.

Yearly.

This field is available only if you select Threshold & Time Period Anly in the Select Rows For field.

List of Vendor Rebates

Selection	Select this check box next to the vendor rebates that you want to analyze. You can analyze one or more rebates at the same time.
Rebate ID	Click a rebate ID link to access the Rebate Agreement - Rebate Agreement page. Use this page to view all the details of this vendor rebate agreement.
Total Rebate Amt on Sel Trans (total rebate amount on selected transactions) and Currency	Displays the total rebate amount in the rebate currency for the selected transactions. The total rebate amount on selected transactions equals the sum of transaction line rebate amounts on the Vendor Rebate Analysis Workbench - Accrued Rebate Details page that match the filter options that you selected.
Total Claim Collected	Displays the total collected amount for a vendor rebate in the rebate currency. The total claim collected equals the sum of total claimed amount for all claims that are associated with the transaction lines on the Vendor Rebate Analysis Workbench - Accrued Rebate Details page that match the filter options that you selected.
Total VAT Claim Collected (total value added tax claim collected)	Displays the total VAT claim collected amount in the rebate currency. The total VAT claim collected equals the sum of total claimed collected VAT amount for all claims that are associated with the transaction lines on the Vendor Rebate Analysis Workbench - Accrued Rebate Details page that match the filter options that you selected.
Total Claim Adjustment	Displays the total claim adjustment amount. The total claim adjustment equals the sum of the difference between the total claim amount minus the original total claim amount for each claim that is associated with the transaction lines on the Vendor Rebate Analysis Workbench - Accrued Rebate Details page that match the filter options that you selected.
Total Allocated Rebate Amount	Displays the total allocated rebate amount for the rebate agreement.
Accrued Rebate Details	Click this link to access the Vendor Rebate Analysis Workbench - Accrued Rebate Details page. Use this page to view the accrued rebate details for this vendor rebate agreement.
Vendor Rebate Allocation Details	Click this link to access the Vendor Rebate Allocation page. Use this page to view the rebate allocation details for this vendor rebate and the sales organizations. See Establishing Vendor Rebate Allocations.

Rebate to Date Activity

Select the Rebate to date Activity tab.

Total Accrued Rebate	Displays the total accrued amount for the vendor rebate agreement.
Total Rebate Payment Received	Displays the total payment received amount for the vendor rebate agreement.
Total Pending Rebate Amount	Displays the total pending amount for the vendor rebate agreement.

Miscellaneous Information

Save Workbench	Click this button to access the Save Workbench page. Use this page to save this vendor rebate analysis workbench and its associated information, including the filter options that you entered. At a later date, you can retrieve the workbench and continue to perform rebate analysis.
Set Filter Options	Click this link to access the Vendor Rebate Analysis Workbench - Workbench Filter Options page. Use this page to maintain the different filter options for this workbench.

Viewing Accrued Rebate Details

Access the Vendor Rebate Analysis Workbench - Accrued Rebate Details page (click the Accrued Rebate Details link in the List of Vendor Rebates group box on the Claim to date Activity tab on the Vendor Rebate Analysis Workbench page).

Rebate Details

Displays the rebate accruals that were generated by the Generate Rebate Accrual process for the rebate agreement that you selected and according to the filter options that you selected.

See Generating Rebate Accruals.

Rebate Amount	Displays the rebate amount for this transaction.
Trans Status (transaction status)	Displays the particular transaction status for the rebate accrual record. For example, if the transaction is a receipt transaction and the related voucher was not available at the time of rebate accruals generation, then the transaction status is Received. If the voucher was available for the receipt transaction at the time of rebate accruals generation or if the transaction is related to a voucher, then the transaction status is Vouchered.. See Understanding the Rebate Accrual Process.
Rebateable Amount and Currency	Displays the rebateable amount in the vendor rebate currency for this transaction. This amount comes from the rebate accrual records that were generated by the Generate Rebate Accrual process for the receipt, voucher, or RTV transaction. The rebateable amount corresponds to the basis amount for rebate calculation.
Rebateable Quantity and (VRBT UOM) (vendor rebate agreement unit of measure)	Displays the rebateable quantity in the vendor rebate unit of measure for this transaction. This quantity comes from the rebate accrual records that were generated by the Generate Rebate Accrual process for the receipt, voucher, or RTV transaction. The rebateable quantity corresponds to the basis quantity for rebate calculation.

Purchase Order

Select the PO tab.

Purchase Order	Click this link to access the Purchase Order Inquiry - Purchase Order page. Use this page to view all the purchase order information that is associated with this purchase order.
Merchandise Amount	Displays the merchandise amount for this transaction.

Receipt

Select the Receipt tab.

Receiver ID Number

Click this link to access the Receipts inquiry page. Use this page to view all the details that are associated with this receipt.

Claim

Select the Claim tab.

Claim Number	Displays the claim number that is associated with the rebate accrual if the rebate accrual has already been processed by the claim generation. Click this link to access the Claim - Details page. Use this page to view all the information that is associated with this claim.
Total Claim Amount	Displays the total claim amount.
Total Claimed Amount	Displays the total claimed amount.

Viewing Rebate Threshold Analysis Information

Access the Vendor Rebate Analysis Workbench - Rebate Threshold Analysis page (after selecting transactions, then select Threshold & Time Period Anly in the Select Rows For field and click the OK button on the Vendor Rebate Analysis Workbench page).

View Results by Time Period

Select a time period, and then click the OK button to have the system redisplay the rebate threshold analysis information for that time period.

Next Threshold

Rebate ID	Click a rebate ID link to access the Rebate Agreement - Rebate Agreement page. Use this page to view all the details of this vendor rebate agreement.
Next Threshold Level	Displays the next threshold level amount or quantity depending on the rebate agreement rule definition. This threshold level is determined based on either the current rebateable amount or current rebateable quantity. Note. This field is applicable only for retrospective rebate rule types.
Estimated Additional Purchase Amount	Displays the estimated amount of purchases that are required to reach the next threshold level for the vendor rebate. Estimated Additional Purchase Amount = (Next Threshold Level − Current Rebateable Amount) Note. This field is applicable only for retrospective rebate rule types and amount based rules.
Estimated Additional Purchase Quantity	Displays the estimated quantity of purchases that are required to reach the next threshold level for the vendor rebate. Estimated Additional Purchase Quantity = (Next Threshold Level − Current Rebateable Quantity) Note. This field is applicable only for retrospective rebate rule types and quantity based rules.
Estimate Rebate Amount	Displays the estimated rebate amount if the next threshold is reached for the vendor rebate. This amount is based on the rebate agreement rule and the rule details. If the rebate factor qualifier is percentage and the rebate tier basis equals amount, then Estimate Rebate Amount = (Next Threshold Level (lower) Amount × Rebate Factor). If the rebate factor qualifier is percentage and the rebate tier basis equals quantity, then the estimated rebate amount cannot be determined because purchase amount cannot be determined. If the rebate factor qualifier is amount and the rebate tier basis equals amount or quantity, then Estimate Rebate Amount = (Rebate Factor of the Next Threshold Level + the sum of the rebate factor for all the lower threshold levels).
Total Open PO Amount (total open purchase order amount)	Click this linked value to access the Vendor Rebate Analysis Workbench - PO Not Received Analysis page. Use this page to view purchase order schedules that are associated with the vendor rebate that have not been received or vouchered.

Rebate Rule Details

Select the Rebate Rule Details tab.

Accrued Rebate Details for Rule

Click this link to access the Vendor Rebate Analysis Workbench - Accrued Rebate Details page. Use this page to view accrued rebate details for the vendor rebate agreement rule.

Current Rebate

Select the Current Rebate tab.

Current Rebateable Quantity	Displays the current rebateable quantity for the rebate agreement rule according to the filter options that you selected. Current rebateable quantity equals the sum of all the accepted quantity in the vendor rebate unit of measure.
Current Rebateable Amount	Displays the current rebateable amount for the rebate agreement rule according to the filter options that you selected. Current rebateable amount equals the sum of all rebateable amounts in the vendor rebate currency for all accrued details.
Total Accrued Rebate	Displays the total accrued rebate amount for the rebate agreement rule according to the filter options that you selected.
Total Purchases to Date	Displays the total purchases to date amount for the vendor rebate.

Time Period Analysis

Select the Time Period Analysis tab.

This section of the page is very dynamic. Depending on the time period that you select, you will view different time period columns in the List of Vendor Rebates group box. For example, if you select a monthly time period, you will view monthly columns with the rebate amount shown for each month.

The columns that appear on this page are based on the time period that you selected and the header start date and end date for the vendor rebate agreement. If the end date is in the future, the current system date is used.

Viewing Not Received Purchase Order Information

Access the Vendor Rebate Analysis Workbench - PO Not Received Analysis page (click the Total Open PO Amount link in the List of Vendor Rebates group box on the Vendor Rebate Analysis Workbench - Rebate Threshold Analysis page).

Total Purchases to Date

Displays the total purchases to date amount for this vendor rebate.

Total Open PO Amount (total open purchase order amount)

Displays the total open purchase order amount for this vendor rebate agreement rule.

Total Open PO Qty (total open purchase order quantity)

Displays the total open purchase order quantity for this vendor rebate agreement rule. The total open purchase order quantity is not relevant to the amount based rule.

Purchase Order

Click this link to access the Purchase Order Inquiry - Purchase Order page. Use this page to view the details for this purchase order.

Extracting Vendor Rebate Analysis to a File

Access the Vendor Rebate Analysis Workbench - Flat File Extraction on Rebate Transactions page (after selecting transactions, then select Extract Accrued Dtls to File in the Select Rows For field and click the OK button on the Vendor Rebate Analysis Workbench page).

Report Destination

Enter the location where you want the flat file to be stored.

Flat File Layout

The system creates the flat file using this file layout:

Field	Field Description
SETID	SetID
VRBT_ID	Vendor rebate ID
BUSINESS_UNIT_PO	Purchasing business unit
PO_ID	Purchase order ID
PO_LINE_NBR	Purchase order line number
PO_SCHED_NBR	Purchase order schedule number
VRBT_TRANS_TYPE	Vendor rebate transaction type
BUSINESS_UNIT	Business unit This is the business unit that is associated with the document ID. It can be a PeopleSoft Purchasing receiving business unit if the document ID is a receipt or a PeopleSoft Payables business unit if the document ID is a voucher.
DOC_ID	Document ID
LINE_NBR	Line number
RECV_SHIP_SEQ	Receiving shipment sequence number
SEQ_NUM	Sequence number
TRANS_DATE	Transaction date
ITM_SETID	Item set ID
INV_ITEM_ID	Item ID
CATEGORY_ID	Category ID
VENDOR_SETID	Vendor set ID
VENDOR_ID	Vendor ID
VRBT_TRANS_STATUS	Vendor rebate transaction status
MERCHANDISE_AMT	Merchandise amount
CURRENCY_CD	Currency code
VRBT_RULE_ID	Vendor rebate rule ID
VRBT_RULE_TYPE	Vendor rebate rule type
RBTABLE_AMT	Rebateable amount
RBTABLE_QTY	Rebateable quantity
UNIT_MEASURE_VRBT	Vendor rebate unit of measure
REBATE_AMOUNT	Rebate amount
TOTAL_CLAIMED_AM	Total claimed amount
CLAIM_ID	Claim ID
CLAIM_STATUS	Claim status
TOTAL_CLAIM_AMT	Total claim amount
TOT_CLAIM_VAT	Total claim value added tax amount
TOT_CLAIM_COLLEC	Total claim collected amount
TOT_VAT_COLLECT	Total value added tax collected amount
TOT_CLAIM_ADJ_AM	Total claim adjustment amount