Adyen

Explore the interactive ERD

Table & Field Reference

platform_margins_report

Column	Type	Keys
`_fivetran_id`	String	PK
`company_account`	String
`costs`	Double
`margin`	Double
`merchant_account`	String
`month`	String
`pricing_plan`	String
`pricing_type`	String
`product_or_service`	String
`revenue`	Double
`statement_currency`	String
`statement_number`	Int

exchange_rate_report

Column	Type	Keys
`_fivetran_id`	String	PK
`base_currency`	String
`currency_description`	String
`exchange_rate`	Double
`exchange_rate_platform_settlement`	Double
`exponent`	Int
`symbol`	String
`target_currency`	String
`valid_from`	Instant

referral_list_report

Column	Type	Keys
`_fivetran_id`	String	PK
`account_name`	String
`active_account_name`	String
`active_user_name`	String
`begindate`	String
`block`	Boolean
`enddate`	String
`reason`	String
`referral`	String
`referral_type`	String

threedsecure_authentication_report

Column	Type	Keys
`_fivetran_id`	String	PK
`acquirer`	String
`acquirer_response`	String
`acs_challenge_mandated`	String
`acs_operator_id`	String
`acs_reference_number`	String
`acs_trans_id`	String
`acs_url`	String
`amount`	Double
`ares_authentication_type`	String
`authentication_mid`	String
`authentication_only`	String
`authorisation_mid`	String
`avs_response`	String
`bin`	String
`card_holder_info`	String
`challenge_cancel`	String
`company`	String
`creation_date`	String
`currency`	String
`cvc_response_code`	String
`cvc_supplied`	String
`data_only`	String
`device_channel`	String
`directory_server`	String
`dstransid`	String
`eci`	String
`error_code`	String
`error_component`	String
`error_description`	String
`error_detail`	String
`error_message_type`	String
`interaction_counter`	String
`issuer_country_code`	String
`issuer_name`	String
`liability_shift`	String
`merchant`	String
`merchant_reference`	String
`message_category`	String
`metadata`	String
`payment_method`	String
`pspreference`	String
`raw_acquirer_response`	String
`recurring_processing_model`	String
`results_status`	String
`risk_score`	Double
`rreq_authentication_type`	String
`sca_exemption_requested`	String
`sca_retry`	String
`shopper_country`	String
`shopper_email`	String
`shopper_interaction`	String
`shopper_ip`	String
`shopper_name`	String
`shopper_reference`	String
`three_ds_2_redirect`	String
`three_dsversion`	String
`threed_authentication_response`	String
`threed_directory_response`	String
`threeds_2_fallback`	String
`threeds_2_fallback_directory_response`	String
`threeds_completion_indicator`	String
`threeds_requestor_challenge_indicator`	String
`threeds_requestor_name`	String
`threeds_server_transaction_id`	String
`time_zone`	String
`trans_status_reason`	String

aggregate_settlement_details_report

Column	Type	Keys
`_fivetran_id`	String	PK
`bank_card_commission_nc`	Double
`batch_closed_date`	String
`batch_number`	Int
`company_account`	String
`country_code`	String
`creation_date`	String
`dcc_markup_nc`	Double
`exchange_rate`	Double
`gross_credit_gc`	Double
`gross_currency`	String
`gross_debit_gc`	Double
`journal_type`	String
`merchant_account`	String
`net_credit_nc`	Double
`net_currency`	String
`net_debit_nc`	Double
`num_txs`	Int
`payable_booking_date`	String
`payment_method`	String
`payout_reference`	String
`settlement_flow`	String
`store`	String
`terminal_id`	String
`time_zone`	String

manual_review_report

Column	Type	Keys
`_fivetran_id`	String	PK
`company_account`	String
`manual_review_psp_reference`	String
`merchant_account`	String
`merchant_reference`	String
`note`	String
`payment_amount`	Double
`payment_currency`	String
`payment_date`	String
`payment_date_time_zone`	String
`payment_method`	String
`psp_reference`	String
`reason`	String
`record_date`	String
`record_date_time_zone`	String
`record_type`	String
`risk_scoring`	Double
`shopper_email`	String
`shopper_reference`	String
`user_name`	String

