Querying Bill Details of Monthly Expenditures

Function

This API is used to query bill details of monthly expenditures.

For details about how to query the bill details of monthly expenditures in the Partner Center, click here.

Bill File

A partner can subscribe to the partner bill (customer resource usage) in the HUAWEI CLOUD Partner Center. For details, see File Subscription. Your sales platform will calculate the customer expenditures and generate the customer bills based on this bill and then you can perform reconciliation with HUAWEI CLOUD.

1. Link to Obtain the File

   https://bucketname.obs.Endpoint.myhuaweicloud.com/customerBill/filename

   Table 1 Parameter descriptions

   Parameter	Description
   bucketname	Indicates the name of the OBS bucket created by the partner. Only OBS buckets purchased on HUAWEI CLOUD in the Hong Kong region can be used. For details about how to create a bucket, see Creating a Bucket.
   Endpoint	Domain name or IP address of the server bearing the REST service endpoint. Obtain this value from Regions and Endpoints.
   customerBill	Name of the folder for storing the partner bill details file uploaded by the system.
   filename	File name. The name of a bill details file is in customerBill_YYYYMM.tar.gz format. In the preceding command, customerBill_YYYYMM.tar.gz is a compressed package. The files contained in the package are named in customerBill_YYYYMM_xxxx.csv format. Each CSV file contains 100,000 records.

2. File Generation Cycle

   The file is generated each natural month.

   The system automatically creates the file of previous month before 12:00 (Beijing Time) at the fifth day of each month and uploads the file to the created OBS bucket. If the upload fails on the current day, the system uploads the file again next day. If the upload still fails, the system uploads the file the day after that day. The system can try a maximum of five times. Every time when the upload fails, the system sends a failure notification email to the email address of the partner.

