Reservation columns - AWS Data Exports

Reservation columns

Reservation columns contain data about a reservation that applies to the line item.

Column name Description Data type
reservation_amortized_upfront_cost_for_usage The initial upfront payment for all upfront RIs and partial upfront RIs amortized for usage time. The value is equal to: RIAmortizedUpfrontFeeForBillingPeriod * The normalized usage amount for DiscountedUsage line items / The normalized usage amount for the RIFee. Because there are no upfront payments for no upfront RIs, the value for a no upfront RI is 0. We don't provide this value for Dedicated Host reservations at this time. The change will be made in a future update. double
reservation_amortized_upfront_fee_for_billing_period

Describes how much of the upfront fee for this reservation is costing you for the billing period. The initial upfront payment for all upfront RIs and partial upfront RIs, amortized over this month. Because there are no upfront fees for no upfront RIs, the value for no upfront RIs is 0. We don't provide this value for Dedicated Host reservations at this time. The change will be made in a future update.

double
reservation_availability_zone

The Availability Zone of the resource that is associated with this line item.

string
reservation_effective_cost 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. double
reservation_end_time

The end date of the associated RI lease term.

string
reservation_modification_status

Shows whether the RI lease was modified or if it is unaltered.

Original: The purchased RI was never modified.

System: The purchased RI was modified using the console or API.

Manual: The purchased RI was modified using AWS Support assistance.

ManualWithData: The purchased RI was modified using AWS Support assistance, and AWS calculated estimates for the RI.

string
reservation_net_amortized_upfront_cost_for_usage

The initial upfront payment for All Upfront RIs and Partial Upfront RIs amortized for usage time, if applicable. This column is included in your report only when your account has a discount in the applicable billing period.

double
reservation_net_amortized_upfront_fee_for_billing_period

The cost of the reservation's upfront fee for the billing period. This column is included in your report only when your account has a discount in the applicable billing period.

double
reservation_net_effective_cost

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.

double
reservation_net_recurring_fee_for_usage

The after-discount cost of the recurring usage fee. This column is included in your report only when your account has a discount in the applicable billing period.

double
reservation_net_unused_amortized_upfront_fee_for_billing_period

The net unused amortized upfront fee for the billing period. This column is included in your report only when your account has a discount in the applicable billing period.

double
reservation_net_unused_recurring_fee

The recurring fees associated with unused reservation hours for Partial Upfront and No Upfront RIs after discounts. This column is included in your report only when your account has a discount in the applicable billing period.

double
reservation_net_upfront_value

The upfront value of the RI with discounts applied. This column is included in your report only when your account has a discount in the applicable billing period.

double
reservation_normalized_units_per_reservation

The number of normalized units for each instance of a reservation subscription.

string
reservation_number_of_reservations

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

string
reservation_recurring_fee_for_usage The recurring fee amortized for usage time, for partial upfront RIs and no upfront RIs. The value is equal to: The unblended cost of the RIFee * The sum of the normalized usage amount of Usage line items / The normalized usage amount of the RIFee for size flexible Reserved Instances. Because all upfront RIs don't have recurring fee payments greater than 0, the value for all upfront RIs is 0. double
reservation_reservation_a_r_n

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.

string
reservation_start_time

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

string
reservation_subscription_id

A unique identifier that maps a line item with the associated offer. We recommend you use the RI ARN as your identifier of an AWS Reserved Instance, but both can be used.

string
reservation_total_reserved_normalized_units The total number of reserved normalized units for all instances for a reservation subscription. AWS computes total normalized units by multiplying the reservation/NormalizedUnitsPerReservation with reservation/NumberOfReservations. string
reservation_total_reserved_units TotalReservedUnits populates for both Fee and RIFee line items with distinct values. string
reservation_units_per_reservation UnitsPerReservation populates for both Fee and RIFee line items with distinct values. string
reservation_unused_amortized_upfront_fee_for_billing_period

The amortized-upfront-fee-for-billing-period-column amortized portion of the initial upfront fee for all upfront RIs and partial upfront RIs. Because there are no upfront payments for no upfront RIs, the value for no upfront RIs is 0. We don't provide this value for Dedicated Host reservations at this time. The change will be made in a future update.

double
reservation_unused_normalized_unit_quantity

The number of unused normalized units for a size-flexible Regional RI that you didn't use during this billing period.

double
reservation_unused_quantity

The number of RI hours that you didn't use during this billing period.

double
reservation_unused_recurring_fee

The recurring fees associated with your unused reservation hours for partial upfront and no upfront RIs. Because all upfront RIs don't have recurring fees greater than 0, the value for All Upfront RIs is 0.

double
reservation_upfront_value

The upfront price paid for your AWS Reserved Instance. For no upfront RIs, this value is 0.

double