# Navan schema ERD

Table and field reference for the Fivetran Navan connector.

## Table & Field Reference

### booking_eticket

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| booking_uuid | Unknown | PK, FK |
| eticket | Unknown |  |

### booking_passenger_hr_attribute_value

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| booking_passenger_index | Unknown | PK, FK |
| booking_uuid | Unknown | PK, FK |
| name | Unknown |  |
| response_label | Unknown |  |

### booking_passenger

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| booking_uuid | Unknown | PK, FK |
| passport_country_of_citizenship | Unknown |  |
| passport_country_of_issue | Unknown |  |
| passport_expires_on | Unknown |  |
| passport_issued_on | Unknown |  |
| person_billable_entity | Unknown |  |
| person_cost_center | Unknown |  |
| person_department | Unknown |  |
| person_email | Unknown |  |
| person_employeed_id | Unknown |  |
| person_manager_email | Unknown |  |
| person_manager_name | Unknown |  |
| person_manager_uuid | Unknown |  |
| person_name | Unknown |  |
| person_region | Unknown |  |
| person_subsidiary | Unknown |  |
| person_uuid | Unknown |  |
| status | Unknown |  |
| traveler_type | Unknown |  |

### booking_segment

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| booking_uuid | Unknown | PK, FK |
| airline_alliance | Unknown |  |
| arrival_address | Unknown |  |
| arrival_airport_code | Unknown |  |
| arrival_city | Unknown |  |
| arrival_country | Unknown |  |
| arrival_postal_code | Unknown |  |
| arrival_state | Unknown |  |
| cabin | Unknown |  |
| cabin_purchased | Unknown |  |
| departure_address | Unknown |  |
| departure_airport_code | Unknown |  |
| departure_city | Unknown |  |
| departure_country | Unknown |  |
| departure_postal_code | Unknown |  |
| departure_state | Unknown |  |
| end_local_date_time | Unknown |  |
| end_timestamp | Unknown |  |
| fare_class | Unknown |  |
| flight_number | Unknown |  |
| hotel_chain | Unknown |  |
| hotel_super_chain | Unknown |  |
| provider_code | Unknown |  |
| provider_name | Unknown |  |
| start_local_date_time | Unknown |  |
| start_timestamp | Unknown |  |

### booking_trip_uuid

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| booking_uuid | Unknown | PK, FK |
| trip_uuid | Unknown |  |

### booking_cost_center

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| booking_uuid | Unknown | PK, FK |
| cost_center | Unknown |  |

### booking_department

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| booking_uuid | Unknown | PK, FK |
| department | Unknown |  |

### booking_billable_entity

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| booking_uuid | Unknown | PK, FK |
| billable_entity | Unknown |  |

### booking_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| booking_uuid | Unknown | PK, FK |
| name | Unknown |  |
| value | Unknown |  |

### booking_region

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| booking_uuid | Unknown | PK, FK |
| region | Unknown |  |

### booking_subsidiary

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| booking_uuid | Unknown | PK, FK |
| subsidiary | Unknown |  |

### booking_credit

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| booking_uuid | Unknown | PK, FK |
| credit_available | Double |  |
| credit_available_usd | Double |  |
| credit_exchange_fee_usd | Double |  |
| credit_from_original_booking | Unknown |  |
| credit_used | Double |  |
| credit_used_usd | Double |  |
| residual_credit | Double |  |

### booking_reshopping

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| booking_uuid | Unknown | PK, FK |
| reshopping_is_rebooked | Unknown |  |
| reshopping_new_price | Double |  |
| reshopping_new_ticket_number | Unknown |  |
| reshopping_original_price | Double |  |
| reshopping_original_ticket_number | Unknown |  |

### booking_destination

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| booking_uuid | Unknown | PK, FK |
| address | Unknown |  |
| airport_code | Unknown |  |
| city | Unknown |  |
| country | Unknown |  |
| postal_code | Unknown |  |
| state | Unknown |  |

### booking_booker_hr_attribute_value

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| booking_booker_index | Unknown | PK, FK |
| booking_uuid | Unknown | PK, FK |
| name | Unknown |  |
| response_label | Unknown |  |

