# PaymentSources: Chargebee Payment Sources - Catalog: `Chargebee` - Schema: `Subscriptions` - Primary Keys: `id` - Label: Payment Sources Can retrieve data and change data using insert, update and delete. ## Table Columns The columns of the table `PaymentSources` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `amazon_payment_agreement_id` | `string` | Amazon Payment Agreement ID | ☐ | | | `amazon_payment_email` | `string` | Amazon Payment Email | ☐ | | | `bank_account_account_holder_type` | `string` | Bank Account Account Holder Type | ☐ | | | `bank_account_account_type` | `string` | Bank Account Account Type | ☐ | | | `bank_account_bank_name` | `string` | Bank Account Bank Name | ☐ | | | `bank_account_direct_debit_scheme` | `string` | | ☐ | | | `bank_account_echeck_type` | `string` | Bank Account Echeck Type | ☐ | | | `bank_account_first_name` | `string` | | ☐ | | | `bank_account_last_name` | `string` | | ☐ | | | `bank_account_last4` | `string` | Bank Account Last 4 | ☐ | | | `bank_account_mandate_id` | `string` | Bank Account Mandate ID | ☐ | | | `bank_account_name_on_account` | `string` | Bank Account Name on Account | ☐ | | | `billing_address_city` | `string` | Billing Address City | ☐ | | | `billing_address_company` | `string` | Billing Address Company | ☐ | | | `billing_address_country` | `string` | Billing Address Country | ☐ | | | `billing_address_email` | `string` | Billing Address Email | ☐ | | | `billing_address_first_name` | `string` | Billing Address First Name | ☐ | | | `billing_address_last_name` | `string` | Billing Address Last Name | ☐ | | | `billing_address_line1` | `string` | Billing Address Line 1 | ☐ | | | `billing_address_line2` | `string` | Billing Address Line 2 | ☐ | | | `billing_address_line3` | `string` | Billing Address Line 3 | ☐ | | | `billing_address_phone` | `string` | Billing Address Phone | ☐ | | | `billing_address_state_code` | `string` | | ☐ | | | `billing_address_state` | `string` | Billing Address State | ☐ | | | `billing_address_validation_status` | `string` | Billing Address Validation Status | ☐ | | | `billing_address_zip` | `string` | | ☐ | | | `boleto_email` | `string` | | ☐ | | | `boleto_first_name` | `string` | | ☐ | | | `boleto_last_name` | `string` | | ☐ | | | `boleto_last4` | `string` | | ☐ | | | `business_entity_id` | `string(50)` | | ☐ | | | `card_billing_addr1` | `string` | Card Billing Address 1 | ☐ | | | `card_billing_addr2` | `string` | Card Billing Address 2 | ☐ | | | `card_billing_city` | `string` | Card Billing City | ☐ | | | `card_billing_country` | `string` | Card Billing Country | ☐ | | | `card_billing_state_code` | `string` | Card Billing State Code | ☐ | | | `card_billing_state` | `string` | Card Billing State | ☐ | | | `card_billing_zip` | `string` | Card Billing ZIP Code | ☐ | | | `card_brand` | `string` | Card Brand | ☐ | | | `card_expiry_month` | `int16` | Card Expiry Month | ☐ | | | `card_expiry_year` | `int16` | Card Expiry Year | ☐ | | | `card_first_name` | `string` | Card First Name | ☐ | | | `card_funding_type` | `string` | Card Funding Type | ☐ | | | `card_iin` | `string` | Card IIN | ☐ | | | `card_last_name` | `string` | Card Last Name | ☐ | | | `card_last4` | `string` | Card Last 4 | ☐ | | | `card_masked_number` | `string` | Card Masked Number | ☐ | | | `created_at` | `datetime` | Created at | ☐ | | | `customer_id` | `string` | Customer ID | ☐ | | | `deleted` | `boolean` | Deleted | ☐ | | | `gateway_account_id` | `string` | Gateway Account ID | ☐ | | | `gateway` | `string` | Gateway | ☐ | | | `id` | `string` | ID | ☑ | | | `ip_address` | `string` | IP Address | ☐ | | | `issuing_country` | `string` | Issuing Country | ☐ | | | `klarna_pay_now_email` | `string` | | ☐ | | | `paypal_agreement_id` | `string` | Paypal Agreement ID | ☐ | | | `paypal_email` | `string` | Paypal Email | ☐ | | | `reference_id` | `string` | Reference ID | ☐ | | | `resource_version` | `int64` | Resource Version | ☐ | | | `status` | `string` | Status | ☐ | | | `type` | `string` | Type | ☐ | | | `updated_at` | `datetime` | Updated at | ☐ | | | `upi_vpa` | `string` | | ☐ | | | `venmo_user_name` | `string` | | ☐ | |