Catalog: Chargebee
Schema: PaymentSources
Primary Keys: id
Label: Payment Sources
Can retrieve data and change data using insert, update and delete.
Select Chargebee API URL: /payment_sources
Insert Chargebee API URL: /payment_sources
Update Chargebee API URL: /payment_sources
Delete Chargebee API URL: /payment_sources
Field Selection Method: NotRequired
Base Path: list[*].payment_source
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 or update.
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_echeck_type |
string |
Bank Account Echeck Type |
☐ |
|
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 |
☐ |
|
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 |
string |
Card Billing State |
☐ |
|
card_billing_state_code |
string |
Card Billing State Code |
☐ |
|
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 |
string |
Gateway |
☐ |
|
gateway_account_id |
string |
Gateway Account ID |
☐ |
|
id |
string |
ID |
☑ |
|
ip_address |
string |
IP Address |
☐ |
|
issuing_country |
string |
Issuing Country |
☐ |
|
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 |
☐ |
|
12-12-2020 18:45 Version 20.1.301-BETA+3023