Bill level
When downloading bills for all customers (or resellers) in the Partner Center, you can download bills at 4 levels, which are as follows:
Bill by Instance: package the Bill by Instance files of all customers (or resellers) into ONE ZIP file. After decompression ONE CSV bill file per customer (or reseller).
Bill by Instance (consolidated): consolidate the Bill by Instance data of all customers (or resellers) into ONE CSV bill file, and distinguish different customer data by filtering the Owner UIN column, or distinguish different reseller data by filtering the Reseller UIN column.
Bill Details: Package the Bill Details files of all customers (or resellers) into ONE ZIP file. After decompression, ONE CSV bill file per customer (or reseller).
Bill Details (consolidated, monthly aggregated): consolidate the Bill Details data of all customers (or dealers) into ONE CSV bill file, and aggregate similar data according to specific rules, distinguish different customer data by filtering the Owner UIN column, or distinguish different reseller data by filtering the Reseller UIN column.
Note:
To facilitate reseller to comprehensively analyze costs and revenues, the Bill by Instance (consolidated) and Bill Details (consolidated, monthly aggregated) bills from the perspective of the Reseller or Distributor contain partner cost data such as "SP Deduction, SP Deduction Rate, SP Deduction (Cost), Reseller Discount Rate, Total Amount After Discount (Excluding Tax), Reseller Voucher Deduction, Amount Before Tax, Tax Rate, Tax Amount, Total Cost (Including Tax)", the perspective of Second-Level Reseller not contain these data.
The Bill by Instance and Bill Details do not contain the partner cost data.
Bill details aggregation rules
1. The transaction type field value is "Hourly settlement, Daily settlement, Spot, Hourly RI fee, Hourly Savings Plan fee" for aggregation, and other types are not aggregated.
2. The following fields with the same values "Payer UIN, Owner UIN, Operator UIN, Reseller UIN, Billing Mode, Transaction Type, Product Name, Subproduct Name, Component Type, Component Name, Instance ID, Instance Name, Region, Availability Zone, Project Name, Component List Price, Component Price Measurement Unit, Customer Component Contracted Price, Price Attribute, Customer Discount Rate, SP Deduction Rate, Reseller Discount Rate, Tax Rate" are aggregated into 1 piece of data.
3. Calculation rules for other fields after aggregation:
Sum the values of the fields including "Original Cost, RI Deduction (Duration), RI Deduction (Cost), Total Amount Before Voucher, Customer Voucher Deduction, Total Cost, SP Deduction, SP Deduction (Cost), Total Amount After Discount (Excluding Tax), Reseller Voucher Deduction, Amount Before Tax, Tax Amount, Total Cost (Including Tax)".
Delete the "Component Usage, Usage Duration" fields in the detailed bill, and sum the values of these two fields and display them in the new fields "SUM of Component Usage, SUM of Usage Duration".
The "Usage Start Time" is the earliest time in the original data aggregated into this data.
The "Usage End Time" is the latest time in the original data aggregated into this data.
"Transaction ID, Transaction Time" is displayed as "-".
The other fields remain unchanged and consistent with the detailed bill before aggregation.