How are the values in PPA_WIP_VALUES computed?

Document ID : KB000022589
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

The Technical Reference Guide provides an explanation of the database schema for the fields in the PPA_WIP_VALUES table.
Here is an expanded explanation of the PPA_WIP_VALUES table and how the attributes are computed.

Solution:

PPA_WIP_VALUES TABLE COLUMNS

QUANTITY = Financial Transaction Entry Quantity
This could represent hours or units. This is the quantity entered on Timesheets or other Financial Transaction Entries.

NATURAL_STDCOST = Rate Matrix Standard Cost Value as it appears in UI
This is the Standard Cost value from the Rate Matrix Row - no computations are done for this field.

STDCOST = NATURAL_STDCOST * COST_EXCHANGE_RATE
If a single currency environment is configured, the Exchange Rate = 1.00
Otherwise, the Exchange Rate is calculated from the configuration for selected Currency Code, and Exchange Rate Type. Reference STDCOST_CURRENCY_CODE

NATURAL_ACTUALCOST = Rate Matrix Actual Cost Value as it appears in UI
This is the Actual Cost value from the Rate Matrix Row - no computations are done for this field.

ACTUALCOST = NATURAL_ACTUALCOST * COST_EXCHANGE_RATE
If a single currency environment is configured, the Exchange Rate = 1.00
Otherwise, the Exchange Rate is calculated from the configuration for selected Currency Code, and Exchange Rate Type. Reference COST_CURRENCY_CODE.

PRICE = Rate Matrix Actual Cost Value as it appears in UI
This is the Actual Cost value from the Rate Matrix Row - no computations are done for this field. (Same as NATURAL_ACTUALCOST)

TOTALCOST = ACTUAL_COST * QUANTITY

NATURAL_BILLRATE = Rate Matrix Rate Value as it appears in the UI **IF no Cost Plus Code is defined on the Rate Matrix Row**

If a Cost Plus Code is defined on the Rate Matrix Row for the Project's 'Rate' Matrix, then the NATURAL_BILLRATE does not use the Rate Matrix Rate Value, as described below:
NATURAL_BILLRATE = NATURAL_ACTUALCOST when a Cost Code applied to Actual Costs is defined on the Rate Matrix Row
NATURAL_BILLRATE = NATURAL_STDCOST when a Cost Code applied to Standard Costs is defined on the Rate Matrix Row

BILLRATE = NATURAL_BILLRATE * RATE_EXCHANGE_RATE
If a single currency environment is configured, the Exchange Rate = 1.00
Otherwise, the Exchange Rate is calculated from the configuration for selected Currency Code, and Exchange Rate Type.
Reference RATE_CURRENCY_CODE.

AMOUNT = BILLRATE * QUANTITY

When a Cost Plus Code is defined on the Rate Matrix Row that is used for calculating costs, the following fields are calculated, otherwise the value in the field is zero.

Cost Plus Codes are created in Administration Menu, Finance: Cost Plus Codes.
FACTORAMOUNT = AMOUNT * Cost Plus Multiplier
BURDEN = AMOUNT * Cost Plus Burden
OVERHEAD = AMOUNT * Cost Plus Overhead

TOTALAMOUNT = AMOUNT + FACTORAMOUNT + BURDEN + OVERHEAD