Checkout.com

Explore the interactive ERD

Table & Field Reference

balance

Column	Type	Keys
`_fivetran_id`	String	PK
`entity_id`	String	FK
`available`	Unknown
`collateral`	Unknown
`descriptor`	Unknown
`holding_currency`	Unknown
`payable`	Unknown
`pending`	Unknown

dispute

Column	Type	Keys
`id`	Unknown	PK
`entity_id`	Unknown	FK
`payment_action_id`	Unknown	FK
`payment_id`	Unknown	FK
`amount`	Unknown
`category`	Unknown
`currency`	Unknown
`evidence_required_by`	Unknown
`last_update`	Instant
`payment_arn`	Unknown
`payment_mcc`	Unknown
`payment_method`	Unknown
`payment_reference`	Unknown
`processing_channel`	Unknown
`reason_code`	Unknown
`received_on`	Unknown
`resolved_reason`	Unknown
`status`	Unknown

report

Column	Type	Keys
`id`	Unknown	PK
`client_id`	Unknown
`created_on`	Unknown
`description`	Unknown
`entity_id`	Unknown
`from_date`	Unknown
`last_modified_on`	Unknown
`name`	Unknown
`tags`	Json
`to_date`	Unknown
`type`	Unknown

balance_report

Column	Type	Keys
`_fivetran_id`	String	PK
`entity_id`	Unknown	FK
`report_id`	Unknown	FK
`account_updater_fee`	Unknown
`acquiring_premium`	Unknown
`adjustment`	Unknown
`alternative_payment_method_fee`	Unknown
`authentication_fee`	Unknown
`authentication_scheme_fee`	Unknown
`billing_fee`	Unknown
`card_payment_blended_fee`	Unknown
`card_payment_gateway_fee`	Unknown
`card_payment_interchange_fee`	Unknown
`card_payment_scheme_fee`	Unknown
`chargeback`	Unknown
`chargeback_fee`	Unknown
`closing_available_balance`	Unknown
`closing_collateral_balance`	Unknown
`closing_payable_balance`	Unknown
`closing_pending_balance`	Unknown
`currency_account_id`	Unknown
`currency_account_name`	Unknown
`description`	Unknown
`entity_name`	Unknown
`holding_currency`	Unknown
`integrated_platform_fee`	Unknown
`intelligent_acceptance_fee`	Unknown
`merchant_payout`	Unknown
`merchant_payout_fee`	Unknown
`network_token_fee`	Unknown
`opening_available_balance`	Unknown
`opening_collateral_balance`	Unknown
`opening_payable_balance`	Unknown
`opening_pending_balance`	Unknown
`pay_to_bank_fee`	Unknown
`pay_to_bank_payout`	Unknown
`pay_to_card`	Unknown
`pay_to_card_fee`	Unknown
`pay_to_card_interchange_fee`	Unknown
`pay_to_card_scheme_fee`	Unknown
`payment`	Unknown
`payment_method`	Unknown
`refund`	Unknown
`refund_gateway_fee`	Unknown
`refund_scheme_fee`	Unknown
`refunded_interchange_fee`	Unknown
`report_date`	Unknown
`report_file_id`	Unknown
`reporting_end_date`	Unknown
`reporting_start_date`	Unknown
`representment_fee`	Unknown
`reserve_deducted`	Unknown
`reserve_released`	Unknown
`retrieval_fee`	Unknown
`risk_engine_fee`	Unknown
`tax`	Unknown
`transfers_in`	Unknown
`transfers_out`	Unknown

customer_meta_data

Column	Type	Keys
`name`	Unknown	PK
`customer_id`	Unknown	PKFK
`value`	Unknown

customer

Column	Type	Keys
`id`	Unknown	PK
`default_value`	Unknown
`email`	Unknown
`name`	Unknown

instrument_bank_account

Column	Type	Keys
`customer_id`	Unknown	PK
`id`	Unknown	PK
`account_holder_billing_address_city`	Unknown
`account_holder_billing_address_country`	Unknown
`account_holder_billing_address_line_1`	Unknown
`account_holder_billing_address_line_2`	Unknown
`account_holder_billing_address_state`	Unknown
`account_holder_billing_address_zip`	Unknown
`account_holder_company_name`	Unknown
`account_holder_country_of_birth`	Unknown
`account_holder_date_of_birth`	Unknown
`account_holder_email`	Unknown
`account_holder_first_name`	Unknown
`account_holder_identification_issuing_country`	Unknown
`account_holder_identification_number`	Unknown
`account_holder_identification_type`	Unknown
`account_holder_last_name`	Unknown
`account_holder_phone_country_code`	Unknown
`account_holder_phone_number`	Unknown
`account_holder_residential_status`	Unknown
`account_holder_tax_id`	Unknown
`account_holder_type`	Unknown
`account_number`	Unknown
`account_type`	Unknown
`bank_address_city`	Unknown
`bank_address_country`	Unknown
`bank_address_line_1`	Unknown
`bank_address_line_2`	Unknown
`bank_address_state`	Unknown
`bank_address_zip`	Unknown
`bank_branch`	Unknown
`bank_code`	Unknown
`bank_name`	Unknown
`bban`	Unknown
`branch_code`	Unknown
`country`	Unknown
`currency`	Unknown
`fingerprint_token`	Unknown
`iban`	Unknown
`swift_bic`	Unknown
`type`	Unknown

instrument_card

Column	Type	Keys
`customer_id`	Unknown	PK
`id`	Unknown	PK
`account_holder_billing_address_city`	Unknown
`account_holder_billing_address_country`	Unknown
`account_holder_billing_address_line_1`	Unknown
`account_holder_billing_address_line_2`	Unknown
`account_holder_billing_address_state`	Unknown
`account_holder_billing_address_zip`	Unknown
`account_holder_first_name`	Unknown
`account_holder_last_name`	Unknown
`account_holder_phone_country_code`	Unknown
`account_holder_phone_number`	Unknown
`bin`	Unknown
`card_category`	Unknown
`card_type`	Unknown
`expiry_month`	Unknown
`expiry_year`	Unknown
`fingerprint_token`	Unknown
`issuer`	Unknown
`issuer_country`	Unknown
`last_4`	Unknown
`product_id`	Unknown
`product_type`	Unknown
`scheme`	Unknown
`type`	Unknown

payment_amount_allocation

Column	Type	Keys
`id`	Unknown	PK
`payment_id`	Unknown	PKFK
`amount`	Unknown
`commission_amount`	Unknown
`commission_percentage`	Unknown
`reference`	Unknown

payment_item

Column	Type	Keys
`index`	Unknown	PK
`payment_id`	Unknown	PKFK
`commodity_code`	Unknown
`discount_amount`	Unknown
`image_url`	Unknown
`name`	Unknown
`quantity`	Unknown
`reference`	Unknown
`tax_amount`	Unknown
`total_amount`	Unknown
`unit_of_measure`	Unknown
`unit_price`	Unknown
`url`	Unknown
`wxpay_goods_id`	Unknown

payment_meta_data

Column	Type	Keys
`name`	Unknown	PK
`payment_id`	Unknown	PKFK
`value`	Unknown

payment

