invantive documentation
Invantive Support ForumsLog In / Sign Up

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_adjusted decimal Amount Adjusted
amount_paid decimal Amount Paid
batch_id varchar2 Batch ID
billing_address_city varchar2 Billing Address City
billing_address_company varchar2 Billing Address Company
billing_address_country varchar2 Billing Address Country
billing_address_email varchar2 Billing Address Email
billing_address_first_name varchar2 Billing Address First Name
billing_address_last_name varchar2 Billing Address Last Name
billing_address_line1 varchar2 Billing Address Line 1
billing_address_line2 varchar2 Billing Address Line 2
billing_address_line3 varchar2 Billing Address Line 3
billing_address_phone varchar2 Billing Address Phone
billing_address_state varchar2 Billing Address State
billing_address_state_code varchar2 itgen_cbe_billing_address_state_code
billing_address_validation_status varchar2 Billing Address Validation Status
billing_address_zip varchar2 itgen_cbe_billing_address_zip
business_entity_id varchar2 itgen_cbe_business_entity_id
cancellation_reason varchar2 Cancellation Reason
cancelled_at datetime Cancelled at
created_at datetime Created at
created_by datetime Created by
currency_code varchar2 Currency Code
customer_id varchar2 Customer ID
deleted char Deleted
delivered_at datetime Delivered at
discount decimal Discount
document_number varchar2 Document Number
fulfillment_status varchar2 Fulfillment Status
gift_id varchar2 Gift ID
gift_note varchar2 Gift Note
id varchar2 ID
invoice_id varchar2 Invoice ID
invoice_round_off_amount decimal Invoice Round-off Amount
is_gifted char Is Gifted
is_resent char itgen_cbe_is_resent
note varchar2 Note
order_date datetime Order Date
order_type varchar2 Order Type
original_order_id varchar2 itgen_cbe_original_order_id
paid_on datetime Paid on
payment_status varchar2 Payment Status
price_type varchar2 Price Type
reference_id varchar2 Reference ID
refundable_credits decimal Refundable Credits
refundable_credits_issued decimal Refundable Credits Issued
resend_reason varchar2 itgen_cbe_resend_reason
resent_status varchar2 itgen_cbe_resent_status
resource_version int64 Resource Version
rounding_adjustement decimal Rounding Adjustement
shipment_carrier varchar2 Shipment Carrier
shipped_at datetime Shipped at
shipping_address_city varchar2 Shipping Address City
shipping_address_company varchar2 Shipping Address Company
shipping_address_country varchar2 Shipping Address Country
shipping_address_email varchar2 Shipping Address Email
shipping_address_first_name varchar2 Shipping Address First Name
shipping_address_last_name varchar2 Shipping Address Last Name
shipping_address_line1 varchar2 Shipping Address Line 1
shipping_address_line2 varchar2 Shipping Address Line 2
shipping_address_phone varchar2 Shipping Address Phone
shipping_address_state varchar2 Shipping Address State
shipping_address_state_code varchar2 itgen_cbe_shipping_address_state_code
shipping_address_validation_status varchar2 Shipping Address Validation Status
shipping_address_zip varchar2 Shipping Address ZIP Code
shipping_cut_off_date datetime Shipping Cut-off Date
shipping_date datetime Shipping Date
status varchar2 Status
status_update_at datetime Status Update at
sub_total decimal Sub-total
subscription_id varchar2 Subscription ID
tax decimal Tax
total decimal Total
tracking_id varchar2 Tracking ID
updated_at datetime Updated at

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: