ERD for Paypal

41 tables

Loading diagram…

billing_plan

string

create_time

date

description

string

merchant_preferences_cancel_url

string

merchant_preferences_return_url

string

name

string

payment_preferences_auto_bill_outstanding

boolean

payment_preferences_payment_failure_threshold

int

payment_preferences_setup_fee_currency_code

string

payment_preferences_setup_fee_value

string

payment_preferences_setup_fee_failure_action

string

product_id

string

quantity_supported

boolean

status

string

taxes_inclusive

boolean

taxes_percentage

string

update_time

date

_weld_synced

date

billing_plan_billing_cycle

billing_plan_id

string

index

int

create_time

date

frequency_interval_count

int

frequency_interval_unit

string

pricing_scheme_fixed_price_currency_code

string

pricing_scheme_fixed_price_value

string

pricing_scheme_pricing_model

string

pricing_scheme_version

int

sequence

int

tenure_type

string

total_cycles

int

update_time

date

_weld_synced

date

billing_plan_pricing_tier

billing_plan_id

string

billing_cycle_index

int

index

int

amount_currency_code

string

amount_value

string

ending_quantity

string

starting_quantity

string

_weld_synced

date

dispute

dispute_id

string

allowed_response_options_accept_claim_accept_claim_types

string

allowed_response_options_acknowledge_return_item_acknowledgement_types

string

allowed_response_options_make_offer_offer_types

string

buyer_response_due_date

date

communication_details_email

string

communication_details_note

string

communication_details_time_posted

date

create_time

date

dispute_amount_currency_code

string

dispute_amount_value

string

dispute_asset_asset_symbol

string

dispute_asset_quantity

string

dispute_asset_quantity_in_subunits

string

dispute_asset_decimals

int

dispute_channel

string

dispute_life_cycle_stage

string

dispute_outcome_amount_refunded_currency_code

string

dispute_outcome_amount_refunded_value

string

dispute_outcome_asset_refunded_asset_symbol

string

dispute_outcome_asset_refunded_quantity

string

dispute_outcome_asset_refunded_quantity_in_subunits

string

dispute_outcome_asset_refunded_decimals

int

dispute_outcome_outcome_code

string

dispute_outcome_outcome_reason

string

dispute_state

string

extensions_buyer_contacted_time

date

extensions_merchant_buyer_contacted_channel

string

extensions_merchant_contacted

boolean

extensions_merchant_contacted_mode

string

extensions_merchant_contacted_outcome

string

extensions_merchant_contacted_time

date

extensions_reported_source

string

external_reason_code

string

fee_policy

string

offer_buyer_requested_amount_currency_code

string

offer_buyer_requested_amount_value

string

offer_offer_type

string

offer_seller_offered_amount_currency_code

string

offer_seller_offered_amount_value

string

reason

string

refund_details_allowed_refund_amount_currency_code

string

refund_details_allowed_refund_amount_value

string

seller_response_due_date

date

status

string

update_time

date

_weld_synced

date

dispute_disputed_transaction

dispute_id

string

index

int

buyer_name

string

buyer_transaction_id

string

create_time

date

custom

string

gross_amount_currency_code

string

gross_amount_value

string

gross_asset_asset_symbol

string

gross_asset_quantity

string

gross_asset_quantity_in_subunits

string

gross_asset_decimals

int

invoice_number

string

reference_id

string

seller_email

string

seller_merchant_id

string

seller_name

string

seller_transaction_id

string

transaction_status

string

_weld_synced

date

dispute_disputed_transaction_item

dispute_id

string

disputed_transaction_index

int

index

int

dispute_amount_currency_code

string

dispute_amount_value

string

item_description

string

item_id

string

item_name

string

item_quantity

string

item_type

string

notes

string

partner_transaction_id

string

reason

string

_weld_synced

date

dispute_adjudication

dispute_id

string

index

int

adjudication_time

date

dispute_life_cycle_stage

string

reason

string

type

string

_weld_synced

date

dispute_fund_movement

dispute_id

string

index

int

amount_currency_code

string

amount_value

string

asset_asset_symbol

string

asset_quantity

string

asset_quantity_in_subunits

string

asset_decimals

int

initiated_time

date

party

string

reason

string

type

string

_weld_synced

date

dispute_message

dispute_id

string

index

int

content

string

documents

string

posted_by

string

time_posted

date

_weld_synced

date

