Special Processing in the Header

Include Cancelled Lines and Include Suspended Lines

You select the Include Cancelled Lines option to include information for cancelled contracts in the report. Contracts that do not have a blank value in the CN CD grid column are cancelled contracts. You specify the value for the CN CD grid column from the Cancellation Reason Code UDC table (17/CN).

You select the Include Suspended Lines option to include information for suspended contracts in the report. Contracts that do not have a blank value in the Bill Suspend Flag grid column are suspended contracts. You specify the value for the Bill Suspend Flag grid column from the Bill Suspend Reason Code UDC table (17/BS).

When you select the options for suspended and cancelled contracts, the search results will include these contracts along with other contracts unless you specifically filter for only these conditions. To report over only cancelled or suspended contracts, you can use the Query By Example (QBE) line to filter for these conditions or use the Advanced Query feature.

Days Past, Days Ahead, and Days to Analyze

You can define a time period to view contracts that have recently expired or are set to expire soon. Select the Days Past option to view contracts that have recently expired and enter the number of days you want to look back in the Days to Analyze field. For example, to view contracts that have expired within the last 30 days, select the Days Past option and enter "30" in the Days to Analyze field. The system includes the contracts that have expired within the last 30 days in the grid and these expired contracts have a value of "1" in the grid column Expired Contract.

To view contracts that are set to expire soon, select the Days Ahead option and enter the number of days counting from today to the day that you want to look up in the Days to Analyze field. The system considers today as the first day of the days ahead. The system includes the contracts that are set to expire according to your criteria in the header fields with a value of "1" in the Expiring Contract grid column.

If you select both Days Past and Days Ahead options, the system displays contracts that have recently expired and contracts that are set to expire in the grid. You can enter any number between (and including) zero and 366 in the Days to Analyze field.

When you select the options for expired and expiring contracts, the search results will include these contracts along with other contracts unless you specifically filter for only these conditions. The system includes only the contracts identified as expired or expiring in the Expired - Expiring Contracts Report.

As If Currency and As of Date

The One View Service Contract Inquiry application can report on contract amounts in a common currency. You can use the As If Currency and As of Date fields to convert contract amounts from domestic currency to a common currency. The system converts and subsequently populates the As If columns in the grid only if the As If Currency Code field has a valid value. The system uses the As of Date field to get the exchange rate to do the conversion. The As If Currency and As of Date fields are not filters for the grid column. If you are not using these fields, the conversion will not take place and the "As If" columns will not appear in the grid. You can convert four contract amounts to a common currency. These are Total Dollars, Daily Amortization Amount, Annualized Contract Amount, and Recurring Billing Amount.

The system enables you to compare contracts that are billed with different periodicity (monthly, quarterly, or annually) using the Annualized Contract Amount column. Special processing in this column multiplies the value in the Daily Amortization Amount column by 365 and converts it to an annualized amount, which enables you to compare all contracts assuming each contract lasted a year.