Brex

Explore the interactive ERD

Table & Field Reference

card_transaction_metadata

Column	Type	Keys
`custom_name`	Unknown	PK
`primary_card_account_transaction_id`	Unknown	PKFK
`custom_value`	Unknown

primary_card_account_transaction

Column	Type	Keys
`id`	Unknown	PK
`card_id`	Unknown	FK
`amount`	Unknown
`currency`	Unknown
`description`	Unknown
`initiated_at_date`	Unknown
`merchant_category_code`	Unknown
`posted_at_date`	Unknown
`raw_descriptor`	Unknown
`type`	Unknown

cash_account_statement

Column	Type	Keys
`id`	Unknown	PK
`cash_account_id`	Unknown	FK
`end_balance_amount`	Unknown
`end_balance_currency`	Unknown
`period_end_date`	Unknown
`period_start_date`	Unknown
`start_balance_amount`	Unknown
`start_balance_currency`	Unknown

card_account

Column	Type	Keys
`id`	Unknown	PK
`account_limit_amount`	Unknown
`account_limit_currency`	Unknown
`available_balance_amount`	Unknown
`available_balance_currency`	Unknown
`current_balance_amount`	Unknown
`current_balance_currency`	Unknown
`current_statement_end_date`	Unknown
`current_statement_start_date`	Unknown
`status`	Unknown

cash_account_transaction

Column	Type	Keys
`id`	Unknown	PK
`transfer_id`	Unknown	FK
`amount`	Unknown
`currency`	Unknown
`description`	Unknown
`initiated_at_date`	Unknown
`posted_at_date`	Unknown
`type`	Unknown

linked_account

Column	Type	Keys
`id`	Unknown	PK
`available_balance_amount`	Unknown
`available_balance_as_of_date`	Unknown
`available_balance_currency`	Unknown
`bank_details_name`	Unknown
`bank_details_type`	Unknown
`brex_account_id`	Unknown
`current_balance_amount`	Unknown
`current_balance_as_of_date`	Unknown
`current_balance_currency`	Unknown
`last_four`	Unknown

vendor_payment_account

Column	Type	Keys
`payment_instrument_id`	Unknown	PK
`vendor_id`	Unknown	PKFK
`account_class`	Unknown
`account_number`	Unknown
`account_type`	Unknown
`address_city`	Unknown
`address_country`	Unknown
`address_line_1`	Unknown
`address_line_2`	Unknown
`address_phone_number`	Unknown
`address_postal_code`	Unknown
`address_state`	Unknown
`beneficiary_bank_name`	Unknown
`iban`	Unknown
`mailing_city`	Unknown
`mailing_country`	Unknown
`mailing_line_1`	Unknown
`mailing_line_2`	Unknown
`mailing_phone_number`	Unknown
`mailing_postal_code`	Unknown
`mailing_state`	Unknown
`recipient_name`	Unknown
`routing_number`	Unknown
`swift_code`	Unknown
`type`	Unknown

vendor

Column	Type	Keys
`id`	Unknown	PK
`company_name`	Unknown
`email`	Unknown
`phone`	Unknown

trips_booking_ticket

Column	Type	Keys
`number`	Unknown	PK
`trips_booking_id`	Unknown	PKFK
`issue_date`	Unknown

trips_booking_journey

Column	Type	Keys
`index`	Unknown	PK
`trips_booking_id`	Unknown	PKFK
`cabin_display_name`	Unknown
`flight`	Json
`status`	Unknown

trips_booking

Column	Type	Keys
`id`	Unknown	PK
`booking_data_type`	Unknown
`created_at`	Unknown
`known_traveler_number_document_number`	Unknown
`known_traveler_number_issuing_country`	Unknown
`redress_number_document_number`	Unknown
`redress_number_issuing_country`	Unknown
`source`	Unknown
`status`	Unknown
`trip_id`	Unknown
`type`	Unknown
`updated_at`	Unknown
`version`	Unknown

department

Column	Type	Keys
`id`	Unknown	PK
`description`	Unknown
`name`	Unknown

cash_account

