CreditNotes: Chargebee Credit Notes |
Catalog: Chargebee
Schema: CreditNotes
Primary Keys: id
Label: Credit Notes
Can retrieve data and change data using insert, update and delete.
Table Columns
The columns of the table CreditNotes 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 |
Documentation |
---|---|---|---|---|
amount_allocated |
decimal |
Amount Allocated |
☐ |
|
amount_available |
decimal |
Amount Available |
☐ |
|
amount_refunded |
decimal |
Amount Refunded |
☐ |
|
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 |
|
☐ |
|
business_entity_id |
string |
|
☐ |
|
channel |
string |
|
☐ |
|
create_reason_code |
string |
Create Reason Code |
☐ |
|
currency_code |
string |
Currency Code |
☐ |
|
customer_id |
string |
Customer ID |
☐ |
|
date |
datetime |
Date |
☐ |
|
deleted |
boolean |
Deleted |
☐ |
|
einvoice_id |
string |
|
☐ |
|
einvoice_message |
string |
|
☐ |
|
einvoice_reference_number |
string |
|
☐ |
|
einvoice_status |
string |
|
☐ |
|
fractional_correction |
decimal |
Fractional Correction |
☐ |
|
generated_at |
datetime |
|
☐ |
|
id |
string |
ID |
☑ |
|
local_currency_code |
string |
Local Currency Code |
☐ |
|
local_currency_exchange_rate |
decimal |
|
☐ |
|
price_type |
string |
Price Type |
☐ |
|
reason_code |
string |
|
☐ |
|
reference_invoice_id |
string |
Reference Invoice ID |
☐ |
|
refunded_at |
datetime |
Refunded at |
☐ |
|
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 |
☐ |
|
site_details_at_creation_organization_address |
string |
|
☐ |
|
site_details_at_creation_timezone |
string |
|
☐ |
|
status |
string |
Status |
☐ |
|
sub_total_in_local_currency |
decimal |
Sub Total in Local Currency |
☐ |
|
sub_total |
decimal |
Sub-total |
☐ |
|
subscription_id |
string |
Subscription ID |
☐ |
|
tax_category |
string |
|
☐ |
|
total_in_local_currency |
decimal |
Total in Local Currency |
☐ |
|
total |
decimal |
Total |
☐ |
|
type |
string |
Type |
☐ |
|
updated_at |
datetime |
Updated at |
☐ |
|
vat_number_prefix |
string |
|
☐ |
|
vat_number |
string |
VAT Number |
☐ |
|
voided_at |
datetime |
Voided at |
☐ |
|
10-06-2024 18:44 Version 24.1.3-BETA+4689