InvoiceLineItems
Columns
Name | Type | ReadOnly | References | Description |
Id [KEY] | String | True | The Id of the invoice item. | |
InvoiceId | String | False | Invoices.Id | The Id of the invoice. |
Amount | Int | False | The amount, in cents. | |
Customer | String | False | Customers.Id | Three-letter ISO currency code, in lowercase. Must be a supported currency. |
Currency | String | False | Three-letter ISO currency code, in lowercase. Must be a supported currency. | |
Description | String | False | An arbitrary string attached to the object. Often useful for displaying to users. | |
Discountable | Boolean | False | If true, discounts will apply to this line item. Always false for prorations. | |
PeriodStart | Datetime | False | The set of key/value pairs that you can attach to a customer object. | |
PeriodEnd | Datetime | False | The set of key/value pairs that you can attach to a customer object. | |
PlanId | String | False | The set of key/value pairs that you can attach to a customer object. | |
PlanAggregate | String | True | The plan of the subscription, if the line item is a subscription or a proration. | |
Proration | Boolean | True | Whether this is a proration. | |
Quantity | Int | False | The quantity of the subscription, if the line item is a subscription or a proration. | |
Subscription | String | False | When type is invoiceitem, the subscription that the invoice item pertains to, if any. Left blank when type is already subscription, as it'd be redundant with id. | |
MetadataAggregate | String | False | The metadata object. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
Name | Type | Description |
AccountId | String | The Id of the connected account to get invoice line items for |
Last updated