dispute_evidence

dispute_id

string

index

int

action_info_action

string

action_info_mandatory

boolean

action_info_response_option

string

date

dispute_life_cycle_stage

string

documents

string

evidence_info_refund_ids

string

evidence_info_tracking_info

string

evidence_type

string

item_id

string

item_type

string

notes

string

source

string

_weld_synced

date

dispute_supporting_info

dispute_id

string

index

int

dispute_life_cycle_stage

string

documents

string

notes

string

provided_time

date

source

string

_weld_synced

date

dispute_offer_history

dispute_id

string

index

int

actor

string

dispute_life_cycle_stage

string

event_type

string

notes

string

offer_amount_currency_code

string

offer_amount_value

string

offer_time

date

offer_type

string

_weld_synced

date

dispute_refund_transaction

string

dispute_id

string

index

int

create_time

date

gross_amount_currency_code

string

gross_amount_value

string

_weld_synced

date

dispute_history

dispute_id

string

allowed_response_options_accept_claim_accept_claim_types

string

allowed_response_options_acknowledge_return_item_acknowledgement_types

string

allowed_response_options_make_offer_offer_types

string

buyer_response_due_date

date

communication_details_email

string

communication_details_note

string

communication_details_time_posted

date

create_time

date

dispute_amount_currency_code

string

dispute_amount_value

string

dispute_asset_asset_symbol

string

dispute_asset_quantity

string

dispute_asset_quantity_in_subunits

string

dispute_asset_decimals

int

dispute_channel

string

dispute_life_cycle_stage

string

dispute_outcome_amount_refunded_currency_code

string

dispute_outcome_amount_refunded_value

string

dispute_outcome_asset_refunded_asset_symbol

string

dispute_outcome_asset_refunded_quantity

string

dispute_outcome_asset_refunded_quantity_in_subunits

string

dispute_outcome_asset_refunded_decimals

int

dispute_outcome_outcome_code

string

dispute_outcome_outcome_reason

string

dispute_state

string

extensions_buyer_contacted_time

date

extensions_merchant_buyer_contacted_channel

string

extensions_merchant_contacted

boolean

extensions_merchant_contacted_mode

string

extensions_merchant_contacted_outcome

string

extensions_merchant_contacted_time

date

extensions_reported_source

string

external_reason_code

string

fee_policy

string

offer_buyer_requested_amount_currency_code

string

offer_buyer_requested_amount_value

string

offer_offer_type

string

offer_seller_offered_amount_currency_code

string

offer_seller_offered_amount_value

string

reason

string

refund_details_allowed_refund_amount_currency_code

string

refund_details_allowed_refund_amount_value

string

seller_response_due_date

date

status

string

update_time

date

_weld_synced

date

invoice

string

additional_recipients

string

amount_currency_code

string

amount_value

string

amount_breakdown_custom_amount_currency_code

string

amount_breakdown_custom_amount_value

string

amount_breakdown_custom_label

string

amount_breakdown_discount_invoice_discount_amount_currency_code

string

amount_breakdown_discount_invoice_discount_amount_value

string

amount_breakdown_discount_invoice_discount_percent

string

amount_breakdown_discount_item_discount_currency_code

string

amount_breakdown_discount_item_discount_value

string

amount_breakdown_item_total_currency_code

string

amount_breakdown_item_total_value

string

amount_breakdown_shipping_amount_currency_code

string

amount_breakdown_shipping_amount_value

string

amount_breakdown_shipping_tax_amount_currency_code

string

amount_breakdown_shipping_tax_amount_value

string

amount_breakdown_shipping_tax_name

string

amount_breakdown_shipping_tax_note

string

amount_breakdown_shipping_tax_percent

string

amount_breakdown_tax_total_currency_code

string

amount_breakdown_tax_total_value

string

configuration_allow_tip

boolean

configuration_partial_payment_allow_partial_payment

boolean

configuration_partial_payment_minimum_amount_due_currency_code

string

configuration_partial_payment_minimum_amount_due_value

string

configuration_tax_calculated_after_discount

boolean

configuration_tax_inclusive

boolean

configuration_template_id

string

detail_currency_code

string

detail_invoice_date

string

detail_invoice_number

string

detail_memo

string

detail_metadata_cancel_time

date

detail_metadata_cancelled_by

string

detail_metadata_create_time

date

detail_metadata_created_by

string

detail_metadata_created_by_flow

