AWS Field Dictionary

Dictionary of most used fields in AWS

Prefix
AWS Billing Field
Description
Services

bill

bill/BillingEntity

Helps you identify whether your invoices or transactions are for AWS Marketplace or for purchases of other AWS services.

bill

bill/BillingPeriodStartDate

The start date of the billing period covered by this report, in UTC. The format is YYYY-MM-DDTHH:mm:ssZ.

bill

bill/BillType

The type of invoice covered by this report. There are three types of invoices:

  • Anniversary: ​​Line items for services you used during the month

  • Purchase: Line items for initial service fees

  • Refund: Line items for refunds

bill

bill/InvoiceId

The ID associated with a specific line item. Until the report is finalized, it is blank.

bill

bill/InvoicingEntity

"Amazon Web Services, Inc.: The entity that issues invoices to the customer globally, where applicable.

Amazon Web Services India Private Limited: The entity that issues invoices to customers based in India.

Amazon Web Services South Africa Proprietary Limited: The entity that issues invoices to customers in South Africa."

bill

bill/PayerAccountId

The billing account ID. For an organization in AWS Organizations, this is the management account ID.

lineItem

lineItem/LegalEntity

The registered seller of a specific product or service. In most cases, the billing entity and legal entity are the same. Values ​​may differ for AWS Marketplace third-party transactions. Possible values ​​include:

Amazon Web Services, Inc. — The entity that sells AWS services. Amazon Web Services India Private Limited: The local Indian entity that acts as a reseller of AWS services in India.

lineItem

lineItem/LineItemDescription

The description of the line item type. For example, the description of a usage line item summarizes the type of usage incurred during a specific period.

For flexible size IRs, the description matches the IR to which the benefit was applied. For example, if a line item matches a t2.micro and a t2.small IR was applied to the usage, lineItem/LineItemDescription displays t2.small.

The description of a usage line item with an IR discount contains the pricing plan covered by the line item.

lineItem

lineItem/LineItemType

The type of charge covered by this line item. Possible types are the following:

  • BundledDiscount – A usage-based discount that provides free or discounted usage of a service or feature based on the usage of another service or feature.

  • Credit – Any credits that AWS applied to your bill. See the Description column for details. AWS might update reports after they have been finalized if AWS applies a credit to your account for the month after finalizing your bill.

  • Discount – Any discounts that AWS applied to your usage. This specific line item name may vary and require parsing based on the discount. For more information, refer to the lineItem/LineItemDescription column.

  • DiscountedUsage – The rate for any instances for which you had Reserved Instance (RI) benefits.

  • Fee – Any upfront annual fee that you paid for subscriptions. For example, the upfront fee that you paid for an All Upfront RI or a Partial Upfront RI.

  • Refund – The negative charges that AWS refunded money for. Check the Description column for details. AWS might update reports after they have been finalized if AWS applies a refund to your account for the month after finalizing your bill.

  • RIFee – The monthly recurring fee for subscriptions. For example, the recurring fee for Partial Upfront RIs, No Upfront RIs, and All Upfronts that you pay every month. Although the RIFee might be $0 for all upfront reservations, this line is still populated for those reservation types to provide other columns such as reservation/AmortizedUpfrontFeeForBillingPeriod and reservation/ReservationARN.

  • Tax – Any taxes that AWS applied to your bill. For example, VAT or US sales tax.

  • Usage – Any usage that is charged at On-Demand Instance rates.

  • SavingsPlanUpfrontFee – Any one-time upfront fee from your purchase of an All Upfront or Partial Upfront Savings Plan.

  • SavingsPlanRecurringFee – Any recurring hourly charges that correspond with your No Upfront or Partial Upfront Savings Plan. The Savings Plan recurring fee is initially added to your bill on the day that you purchase a No Upfront or Partial Upfront Savings Plan. After the initial purchase, AWS adds the recurring fee to the first day of each billing period thereafter.

  • SavingsPlanCoveredUsage – Any on-demand cost that is covered by your Savings Plan. Savings Plan covered usage line items are offset by the corresponding Savings Plan negation items.

  • SavingsPlanNegation – Any offset cost through your Savings Plan benefit that’s associated with the corresponding Savings Plan covered usage item.

lineItem

lineItem/NetUnblendedCost

The actual after-discount cost that you're paying for the line item. This column is included in your report only when your account has a discount in the applicable billing period.

lineItem

lineItem/Operation

The specific AWS 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.

lineItem

lineItem/ResourceId

(Optional) If you chose to include individual resource IDs in your report, this column contains the ID of the resource that you provisioned. For example, an Amazon S3 storage bucket, an Amazon EC2 compute instance, or an Amazon RDS database can each have a resource ID. This field is blank for usage types that aren't associated with an instantiated host, such as data transfers and API requests, and line item types such as discounts, credits, and taxes. The following table shows a list of resource identifiers for common AWS services.

