Column

Explore the interactive ERD

Table & Field Reference

business_detail_beneficial_owner

Column	Type	Keys
`index`	Unknown	PK
`business_detail_id`	Unknown	PKFK
`address_city`	Unknown
`address_country_code`	Unknown
`address_line_1`	Unknown
`address_line_2`	Unknown
`address_postal_code`	Unknown
`address_state`	Unknown
`date_of_birth`	Unknown
`drivers_license`	Unknown
`email`	Unknown
`first_name`	Unknown
`last_name`	Unknown
`middle_name`	Unknown
`national_id`	Unknown
`passport`	Json
`ssn`	Unknown

business_detail

Column	Type	Keys
`id`	Unknown	PKFK
`address_city`	Unknown
`address_country_code`	Unknown
`address_line_1`	Unknown
`address_line_2`	Unknown
`address_postal_code`	Unknown
`address_state`	Unknown
`business_name`	Unknown
`ein`	Unknown
`industry`	Unknown
`legal_type`	Unknown
`registration_id_country_code`	Unknown
`registration_id_number`	Unknown
`website`	Unknown

payment

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown	FK
`bank_account_id`	Unknown	FK
`loan_id`	Unknown	FK
`created_at`	Unknown
`currency`	Unknown
`description`	Unknown
`principal_amount`	Unknown
`status`	Unknown

event

Column	Type	Keys
`id`	Unknown	PK
`created_at`	Unknown
`data`	Json
`type`	Unknown

counter_party

Column	Type	Keys
`id`	Unknown	PK
`local_account_number`	Unknown	FK
`account_number`	Unknown
`account_type`	Unknown
`address_city`	Unknown
`address_country_code`	Unknown
`address_line_1`	Unknown
`address_line_2`	Unknown
`address_postal_code`	Unknown
`address_state`	Unknown
`beneficiary_address_city`	Unknown
`beneficiary_address_country_code`	Unknown
`beneficiary_address_line_1`	Unknown
`beneficiary_address_line_2`	Unknown
`beneficiary_address_postal_code`	Unknown
`beneficiary_address_state`	Unknown
`created_at`	Unknown
`description`	Unknown
`email`	Unknown
`is_column_account`	Unknown
`legal_id`	Unknown
`legal_type`	Unknown
`local_bank_code`	Unknown
`local_bank_country_code`	Unknown
`local_bank_name`	Unknown
`name`	Unknown
`phone`	Unknown
`routing_number`	Unknown
`routing_number_type`	Unknown
`updated_at`	Unknown
`wire_beneficiary_email`	Unknown
`wire_beneficiary_legal_id`	Unknown
`wire_beneficiary_name`	Unknown
`wire_beneficiary_phone`	Unknown
`wire_beneficiary_type`	Unknown
`wire_drawdown_allowed`	Unknown
`wire_local_account_number`	Unknown
`wire_local_bank_code`	Unknown

disbursement

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown	FK
`bank_account_id`	Unknown	FK
`loan_id`	Unknown	FK
`amount`	Unknown
`created_at`	Unknown
`currency`	Unknown
`description`	Unknown
`effective_at`	Unknown
`status`	Unknown

account

Column	Type	Keys
`id`	Unknown	PK
`bank_account_id`	Unknown	FK
`account_number`	Unknown
`created_at`	Unknown
`description`	Unknown
`routing_number`	Unknown

loan

Column	Type	Keys
`id`	Unknown	PK
`primary_signer_entity_id`	Unknown	FK
`balances_principal_charged_off`	Unknown
`balances_principal_holding`	Unknown
`balances_principal_outstanding`	Unknown
`balances_principal_paid`	Unknown
`canceled_at`	Unknown
`charged_off_at`	Unknown
`created_at`	Unknown
`currency`	Unknown
`delinquent_at`	Unknown
`description`	Unknown
`disputed_at`	Unknown
`is_revolving`	Unknown
`maturity_date`	Unknown
`max_principal_balance`	Unknown
`paid_off_at`	Unknown
`status`	Unknown

entity

Column	Type	Keys
`id`	Unknown	PK
`document`	Json
`is_root`	Unknown
`name`	Unknown
`review_reason`	Json
`type`	Unknown
`verification_status`	Unknown

book_transfer

Column	Type	Keys
`id`	Unknown	PK
`receiver_account_id`	Unknown	FK
`receiver_bank_account_id`	Unknown	FK
`sender_account_id`	Unknown	FK
`sender_bank_account_id`	Unknown	FK
`allow_overdraft`	Unknown
`amount`	Unknown
`created_at`	Unknown
`currency_code`	Unknown
`description`	Unknown
`idempotency_key`	Unknown
`status`	Unknown
`updated_at`	Unknown

transfer

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown	FK
`counterparty_id`	Unknown	FK
`sender_bank_account_id`	Unknown	FK
`amount`	Unknown
`completed_at`	Unknown
`created_at`	Unknown
`currency_code`	Unknown
`description`	Unknown
`external_source_bank_name`	Unknown
`external_source_sender_name`	Unknown
`idempotency_key`	Unknown
`is_incoming`	Unknown
`receiver_internal_account_account_number_id`	Unknown
`receiver_internal_account_bank_account_id`	Unknown
`sender_account_id`	Unknown
`status`	Unknown
`type`	Unknown
`updated_at`	Unknown

