Special Processing in the Calculated Grid Columns

The system retrieves information from several sources to identify the revenues and costs associated with service contracts. When this information is retrieved, the system writes a grid record for each service contract that does not have specific revenue or cost information. The report ignores these rows but they are necessary as part of the processing. A service contract is defined as the unique combination of Contract Number, Contract Change Number, and Line Number. The Profitability Factor Type and Profitability Factor Source columns are quick ways to identify non-informative rows from the ones used in the reports. These columns will not have any value for the rows that do not contain information.

The system records information in the grid columns that is related to the special processing considerations in the header. These columns facilitate reporting over data that is not available in the database in a form easy to report on. The report delivered with the application is possible because of these columns. You can also use them when defining custom reports.

The One View Service Contract Profitability Inquiry application uses the following special processing in these calculated columns in the grid:

  • Profitability Factor Type

    Use this column to identify whether the grid row contains information that impacts profitability and if so, the type of profitability information that it contains. Revenue and Cost are the two types of profitability factors. A blank value in this column indicates that the grid row does not contain information that the system will use when determining profitability.

  • Profitability Factor Source

    Use this column to identify the source of the amount included in the profitability calculation. Service Contracts and Service Work Orders are the two types of sources. A blank value in this column indicates that the grid row does not contain information that the system will use when determining profitability.

  • Type of Contracts Included

    The value in this column indicates the type of contract that you have included for analysis. Values can be Cancelled, Suspended, Both, or None.

  • One View Common Summary

    Special processing in this column ensures that a common value is shared across all grid records on One View Reporting applications. The system uses this column along with the BIP Editor for certain summary needs. This column is not meaningful by itself and the system assigns a value of blank to this column for each record in the grid.

  • As If Currency Code

    The system populates this column with the currency code from the As If Currency field in the header. The system will not display this column if the As If Currency and As of Date fields in the header have a blank value.

  • As of Date

    The system populates this column with the date from the As of Date field in the header. The system uses this date to get the exchange rate to convert amounts from domestic currency to a common currency. The system will not display this column if the As If Currency and the As of Date fields in the header have a blank value.

  • Revenue Amount

    This is the revenue amount for the contract generated from service contract billing or service work order billing. The system retrieves this amount from the Billing Detail Workfile (F4812) and the Billing Workfile History (F4812H) tables. If the revenue amount comes from service contract billings, the system displays the net amount of all revenues and credits for all service contract billings for a contract in a single grid row. If the revenue amount comes from service work order billings, the system displays the net amount of all the parts and labor billing records related to each work order in individual grid rows and displays the work order number in the Work Order Number column. The system applies this special processing to all service work orders that are entitled against this contract and has billed revenue.

  • As If Revenue Amount

    This is the revenue amount converted to a common currency. The system will not display this column if the As If Currency and the As of Date fields in the header have a blank value.

  • Invoiced Amount

    This is the invoiced amount for the contract coming from the service contract billing or the service work order billing. The only difference between this column and the Revenue Amount column is that Invoiced Amount include taxes and Revenue Amount does not.

  • As If Invoiced Amount

    This is the invoiced amount converted to a common currency. The system will not display this column if the As If Currency and the As of Date fields in the header have a blank value.

  • Actual Labor

    This is the total labor cost associated with a service work order that is entitled against the contract. The system retrieves this amount from the Work Order Master table (F4801) and displays the labor costs for each service work order entitled against the contract in separate grid rows. The value in the Work Order Number column is the work order number associated with each service work order.

  • As If Actual Labor

    This is the actual labor amount converted to a common currency. The system will not display this column if the As If Currency and the As of Date fields in the header have a blank value.

  • Actual Material

    This is the total cost of material (parts) associated with a service work order that is entitled against the contract. The system retrieves this amount from the Work Order Master table (F4801) and displays the material cost for each service work order entitled against the contract in separate grid rows. The value in the Work Order Number column is the work order number associated with each service work order.

  • As If Actual Material

    This is the actual material cost converted to a common currency. The system will not display this column if the As If Currency and the As of Date fields in the header have a blank value.

  • Actual Other

    This is the total other cost associated with a service work order that is entitled against the contract. The system retrieves this amount from the Work Order Master table (F4801) and displays the other cost for each service work order entitled against the contract in separate grid rows. The value in the Work Order Number column is the work order number associated with each service work order.

  • As If Actual Other

    This is the actual other cost converted to a common currency. The system will not display this column if the As If Currency and the As of Date fields in the header have a blank value.

  • Actual Dollars

    This is the total costs (labor, material and other costs) associated with a service work order that is entitled against the contract. The system retrieves this amount from the Work Order Master table (F4801) and displays the total cost for each service work order entitled against the contract in separate grid rows. The value in the Work Order Number column is the work order number associated with each service work order.

  • As If Actual Dollars

    This is the actual dollar amount converted to a common currency. The system will not display this column if the As If Currency and the As of Date fields in the header have a blank value.

  • Work Order Number

    This column records the work order number for the service work order that is entitled against the contract and for which you want to analyze associated costs and revenues.

Note: The system retrieves revenue and costs for service contracts and service work orders and displays the information in the grid. For revenue billed against a service contract, the system nets the amount for all revenue and credits and displays it in a single grid row. For revenue and cost coming from service work order billings, the system the system uses a grid row for each work order to display revenue from billing and a separate grid row to display cost from billing. To analyze total contract profitability, you must consider the revenue and costs from both service contracts and service work orders entitled against the contract.