---
title: "Orders (Chargebee)"
description: "Orders"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/chargebee/Chargebee.Orders.Orders
original: https://documentation.invantive.eu/en/datamodels/chargebee/Chargebee.Orders.Orders
updated: 2024-06-10T18:44:26Z
license: https://documentation.invantive.eu/en/
---

# 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 | [x] |  |  |
| `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:

- [Chargebee](/en/release-notes/drivers?driver=chargebee)