string

detail_metadata_first_sent_time

date

detail_metadata_invoicer_view_url

string

detail_metadata_last_sent_by

string

detail_metadata_last_sent_time

date

detail_metadata_last_update_time

date

detail_metadata_last_updated_by

string

detail_metadata_recipient_view_url

string

detail_note

string

detail_payment_term_due_date

date

detail_payment_term_term_type

string

detail_reference

string

detail_terms_and_conditions

string

due_amount_currency_code

string

due_amount_value

string

gratuity_currency_code

string

gratuity_value

string

invoicer_additional_notes

string

invoicer_address_address_line_1

string

invoicer_address_address_line_2

string

invoicer_address_address_line_3

string

invoicer_address_admin_area_1

string

invoicer_address_admin_area_2

string

invoicer_address_admin_area_3

string

invoicer_address_admin_area_4

string

invoicer_address_country_code

string

invoicer_address_postal_code

string

invoicer_business_name

string

invoicer_email_address

string

invoicer_logo_url

string

invoicer_name_alternate_full_name

string

invoicer_name_full_name

string

invoicer_name_given_name

string

invoicer_name_middle_name

string

invoicer_name_prefix

string

invoicer_name_suffix

string

invoicer_name_surname

string

invoicer_tax_id

string

invoicer_website

string

parent_id

string

payments_paid_amount_currency_code

string

payments_paid_amount_value

string

refunds_refund_amount_currency_code

string

refunds_refund_amount_value

string

status

string

_weld_synced

date

invoice_attachment

string

invoice_id

string

content_type

string

create_time

date

reference_url

string

size

string

_weld_synced

date

invoice_item

string

invoice_id

string

description

string

discount_amount_currency_code

string

discount_amount_value

string

discount_percent

string

item_date

string

name

string

quantity

string

tax_amount_currency_code

string

tax_amount_value

string

tax_name

string

tax_note

string

tax_percent

string

unit_amount_currency_code

string

unit_amount_value

string

unit_of_measure

string

_weld_synced

date

invoice_payment_transaction

invoice_id

string

payment_id

string

_weld_synced

date

invoice_recipient

invoice_id

string

index

int

billing_info_additional_info

string

billing_info_address_address_line_1

string

billing_info_address_address_line_2

string

billing_info_address_address_line_3

string

billing_info_address_admin_area_1

string

billing_info_address_admin_area_2

string

billing_info_address_admin_area_3

string

billing_info_address_admin_area_4

string

billing_info_address_country_code

string

billing_info_address_postal_code

string

billing_info_business_name

string

billing_info_email_address

string

billing_info_language

string

billing_info_name_alternate_full_name

string

billing_info_name_full_name

string

billing_info_name_given_name

string

billing_info_name_middle_name

string

billing_info_name_prefix

string

billing_info_name_suffix

string

billing_info_name_surname

string

billing_info_phones

string

shipping_info_address_address_line_1

string

shipping_info_address_address_line_2

string

shipping_info_address_address_line_3

string

shipping_info_address_admin_area_1

string

shipping_info_address_admin_area_2

string

shipping_info_address_admin_area_3

string

shipping_info_address_admin_area_4

string

shipping_info_address_country_code

string

shipping_info_address_postal_code

string

shipping_info_business_name

string

shipping_info_name_alternate_full_name

string

shipping_info_name_full_name

string

shipping_info_name_given_name

string

shipping_info_name_middle_name

string

shipping_info_name_prefix

string

shipping_info_name_suffix

string

shipping_info_name_surname

string

_weld_synced

date

invoice_refund_transaction

invoice_id

string

refund_id

string

_weld_synced

date

invoice_invoicer_phone

invoice_id

string

index

int

country_code

string

extension_number

string

national_number

string

phone_type

string

_weld_synced

date

subscription

string

billing_info_current_cycle_sequence

int

billing_info_failed_payments_count

int

billing_info_final_payment_time

date

billing_info_last_failed_payment_amount_currency_code

string

billing_info_last_failed_payment_amount_value

string

billing_info_last_failed_payment_next_payment_retry_time

date

billing_info_last_failed_payment_reason_code

string

billing_info_last_failed_payment_time

date

billing_info_last_payment_amount_currency_code

string

billing_info_last_payment_amount_value

string

billing_info_last_payment_status

string

billing_info_last_payment_time

date

billing_info_next_billing_time

date

