# Adyen schema ERD

Table and field reference for the Fivetran Adyen connector.

## 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 |  |