Catalog: Chargebee
Schema: Quotes
Primary Keys: id
Label: Quote 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: /quotes
Insert Chargebee API URL: /quotes
Update Chargebee API URL: /quotes
Delete Chargebee API URL: /quotes
Field Selection Method: NotRequired
Base Path: list[*].quote.line_items[*]
The columns of the table QuoteLineItems 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 |
☑ |
|
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 |
☐ |
|
quote_id |
string |
Quote ID |
☑ |
|
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