billing_info_outstanding_balance_currency_code

string

billing_info_outstanding_balance_value

string

create_time

date

custom_id

string

plan_id

string

plan_overridden

boolean

quantity

string

shipping_amount_currency_code

string

shipping_amount_value

string

start_time

date

status

string

status_change_note

string

status_update_time

date

subscriber_email_address

string

subscriber_name_given_name

string

subscriber_name_surname

string

subscriber_payer_id

string

subscriber_shipping_address_address_address_line_1

string

subscriber_shipping_address_address_address_line_2

string

subscriber_shipping_address_address_admin_area_1

string

subscriber_shipping_address_address_admin_area_2

string

subscriber_shipping_address_address_postal_code

string

subscriber_shipping_address_address_country_code

string

subscriber_shipping_address_email_address

string

subscriber_shipping_address_name_full_name

string

subscriber_shipping_address_phone_number_country_code

string

subscriber_shipping_address_phone_number_national_number

string

subscriber_shipping_address_type

string

subscriber_tenant

string

update_time

date

_weld_synced

date

subscription_cycle_execution

subscription_id

string

index

int

current_pricing_scheme_version

int

cycles_completed

int

cycles_remaining

int

sequence

int

tenure_type

string

total_cycles

int

_weld_synced

date

subscription_history

string

billing_info_current_cycle_sequence

int

billing_info_failed_payments_count

int

billing_info_final_payment_time

date

billing_info_last_failed_payment_amount_currency_code

string

billing_info_last_failed_payment_amount_value

string

billing_info_last_failed_payment_next_payment_retry_time

date

billing_info_last_failed_payment_reason_code

string

billing_info_last_failed_payment_time

date

billing_info_last_payment_amount_currency_code

string

billing_info_last_payment_amount_value

string

billing_info_last_payment_status

string

billing_info_last_payment_time

date

billing_info_next_billing_time

date

billing_info_outstanding_balance_currency_code

string

billing_info_outstanding_balance_value

string

create_time

date

custom_id

string

plan_id

string

plan_overridden

boolean

quantity

string

shipping_amount_currency_code

string

shipping_amount_value

string

start_time

date

status

string

status_change_note

string

status_update_time

date

subscriber_email_address

string

subscriber_name_given_name

string

subscriber_name_surname

string

subscriber_payer_id

string

subscriber_shipping_address_address_address_line_1

string

subscriber_shipping_address_address_address_line_2

string

subscriber_shipping_address_address_admin_area_1

string

subscriber_shipping_address_address_admin_area_2

string

subscriber_shipping_address_address_postal_code

string

subscriber_shipping_address_address_country_code

string

subscriber_shipping_address_email_address

string

subscriber_shipping_address_name_full_name

string

subscriber_shipping_address_phone_number_country_code

string

subscriber_shipping_address_phone_number_national_number

string

subscriber_shipping_address_type

string

subscriber_tenant

string

update_time

date

_weld_synced

date

transaction

string

event_code

string

account_number

string

auction_info_auction_buyer_id

string

auction_info_auction_closing_date

date

auction_info_auction_item_site

string

auction_info_auction_site

string

cart_info_paypal_invoice_id

string

cart_info_tax_inclusive

boolean

last_refreshed_datetime

date

payer_info_account_id

string

payer_info_address_city

string

payer_info_address_country_code

string

payer_info_address_line1

string

payer_info_address_line2

string

payer_info_address_postal_code

string

payer_info_address_state

string

payer_info_address_status

string

payer_info_country_code

string

payer_info_email_address

string

payer_info_payer_name_alternate_full_name

string

payer_info_payer_name_full_name

string

payer_info_payer_name_given_name

string

payer_info_payer_name_middle_name

string

payer_info_payer_name_prefix

string

payer_info_payer_name_suffix

string

payer_info_payer_name_surname

string

payer_info_payer_status

string

payer_info_phone_number_country_code

string

payer_info_phone_number_extension_number

string

payer_info_phone_number_national_number

string

shipping_info_address_city

string

shipping_info_address_country_code

string

shipping_info_address_line1

string

shipping_info_address_line2

string

shipping_info_address_postal_code

string

shipping_info_address_state

string

shipping_info_method

string

shipping_info_name

string

shipping_info_secondary_shipping_address_city

string

shipping_info_secondary_shipping_address_country_code

string

shipping_info_secondary_shipping_address_line1

string

