Skip to main content

balances_for_billing_period_by_billing_accounts

Creates, updates, deletes, gets or lists a balances_for_billing_period_by_billing_accounts resource.

Overview

Namebalances_for_billing_period_by_billing_accounts
TypeResource
Idazure.consumption.balances_for_billing_period_by_billing_accounts

Fields

NameDatatypeDescription
idtextThe full qualified ARM ID of an event.
nametextThe ID that uniquely identifies an event.
adjustment_detailstextfield from the properties object
adjustmentstextfield from the properties object
azure_marketplace_service_chargestextfield from the properties object
beginning_balancetextfield from the properties object
billingAccountIdtextfield from the properties object
billingPeriodNametextfield from the properties object
billing_frequencytextfield from the properties object
charges_billed_separatelytextfield from the properties object
currencytextfield from the properties object
ending_balancetextfield from the properties object
etagtextThe etag for the resource.
new_purchasestextfield from the properties object
new_purchases_detailstextfield from the properties object
overage_refundtextfield from the properties object
price_hiddentextfield from the properties object
service_overagetextfield from the properties object
tagstextResource tags.
total_overagetextfield from the properties object
total_usagetextfield from the properties object
typetextResource type.
utilizedtextfield from the properties object

Methods

NameAccessible byRequired ParamsDescription
getSELECTbillingAccountId, billingPeriodNameGets the balances for a scope by billing period and billingAccountId. Balances are available via this API only for May 1, 2014 or later.

SELECT examples

Gets the balances for a scope by billing period and billingAccountId. Balances are available via this API only for May 1, 2014 or later.

SELECT
id,
name,
adjustment_details,
adjustments,
azure_marketplace_service_charges,
beginning_balance,
billingAccountId,
billingPeriodName,
billing_frequency,
charges_billed_separately,
currency,
ending_balance,
etag,
new_purchases,
new_purchases_details,
overage_refund,
price_hidden,
service_overage,
tags,
total_overage,
total_usage,
type,
utilized
FROM azure.consumption.vw_balances_for_billing_period_by_billing_accounts
WHERE billingAccountId = '{{ billingAccountId }}'
AND billingPeriodName = '{{ billingPeriodName }}';