Column	Type	Keys
`id`	Unknown	PK
`account_number`	Unknown
`available_balance_amount`	Unknown
`available_balance_currency`	Unknown
`current_balance_amount`	Unknown
`current_balance_currency`	Unknown
`is_primary`	Unknown
`name`	Unknown
`routing_number`	Unknown
`status`	Unknown

primary_card_account_statement

Column	Type	Keys
`id`	Unknown	PK
`end_balance_amount`	Unknown
`end_balance_currency`	Unknown
`period_end_date`	Unknown
`period_start_date`	Unknown
`start_balance_amount`	Unknown
`start_balance_currency`	Unknown

user_metadata

Column	Type	Keys
`custom_name`	Unknown	PK
`users_id`	Unknown	PKFK
`custom_value`	Unknown

users

Column	Type	Keys
`id`	Unknown	PK
`department_id`	Unknown	FK
`location_id`	Unknown	FK
`manager_id`	Unknown	FK
`email`	Unknown
`first_name`	Unknown
`last_name`	Unknown
`status`	Unknown

referral_account

Column	Type	Keys
`id`	Unknown	PK
`referral_id`	Unknown	FK
`application_status`	Unknown
`created_at`	Instant
`domestic_account_type`	Unknown
`domestic_bank_account_number`	Unknown
`domestic_bank_address`	Unknown
`domestic_bank_name`	Unknown
`domestic_bank_routing_number`	Unknown
`domestic_beneficiary_address`	Unknown
`domestic_beneficiary_name`	Unknown
`international_account_type`	Unknown
`international_bank_address`	Unknown
`international_bank_name`	Unknown
`international_beneficiary_address`	Unknown
`international_beneficiary_name`	Unknown
`international_special_instructions`	Unknown
`international_swift_account_number`	Unknown
`international_swift_bank_number`	Unknown

referral

Column	Type	Keys
`id`	Unknown	PK
`customer_email`	Unknown
`expires_at`	Unknown
`referral_signup_url`	Unknown
`status`	Unknown

transfer

Column	Type	Keys
`id`	Unknown	PK
`counterparty_account_number`	Unknown	FK
`counterparty_deposit_account_id`	Unknown	FK
`counterparty_id`	Unknown	FK
`counterparty_payment_instrument_id`	Unknown	FK
`creator_id`	Unknown	FK
`originating_account_id`	Unknown	FK
`amount`	Unknown
`cancellation_reason`	Unknown
`counterparty_external_memo`	Unknown
`counterparty_fed_reference_number`	Unknown
`counterparty_type`	Unknown
`created_at`	Unknown
`currency`	Unknown
`description`	Unknown
`display_name`	Unknown
`estimated_delivery_date`	Unknown
`originating_account_type`	Unknown
`payment_type`	Unknown
`process_date`	Unknown
`status`	Unknown

trips

Column	Type	Keys
`id`	Unknown	PK
`booker_user_id`	Unknown	FK
`traveler_user_id`	Unknown	FK
`billable_at`	Unknown
`created_at`	Unknown
`ends_at`	Unknown
`name`	Unknown
`starts_at`	Unknown
`status`	Unknown
`traveler_guest_email`	Unknown
`traveler_type`	Unknown
`updated_at`	Instant
`version`	Unknown

location

Column	Type	Keys
`id`	Unknown	PK
`description`	Unknown
`name`	Unknown

card_metadata

Column	Type	Keys
`custom_name`	Unknown	PK
`card_id`	Unknown	PKFK
`custom_value`	Unknown

card

Column	Type	Keys
`id`	Unknown	PK
`owner_user_id`	Unknown	FK
`billing_city`	Unknown
`billing_country`	Unknown
`billing_line_1`	Unknown
`billing_line_2`	Unknown
`billing_phone_number`	Unknown
`billing_postal_code`	Unknown
`billing_state`	Unknown
`limit_type`	Unknown
`lock_after_date`	Unknown
`mailing_city`	Unknown
`mailing_country`	Unknown
`mailing_line_1`	Unknown
`mailing_line_2`	Unknown
`mailing_phone_number`	Unknown
`mailing_postal_code`	Unknown
`mailing_state`	Unknown
`name`	Unknown
`owner_type`	Unknown
`reason`	Unknown
`spend_available_amount`	Unknown
`spend_available_currency`	Unknown
`spend_duration`	Unknown
`spend_limit_amount`	Unknown
`spend_limit_currency`	Unknown
`status`	Unknown
`type`	Unknown

