Line item columns - AWS Data Exports

Line item columns

Line item columns contain data about cost, usage, type of usage, pricing rates, product name, and more.

Column name Description Data type
line_item_usage_account_name

The name 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.

 string
line_item_availability_zone The Availability Zone that hosts this line item. For example, us-east-1a or us-east-1b. string
line_item_blended_cost

The BlendedRate multiplied by the UsageAmount.

BlendedCost is blank for line items that have a LineItemType of Discount. Discounts are calculated using only the unblended cost of a member account, aggregated by member account and SKU. As a result, BlendedCost is not available for discounts.

 double
line_item_blended_rate

The BlendedRate is the average cost incurred for each SKU across an organization.

For example, the Amazon S3 blended rates are the total cost of storage divided by the amount of data stored per month. For accounts with RIs, the blended rates are calculated as the average costs of the RIs and the On-Demand Instances.

Blended rates are calculated at the management account level, and used to allocate costs to each member account. For more information, see Blended Rates and Costs in the AWS Billing User Guide.

 string
line_item_currency_code

The currency that this line item is shown in. All AWS customers are billed in US dollars by default. To change your billing currency, see Changing which currency you use to pay your bill in the AWS Billing User Guide.

 string
line_item_legal_entity

The Seller of Record of a specific product or service. In most cases, the invoicing entity and legal entity are the same. The values might differ for third-party AWS Marketplace 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 for AWS services in India.

 string
line_item_line_item_description

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 time period.

For size-flexible RIs, the description corresponds to the RI the benefit was applied to. For example, if a line item corresponds to a t2.micro and a t2.small RI was applied to the usage, the line_item_line_item_description displays t2.small.

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

 string
line_item_line_item_type

The type of charge covered by this line item. The possible types are as follows:

  • 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've 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 of 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. Review the Description column for details. AWS might update reports after they've 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.

 string
line_item_net_unblended_cost

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

 double
line_item_net_unblended_rate

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

 string
line_item_normalization_factor

As long as the instance has shared tenancy, AWS can apply all Regional Linux or Unix Amazon EC2 and Amazon RDS RI discounts to all instance sizes in an instance family and AWS Region. This also applies to RI discounts for member accounts in an organization. All new and existing Amazon EC2 and Amazon RDS size-flexible RIs are sized according to a normalization factor, based on the instance size.

 double
line_item_normalized_usage_amount

The amount of usage that you incurred, in normalized units, for size-flexible RIs. The NormalizedUsageAmount is equal to UsageAmount multiplied by NormalizationFactor.

 double
line_item_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. string
line_item_product_code

The code of the product measured. For example, Amazon EC2 is the product code for Amazon Elastic Compute Cloud.

 string
line_item_resource_id

Table configuration: Added by: INCLUDE RESOURCES

(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.

 string
line_item_tax_type

The type of tax that AWS applied to this line item.

 string
line_item_unblended_cost The UnblendedCost is the UnblendedRate multiplied by the UsageAmount. double
line_item_unblended_rate

In consolidated billing for accounts using AWS Organizations, the unblended rate is the rate associated with an individual account's service usage.

For Amazon EC2 and Amazon RDS line items that have an RI discount applied to them, the UnblendedRate is 0. Line items with an RI discount have a LineItemType of DiscountedUsage.

 string
line_item_usage_account_id

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.

 string
line_item_usage_amount

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

Certain subscription charges will have a UsageAmount of 0.

 double
line_item_usage_end_date The end date and time for the corresponding line item in UTC, exclusive. The format is YYYY-MM-DDTHH:mm:ssZ. timestamp
line_item_usage_start_date The start date and time for the line item in UTC, inclusive. The format is YYYY-MM-DDTHH:mm:ssZ. timestamp
line_item_usage_type 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. string