Navan

Explore the interactive ERD

Table & Field Reference

booking_eticket

Column	Type	Keys
`index`	Unknown	PK
`booking_uuid`	Unknown	PKFK
`eticket`	Unknown

booking_passenger_hr_attribute_value

Column	Type	Keys
`index`	Unknown	PK
`booking_passenger_index`	Unknown	PKFK
`booking_uuid`	Unknown	PKFK
`name`	Unknown
`response_label`	Unknown

booking_passenger

Column	Type	Keys
`index`	Unknown	PK
`booking_uuid`	Unknown	PKFK
`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	PKFK
`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	PKFK
`trip_uuid`	Unknown

booking_cost_center

Column	Type	Keys
`index`	Unknown	PK
`booking_uuid`	Unknown	PKFK
`cost_center`	Unknown

booking_department

Column	Type	Keys
`index`	Unknown	PK
`booking_uuid`	Unknown	PKFK
`department`	Unknown

booking_billable_entity

Column	Type	Keys
`index`	Unknown	PK
`booking_uuid`	Unknown	PKFK
`billable_entity`	Unknown

booking_custom_field

Column	Type	Keys
`index`	Unknown	PK
`booking_uuid`	Unknown	PKFK
`name`	Unknown
`value`	Unknown

booking_region

Column	Type	Keys
`index`	Unknown	PK
`booking_uuid`	Unknown	PKFK
`region`	Unknown

booking_subsidiary

Column	Type	Keys
`index`	Unknown	PK
`booking_uuid`	Unknown	PKFK
`subsidiary`	Unknown

booking_credit

Column	Type	Keys
`index`	Unknown	PK
`booking_uuid`	Unknown	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`booking_uuid`	Unknown	PKFK
`name`	Unknown
`response_label`	Unknown

booking_booker

Column	Type	Keys
`index`	Unknown	PK
`booking_uuid`	Unknown	PKFK
`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	PKFK
`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	PKFK
`seat`	Unknown

booking_out_of_policy_violation_type

Column	Type	Keys
`index`	Unknown	PK
`booking_uuid`	Unknown	PKFK
`out_of_policy_violation_type`	Unknown

booking_price_benchmark

Column	Type	Keys
`index`	Unknown	PK
`booking_uuid`	Unknown	PKFK
`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	PKFK
`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	PKFK
`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_`