Special Processing in the Calculated Grid Columns

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 reports delivered with the application are possible because of these columns. You can also use them when defining custom reports.

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

• Date Analyze From

  This is the starting date that the system uses to analyze expired rental contracts. The system determines this date based on today's date, the value in the Days to Analyze field, and whether the Days Past option is selected. For example, if you select the Days Past option to analyze rental contracts that have expired in the last ten days, the value in this column is today's date minus ten.

• Date Analyze Through

  This is the ending date that the system uses to analyze expiring rental contracts. The system determines this date based on today's date, the value in the Days to Analyze field, and whether the Days Ahead option is selected. The system considers today as the first day of the days ahead. For example, if you select the Days Ahead option to analyze rental contracts expiring in the next ten days, this date is today's date plus ten minus one (or today's date plus nine).

• Expired Contract

  You select the Days Past option and use the value in the Days to Analyze field in the header to filter information for expired rental contracts in the grid. The system selects this column to indicate that this is an expired contract that you can analyze.

• Expiring Contract

  You select the Days Ahead option and use the value in the Days to Analyze field in the header to filter information for expiring contracts in the grid. The system selects this column to indicate that this is an expiring contract that you can analyze.

• Days to Analyze

  This represents the number of days that the system uses to look back or look ahead when building the date range to include either or both expired and expiring contracts for analysis. The system populates this column with the value from the Days to Analyze field in the header.

• Days Past

  The system selects this column to indicate that the rental contract has expired. You can select the Days Past option and use the Days to Analyze field in the header to filter information for contracts that have expired in the last number of days entered in the Days to Analyze field.

• Days Ahead

  The system selects this column to indicate that the contract is set to expire. You can select the Days Ahead option and use the Days to Analyze field in the header to filter information for contracts that are expiring from today to the number of days in the future entered in the Days to Analyze field. The system considers today as the first day of the days ahead. For example, if you have selected the Days Ahead header option and set the Days to Analyze to seven, the system includes contracts that are expiring today and contracts that will expire in the next six days in the grid.

• Extended Amount

  This is the unit price multiplied by the number of units.

• As If Extended Amount

  This is the extended amount converted to a common currency. The extended amount is the unit price multiplied by the number of units. The system calculates the As If Extended Amount using the currency code in the As If Currency Code field and the exchange rate that the system retrieves using the value in the As of Exchange Rate Date field.

• Number of Billing Days

  The number of days in the contract based on the billing start date and the billing end date.

• Daily Rate

  The daily rate for the contract. This is the total contract amount divided by the total number of billing days.

• Total Contract

  The total contract amount for the contract. The system uses the number of billing days and the Billing Unit of Measure (UOM) to determine the basis for calculating the total contract amount.

  For example, if the Billing UOM is monthly, the system divides the extended amount (quantity multiplied by unit price) by 30 days, and multiplies the result by the number of billing days to derive a daily rate. For a weekly billing UOM, the system uses 7 days for the calculation. The system divides the daily rate by the number of billing days to determine the total contract amount.