### booking_booker

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| booking_uuid | Unknown | PK, FK |
| uuid | Unknown | FK |
| billable_entity | Unknown |  |
| cost_center | Unknown |  |
| department | Unknown |  |
| email | Unknown |  |
| employeed_id | Unknown |  |
| manager_email | Unknown |  |
| manager_name | Unknown |  |
| manager_uuid | Unknown |  |
| name | Unknown |  |
| passport | Unknown |  |
| region | Unknown |  |
| subsidiary | Unknown |  |

### booking_origin

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| booking_uuid | Unknown | PK, FK |
| address | Unknown |  |
| airport_code | Unknown |  |
| city | Unknown |  |
| country | Unknown |  |
| postal_code | Unknown |  |
| state | Unknown |  |

### booking_seat

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| booking_uuid | Unknown | PK, FK |
| seat | Unknown |  |

### booking_out_of_policy_violation_type

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| booking_uuid | Unknown | PK, FK |
| out_of_policy_violation_type | Unknown |  |

### booking_price_benchmark

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| booking_uuid | Unknown | PK, FK |
| transaction_id | Unknown | FK |
| details | Unknown |  |
| median_price | Unknown |  |
| price | Unknown |  |
| route | Unknown |  |
| route_type | Unknown |  |

### booking

| Column | Type | Keys |
| --- | --- | --- |
| uuid | Unknown | PK |
| airline_credit_card_surcharge | Double |  |
| airline_route | Unknown |  |
| approval_changed_at | Unknown |  |
| approval_status | Unknown |  |
| approver_email | Unknown |  |
| approver_reason | Unknown |  |
| base_price | Double |  |
| bill_to_client | Unknown |  |
| booking_duration | Unknown |  |
| booking_fee | Double |  |
| booking_id | Unknown |  |
| booking_method | Unknown |  |
| booking_status | Unknown |  |
| booking_type | Unknown |  |
| cabin | Unknown |  |
| cabin_purchased | Unknown |  |
| cancellation_reason | Unknown |  |
| cancelled_at | Unknown |  |
| car_type | Unknown |  |
| carbon_emission | Double |  |
| carbon_offset_cost | Double |  |
| cnr_cnr_codes | Json |  |
| cnr_cnr_provider | Json |  |
| cnr_cnr_sources | Json |  |
| cnr_published_price | Double |  |
| company_office | Unknown |  |
| company_payment_method | Unknown |  |
| confirmation_number | Unknown |  |
| corporate_discount_used | Unknown |  |
| created | Unknown |  |
| currency | Unknown |  |
| currency_exhange_rate_from_usd | Double |  |
| domestic | Unknown |  |
| end_date | Unknown |  |
| eticket | Json |  |
| event_name | Unknown |  |
| exchange_amount | Double |  |
| exchange_fee | Double |  |
| expensed | Unknown |  |
| extras_fee | Double |  |
| fare_basis_code | Unknown |  |
| fare_class | Unknown |  |
| flight | Unknown |  |
| flight_mile | Unknown |  |
| flown_cabin_class | Unknown |  |
| grand_total | Double |  |
| gsa_rate | Unknown |  |
| gst | Double |  |
| handling_fee | Double |  |
| hotel_chain | Unknown |  |
| hotel_code | Unknown |  |
| hotel_latitude | Double |  |
| hotel_longitude | Double |  |
| hst | Double |  |
| inventory | Unknown |  |
| inventory_source | Unknown |  |
| invitation_type | Unknown |  |
| invite_connection_method | Unknown |  |
| invoice | Unknown |  |
| invoice_collection_fee | Double |  |
| invoice_number | Unknown |  |
| last_modified | Unknown |  |
| lead_time_in_days | Unknown |  |
| logged_as_user_name | Unknown |  |
| max_cancellation_loss | Double |  |
| max_price_policy | Double |  |
| name_on_credit_card | Unknown |  |
| navan_pro | Unknown |  |
| net_charge | Double |  |
| number_of_passenger | Unknown |  |
| optimal_price | Double |  |
| out_of_policy | Unknown |  |
| out_of_policy_description | Unknown |  |
| out_of_policy_violation | Unknown |  |
| payment_credit_card_type_name | Unknown |  |
| payment_method | Unknown |  |
| payment_method_used | Unknown |  |
| payment_schedule | Unknown |  |
| pcc | Unknown |  |
| pdf | Unknown |  |
| policy_level | Unknown |  |
| ppb_points_burned | Unknown |  |
| preferred_vendor | Unknown |  |
| project | Unknown |  |
| purpose | Unknown |  |
| qst | Double |  |
| reason | Unknown |  |
| resort_fee | Double |  |
| route_type | Unknown |  |
| saving | Double |  |
| saving_missed | Double |  |
| seats_fee | Double |  |
| start_date | Unknown |  |
| statement_description | Unknown |  |
| tax | Double |  |
| train_mile | Unknown |  |
| transaction_fee | Double |  |
| travel_agent_request_fee | Double |  |
| travel_spend | Double |  |
| trip_bucks_earned | Double |  |
| trip_bucks_earned_usd | Double |  |
| trip_description | Unknown |  |
| trip_fee | Double |  |
| trip_length | Unknown |  |
| trip_name | Unknown |  |
| unitary_price | Double |  |
| usd_grand_total | Double |  |
| vat | Double |  |
| vendor | Unknown |  |
| vip_fee | Double |  |