expense_reviewer

Column	Type	Keys
`expense_id`	Unknown	PKFK
`id`	Unknown	PKFK
`department_id`	Unknown	FK
`location_id`	Unknown	FK
`first_name`	Unknown
`last_name`	Unknown

expense_custom_field

Column	Type	Keys
`key`	Unknown	PK
`expense_id`	Unknown	PKFK
`data`	Json
`data_type`	Unknown
`value_type`	Unknown

expense

Column	Type	Keys
`id`	Unknown	PK
`department_id`	Unknown	FK
`location_id`	Unknown	FK
`payment_instrument_id`	Unknown	FK
`user_id`	Unknown	FK
`address_city`	Unknown
`address_coordinates_latitude`	Unknown
`address_coordinates_longitude`	Unknown
`address_country`	Unknown
`address_line_1`	Unknown
`address_line_2`	Unknown
`address_postal_code`	Unknown
`address_state`	Unknown
`address_timezone`	Unknown
`approved_at`	Unknown
`billing_amount`	Unknown
`billing_currency`	Unknown
`billing_entity_id`	Unknown
`budget_amount`	Unknown
`budget_currency`	Unknown
`budget_id`	Unknown
`budget_name`	Unknown
`category`	Unknown
`completion_date`	Unknown
`expense_type`	Unknown
`exported_at`	Unknown
`integration_billing_entity_id`	Unknown
`integration_spending_entity_id`	Unknown
`memo`	Unknown
`merchant_country`	Unknown
`merchant_id`	Unknown
`merchant_mcc`	Unknown
`merchant_raw_descriptor`	Unknown
`original_amount`	Unknown
`original_currency`	Unknown
`payment_id`	Unknown
`payment_instrument_type`	Unknown
`payment_posted_at`	Unknown
`payment_status`	Unknown
`purchased_amount`	Unknown
`purchased_at`	Unknown
`purchased_currency`	Unknown
`receipts`	Json
`repayment_initiated_by_department_id`	Unknown
`repayment_initiated_by_first_name`	Unknown
`repayment_initiated_by_id`	Unknown
`repayment_initiated_by_last_name`	Unknown
`repayment_initiated_by_location_id`	Unknown
`repayment_initiation_date`	Unknown
`review_approved_at`	Unknown
`review_approver_department_id`	Unknown
`review_approver_first_name`	Unknown
`review_approver_id`	Unknown
`review_approver_last_name`	Unknown
`review_approver_location_id`	Unknown
`review_compliance_status`	Unknown
`review_copilot_approver_department_id`	Unknown
`review_copilot_approver_first_name`	Unknown
`review_copilot_approver_id`	Unknown
`review_copilot_approver_last_name`	Unknown
`review_copilot_approver_location_id`	Unknown
`reviewer_status`	Unknown
`spending_entity_billing_address_city`	Unknown
`spending_entity_billing_address_country`	Unknown
`spending_entity_billing_address_line_1`	Unknown
`spending_entity_billing_address_line_2`	Unknown
`spending_entity_billing_address_phone_number`	Unknown
`spending_entity_billing_address_postal_code`	Unknown
`spending_entity_billing_address_state`	Unknown
`spending_entity_created_at`	Unknown
`spending_entity_display_name`	Unknown
`spending_entity_id`	Unknown
`spending_entity_is_default`	Unknown
`spending_entity_status`	Unknown
`status`	Unknown
`status_reason`	Unknown
`submitted_at`	Unknown
`trip_id`	Unknown
`updated_at`	Instant
`usd_equivalent_amount`	Unknown
`usd_equivalent_currency`	Unknown