FOCUS 1.2 with Amazon columns - Amazon Data Exports
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

FOCUS 1.2 with Amazon columns

Column name Description Data type Null value allowed
AvailabilityZone A provider-assigned identifier for a physically separated and isolated area within a Region that provides high availability and fault tolerance. string Yes
BilledCost A charge serving as the basis for invoicing, inclusive of all reduced rates and discounts while excluding the amortization of upfront charges (one-time or recurring). double No
BillingAccountId The identifier assigned to a billing account by the provider. string No
BillingAccountName The display name assigned to a billing account. string Yes
BillingAccountType A provider-assigned name to identify the type of billing account. string No
BillingCurrency Represents the currency that a charge was billed in. string No
BillingPeriodEnd The exclusive end bound of a billing period. timestamp_milliseconds No
BillingPeriodStart The inclusive start bound of a billing period. timestamp_milliseconds No
CapacityReservationId The identifier assigned to a capacity reservation by the provider. string Yes
CapacityReservationStatus Indicates whether the charge represents either the consumption of a capacity reservation or when a capacity reservation is unused. string Yes
ChargeCategory Represents the highest-level classification of a charge based on the nature of how it is billed. string No
ChargeClass Indicates whether the row represents a correction to a previously invoiced billing period. string Yes
ChargeDescription Self-contained summary of the charge's purpose and price. string Yes
ChargeFrequency Indicates how often a charge will occur. string No
ChargePeriodEnd The exclusive end bound of a charge period. timestamp_milliseconds No
ChargePeriodStart The inclusive start bound of a charge period. timestamp_milliseconds No
CommitmentDiscountCategory Indicates whether the commitment discount identified in the CommitmentDiscountId column is based on usage quantity or cost (aka "spend"). string Yes
CommitmentDiscountId The identifier assigned to a commitment discount by the provider. string Yes
CommitmentDiscountName The display name assigned to a commitment discount. string Yes
CommitmentDiscountQuantity The amount of a commitment discount purchased or accounted for in commitment discount related rows that is denominated in Commitment Discount Units. double Yes
CommitmentDiscountStatus Indicates whether the charge corresponds with the consumption of a commitment discount or the unused portion of the committed amount. string Yes
CommitmentDiscountType A provider-assigned identifier for the type of commitment discount applied to the row. string Yes
CommitmentDiscountUnit The provider-specified measurement unit indicating how a provider measures the Commitment Discount Quantity of a commitment discount. string Yes
ConsumedQuantity The volume of a metered SKU associated with a resource or service used, based on the Consumed Unit. double Yes
ConsumedUnit Provider-specified measurement unit indicating how a provider measures usage of a metered SKU associated with a resource or service. string Yes
ContractedCost Cost calculated by multiplying contracted unit price and the corresponding Pricing Quantity. double No
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 discounts or any other discounts. double Yes
EffectiveCost The amortized cost of the charge after applying all reduced rates, discounts, and the applicable portion of relevant, prepaid purchases (one-time or recurring) that covered this charge. double No
InvoiceId The provider-assigned identifier for an invoice encapsulating some or all charges in the corresponding billing period for a given billing account. string Yes
InvoiceIssuerName The name of the entity responsible for invoicing for the resources or services consumed. string No
ListCost Cost calculated by multiplying List Unit Price and the corresponding Pricing Quantity. double No
ListUnitPrice The suggested provider-published unit price for a single Pricing Unit of the associated SKU, exclusive of any discounts. double Yes
PricingCategory Describes the pricing model used for a charge at the time of use or purchase. string Yes
PricingCurrency The national or virtual currency denomination that a resource or service was priced in. string Yes
PricingCurrencyContractedUnitPrice The agreed-upon unit price for a single Pricing Unit of the associated SKU, inclusive of negotiated discounts, if present, while excluding negotiated commitment discounts or any other discounts, and expressed in Pricing Currency. double Yes
PricingCurrencyEffectiveCost The cost of the charge after applying all reduced rates, discounts, and the applicable portion of relevant, prepaid purchases (one-time or recurring) that covered this charge, as denominated in Pricing Currency. double Yes
PricingCurrencyListUnitPrice The suggested provider-published unit price for a single Pricing Unit of the associated SKU, exclusive of any discounts and expressed in Pricing Currency. double Yes
PricingQuantity The volume of a given SKU associated with a resource or service used or purchased, based on the Pricing Unit. double Yes
PricingUnit Provider-specified measurement unit for determining unit prices, indicating how the provider rates measured usage and purchase quantities after applying pricing rules like block pricing. string Yes
ProviderName The name of the entity that made the resources or services available for purchase. string No
PublisherName The name of the entity that produced the resources or services that were purchased. string No
RegionId Provider-assigned identifier for an isolated geographic area where a resource is provisioned or a service is provided. string Yes
RegionName The name of an isolated geographic area where a resource is provisioned or a service is provided. string Yes
ResourceId Identifier assigned to a resource by the provider. string Yes
ResourceName Display name assigned to a resource. string Yes
ResourceType The kind of resource the charge applies to. string Yes
ServiceCategory Highest-level classification of a service based on the core function of the service. string No
ServiceName An offering that can be purchased from a provider (e.g., cloud virtual machine, SaaS database, professional services from a systems integrator). string No
ServiceSubcategory Secondary classification of the Service Category for a service based on its core function. string No
SkuId Provider-specified unique identifier that represents a specific SKU (e.g., a quantifiable good or service offering). string Yes
SkuMeter Describes the functionality being metered or measured by a particular SKU in a charge. string Yes
SkuPriceId A provider-specified unique identifier that represents a specific SKU Price associated with a resource or service used or purchased. string Yes
SkuPriceDetails A set of properties of a SKU Price ID which are meaningful and common to all instances of that SKU Price ID. map <string, string> Yes
SubAccountId An ID assigned to a grouping of resources or services, often used to manage access and/or cost. string Yes
SubAccountName A name assigned to a grouping of resources or services, often used to manage access and/or cost. string Yes
SubAccountType A provider-assigned name to identify the type of sub account. string Yes
Tags The set of tags assigned to tag sources that account for potential provider-defined or user-defined tag evaluations. map <string, string> Yes
x_Discounts A map column containing key-value pairs of any specific discounts that apply to this line item. map <string, double> Yes
x_Operation The specific Amazon operation covered by this line item. This describes the specific usage of the line item. For example, a value of RunInstances indicates the operation of an Amazon EC2 instance. string Yes
x_ServiceCode The code of the product measured. For example, Amazon EC2 is the product code for Amazon Elastic Compute Cloud. string Yes