shipping_info_secondary_shipping_address_line2

string

shipping_info_secondary_shipping_address_postal_code

string

shipping_info_secondary_shipping_address_state

string

store_info_store_id

string

store_info_terminal_id

string

transaction_info_annual_percentage_rate

string

transaction_info_available_balance_currency_code

string

transaction_info_available_balance_value

string

transaction_info_bank_reference_id

string

transaction_info_credit_promotional_fee_currency_code

string

transaction_info_credit_promotional_fee_value

string

transaction_info_credit_term

string

transaction_info_credit_transactional_fee_currency_code

string

transaction_info_credit_transactional_fee_value

string

transaction_info_custom_field

string

transaction_info_discount_amount_currency_code

string

transaction_info_discount_amount_value

string

transaction_info_ending_balance_currency_code

string

transaction_info_ending_balance_value

string

transaction_info_fee_amount_currency_code

string

transaction_info_fee_amount_value

string

transaction_info_instrument_sub_type

string

transaction_info_instrument_type

string

transaction_info_insurance_amount_currency_code

string

transaction_info_insurance_amount_value

string

transaction_info_invoice_id

string

transaction_info_other_amount_currency_code

string

transaction_info_other_amount_value

string

transaction_info_payment_method_type

string

transaction_info_payment_tracking_id

string

transaction_info_paypal_account_id

string

transaction_info_paypal_reference_id

string

transaction_info_paypal_reference_id_type

string

transaction_info_protection_eligibility

string

transaction_info_sales_tax_amount_currency_code

string

transaction_info_sales_tax_amount_value

string

transaction_info_shipping_amount_currency_code

string

transaction_info_shipping_amount_value

string

transaction_info_shipping_discount_amount_currency_code

string

transaction_info_shipping_discount_amount_value

string

transaction_info_shipping_tax_amount_currency_code

string

transaction_info_shipping_tax_amount_value

string

transaction_info_tip_amount_currency_code

string

transaction_info_tip_amount_value

string

transaction_info_transaction_amount_currency_code

string

transaction_info_transaction_amount_value

string

transaction_info_transaction_initiation_date

date

transaction_info_transaction_note

string

transaction_info_transaction_status

string

transaction_info_transaction_subject

string

transaction_info_transaction_updated_date

date

_weld_synced

date

transaction_item_detail

transaction_id

string

transaction_event_code

string

index

int

adjustment_amount_currency_code

string

adjustment_amount_value

string

basic_shipping_amount_currency_code

string

basic_shipping_amount_value

string

discount_amount_currency_code

string

discount_amount_value

string

extra_shipping_amount_currency_code

string

extra_shipping_amount_value

string

gift_wrap_amount_currency_code

string

gift_wrap_amount_value

string

handling_amount_currency_code

string

handling_amount_value

string

insurance_amount_currency_code

string

insurance_amount_value

string

invoice_number

string

item_amount_currency_code

string

item_amount_value

string

item_code

string

item_description

string

item_name

string

item_options

string

item_quantity

string

item_unit_price_currency_code

string

item_unit_price_value

string

tax_percentage

string

total_item_amount_currency_code

string

total_item_amount_value

string

_weld_synced

date

transaction_item_tax_amount

transaction_id

string

transaction_event_code

string

transaction_item_detail_index

int

index

int

tax_amount_currency_code

string

tax_amount_value

string

_weld_synced

date

transaction_item_checkout_option

transaction_id

string

transaction_event_code

string

transaction_item_detail_index

int

index

int

checkout_option_name

string

checkout_option_value

string

_weld_synced

date

transaction_incentive

transaction_id

string

index

int

transaction_event_code

string

incentive_amount_currency_code

string

incentive_amount_value

string

incentive_code

string

incentive_program_code

string

incentive_type

string

_weld_synced

date

balance

account_id

string

currency

string

as_of_time

date

available_balance_currency_code

string

available_balance_value

string

last_refresh_time

date

primary

boolean

total_balance_currency_code

string

total_balance_value

string

withheld_balance_currency_code

string

withheld_balance_value

string

_weld_synced

date

balance_history

account_id

string

currency

string

as_of_time

date

available_balance_currency_code

string

available_balance_value

string

last_refresh_time

date

primary

boolean

total_balance_currency_code

string

total_balance_value

string

withheld_balance_currency_code

string

withheld_balance_value

string

_weld_synced

date

Table

Sub table