3. File Fields

   Parameter	Type	Value Range	Description
   Customer ID	String	A maximum of 64 characters	Domain ID of a customer.
   Product ID	String	A maximum of 64 characters	Product ID
   Service Type Code	String	A maximum of 64 characters	Cloud service type code. For example, the cloud service type code of OBS is hws.service.type.obs. To obtain a specific service type, call the API in Querying Cloud Service Types.
   Resource Type Code	String	A maximum of 100 characters	Resource type code. For example, the VM resource type code of ECS is hws.resource.type.vm. To obtain a specific resource type, call the API in Querying Resource Types.
   Cloud Service Region Code	String	A maximum of 64 characters	Cloud service region code, for example, cn-north-1. Obtain the value from the Region column in Regions and Endpoints.
   Billing Mode	String	A maximum of 2 characters	0: Yearly/monthly 1: Pay-per-use 2: Reserved instance–upfront payment 3: Reserved instance–hourly billing
   List Price	BigDecimal	-	List price or promotional price at which customers purchased HUAWEI CLOUD products, in US dollars.
   Fee Generation Time	String	A maximum of 32 characters	Time when fees are generated. The format is YYYY-MM, indicating year-month.
   Order ID	String	A maximum of 64 characters	Order ID. This field is available only for yearly/monthly subscriptions.
   Usage	BigDecimal	-	Usage (usage of packages and reserved instances not included). This field is available only for pay-per-use subscriptions.
   Usage Unit	Integer	-	Usage unit. You can call the API in Querying Measurement Units to obtain the value.
   Whether a Spot ECS	String	A maximum of 1 character	2: Yes
   Cash Coupon Amount	BigDecimal	-	Cash coupon amount, in US dollars. It specifies the amount deducted using cash coupons.
   Flexi-purchase Coupon Amount	BigDecimal	-	Flexi-purchase coupon amount (reserved).
   Stored-value Card Amount	BigDecimal	-	Stored-value card amount (reserved).
   Settlement Product Type	Integer	-	0: List-price offering 1: Promotional offering 2: Hybrid hosting products 5: Stored-value card 6: Marketplace products 7: Spot ECSs 8: FCS (reserved) 11: Special price request
   Partner Preference Ratio	BigDecimal	-	Discount percentage for each settlement type. Leave this parameter empty when Partner Preferential Type is set to 1.
   Currency	String	A maximum of 3 characters	USD
   Billing Cycle	String	A maximum of 32 characters	Billing cycle, in the YYYY-MM format.
   Customer Account	String	A maximum of 64 characters	HUAWEI CLOUD username of the customer.
   Customer Name	String	A maximum of 192 characters	Name used by the customer for real-name authentication. If the customer does not perform real-name authentication, this field is left blank.
   Product Name	String	A maximum of 576 characters	Product name.
   Product Type Name	String	A maximum of 192 characters	Cloud service name, which can be obtained by calling the API in Querying Cloud Service Types.
   Resource Type Name	String	A maximum of 192 characters	Resource type name, which can be obtained by calling the API in Querying Resource Types.
   Cloud Service Region Name	String	A maximum of 96 characters	Cloud service region. For details, see Regions and Endpoints.
   Package Usage	BigDecimal	-	Used amount of the package. The used resources are not calculated using the pay-per-use price.
   Unit (Package Usage)	Integer	-	Package usage unit. For details, see Usage Unit. If the package usage is 0, this field is left blank.
   Reserved Instance Usage	BigDecimal	-	Used reserved instance. The used resources are not calculated using the pay-per-use price.
   Unit (Reserved Instance Usage)	Integer	-	Reserved instance usage unit. For details, see Usage Unit. If the reserved instance usage is 0, this field is left blank.
   Bill Type	String	A maximum of 1 character	Type of a bill item. 0: Expenditure 1: Unsubscription 2: Huawei write-off
   BizID	String	A maximum of 64 characters	Business ID.
   BizItemID	String	A maximum of 64 characters	Business item ID.
   Amount after Coupons	BigDecimal	-	Consumption amount of a customer, excluding the amount of flexi-purchase coupons, cash coupons, and stored-value cards.
   Amount Due	BigDecimal	-	Bill amount that a partner must pay.
   Specifications	String	A maximum of 256 characters	Product specifications, such as General Computing|s2.small.1|1vCPUs|1GB|linux. General Computing|s2.small.1|1vCPUs|1GB|linux
   Billing Item	String	A maximum of 256 characters	Billing item To obtain a specific billing item, call the API in Querying Usage Types. The value is the same as the usage type in SDRs. The mappings between cloud services and usage types are as follows: ECS: Duration EVS: Duration EIP: Duration Bandwidth: Duration (by bandwidth) or upflow (by traffic) Marketplace image: Duration
   Unit Price	BigDecimal	-	Unit price. For the unit price of a pay-per-use product, this parameter has a value only when the price is the same. For tiered billing, this parameter is left empty. Unit price of a yearly/monthly product is returned only in the following scenarios: Yearly/monthly subscription, renewal, specification downsizing, specification upgrade, and capacity expansion Simple pricing Unit price of a reserved instance is returned only in the following scenarios: Subscription, renewal, specification downsizing, specification upgrade, capacity expansion, and pay-per-use Simple pricing
   Unit	String	A maximum of 256 characters	Price unit For example, the price is 0.6 yuan/10,000 times. The unit price is 0.6, the price unit is yuan, and the step is 10,000 times. The unit price is 0.6 and the price unit is yuan/10,000 times.
   Settlement Amount	BigDecimal	-	When Partner Preferential Type is set to 0, the settlement amount is calculated as follows: Settlement amount = List price x (1 – Partner discount ratio). When Partner Preferential Type is set to 1, the settlement amount is calculated based on the fixed unit price. The settlement amount includes the cash coupon amount and does not include the tax amount. Unit: USD ($)
   Partner Coupon	BigDecimal	-	Amount of the cash coupon that is deducted after a discount is used. Unit: USD ($)
   Scene	String	-	Whether to refund partner's cash coupon generated during the refund. Unit: USD ($) Y: yes N: no
   Partner Amount Without Tax	BigDecimal	-	Amount that needs to pay after partner's cash coupons are deducted. Unit: USD ($) NOTE: If Scene is set to Y, this parameter value is calculated as follows: Partner amount without tax = Settlement amount – Partner coupon If Scene is set to N, the partner amount without tax equals the settlement amount.
   Tax Amount	BigDecimal	-	Tax amount. If tax determination is not involved or the tax base is 0, the tax amount is 0. Unit: USD ($)
   Usage Type Name	String	-	Usage type name. To obtain a specific type, call the API in Querying Usage Types.
   Partner Preferential Type	String	-	Partner preferential type. The options are as follows: 0: Discount 1: Fixed unit price

   

   • When Partner Preferential Type is set to 0, Amount due = List price x (1 – Partner discount ratio) – Partner coupon + Tax amount.
   • When Partner Preferential Type is set to 1, Amount due = Settlement amount - Partner coupon + Tax amount.

4. Sample File

   Customer ID,Product ID,Product type code,Resource type code,Cloud service region code,Billing mode,Official website price,Fee generation time,Order ID,Usage,Usage Unit,Whether a spot ECS,Coupon amount,Flexi-purchase coupon amount,Stored-value card amount,Settlement product type,Partner preference ratio,Currency,Billing cycle,Customer account,Customer name,Product name,Product type name,Resource type name,Cloud service region name,Package Usage,Unit (Package Usage),Reserved Instance Usage,Reserved Instance Usage,Bill Type,BizID,BizItemID,Amount after Coupons,Amount DueSpecifications,Billing item,Unit Price,Unit,Settlement Amount,Partner Coupon,Scene,Partner Amount Without Tax,Tax Amount,Usage Type Name,Partner Preferential Type

   05876442ca80d5cc0f2dc01c66d6d0c0,00301-25435-0--0,hws.service.type.ebs,hws.resource.type.volume,cn-east-2, 0,30.3,Jan-21,CS2008210926C178U,,,,10,0,0,0,0.75,USD,Jan-21,xiajing_zs_hff,,GD3 linear EVS pay-per-use package,EVS,EVS,CN East-Shanghai2,0,,0,,0,,,20.3,16.05,Common I/O,,0.001,USD/1GB,25.22,10,,15.22,0.83,0,