Column	Type	Keys
`id`	Unknown	PK
`customer_id`	Unknown	FK
`amount`	Unknown
`approved`	Unknown
`balance_available_to_capture`	Unknown
`balance_available_to_refund`	Unknown
`balance_available_to_void`	Unknown
`balance_total_authorized`	Unknown
`balance_total_captured`	Unknown
`balance_total_refunded`	Unknown
`balance_total_voided`	Unknown
`billing_descriptor_city`	Unknown
`billing_descriptor_local_descriptors`	Json
`billing_descriptor_name`	Unknown
`billing_descriptor_reference`	Unknown
`currency`	Unknown
`customer_email`	Unknown
`customer_name`	Unknown
`description`	Unknown
`destination_id`	Unknown
`destination_type`	Unknown
`eci`	Unknown
`expires_on`	Unknown
`payment_ip`	Unknown
`payment_type`	Unknown
`processing_acquirer_transaction_id`	Unknown
`processing_aft`	Unknown
`processing_app_id`	Unknown
`processing_custom_payment_method_ids`	Json
`processing_fraud_status`	Unknown
`processing_locale`	Unknown
`processing_merchant_category_code`	Unknown
`processing_partner_authorization_code`	Unknown
`processing_partner_authorization_response_code`	Unknown
`processing_partner_customer_id`	Unknown
`processing_partner_error_codes`	Json
`processing_partner_error_message`	Unknown
`processing_partner_order_id`	Unknown
`processing_partner_payment_id`	Unknown
`processing_partner_status`	Unknown
`processing_partner_transaction_id`	Unknown
`processing_preferred_scheme`	Unknown
`processing_provider_authorized_payment_method_description`	Unknown
`processing_provider_authorized_payment_method_number_of_days`	Unknown
`processing_provider_authorized_payment_method_number_of_installments`	Unknown
`processing_provider_authorized_payment_method_type`	Unknown
`processing_purchase_country`	Unknown
`processing_retrieval_reference_number`	Unknown
`processing_scheme_merchant_id`	Unknown
`processing_tax_amount`	Unknown
`recipient_account_number`	Unknown
`recipient_address_city`	Unknown
`recipient_address_country`	Unknown
`recipient_address_line_1`	Unknown
`recipient_address_line_2`	Unknown
`recipient_address_state`	Unknown
`recipient_address_zip`	Unknown
`recipient_dob`	Unknown
`recipient_first_name`	Unknown
`recipient_last_name`	Unknown
`reference`	Unknown
`requested_on`	Unknown
`risk_flagged`	Unknown
`risk_score`	Unknown
`scheme_id`	Unknown
`sender_address_city`	Unknown
`sender_address_country`	Unknown
`sender_address_line_1`	Unknown
`sender_address_line_2`	Unknown
`sender_address_state`	Unknown
`sender_address_zip`	Unknown
`sender_first_name`	Unknown
`sender_last_name`	Unknown
`sender_reference`	Unknown
`sender_type`	Unknown
`shipping_address_city`	Unknown
`shipping_address_country`	Unknown
`shipping_address_line_1`	Unknown
`shipping_address_line_2`	Unknown
`shipping_address_state`	Unknown
`shipping_address_zip`	Unknown
`shipping_phone_country_code`	Unknown
`shipping_phone_number`	Unknown
`source_type`	Unknown
`status`	Unknown
`three_d_secure_authentication_response`	Unknown
`three_d_secure_authentication_status_reason`	Unknown
`three_d_secure_challenged`	Unknown
`three_d_secure_cryptogram`	Unknown
`three_d_secure_downgraded`	Unknown
`three_d_secure_enrolled`	Unknown
`three_d_secure_exemption`	Unknown
`three_d_secure_exemption_applied`	Unknown
`three_d_secure_signature_valid`	Unknown
`three_d_secure_trusted_listing_source`	Unknown
`three_d_secure_trusted_listing_status`	Unknown
`three_d_secure_upgrade_reason`	Unknown
`three_d_secure_version`	Unknown
`three_d_secure_xid`	Unknown

payment_source_bancontact

Column	Type	Keys
`index`	Unknown	PK
`payment_id`	Unknown	PKFK
`iban`	Unknown

payment_source_p_24

Column	Type	Keys
`index`	Unknown	PK
`payment_id`	Unknown	PKFK
`p_24_descriptor`	Unknown

payment_source_qpay

Column	Type	Keys
`id`	Unknown	PK
`payment_id`	Unknown	PKFK
`confirmation_id`	Unknown
`description`	Unknown
`qpay_status`	Unknown
`status_message`	Unknown

payment_source_giropay

Column	Type	Keys
`index`	Unknown	PK
`payment_id`	Unknown	PKFK
`account_holder_first_name`	Unknown
`account_holder_last_name`	Unknown
`account_holder_name`	Unknown
`bic`	Unknown
`iban`	Unknown
`purpose`	Unknown

payment_source_eps

Column	Type	Keys
`index`	Unknown	PK
`payment_id`	Unknown	PKFK
`account_holder_first_name`	Unknown
`account_holder_last_name`	Unknown
`account_holder_name`	Unknown
`bic`	Unknown
`iban`	Unknown
`purpose`	Unknown

payment_source_multibance

Column	Type	Keys
`index`	Unknown	PK
`payment_id`	Unknown	PKFK
`payment_reference`	Unknown
`service_supplier_id`	Unknown

payment_source_knet

