Understanding Inquiry Column Definition

To define which equipment cost information to review on the Equipment Cost Analysis program (P13801), you can use the Equipment Cost Analysis Inquiry Columns program (P13804) to set up the columns to include in the display. You can define inquiry columns for a variety of costs, including:

  • Actual labor

  • Actual material

  • Total maintenance

  • Budget total

  • For each column that you set up, you define a calculation formula that indicates how to calculate the amounts.

    The calculation formula is based on the defined classification codes that you set up for equipment cost analysis. The inquiry column definitions for the equipment cost analysis are stored in the Inquiry Columns table (F5192).

    Note: The Equipment Cost Analysis program enables you to include up to 10 columns of cost information in the display.

The cost classification codes that you use to use to create the formula are two-digit numeric codes with values ranging from 01 to 99. Ensure that you enter the leading zero where necessary. For example, 03+07+12 is a valid formula.