payments_accounting_report

Column	Type	Keys
`_fivetran_id`	String	PK
`acquirer`	String
`acquirer_account`	String
`acquirer_auth_code`	String
`acquirer_reference`	String
`advanced_pc`	Double
`advancement_batch`	String
`advancement_code`	String
`advancement_fee_percentage`	String
`arn`	String
`authorised_pc`	Double
`booking_date`	String
`booking_date_ams`	String
`booking_type`	String
`captured_pc`	Double
`card_number`	String
`commission_sc`	Double
`company_account`	String
`creation_date`	String
`creation_date_ams`	String
`dcc_markup_sc`	Double
`exchange_rate`	Double
`funding_source`	String
`global_card_brand`	String
`gratuity_amount`	Double
`icsf_details`	String
`installments`	String
`installments_pc`	Double
`interchange_sc`	Double
`issuer_country`	String
`issuer_name`	String
`main_amount`	Double
`main_currency`	String
`markup_sc`	Double
`merchant_account`	String
`merchant_order_reference`	String
`merchant_reference`	String
`metadata`	String
`mid`	String
`modification_merchant_reference`	String
`modification_psp_reference`	String
`network_token_available`	String
`network_token_used`	String
`original_amount`	Double
`payable_batch`	Int
`payable_sc`	Double
`payment_account_reference`	String
`payment_currency`	String
`payment_method`	String
`payment_method_variant`	String
`payment_requester_type`	String
`payout_date`	String
`processing_fee_currency`	String
`processing_fee_fc`	Double
`psp_reference`	String
`received_pc`	Double
`record_type`	String
`risk_premium`	Boolean
`scheme_fees_sc`	Double
`settlement_currency`	String
`shopper_country`	String
`shopper_name`	String
`shopper_reference`	String
`split_payment_data`	String
`store`	String
`surcharge_amount`	Double
`tender_reference`	String
`time_zone`	String
`unique_terminal_id`	String
`user_name`	String

pos_authorized_amount

Column	Type	Keys
`_fivetran_id`	String	PK
`authorized_amount`	Double
`currency`	String
`store_id`	String
`terminal_country`	String
`terminal_model`	String
`transaction_count`	Int

threedsecure_conversion_report

Column	Type	Keys
`_fivetran_id`	String	PK
`acquirer`	String
`acquirer_response`	String
`amount`	Double
`avs_response`	String
`bin`	String
`company`	String
`creation_date`	String
`currency`	String
`cvc_response_code`	String
`cvc_supplied`	String
`merchant`	String
`merchant_reference`	String
`metadata`	String
`payment_method`	String
`pspreference`	String
`raw_acquirer_response`	String
`risk_score`	Double
`sent_for_auth`	Int
`shopper_country`	String
`shopper_email`	String
`shopper_interaction`	String
`shopper_ip`	String
`shopper_name`	String
`three_dsversion`	String
`threed_2_ares_transstatus`	String
`threed_2_rreq_transstatus`	String
`threed_authentication_response`	String
`threed_directory_response`	String
`time_zone`	String

received_payments_report