Column	Type	Keys
`index`	Unknown	PK
`payment_id`	Unknown	PKFK
`auth_code`	Unknown
`auth_response_code`	Unknown
`avr`	Unknown
`bank_reference`	Unknown
`card_token`	Unknown
`error`	Unknown
`error_text`	Unknown
`inquiry_result`	Unknown
`knet_payment_id`	Unknown
`knet_result`	Unknown
`knet_transaction_id`	Unknown
`language_name`	Unknown
`post_date`	Unknown
`ptlf`	Unknown
`user_defined_field_1`	Unknown
`user_defined_field_2`	Unknown
`user_defined_field_3`	Unknown
`user_defined_field_4`	Unknown
`user_defined_field_5`	Unknown

payment_source_klarna

Column	Type	Keys
`index`	Unknown	PK
`payment_id`	Unknown	PKFK
`account_holder_billing_address_city`	Unknown
`account_holder_billing_address_country`	Unknown
`account_holder_billing_address_line_1`	Unknown
`account_holder_billing_address_line_2`	Unknown
`account_holder_billing_address_state`	Unknown
`account_holder_billing_address_zip`	Unknown
`account_holder_date_of_birth`	Unknown
`account_holder_email`	Unknown
`account_holder_first_name`	Unknown
`account_holder_gender`	Unknown
`account_holder_last_name`	Unknown
`account_holder_phone_country_code`	Unknown
`account_holder_phone_number`	Unknown
`account_holder_title`	Unknown

payment_source_currency_account

Column	Type	Keys
`id`	Unknown	PK
`payment_id`	Unknown	PKFK
`amount`	Unknown

payment_source_card

Column	Type	Keys
`fingerprint_token`	Unknown	PKFK
`payment_id`	Unknown	PKFK
`avs_check`	Unknown
`cvv_check`	Unknown
`payment_account_reference`	Unknown

payment_source_sepa

Column	Type	Keys
`id`	Unknown	PKFK
`payment_id`	Unknown	PKFK

payment_action_meta_data

Column	Type	Keys
`name`	Unknown	PK
`payment_action_id`	Unknown	PKFK
`payment_action_payment_id`	Unknown	PKFK
`value`	Unknown

payment_action

Column	Type	Keys
`id`	Unknown	PK
`payment_id`	Unknown	PKFK
`amount`	Unknown
`approved`	Unknown
`auth_code`	Unknown
`authorization_type`	Unknown
`capture_type`	Unknown
`processed_on`	Unknown
`processing_acquirer_reference_number`	Unknown
`processing_acquirer_transaction_id`	Unknown
`processing_capture_payment_id`	Unknown
`processing_retrieval_reference_number`	Unknown
`reference`	Unknown
`response_code`	Unknown
`response_summary`	Unknown
`type`	Unknown

financial_action_report

Column	Type	Keys
`_fivetran_id`	String	PK
`action_id`	Unknown	FK
`client_entity_id`	Unknown	FK
`payment_id`	Unknown	FK
`payout_id`	Unknown	FK
`report_id`	Unknown	FK
`account_funding_transaction`	Unknown
`acquirer_reference_number`	Unknown
`action_type`	Unknown
`breakdown_type`	Unknown
`card_category`	Unknown
`card_type`	Unknown
`client_entity_name`	Unknown
`currency_account_custom_id`	Unknown
`currency_account_id`	Unknown
`currency_account_name`	Unknown
`entity_country`	Unknown
`entity_country_tax_currency`	Unknown
`fee_detail`	Unknown
`fx_rate_applied`	Unknown
`fx_trade_id`	Unknown
`holding_currency`	Unknown
`holding_currency_amount`	Unknown
`index_id`	Unknown
`issuer_country`	Unknown
`merchant_category_code`	Unknown
`mid`	Unknown
`payment_method`	Unknown
`processed_on`	Unknown
`processing_channel_id`	Unknown
`processing_channel_name`	Unknown
`processing_currency`	Unknown
`processing_currency_amount`	Unknown
`processing_to_transaction_currency_fx_rate`	Unknown
`reference`	Unknown
`region`	Unknown
`report_file_id`	Unknown
`requested_on`	Unknown
`reserve_deducted_date`	Unknown
`reserve_rate`	Unknown
`reserve_release_date`	Unknown
`response_code`	Unknown
`response_description`	Unknown
`sub_entity_id`	Unknown
`sub_entity_name`	Unknown
`tax_currency_amount`	Unknown
`tax_fx_rate`	Unknown
`transaction_currency`	Unknown
`transaction_currency_amount`	Unknown
`transaction_to_holding_currency_fx_rate`	Unknown

