Catalog: Chargebee
Schema: Invoices
Primary Keys: id
Label: Invoices
Can retrieve data and change data using insert, update and delete.
Select Chargebee API URL: /invoices
Insert Chargebee API URL: /invoices
Update Chargebee API URL: /invoices
Delete Chargebee API URL: /invoices
Field Selection Method: NotRequired
Base Path: list[*].invoice
The columns of the table Invoices 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_adjusted |
decimal |
Amount Adjusted |
☐ |
|
amount_due |
decimal |
Amount Due |
☐ |
|
amount_paid |
decimal |
Amount Paid |
☐ |
|
amount_to_collect |
decimal |
Amount to Collect |
☐ |
|
base_currency_code |
string |
Base Currency Code |
☐ |
|
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 |
|
☐ |
|
credits_applied |
decimal |
Credits Applied |
☐ |
|
currency_code |
string |
Currency Code |
☐ |
|
customer_id |
string |
Customer ID |
☐ |
|
date |
datetime |
Date |
☐ |
|
deleted |
boolean |
Deleted |
☐ |
|
due_date |
datetime |
Due Date |
☐ |
|
dunning_status |
string |
Dunning Status |
☐ |
|
exchange_rate |
decimal |
Exchange Rate |
☐ |
|
expected_payment_date |
datetime |
Expected Payment Date |
☐ |
|
first_invoice |
boolean |
First Invoice |
☐ |
|
has_advance_charges |
boolean |
Has Advance Charges |
☐ |
|
id |
string |
ID |
☑ |
|
is_gifted |
boolean |
Is Gifted |
☐ |
|
local_currency_code |
string |
Local Currency Code |
☐ |
|
net_term_days |
int32 |
Net Term Days |
☐ |
|
new_sales_amount |
decimal |
New Sales Amount |
☐ |
|
next_retry_at |
datetime |
Next Retry at |
☐ |
|
paid_at |
datetime |
Paid at |
☐ |
|
payment_owner |
string |
Payment Owner |
☐ |
|
po_number |
string |
PO Number |
☐ |
|
price_type |
string |
Price Type |
☐ |
|
recurring |
boolean |
Recurring |
☐ |
|
resource_version |
int64 |
Resource Version |
☐ |
|
round_off_amount |
decimal |
Round-off Amount |
☐ |
|
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 |
☐ |
|
sub_total_in_local_currency |
decimal |
Sub Total in Local Currency |
☐ |
|
subscription_id |
string |
Subscription ID |
☐ |
|
tax |
decimal |
Tax |
☐ |
|
term_finalized |
boolean |
Term Finalized |
☐ |
|
total |
decimal |
Total |
☐ |
|
total_in_local_currency |
decimal |
Total in Local Currency |
☐ |
|
updated_at |
datetime |
Updated at |
☐ |
|
vat_number |
string |
VAT Number |
☐ |
|
void_reason_code |
string |
Void Reason Code |
☐ |
|
voided_at |
datetime |
Voided at |
☐ |
|
write_off_amount |
decimal |
Write Off Amount |
☐ |
|
12-12-2020 18:45 Version 20.1.301-BETA+3023