Orders: Chargebee Orders
insert update delete REST
- Catalog:
Chargebee - Schema:
Orders - Primary Keys:
id - Label: Orders
Can retrieve data and change data using insert, update and delete.
API Source
- Endpoint:
/orders
Table Columns
The columns of the table Orders are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
amount_ |
decimal |
Amount Adjusted | |||
amount_ |
decimal |
Amount Paid | |||
batch_ |
varchar2 |
Batch ID | |||
billing_ |
varchar2 |
Billing Address City | |||
billing_ |
varchar2 |
Billing Address Company | |||
billing_ |
varchar2 |
Billing Address Country | |||
billing_ |
varchar2 |
Billing Address Email | |||
billing_ |
varchar2 |
Billing Address First Name | |||
billing_ |
varchar2 |
Billing Address Last Name | |||
billing_ |
varchar2 |
Billing Address Line 1 | |||
billing_ |
varchar2 |
Billing Address Line 2 | |||
billing_ |
varchar2 |
Billing Address Line 3 | |||
billing_ |
varchar2 |
Billing Address Phone | |||
billing_ |
varchar2 |
Billing Address State | |||
billing_ |
varchar2 |
itgen_cbe_billing_address_state_code | |||
billing_ |
varchar2 |
Billing Address Validation Status | |||
billing_ |
varchar2 |
itgen_cbe_billing_address_zip | |||
business_ |
varchar2 |
itgen_cbe_business_entity_id | |||
cancellation_ |
varchar2 |
Cancellation Reason | |||
cancelled_ |
datetime |
Cancelled at | |||
created_ |
datetime |
Created at | |||
created_ |
datetime |
Created by | |||
currency_ |
varchar2 |
Currency Code | |||
customer_ |
varchar2 |
Customer ID | |||
deleted |
char |
Deleted | |||
delivered_ |
datetime |
Delivered at | |||
discount |
decimal |
Discount | |||
document_ |
varchar2 |
Document Number | |||
fulfillment_ |
varchar2 |
Fulfillment Status | |||
gift_ |
varchar2 |
Gift ID | |||
gift_ |
varchar2 |
Gift Note | |||
id |
varchar2 |
ID | |||
invoice_ |
varchar2 |
Invoice ID | |||
invoice_ |
decimal |
Invoice Round-off Amount | |||
is_ |
char |
Is Gifted | |||
is_ |
char |
itgen_cbe_is_resent | |||
note |
varchar2 |
Note | |||
order_ |
datetime |
Order Date | |||
order_ |
varchar2 |
Order Type | |||
original_ |
varchar2 |
itgen_cbe_original_order_id | |||
paid_ |
datetime |
Paid on | |||
payment_ |
varchar2 |
Payment Status | |||
price_ |
varchar2 |
Price Type | |||
reference_ |
varchar2 |
Reference ID | |||
refundable_ |
decimal |
Refundable Credits | |||
refundable_ |
decimal |
Refundable Credits Issued | |||
resend_ |
varchar2 |
itgen_cbe_resend_reason | |||
resent_ |
varchar2 |
itgen_cbe_resent_status | |||
resource_ |
int64 |
Resource Version | |||
rounding_ |
decimal |
Rounding Adjustement | |||
shipment_ |
varchar2 |
Shipment Carrier | |||
shipped_ |
datetime |
Shipped at | |||
shipping_ |
varchar2 |
Shipping Address City | |||
shipping_ |
varchar2 |
Shipping Address Company | |||
shipping_ |
varchar2 |
Shipping Address Country | |||
shipping_ |
varchar2 |
Shipping Address Email | |||
shipping_ |
varchar2 |
Shipping Address First Name | |||
shipping_ |
varchar2 |
Shipping Address Last Name | |||
shipping_ |
varchar2 |
Shipping Address Line 1 | |||
shipping_ |
varchar2 |
Shipping Address Line 2 | |||
shipping_ |
varchar2 |
Shipping Address Phone | |||
shipping_ |
varchar2 |
Shipping Address State | |||
shipping_ |
varchar2 |
itgen_cbe_shipping_address_state_code | |||
shipping_ |
varchar2 |
Shipping Address Validation Status | |||
shipping_ |
varchar2 |
Shipping Address ZIP Code | |||
shipping_ |
datetime |
Shipping Cut-off Date | |||
shipping_ |
datetime |
Shipping Date | |||
status |
varchar2 |
Status | |||
status_ |
datetime |
Status Update at | |||
sub_ |
decimal |
Sub-total | |||
subscription_ |
varchar2 |
Subscription ID | |||
tax |
decimal |
Tax | |||
total |
decimal |
Total | |||
tracking_ |
varchar2 |
Tracking ID | |||
updated_ |
datetime |
Updated at |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: