# Brex schema ERD

Table and field reference for the Fivetran Brex connector.

## Table & Field Reference

### card_transaction_metadata

| Column | Type | Keys |
| --- | --- | --- |
| custom_name | Unknown | PK |
| primary_card_account_transaction_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| issue_date | Unknown |  |

### trips_booking_journey

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| trips_booking_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 |  |

## Relationships

- card_transaction_metadata(primary_card_account_transaction_id) → primary_card_account_transaction(id)
- primary_card_account_transaction(card_id) → card(id)
- cash_account_statement(cash_account_id) → cash_account(id)
- cash_account_transaction(transfer_id) → transfer(id)
- vendor_payment_account(vendor_id) → vendor(id)
- trips_booking_ticket(trips_booking_id) → trips_booking(id)
- trips_booking_journey(trips_booking_id) → trips_booking(id)
- user_metadata(users_id) → users(id)
- users(manager_id) → users(id)
- users(department_id) → department(id)
- users(location_id) → location(id)
- referral_account(referral_id) → referral(id)
- transfer(creator_id) → users(id)
- transfer(counterparty_id) → vendor(id)
- transfer(counterparty_payment_instrument_id) → vendor_payment_account(payment_instrument_id)
- transfer(counterparty_deposit_account_id) → referral_account(id)
- transfer(counterparty_account_number) → referral_account(international_swift_account_number)
- transfer(originating_account_id) → referral_account(id)
- trips(booker_user_id) → users(id)
- trips(traveler_user_id) → users(id)
- card_metadata(card_id) → card(id)
- card(owner_user_id) → users(id)
- expense_reviewer(id) → users(id)
- expense_reviewer(department_id) → department(id)
- expense_reviewer(location_id) → location(id)
- expense_reviewer(expense_id) → expense(id)
- expense_custom_field(expense_id) → expense(id)
- expense(user_id) → users(id)
- expense(department_id) → department(id)
- expense(location_id) → location(id)
- expense(payment_instrument_id) → vendor_payment_account(payment_instrument_id)