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
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
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
createdAt
DATETIME
updatedAt
DATETIME
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
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
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
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
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
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
Last updated