Chargebee API Data ModelCatalog: Chargebee
Schema: Transactions
Primary Keys: id
Label: Subscription Add-ons
Can retrieve data and change data using insert, update and delete.
Select Chargebee API URL: /transactions
Insert Chargebee API URL: /transactions
Update Chargebee API URL: /transactions
Delete Chargebee API URL: /transactions
Field Selection Method: NotRequired
Base Path: list[*].transaction
Table Columns
The columns of the table Transactions 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 |
decimal |
Amount |
☐ |
|
amount_capturable |
decimal |
Amount Capturable |
☐ |
|
amount_unused |
decimal |
Amount Unused |
☐ |
|
authorization_reason |
string |
Authorization Reason |
☐ |
|
currency_code |
string |
Currency Code |
☐ |
|
customer_id |
string |
Customer ID |
☐ |
|
date |
datetime |
Date |
☐ |
|
deleted |
boolean |
Deleted |
☐ |
|
error_code |
string |
Error Code |
☐ |
|
error_text |
string |
Error Text |
☐ |
|
fraud_flag |
string |
Fraud Flag |
☐ |
|
fraud_reason |
string |
Fraud Reason |
☐ |
|
gateway |
string |
Gateway |
☐ |
|
gateway_account_id |
string |
Gateway Account ID |
☐ |
|
id |
string |
ID |
☑ |
|
id_at_gateway |
string |
ID At Gateway |
☐ |
|
initiator_type |
string |
Initiator Type |
☐ |
|
masked_card_number |
string |
Masked Card Number |
☐ |
|
payment_method |
string |
Payment Method |
☐ |
|
payment_source_id |
string |
Payment Source ID |
☐ |
|
reference_authorization_id |
string |
Reference Authorization ID |
☐ |
|
reference_number |
string |
Reference Number |
☐ |
|
reference_transaction_id |
string |
Reference Transaction ID |
☐ |
|
refunded_txn_id |
string |
Refunded Transaction ID |
☐ |
|
resource_version |
int64 |
Resource Version |
☐ |
|
reversal_transaction_id |
decimal |
Reversal Transaction ID |
☐ |
|
settled_at |
datetime |
Settled at |
☐ |
|
status |
string |
Status |
☐ |
|
subscription_id |
string |
Subscription ID |
☐ |
|
three_d_secure |
boolean |
Three D Secure |
☐ |
|
type |
string |
Type |
☐ |
|
updated_at |
datetime |
Updated at |
☐ |
|
voided_at |
datetime |
Voided at |
☐ |
|
12-12-2020 18:45 Version 20.1.301-BETA+3023
