Constraints

Column type
Metric
Feature level
Mandatory
Allows nulls
No
Data type
Decimal
Value format
Numeric Format
Number range
Any valid decimal value

Description

List Cost represents the cost calculated by multiplying the list unit price and the corresponding Pricing Quantity. List Cost is denominated in the Billing Currency and is commonly used for calculating savings based on various rate optimization activities by comparing it with Contracted Cost, Billed Cost and Effective Cost.

The ListCost column adheres to the following requirements:

  • ListCost MUST be present in a FOCUS dataset.
  • ListCost MUST be of type Decimal.
  • ListCost MUST conform to NumericFormat requirements.
  • ListCost MUST NOT be null.
  • ListCost MUST be a valid decimal value.
  • ListCost MUST be denominated in the BillingCurrency.
  • When ListUnitPrice is null, ListCost adheres to the following additional requirements:
    • ListCost of a charge calculated based on other charges (e.g., when the ChargeCategory is "Tax") MUST be calculated based on the ListCost of those related charges.
    • ListCost of a charge unrelated to other charges (e.g., when the ChargeCategory is "Credit") MUST match the BilledCost.
  • The product of ListUnitPrice and PricingQuantity MUST match the ListCost when ListUnitPrice is not null, PricingQuantity is not null, and ChargeClass is not "Correction".
  • Discrepancies in ListCost, ListUnitPrice, or PricingQuantity MAY exist when ChargeClass is "Correction".
Read the source on focus.finops.org ↗