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
| 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
| Name | Accessible by | Required Params | Description |
|---|---|---|---|
get | SELECT | billingAccountName, invoiceName | Gets the transaction summary for an invoice. Transactions include purchases, refunds and Azure usage charges. |
SELECT examples
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 }}'
AND invoiceName = '{{ invoiceName }}';