Why Does the TRANSACTION Table Not Contain a transaction_fee_amount column?

Question

Braintree's API documentation references a transaction_fee_amount field. Why doesn't Fivetran provide this data in the TRANSACTION table?

Environment

Connector: Braintree

Answer

Braintree's transaction_fee_amount field represents fees associated with PayPal transactions. It is only available for transactions processed through PayPal. Therefore, we sync transaction_fee_amount data to the PAYPAL_DETAILS table.

See Braintree's Transaction API documentation for more information.