transactions_transaction_summary_by_invoices

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

Overview

Name	transactions_transaction_summary_by_invoices
Type	Resource
Id	azure.billing.transactions_transaction_summary_by_invoices

Fields

The following fields are returned by SELECT queries:

get

A transaction summary.

Name	Datatype	Description
azureCreditApplied	number	The total amount of any Azure credits applied.
billingCurrency	string	The ISO 4217 code for the currency in which the transactions are billed.
consumptionCommitmentDecremented	number	The total Microsoft Azure Consumption Commitment (MACC) decrement through the invoice.
subTotal	number	The total pre-tax charged amount.
tax	number	The total tax amount applied.
total	number	The total charges.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	billingAccountName, invoiceName	filter, search	Gets the transaction summary for an invoice. Transactions include purchases, refunds and Azure usage charges.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
billingAccountName	string	The ID that uniquely identifies a billing account.
invoiceName	string	The ID that uniquely identifies an invoice.
filter	string	The filter query option allows clients to filter the line items that are aggregated to create the line item summary.
search	string	The search query option allows clients to filter the line items that are aggregated to create the line item summary.

SELECT examples

get

Gets the transaction summary for an invoice. Transactions include purchases, refunds and Azure usage charges.

SELECT
azureCreditApplied,
billingCurrency,
consumptionCommitmentDecremented,
subTotal,
tax,
total
FROM azure.billing.transactions_transaction_summary_by_invoices
WHERE billingAccountName = '{{ billingAccountName }}' -- required
AND invoiceName = '{{ invoiceName }}' -- required
AND filter = '{{ filter }}'
AND search = '{{ search }}'
;