---
title: "Invoices (Chargebee)"
description: "Invoices"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/chargebee/Chargebee.Invoices.Invoices
original: https://documentation.invantive.eu/en/datamodels/chargebee/Chargebee.Invoices.Invoices
updated: 2024-06-10T18:44:26Z
license: https://documentation.invantive.eu/en/
---

# 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 | [x] |  |  |
| `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:

- [Chargebee](/en/release-notes/drivers?driver=chargebee)

