Transactions - Chargebee Data Catalog

List of all transactions that occurred in your account.

UPSERT KEY

Each row is uniquely identified by this column. Use it as the upsert key when applying incremental datasets to your warehouse.

Related Tables

Tables referencing transactions.id

transaction_linked_payments invoice_dunning_attempts transaction_linked_refunds

Columns

id string, not null

Primary Key

Uniquely identifies the transaction.

subscription_id string, null

Foreign Key subscriptions.id

The identifier of the subscription for which this transaction occurred.

payment_source_id string, null

Foreign Key payment_sources.id

The identifier of the payment source for which this transaction occurred.

customer_id string, null

Foreign Key customers.id

The identifier of the customer for which this transaction occurred.

business_entity_id string, null

Foreign Key business_entities.id

The unique ID of the business entity of this transaction. This is always the same as the business entity of the customer.

amount long, null

The amount for this transaction.

amount_capturable long, null

This is the portion of the authorized amount that is yet to be captured. The payment capture is recorded as a transaction of type = payment. This applies only to a transaction of type = authorization.

amount_unused long, null

This is the portion of the amount that has not been invoiced yet and is therefore added to excess_payments for the customer. This applies only to a transaction of type = payment.

authorization_reason string, null

The type of authorization transaction. Possible values are:

blocking_funds: The transaction was created to block funds from a payment method.
verification: The transaction was created for payment method verification.

change_type string

The column indicates the type of change [create, update, delete, read] and can be used to load data into the warehouse accordingly.

currency_code string, not null

The currency code (ISO 4217 format) for the transaction.

custom_payment_method_id string, null

The identifier of the custom payment method for this transaction.

custom_payment_method_name string, null

The name of the custom payment method for this transaction.

date timestamp, null

Indicates when this transaction occurred.

error_code string, null

The error code received from the payment gateway on failure.

error_detail_decline_code string, null

When a transaction is declined, the gateway provides this code to specify the reason for the decline.

error_detail_decline_message string, null

This message provides a descriptive explanation of the reason for the transaction's decline.

error_detail_error_category string, null

This field categorizes the type of error that occurred for the request. It helps in understanding whether the error is due to validation, processing, network issues, and more.

error_detail_error_code string, null

A gateway-specific code that corresponds to the particular error encountered for the request. This code identifies the error in a standardized manner across the gateway's services.

error_detail_error_field string, null

This field indicates which specific data field or attribute in the request caused the error.

error_detail_error_message string, null

A message provided by the gateway that describes the nature of the error encountered.

error_detail_network_error_code string, null

This code represents errors that originate from the payment network (such as Visa, MasterCard, etc.). It differs from the gateway error code and is specific to the network's error-handling system.

error_detail_network_error_message string, null

This is the network-related error message from the gateway. This is a detailed message provided by the payment network explaining the nature of the network error encountered.

error_detail_processor_error_code string, null

This code is provided by the payment processor (the entity that handles the transaction between bank accounts and payment networks) and indicates errors that occurred at this stage of the payment process.

error_detail_processor_error_message string, null

This message describes the specific error that the payment processor encountered.

error_detail_recommendation_code string, null

After an error occurred, the gateway or payment network may provide a recommendation code. This code suggests a course of action or remedy to resolve the issue.

error_detail_recommendation_message string, null

This message provides guidance or suggestions on actions or remedies to resolve the issue.

error_detail_request_id string, null

This is a unique identifier assigned by the payment gateway. It tracks the request at the payment gateway.

error_text string, null

The error message received from the payment gateway on failure.

fraud_flag string, null

Indicates whether the transaction was identified as fraudulent. Possible values are:

fraudulent: The transaction was marked as fraudulent.
safe: The transaction was marked as safe.
suspicious: The transaction was identified as potentially fraudulent by the gateway.

fraud_reason string, null

A short description of why the transaction was marked as fraudulent or suspicious.

gateway string, not null

The gateway through which this transaction occurred. This applies only to 'Card' Payment Methods. Possible values are:

