Mapping FOCUS Columns to Flexera One Dimensions
|
FOCUS Column |
Flexera One Dimension |
Required |
Allows nulls? |
Meaning |
|
BillingCurrency |
- |
Yes |
No |
The currency that a charge was billed in. |
|
BillingPeriodStart |
- |
Yes |
No |
Represents the start date and time of the billing period. Must be represented in the extended ISO 8601 format with UTC offset ('YYYY-MM-DDTHH:mm:ssZ'). |
|
ChargeCategory |
Line Item Type |
Yes |
No |
Indicates whether the row represents an upfront or recurring fee, cost of usage that already occurred, an after-the-fact adjustment (for example, credits), or taxes. |
|
ChargePeriodEnd |
- |
Yes |
No |
The end date and time of a charge period. Must be represented in the extended ISO 8601 format with UTC offset ('YYYY-MM-DDTHH:mm:ssZ'). |
|
ChargePeriodStart |
- |
Yes |
No |
The beginning date and time of a charge period. Must be represented in the extended ISO 8601 format with UTC offset ('YYYY-MM-DDTHH:mm:ssZ'). |
|
ConsumedUnit |
Usage Unit |
Yes |
Yes |
The units of a given resource or service used or purchased in combination with Usage Quantity. Note:Currently, both the UsageUnit and ConsumedUnit columns are supported. |
|
ProviderName |
Cloud Vendor |
Yes |
No |
The name of the entity that made the resources or services available for purchase. |
|
PublisherName |
Manufacturer Name |
Yes |
No |
The name of the entity that published the resources or services that were purchased. |
|
Region |
Region |
No |
Yes |
The physical region where a resource was consumed. Note:Currently, both the Region and RegionId columns are supported. |
|
RegionId |
Region |
Yes |
Yes |
The physical region where a resource was consumed. Note:Currently, both the RegionId and Region columns are supported. |
|
ResourceId |
Resource ID |
Yes |
Yes |
The ID of a specific cloud resource. For AWS, it might be a bucket name or instance ID. Equivalent for other clouds. |
|
ResourceType |
Resource Type |
Yes |
Yes |
The kind of resource the charge applies to. |
|
ServiceCategory |
Category |
Yes |
No |
The highest-level classification of a service based on the core function of the service. |
|
ServiceName |
Service |
Yes |
No |
The name of the high-level service consumed. For example, AmazonS3 (AWS), Microsoft.Compute (Azure), or Compute Engine (Google Cloud Platform). |
|
SubAccountId |
Cloud Vendor Account |
Yes |
Yes |
A sub account ID is a provider assigned identifier assigned to a sub account. |
|
SubAccountName |
Cloud Vendor Account Name |
Yes |
Yes |
A sub account name is a display name assigned to a sub account. |
|
Tags |
- |
Yes |
Yes |
Can be used for defining custom dimensions. For example, consider the following: "{""environment"": ""Test"", ""department"": ""Sales"", ""cpu-count"": ""24""}" |
|
UsageUnit |
Usage Unit |
No |
Yes |
The units of a given resource or service used or purchased in combination with Usage Quantity. Note:Currently, both the UsageUnit and ConsumedUnit columns are supported. |