Skip to main content

Ripple - Contents of CSV Data

Key terminology in the CSV files downloaded from Ripple.

Written by Yo Fukuda
Updated this week

Overview

This article explains the key fields and terminology found in the CSV files downloaded from the Ripple invoice page.

A sample CSV file is available for download from the Invoices page in Ripple.


Field Descriptions

【BillingGroupID】

The billing group ID of the billing group.

【BillingGroupName】

The name of the billing group.

【CompanyName】

The company name associated with the billing group.

【CustomerID】

The AWS account ID registered to the billing group.

【CustomerName】

The AWS account name registered to the billing group.

【ServiceType】

Indicates the type of service. The value will be one of the following: Account, Product, or Service.

  • Account: Represents _ACCOUNT_TOTAL in ServiceName.

  • Product: Represents one of _CUSTOM_SERVICE, _SUBSTITUTION, or _TOTAL in ServiceName.

  • Service: Represents the value of lineItem/ProductCode from the AWS Cost and Usage Report (CUR).

【ServiceName】

Represents the name of the service.

  • _SUPPORT_BUSINESS: AWS Support fee (excluding tax) as set in the billing group’s invoice settings.

  • _SUBSTITUTION: Service fee (excluding tax) as set in the billing group’s invoice settings.

  • _TOTAL: Total amount (excluding tax) for the BillingGroupID.

  • _ACCOUNT_TOTAL: Total amount (excluding tax) per CustomerID.

  • Other values: Represent lineItem/ProductCode from the AWS Cost and Usage Report (CUR).

【Charge】

Amount per ServiceName (excluding tax).

【DiscountCharge】

Discount amount (excluding tax).

【DiscountCharge - TaxFree】

Discount amount (excluding tax). (Note: This appears to be a duplicate or clarification of the above field.)

【Tax】

Tax amount


Need More Help?

If any errors occur during the process or if you have any questions, please reach out to us:


Did this answer your question?