transactions_by_invoice_sections
Creates, updates, deletes, gets or lists a transactions_by_invoice_sections resource.
Overview
| Name | transactions_by_invoice_sections |
| Type | Resource |
| Id | azure.billing.transactions_by_invoice_sections |
Fields
| Name | Datatype | Description |
|---|---|---|
properties | object | A transaction. |
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 |
|---|---|---|---|
list | SELECT | billingAccountName, billingProfileName, invoiceSectionName, periodEndDate, periodStartDate, type | Lists the billed or unbilled transactions by invoice section name for given start date and end date. Transactions include purchases, refunds and Azure usage charges. Unbilled transactions are listed under pending invoice Id and do not include tax. Tax is added to the amount once an invoice is generated. |
SELECT examples
Lists the billed or unbilled transactions by invoice section name for given start date and end date. Transactions include purchases, refunds and Azure usage charges. Unbilled transactions are listed under pending invoice Id and do not include tax. Tax is added to the amount once an invoice is generated.
SELECT
properties,
tags
FROM azure.billing.transactions_by_invoice_sections
WHERE billingAccountName = '{{ billingAccountName }}'
AND billingProfileName = '{{ billingProfileName }}'
AND invoiceSectionName = '{{ invoiceSectionName }}'
AND periodEndDate = '{{ periodEndDate }}'
AND periodStartDate = '{{ periodStartDate }}'
AND type = '{{ type }}';