Jaa

FinOps toolkit data dictionary

  • Artikkeli

This article describes column names found in FinOps toolkit solutions. Most of the columns in FinOps toolkit solutions originate in Cost Management or the FinOps Open Cost and Usage Specification (FOCUS).

List of terms

The following table includes columns you can expect to see in FinOps toolkit solutions. For simplicity, the data dictionary doesn't include the x_ prefix used to denote "external" or non-FOCUS columns, so x_AccountName is listed under AccountName.

Quick links: A   B   C   D   E

  I

  L   M   N   O   P

  R   S   T   U

Name Description
AccountName Name of the identity responsible for billing for this subscription. It's your EA enrollment account owner or Microsoft Online Subscription Agreement (MOSA) account admin. Not applicable to a Microsoft Customer Agreement (MCA).
AccountOwnerId Email address of the identity responsible for billing for this subscription. It's your EA enrollment account owner or MOSA account admin. Not applicable to MCA.
AvailabilityZone Area within a resource location used for high availability. Not available for all services. Not included in Microsoft Cloud cost data.
BilledCost Amount owed for the charge after any applied discounts. If using FinOps hubs, you need to include the Cost Management connector to see all billed costs. Maps to CostInBillingCurrency for actual cost in Cost Management.
BilledCostInUsd BilledCost in USD.
BilledPricingCost BilledCost in the pricing currency.
BillingAccountAgreement Derived. Indicates the type of account. Allowed values: EA, MCA, MG, MOSA, MPA.
BillingAccountId Unique identifier for the billing account. "BillingAccount" columns map to the EA billing account and MCA billing profile. x_BillingAccount is the same as Cost Management.
BillingAccountName Name of the billing account. "BillingAccount" columns map to the EA billing account and MCA billing profile. x_BillingAccount is the same as Cost Management.
BillingAccountType Indicates whether the BillingAccountId represents an EA billing account or MCA billing profile.
BillingCurrency Currency code for all price and cost columns.
BillingExchangeRate Exchange rate to multiply by when converting from the pricing currency to the billing currency.
BillingExchangeRateDate Date the exchange rate was determined.
BillingPeriodEnd Exclusive end date of the invoice period. Usually the first of the next month at midnight.
BillingPeriodStart First day of the invoice period. Usually the first of the month.
BillingProfileId Unique identifier of the scope that invoices are generated for. EA billing account or MCA billing profile.
BillingProfileName Name of the scope that invoices invoices are generated for. EA billing account or MCA billing profile.
CapacityCommitmentId Unique identifier of the capacity commitment, if applicable. Only available for virtual machines.
ChargeCategory Highest-level classification of a charge based on the nature of how it gets billed. Allowed values: Usage, Purchase, Credit, Adjustment, Tax. Maps to ChargeType in Cost Management.
ChargeClass Indicates whether the row represents a correction to one or more charges invoiced in a previous billing period. Allowed values: Correction.
ChargeDescription Brief, human-readable summary of a row.
ChargeFrequency Indicates how often a charge occurs. Allowed values: One-Time, Recurring, Usage-Based. Maps to Frequency in Cost Management.
ChargeId Derived. Unique identifier (GUID) of the charge.
ChargePeriod Derived. Used in Power BI to summarize the charge period range from the ChargePeriodStart to ChargePeriodEnd.
ChargePeriodEnd End date and time of a charge period.
ChargePeriodStart Beginning date and time of a charge period. Maps to Date in Cost Management.
~ChargeSubcategory~ (removed) Indicates the kind of usage or adjustment the row represents. Maps to ChargeType in Cost Management. Deprecated with in v0.4 to align with FOCUS 1.0. Use ChargeCategory, ChargeClass, or CommitmentDiscountStatus.
CommitmentDiscountKey Derived. Unique key used to join with instance size flexibility data.
CommitmentDiscountCategory Derived. Indicates whether the commitment-based discount identified in the CommitmentDiscountId column is based on usage quantity or cost (also known as "spend"). Allowed values: Usage, Spend.
CommitmentDiscountId Unique identifier (GUID) of the commitment-based discount (for example, reservation, savings plan) this resource utilized. Maps to BenefitId in Cost Management.
CommitmentDiscountName Name of the commitment-based discount (for example, reservation, savings plan) this resource utilized. Maps to BenefitName in Cost Management.
CommitmentDiscountNameUnique Derived. Unique name of the commitment (for example, reservation, savings plan), including the ID for uniqueness.
CommitmentDiscountSavings Derived. Used in Power BI to sum the amount saved from commitment discounts only. Does not include savings from negotiated discounts. Formula: ContractedCost - EffectiveCost.
CommitmentDiscountStatus Indicates whether the charge corresponds with the consumption of a commitment-based discount or the unused portion of the committed amount.
CommitmentDiscountType Derived. Label assigned by the provider to describe the type of commitment-based discount applied to the row. Allowed values: Reservation, Savings Plan.
CommitmentCostSavings See CommitmentDiscountSavings.
CommitmentCostSavingsRunningTotal Derived. Calculates the accumulated or running total of CommitmentCostSavings for the day, including all previous day's values.
CommitmentUnitPriceSavings Derived. Amount the unit price was reduced for commitment discounts. Does not include negotiated discounts. Formula: ContractedUnitPrice - x_EffectiveUnitPrice.
CommitmentUtilization Derived. Calculates the commitment utilization percentage for the period. Calculated as the sum of CommitmentUtilizationAmount divided by the sum of CommitmentUtilizationPotential.
CommitmentUtilizationAmount Derived. Amount of utilized commitment for the record, if the charge was associated with a commitment. Uses cost for savings plans and quantity for reservations.
CommitmentUtilizationPotential Derived. Amount that could have been applied to a commitment, but might not have been. It's generally the same as CommitmentUtilizationAmount, except for the unused charges. Uses cost for savings plans and quantity for reservations.
ConsumedQuantity Volume of a given SKU associated with a resource or service used, based on the Consumed Unit.
ConsumedUnit Provider-specified measurement unit indicating how a provider measures usage of a given SKU associated with a resource or service. Maps to UnitOfMeasure in Cost Management.
ConsumedService Azure Resource Manager resource provider namespace.
ContractedCost Cost calculated by multiplying contracted unit price and the corresponding Pricing Quantity.
ContractedUnitPrice The agreed-upon unit price for a single Pricing Unit of the associated SKU, inclusive of negotiated discounts, if present, while excluding negotiated commitment-based discounts or any other discounts.
CostAllocationRuleName Name of the Microsoft Cost Management cost allocation rule that generated this charge. Cost allocation is used to move or split shared charges.
CostCenter Custom value defined by a billing admin for internal chargeback.
CustomerId Cloud Solution Provider (CSP) customer tenant ID.
CustomerName Cloud Solution Provider (CSP) customer tenant name.
DiscountCostSavings See TotalSavings.
DiscountCostSavingsRunningTotal Derived. Calculates the accumulated or running total of DiscountCostSavings for the day, including all previous day's values.
DiscountUnitPriceSavings Derived. Amount the unit price was discounted compared to public, list prices. If 0 when there are discounts, it means the list price and cost weren't provided by Cost Management. Formula: ListUnitPrice - x_EffectiveUnitPrice.
EffectiveCost BilledCost with commitment purchases spread across the commitment term. See Amortization. Maps to CostInBillingCurrency for amortized cost in Cost Management.
EffectiveCostInUsd EffectiveCost in USD.
EffectiveCostPerResource Derived. Used in Power BI to calculate the average EffectiveCost for each unique resource ID. This is a simple average. Formula = SUM(EffectiveCost) / DCOUNT(ResourceId). This does not account for all free resources and may include nested, child resources or deleted resources.
EffectiveCostRunningTotal Derived. Used in Power BI to calculate the total EffectiveCost for the reporting period up to and including the specified day. For instance, the cost for the 15th will include the cost from the 1st through the 15th.
EffectivePricingCost EffectiveCost in the pricing currency.
EffectiveUnitPrice Amortized price per unit after commitment discounts.
IncrementalRefreshDate Derived. Numeric version of the ChargePeriodStart column to simplify setup for incremental refresh.
InvoiceId Unique identifier for the invoice the charge is included in. Only available for closed months after the invoice is published.
InvoiceIssuerId Unique identifier of the organization that generated the invoice.
InvoiceIssuerName Name of the organization that generated the invoice. Only supported for CSP accounts. Not supported for EA or MCA accounts that a partner manages due to data not being provided by Cost Management.
InvoiceSectionId Unique identifier (GUID) of a section within an invoice used for grouping related charges. Represents an EA department. Not applicable for MOSA.
InvoiceSectionName Name of a section within an invoice used for grouping related charges. Represents an EA department. Not applicable for MOSA.
IsCreditEligible Indicates if this charge can be deducted from credits. May be a string (True or False in legacy datasets). Maps to IsAzureCreditEligible in Cost Management.
IsFree Derived. Indicates if this charge is free and has 0 BilledCost and 0 EffectiveCost. If the charge shouldn't be free, contact support because it's likely an inaccurate or incomplete data in Cost Management.
ListCost Derived if not available. List (or retail) cost without any discounts applied.
ListCostInUsd ListCost in USD.
ListUnitPrice List (or retail) price per unit. If the same as OnDemandUnitPrice when there are discounts, this means list price and cost weren't provided by Cost Management.
Month Derived. Month of the charge.
NegotiatedCostSavings See NegotiatedDiscountSavings.
NegotiatedCostSavingsRunningTotal Derived. Calculates the accumulated or running total of NegotiatedCostSavings for the day, including all previous day's values.
NegotiatedDiscountSavings Derived. Used in Power BI to sum the amount saved after negotiated discounts are applied but excluding commitment discounts. Formula: ListCost - ContractedCost.
NegotiatedUnitPriceSavings Derived. Amount the unit price was reduced after negotiated discounts were applied to public, list prices. Doesn't include commitment discounts. Formula: ListUnitPrice - ContractedUnitPrice.
~OnDemandCost~ (removed) Derived. Cost based on UnitPrice (with negotiated discounts applied, but without commitment discounts). Calculated as Quantity multiplied by UnitPrice. Renamed to ContractedCost in v0.4 to align with FOCUS 1.0.
~OnDemandUnitPrice~ (removed) Derived. On-demand price per unit without any commitment discounts applied. If it's the same as EffectivePrice, it means EffectivePrice wasn't provided by Cost Management. Renamed to ContractedUnitPrice in v0.4 to align with FOCUS 1.0.
PartnerCreditApplied Indicates when the Cloud Solution Provider (CSP) Partner Earned Credit (PEC) was applied for a charge.
PartnerCreditRate Rate earned based on the Cloud Solution Provider (CSP) Partner Earned Credit (PEC) applied.
PartnerId Unique identifier of the Cloud Solution Provider (CSP) partner.
PartnerName Name of the Cloud Solution Provider (CSP) partner.
PricingBlockSize Derived. Indicates what measurement type is used by the PricingQuantity. Extracted from UnitOfMeasure in Cost Management.
PricingCategory Describes the pricing model used for a charge at the time of use or purchase. Allowed values: Standard, Dynamic, or Committed.
PricingCurrency Currency used for all price columns.
PricingQuantity Derived. Amount of a particular service that got used or purchased based on the PricingUnit. PricingQuantity is the same as UsageQuantity divided by x_PricingBlockSize.
PricingSubcategory Describes the kind of pricing model used for a charge within a specific PricingCategory.
PricingUnit Derived. Indicates what measurement type is used by the PricingQuantity. Extracted from UnitOfMeasure in Cost Management.
PricingUnitDescription Describes the measurement type is used by the PricingQuantity. Maps to UnitOfMeasure in Cost Management.
PublisherCategory Indicates whether a charge is from a cloud provider or third-party Marketplace vendor. Allowed values: Cloud Provider and Vendor. Maps to PublisherType in Cost Management.
PublisherId Unique identifier for the organization that created the product that got used or purchased.
PublisherName Name of the organization that created the product that got used or purchased.
~Region~ (removed) Isolated geographic area where a resource is provisioned in and/or a service is provided from. Replaced with RegionId and RegionName in v0.4 to align with FOCUS 1.0.
RegionId Provider-assigned identifier for an isolated geographic area where a resource is provisioned or a service is provided.
RegionName Name of an isolated geographic area where a resource is provisioned or a service is provided.
ReportingDate Derived. Used in Power BI reports to handle daily vs. monthly reporting. If daily, it is the start of the day for ChargePeriodStart. If monthly, it is the start of the month for ChargePeriodStart.
ResellerId Unique identifier for the Cloud Solution Provider (CSP) reseller. Maps to ResellerMpnId in Cost Management.
ResellerName Name of the Cloud Solution Provider (CSP) reseller.
ResourceGroupId Derived. Unique identifier for the ResourceGroupName.
ResourceGroupName Grouping of resources that make up an application or set of resources that share the same lifecycle (for example, created and deleted together).
ResourceGroupNameUnique Derived. Unique name of the resource, including the subscription name for uniqueness.
ResourceId Unique identifier for the resource. May be empty for purchases.
ResourceMachineName Derived. Extracted from x_SkuDetails. Used for Azure Hybrid Benefit reports.
ResourceName Name of the cloud resource. May be empty for purchases.
ResourceNameUnique Derived. Unique name of the resource, including the resource ID for uniqueness.
ResourceParentId Derived. Unique identifier for the logical resource parent as defined by the cm-resource-parent, ms-resource-parent, and hidden-managedby tags.
ResourceParentName Derived. Name of logical resource parent (ResourceParentId).
ResourceParentType Derived. The kind of resource the logical resource parent (ResourceParentId) is. Uses the Azure Resource Manager resource type and not the display name.
ResourceType The kind of resource for which you're being charged. ResourceType is a friendly display name. x_ResourceType is the Azure Resource Manager resource type code.
SchemaVersion Derived. Version of the Cost Management cost details schema that was detected during ingestion.
ServiceCategory Top-level category for the ServiceName. This column aligns with the FOCUS requirements.
ServiceName Name of the service the resource type is a part of. This column aligns with the FOCUS requirements.
SkuCPUs Derived. Indicates the number of virtual CPUs used by this resource. Extracted from x_SkuDetails. Used for Azure Hybrid Benefit reports.
SkuDetails Additional information about the SKU. This column is formatted as a JSON object. Maps to AdditionalInfo in Cost Management.
SkuId Unique identifier for the product that got used or purchased. Maps to ProductId in Cost Management for MCA.
SkuImageType Derived. Extracted from x_SkuDetails. Used for Azure Hybrid Benefit reports.
SkuLicenseCPUs Derived. Indicates the number of virtual CPUs required from on-premises licenses required to use Azure Hybrid Benefit for this resource. Extracted from x_SkuDetails.
SkuLicenseStatus Derived. Indicates whether the charge used or was eligible for Azure Hybrid Benefit. Extracted from x_SkuDetails.
SkuMeterCategory Represents a cloud service, like Virtual machines or Storage.
SkuMeterId Unique identifier (sometimes a GUID, but not always) for the usage meter. It usually maps to a specific SKU or range of SKUs that have a specific price.
SkuMeterName Name of the usage meter. It usually maps to a specific SKU or range of SKUs that have a specific price. Not applicable for purchases.
SkuMeterRegion Geographical area associated with the price. If empty, the price for this charge isn't based on region. It can differ from RegionId and RegionName.
SkuMeterSubCategory Groups service charges of a particular type. Sometimes used to represent a set of SKUs (for example, VM series) or a different type of charge (for example, table vs. file storage). Can be empty.
SkuName Product that got used or purchased.
SkuOfferId Microsoft Cloud subscription type.
SkuOrderId Maps to ProductOrderId in Cost Management.
SkuOrderName Maps to ProductOrderName in Cost Management.
SkuPartNumber Identifier to help separate specific usage meters.
SkuPlanName Represents the pricing plan or SKU.
SkuPriceId Unique identifier for the product that got used or purchased inclusive of other pricing variations, like tiering and discounts. Maps to {ProductId}_{SkuId}_{MeterType} in the price sheet for MCA.
SkuServiceFamily Groups service charges based on the core function of the service. Can be used to track the migration of workloads across fundamentally different architectures, like IaaS and PaaS data storage. As of February 2023, there's a bug for EA where it's always Compute.
SkuTerm Number of months a purchase covers. Only applicable to commitments today.
SkuTermLabel Derived. User-friendly display text for x_SkuTerm.
SkuType Derived. Extracted from x_SkuDetails and renamed from ServiceType. Used for Azure Hybrid Benefit reports.
SkuUsageType Derived. Extracted from x_SkuDetails. Used for Azure Hybrid Benefit reports.
SkuVMProperties Derived. Extracted from x_SkuDetails. Used for Azure Hybrid Benefit reports.
SourceChanges Derived. List of codes that indicate changes made to this row to address data quality issues.
SourceType Derived. Indicates the type of data exported from Cost Management. Allowed values: ActualCost, AmortizedCost, FocusCost, PriceSheet, ReservationDetails, ReservationRecommendations, ReservationTransactions.
SourceVersion Derived. Indicates the schema version of the dataset that was exported from Cost Management.
SubAccountId See SubscriptionId.
SubAccountName See SubscriptionName.
SubAccountType Indicates the type of SubAccountId. Always "Subscription" today.
SubscriptionId Unique identifier (GUID) of the Microsoft Cloud subscription.
SubscriptionName Name of the Microsoft Cloud subscription.
SubscriptionNameUnique Derived. Unique name of the subscription, including the ID for uniqueness.
Tags Derived. Custom metadata (key/value pairs) applied to the resource or product the charge applies to. Formatted as a JavaScript object (JSON). Microsoft Cost Management has a bug where it's missing the outer braces, so that is fixed in Power Query.
TagsDictionary Derived. Object version of Tags.
ToolkitTool Derived. Name of the tool in the FinOps toolkit the resource supports.
ToolkitVersion Derived. Version of the tool in the FinOps toolkit the resource supports.
TotalSavings Derived. Used in Power BI to sum the total amount saved after negotiated and commitment discounts are applied. Will be negative for unused commitments. Formula: ListCost - EffectiveCost.
UsageCPUHours Derived. Total vCPU hours used by this resource. Calculated as vCPUs multiplied by UsageQuantity. Used for Azure Hybrid Benefit reports.
UsageQuantity Number of units of a resource or service that got used or purchased based on the UsageUnit. Replaced by ConsumedQuantity in v0.4 to align with FOCUS 1.0.
UsageUnit Indicates what measurement type is used by the UsageQuantity. Replaced by ConsumedUnit in v0.4 to align with FOCUS 1.0.

For details about limitations with the Microsoft Cost Management FOCUS dataset, please refer to the FOCUS conformance summary.


Generating a unique ID

To generate a unique ID, use the following columns in the Cost Management FOCUS dataset:

  • BillingAccountId
  • ChargePeriodStart
  • CommitmentDiscountId
  • RegionId
  • ResourceId
  • ResourceName
  • SkuPriceId
  • SubAccountId
  • Tags
  • x_AccountOwnerId
  • x_CostCenter
  • x_InvoiceSectionId
  • x_ResourceGroupName
  • x_SkuDetails
  • x_SkuMeterId
  • x_SkuOfferId
  • x_SkuPartNumber

Feedback about FOCUS columns

If you have feedback about our mappings or about our full FOCUS support plans, start a thread in FinOps toolkit discussions. If you believe you have a bug, create an issue.

If you have feedback about FOCUS, create an issue in the FOCUS repository. We also encourage you to consider contributing to the FOCUS project. The project is looking for more practitioners to help bring their experience to help guide efforts and make it the most useful spec it can be. To learn more about FOCUS or to contribute to the project, visit focus.finops.org.


Related content

Related resources:

Related FinOps capabilities:

Related products:

Related solutions: