Windsor brings all your Braintree data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL

Braintree Field Reference

Fields

ID	Type	Name	Description	Report
customer_stream__addresses	OBJECT	customer_stream.addresses	customer_stream.addresses	customer_stream
customer_stream__android_pay_cards	OBJECT	customer_stream.android_pay_cards	customer_stream.android_pay_cards	customer_stream
customer_stream__apple_pay_cards	OBJECT	customer_stream.apple_pay_cards	customer_stream.apple_pay_cards	customer_stream
customer_stream__company	TEXT	customer_stream.company	customer_stream.company	customer_stream
customer_stream__created_at	TEXT	customer_stream.created_at	customer_stream.created_at	customer_stream
customer_stream__credit_cards	OBJECT	customer_stream.credit_cards	customer_stream.credit_cards	customer_stream
customer_stream__custom_fields	TEXT	customer_stream.custom_fields	customer_stream.custom_fields	customer_stream
customer_stream__email	TEXT	customer_stream.email	customer_stream.email	customer_stream
customer_stream__fax	TEXT	customer_stream.fax	customer_stream.fax	customer_stream
customer_stream__first_name	TEXT	customer_stream.first_name	customer_stream.first_name	customer_stream
customer_stream__graphql_id	TEXT	customer_stream.graphql_id	customer_stream.graphql_id	customer_stream
customer_stream__id	TEXT	customer_stream.id	customer_stream.id	customer_stream
customer_stream__last_name	TEXT	customer_stream.last_name	customer_stream.last_name	customer_stream
customer_stream__masterpass_cards	OBJECT	customer_stream.masterpass_cards	customer_stream.masterpass_cards	customer_stream
customer_stream__payment_methods	OBJECT	customer_stream.payment_methods	customer_stream.payment_methods	customer_stream
customer_stream__paypal_accounts	OBJECT	customer_stream.paypal_accounts	customer_stream.paypal_accounts	customer_stream
customer_stream__phone	TEXT	customer_stream.phone	customer_stream.phone	customer_stream
customer_stream__samsung_pay_cards	OBJECT	customer_stream.samsung_pay_cards	customer_stream.samsung_pay_cards	customer_stream
customer_stream__updated_at	TEXT	customer_stream.updated_at	customer_stream.updated_at	customer_stream
customer_stream__us_bank_accounts	OBJECT	customer_stream.us_bank_accounts	customer_stream.us_bank_accounts	customer_stream
customer_stream__venmo_accounts	OBJECT	customer_stream.venmo_accounts	customer_stream.venmo_accounts	customer_stream
customer_stream__visa_checkout_cards	OBJECT	customer_stream.visa_checkout_cards	customer_stream.visa_checkout_cards	customer_stream
customer_stream__website	TEXT	customer_stream.website	customer_stream.website	customer_stream
datasource	TEXT	Data Source	The name of the Windsor connector returning the row
discount_stream__amount	NUMERIC	discount_stream.amount	discount_stream.amount	discount_stream
discount_stream__current_billing_cycle	NUMERIC	discount_stream.current_billing_cycle	discount_stream.current_billing_cycle	discount_stream
discount_stream__description	TEXT	discount_stream.description	discount_stream.description	discount_stream
discount_stream__id	TEXT	discount_stream.id	discount_stream.id	discount_stream
discount_stream__kind	TEXT	discount_stream.kind	discount_stream.kind	discount_stream
discount_stream__name	TEXT	discount_stream.name	discount_stream.name	discount_stream
discount_stream__never_expires	BOOLEAN	discount_stream.never_expires	discount_stream.never_expires	discount_stream
discount_stream__number_of_billing_cycles	NUMERIC	discount_stream.number_of_billing_cycles	discount_stream.number_of_billing_cycles	discount_stream
discount_stream__quantity	NUMERIC	discount_stream.quantity	discount_stream.quantity	discount_stream
dispute_stream__amount_disputed	NUMERIC	dispute_stream.amount_disputed	dispute_stream.amount_disputed	dispute_stream
dispute_stream__amount_won	NUMERIC	dispute_stream.amount_won	dispute_stream.amount_won	dispute_stream
dispute_stream__case_number	TEXT	dispute_stream.case_number	dispute_stream.case_number	dispute_stream
dispute_stream__chargeback_protection_level	TEXT	dispute_stream.chargeback_protection_level	dispute_stream.chargeback_protection_level	dispute_stream
dispute_stream__created_at	TEXT	dispute_stream.created_at	dispute_stream.created_at	dispute_stream
dispute_stream__currency_iso_code	TEXT	dispute_stream.currency_iso_code	dispute_stream.currency_iso_code	dispute_stream
dispute_stream__evidence	TEXT	dispute_stream.evidence	dispute_stream.evidence	dispute_stream
dispute_stream__graphql_id	TEXT	dispute_stream.graphql_id	dispute_stream.graphql_id	dispute_stream
dispute_stream__id	TEXT	dispute_stream.id	dispute_stream.id	dispute_stream
dispute_stream__kind	TEXT	dispute_stream.kind	dispute_stream.kind	dispute_stream
dispute_stream__merchant_account_id	TEXT	dispute_stream.merchant_account_id	dispute_stream.merchant_account_id	dispute_stream
dispute_stream__original_dispute_id	TEXT	dispute_stream.original_dispute_id	dispute_stream.original_dispute_id	dispute_stream
dispute_stream__paypal_messages	OBJECT	dispute_stream.paypal_messages	dispute_stream.paypal_messages	dispute_stream
dispute_stream__processor_comments	TEXT	dispute_stream.processor_comments	dispute_stream.processor_comments	dispute_stream
dispute_stream__reason	TEXT	dispute_stream.reason	dispute_stream.reason	dispute_stream
dispute_stream__reason_code	TEXT	dispute_stream.reason_code	dispute_stream.reason_code	dispute_stream
dispute_stream__reason_description	TEXT	dispute_stream.reason_description	dispute_stream.reason_description	dispute_stream
dispute_stream__received_date	DATE	dispute_stream.received_date	dispute_stream.received_date	dispute_stream
dispute_stream__reference_number	TEXT	dispute_stream.reference_number	dispute_stream.reference_number	dispute_stream
dispute_stream__reply_by_date	TEXT	dispute_stream.reply_by_date	dispute_stream.reply_by_date	dispute_stream
dispute_stream__status	TEXT	dispute_stream.status	dispute_stream.status	dispute_stream
dispute_stream__updated_at	TEXT	dispute_stream.updated_at	dispute_stream.updated_at	dispute_stream
merchant_account_stream__business_details	TEXT	merchant_account_stream.business_details	merchant_account_stream.business_details	merchant_account_stream
merchant_account_stream__currency_iso_code	TEXT	merchant_account_stream.currency_iso_code	merchant_account_stream.currency_iso_code	merchant_account_stream
merchant_account_stream__funding_details	TEXT	merchant_account_stream.funding_details	merchant_account_stream.funding_details	merchant_account_stream
merchant_account_stream__id	TEXT	merchant_account_stream.id	merchant_account_stream.id	merchant_account_stream
merchant_account_stream__individual_details	TEXT	merchant_account_stream.individual_details	merchant_account_stream.individual_details	merchant_account_stream
merchant_account_stream__status	TEXT	merchant_account_stream.status	merchant_account_stream.status	merchant_account_stream
plan_stream__add_ons	OBJECT	plan_stream.add_ons	plan_stream.add_ons	plan_stream
plan_stream__billing_day_of_month	NUMERIC	plan_stream.billing_day_of_month	plan_stream.billing_day_of_month	plan_stream
plan_stream__billing_frequency	NUMERIC	plan_stream.billing_frequency	plan_stream.billing_frequency	plan_stream
plan_stream__created_at	TEXT	plan_stream.created_at	plan_stream.created_at	plan_stream
plan_stream__currency_iso_code	TEXT	plan_stream.currency_iso_code	plan_stream.currency_iso_code	plan_stream
plan_stream__description	TEXT	plan_stream.description	plan_stream.description	plan_stream
plan_stream__discounts	OBJECT	plan_stream.discounts	plan_stream.discounts	plan_stream
plan_stream__id	TEXT	plan_stream.id	plan_stream.id	plan_stream
plan_stream__name	TEXT	plan_stream.name	plan_stream.name	plan_stream
plan_stream__number_of_billing_cycles	NUMERIC	plan_stream.number_of_billing_cycles	plan_stream.number_of_billing_cycles	plan_stream
plan_stream__price	NUMERIC	plan_stream.price	plan_stream.price	plan_stream
plan_stream__trial_duration	NUMERIC	plan_stream.trial_duration	plan_stream.trial_duration	plan_stream
plan_stream__trial_duration_unit	TEXT	plan_stream.trial_duration_unit	plan_stream.trial_duration_unit	plan_stream
plan_stream__trial_period	BOOLEAN	plan_stream.trial_period	plan_stream.trial_period	plan_stream
plan_stream__updated_at	TEXT	plan_stream.updated_at	plan_stream.updated_at	plan_stream
source	TEXT	Source	The name of the Windsor connector returning the row
subscription_stream__add_ons	OBJECT	subscription_stream.add_ons	subscription_stream.add_ons	subscription_stream
subscription_stream__balance	NUMERIC	subscription_stream.balance	subscription_stream.balance	subscription_stream
subscription_stream__billing_day_of_month	NUMERIC	subscription_stream.billing_day_of_month	subscription_stream.billing_day_of_month	subscription_stream
subscription_stream__billing_period_start_date	DATE	subscription_stream.billing_period_start_date	subscription_stream.billing_period_start_date	subscription_stream
subscription_stream__created_at	TEXT	subscription_stream.created_at	subscription_stream.created_at	subscription_stream
subscription_stream__current_billing_cycle	NUMERIC	subscription_stream.current_billing_cycle	subscription_stream.current_billing_cycle	subscription_stream
subscription_stream__days_past_due	NUMERIC	subscription_stream.days_past_due	subscription_stream.days_past_due	subscription_stream
subscription_stream__description	TEXT	subscription_stream.description	subscription_stream.description	subscription_stream
subscription_stream__discounts	OBJECT	subscription_stream.discounts	subscription_stream.discounts	subscription_stream
subscription_stream__failure_count	NUMERIC	subscription_stream.failure_count	subscription_stream.failure_count	subscription_stream
subscription_stream__first_billing_date	DATE	subscription_stream.first_billing_date	subscription_stream.first_billing_date	subscription_stream
subscription_stream__id	TEXT	subscription_stream.id	subscription_stream.id	subscription_stream
subscription_stream__merchant_account_id	TEXT	subscription_stream.merchant_account_id	subscription_stream.merchant_account_id	subscription_stream
subscription_stream__never_expires	BOOLEAN	subscription_stream.never_expires	subscription_stream.never_expires	subscription_stream
subscription_stream__next_bill_amount	NUMERIC	subscription_stream.next_bill_amount	subscription_stream.next_bill_amount	subscription_stream
subscription_stream__next_billing_date	DATE	subscription_stream.next_billing_date	subscription_stream.next_billing_date	subscription_stream
subscription_stream__next_billing_period_amount	NUMERIC	subscription_stream.next_billing_period_amount	subscription_stream.next_billing_period_amount	subscription_stream
subscription_stream__number_of_billing_cycles	NUMERIC	subscription_stream.number_of_billing_cycles	subscription_stream.number_of_billing_cycles	subscription_stream
subscription_stream__paid_through_date	DATE	subscription_stream.paid_through_date	subscription_stream.paid_through_date	subscription_stream
subscription_stream__payment_method_token	TEXT	subscription_stream.payment_method_token	subscription_stream.payment_method_token	subscription_stream
subscription_stream__plan_id	TEXT	subscription_stream.plan_id	subscription_stream.plan_id	subscription_stream
subscription_stream__price	NUMERIC	subscription_stream.price	subscription_stream.price	subscription_stream
subscription_stream__status	TEXT	subscription_stream.status	subscription_stream.status	subscription_stream
subscription_stream__transactions	OBJECT	subscription_stream.transactions	subscription_stream.transactions	subscription_stream
subscription_stream__trial_duration	NUMERIC	subscription_stream.trial_duration	subscription_stream.trial_duration	subscription_stream
subscription_stream__trial_duration_unit	TEXT	subscription_stream.trial_duration_unit	subscription_stream.trial_duration_unit	subscription_stream
subscription_stream__trial_period	BOOLEAN	subscription_stream.trial_period	subscription_stream.trial_period	subscription_stream
subscription_stream__updated_at	TEXT	subscription_stream.updated_at	subscription_stream.updated_at	subscription_stream
today	DATE	Today	Today's date
transaction_stream__acquirer_reference_number	TEXT	transaction_stream.acquirer_reference_number	transaction_stream.acquirer_reference_number	transaction_stream
transaction_stream__additional_processor_response	TEXT	transaction_stream.additional_processor_response	transaction_stream.additional_processor_response	transaction_stream
transaction_stream__amount	TEXT	transaction_stream.amount	transaction_stream.amount	transaction_stream
transaction_stream__android_pay_card_details	TEXT	transaction_stream.android_pay_card_details	transaction_stream.android_pay_card_details	transaction_stream
transaction_stream__apple_pay_details	TEXT	transaction_stream.apple_pay_details	transaction_stream.apple_pay_details	transaction_stream
transaction_stream__authorization_expires_at	TEXT	transaction_stream.authorization_expires_at	transaction_stream.authorization_expires_at	transaction_stream
transaction_stream__avs_error_response_code	TEXT	transaction_stream.avs_error_response_code	transaction_stream.avs_error_response_code	transaction_stream
transaction_stream__avs_postal_code_response_code	TEXT	transaction_stream.avs_postal_code_response_code	transaction_stream.avs_postal_code_response_code	transaction_stream
transaction_stream__avs_street_address_response_code	TEXT	transaction_stream.avs_street_address_response_code	transaction_stream.avs_street_address_response_code	transaction_stream
transaction_stream__billing_details	TEXT	transaction_stream.billing_details	transaction_stream.billing_details	transaction_stream
transaction_stream__channel	TEXT	transaction_stream.channel	transaction_stream.channel	transaction_stream
transaction_stream__created_at	TEXT	transaction_stream.created_at	transaction_stream.created_at	transaction_stream
transaction_stream__credit_card_details	TEXT	transaction_stream.credit_card_details	transaction_stream.credit_card_details	transaction_stream
transaction_stream__currency_iso_code	TEXT	transaction_stream.currency_iso_code	transaction_stream.currency_iso_code	transaction_stream
transaction_stream__custom_fields	OBJECT	transaction_stream.custom_fields	transaction_stream.custom_fields	transaction_stream
transaction_stream__customer_details	TEXT	transaction_stream.customer_details	transaction_stream.customer_details	transaction_stream
transaction_stream__cvv_response_code	TEXT	transaction_stream.cvv_response_code	transaction_stream.cvv_response_code	transaction_stream
transaction_stream__disbursement_details	TEXT	transaction_stream.disbursement_details	transaction_stream.disbursement_details	transaction_stream
transaction_stream__discount_amount	NUMERIC	transaction_stream.discount_amount	transaction_stream.discount_amount	transaction_stream
transaction_stream__discounts	OBJECT	transaction_stream.discounts	transaction_stream.discounts	transaction_stream
transaction_stream__disputes	OBJECT	transaction_stream.disputes	transaction_stream.disputes	transaction_stream
transaction_stream__escrow_status	TEXT	transaction_stream.escrow_status	transaction_stream.escrow_status	transaction_stream
transaction_stream__gateway_rejection_reason	TEXT	transaction_stream.gateway_rejection_reason	transaction_stream.gateway_rejection_reason	transaction_stream
transaction_stream__global_id	TEXT	transaction_stream.global_id	transaction_stream.global_id	transaction_stream
transaction_stream__graphql_id	TEXT	transaction_stream.graphql_id	transaction_stream.graphql_id	transaction_stream
transaction_stream__id	TEXT	transaction_stream.id	transaction_stream.id	transaction_stream
transaction_stream__installment_count	NUMERIC	transaction_stream.installment_count	transaction_stream.installment_count	transaction_stream
transaction_stream__masterpass_card_details	TEXT	transaction_stream.masterpass_card_details	transaction_stream.masterpass_card_details	transaction_stream
transaction_stream__merchant_account_id	TEXT	transaction_stream.merchant_account_id	transaction_stream.merchant_account_id	transaction_stream
transaction_stream__merchant_address	TEXT	transaction_stream.merchant_address	transaction_stream.merchant_address	transaction_stream
transaction_stream__merchant_identification_number	TEXT	transaction_stream.merchant_identification_number	transaction_stream.merchant_identification_number	transaction_stream
transaction_stream__merchant_name	TEXT	transaction_stream.merchant_name	transaction_stream.merchant_name	transaction_stream
transaction_stream__network_response_code	TEXT	transaction_stream.network_response_code	transaction_stream.network_response_code	transaction_stream
transaction_stream__network_response_text	TEXT	transaction_stream.network_response_text	transaction_stream.network_response_text	transaction_stream
transaction_stream__network_transaction_id	TEXT	transaction_stream.network_transaction_id	transaction_stream.network_transaction_id	transaction_stream
transaction_stream__order_id	TEXT	transaction_stream.order_id	transaction_stream.order_id	transaction_stream
transaction_stream__payment_instrument_type	TEXT	transaction_stream.payment_instrument_type	transaction_stream.payment_instrument_type	transaction_stream
transaction_stream__paypal_details	TEXT	transaction_stream.paypal_details	transaction_stream.paypal_details	transaction_stream
transaction_stream__pin_verified	BOOLEAN	transaction_stream.pin_verified	transaction_stream.pin_verified	transaction_stream
transaction_stream__plan_id	TEXT	transaction_stream.plan_id	transaction_stream.plan_id	transaction_stream
transaction_stream__processed_with_network_token	BOOLEAN	transaction_stream.processed_with_network_token	transaction_stream.processed_with_network_token	transaction_stream
transaction_stream__processor_authorization_code	TEXT	transaction_stream.processor_authorization_code	transaction_stream.processor_authorization_code	transaction_stream
transaction_stream__processor_response_code	TEXT	transaction_stream.processor_response_code	transaction_stream.processor_response_code	transaction_stream
transaction_stream__processor_response_text	TEXT	transaction_stream.processor_response_text	transaction_stream.processor_response_text	transaction_stream
transaction_stream__processor_response_type	TEXT	transaction_stream.processor_response_type	transaction_stream.processor_response_type	transaction_stream
transaction_stream__processor_settlement_response_code	TEXT	transaction_stream.processor_settlement_response_code	transaction_stream.processor_settlement_response_code	transaction_stream
transaction_stream__processor_settlement_response_text	TEXT	transaction_stream.processor_settlement_response_text	transaction_stream.processor_settlement_response_text	transaction_stream
transaction_stream__purchase_order_number	TEXT	transaction_stream.purchase_order_number	transaction_stream.purchase_order_number	transaction_stream
transaction_stream__recurring	BOOLEAN	transaction_stream.recurring	transaction_stream.recurring	transaction_stream
transaction_stream__refund_global_ids	OBJECT	transaction_stream.refund_global_ids	transaction_stream.refund_global_ids	transaction_stream
transaction_stream__refund_ids	OBJECT	transaction_stream.refund_ids	transaction_stream.refund_ids	transaction_stream
transaction_stream__refunded_transaction_id	TEXT	transaction_stream.refunded_transaction_id	transaction_stream.refunded_transaction_id	transaction_stream
transaction_stream__response_emv_data	TEXT	transaction_stream.response_emv_data	transaction_stream.response_emv_data	transaction_stream
transaction_stream__retrieval_reference_number	TEXT	transaction_stream.retrieval_reference_number	transaction_stream.retrieval_reference_number	transaction_stream
transaction_stream__samsung_pay_card_details	TEXT	transaction_stream.samsung_pay_card_details	transaction_stream.samsung_pay_card_details	transaction_stream
transaction_stream__sca_exemption_requested	TEXT	transaction_stream.sca_exemption_requested	transaction_stream.sca_exemption_requested	transaction_stream
transaction_stream__service_fee_amount	NUMERIC	transaction_stream.service_fee_amount	transaction_stream.service_fee_amount	transaction_stream
transaction_stream__settlement_batch_id	TEXT	transaction_stream.settlement_batch_id	transaction_stream.settlement_batch_id	transaction_stream
transaction_stream__shipping_amount	NUMERIC	transaction_stream.shipping_amount	transaction_stream.shipping_amount	transaction_stream
transaction_stream__shipping_details	TEXT	transaction_stream.shipping_details	transaction_stream.shipping_details	transaction_stream
transaction_stream__ships_from_postal_code	TEXT	transaction_stream.ships_from_postal_code	transaction_stream.ships_from_postal_code	transaction_stream
transaction_stream__status	TEXT	transaction_stream.status	transaction_stream.status	transaction_stream
transaction_stream__status_history	OBJECT	transaction_stream.status_history	transaction_stream.status_history	transaction_stream
transaction_stream__subscription_details	TEXT	transaction_stream.subscription_details	transaction_stream.subscription_details	transaction_stream
transaction_stream__subscription_id	TEXT	transaction_stream.subscription_id	transaction_stream.subscription_id	transaction_stream
transaction_stream__tax_amount	NUMERIC	transaction_stream.tax_amount	transaction_stream.tax_amount	transaction_stream
transaction_stream__tax_exempt	BOOLEAN	transaction_stream.tax_exempt	transaction_stream.tax_exempt	transaction_stream
transaction_stream__terminal_identification_number	TEXT	transaction_stream.terminal_identification_number	transaction_stream.terminal_identification_number	transaction_stream
transaction_stream__type	TEXT	transaction_stream.type	transaction_stream.type	transaction_stream
transaction_stream__updated_at	TEXT	transaction_stream.updated_at	transaction_stream.updated_at	transaction_stream
transaction_stream__venmo_account_details	TEXT	transaction_stream.venmo_account_details	transaction_stream.venmo_account_details	transaction_stream
transaction_stream__visa_checkout_card_details	TEXT	transaction_stream.visa_checkout_card_details	transaction_stream.visa_checkout_card_details	transaction_stream
transaction_stream__voice_referral_number	TEXT	transaction_stream.voice_referral_number	transaction_stream.voice_referral_number	transaction_stream