Chargebee API Data ModelCatalog: Chargebee
Schema: Invoices
Primary Keys: id
Label: Invoice Line Items
This is a read-only table. The Chargebee API may not support changing the data or the Invantive SQL driver for Chargebee does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Chargebee API.
Select Chargebee API URL: /invoices
Insert Chargebee API URL: /invoices
Update Chargebee API URL: /invoices
Delete Chargebee API URL: /invoices
Field Selection Method: NotRequired
Base Path: list[*].invoice.line_items[*]
Table Columns
The columns of the table InvoiceLineItems are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
|---|---|---|---|---|
amount |
decimal |
Amount |
☐ |
|
amount_in_decimal |
string |
Amount in Decimal |
☐ |
|
customer_id |
string |
Customer ID |
☐ |
|
date_from |
datetime |
Date from |
☐ |
|
date_to |
datetime |
Date to |
☐ |
|
description |
string |
Description |
☐ |
|
discount_amount |
decimal |
Discount Amount |
☐ |
|
entity_description |
string |
Entity Description |
☐ |
|
entity_id |
string |
Entity ID |
☐ |
|
entity_type |
string |
Entity Type |
☐ |
|
id |
string |
ID |
☑ |
|
invoice_id |
string |
Invoice ID |
☑ |
|
is_taxed |
boolean |
Is Taxed |
☐ |
|
item_level_discount_amount |
decimal |
Item Level Discount Amount |
☐ |
|
pricing_model |
string |
Pricing Model |
☐ |
|
quantity |
int32 |
Quantity |
☐ |
|
quantity_in_decimal |
string |
Quantity in Decimal |
☐ |
|
subscription_id |
string |
Subscription ID |
☐ |
|
tax_amount |
decimal |
Tax Amount |
☐ |
|
tax_exempt_reason |
string |
Tax Exempt Reason |
☐ |
|
tax_rate |
decimal |
Tax Rate |
☐ |
|
unit_amount |
decimal |
Unit Amount |
☐ |
|
unit_amount_in_decimal |
string |
Unit Amount in Decimal |
☐ |
|
12-12-2020 18:45 Version 20.1.301-BETA+3023
