# Transactions: Chargebee Subscription Add-ons - Catalog: `Chargebee` - Schema: `Transactions` - Primary Keys: `id` - Label: Subscription Add-ons Can retrieve data and change data using insert, update and delete. ## Table Columns The columns of the table `Transactions` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `amount_capturable` | `decimal` | Amount Capturable | ☐ | | | `amount_unused` | `decimal` | Amount Unused | ☐ | | | `amount` | `decimal` | Amount | ☐ | | | `authorization_reason` | `string` | Authorization Reason | ☐ | | | `business_entity_id` | `string` | | ☐ | | | `currency_code` | `string` | Currency Code | ☐ | | | `custom_payment_method_name` | `string` | | ☐ | | | `customer_id` | `string` | Customer ID | ☐ | | | `date` | `datetime` | Date | ☐ | | | `deleted` | `boolean` | Deleted | ☐ | | | `error_code` | `string` | Error Code | ☐ | | | `error_detail_decline_code` | `string` | | ☐ | | | `error_detail_decline_message` | `string` | | ☐ | | | `error_detail_error_category` | `string` | | ☐ | | | `error_detail_error_code` | `string` | | ☐ | | | `error_detail_error_field` | `string` | | ☐ | | | `error_detail_error_message` | `string` | | ☐ | | | `error_detail_network_error_code` | `string` | | ☐ | | | `error_detail_network_error_message` | `string` | | ☐ | | | `error_detail_processor_error_code` | `string` | | ☐ | | | `error_detail_processor_error_message` | `string` | | ☐ | | | `error_detail_recommendation_code` | `string` | | ☐ | | | `error_detail_recommendation_message` | `string` | | ☐ | | | `error_detail_request_id` | `string` | | ☐ | | | `error_text` | `string` | Error Text | ☐ | | | `fraud_flag` | `string` | Fraud Flag | ☐ | | | `fraud_reason` | `string` | Fraud Reason | ☐ | | | `gateway_account_id` | `string` | Gateway Account ID | ☐ | | | `gateway` | `string` | Gateway | ☐ | | | `id_at_gateway` | `string` | ID At Gateway | ☐ | | | `id` | `string` | ID | ☑ | | | `iin` | `string` | IIN | ☐ | | | `initiator_type` | `string` | Initiator Type | ☐ | | | `last4` | `string` | Last 4 | ☐ | | | `masked_card_number` | `string` | Masked Card Number | ☐ | | | `merchant_reference_id` | `string` | | ☐ | | | `payment_method_details` | `string` | | ☐ | | | `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 | ☐ | |