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

# PaymentSources: Chargebee Payment Sources

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

- Catalog: `Chargebee`
- Schema: `Subscriptions`
- Primary Keys: `id`
- Label: Payment Sources

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

## API Source

- Endpoint: `/payment_sources`

## Table Columns

The columns of the table `PaymentSources` 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 |
|---|---|---|:---:|---|---|
| `amazon_payment_agreement_id` | `varchar2` | Amazon Payment Agreement ID | [ ] |  |  |
| `amazon_payment_email` | `varchar2` | Amazon Payment Email | [ ] |  |  |
| `bank_account_account_holder_type` | `varchar2` | Bank Account Account Holder Type | [ ] |  |  |
| `bank_account_account_type` | `varchar2` | Bank Account Account Type | [ ] |  |  |
| `bank_account_bank_name` | `varchar2` | Bank Account Bank Name | [ ] |  |  |
| `bank_account_direct_debit_scheme` | `varchar2` | itgen_cbe_bank_account_direct_debit_scheme | [ ] |  |  |
| `bank_account_echeck_type` | `varchar2` | Bank Account Echeck Type | [ ] |  |  |
| `bank_account_first_name` | `varchar2` | itgen_cbe_bank_account_first_name | [ ] |  |  |
| `bank_account_last_name` | `varchar2` | itgen_cbe_bank_account_last_name | [ ] |  |  |
| `bank_account_last4` | `varchar2` | Bank Account Last 4 | [ ] |  |  |
| `bank_account_mandate_id` | `varchar2` | Bank Account Mandate ID | [ ] |  |  |
| `bank_account_name_on_account` | `varchar2` | Bank Account Name on Account | [ ] |  |  |
| `billing_address_city` | `varchar2` | Billing Address City | [ ] |  |  |
| `billing_address_company` | `varchar2` | Billing Address Company | [ ] |  |  |
| `billing_address_country` | `varchar2` | Billing Address Country | [ ] |  |  |
| `billing_address_email` | `varchar2` | Billing Address Email | [ ] |  |  |
| `billing_address_first_name` | `varchar2` | Billing Address First Name | [ ] |  |  |
| `billing_address_last_name` | `varchar2` | Billing Address Last Name | [ ] |  |  |
| `billing_address_line1` | `varchar2` | Billing Address Line 1 | [ ] |  |  |
| `billing_address_line2` | `varchar2` | Billing Address Line 2 | [ ] |  |  |
| `billing_address_line3` | `varchar2` | Billing Address Line 3 | [ ] |  |  |
| `billing_address_phone` | `varchar2` | Billing Address Phone | [ ] |  |  |
| `billing_address_state` | `varchar2` | Billing Address State | [ ] |  |  |
| `billing_address_state_code` | `varchar2` | itgen_cbe_billing_address_state_code | [ ] |  |  |
| `billing_address_validation_status` | `varchar2` | Billing Address Validation Status | [ ] |  |  |
| `billing_address_zip` | `varchar2` | itgen_cbe_billing_address_zip | [ ] |  |  |
| `boleto_email` | `varchar2` | itgen_cbe_boleto_email | [ ] |  |  |
| `boleto_first_name` | `varchar2` | itgen_cbe_boleto_first_name | [ ] |  |  |
| `boleto_last_name` | `varchar2` | itgen_cbe_boleto_last_name | [ ] |  |  |
| `boleto_last4` | `varchar2` | itgen_cbe_boleto_last4 | [ ] |  |  |
| `business_entity_id` | `varchar2(50)` | itgen_cbe_business_entity_id | [ ] |  |  |
| `card_billing_addr1` | `varchar2` | Card Billing Address 1 | [ ] |  |  |
| `card_billing_addr2` | `varchar2` | Card Billing Address 2 | [ ] |  |  |
| `card_billing_city` | `varchar2` | Card Billing City | [ ] |  |  |
| `card_billing_country` | `varchar2` | Card Billing Country | [ ] |  |  |
| `card_billing_state` | `varchar2` | Card Billing State | [ ] |  |  |
| `card_billing_state_code` | `varchar2` | Card Billing State Code | [ ] |  |  |
| `card_billing_zip` | `varchar2` | Card Billing ZIP Code | [ ] |  |  |
| `card_brand` | `varchar2` | Card Brand | [ ] |  |  |
| `card_expiry_month` | `int16` | Card Expiry Month | [ ] |  |  |
| `card_expiry_year` | `int16` | Card Expiry Year | [ ] |  |  |
| `card_first_name` | `varchar2` | Card First Name | [ ] |  |  |
| `card_funding_type` | `varchar2` | Card Funding Type | [ ] |  |  |
| `card_iin` | `varchar2` | Card IIN | [ ] |  |  |
| `card_last_name` | `varchar2` | Card Last Name | [ ] |  |  |
| `card_last4` | `varchar2` | Card Last 4 | [ ] |  |  |
| `card_masked_number` | `varchar2` | Card Masked Number | [ ] |  |  |
| `created_at` | `datetime` | Created at | [ ] |  |  |
| `customer_id` | `varchar2` | Customer ID | [ ] |  |  |
| `deleted` | `char` | Deleted | [ ] |  |  |
| `gateway` | `varchar2` | Gateway | [ ] |  |  |
| `gateway_account_id` | `varchar2` | Gateway Account ID | [ ] |  |  |
| `id` | `varchar2` | ID | [x] |  |  |
| `ip_address` | `varchar2` | IP Address | [ ] |  |  |
| `issuing_country` | `varchar2` | Issuing Country | [ ] |  |  |
| `klarna_pay_now_email` | `varchar2` | itgen_cbe_klarna_pay_now_email | [ ] |  |  |
| `paypal_agreement_id` | `varchar2` | Paypal Agreement ID | [ ] |  |  |
| `paypal_email` | `varchar2` | Paypal Email | [ ] |  |  |
| `reference_id` | `varchar2` | Reference ID | [ ] |  |  |
| `resource_version` | `int64` | Resource Version | [ ] |  |  |
| `status` | `varchar2` | Status | [ ] |  |  |
| `type` | `varchar2` | Type | [ ] |  |  |
| `updated_at` | `datetime` | Updated at | [ ] |  |  |
| `upi_vpa` | `varchar2` | itgen_cbe_upi_vpa | [ ] |  |  |
| `venmo_user_name` | `varchar2` | itgen_cbe_venmo_user_name | [ ] |  |  |



## Release Notes

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

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

