FOCUS Mappings

Ternary supports the FOCUS format and translating your existing billing exports into the FOCUS format for consistency across multi-cloud estates. You will see a combination of FOCUS specific fields and AWS, Azure and GCP native fields. Any field, coming from the native exports, specific to that vendor will be appended with something such as (AWS Billing Export Field) or (GCP Billing Export Field). Native, FOCUS specific

Ternary Grouping	FOCUS Grouping
BillingAccountID	BillingAccountId
BillingAccountName	BillingAccountName
BillingEntity	InvoiceIssuer
ProjectID	SubAccountId
ProjectName	SubAccountName
cloudId	cloud_id
cloudName	cloud_name
Category	ServiceCategory
Region	RegionId
ServiceDescription	ServiceName
SkuDescription	ChargeDescription
SkuID	SkuId
UsageUnit	UsageUnit
Zone	AvailabilityZone
azure_product_name	ProductName
azure_product_order_name	productOrderName
azure_meter_subcategory	meterSubCategory
azure_benefit_id	benefitId
azure_benefit_name	benefitName
azure_frequency	frequency
azure_reservation_id	reservationId
azure_reservation_name	reservationName
azure_resource_group	resourceGroupName
azure_partner_name	partnerName
azure_partner_earned_credit_rate	partnerEarnedCreditRate
azure_partner_tenant_id	partnerTenantId
azure_customer_name	customerName
azure_resource_group_name	resourceGroupName
azure_product_id	ProductId
aws_savings_plan_arn	savings_plan_savings_plan_arn
aws_line_item_operation	line_item_operation
aws_usage_type_group	product_group
aws_reservation_arn	reservation_reservation_arn
aws_eks_cluster_name	eks:cluster-name
aws_eks_namespace	eks:namespace
aws_eks_node	eks:node
aws_eks_deployment	eks:deployment
aws_eks_workload_name	eks:workload-name
aws_eks_workload_type	eks:workload-type
billingEntity	bill_billing_entity (AWS Billing Export Field)
commitmentPaymentModel	pricing_purchase_option (AWS Billing Export Field)
machine_family_category	product_instance_family
machine_series_family	product_instance_type_family
machine_spec	product_instance_type
vendor	PublisherName and ProviderName
dataSource	DataSource
databaseEngine	product_database_engine (AWS Billing Export Field)
invoiceMonth	InvoiceMonth
lineItemType	ChargeCategory
location	Not present but Region and Zone exist
operatingSystem	product_operating_system (AWS Billing Export Field)
parentId	ancestry_ids
parentName	ancestry_names
pricingModel	PricingCategory
pricingUnit	ConsumedUnit
tenancy	PricingModel
oci_tenant_id	lineItem_tenantId
oci_availability_domain	product_availabilityDomain
projectNumber	SubAccountNumber
ancestryNames	ancestors
ServiceID	ServiceId
cloud_provider	ProviderName
lineItemType	line_item_line_item_type (AWS Billing Export Field)

Ternary Measure	FOCUS Measure
cost	Pending
netCost	Billed Cost
amortizedCost	Pending
netAmortizedCost	Effective Cost
usageAmount	ConsumedQuantity
usageAmountInPricingUnits	usage_amount_in_pricing_units (GCP Billing Export Field)
awsReservationEffectiveCost	reservation_effective_cost (AWS Billing Export Field)
awsSavingsPlanAmortizedUpfrontCommitmentForBillingPeriod	savings_plan_amortized_upfront_commitment_for_billing_period (AWS Billing Export Field)
awsSavingsPlanEffectiveCost	savings_plan_savings_plan_effective_cost (AWS Billing Export Field)
awsNetUnblendedCost	line_item_net_unblended_cost
awsUsageBlendedCost	line_item_blended_cost