Skip to main content

Ripple – Billing CSV Data Fields

This article explains the fields contained in the billing CSV data.

Alphaus Support Team avatar
Written by Alphaus Support Team
Updated yesterday

BillingGroupID

The ID of the billing group.

BillingGroupName

The name of the billing group.

CompanyName

The company name of the billing group.

CustomerID

The AWS account ID registered in the billing group.

CustomerName

The AWS account name registered in the billing group.

ServiceType

Indicates the type of service. Possible values are: Account, Product, or Service.

  • Account Represents _ACCOUNT_TOTAL for ServiceName.

  • Product Represents _SUPPORT_BUSINESS_JPY, _SUBSTITUTION_JPY, or _TOTAL for ServiceName.

  • Service Represents the lineItem/ProductCode value from the CUR.

    • Marketplace Usage Amount is displayed as Service.

    • Marketplace One-time Usage Amount is displayed as ServiceFee.

ServiceName

The name of the service.

  • _SUPPORT_BUSINESS_JPY AWS support fees (tax excluded) as configured in the billing group's invoice settings.

  • _SUBSTITUTION_JPY Agency fees (tax excluded) as configured in the billing group's invoice settings.

  • _TOTAL Total amount (tax excluded) for the BillingGroupID.

  • _ACCOUNT_TOTAL Total amount per CustomerID (tax excluded).

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

Charge

Amount per ServiceName (tax excluded).

DiscountCharge

Amount after discount (tax excluded).

DiscountCharge - TaxFree

Amount after discount for usage fees, excluding tax-exempt portions (tax excluded).

FreeFormat

Amount added as "Other Costs."

CustomService

Amount added as "Billing Service."

Tax

Tax amount.

  • [DiscountCharge - TaxFree] when ServiceName is _TOTAL

    • [Consumption tax rate set in the billing group's invoice settings]

Total

Total amount for the BillingGroupID (tax included).

You can also select and download only the necessary CSV fields at the time of download.

Did this answer your question?