invantive documentation
Invantive Support ForumsLog In / Sign Up

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_adjusted decimal Amount Adjusted
amount_due decimal Amount Due
amount_paid decimal Amount Paid
amount_to_collect decimal Amount to Collect
base_currency_code varchar2 Base Currency Code
billing_address_city varchar2 Billing Address City
billing_address_company varchar2 Billing Address Company
billing_address_country varchar2 Billing Address Country
billing_address_email varchar2 Billing Address Email
billing_address_first_name varchar2 Billing Address First Name
billing_address_last_name varchar2 Billing Address Last Name
billing_address_line1 varchar2 Billing Address Line 1
billing_address_line2 varchar2 Billing Address Line 2
billing_address_line3 varchar2 Billing Address Line 3
billing_address_phone varchar2 Billing Address Phone
billing_address_state varchar2 Billing Address State
billing_address_state_code varchar2 itgen_cbe_billing_address_state_code
billing_address_validation_status varchar2 Billing Address Validation Status
billing_address_zip varchar2 itgen_cbe_billing_address_zip
business_entity_id varchar2(50) itgen_cbe_business_entity_id
credits_applied decimal Credits Applied
currency_code varchar2 Currency Code
customer_id varchar2 Customer ID
date datetime Date
deleted char Deleted
due_date datetime Due Date
dunning_status varchar2 Dunning Status
einvoice_id varchar2 itgen_cbe_einvoice_id
einvoice_message varchar2 itgen_cbe_einvoice_message
einvoice_reference_number varchar2 itgen_cbe_einvoice_reference_number
einvoice_status varchar2 itgen_cbe_einvoice_status
exchange_rate decimal Exchange Rate
expected_payment_date datetime Expected Payment Date
first_invoice char First Invoice
has_advance_charges char Has Advance Charges
id varchar2 ID
is_gifted char Is Gifted
local_currency_code varchar2 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 varchar2 Payment Owner
po_number varchar2 PO Number
price_type varchar2 Price Type
recurring char Recurring
resource_version int64 Resource Version
round_off_amount decimal Round-off Amount
shipping_address_city varchar2 Shipping Address City
shipping_address_company varchar2 Shipping Address Company
shipping_address_country varchar2 Shipping Address Country
shipping_address_email varchar2 Shipping Address Email
shipping_address_first_name varchar2 Shipping Address First Name
shipping_address_last_name varchar2 Shipping Address Last Name
shipping_address_line1 varchar2 Shipping Address Line 1
shipping_address_line2 varchar2 Shipping Address Line 2
shipping_address_phone varchar2 Shipping Address Phone
shipping_address_state varchar2 Shipping Address State
shipping_address_validation_status varchar2 Shipping Address Validation Status
shipping_address_zip varchar2 Shipping Address ZIP Code
site_details_at_creation_organization_address varchar2 itgen_cbe_site_details_at_creation_organization_address
site_details_at_creation_timezone varchar2 itgen_cbe_site_details_at_creation_timezone
status varchar2 Status
sub_total decimal Sub-total
sub_total_in_local_currency decimal Sub Total in Local Currency
subscription_id varchar2 Subscription ID
tax decimal Tax
term_finalized char Term Finalized
total decimal Total
total_in_local_currency decimal Total in Local Currency
updated_at datetime Updated at
vat_number varchar2 VAT Number
void_reason_code varchar2 Void Reason Code
voided_at datetime Voided at
write_off_amount decimal Write Off Amount

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: