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:

• AddOns

• Credit Card Verification

• Customer

• Discounts

• Merchant Accounts

• Plan

• Subscriptions

• 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.

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