lineItem

lineItem/UnblendedCost

The UnblendedCost is the UnblendedRate multiplied by the UsageAmount.

lineItem

lineItem/UsageAccountId

The account ID of the account that used this line item. For organizations, this can be either the management account or a member account. You can use this field to track costs or usage by account.

lineItem

lineItem/UsageAmount

The amount of usage that you incurred during the specified time period. For size-flexible Reserved Instances, use the reservation/TotalReservedUnits column instead.

lineItem

lineItem/UsageStartDate

The start date and time for the line item in UTC, inclusive. The format is YYYY-MM-DDTHH:mm:ssZ.

lineItem

lineItem/UsageType

The usage details of the line item. For example, USW2-BoxUsage:m2.2xlarge describes an M2 High Memory Double Extra Large instance in the US West (Oregon) Region.

reservation

reservation/EffectiveCost

The sum of both the upfront and hourly rate of your RI, averaged into an effective hourly rate. EffectiveCost is calculated by taking the amortizedUpfrontCostForUsage and adding it to the recurringFeeForUsage.

  • Amazon EC2

  • OpenSearch Service

  • Amazon DynamoDB

  • Amazon ElastiCache

  • Amazon RDS

reservation

reservation/EndTime

The end date of the associated RI lease term.

  • Amazon EC2

  • OpenSearch Service

  • Amazon Redshift

  • Amazon ElastiCache

  • Amazon RDS

reservation

reservation/NetEffectiveCost

The sum of both the upfront fee and the hourly rate of your RI, averaged into an effective hourly rate. This column is included in your report only when your account has a discount in the applicable billing period.

reservation

reservation/NumberOfReservations

The number of reservations that are covered by this subscription. For example, one RI subscription might have four associated RI reservations.

  • Amazon EC2

  • OpenSearch Service

  • Amazon DynamoDB

  • Amazon Redshift

  • Amazon ElastiCache

  • Amazon RDS

reservation

reservation/ReservationARN

The Amazon Resource Name (ARN) of the RI that this line item benefited from. This is also called the "RI Lease ID". This is a unique identifier of this particular AWS Reserved Instance. The value string also contains the AWS service name and the Region where the RI was purchased.

  • Amazon EC2

  • OpenSearch Service

  • Amazon DynamoDB

  • Amazon Redshift

  • Amazon ElastiCache

  • Amazon RDS

reservation

reservation/StartTime

The start date of the term of the associated Reserved Instance.

  • Amazon EC2

  • OpenSearch Service

  • Amazon Redshift

  • Amazon ElastiCache

  • Amazon RDS

pricing

pricing/publicOnDemandCost

The total cost for the line item based on public On-Demand Instance rates. If you have SKUs with multiple On-Demand public costs, the equivalent cost for the highest tier is displayed. For example, services offering free-tiers or tiered pricing.

pricing

pricing/PurchaseOption

How you chose to pay for this line item. Valid values are All Upfront, Partial Upfront, and No Upfront.

pricing

pricing/term

Whether your AWS usage is Reserved or On-Demand.

pricing

pricing/unit

The pricing unit that AWS used for calculating your usage cost. For example, the pricing unit for Amazon EC2 instance usage is in hours.

product

product/instanceFamily

Describes your Amazon EC2 instance family. Amazon EC2 provides you with a large number of options across 10 different instance types, each with one or more size options, organized into distinct instance families optimized for different types of applications.

  • Amazon EC2

  • Amazon RDS

  • OpenSearch Service

  • Amazon ElastiCache

  • Amazon EMR

and more. For the full service list, download Column_Attribute_Service.zip.

product

product/instanceType

Describes the instance type, size, and family, which define the CPU, networking, and storage capacity of your instance.

  • Amazon EC2

  • Amazon RDS

  • OpenSearch Service

  • Amazon ElastiCache

  • Amazon EMR

and more. For the full service list, download Column_Attribute_Service.zip.

product

product/instanceTypeFamily

The instance family that is associated with the given usage.

  • Amazon DocumentDB

  • Amazon RDS

product

product/operatingSystem

Describes the operating system of your Amazon EC2 instance.

  • Amazon AppStream

  • Amazon EC2

  • Amazon GameLift

  • Amazon Lightsail

  • Amazon WorkSpaces

  • AWS CodeBuild

product

product/operation

Describes the specific AWS operation that this line item covers.

  • Amazon EC2

  • Amazon S3

  • Amazon RDS

  • Amazon DynamoDB

  • Amazon CloudWatch

  • Amazon Redshift

and more. For the full service list, download Column_Attribute_Service.zip.

product

product/ProductFamily

The category for the type of product.

  • Sample values: Alarm, AWS Budgets, Stopped Instance, Storage Snapshot, Compute

  • Amazon EC2

  • AWS Certificate Manager

  • Amazon S3

  • Amazon RDS

  • Amazon DynamoDB

