Please enable JavaScript to view this site.

Chargebee API Data Model

Navigation: Schema: Quotes > Tables

Quotes: Chargebee Quotes

Contents Previous Home Next More

Catalog: Chargebee

Schema: Quotes

Primary Keys: id

Label: Quotes

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

Select Chargebee API URL: /quotes

Insert Chargebee API URL: /quotes

Update Chargebee API URL: /quotes

Delete Chargebee API URL: /quotes

Field Selection Method: NotRequired

Base Path: list[*].quote

Table Columns

The columns of the table Quotes 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 or update.

Name

Data Type

Label

Required

Documentation

amount_due

decimal

Amount Due

☐

 

amount_paid

decimal

Amount Paid

☐

 

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

string

Billing Address State

☐

 

billing_address_validation_status

string

Billing Address Validation Status

☐

 

billing_address_zip

string

 

☐

 

charge_on_acceptance

decimal

Charge on Acceptance

☐

 

contract_term_end

datetime

Contract Term End

☐

 

contract_term_start

datetime

Contract Term Start

☐

 

contract_term_termination_fee

decimal

Contract Term Termination Fee

☐

 

credits_applied

decimal

Credits Applied

☐

 

currency_code

string

Currency Code

☐

 

customer_id

string

Customer ID

☐

 

date

datetime

Date

☐

 

id

string

ID

☑

 

invoice_id

string

Invoice ID

☐

 

name

string

Name

☐

 

operation_type

string

Operation Type

☐

 

po_number

string

PO Number

☐

 

price_type

string

Price Type

☐

 

resource_version

int64

Resource Version

☐

 

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

string

Shipping Address State

☐

 

shipping_address_validation_status

string

Shipping Address Validation Status

☐

 

shipping_address_zip

string

Shipping Address ZIP Code

☐

 

status

string

Status

☐

 

sub_total

decimal

Sub-total

☐

 

subscription_id

string

Subscription ID

☐

 

total

decimal

Total

☐

 

total_payable

decimal

Total Payable

☐

 

updated_at

datetime

Updated at

☐

 

valid_till

datetime

Valid till

☐

 

vat_number

string

VAT Number

☐

 

version

int32

Version

☐

 

 

12-12-2020 18:45 Version 20.1.301-BETA+3023