### transaction_line_item

| Column | Type | Keys |
| --- | --- | --- |
| line_item_id | Unknown | PK |
| transaction_id | Unknown | PK, FK |
| cost_center | Unknown |  |
| date | Unknown |  |
| department | Unknown |  |
| description | Unknown |  |
| flag_reasons | Unknown |  |
| flagged | Unknown |  |
| gl_code_name | Unknown |  |
| gl_code_number | Unknown |  |
| name | Unknown |  |
| original_amount | Unknown |  |
| original_currency | Unknown |  |
| personal | Unknown |  |
| policy | Unknown |  |
| policy_added_timestamp | Unknown |  |
| posted_amount | Unknown |  |
| posted_currency | Unknown |  |
| region | Unknown |  |
| subsidiary | Unknown |  |
| custom_** |  |  |

### transaction_tax_line_detail

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| transaction_id | Unknown | PK, FK |
| erp_tax_code | Unknown |  |
| erp_tax_id | Unknown |  |
| net_amount | Unknown |  |
| tax_amount | Unknown |  |
| tax_rate | Unknown |  |
| tax_type | Unknown |  |
| total_amount | Unknown |  |

### transaction

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| accrued_rebate_amount | Unknown |  |
| activity_description | Unknown |  |
| activity_type | Unknown |  |
| approval_status | Unknown |  |
| approved_by_email | Unknown |  |
| approver_type | Unknown |  |
| authorization_date | Unknown |  |
| billable_entity_amount | Unknown |  |
| billable_entity_currency | Unknown |  |
| booker | Unknown |  |
| booking_end_date | Unknown |  |
| booking_start_date | Unknown |  |
| booking_status | Unknown |  |
| card_description | Unknown |  |
| card_program_name | Unknown |  |
| cardholder | Unknown |  |
| cardholder_email | Unknown |  |
| cardholder_employee_id | Unknown |  |
| country_of_transaction | Unknown |  |
| department | Unknown |  |
| detail_type | Unknown |  |
| direct_reimbursement_fee_amount | Unknown |  |
| distance_amount | Unknown |  |
| distance_unit | Unknown |  |
| ereceipt | Unknown |  |
| ereceipt_navan | Unknown |  |
| erp_effective_date | Unknown |  |
| erp_sync_status | Unknown |  |
| eticket | Unknown |  |
| exchange_rate | Unknown |  |
| fee | Unknown |  |
| flag_reason | Unknown |  |
| flag_status | Unknown |  |
| flagged | Unknown |  |
| flight_cabin | Unknown |  |
| flight_destination_airport | Unknown |  |
| flight_mile | Unknown |  |
| flight_origin_airport | Unknown |  |
| fx_fee_amount | Unknown |  |
| gl_code_name | Unknown |  |
| gl_code_number | Unknown |  |
| hotel_name | Unknown |  |
| invoice_date | Unknown |  |
| invoice_number | Unknown |  |
| itemized | Unknown |  |
| last_approver_action_date | Unknown |  |
| legal_entity | Unknown |  |
| manually_added_date | Unknown |  |
| merchant_address | Unknown |  |
| merchant_category | Unknown |  |
| merchant_name | Unknown |  |
| modified_timestamp | Unknown |  |
| navan_booking_id | Unknown |  |
| navan_booking_uuid | Unknown |  |
| original_amount | Unknown |  |
| original_currency | Unknown |  |
| participant | Unknown |  |
| personal | Unknown |  |
| personal_amount | Unknown |  |
| policy | Unknown |  |
| policy_category | Unknown |  |
| posted_amount | Unknown |  |
| posted_currency | Unknown |  |
| posted_date | Unknown |  |
| posted_date_time | Unknown |  |
| rebate_type | Unknown |  |
| receipt | Unknown |  |
| receipt_navan | Unknown |  |
| region | Unknown |  |
| reimbursement_amount | Unknown |  |
| reimbursement_currency | Unknown |  |
| reimbursement_date | Unknown |  |
| reimbursement_exchange_rate | Unknown |  |
| reimbursement_method | Unknown |  |
| rejected_amount | Unknown |  |
| related_traveler | Unknown |  |
| repaid_transaction_id | Unknown |  |
| reporting_transaction_id | Unknown |  |
| reverse_charge | Unknown |  |
| source_id | Unknown |  |
| statement_id | Unknown |  |
| subsidiary | Unknown |  |
| taxable_benefit | Unknown |  |
| train_mile | Unknown |  |
| transaction_costcenter | Unknown |  |
| transaction_date | Unknown |  |
| transaction_description | Unknown |  |
| transaction_type | Unknown |  |
| travelers_cost_center | Unknown |  |
| travelers_department | Unknown |  |
| travelers_employee_id | Unknown |  |
| travelers_region | Unknown |  |
| travelers_subsidiary | Unknown |  |
| trip_name | Unknown |  |
| trip_purpose | Unknown |  |
| trip_uuid | Unknown |  |
| vat_number | Unknown |  |
| custom_** |  |  |