wire_draw_down

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown	FK
`bank_account_id`	Unknown	FK
`amount`	Unknown
`beneficiary_account_number`	Unknown
`beneficiary_counterparty_id`	Unknown
`beneficiary_name`	Unknown
`currency_code`	Unknown
`imad`	Unknown
`is_incoming`	Unknown
`message_identifier`	Unknown
`originator_account_number`	Unknown
`originator_name`	Unknown
`originator_to_beneficiary_information`	Unknown
`received_at`	Unknown
`receiver_di_name`	Unknown
`receiver_di_routing_number`	Unknown
`sender_di_name`	Unknown
`sender_di_routing_number`	Unknown
`status`	Unknown
`wire_transfer_id`	Unknown

ach_return_detail

Column	Type	Keys
`_fivetran_id`	String	PK
`ach_return_id`	Unknown	FK
`addenda`	Unknown
`created_at`	Unknown
`description`	Unknown
`return_code`	Unknown
`status`	Unknown
`updated_at`	Unknown

ach_return

Column	Type	Keys
`id`	Unknown	PK
`ach_transfer_id`	Unknown	FK
`created_at`	Unknown
`is_incoming`	Unknown
`status`	Unknown
`updated_at`	Unknown

international_wire_charge

Column	Type	Keys
`_fivetran_id`	String	PK
`international_wire_id`	Unknown	FK
`agent`	Unknown
`amount`	Unknown
`currency_code`	Unknown

international_wire

Column	Type	Keys
`id`	Unknown	PK
`account_number_id`	Unknown	FK
`bank_account_id`	Unknown	FK
`account_id`	Unknown
`allow_overdraft`	Unknown
`amount`	Unknown
`beneficiary_account_number`	Unknown
`beneficiary_address_city`	Unknown
`beneficiary_address_country_code`	Unknown
`beneficiary_address_line_1`	Unknown
`beneficiary_address_line_2`	Unknown
`beneficiary_address_postal_code`	Unknown
`beneficiary_address_state`	Unknown
`beneficiary_fi`	Unknown
`beneficiary_name`	Unknown
`charge_bearer`	Unknown
`charges`	Json
`completed_at`	Unknown
`counterparty_id`	Unknown
`created_at`	Unknown
`currency_code`	Unknown
`description`	Unknown
`end_to_end_id`	Unknown
`fx_quota_id`	Unknown
`fx_rate`	Unknown
`idempotency_key`	Unknown
`initiated_at`	Unknown
`instructed_amount`	Unknown
`instructed_currency_code`	Unknown
`instruction_id`	Unknown
`instruction_to_beneficiary_fi`	Unknown
`is_incoming`	Unknown
`manual_review_at`	Unknown
`originator_account_number`	Unknown
`originator_address_city`	Unknown
`originator_address_country_code`	Unknown
`originator_address_line_1`	Unknown
`originator_address_line_2`	Unknown
`originator_address_postal_code`	Unknown
`originator_address_state`	Unknown
`originator_fi`	Unknown
`originator_name`	Unknown
`pending_submission_at`	Unknown
`raw_message`	Unknown
`remittance_info_general_info`	Unknown
`return_reason`	Unknown
`returned_amount`	Unknown
`returned_at`	Unknown
`returned_currency_code`	Unknown
`settled_amount`	Unknown
`settled_currency_code`	Unknown
`settlement_date`	Unknown
`status`	Unknown
`submitted_at`	Unknown
`uetr`	Unknown
`ultimate_beneficiary_address`	Unknown
`ultimate_beneficiary_name`	Unknown
`ultimate_originator_address`	Unknown
`ultimate_originator_name`	Unknown
`updated_at`	Unknown

