Schema Information Braintree
This topic provides a structured reference to assist you in working with Daton's Braintree connector and the associated fields and tables.
Schema Information Braintree
This topic provides a structured reference to assist you in working with Daton's Braintree connector and the associated fields and tables.
Tables/APIs
The following is the list of tables or APIs associated with the Braintree connector:
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.
Fields
Field Name |
Data Type |
|---|---|
amount |
NUMERIC |
currentBillingCycle |
INTEGER |
description |
STRING |
id |
STRING |
kind |
STRING |
quantity |
INTEGER |
name |
STRING |
neverExpires |
BOOLEAN |
numberOfBillingCycles |
INTEGER |
planId |
STRING |
_daton_user_id |
NUMERIC |
_daton_batch_runtime |
NUMERIC |
| _daton_batch_id | NUMERIC |
CreditCardVerification
Retrieves the credit card verification details associated with the Braintree account. For more information on the API, see Braintree- CreditCardVerification.
Fields
Field Name |
Data Type |
|---|---|
status |
STRING |
amount |
NUMERIC |
avsErrorResponseCode |
STRING |
avsPostalCodeResponseCode |
STRING |
avsStreetAddressResponseCode |
STRING |
currencyIsoCode |
STRING |
cvvResponseCode |
STRING |
gatewayRejectionReason |
STRING |
processorResponseCode |
STRING |
processorResponseText |
STRING |
processorResponseType |
STRING |
networkResponseCode |
STRING |
networkResponseText |
STRING |
merchantAccountId |
STRING |
graphqlId |
STRING |
id |
STRING |
creditCard |
RECORD |
billingAddress |
RECORD |
createdAt |
DATETIME |
riskData |
RECORD |
threeDSecureInfo |
RECORD |
_daton_user_id |
NUMERIC |
_daton_batch_runtime |
NUMERIC |
| _daton_batch_id | NUMERIC |
Customer
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.
Fields
Field Name |
Data Type |
|---|---|
createdAt |
DATETIME |
updatedAt |
DATETIME |
email |
STRING |
firstName |
STRING |
graphqlId |
STRING |
id |
STRING |
lastName |
STRING |
creditCards |
RECORD |
paypalAccounts |
RECORD |
applePayCards |
RECORD |
androidPayCards |
RECORD |
amexExpressCheckoutCards |
RECORD |
coinbaseAccounts |
RECORD |
venmoAccounts |
RECORD |
visaCheckoutCards |
RECORD |
masterpassCards |
RECORD |
usBankAccounts |
RECORD |
samsungPayCards |
RECORD |
customActionsPaymentMethods |
RECORD |
addresses |
RECORD |
_daton_user_id |
NUMERIC |
_daton_batch_runtime |
NUMERIC |
| _daton_batch_id | NUMERIC |
Discounts
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.
Fields
Field Name |
Data Type |
|---|---|
amount |
NUMERIC |
currentBillingCycle |
INTEGER |
description |
STRING |
id |
STRING |
kind |
STRING |
quantity |
INTEGER |
name |
STRING |
neverExpires |
BOOLEAN |
numberOfBillingCycles |
INTEGER |
planId |
STRING |
_daton_user_id |
NUMERIC |
_daton_batch_runtime |
NUMERIC |
| _daton_batch_id | NUMERIC |
MerchantAccounts
Retrieves the create, find, and update details of a Braintree merchant account. For more information on the API, see Braintree- MerchantAccounts.
Fields
Field Name |
Data Type |
|---|---|
status |
STRING |
id |
STRING |
masterMerchantAccount |
STRING |
individualDetails |
RECORD |
businessDetails |
RECORD |
fundingDetails |
RECORD |
currencyIsoCode |
STRING |
isDefault |
BOOLEAN |
_daton_user_id |
NUMERIC |
_daton_batch_runtime |
NUMERIC |
| _daton_batch_id | NUMERIC |
Plan
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.
Fields
Field Name |
Data Type |
|---|---|
createdAt |
DATETIME |
updatedAt |
DATETIME |
id |
STRING |
addOns |
STRING |
merchantId |
STRING |
billingDayOfMonth |
INTEGER |
billingFrequency |
INTEGER |
creditCards |
RECORD |
paypalAccounts |
RECORD |
applePayCards |
RECORD |
androidPayCards |
RECORD |
amexExpressCheckoutCards |
RECORD |
coinbaseAccounts |
RECORD |
venmoAccounts |
RECORD |
visaCheckoutCards |
RECORD |
masterpassCards |
RECORD |
usBankAccounts |
RECORD |
samsungPayCards |
RECORD |
customActionsPaymentMethods |
RECORD |
addresses |
RECORD |
_daton_user_id |
NUMERIC |
_daton_batch_runtime |
NUMERIC |
| _daton_batch_id | NUMERIC |
Subscriptions
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.
Fields
Field Name |
Data Type |
|---|---|
DurationUnit |
STRING |
Source |
STRING |
Status |
STRING |
addOns |
STRING |
balance |
NUMERIC |
billingDayOfMonth |
INTEGER |
billingPeriodEndDate |
DATETIME |
billingPeriodStartDate |
DATETIME |
currentBillingCycle |
INTEGER |
daysPastDue |
INTEGER |
descriptor |
RECORD |
description |
STRING |
failureCount |
INTEGER |
createdAt |
DATETIME |
updatedAt |
DATETIME |
firstBillingDate |
DATETIME |
hasTrialPeriod |
BOOLEAN |
id |
STRING |
merchantAccountId |
STRING |
neverExpires |
BOOLEAN |
nextBillAmount |
NUMERIC |
nextBillingDate |
DATETIME |
nextBillingPeriodAmount |
NUMERIC |
numberOfBillingCycles |
INTEGER |
paidThroughDate |
DATETIME |
paymentMethodToken |
STRING |
planId |
STRING |
price |
NUMERIC |
statusHistory |
RECORD |
trialDuration |
INTEGER |
trialDurationUnit |
STRING |
_daton_user_id |
NUMERIC |
_daton_batch_runtime |
NUMERIC |
| _daton_batch_id | NUMERIC |
Transaction
Retrieves all details of a transaction, including current status associated with the BigCommerce store. For more information on the API, see Braintree- Transaction.
Fields
Field Name |
Data Type |
|---|---|
addOns |
STRING |
amount |
NUMERIC |
avsPostalCodeResponseCode |
STRING |
avsStreetAddressResponseCode |
STRING |
billingAddress |
RECORD |
channel |
STRING |
createdAt |
DATETIME |
creditCard |
RECORD |
currencyIsoCode |
STRING |
customer |
RECORD |
cvvResponseCode |
STRING |
disbursementDetails |
RECORD |
disputes |
RECORD |
descriptor |
RECORD |
discounts |
STRING |
escrowStatus |
STRING |
gatewayRejectionReason |
STRING |
graphqlId |
STRING |
id |
STRING |
merchantAccountId |
STRING |
orderId |
STRING |
androidPayDetails |
RECORD |
paypalDetails |
RECORD |
paypalHereDetails |
RECORD |
applePayDetails |
RECORD |
amexExpressCheckoutDetails |
RECORD |
venmoAccountDetails |
RECORD |
usBankAccountDetails |
RECORD |
visaCheckoutCardDetails |
RECORD |
masterpassCardDetails |
RECORD |
idealPaymentDetails |
RECORD |
localPaymentDetails |
RECORD |
processorAuthorizationCode |
STRING |
planId |
STRING |
processorResponseCode |
STRING |
processorResponseType |
STRING |
customActionsPaymentMethodDetails |
RECORD |
processorResponseText |
STRING |
processorSettlementResponseCode |
STRING |
processorSettlementResponseText |
STRING |
additionalProcessorResponse |
STRING |
networkResponseCode |
STRING |
networkResponseText |
STRING |
voiceReferralNumber |
STRING |
purchaseOrderNumber |
STRING |
recurring |
BOOLEAN |
refundIds |
STRING |
retrievalReferenceNumber |
STRING |
shippingAddress |
RECORD |
status |
STRING |
subscriptionId |
STRING |
refundedTransactionId |
STRING |
samsungPayCardDetails |
RECORD |
statusHistory |
RECORD |
subscription |
RECORD |
subscriptionDetails |
RECORD |
taxExempt |
BOOLEAN |
taxAmount |
NUMERIC |
shippingAmount |
NUMERIC |
discountAmount |
NUMERIC |
serviceFeeAmount |
NUMERIC |
shipsFromPostalCode |
STRING |
type |
STRING |
settlementBatchId |
STRING |
updatedAt |
DATETIME |
paymentInstrumentType |
STRING |
riskData |
RECORD |
partialSettlementTransactionIds |
STRING |
authorizationAdjustments |
STRING |
authorizationExpiresAt |
DATETIME |
threeDSecureInfo |
RECORD |
facilitatedDetails |
RECORD |
facilitatorDetails |
RECORD |
networkTransactionId |
STRING |
_daton_user_id |
NUMERIC |
_daton_batch_runtime |
NUMERIC |
_daton_batch_id |
NUMERIC |