adyen: Adyen is a payment gateway.
amazon_payments: Amazon Payments is a payment service provider.
authorize_net: Authorize.net is a payment gateway.
balanced_payments: Balanced is a payment gateway.
bank_of_america: Bank of America Gateway.
beanstream: Bambora (formerly known as Beanstream) is a payment gateway.
bluepay: BluePay is a payment gateway.
bluesnap: BlueSnap is a payment gateway.
braintree: Braintree is a payment gateway.
chargebee: Chargebee test gateway.
chargebee_payments: Chargebee Payments gateway.
checkout_com: Checkout.com is a payment gateway.
cybersource: CyberSource is a payment gateway.
dlocal: Dlocal provides payment solutions for global commerce by accepting local payment methods.
ebanx: EBANX is a payment gateway, enabling businesses to accept diverse local payment methods from various countries for increased market reach and conversion.
ecentric: Ecentric provides a seamless payment processing service in South Africa, specializing in omnichannel capabilities.
elavon: Elavon Virtual Merchant is a payment solution.
eway: eWAY Account is a payment gateway.
eway_rapid: eWAY Rapid is a payment gateway.
exact: Exact Payments is a payment gateway.
first_data_global: First Data Global Gateway Virtual Terminal Account.
global_payments: Global Payments is a payment service provider.
gocardless: GoCardless is a payment service provider.
hdfc: HDFC Account is a payment gateway.
ingenico_direct: Worldline Online Payments is a payment gateway.
metrics_global: Metrics Global is a leading payment service provider providing unified payment services in the US.
migs: MasterCard Internet Gateway Service payment gateway.
mollie: Mollie is a payment gateway.
moneris: Moneris is a payment gateway.
moneris_us: Moneris USA is a payment gateway.
nmi: NMI is a payment gateway.
not_applicable: Indicates that a payment gateway is not applicable for this table.
nuvei: Nuvei is a secure and reliable payment processing solution that allows businesses to accept payments from customers and is suitable for various types of businesses.
ogone: Ingenico ePayments (formerly known as Ogone) is a payment gateway.
orbital: Chase Paymentech (Orbital) is a payment gateway.
pay_com: Pay.com provides payment services focused on simplicity and hassle-free operations for businesses of all sizes.
paymill: PAYMILL is a payment gateway.
paypal: PayPal Commerce is a payment gateway.
paypal_express_checkout: PayPal Express Checkout is a payment gateway.
paypal_payflow_pro: PayPal Payflow Pro is a payment gateway.
paypal_pro: PayPal Pro Account is a payment gateway.
pin: Pin is a payment gateway.
quickbooks: Intuit QuickBooks Payments gateway.
razorpay: Razorpay is a fast-growing payment service provider in India, working with all leading banks and supporting major local payment methods including Netbanking, UPI, etc.
sage_pay: Sage Pay is a payment gateway.
stripe: Stripe is a payment gateway.
tco: 2Checkout is a payment gateway.
vantiv: Vantiv is a payment gateway.
wepay: WePay is a payment gateway.
windcave: Windcave provides an end-to-end payment processing solution in ANZ and other leading global markets.
wirecard: WireCard Account is a payment service provider.
worldpay: WorldPay is a payment gateway.

gateway_account_id string, null

The gateway account used for this transaction.

id_at_gateway string, null

The identifier used to refer to this transaction in the gateway.

iin string, null

First 6 digits of the card payment method.

initiator_type string, null

A marker for on-session payments (3DS). A null value indicates 'merchant'. Possible values are:

customer: Customer initiated 3DS payment.
merchant: Payment initiated on a stored payment method by the merchant.

last4 string, null

Last 4 digits of the card payment method.

masked_card_number string, null

merchant_reference_id string, null

A unique identifier used to track this transaction across various systems you integrate with. This identifier passes to the payment gateway when the transaction is initiated. This is supported only for the Exact payment gateway.

payment_method string, not null, default=card

The payment method of this transaction. The possible values are:

