BillingInvoices
Get billing invoices in the advertiser account.
View-Specific Information
SELECT
The driver uses the Pinterest API to process WHERE clause conditions built with the following columns and operators. Any remaining filters are processed client-side within the driver.
| Column | Supported Operators |
| AdAccountId | = |
| Status | = |
| DocumentType | = |
| StartDueDate | = |
| EndDueDate | = |
For example:
SELECT * FROM BillingInvoices WHERE AdAccountId = '549768561505'
SELECT * FROM BillingInvoices WHERE AdAccountId = '549768561505' AND Status = 'OPEN' AND StartDueDate = '2024-01-01' AND EndDueDate = '2024-12-31'
Columns
| Name | Type | References | Description |
| Id [KEY] | String | Unique identifier for the billing invoice. | |
| AdAccountId | String |
AdAccounts.Id | The ID of the ad account this invoice belongs to. |
| AdAccountName | String | The name of the ad account this invoice belongs to. | |
| AmountBilledMicroCurrency | Long | The amount billed in this invoice, denoted in micro currency. | |
| AmountDiscountMicroCurrency | Long | The discount in this invoice, denoted in micro currency. | |
| AmountNetMicroCurrency | Long | The net amount in this invoice, denoted in micro currency. | |
| AmountTaxMicroCurrency | Long | The tax in this invoice, denoted in micro currency. | |
| BillToCountry | String | The country of the bill-to address. | |
| BillingPeriodStartDate | Date | The start date of the billing period. Format: YYYY-MM-DD. | |
| BillingPeriodEndDate | Date | The end date of the billing period. Format: YYYY-MM-DD. | |
| Currency | String | Currency code from ISO 4217.
The allowed values are UNK, USD. | |
| DocumentType | String | The type of the document.
The allowed values are INVOICE, CREDIT_MEMO. | |
| InvoiceDueDate | Date | The date the invoice is due. Format: YYYY-MM-DD. | |
| PaymentTerms | String | The payment terms of the invoice. | |
| Status | String | The status of the invoice.
The allowed values are OPEN, CLOSED. |
Pseudocolumns
Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description | |
| StartDueDate | Date | Starting point for due dates when searching for invoices. Format: YYYY-MM-DD. | |
| EndDueDate | Date | Ending point for due dates when searching for invoices. Format: YYYY-MM-DD. |