ListUnitPrice
List Unit Price · Cost and Usage dataset
- Feature level
- Conditional
- Data type
- Decimal
- Allows nulls
- Yes
- Column type
- Metric
What it is
The List Unit Price represents the suggested service-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.
Requirements (11)
Verbatim from the specification. These are the statements the validator checks against.
- ListUnitPrice MUST be of type Decimal.
- ListUnitPrice MUST conform to NumericFormat requirements.
- ListUnitPrice MUST adhere to the following nullability requirements:
- ListUnitPrice MUST be null when SkuPriceId is null.
- ListUnitPrice MUST be null when ChargeCategory is "Tax".
- ListUnitPrice MUST NOT be null when SkuPriceId is not null.
- 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 MUST adhere to the following requirements:
- ListUnitPrice MUST be a non-negative decimal value.
- ListUnitPrice MUST be denominated in the BillingCurrency.
Check your own export
The FOCUS 1.4 validator checks this column and 122 others against your file, in your browser, with no size cap and nothing uploaded.
Other Cost and Usage columns
Definition taken from the FOCUS 1.4 specification. FOCUS is published by the FinOps Foundation under CC BY 4.0.
One column is a definition. A pipeline is a project.
Finitizer ingests FOCUS from every provider you run and reports across all of them.