and more. For the full service list, download Column_Attribute_Service.zip.

product

product/ProductName

The full name of the AWS service. Use this column to filter AWS usage by AWS service.

  • Sample values: AWS Backup, AWS Config, Amazon Registrar, Amazon Elastic File System, Amazon Elastic Compute Cloud

product

product/PurchaseOption

Describes the available purchasing models for an AWS service. For example, AWS provides four main Amazon EC2 instance purchasing options: On-Demand, Reserved Instances, Spot Instances, with the added option of Dedicated Hosts.

product

product/purchaseterm

In Amazon EC2, this specifies a commitment to a consistent instance configuration. This includes instance type and Region for a period of 1 to 3 years.

product

product/region

The geographical area that hosts your AWS services. Use this field to analyze spend across a particular Region.

  • Amazon EC2

  • AWS Certificate Manager

  • Amazon S3

  • Amazon RDS

  • Amazon DynamoDB

and more. For the full service list, download Column_Attribute_Service.zip.

product

product/servicename

A simplified description about the AWS service.

  • Amazon EC2 Budgets

  • Amazon ECR

  • Amazon ECS

  • Amazon EFS

  • Amazon Elastic Inference

  • Amazon EKS

product

product/sku

A unique code for a product. The SKU is created by combining the ProductCode, UsageType, and Operation. For size-flexible RIs, the SKU uses the instance that was used. For example, if you used a t2.micro instance and AWS applied a t2.small RI discount to the usage, the line item SKU is created with the t2.micro.

  • Amazon EC2

  • AWS Certificate Manager

  • Amazon S3

  • Amazon RDS

  • Amazon DynamoDB

and more. For the full service list, download Column_Attribute_Service.zip.

product

product/storage

Describes the disk storage attached to your instance.

  • Amazon EC2

  • Amazon RDS

  • Amazon Redshift

  • OpenSearch Service

  • Amazon WorkSpaces

and more. For the full service list, download Column_Attribute_Service.zip.

product

product/usagetype

Describes the usage details of the line item.

  • Sample values: EU-BoxUsage:c5d.9xlarge, EU-BoxUsage:m4.16xlarge, SAE1-InstanceUsage:db.t2.medium, USW2-AW-SW-19, SAE1-BoxUsage:c4.large

  • Amazon EC2

  • AWS Certificate Manager

  • Amazon S3

  • Amazon RDS

  • Amazon DynamoDB

and more. For the full service list, download Column_Attribute_Service.zip.

product

product/volumeType

Describes your Amazon EBS volume types.

  • Sample values: Standard, General Purpose, General Purpose-Aurora, Amazon Glacier, Amazon SimpleDB – Standard

  • Amazon EC2

  • Amazon S3

  • Amazon RDS

  • Amazon DynamoDB

  • Amazon S3 Glacier

and more. For the full service list, download Column_Attribute_Service.zip.

savingsPlan

savingsPlan/EndTime

The expiration date for the Savings Plan agreement.

  • Amazon EC2

  • Fargate

  • AWS Lambda

  • Amazon SageMaker AI

savingsPlan

savingsPlan/NetSavingsPlanEffectiveCost

The effective cost for Savings Plans, which is your usage divided by the fees. This column is included in your report only when your account has a discount in the applicable billing period.

savingsPlan

savingsPlan/OfferingType

Describes the type of Savings Plan purchased.

  • Amazon EC2

  • Fargate

  • AWS Lambda

  • Amazon SageMaker AI

savingsPlan

savingsPlan/PaymentOption

The payment options available for your Savings Plan.

  • Amazon EC2

  • Fargate

  • AWS Lambda

  • Amazon SageMaker AI

savingsPlan

savingsPlan/PurchaseTerm

Describes the duration, or term, of the Savings Plan.

  • Amazon EC2

  • Fargate

  • AWS Lambda

  • Amazon SageMaker AI

savingsPlan

savingsPlan/SavingsPlanArn

The unique Savings Plan identifier.

  • Amazon EC2

  • Fargate

  • AWS Lambda

  • Amazon SageMaker AI

savingsPlan

savingsPlan/SavingsPlanEffectiveCost

The proportion of the Savings Plan monthly commitment amount (upfront and recurring) that is allocated to each usage line.

  • Amazon EC2

  • Fargate

  • AWS Lambda

  • Amazon SageMaker AI

savingsPlan

savingsPlan/StartTime

The start date of the Savings Plan agreement.

  • Amazon EC2

  • Fargate

  • AWS Lambda

  • Amazon SageMaker AI

pier

pier/aws/ondemandeffectivecost

Cost effective on demand

pier

pier/aws/netondemandeffectivecost

Amortized cost

pier

pier/accountname

Name corresponding to the account.

pier

pier/accountemail

Email address corresponding to the account.

Last updated