ach_credit: ACH Credit.
alipay: Alipay.
amazon_payments: Amazon Payments.
apple_pay: Apple Pay.
automated_bank_transfer: Automated Bank Transfer.
bancontact: Bancontact.
bank_transfer: Bank Transfer.
boleto: Boleto.
card: Card.
cash: Cash.
chargeback: Only applicable for a transaction of type = refund. This value is set by Chargebee when an automated chargeback occurred.
check: Check.
custom: Custom.
direct_debit: Direct Debit.
dotpay: Dotpay.
faster_payments: Faster Payments.
giropay: Giropay
google_pay: Google Pay
ideal: IDEAL
klarna_pay_now: Klarna Pay Now
netbanking_emandates: Netbanking E-mandates
other: Payment Methods other than the above types.
pay_to: PayTo
paypal_express_checkout: Paypal Express Checkout
sepa_credit: SEPA Credit
sepa_instant_transfer: Sepa Instant Transfer.
sofort: Sofort
unionpay: Unionpay
upi: UPI
venmo: Venmo
wechat_pay: WeChat Pay

payment_method_details string, null

Payment method details of the corresponding transaction.

record_exported_at timestamp

The column represents the timestamp when the data was exported to the configured destination.

record_extracted_at timestamp

The column represents the timestamp when the updated data became available in Chargebee's data lakehouse.

reference_authorization_id string, null

This is the id of the transaction (always of type = authorization) that authorized the payment being captured. This applies only to transactions of type = payment.

reference_number string, null

The reference number for this transaction. For example, the check number when payment_method = check.

reference_transaction_id string, null

This is the id of the offline transaction being refunded or reversed. This applies only to transactions of type = refund or payment_reversal.

refunded_txn_id string, null

This is the id of the transaction (always of type = payment) being refunded. This applies only to transactions of type = refund.

resource_version long, null

The version number of this table. The resource_version is updated with a new timestamp in milliseconds for every change made to the table. This field is present only if the table was updated after 2016-09-28.

reversal_transaction_id string, null

The reversal transaction identifier. This applies only to payment transactions.

settled_at timestamp, null

Indicates the time at which the final status of the transaction was marked.

status string, null

The status of this transaction. Possible values are:

failure: Transaction failed. Refer to the error_code and error_text fields to understand the reason for failure.
in_progress: The transaction is being processed by the gateway. This typically happens for direct debit transactions or, in the case of cards, refund transactions. Such transactions can take 2 to 7 days to complete, depending on the gateway and payment method.
needs_attention: Connection with the Gateway terminated abruptly, so the status of this transaction needs manual resolution.
success: The transaction was successful.
timeout: Transaction failed because the Gateway did not accept the connection.
voided: The transaction was voided or authorization expired at the gateway.

three_d_secure boolean, null

Indicates whether this transaction went through 3DS. This applies only to ‘on-session’ payments & verifications. If 3DS is not enforced by the gateway/bank or if the customer’s card is not enrolled, this value is false.

type string, not null

The type of the transaction. Possible values are:

authorization: The transaction represents an authorization for capturing the amount from the customer’s payment_source.
payment: The transaction represents the capture of the amount from the customer’s payment_source.
payment_reversal: Indicates a reversal transaction.
refund: The transaction represents a refund of the amount to the customer’s payment_source.

updated_at timestamp, null

Timestamp indicating when this transaction was last updated. This field is present only if the table was updated after 2016-09-28.

voided_at timestamp, null

Timestamp indicating when the payment was voided or authorization expired at the gateway.

Sample Queries

List Transactions Needing Attention

This query retrieves all transactions with a status of needs_attention along with relevant details from the customers and subscriptions tables.

copy

Click to Copy

      SELECT
  t.id AS transaction_id,
  t.currency_code,
  t.amount,
  t.id_at_gateway,
  t.status AS transaction_status,
  c.id AS customer_id,
  c.name AS customer_name,
  c.email AS customer_email,
  s.id AS subscription_id,
  s.status AS subscription_status
FROM
  transactions t
  LEFT JOIN customers c ON t.customer_id = c.id
  LEFT JOIN subscriptions s ON t.subscription_id = s.id
WHERE
  t.status = 'needs_attention';