Invoices: Chargebee Invoices
insert update delete REST
- Catalog:
Chargebee - Schema:
Invoices - Primary Keys:
id - Label: Invoices
Can retrieve data and change data using insert, update and delete.
API Source
- Endpoint:
/invoices
Table Columns
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 and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
amount_ |
decimal |
Amount Adjusted | |||
amount_ |
decimal |
Amount Due | |||
amount_ |
decimal |
Amount Paid | |||
amount_ |
decimal |
Amount to Collect | |||
base_ |
varchar2 |
Base Currency Code | |||
billing_ |
varchar2 |
Billing Address City | |||
billing_ |
varchar2 |
Billing Address Company | |||
billing_ |
varchar2 |
Billing Address Country | |||
billing_ |
varchar2 |
Billing Address Email | |||
billing_ |
varchar2 |
Billing Address First Name | |||
billing_ |
varchar2 |
Billing Address Last Name | |||
billing_ |
varchar2 |
Billing Address Line 1 | |||
billing_ |
varchar2 |
Billing Address Line 2 | |||
billing_ |
varchar2 |
Billing Address Line 3 | |||
billing_ |
varchar2 |
Billing Address Phone | |||
billing_ |
varchar2 |
Billing Address State | |||
billing_ |
varchar2 |
itgen_cbe_billing_address_state_code | |||
billing_ |
varchar2 |
Billing Address Validation Status | |||
billing_ |
varchar2 |
itgen_cbe_billing_address_zip | |||
business_ |
varchar2 |
itgen_cbe_business_entity_id | |||
credits_ |
decimal |
Credits Applied | |||
currency_ |
varchar2 |
Currency Code | |||
customer_ |
varchar2 |
Customer ID | |||
date |
datetime |
Date | |||
deleted |
char |
Deleted | |||
due_ |
datetime |
Due Date | |||
dunning_ |
varchar2 |
Dunning Status | |||
einvoice_ |
varchar2 |
itgen_cbe_einvoice_id | |||
einvoice_ |
varchar2 |
itgen_cbe_einvoice_message | |||
einvoice_ |
varchar2 |
itgen_cbe_einvoice_reference_number | |||
einvoice_ |
varchar2 |
itgen_cbe_einvoice_status | |||
exchange_ |
decimal |
Exchange Rate | |||
expected_ |
datetime |
Expected Payment Date | |||
first_ |
char |
First Invoice | |||
has_ |
char |
Has Advance Charges | |||
id |
varchar2 |
ID | |||
is_ |
char |
Is Gifted | |||
local_ |
varchar2 |
Local Currency Code | |||
net_ |
int32 |
Net Term Days | |||
new_ |
decimal |
New Sales Amount | |||
next_ |
datetime |
Next Retry at | |||
paid_ |
datetime |
Paid at | |||
payment_ |
varchar2 |
Payment Owner | |||
po_ |
varchar2 |
PO Number | |||
price_ |
varchar2 |
Price Type | |||
recurring |
char |
Recurring | |||
resource_ |
int64 |
Resource Version | |||
round_ |
decimal |
Round-off Amount | |||
shipping_ |
varchar2 |
Shipping Address City | |||
shipping_ |
varchar2 |
Shipping Address Company | |||
shipping_ |
varchar2 |
Shipping Address Country | |||
shipping_ |
varchar2 |
Shipping Address Email | |||
shipping_ |
varchar2 |
Shipping Address First Name | |||
shipping_ |
varchar2 |
Shipping Address Last Name | |||
shipping_ |
varchar2 |
Shipping Address Line 1 | |||
shipping_ |
varchar2 |
Shipping Address Line 2 | |||
shipping_ |
varchar2 |
Shipping Address Phone | |||
shipping_ |
varchar2 |
Shipping Address State | |||
shipping_ |
varchar2 |
Shipping Address Validation Status | |||
shipping_ |
varchar2 |
Shipping Address ZIP Code | |||
site_ |
varchar2 |
itgen_cbe_site_details_at_creation_organization_address | |||
site_ |
varchar2 |
itgen_cbe_site_details_at_creation_timezone | |||
status |
varchar2 |
Status | |||
sub_ |
decimal |
Sub-total | |||
sub_ |
decimal |
Sub Total in Local Currency | |||
subscription_ |
varchar2 |
Subscription ID | |||
tax |
decimal |
Tax | |||
term_ |
char |
Term Finalized | |||
total |
decimal |
Total | |||
total_ |
decimal |
Total in Local Currency | |||
updated_ |
datetime |
Updated at | |||
vat_ |
varchar2 |
VAT Number | |||
void_ |
varchar2 |
Void Reason Code | |||
voided_ |
datetime |
Voided at | |||
write_ |
decimal |
Write Off Amount |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: