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

Last updated