accounts

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

Overview

Name	accounts
Type	Resource
Id	azure.billing.accounts

Fields

vw_accounts

Name	Datatype	Description
account_status	text	field from the properties object
account_status_reason_code	text	field from the properties object
account_sub_type	text	field from the properties object
account_type	text	field from the properties object
agreement_type	text	field from the properties object
billingAccountName	text	field from the properties object
billing_relationship_types	text	field from the properties object
display_name	text	field from the properties object
enrollment_details	text	field from the properties object
has_no_billing_profiles	text	field from the properties object
has_read_access	text	field from the properties object
notification_email_address	text	field from the properties object
primary_billing_tenant_id	text	field from the properties object
provisioning_state	text	field from the properties object
qualifications	text	field from the properties object
registration_number	text	field from the properties object
sold_to	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 < > % & \ ? /
tax_ids	text	field from the properties object

accounts

Name	Datatype	Description
properties	object	A billing account.
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	SELECT	billingAccountName	Gets a billing account by its ID.
list	SELECT		Lists the billing accounts that a user has access to.
update	UPDATE	billingAccountName	Updates the properties of a billing account. Currently, displayName and address can be updated for billing accounts with agreement type Microsoft Customer Agreement. Currently address and notification email address can be updated for billing accounts with agreement type Microsoft Online Services Agreement. Currently, purchase order number can be edited for billing accounts with agreement type Enterprise Agreement.
add_payment_terms	EXEC	billingAccountName	Adds payment terms to all the billing profiles under the billing account. Currently, payment terms can be added only on billing accounts that have Agreement Type as 'Microsoft Customer Agreement' and AccountType as 'Enterprise'. This action needs pre-authorization and only Field Sellers are authorized to add the payment terms and is not a self-serve action.
cancel_payment_terms	EXEC	billingAccountName	Cancels all the payment terms on billing account that falls after the cancellation date in the request. Currently, cancel payment terms is only served by admin actions and is not a self-serve action.
confirm_transition	EXEC	billingAccountName	Gets the transition details for a billing account that has transitioned from agreement type Microsoft Online Services Program to agreement type Microsoft Customer Agreement.
validate_payment_terms	EXEC	billingAccountName	Validates payment terms on a billing account with agreement type 'Microsoft Customer Agreement' and account type 'Enterprise'.

SELECT examples

Lists the billing accounts that a user has access to.

vw_accounts

SELECT
account_status,
account_status_reason_code,
account_sub_type,
account_type,
agreement_type,
billingAccountName,
billing_relationship_types,
display_name,
enrollment_details,
has_no_billing_profiles,
has_read_access,
notification_email_address,
primary_billing_tenant_id,
provisioning_state,
qualifications,
registration_number,
sold_to,
tags,
tax_ids
FROM azure.billing.vw_accounts
;

accounts

SELECT
properties,
tags
FROM azure.billing.accounts
;

UPDATE example

Updates a accounts resource.

/*+ update */
UPDATE azure.billing.accounts
SET 
tags = '{{ tags }}',
properties = '{{ properties }}'
WHERE 
billingAccountName = '{{ billingAccountName }}';