ach_transfer

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown	FK
`bank_account_id`	Unknown	FK
`counterparty_id`	Unknown	FK
`acknowledged_at`	Unknown
`allow_overdraft`	Unknown
`amount`	Unknown
`cancelled_at`	Unknown
`company_discretionary_data`	Unknown
`company_entry_description`	Unknown
`company_id`	Unknown
`company_name`	Unknown
`completed_at`	Unknown
`created_at`	Unknown
`currency_code`	Unknown
`description`	Unknown
`effective_on`	Unknown
`entry_class_code`	Unknown
`iat_foreign_correspondent_bank_info`	Json
`iat_foreign_payment_amount`	Unknown
`iat_foreign_trace_number`	Unknown
`iat_odfi_branch_country_code`	Unknown
`iat_odfi_identification`	Unknown
`iat_odfi_identification_number_qualifier`	Unknown
`iat_odfi_name`	Unknown
`iat_originator_city_state_province`	Unknown
`iat_originator_country_postal_code`	Unknown
`iat_originator_name`	Unknown
`iat_originator_street_address`	Unknown
`iat_payment_related_info`	Unknown
`iat_rdfi_branch_country_code`	Unknown
`iat_rdfi_identification`	Unknown
`iat_rdfi_identification_number_qualifier`	Unknown
`iat_rdfi_name`	Unknown
`iat_receiver_city_state_province`	Unknown
`iat_receiver_country_postal_code`	Unknown
`iat_receiver_identification_number`	Unknown
`iat_receiver_street_address`	Unknown
`iat_receiving_company_or_individual_name`	Unknown
`iat_transaction_type_code`	Unknown
`idempotency_key`	Unknown
`initiated_at`	Unknown
`intermediary_financial_institutions`	Unknown
`is_incoming`	Unknown
`is_on_us`	Unknown
`manual_review_at`	Unknown
`notification_of_changes`	Unknown
`nsf_deadline`	Unknown
`odfi_routing_number`	Unknown
`payment_related_info`	Unknown
`receiver_id`	Unknown
`receiver_name`	Unknown
`return_contested_at`	Unknown
`return_detail`	Json
`return_dishonored_at`	Unknown
`returned_at`	Unknown
`reversal_pair_transfer_id`	Unknown
`same_day`	Unknown
`settled_at`	Unknown
`status`	Unknown
`submitted_at`	Unknown
`trace_number`	Unknown
`type`	Unknown
`ultimate_beneficiary_counterparty_id`	Unknown
`ultimate_originator_counterparty_id`	Unknown
`updated_at`	Unknown

check_return

Column	Type	Keys
`id`	Unknown	PK
`check_transfer_id`	Unknown	FK
`created_at`	Unknown
`return_reason`	Unknown
`status`	Unknown
`updated_at`	Unknown

check_transfer

Column	Type	Keys
`id`	Unknown	PK
`account_number_id`	Unknown	FK
`bank_account_id`	Unknown	FK
`account_id`	Unknown
`back_image`	Unknown
`check_number`	Unknown
`created_at`	Unknown
`currency_code`	Unknown
`delivered_by_column`	Unknown
`delivery_status`	Unknown
`deposited_amount`	Unknown
`deposited_at`	Unknown
`description`	Unknown
`external_routing_number`	Unknown
`first_return_at`	Unknown
`front_image`	Unknown
`idempotency_key`	Unknown
`is_preview_pdf_available`	Unknown
`issued_at`	Unknown
`manual_review_at`	Unknown
`memo`	Unknown
`message`	Unknown
`micr_line_amount_field`	Unknown
`micr_line_auxiliary_on_us`	Unknown
`micr_line_external_processing_code`	Unknown
`micr_line_on_us`	Unknown
`micr_line_payor_bank_routing_number`	Unknown
`payee_address`	Unknown
`payee_name`	Unknown
`pending_deposit_at`	Unknown
`pending_first_return_at`	Unknown
`pending_stop_at`	Unknown
`pending_user_initiated_return_at`	Unknown
`positive_pay_amount`	Unknown
`reclear_at`	Unknown
`rejected_at`	Unknown
`second_return_at`	Unknown
`settled_at`	Unknown
`status`	Unknown
`stopped_at`	Unknown
`type`	Unknown
`updated_at`	Unknown
`user_initiated_return_dishonored_at`	Unknown
`user_initiated_return_submitted_at`	Unknown
`user_initiated_returned_at`	Unknown

person_detail

Column	Type	Keys
`id`	Unknown	PKFK
`address_city`	Unknown
`address_country_code`	Unknown
`address_line_1`	Unknown
`address_line_2`	Unknown
`address_postal_code`	Unknown
`address_state`	Unknown
`date_of_birth`	Unknown
`email`	Unknown
`first_name`	Unknown
`last_name`	Unknown
`middle_name`	Unknown
`passport`	Json
`ssn`	Unknown

bank_account_owner

Column	Type	Keys
`bank_account_id`	Unknown	PKFK
`owner_id`	Unknown	PKFK

bank_account

Column	Type	Keys
`id`	Unknown	PK
`default_account_id`	Unknown	FK
`balances_available_amount`	Unknown
`balances_holding_amount`	Unknown
`balances_locked_amount`	Unknown
`balances_pending_amount`	Unknown
`created_at`	Unknown
`currency_code`	Unknown
`default_account_number`	Unknown
`description`	Unknown
`is_overdraftable`	Unknown
`overdraft_reserve_account_id`	Unknown
`type`	Unknown

wire_transfer

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown	FK
`bank_account_id`	Unknown	FK
`counterparty_id`	Unknown	FK
`allow_overdraft`	Unknown
`amount`	Unknown
`completed_at`	Unknown
`created_at`	Unknown
`currency_code`	Unknown
`description`	Unknown
`idempotency_key`	Unknown
`initiated_at`	Unknown
`is_incoming`	Unknown
`is_on_us`	Unknown
`pending_submission_at`	Unknown
`platform_id`	Unknown
`rejected_at`	Unknown
`status`	Unknown
`submitted_at`	Unknown
`updated_at`	Unknown
`wire_drawdown_request_id`	Unknown