Navigation: Schema: Orders > Tables

Orders: Chargebee Orders

Catalog: Chargebee

Schema: Orders

Primary Keys: id

Label: Orders

Can retrieve data and change data using insert, update and delete.

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

10-06-2024 18:44 Version 24.1.3-BETA+4689

Important Safety and Usage Information

Intended Use and Limitations: This software, developed by Invantive, is designed to support a variety of business and information technology data processing functions, such as accounting, financial reporting an sales reporting. It is important to note that this software is not designed, tested, or approved for use in environments where malfunction or failure could lead to life-threatening situations or severe physical or environmental damage. This includes, but is not limited to:

Nuclear facilities: The software should not be used for operations or functions related to the control, maintenance, or operation of nuclear facilities.
Defense and Military Applications: This software is not suitable for use in defense-related applications, including but not limited to weaponry control, military strategy planning, or any other aspects of national defense.
Aviation: The software is not intended for use in the operation, navigation, or communication systems of any aircraft or air traffic control environments.
Healthcare and Medicine Production: This software should not be utilized for medical device operation, patient data analysis for critical health decisions, pharmaceutical production, or medical research where its failure or malfunction could impact patient health.
Chemical and Hazardous Material Handling: This software is not intended for the management, control, or operational aspects of chemical plants or hazardous material handling facilities. Any malfunction in software used in these settings could result in dangerous chemical spills, explosions, or environmental disasters.
Transportation and Traffic Control Systems: The software should not be used for the control, operation, or management of transportation systems, including railway signal controls, subway systems, or traffic light management. Malfunctions in such critical systems could lead to severe accidents and endanger public safety.
Energy Grid and Utility Control Systems: This software is not designed for the control or operation of energy grid systems, including electrical substations, renewable energy control systems, or water utility control systems. The failure of software in these areas could lead to significant power outages, water supply disruptions, or other public utility failures, potentially endangering communities and causing extensive damage.
Other High-Risk Environments: Any other critical infrastructure and environments where a failure of the software could result in significant harm to individuals or the environment.

User Responsibility: Users must ensure that they understand the intended use of the software and refrain from deploying it in any setting that falls outside of its designed purpose. It is the responsibility of the user to assess the suitability of the software for their intended application, especially in any scenarios that might pose a risk to life, health, or the environment.

Disclaimer of Liability: Invantive disclaims any responsibility for damage, injury, or legal consequences resulting from the use or misuse of this software in prohibited or unintended applications.

Please enable JavaScript to view this site.

Chargebee API Data Model

Orders: Chargebee Orders

Table Columns

Important Safety and Usage Information