Catalog: Chargebee
Schema: CreditNotes
Primary Keys: id
Label: Credit Notes
Can retrieve data and change data using insert, update and delete.
Select Chargebee API URL: /credit_notes
Insert Chargebee API URL: /credit_notes
Update Chargebee API URL: /credit_notes
Delete Chargebee API URL: /credit_notes
Field Selection Method: NotRequired
Base Path: list[*].credit_note
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 or update.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
amount_allocated |
decimal |
Amount Allocated |
☐ |
|
amount_available |
decimal |
Amount Available |
☐ |
|
amount_refunded |
decimal |
Amount Refunded |
☐ |
|
create_reason_code |
string |
Create Reason Code |
☐ |
|
currency_code |
string |
Currency Code |
☐ |
|
customer_id |
string |
Customer ID |
☐ |
|
date |
datetime |
Date |
☐ |
|
deleted |
boolean |
Deleted |
☐ |
|
fractional_correction |
decimal |
Fractional Correction |
☐ |
|
id |
string |
ID |
☑ |
|
local_currency_code |
string |
Local Currency Code |
☐ |
|
price_type |
string |
Price Type |
☐ |
|
reference_invoice_id |
string |
Reference Invoice ID |
☐ |
|
refunded_at |
datetime |
Refunded at |
☐ |
|
resource_version |
int64 |
Resource Version |
☐ |
|
round_off_amount |
decimal |
Round-off Amount |
☐ |
|
status |
string |
Status |
☐ |
|
sub_total |
decimal |
Sub-total |
☐ |
|
sub_total_in_local_currency |
decimal |
Sub Total in Local Currency |
☐ |
|
subscription_id |
string |
Subscription ID |
☐ |
|
total |
decimal |
Total |
☐ |
|
total_in_local_currency |
decimal |
Total in Local Currency |
☐ |
|
type |
string |
Type |
☐ |
|
updated_at |
datetime |
Updated at |
☐ |
|
voided_at |
datetime |
Voided at |
☐ |
|
12-12-2020 18:45 Version 20.1.301-BETA+3023