Column	Type	Keys
`_fivetran_id`	String	PK
`a_res_trans_status`	String
`acquirer`	String
`acquirer_account`	String
`acquirer_reference`	String
`acquirer_response`	String
`airlinedata`	String
`alternative_acquirer_reference`	String
`amount`	Double
`authorisation_code`	String
`avs_response`	String
`bcmc_iban_or_bic`	String
`billing_city`	String
`billing_country`	String
`billing_house_number_or_name`	String
`billing_postal_code_or_zip`	String
`billing_state_or_province`	String
`billing_street`	String
`bin_funding_source`	String
`browser`	String
`card_number`	String
`cash_register_name`	String
`cashback_amount`	Double
`company_account`	String
`creation_date`	String
`currency`	String
`cvc_2_response`	String
`cvm_performed`	String
`dcc`	String
`delivery_city`	String
`delivery_country`	String
`delivery_house_number_or_name`	String
`delivery_postal_code_or_zip`	String
`delivery_state_or_province`	String
`delivery_street`	String
`device`	String
`device_fingerprint`	String
`global_card_brand`	String
`installments`	String
`issuer_city`	String
`issuer_country`	String
`issuer_id`	String
`issuer_name`	String
`liability_shift`	Boolean
`library_implementation`	String
`library_version`	String
`mcc`	String
`merchant_account`	String
`merchant_order_reference`	String
`merchant_reference`	String
`metadata`	String
`network_token_available`	String
`network_token_used`	String
`network_transaction_reference`	String
`original_amount`	Double
`original_card_bin`	String
`payment_device`	String
`payment_method`	String
`payment_method_variant`	String
`payment_requester_type`	String
`pos_cashback_amount`	Double
`pos_charity_amount`	Double
`pos_discount_amount`	Double
`pos_entry_mode`	String
`pos_gratuity_amount`	Double
`pos_store_and_forward_indicator`	Boolean
`pos_tender_reference`	String
`pos_transaction_date`	String
`psp_reference`	String
`r_req_trans_status`	String
`raw_acquirer_response`	String
`realtime_account_updater_status`	String
`recurring_detail_reference`	String
`retry_json`	String
`risk_profile`	String
`risk_profile_id`	Int
`risk_profile_reference`	String
`risk_scoring`	Double
`shopper_country`	String
`shopper_email`	String
`shopper_interaction`	String
`shopper_ip`	String
`shopper_name`	String
`shopper_pan`	String
`shopper_phone_number`	String
`shopper_reference`	String
`split_payment_data`	String
`store`	String
`surcharge_amount`	Double
`terminal_app_version`	String
`three_dauthentication_response`	String
`three_ddirectory_response`	String
`three_dsversion`	String
`time_zone`	String
`type`	String

tap_to_pay_on_iphone

Column	Type	Keys
`_fivetran_id`	String	PK
`authorized_amount`	Double
`country`	String
`currency`	String
`store_id`	String
`transaction_count`	Int

dispute_report

Column	Type	Keys
`_fivetran_id`	String	PK
`acquirer`	String
`acquirer_account`	String
`avs_response`	String
`bic`	String
`capture_acquirer_reference`	String
`capture_modification_merchant_reference`	String
`cb_reason_code`	String
`cb_scheme_code`	String
`company_account`	String
`cvc_2_response`	String
`data_ed`	String
`dispute_amount`	Double
`dispute_arn`	String
`dispute_auto_defended`	Boolean
`dispute_currency`	String
`dispute_date`	String
`dispute_date_time_zone`	String
`dispute_end_date`	String
`dispute_end_date_time_zone`	String
`dispute_psp_reference`	String
`dispute_reason`	String
`global_card_brand`	String
`gross_amount`	Double
`iban`	String
`issuer_bin`	String
`issuer_country`	String
`issuer_id`	String
`issuer_name`	String
`issuer_region_program`	String
`liability_shift`	Boolean
`merchant_account`	String
`merchant_reference`	String
`merchant_store_code`	String
`metadata`	String
`no_freason_code`	String
`no_fscheme_code`	String
`payment_amount`	Double
`payment_currency`	String
`payment_date`	String
`payment_date_time_zone`	String
`payment_method`	String
`psp_reference`	String
`rdr`	Boolean
`record_date`	String
`record_date_time_zone`	String
`record_type`	String
`rfi_reason_code`	String
`rfi_scheme_code`	String
`risk_scoring`	Double
`second_chargeback`	Boolean
`shopper_country`	String
`shopper_email`	String
`shopper_interaction`	String
`shopper_ip`	String
`shopper_name`	String
`shopper_pan`	String
`shopper_phone_number`	String
`shopper_reference`	String
`shopper_statement`	String
`status`	String
`three_dauthentication_response`	String
`three_ddirectory_response`	String
`user_name`	String

external_settlement_detail_report

