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

# Transactions: Chargebee Subscription Add-ons

`insert` `update` `delete` `REST`

- Catalog: `Chargebee`
- Schema: `Transactions`
- Primary Keys: `id`
- Label: Subscription Add-ons

Can retrieve data and change data using `insert`, `update` and `delete`.

## API Source

- Endpoint: `/transactions`

## 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 and update.

| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `amount` | `decimal` | Amount | [ ] |  |  |
| `amount_capturable` | `decimal` | Amount Capturable | [ ] |  |  |
| `amount_unused` | `decimal` | Amount Unused | [ ] |  |  |
| `authorization_reason` | `varchar2` | Authorization Reason | [ ] |  |  |
| `business_entity_id` | `varchar2` | itgen_cbe_business_entity_id | [ ] |  |  |
| `currency_code` | `varchar2` | Currency Code | [ ] |  |  |
| `custom_payment_method_name` | `varchar2` | itgen_cbe_custom_payment_method_name | [ ] |  |  |
| `customer_id` | `varchar2` | Customer ID | [ ] |  |  |
| `date` | `datetime` | Date | [ ] |  |  |
| `deleted` | `char` | Deleted | [ ] |  |  |
| `error_code` | `varchar2` | Error Code | [ ] |  |  |
| `error_detail_decline_code` | `varchar2` | itgen_cbe_error_detail_decline_code | [ ] |  |  |
| `error_detail_decline_message` | `varchar2` | itgen_cbe_error_detail_decline_message | [ ] |  |  |
| `error_detail_error_category` | `varchar2` | itgen_cbe_error_detail_error_category | [ ] |  |  |
| `error_detail_error_code` | `varchar2` | itgen_cbe_error_detail_error_code | [ ] |  |  |
| `error_detail_error_field` | `varchar2` | itgen_cbe_error_detail_error_field | [ ] |  |  |
| `error_detail_error_message` | `varchar2` | itgen_cbe_error_detail_error_message | [ ] |  |  |
| `error_detail_network_error_code` | `varchar2` | itgen_cbe_error_detail_network_error_code | [ ] |  |  |
| `error_detail_network_error_message` | `varchar2` | itgen_cbe_error_detail_network_error_message | [ ] |  |  |
| `error_detail_processor_error_code` | `varchar2` | itgen_cbe_error_detail_processor_error_code | [ ] |  |  |
| `error_detail_processor_error_message` | `varchar2` | itgen_cbe_error_detail_processor_error_message | [ ] |  |  |
| `error_detail_recommendation_code` | `varchar2` | itgen_cbe_error_detail_recommendation_code | [ ] |  |  |
| `error_detail_recommendation_message` | `varchar2` | itgen_cbe_error_detail_recommendation_message | [ ] |  |  |
| `error_detail_request_id` | `varchar2` | itgen_cbe_error_detail_request_id | [ ] |  |  |
| `error_text` | `varchar2` | Error Text | [ ] |  |  |
| `fraud_flag` | `varchar2` | Fraud Flag | [ ] |  |  |
| `fraud_reason` | `varchar2` | Fraud Reason | [ ] |  |  |
| `gateway` | `varchar2` | Gateway | [ ] |  |  |
| `gateway_account_id` | `varchar2` | Gateway Account ID | [ ] |  |  |
| `id` | `varchar2` | ID | [x] |  |  |
| `id_at_gateway` | `varchar2` | ID At Gateway | [ ] |  |  |
| `iin` | `varchar2` | IIN | [ ] |  |  |
| `initiator_type` | `varchar2` | Initiator Type | [ ] |  |  |
| `last4` | `varchar2` | Last 4 | [ ] |  |  |
| `masked_card_number` | `varchar2` | Masked Card Number | [ ] |  |  |
| `merchant_reference_id` | `varchar2` | itgen_cbe_merchant_reference_id | [ ] |  |  |
| `payment_method` | `varchar2` | Payment Method | [ ] |  |  |
| `payment_method_details` | `varchar2` | itgen_cbe_payment_method_details | [ ] |  |  |
| `payment_source_id` | `varchar2` | Payment Source ID | [ ] |  |  |
| `reference_authorization_id` | `varchar2` | Reference Authorization ID | [ ] |  |  |
| `reference_number` | `varchar2` | Reference Number | [ ] |  |  |
| `reference_transaction_id` | `varchar2` | Reference Transaction ID | [ ] |  |  |
| `refunded_txn_id` | `varchar2` | Refunded Transaction ID | [ ] |  |  |
| `resource_version` | `int64` | Resource Version | [ ] |  |  |
| `reversal_transaction_id` | `decimal` | Reversal Transaction ID | [ ] |  |  |
| `settled_at` | `datetime` | Settled at | [ ] |  |  |
| `status` | `varchar2` | Status | [ ] |  |  |
| `subscription_id` | `varchar2` | Subscription ID | [ ] |  |  |
| `three_d_secure` | `char` | Three D Secure | [ ] |  |  |
| `type` | `varchar2` | Type | [ ] |  |  |
| `updated_at` | `datetime` | Updated at | [ ] |  |  |
| `voided_at` | `datetime` | Voided at | [ ] |  |  |



## Release Notes

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

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

