available_balances

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

Overview

Name	available_balances
Type	Resource
Id	azure.billing.available_balances

Fields

vw_available_balances

Name	Datatype	Description
amount	text	field from the properties object
billingAccountName	text	field from the properties object
billingProfileName	text	field from the properties object
payments_on_account	text	field from the properties object
tags	text	Dictionary of metadata associated with the resource. It may not be populated for all resource types. Maximum key/value length supported of 256 characters. Keys/value should not empty value nor null. Keys can not contain < > % & \ ? /
total_payments_on_account	text	field from the properties object

available_balances

Name	Datatype	Description
properties	object	The Available Credit or Payment on Account Balance. The credit balance can be used to settle due or past due invoices.
tags	object	Dictionary of metadata associated with the resource. It may not be populated for all resource types. Maximum key/value length supported of 256 characters. Keys/value should not empty value nor null. Keys can not contain < > % & \ ? /

Methods

Name	Accessible by	Required Params	Description
get_by_billing_account	SELECT	billingAccountName	The Available Credit or Payment on Account Balance for a billing account. The credit balance can be used to settle due or past due invoices and is supported for billing accounts with agreement type Microsoft Customer Agreement. The payment on account balance is supported for billing accounts with agreement type Microsoft Customer Agreement or Microsoft Online Services Program.
get_by_billing_profile	SELECT	billingAccountName, billingProfileName	The Available Credit or Payment on Account Balance for a billing profile. The credit balance can be used to settle due or past due invoices and is supported for billing accounts with agreement type Microsoft Customer Agreement. The payment on account balance is supported for billing accounts with agreement type Microsoft Customer Agreement.

SELECT examples

The Available Credit or Payment on Account Balance for a billing account. The credit balance can be used to settle due or past due invoices and is supported for billing accounts with agreement type Microsoft Customer Agreement. The payment on account balance is supported for billing accounts with agreement type Microsoft Customer Agreement or Microsoft Online Services Program.

vw_available_balances

SELECT
amount,
billingAccountName,
billingProfileName,
payments_on_account,
tags,
total_payments_on_account
FROM azure.billing.vw_available_balances
WHERE billingAccountName = '{{ billingAccountName }}';

available_balances

SELECT
properties,
tags
FROM azure.billing.available_balances
WHERE billingAccountName = '{{ billingAccountName }}';