SkuPriceDetails
SKU Price Details · Cost and Usage dataset
- Feature level
- Conditional
- Data type
- JSON
- Allows nulls
- Yes
- Column type
- Dimension
What it is
SKU Price Details represent a list of SKU Price properties (key-value pairs) associated with a specific SKU Price ID. These properties include qualitative and quantitative properties of a SKUs (e.g., functionality and technical specifications), along with core stable pricing properties (e.g., pricing periods, tiers, etc.), excluding dynamic or negotiable pricing elements such as unit price amounts; currency (and related exchange rates); temporal validity (e.g., effective dates); and contract- or negotiation-specific factors (e.g., contract or account identifiers, and negotiable discounts). The composition of properties associated with a specific SKU Price may differ across service providers and across SKUs within the same service provider. However, the exclusion of dynamic or negotiable pricing properties should ensure that all charges with the same SKU Price ID share the same SKU Price
Requirements (25)
Verbatim from the specification. These are the statements the validator checks against.
- SkuPriceDetails MUST be of type JSON Object (serialized as a String where necessary).
- SkuPriceDetails MUST conform to StringHandling requirements.
- SkuPriceDetails MUST conform to KeyValueFormat requirements.
- SkuPriceDetails property keys SHOULD conform to PascalCase format.
- SkuPriceDetails MUST adhere to the following nullability requirements:
- SkuPriceDetails MUST be null when SkuPriceId is null.
- SkuPriceDetails MAY be null when SkuPriceId is not null.
- When SkuPriceDetails is not null, SkuPriceDetails MUST adhere to the following requirements:
- SkuPriceDetails MUST be associated with a given SkuPriceId.
- SkuPriceDetails MUST include the FOCUS-defined SKU Price property when an equivalent property is included as a custom property.
- SkuPriceDetails MUST NOT include properties that are not applicable to the corresponding SkuPriceId.
- SkuPriceDetails SHOULD include all FOCUS-defined SKU Price properties listed below that are applicable to the corresponding SkuPriceId.
- SkuPriceDetails SHOULD include all custom SKU Price properties that are applicable to the corresponding SkuPriceId when there is no equivalent FOCUS-defined property.
- SkuPriceDetails MAY include properties that are already captured in other dedicated columns.
- SkuPriceDetails properties for a given SkuPriceId MUST adhere to the following requirements:
- Existing SkuPriceDetails properties SHOULD remain consistent over time.
- Existing SkuPriceDetails properties SHOULD NOT be removed.
- Additional SkuPriceDetails properties MAY be added over time.
- Property key SHOULD remain consistent across comparable SKUs having that property, and the values for this key SHOULD remain in a consistent format.
- Property key MUST begin with the string "x" unless it is a FOCUS-defined property.
- Property value MUST represent the value for a single PricingUnit when the property holds a numeric value.
- FOCUS-defined SKU Price properties MUST adhere to the following requirements:
- Property key MUST match the spelling and casing specified for the FOCUS-defined property.
- Property value MUST be of the type specified for that property.
- Property value MUST represent the value for a single PricingUnit, denominated in the unit of measure specified for that property when the property holds a numeric value.
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.