# Schema Information Braintree

## Tables/APIs 

The following is the list of tables or APIs associated with the Braintree connector:

* [AddOns](#addons) 
* [Credit Card Verification](#creditcardverification)
* [Customer](#customer)
* [Discounts](#discounts)
* [Merchant Accounts](#merchantaccounts)
* [Plan](#plan)
* [Subscriptions](#subscriptions)
* [Transaction](#transaction)

### Fields

#### AddOns 

Retrieves the data of the add on amount and its billing cycle associated with the Braintree account. For more information on the API, see [Braintree- AddOns](https://developer.paypal.com/braintree/docs/reference/response/add-on/ruby). 

**Fields**

<table><thead><tr><th width="153">Field Name</th><th width="71">Data Type</th></tr></thead><tbody><tr><td>amount</td><td>NUMERIC</td></tr><tr><td>currentBillingCycle</td><td>INTEGER</td></tr><tr><td>description</td><td>STRING</td></tr><tr><td>id</td><td>STRING</td></tr><tr><td>kind</td><td>STRING</td></tr><tr><td>quantity</td><td>INTEGER</td></tr><tr><td>name</td><td>STRING</td></tr><tr><td>neverExpires</td><td>BOOLEAN</td></tr><tr><td>numberOfBillingCycles</td><td>INTEGER</td></tr><tr><td>planId</td><td>STRING</td></tr><tr><td>_daton_user_id</td><td>NUMERIC</td></tr><tr><td>_daton_batch_runtime</td><td>NUMERIC</td></tr><tr><td>_daton_batch_id</td><td>NUMERIC</td></tr></tbody></table>

#### CreditCardVerification

Retrieves the credit card verification details associated with the Braintree account. For more information on the API, see [Braintree- CreditCardVerification.](https://developer.paypal.com/braintree/docs/reference/request/credit-card-verification/create/ruby)

**Fields**&#x20;

<table><thead><tr><th width="209">Field Name</th><th width="72">Data Type</th></tr></thead><tbody><tr><td>status</td><td>STRING</td></tr><tr><td>amount</td><td>NUMERIC</td></tr><tr><td>avsErrorResponseCode</td><td>STRING</td></tr><tr><td>avsPostalCodeResponseCode</td><td>STRING</td></tr><tr><td>avsStreetAddressResponseCode</td><td>STRING</td></tr><tr><td>currencyIsoCode</td><td>STRING</td></tr><tr><td>cvvResponseCode</td><td>STRING</td></tr><tr><td>gatewayRejectionReason</td><td>STRING</td></tr><tr><td>processorResponseCode</td><td>STRING</td></tr><tr><td>processorResponseText</td><td>STRING</td></tr><tr><td>processorResponseType</td><td>STRING</td></tr><tr><td>networkResponseCode</td><td>STRING</td></tr><tr><td>networkResponseText</td><td>STRING</td></tr><tr><td>merchantAccountId</td><td>STRING</td></tr><tr><td>graphqlId</td><td>STRING</td></tr><tr><td>id</td><td>STRING</td></tr><tr><td>creditCard</td><td>RECORD</td></tr><tr><td>billingAddress</td><td>RECORD</td></tr><tr><td>createdAt</td><td>DATETIME</td></tr><tr><td>riskData</td><td>RECORD</td></tr><tr><td>threeDSecureInfo</td><td>RECORD</td></tr><tr><td>_daton_user_id</td><td>NUMERIC</td></tr><tr><td>_daton_batch_runtime</td><td>NUMERIC</td></tr><tr><td>_daton_batch_id</td><td>NUMERIC</td></tr></tbody></table>

#### Customer&#x20;

Retrieves the create, find, search and update details of the customers associated with the Braintree account. For more information on the API, see [Braintree- Customer.](https://developer.paypal.com/braintree/docs/reference/response/customer/ruby)

**Fields**

<table><thead><tr><th width="212">Field Name</th><th width="72">Data Type</th></tr></thead><tbody><tr><td>createdAt</td><td>DATETIME</td></tr><tr><td>updatedAt</td><td>DATETIME</td></tr><tr><td>email</td><td>STRING</td></tr><tr><td>firstName</td><td>STRING</td></tr><tr><td>graphqlId</td><td>STRING</td></tr><tr><td>id</td><td>STRING</td></tr><tr><td>lastName</td><td>STRING</td></tr><tr><td>creditCards</td><td>RECORD</td></tr><tr><td>paypalAccounts</td><td>RECORD</td></tr><tr><td>applePayCards</td><td>RECORD</td></tr><tr><td>androidPayCards</td><td>RECORD</td></tr><tr><td>amexExpressCheckoutCards</td><td>RECORD</td></tr><tr><td>coinbaseAccounts</td><td>RECORD</td></tr><tr><td>venmoAccounts</td><td>RECORD</td></tr><tr><td>visaCheckoutCards</td><td>RECORD</td></tr><tr><td>masterpassCards</td><td>RECORD</td></tr><tr><td>usBankAccounts</td><td>RECORD</td></tr><tr><td>samsungPayCards</td><td>RECORD</td></tr><tr><td>customActionsPaymentMethods</td><td>RECORD</td></tr><tr><td>addresses</td><td>RECORD</td></tr><tr><td>_daton_user_id</td><td>NUMERIC</td></tr><tr><td>_daton_batch_runtime</td><td>NUMERIC</td></tr><tr><td>_daton_batch_id</td><td>NUMERIC</td></tr></tbody></table>

#### Discounts&#x20;

Retrieves the data regarding a discount amount and its billing cycle associated with the Braintree account. For more information on the API, see [Braintree- Discounts. ](https://developer.paypal.com/braintree/docs/reference/response/discount/ruby)

**Fields**

<table><thead><tr><th width="153">Field Name</th><th width="71">Data Type</th></tr></thead><tbody><tr><td>amount</td><td>NUMERIC</td></tr><tr><td>currentBillingCycle</td><td>INTEGER</td></tr><tr><td>description</td><td>STRING</td></tr><tr><td>id</td><td>STRING</td></tr><tr><td>kind</td><td>STRING</td></tr><tr><td>quantity</td><td>INTEGER</td></tr><tr><td>name</td><td>STRING</td></tr><tr><td>neverExpires</td><td>BOOLEAN</td></tr><tr><td>numberOfBillingCycles</td><td>INTEGER</td></tr><tr><td>planId</td><td>STRING</td></tr><tr><td>_daton_user_id</td><td>NUMERIC</td></tr><tr><td>_daton_batch_runtime</td><td>NUMERIC</td></tr><tr><td>_daton_batch_id</td><td>NUMERIC</td></tr></tbody></table>

#### MerchantAccounts&#x20;

Retrieves the create, find, and update details of a Braintree merchant account. For more information on the API, see [Braintree- MerchantAccounts](https://developer.paypal.com/braintree/docs/reference/response/merchant-account/ruby).

**Fields**

<table><thead><tr><th width="164">Field Name</th><th width="71">Data Type</th></tr></thead><tbody><tr><td>status</td><td>STRING</td></tr><tr><td>id</td><td>STRING</td></tr><tr><td>masterMerchantAccount</td><td>STRING</td></tr><tr><td>individualDetails</td><td>RECORD</td></tr><tr><td>businessDetails</td><td>RECORD</td></tr><tr><td>fundingDetails</td><td>RECORD</td></tr><tr><td>currencyIsoCode</td><td>STRING</td></tr><tr><td>isDefault</td><td>BOOLEAN</td></tr><tr><td>_daton_user_id</td><td>NUMERIC</td></tr><tr><td>_daton_batch_runtime</td><td>NUMERIC</td></tr><tr><td>_daton_batch_id</td><td>NUMERIC</td></tr></tbody></table>

#### Plan&#x20;

Retrieves the create, find, and update details of a plan associated with a Braintree merchant account. For more information on the API, see [Braintree- Plan.](https://developer.paypal.com/braintree/docs/reference/response/plan/ruby)

**Fields**

<table><thead><tr><th width="212">Field Name</th><th width="72">Data Type</th></tr></thead><tbody><tr><td>createdAt</td><td>DATETIME</td></tr><tr><td>updatedAt</td><td>DATETIME</td></tr><tr><td>id</td><td>STRING</td></tr><tr><td>addOns</td><td>STRING</td></tr><tr><td>merchantId</td><td>STRING</td></tr><tr><td>billingDayOfMonth</td><td>INTEGER</td></tr><tr><td>billingFrequency</td><td>INTEGER</td></tr><tr><td>creditCards</td><td>RECORD</td></tr><tr><td>paypalAccounts</td><td>RECORD</td></tr><tr><td>applePayCards</td><td>RECORD</td></tr><tr><td>androidPayCards</td><td>RECORD</td></tr><tr><td>amexExpressCheckoutCards</td><td>RECORD</td></tr><tr><td>coinbaseAccounts</td><td>RECORD</td></tr><tr><td>venmoAccounts</td><td>RECORD</td></tr><tr><td>visaCheckoutCards</td><td>RECORD</td></tr><tr><td>masterpassCards</td><td>RECORD</td></tr><tr><td>usBankAccounts</td><td>RECORD</td></tr><tr><td>samsungPayCards</td><td>RECORD</td></tr><tr><td>customActionsPaymentMethods</td><td>RECORD</td></tr><tr><td>addresses</td><td>RECORD</td></tr><tr><td>_daton_user_id</td><td>NUMERIC</td></tr><tr><td>_daton_batch_runtime</td><td>NUMERIC</td></tr><tr><td>_daton_batch_id</td><td>NUMERIC</td></tr></tbody></table>

#### Subscriptions&#x20;

Retrieves the create, find, cancel, and update details of a subscription associated with a Braintree account. For more information on the API, see [Braintree- Subscription](https://developer.paypal.com/braintree/docs/reference/response/subscription/ruby).&#x20;

**Fields**

<table><thead><tr><th width="164">Field Name</th><th width="72">Data Type</th></tr></thead><tbody><tr><td>DurationUnit</td><td>STRING</td></tr><tr><td>Source</td><td>STRING</td></tr><tr><td>Status</td><td>STRING</td></tr><tr><td>addOns</td><td>STRING</td></tr><tr><td>balance</td><td>NUMERIC</td></tr><tr><td>billingDayOfMonth</td><td>INTEGER</td></tr><tr><td>billingPeriodEndDate</td><td>DATETIME</td></tr><tr><td>billingPeriodStartDate</td><td>DATETIME</td></tr><tr><td>currentBillingCycle</td><td>INTEGER</td></tr><tr><td>daysPastDue</td><td>INTEGER</td></tr><tr><td>descriptor</td><td>RECORD</td></tr><tr><td>description</td><td>STRING</td></tr><tr><td>failureCount</td><td>INTEGER</td></tr><tr><td>createdAt</td><td>DATETIME</td></tr><tr><td>updatedAt</td><td>DATETIME</td></tr><tr><td>firstBillingDate</td><td>DATETIME</td></tr><tr><td>hasTrialPeriod</td><td>BOOLEAN</td></tr><tr><td>id</td><td>STRING</td></tr><tr><td>merchantAccountId</td><td>STRING</td></tr><tr><td>neverExpires</td><td>BOOLEAN</td></tr><tr><td>nextBillAmount</td><td>NUMERIC</td></tr><tr><td>nextBillingDate</td><td>DATETIME</td></tr><tr><td>nextBillingPeriodAmount</td><td>NUMERIC</td></tr><tr><td>numberOfBillingCycles</td><td>INTEGER</td></tr><tr><td>paidThroughDate</td><td>DATETIME</td></tr><tr><td>paymentMethodToken</td><td>STRING</td></tr><tr><td>planId</td><td>STRING</td></tr><tr><td>price</td><td>NUMERIC</td></tr><tr><td>statusHistory</td><td>RECORD</td></tr><tr><td>trialDuration</td><td>INTEGER</td></tr><tr><td>trialDurationUnit</td><td>STRING</td></tr><tr><td>_daton_user_id</td><td>NUMERIC</td></tr><tr><td>_daton_batch_runtime</td><td>NUMERIC</td></tr><tr><td>_daton_batch_id</td><td>NUMERIC</td></tr></tbody></table>

#### Transaction

Retrieves all details of a transaction, including current status associated with the BigCommerce store. For more information on the API, see [Braintree- Transaction](https://developer.paypal.com/braintree/docs/reference/response/transaction/ruby).&#x20;

**Fields**

<table><thead><tr><th width="249">Field Name</th><th width="72">Data Type</th></tr></thead><tbody><tr><td>addOns</td><td>STRING</td></tr><tr><td>amount</td><td>NUMERIC</td></tr><tr><td>avsPostalCodeResponseCode</td><td>STRING</td></tr><tr><td>avsStreetAddressResponseCode</td><td>STRING</td></tr><tr><td>billingAddress</td><td>RECORD</td></tr><tr><td>channel</td><td>STRING</td></tr><tr><td>createdAt</td><td>DATETIME</td></tr><tr><td>creditCard</td><td>RECORD</td></tr><tr><td>currencyIsoCode</td><td>STRING</td></tr><tr><td>customer</td><td>RECORD</td></tr><tr><td>cvvResponseCode</td><td>STRING</td></tr><tr><td>disbursementDetails</td><td>RECORD</td></tr><tr><td>disputes</td><td>RECORD</td></tr><tr><td>descriptor</td><td>RECORD</td></tr><tr><td>discounts</td><td>STRING</td></tr><tr><td>escrowStatus</td><td>STRING</td></tr><tr><td>gatewayRejectionReason</td><td>STRING</td></tr><tr><td>graphqlId</td><td>STRING</td></tr><tr><td>id</td><td>STRING</td></tr><tr><td>merchantAccountId</td><td>STRING</td></tr><tr><td>orderId</td><td>STRING</td></tr><tr><td>androidPayDetails</td><td>RECORD</td></tr><tr><td>paypalDetails</td><td>RECORD</td></tr><tr><td>paypalHereDetails</td><td>RECORD</td></tr><tr><td>applePayDetails</td><td>RECORD</td></tr><tr><td>amexExpressCheckoutDetails</td><td>RECORD</td></tr><tr><td>venmoAccountDetails</td><td>RECORD</td></tr><tr><td>usBankAccountDetails</td><td>RECORD</td></tr><tr><td>visaCheckoutCardDetails</td><td>RECORD</td></tr><tr><td>masterpassCardDetails</td><td>RECORD</td></tr><tr><td>idealPaymentDetails</td><td>RECORD</td></tr><tr><td>localPaymentDetails</td><td>RECORD</td></tr><tr><td>processorAuthorizationCode</td><td>STRING</td></tr><tr><td>planId</td><td>STRING</td></tr><tr><td>processorResponseCode</td><td>STRING</td></tr><tr><td>processorResponseType</td><td>STRING</td></tr><tr><td>customActionsPaymentMethodDetails</td><td>RECORD</td></tr><tr><td>processorResponseText</td><td>STRING</td></tr><tr><td>processorSettlementResponseCode</td><td>STRING</td></tr><tr><td>processorSettlementResponseText</td><td>STRING</td></tr><tr><td>additionalProcessorResponse</td><td>STRING</td></tr><tr><td>networkResponseCode</td><td>STRING</td></tr><tr><td>networkResponseText</td><td>STRING</td></tr><tr><td>voiceReferralNumber</td><td>STRING</td></tr><tr><td>purchaseOrderNumber</td><td>STRING</td></tr><tr><td>recurring</td><td>BOOLEAN</td></tr><tr><td>refundIds</td><td>STRING</td></tr><tr><td>retrievalReferenceNumber</td><td>STRING</td></tr><tr><td>shippingAddress</td><td>RECORD</td></tr><tr><td>status</td><td>STRING</td></tr><tr><td>subscriptionId</td><td>STRING</td></tr><tr><td>refundedTransactionId</td><td>STRING</td></tr><tr><td>samsungPayCardDetails</td><td>RECORD</td></tr><tr><td>statusHistory</td><td>RECORD</td></tr><tr><td>subscription</td><td>RECORD</td></tr><tr><td>subscriptionDetails</td><td>RECORD</td></tr><tr><td>taxExempt</td><td>BOOLEAN</td></tr><tr><td>taxAmount</td><td>NUMERIC</td></tr><tr><td>shippingAmount</td><td>NUMERIC</td></tr><tr><td>discountAmount</td><td>NUMERIC</td></tr><tr><td>serviceFeeAmount</td><td>NUMERIC</td></tr><tr><td>shipsFromPostalCode</td><td>STRING</td></tr><tr><td>type</td><td>STRING</td></tr><tr><td>settlementBatchId</td><td>STRING</td></tr><tr><td>updatedAt</td><td>DATETIME</td></tr><tr><td>paymentInstrumentType</td><td>STRING</td></tr><tr><td>riskData</td><td>RECORD</td></tr><tr><td>partialSettlementTransactionIds</td><td>STRING</td></tr><tr><td>authorizationAdjustments</td><td>STRING</td></tr><tr><td>authorizationExpiresAt</td><td>DATETIME</td></tr><tr><td>threeDSecureInfo</td><td>RECORD</td></tr><tr><td>facilitatedDetails</td><td>RECORD</td></tr><tr><td>facilitatorDetails</td><td>RECORD</td></tr><tr><td>networkTransactionId</td><td>STRING</td></tr><tr><td>_daton_user_id</td><td>NUMERIC</td></tr><tr><td>_daton_batch_runtime</td><td>NUMERIC</td></tr><tr><td>_daton_batch_id</td><td>NUMERIC</td></tr></tbody></table>