## Relationships

- booking_eticket(booking_uuid) → booking(uuid)
- booking_passenger_hr_attribute_value(booking_passenger_index) → booking_passenger(index)
- booking_passenger_hr_attribute_value(booking_uuid) → booking_passenger(booking_uuid)
- booking_passenger(booking_uuid) → booking(uuid)
- booking_segment(booking_uuid) → booking(uuid)
- booking_trip_uuid(booking_uuid) → booking(uuid)
- booking_cost_center(booking_uuid) → booking(uuid)
- booking_department(booking_uuid) → booking(uuid)
- booking_billable_entity(booking_uuid) → booking(uuid)
- booking_custom_field(booking_uuid) → booking(uuid)
- booking_region(booking_uuid) → booking(uuid)
- booking_subsidiary(booking_uuid) → booking(uuid)
- booking_credit(booking_uuid) → booking(uuid)
- booking_reshopping(booking_uuid) → booking(uuid)
- booking_destination(booking_uuid) → booking(uuid)
- booking_booker_hr_attribute_value(booking_booker_index) → booking_booker(index)
- booking_booker_hr_attribute_value(booking_uuid) → booking_booker(booking_uuid)
- booking_booker(uuid) → booking_passenger(person_uuid)
- booking_booker(booking_uuid) → booking(uuid)
- booking_origin(booking_uuid) → booking(uuid)
- booking_seat(booking_uuid) → booking(uuid)
- booking_out_of_policy_violation_type(booking_uuid) → booking(uuid)
- booking_price_benchmark(transaction_id) → transaction(id)
- booking_price_benchmark(booking_uuid) → booking(uuid)
- transaction_line_item(transaction_id) → transaction(id)
- transaction_tax_line_detail(transaction_id) → transaction(id)