Constraints

Column type
Metric
Feature level
Conditional
Allows nulls
Yes
Data type
Decimal
Value format
Numeric Format
Number range
Any valid non-negative decimal value

Description

The List Unit Price represents the suggested provider-published unit price for a single Pricing Unit of the associated SKU, exclusive of any discounts. This price is denominated in the Billing Currency. The List Unit Price is commonly used for calculating savings based on various rate optimization activities.

The ListUnitPrice column adheres to the following requirements:

  • ListUnitPrice MUST be present in a FOCUS dataset when the provider publishes unit prices exclusive of discounts.
  • ListUnitPrice MUST be of type Decimal.
  • ListUnitPrice MUST conform to NumericFormat requirements.
  • ListUnitPrice nullability is defined as follows:
    • ListUnitPrice MUST be null when ChargeCategory is "Tax".
    • ListUnitPrice MUST NOT be null when ChargeCategory is "Usage" or "Purchase" and ChargeClass is not "Correction".
    • ListUnitPrice MAY be null in all other cases.
  • When ListUnitPrice is not null, ListUnitPrice adheres to the following additional requirements:
    • ListUnitPrice MUST be a non-negative decimal value.
    • ListUnitPrice MUST be denominated in the BillingCurrency.
    • The product of ListUnitPrice and PricingQuantity MUST match the ListCost when PricingQuantity is not null and ChargeClass is not "Correction".
    • Discrepancies in ListUnitPrice, ListCost, or PricingQuantity MAY exist when ChargeClass is "Correction".
Read the source on focus.finops.org ↗