payout_report

Column	Type	Keys
`_fivetran_id`	String	PK
`client_entity_id`	Unknown	FK
`report_id`	Unknown	FK
`account_updater_fee`	Unknown
`acquiring_premium`	Unknown
`adjustment`	Unknown
`alternative_payment_method_fee`	Unknown
`authentication_fee`	Unknown
`authentication_scheme_fee`	Unknown
`billing_fee`	Unknown
`card_payment_blended_fee`	Unknown
`card_payment_gateway_fee`	Unknown
`card_payment_interchange_fee`	Unknown
`card_payment_scheme_fee`	Unknown
`chargeback`	Unknown
`chargeback_fee`	Unknown
`client_entity_name`	Unknown
`currency_account_id`	Unknown
`currency_account_name`	Unknown
`holding_currency`	Unknown
`integrated_platforms_fee`	Unknown
`intelligent_acceptance_fee`	Unknown
`merchant_payout_fee`	Unknown
`network_token_fee`	Unknown
`pay_to_bank_fee`	Unknown
`pay_to_bank_payout`	Unknown
`pay_to_card`	Unknown
`pay_to_card_fee`	Unknown
`pay_to_card_interchange_fee`	Unknown
`pay_to_card_scheme_fee`	Unknown
`payment`	Unknown
`payout_amount`	Unknown
`payout_date`	Unknown
`payout_id`	Unknown
`refund`	Unknown
`refund_gateway_fee`	Unknown
`refund_scheme_fee`	Unknown
`refunded_interchange_fee`	Unknown
`report_file_id`	Unknown
`reporting_end_date`	Unknown
`reporting_start_date`	Unknown
`representment_fee`	Unknown
`reserve_deducted`	Unknown
`reserve_released`	Unknown
`retrieval_fee`	Unknown
`risk_engine_fee`	Unknown
`sub_entity_id`	Unknown
`sub_entity_name`	Unknown
`tax`	Unknown
`transfers_in`	Unknown
`transfers_out`	Unknown

financial_action_by_payout_report

Column	Type	Keys
`_fivetran_id`	String	PK
`action_id`	Unknown	FK
`client_entity_id`	Unknown	FK
`payment_id`	Unknown	FK
`payout_id`	Unknown	FK
`report_id`	Unknown	FK
`account_funding_transaction`	Unknown
`acquirer_reference_number`	Unknown
`action_type`	Unknown
`breakdown_type`	Unknown
`card_category`	Unknown
`card_type`	Unknown
`client_entity_name`	Unknown
`currency_account_custom_id`	Unknown
`currency_account_id`	Unknown
`currency_account_name`	Unknown
`entity_country`	Unknown
`entity_country_tax_currency`	Unknown
`fee_detail`	Unknown
`fx_rate_applied`	Unknown
`fx_trade_id`	Unknown
`holding_currency`	Unknown
`holding_currency_amount`	Unknown
`index_id`	Unknown
`issuer_country`	Unknown
`merchant_category_code`	Unknown
`mid`	Unknown
`payment_method`	Unknown
`processed_on`	Unknown
`processing_channel_id`	Unknown
`processing_channel_name`	Unknown
`processing_currency`	Unknown
`processing_currency_amount`	Unknown
`processing_to_transaction_currency_fx_rate`	Unknown
`reference`	Unknown
`region`	Unknown
`report_file_id`	Unknown
`requested_on`	Unknown
`reserve_deducted_date`	Unknown
`reserve_rate`	Unknown
`reserve_release_date`	Unknown
`response_code`	Unknown
`response_description`	Unknown
`sub_entity_id`	Unknown
`sub_entity_name`	Unknown
`tax_currency_amount`	Unknown
`tax_fx_rate`	Unknown
`transaction_currency`	Unknown
`transaction_currency_amount`	Unknown
`transaction_to_holding_currency_fx_rate`	Unknown