Column	Type	Keys
`_fivetran_id`	String	PK
`acquirer`	String
`acquirer_auth_code`	String
`acquirer_reference`	String
`arn`	String
`card_bin`	String
`card_number_summary`	String
`commission_nc`	Double
`company_account`	String
`creation_date`	String
`exchange_rate`	Double
`gross_credit_gc`	Double
`gross_currency`	String
`gross_debit_gc`	Double
`interchange_nc`	Double
`markup_nc`	Double
`merchant_account`	String
`merchant_order_reference`	String
`merchant_reference`	String
`metadata`	String
`mid`	String
`modification_merchant_reference`	String
`modification_reference`	String
`net_credit_nc`	Double
`net_currency`	String
`net_debit_nc`	Double
`payment_method`	String
`payment_method_variant`	String
`psp_reference`	String
`scheme_fees_nc`	Double
`store_code`	String
`submerchant_identifier`	String
`time_zone`	String
`type`	String

settlement_detail_report

Column	Type	Keys
`_fivetran_id`	String	PK
`acquirer`	String
`additional_type`	String
`advanced_nc`	Double
`advancement_batch`	String
`advancement_code`	String
`arn`	String
`authorisation_code`	String
`authorised_date`	String
`authorised_date_time_zone`	String
`balance_currency`	String
`balance_platform_credit`	Double
`balance_platform_debit`	Double
`batch_number`	Int
`booking_date`	String
`booking_date_ams`	String
`booking_date_time_zone`	String
`booking_type`	String
`card_number`	String
`clearing_network`	String
`commission_nc`	Double
`company_account`	String
`creation_date`	String
`creation_date_ams`	String
`dcc_markup_nc`	Double
`dispute_reference`	String
`exchange_rate`	Double
`funds_destination`	String
`global_card_brand`	String
`gratuity_amount`	Double
`gross_credit_gc`	Double
`gross_currency`	String
`gross_debit_gc`	Double
`installments`	String
`interchange_nc`	Double
`issuer_country`	String
`markup_nc`	Double
`merchant_account`	String
`merchant_order_reference`	String
`merchant_reference`	String
`metadata`	String
`modification_merchant_reference`	String
`modification_reference`	String
`net_credit_bc`	Double
`net_credit_nc`	Double
`net_currency`	String
`net_debit_bc`	Double
`net_debit_nc`	Double
`payment_fees_nc`	Double
`payment_method`	String
`payment_method_variant`	String
`payment_transaction_group`	String
`pos_transaction_date`	String
`pos_transaction_date_time_zone`	String
`psp_reference`	String
`scheme_fees_nc`	Double
`settlement_flow`	String
`shopper_country`	String
`shopper_reference`	String
`split_payment_data`	String
`split_settlement`	String
`store`	String
`surcharge_amount`	Double
`tender_reference`	String
`terminal_id`	String
`time_zone`	String
`type`	String

accountconfig_report

Column	Type	Keys
`_fivetran_id`	String	PK
`acquirer_account_name`	String
`acquirer_name`	String
`company_account_name`	String
`merchant_account_capture_delay`	String
`merchant_account_merchant_name`	String
`merchant_account_name`	String
`merchant_account_status`	String
`payment_method_action_code`	String
`payment_method_active`	String
`payment_method_allowed_application_id`	String
`payment_method_allowed_cvmlimit`	String
`payment_method_allowed_posentry_mode`	String
`payment_method_authorisation_type`	String
`payment_method_available_countries`	String
`payment_method_currency_codes`	String
`payment_method_custom_routing_flag`	String
`payment_method_installments`	String
`payment_method_issuer_country_codes`	String
`payment_method_max_delivery`	String
`payment_method_merchant_category_code`	Int
`payment_method_merchant_category_code_override_configuration`	Int
`payment_method_merchant_name`	String
`payment_method_midnumber`	String
`payment_method_min_delivery`	String
`payment_method_priority`	Int
`payment_method_routing_binconfig_name`	String
`payment_method_settlement_type`	String
`payment_method_shopper_interaction`	String
`payment_method_type`	String
`payment_method_weight`	Int
`store_code`	String
`store_description`	String
`store_status`	String

non_transactional_scheme_fees_report

Column	Type	Keys
`_fivetran_id`	String	PK
`acquirer`	String
`billing_month`	String
`company`	String
`currency_code`	String
`details`	String
`fee_amount`	String
`fee_end_date`	String
`fee_name`	String
`fee_start_date`	String
`frequency`	String
`merchant`	String
`scheme`	String