Chargebee API Data ModelCatalog: Chargebee
Schema: Orders
Primary Keys: id
Label: Order 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: /orders
Insert Chargebee API URL: /orders
Update Chargebee API URL: /orders
Delete Chargebee API URL: /orders
Field Selection Method: NotRequired
Base Path: list[*].order.line_items[*]
Table Columns
The columns of the table OrderLineItems are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
|---|---|---|---|---|
amount |
decimal |
Amount |
☐ |
|
amount_adjusted |
decimal |
Amount Adjusted |
☐ |
|
amount_paid |
decimal |
Amount Paid |
☐ |
|
description |
string |
Description |
☐ |
|
discount_amount |
decimal |
Discount Amount |
☐ |
|
entity_id |
string |
Entity ID |
☐ |
|
entity_type |
string |
Entity Type |
☐ |
|
fulfillment_amount |
decimal |
Fulfillment Amount |
☐ |
|
fulfillment_quantity |
decimal |
Fulfillment Quantity |
☐ |
|
id |
string |
ID |
☑ |
|
invoice_id |
string |
Invoice ID |
☐ |
|
invoice_line_item_id |
string |
Invoice Line Item ID |
☐ |
|
is_shippable |
boolean |
Is Shippable |
☐ |
|
item_level_discount_amount |
decimal |
Item Level Discount Amount |
☐ |
|
order_id |
string |
Order ID |
☑ |
|
refundable_credits |
decimal |
Refundable Credits |
☐ |
|
refundable_credits_issued |
decimal |
Refundable Credits Issued |
☐ |
|
sku |
string |
SKU |
☐ |
|
status |
string |
Status |
☐ |
|
tax_amount |
decimal |
Tax Amount |
☐ |
|
unit_price |
decimal |
Unit Price |
☐ |
|
12-12-2020 18:45 Version 20.1.301-BETA+3023
