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 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 amongst 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 to 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 available for vendor rebate analysis is dependent 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. PeopleSoft recommends you determine an appropriate frequency for the run of the process so that business requirements are met and the process is able to complete in a reasonable amount of time.

Vendor Rebate Analysis Process

To use the vendor rebate analysis workbench:

Select the vendor rebate agreements 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 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 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 selected.
  
  Select PO Not Received Report to generate the PO Not Received Report for the vendor rebates 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 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 only applicable for the threshold and time period analysis.
4. Click the OK button on the Vendor Rebate Analysis Workbench page.
5. View the information rendered by the processing action you requested.
  
  The process 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 selected.
  
  Use the Vendor Rebate Analysis Workbench - PO Not Received Report page to generate the PO Not Received report for the vendor rebates selected.
  
  Use the Vendor Rebate Analysis Workbench - Rebate Threshold Report page to generate the Rebate Threshold report for the vendor rebates 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 selected.
(Optional) Save this version of the Vendor Rebate Analysis Workbench for use at 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	Object Name	Navigation	Usage
Sales Organization Setup	VRBT_SLS_ORG_SETUP	Purchasing, Vendor Rebates, Vendor Rebate Analysis, Sales Organization Setup, 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 Organization

Access the Sales Organization Setup page.

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, it is required that you create a sales organization and associate this sales organization to the PeopleSoft Order Management business unit in order to perform vendor rebate allocations.

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

Establishing Vendor Rebate Allocations

This section discusses how to establish vendor rebate allocations.

Prerequisites

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

See Defining Sales Organizations.

Page Used to Establish Vendor Rebate Allocations

Page Name	Object Name	Navigation	Usage
Vendor Rebate Allocation	VRBT_ALLOC_DTLS	Purchasing, Vendor Rebates, Vendor Rebate Analysis, Vendor Rebate Allocation, Vendor Rebate Allocation	Allocate the earned rebate from the supplier to the sales organizations. This page is used 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.

Note. If the rebate manager does not have unrestricted access then they can only select vendor rebate agreements assigned to them.

See Defining Vendor Rebate Agreement Authorization.

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

Displays today's date by default. You can select another allocation date if you choose.

Amount to Allocate and Allocated Amount

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

When inserting 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 there are currently no other allocations for this vendor rebate agreement, the Total Rebate Payment Received amount appears by default. If there are other allocations the Amount Available to Allocate amount appears by default. You can enter a different amount if you choose.

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 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 purchase orders not received information.
Extract vendor rebate analysis to a file.

Pages Used to Analyze Vendor Rebates

Page Name	Object 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 vendor rebate agreement analysis.
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. 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. Click the Accrued Rebate Details for Rule link in the List of Vendor Rebates group box under 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 under the PO tab on the Vendor Rebate Analysis Workbench - Accrued Rebate Details 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 under 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.	Perform rebate agreement threshold analysis. Threshold analysis assists rebate managers in analyzing the extent of additional purchases 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 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.	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.	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.	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 particular vendor rebate analysis workbench for later retrieval and use.

Selecting Vendor Rebates For Analysis

Access the Vendor Rebate Analysis Workbench - Workbench Filter Options page.

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 you want to analyze on the workbench. Only approved vendor rebate agreements are available for selection. Also, the vendor rebate agreements available for selection is determined by the rebate manager's access right. If you are a rebate manager that does not have unrestricted access then you can only view and select your rebate agreements. If you are a rebate manager and have unrestricted access then you can view and select any rebate agreements 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 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 associated with the vendor rebate agreement on the Vendor Rebate Analysis Workbench.
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 selected.

Using the Vendor Rebate Analysis Workbench

Access the Vendor Rebate Analysis Workbench page.

Select Rows For

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

Extract Accrued Dtls to File: When you select this option 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 option 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 option 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 option along with a view results by time period option the Rebate Threshold and Time Period Analysis page appears populated with the vendor rebate information associated with the vendor rebates 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 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 will occur.

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 only available 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 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 Amt on Sel Trans equals the sum of transaction line rebate amounts on the Vendor Rebate Analysis Workbench - Accrued Rebate Details page that matches the filter options selected.
Total Claim Collected	Displays the total claim collected amount in the rebate currency. Total Claim Collected equals the sum of Total Claimed Amount for all claims associated to the transaction lines on the Vendor Rebate Analysis Workbench - Accrued Rebate Details page that matches the filter options selected.
Total VAT Claim Collected (total value added tax claim collected)	Displays the total VAT claim collected amount in the rebate currency. Total VAT Claim Collected equals the sum of Total Claimed Collected VAT amount for all claims associated to the transaction lines on the Vendor Rebate Analysis Workbench - Accrued Rebate Details page that matches the filter options selected.
Total Claim Adjustment	Displays the total claim adjustment amount. Total Claim Adjustment equals the sum of the difference between the Total Claim Amount minus the original total claim amount for each claim associated to the transaction lines on the Vendor Rebate Analysis Workbench - Accrued Rebate Details page that matches the filter options 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 rebate amount for the vendor rebate agreement.
Total Rebate Payment Received	Displays the total rebate payment received amount for the vendor rebate agreement.
Total Pending Rebate Amount	Displays the total pending rebate 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 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. 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.

Rebate Details

Displays the rebate accruals generated by the Generate Rebate Accrual process for the rebate agreement selected and according to the filter options 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 rebate accruals generation time, then the transaction status is Received. If the voucher was available for the receipt transaction at the rebate accruals generation time 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 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 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 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 associated with this receipt.

Claim

Select the Claim tab.

Claim Number	Displays the claim number associated to 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 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.

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 only applicable for retrospective rebate rule types.
Estimated Additional Purchase Amount	Displays the estimated amount of purchases 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 only applicable for retrospective rebate rule types and amount rule based.
Estimated Additional Purchase Quantity	Displays the estimated quantity of purchases 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 only applicable for retrospective rebate rule types and quantity rule based.
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 estimate rebate amount cannot be determined since 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 tied to 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 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 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 vendor rebate for the rebate agreement rule according to the filter options 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 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 display on this page are based on the time period selected and the vendor rebate agreement header start date and end date. If the end date is in the future the current system date is used.

Viewing Purchase Orders Not Received Information

Access the Vendor Rebate Analysis Workbench - PO Not Received 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.

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 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