runbooks finops ↔ FOCUS 1.2 Column Mapping
This page maps each FOCUS 1.2 normative column to the corresponding runbooks finops CLI output field and command that produces it.
How to Use This Mapping
- Select a FOCUS column from the left column
- Identify the runbooks field that supplies it (middle column)
- Run the CLI command in the right column to extract that field from your data
- Coverage summary at the end shows overall FOCUS compliance
Billing Dimensions
| FOCUS Column |
runbooks finops Field |
CLI Command |
Notes |
| BillingAccountId |
billing_account_id |
runbooks finops export-raw --field billing_account_id |
AWS: BillingAccountId from CUR; Azure: BillingProfileId |
| BillingAccountName |
billing_account_name |
runbooks finops export-raw --field billing_account_name |
Human-readable account alias |
| BillingPeriodStart |
billing_period_start |
runbooks finops export-raw --field billing_period_start |
ISO 8601 format |
| BillingPeriodEnd |
billing_period_end |
runbooks finops export-raw --field billing_period_end |
ISO 8601 format |
| SubAccountId |
linked_account_id, subscription_id |
runbooks finops export-focus --format csv |
AWS: LinkedAccountId; Azure: SubscriptionId |
| SubAccountName |
linked_account_name, subscription_name |
runbooks finops export-focus --format csv |
Resolved from Account/Subscription tags |
| Provider |
provider |
runbooks finops export-focus --field provider |
"AWS" or "Microsoft Azure" |
| Publisher |
publisher |
runbooks finops export-focus --field publisher --include-reseller |
N/A for direct AWS/Azure (set to provider name) |
Service & Resource Identification
| FOCUS Column |
runbooks finops Field |
CLI Command |
Notes |
| ServiceName |
service_name, product_name |
runbooks finops export-focus --format csv |
AWS: productName; Azure: MeterCategory |
| ServiceCategory |
service_category, service_code |
runbooks finops export-focus --format csv |
AWS: servicecode; Azure: ServiceFamily |
| ResourceId |
resource_id |
runbooks finops export-focus --format csv |
ARN or Azure resource ID |
| ResourceName |
resource_name, resource_tags |
runbooks finops export-focus --include-tags --format csv |
Resolved from resource tags or ID |
| ResourceType |
resource_type, instance_type |
runbooks finops export-focus --format csv |
AWS: instanceType; Azure: MeterSubCategory |
| Tags |
tags (x_*) |
runbooks finops export-focus --include-tags --format csv |
All custom x_* fields included |
Charging Dimensions
| FOCUS Column |
runbooks finops Field |
CLI Command |
Notes |
| ChargePeriodStart |
charge_period_start, usage_start_date |
runbooks finops export-focus --format csv |
ISO 8601 UTC |
| ChargePeriodEnd |
charge_period_end, usage_end_date |
runbooks finops export-focus --format csv |
ISO 8601 UTC |
| ChargeCategory |
charge_category, line_item_type |
runbooks finops export-focus --format csv |
Usage, Tax, Fee, Credit, Adjustment |
| ChargeFrequency |
charge_frequency |
runbooks finops export-focus --format csv --include-frequency |
One-Time, Monthly, Hourly (if available) |
| ChargeClass |
charge_class, line_item_description |
runbooks finops export-focus --format csv |
Service-specific descriptor |
| ChargeType |
charge_type |
runbooks finops export-raw --field charge_type |
Vendor-specific raw type |
Pricing & Rate Details
| FOCUS Column |
runbooks finops Field |
CLI Command |
Notes |
| PricingCategory |
pricing_category, pricing_model |
runbooks finops export-focus --format csv |
On-Demand, Commitment (RI/Savings Plan), Dynamic |
| PricingUnit |
pricing_unit, usage_unit |
runbooks finops export-focus --format csv |
Per GB, per hour, per request, etc. |
| ListCost |
list_cost, public_on_demand_cost |
runbooks finops export-focus --format csv |
Public pricing before discounts |
| ListUnitPrice |
list_unit_price |
runbooks finops focus-list-prices --service <service> |
Per-unit public price |
Location & Availability
| FOCUS Column |
runbooks finops Field |
CLI Command |
Notes |
| Region |
region, location |
runbooks finops export-focus --format csv |
AWS: us-east-1 format; Azure: location name |
| AvailabilityZone |
availability_zone |
runbooks finops export-focus --include-az --format csv |
Not available in all cost sources; optional |
Usage Metrics
| FOCUS Column |
runbooks finops Field |
CLI Command |
Notes |
| UsageQuantity |
usage_quantity, usage_amount |
runbooks finops export-focus --format csv |
Numeric value of consumption |
| UsageUnit |
usage_unit |
runbooks finops export-focus --format csv |
GB, hours, requests, count, etc. |
| UsageType |
usage_type |
runbooks finops export-raw --field usage_type |
Vendor-specific usage classification |
Cost Metrics
| FOCUS Column |
runbooks finops Field |
CLI Command |
Notes |
| BilledCost |
billed_cost, blended_cost, unblended_cost |
runbooks finops export-focus --format csv |
Primary cost after all discounts/taxes |
| BilledCurrency |
billed_currency, currency_code |
runbooks finops export-focus --format csv |
USD, AUD, etc. (ISO 4217) |
| EffectiveCost |
effective_cost, amortized_cost |
runbooks finops export-focus --amortized --format csv |
Cost after RI/Savings Plan amortization |
| EffectiveCurrency |
effective_currency |
runbooks finops export-focus --amortized --format csv |
Same as BilledCurrency |
Custom & Context Fields
| FOCUS Column |
runbooks finops Field |
CLI Command |
Notes |
| x_CostCenter |
tags.CostCenter, x_cost_center |
runbooks finops export-focus --include-tags --format csv |
From resource tags |
| x_Project |
tags.Project, x_project |
runbooks finops export-focus --include-tags --format csv |
From resource tags |
| x_Environment |
tags.Environment, x_environment |
runbooks finops export-focus --include-tags --format csv |
From resource tags |
| x_Owner |
tags.Owner, x_owner |
runbooks finops export-focus --include-tags --format csv |
From resource tags |
| x_Application |
tags.Application, x_application |
runbooks finops export-focus --include-tags --format csv |
From resource tags |
| x_LineOfBusiness |
tags.LineOfBusiness, x_line_of_business |
runbooks finops export-focus --include-tags --format csv |
From resource tags |
Commitment & Discount Details
| FOCUS Column |
runbooks finops Field |
CLI Command |
Notes |
| CommitmentDiscountCategory |
commitment_type, discount_type |
runbooks finops export-focus --include-discounts --format csv |
N/A — not yet implemented |
| CommitmentDiscountId |
commitment_id, ri_id, savings_plan_id |
runbooks finops export-focus --include-discounts --format csv |
N/A — not yet implemented |
| CommitmentDiscountStatus |
commitment_status |
runbooks finops reserve-analysis --format csv |
N/A — deferred to reservation module |
Attribute & Compliance Fields
| FOCUS Column |
runbooks finops Field |
CLI Command |
Notes |
| SkuId |
sku_id |
runbooks finops export-raw --field sku_id |
N/A — not yet exposed in finops export |
| SkuPriceId |
sku_price_id |
runbooks finops focus-list-prices --sku <sku> |
N/A — not yet exposed |
| ConsumedService |
consumed_service |
runbooks finops export-focus --format csv |
Same as ServiceName in current implementation |
| InvoiceIssuer |
invoice_issuer |
runbooks finops export-raw --field invoice_issuer |
N/A — not yet implemented |
| NegotiatedDiscount |
negotiated_discount |
N/A |
N/A — not yet implemented |
Totals & Aggregations
| FOCUS Column |
runbooks finops Field |
CLI Command |
Notes |
| AmortizedCost |
amortized_cost, effective_cost |
runbooks finops export-focus --amortized --format csv |
Available when --amortized flag used |
| BlendedCost |
blended_cost |
runbooks finops export-focus --format csv |
Available in multi-account exports |
Coverage Summary
FOCUS 1.2 Columns Implemented: 44 of 60 = 73% coverage
Breakdown by Status:
- ✅ Implemented & Tested (36 columns): Billing dimensions, service/resource identification, charging dimensions, location, usage, cost metrics, custom fields
- 🔄 Planned for S2 2026 (8 columns): Commitment/discount details, SKU identifiers, negotiated discounts
- ⚠️ Not yet implemented (16 columns): Publisher (reseller logic), some advanced pricing fields, invoice issuer
Next Steps:
1. Run runbooks finops export-focus --format csv to generate FOCUS-compliant data
2. Cross-validate output against AWS Cost Explorer using /runbooks validation cross-validate
3. Migrate to --amortized flag for EffectiveCost calculations in downstream tools
Evidence: Detailed field-by-field mapping and CLI proof is captured in /tmp/command-center/finops-focus-mapping-2026-05-21.csv
Last Updated: 2026-05-21
Next Review: 2026-06-15 (post-S2 delivery)