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
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