# SAP Concur schema ERD

Table and field reference for the Fivetran SAP Concur connector.

## Table & Field Reference

### booking

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| trip_id | String | PK |
| agency_name | String |  |
| agency_number | String |  |
| agency_pcc | String |  |
| booking_owner | String |  |
| booking_source | String |  |
| date_booked_local | Instant |  |
| date_created_utc | Instant |  |
| date_modified_utc | Instant |  |
| itin_source_name | String |  |
| last_ticket_date_utc | Instant |  |
| original_itin_locator | Long |  |
| passenger_count | String |  |
| source | String |  |

### charge_fixed

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| segment_index | Int | PK |
| amount | Double |  |
| currency | String |  |
| description | String |  |
| is_paid | Boolean |  |
| is_primary | Boolean |  |
| semantics_code | String |  |
| semantics_vendor_type | String |  |
| start_date_local | Instant |  |
| vendor | String |  |
| vendor_charge_code | String |  |

### dining

| Column | Type | Keys |
| --- | --- | --- |
| booking_id | String | PK |
| index | Int | PK |
| cancellation_number | String |  |
| confirmation_number | String |  |
| date_cancelled_utc | Instant |  |
| date_created_utc | Instant |  |
| date_modified_utc | Instant |  |
| end_date_local | Instant |  |
| end_date_utc | Instant |  |
| frequent_traveler_id | String |  |
| is_preferred_vendor | Int |  |
| is_upgrade_allowed | Boolean |  |
| name | String |  |
| notes | String |  |
| num_persons | String |  |
| phone_number | String |  |
| reservation_id | String |  |
| restaurant_id | String |  |
| start_address | String |  |
| start_address_2 | String |  |
| start_city | String |  |
| start_country | String |  |
| start_date_local | Instant |  |
| start_date_utc | Instant |  |
| start_latitude | Double |  |
| start_longitude | Double |  |
| start_postal_code | String |  |
| start_state | String |  |
| status | String |  |
| time_zone | String |  |
| upgraded_date_time | Instant |  |
| vendor | String |  |
| vendor_flags | String |  |
| vendor_name | String |  |

### entry_attendee_association

| Column | Type | Keys |
| --- | --- | --- |
| attendee_id | String | PK |
| expense_entry_id | String | PK |
| amount | Double |  |
| associated_attendee_count | Int |  |
| id | String |  |

### spend_user_authorized_approver

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| spend_user_id | String | PK, FK |
| approval_group | String |  |
| approval_limit | Double |  |
| approval_type | String |  |
| exception_approval_authority | Boolean |  |
| level | Int |  |
| reimbursement_currency | String |  |

### vendor_status

| Column | Type | Keys |
| --- | --- | --- |
| record_number | Int | PK |
| vendor_code | String | PK, FK |
| code | Int |  |
| message | String |  |
| type | String |  |

### car

| Column | Type | Keys |
| --- | --- | --- |
| booking_id | String | PK |
| index | Int | PK |
| air_condition | String |  |
| body | String |  |
| cancellation_number | String |  |
| class | String |  |
| confirmation_number | String |  |
| credit_card_last_four | String |  |
| credit_card_type | String |  |
| currency | String |  |
| daily_rate | Double |  |
| date_cancelled_utc | Instant |  |
| date_created_utc | Instant |  |
| date_modified_utc | Instant |  |
| discount_code | String |  |
| dropoff_collection_address_1 | String |  |
| dropoff_collection_address_type | String |  |
| dropoff_collection_category | String |  |
| dropoff_collection_city | String |  |
| dropoff_collection_city_code | String |  |
| dropoff_collection_country | String |  |
| dropoff_collection_latitude | Double |  |
| dropoff_collection_longitude | String |  |
| dropoff_collection_number | String |  |
| dropoff_collection_phone_number | String |  |
| dropoff_collection_postal_code | String |  |
| dropoff_collection_state | String |  |
| end_address | String |  |
| end_address_2 | String |  |
| end_city | String |  |
| end_city_code | String |  |
| end_close_time | String |  |
| end_country | String |  |
| end_date_local | Instant |  |
| end_date_utc | Instant |  |
| end_latitude | Double |  |
| end_location | String |  |
| end_longitude | Double |  |
| end_open_time | String |  |
| end_phone_number | String |  |
| end_postal_code | String |  |
| end_statel | String |  |
| frequent_traveler_id | String |  |
| is_ghost_card | Boolean |  |
| is_preferred_vendor | Int |  |
| is_upgrade_allowed | Boolean |  |
| notes | String |  |
| num_cars | Int |  |
| num_persons | Int |  |
| phone_number | String |  |
| pickup_delivery_address_1 | String |  |
| pickup_delivery_address_type | String |  |
| pickup_delivery_category | String |  |
| pickup_delivery_city | String |  |
| pickup_delivery_city_code | String |  |
| pickup_delivery_country | String |  |
| pickup_delivery_latitude | Double |  |
| pickup_delivery_longitude | Double |  |
| pickup_delivery_number | String |  |
| pickup_delivery_phone_number | String |  |
| pickup_delivery_postal_code | String |  |
| pickup_delivery_state | String |  |
| rate_code | String |  |
| rate_type | String |  |
| special_equipment | String |  |
| special_instructions | String |  |
| start_address | String |  |
| start_address_2 | String |  |
| start_city | String |  |
| start_city_code | String |  |
| start_close_time | String |  |
| start_country | String |  |
| start_date_local | Instant |  |
| start_date_utc | Instant |  |
| start_latitude | Double |  |
| start_location | String |  |
| start_longitude | String |  |
| start_open_time | String |  |
| start_postal_code | String |  |
| start_state | String |  |
| status | String |  |
| time_zone | String |  |
| total_rate | Double |  |
| transmission | String |  |
| upgraded_date_time | Instant |  |
| vendor | String |  |
| vendor_flags | String |  |
| vendor_name | String |  |

### travel_request

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| approved | Boolean |  |
| approver_id | String |  |
| approver_status_code | String |  |
| business_purpose | String |  |
| canceled_post_approval | Boolean |  |
| closed | Boolean |  |
| comment | String |  |
| creation_date | Instant |  |
| end_date | Instant |  |
| ever_sent_back | Boolean |  |
| name | String |  |
| owner_id | String |  |
| pending_approval | Boolean |  |
| request_code | String |  |
| start_date | Instant |  |
| start_time | String |  |
| submit_date | Instant |  |
| total_approved_amount_currency | String |  |
| total_approved_amount_value | Double |  |
| total_posted_amount_currency | String |  |
| total_posted_amount_value | Double |  |
| total_remaining_amount_currency | String |  |
| total_remaining_amount_value | Double |  |
| travel_agency_id | String |  |
| type_code | String |  |
| type_label | String |  |

### payment_request

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| payment_request_digest_id | String | FK |
| amount_without_vat | Double |  |
| approval_status | String |  |
| approved_by_delegate | String |  |
| assigned_by_username | String |  |
| assigned_date | Instant |  |
| buyer_cost_center | String |  |
| calculated_amount | Double |  |
| check_number | String |  |
| company_bill_to_address_code | String |  |
| company_ship_to_address_code | String |  |
| country_code | String |  |
| created_by_username | String |  |
| currency_code | String |  |
| custom_1 | String |  |
| custom_10 | String |  |
| custom_11 | String |  |
| custom_12 | String |  |
| custom_13 | String |  |
| custom_14 | String |  |
| custom_15 | String |  |
| custom_16 | String |  |
| custom_17 | String |  |
| custom_18 | String |  |
| custom_19 | String |  |
| custom_2 | String |  |
| custom_20 | String |  |
| custom_21 | String |  |
| custom_22 | String |  |
| custom_23 | String |  |
| custom_24 | String |  |
| custom_3 | String |  |
| custom_4 | String |  |
| custom_5 | String |  |
| custom_6 | String |  |
| custom_7 | String |  |
| custom_8 | String |  |
| custom_9 | String |  |
| data_source | String |  |
| deleted_date | Instant |  |
| delivery_slip_number | String |  |
| description | String |  |
| discount_percentage | Double |  |
| discount_terms | String |  |
| employee_email_address | String |  |
| employee_id | String |  |
| employee_login_id | String |  |
| employee_name | String |  |
| external_policy_id | String |  |
| extract_date | Instant |  |
| first_approval_date | Instant |  |
| first_submit_date | Instant |  |
| invoice_amount | Double |  |
| invoice_date | Instant |  |
| invoice_number | String |  |
| invoice_received_date | Instant |  |
| is_assigned | String |  |
| is_emergency_check_run | String |  |
| is_invoice_confirmed | Boolean |  |
| is_payment_request_deleted | String |  |
| is_payment_request_duplicate | String |  |
| is_test_transaction | String |  |
| last_submit_date | Instant |  |
| ledger_code | String |  |
| line_item_total_amount | Double |  |
| line_item_vat_amount | Double |  |
| name | String |  |
| notes_to_vendor | String |  |
| ob_10_buyer_id | String |  |
| ob_10_transaction_id | String |  |
| org_unit_1 | String |  |
| org_unit_2 | String |  |
| org_unit_3 | String |  |
| org_unit_4 | String |  |
| org_unit_5 | String |  |
| org_unit_6 | String |  |
| paid_amount | Double |  |
| paid_date | Instant |  |
| payment_adjustment_notes | String |  |
| payment_amount | Double |  |
| payment_due_date | Instant |  |
| payment_method | String |  |
| payment_request_created_by_test_user | String |  |
| payment_request_deleted_by | String |  |
| payment_status | String |  |
| payment_terms_days | Int |  |
| posting_date | Instant |  |
| provincial_tax_id | String |  |
| purchase_order_number | String |  |
| receipt_confirmation_type | String |  |
| shipping_amount | Double |  |
| submitted_by_delegate | String |  |
| tax_amount | Double |  |
| tax_code | String |  |
| tax_code_2 | String |  |
| tax_code_3 | String |  |
| tax_code_4 | String |  |
| total_approved_amount | Double |  |
| uri | String |  |
| user_creation_date | Instant |  |
| vat_amount_four | Double |  |
| vat_amount_one | Double |  |
| vat_amount_three | Double |  |
| vat_amount_two | Double |  |
| vat_rate_four | Double |  |
| vat_rate_one | Double |  |
| vat_rate_three | Double |  |
| vat_rate_two | Double |  |
| vendor_ship_from_address_code | String |  |
| vendor_tax_id | String |  |
| workflow_complete_date | Instant |  |
| company_bill_to_** |  |  |
| company_ship_to_** |  |  |
| vendor_remit_** |  |  |
| vendor_ship_from_** |  |  |

### travel_request_exception

| Column | Type | Keys |
| --- | --- | --- |
| code | String | PK |
| travel_request_id | String | PK |
| is_blocking | Boolean |  |
| level | Int |  |
| message | String |  |

### user

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| user_id | String | FK |
| active | Boolean |  |
| cell_phone_number | String |  |
| company_id | String |  |
| cost_center | String |  |
| created_at | Instant |  |
| date_of_birth | String |  |
| display_name | String |  |
| employee_id | String |  |
| employee_number | String |  |
| first_name | String |  |
| last_modified_at | Instant |  |
| last_name | String |  |
| manager_display_name | String |  |
| manager_id | String |  |
| middle_name | String |  |
| nick_name | String |  |
| preference_24_hour | String |  |
| preference_currency_symbol_location | String |  |
| preference_date_format | String |  |
| preference_default_cal_view | String |  |
| preference_distance | String |  |
| preference_end_day_view_hour | Int |  |
| preference_first_day_of_week | String |  |
| preference_hour_minute_separator | String |  |
| preference_negative_currency_format | String |  |
| preference_negative_number_format | String |  |
| preference_number_format | String |  |
| preference_start_day_view_hour | Int |  |
| preferred_language | String |  |
| primary_email | String |  |
| start_date | Instant |  |
| termination_date | Instant |  |
| timezone | String |  |
| title | String |  |

### attendee

| Column | Type | Keys |
| --- | --- | --- |
| attendee_type_id | String | PK |
| id | String | PK |
| company | String |  |
| currency_code | String |  |
| external_id | String |  |
| first_name | String |  |
| has_exceptions_prev_year | Boolean |  |
| has_exceptions_ytd | Boolean |  |
| last_name | String |  |
| middle_initial | String |  |
| owner_login_id | String |  |
| owner_name | String |  |
| suffix | String |  |
| title | String |  |
| version_number | String |  |

### itemization

| Column | Type | Keys |
| --- | --- | --- |
| expense_entry_id | String | PK |
| id | String | PK |
| allocation_type | String |  |
| approved_amount | Double |  |
| description | String |  |
| expense_type_code | String |  |
| expense_type_name | String |  |
| has_comments | Boolean |  |
| has_exceptions | Boolean |  |
| is_billable | Boolean |  |
| is_image_required | Boolean |  |
| is_personal | Boolean |  |
| last_modified | Instant |  |
| location_id | String |  |
| posted_amount | Double |  |
| report_id | String |  |
| report_owner_id | String |  |
| spend_category_code | String |  |
| spend_category_name | String |  |
| transaction_amount | Double |  |
| transaction_date | Instant |  |

### air

| Column | Type | Keys |
| --- | --- | --- |
| booking_id | String | PK |
| index | Int | PK |
| aircraft_code | String |  |
| bags | String |  |
| cabin | String |  |
| cancellation_number | String |  |
| cancellation_policy | String |  |
| carbon_emission_lbs | Double |  |
| carbon_model | Int |  |
| checked_baggage | String |  |
| class_of_service | String |  |
| confirmation_number | String |  |
| credit_card_last_four | String |  |
| credit_card_type | String |  |
| date_cancelled_utc | Instant |  |
| date_created_utc | Instant |  |
| date_modified_utc | Instant |  |
| duration | Int |  |
| end_city_code | String |  |
| end_date_local | Instant |  |
| end_date_utc | Instant |  |
| end_gate | String |  |
| end_terminal | String |  |
| eticket | String |  |
| flight_number | String |  |
| frequent_traveler_id | String |  |
| is_ghost_card | Boolean |  |
| is_open_segment | Boolean |  |
| is_preferred_vendor | Int |  |
| is_upgrade_allowed | Boolean |  |
| leg_id | Int |  |
| meals | String |  |
| miles | Int |  |
| notes | String |  |
| num_stops | Int |  |
| open_segment | String |  |
| operated_by_flight_number | String |  |
| operated_by_vendor | String |  |
| operated_by_vendor_name | String |  |
| services | String |  |
| special_instructions | String |  |
| start_city_code | String |  |
| start_date_local | Instant |  |
| start_date_utc | Instant |  |
| start_gate | String |  |
| start_terminal | String |  |
| status | String |  |
| time_zone | String |  |
| upgraded_date_time | Instant |  |
| vendor | String |  |
| vendor_flags | String |  |
| vendor_name | String |  |

### location

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| administrative_region | String |  |
| country | String |  |
| country_subdivision | String |  |
| iatacode | String |  |
| is_airport | Boolean |  |
| is_booking_tool | Boolean |  |
| latitude | Double |  |
| longitude | Double |  |
| name | String |  |

### spend_user

| Column | Type | Keys |
| --- | --- | --- |
| spend_user_id | String | PK |
| allow_credit_card_trans_arrival_emails | Boolean |  |
| allow_receipt_image_avail_emails | Boolean |  |
| auto_add_trip_card_trans_on_report | Boolean |  |
| bi_hierarchy_code | String |  |
| bi_hierarchy_href | String |  |
| bi_hierarchy_sync_guid | String |  |
| bimanager_value | String |  |
| budget_country_code | String |  |
| cash_advance_account_code | String |  |
| country | String |  |
| default_report_print_format | String |  |
| enable_ocr_for_email | Boolean |  |
| enable_ocr_for_ui | Boolean |  |
| enable_trip_based_assistant | Boolean |  |
| expense_audit_required | String |  |
| ledger_code | String |  |
| locale | String |  |
| non_employee | Boolean |  |
| office_location_city | String |  |
| office_location_country | String |  |
| office_location_state_province | String |  |
| processor_report_access | String |  |
| prompt_for_card_transactions_on_report | Boolean |  |
| prompt_for_report_print_format | Boolean |  |
| reimbursement_currency | String |  |
| reimbursement_type | String |  |
| show_expense_on_report | String |  |
| show_imaging_intro | Boolean |  |
| show_instruct_help_panel | Boolean |  |
| show_total_on_report | Boolean |  |
| state_province | String |  |
| test_employee | Boolean |  |
| use_quick_itin_as_default | Boolean |  |

### rail

| Column | Type | Keys |
| --- | --- | --- |
| booking_id | String | PK |
| index | Int | PK |
| amenities | String |  |
| cabin | String |  |
| cancellation_number | String |  |
| carbon_emission_lbs | Double |  |
| carbon_model | Int |  |
| class_of_service | String |  |
| confirmation_number | String |  |
| credit_card_type | String |  |
| currency | String |  |
| date_cancelled_utc | Instant |  |
| date_created_utc | Instant |  |
| date_modified_utc | Instant |  |
| discount_code | String |  |
| duration | Int |  |
| end_city | String |  |
| end_city_code | String |  |
| end_country | String |  |
| end_date_local | Instant |  |
| end_date_utc | Instant |  |
| end_latitude | Double |  |
| end_longitude | Double |  |
| end_platform | String |  |
| end_rail_station | String |  |
| end_rail_station_name | String |  |
| end_state | String |  |
| eticket | String |  |
| fare_type | String |  |
| frequent_traveler_id | String |  |
| is_ghost_card | Boolean |  |
| is_preferred_vendor | Int |  |
| is_upgrade_allowed | Boolean |  |
| leg_id | Int |  |
| meals | String |  |
| miles | Int |  |
| notes | String |  |
| num_persons | Int |  |
| num_stops | Int |  |
| operated_by_train_number | String |  |
| operated_by_vendor | String |  |
| rate_code | String |  |
| route_restrict_code | String |  |
| special_instructions | String |  |
| start_city | String |  |
| start_city_code | String |  |
| start_country | String |  |
| start_date_local | Instant |  |
| start_date_utc | Instant |  |
| start_latitude | Double |  |
| start_longitude | Double |  |
| start_platform | String |  |
| start_rail_station | String |  |
| start_rail_station_name | String |  |
| start_state | String |  |
| status | String |  |
| time_zone | String |  |
| total_rate | Double |  |
| train_number | String |  |
| train_type_code | String |  |
| train_type_name | String |  |
| transport_mode | String |  |
| upgraded_date_time | Instant |  |
| vendor | String |  |
| vendor_flags | String |  |
| vendor_name | String |  |
| wagon_number | String |  |

### expense_entry

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| report_id | String | PK |
| location_id | String | FK |
| trip_id | String | FK |
| approved_amount | Double |  |
| business_purpose | String |  |
| card_transaction | String |  |
| employee_bank_account_id | String |  |
| ereceipt_id | String |  |
| exchange_rate | Double |  |
| expense_id | String |  |
| expense_pay | Boolean |  |
| expense_type_code | String |  |
| expense_type_id | String |  |
| expense_type_name | String |  |
| form_id | String |  |
| has_allocation | String |  |
| has_applied_cash_advance | Boolean |  |
| has_attendees | Boolean |  |
| has_comments | Boolean |  |
| has_exceptions | Boolean |  |
| has_image | Boolean |  |
| has_vat | Boolean |  |
| image_required | Boolean |  |
| is_billable | Boolean |  |
| is_itemized | Boolean |  |
| is_personal | Boolean |  |
| is_personal_card_charge | Boolean |  |
| last_modified | Instant |  |
| location_country | String |  |
| location_name | String |  |
| location_subdivision | String |  |
| payment_type_id | String |  |
| payment_type_name | String |  |
| posted_amount | Double |  |
| report_entry_receipt_received | Boolean |  |
| report_entry_receipt_type | String |  |
| spend_category | String |  |
| transaction_amount | Double |  |
| transaction_currency_code | String |  |
| transaction_date | Instant |  |
| user_id | String |  |
| vendor_description | String |  |
| vendor_list_item_id | String |  |
| vendor_list_item_name | String |  |
| journey_** |  |  |

### allocation

| Column | Type | Keys |
| --- | --- | --- |
| allocation_id | String | PK |
| itemization_id | String | PK |
| account_code_1 | String |  |
| account_code_2 | String |  |
| is_hidden | Boolean |  |
| is_percent_edited | Boolean |  |
| percentage | String |  |

### vendor_bank

| Column | Type | Keys |
| --- | --- | --- |
| account_number | String | PK |
| address_code | String | PK |
| vendor_code | String | PK, FK |
| account_type | String |  |
| bank_code | String |  |
| bank_name | String |  |
| branch_code | String |  |
| branch_location | String |  |
| country_code | String |  |
| currency_alpha_code | String |  |
| id | String |  |
| is_active | String |  |
| name_on_account | String |  |
| routing_number | String |  |
| trans_type | String |  |
| uri | String |  |

### report

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| amount_due_company_card | Double |  |
| amount_due_employee | Double |  |
| approval_status_code | String |  |
| approval_status_name | String |  |
| approver_login_id | String |  |
| approver_name | String |  |
| country | String |  |
| country_subdivision | String |  |
| create_date | Instant |  |
| currency_code | String |  |
| ever_sent_back | Boolean |  |
| has_exception | Boolean |  |
| last_comment | String |  |
| last_modified_date | Instant |  |
| ledger_name | String |  |
| name | String |  |
| owner_login_id | String |  |
| owner_name | String |  |
| paid_date | Instant |  |
| payment_status_code | String |  |
| payment_status_name | String |  |
| personal_amount | Double |  |
| policy_id | String |  |
| processing_payment_date | Instant |  |
| receipts_received | Boolean |  |
| submit_date | Instant |  |
| total | Double |  |
| total_approved_amount | Double |  |
| total_claimed_amount | Double |  |
| user_defined_date | Instant |  |
| workflow_action_url | String |  |

### charge_rate_with_allowance

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| segment_index | Int | PK |
| allowance_amount | Double |  |
| allowance_is_unlimited | Boolean |  |
| allowance_num_units | Double |  |
| allowance_unit | String |  |
| amount | Double |  |
| currency | String |  |
| is_primary | Boolean |  |
| num_units | Double |  |
| per_unit | String |  |
| semantics_code | String |  |
| semantics_vendor_type | String |  |
| start_date_local | Instant |  |
| vendor | String |  |
| vendor_charge_code | String |  |

### charge_rate

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| segment_index | Int | PK |
| amount | Double |  |
| confirmation_number | String |  |
| currency | String |  |
| is_paid | Boolean |  |
| is_primary | Boolean |  |
| num_units | Double |  |
| per_unit | String |  |
| semantics_code | String |  |
| semantics_vendor_type | String |  |
| start_date_local | Instant |  |
| vendor | String |  |
| vendor_charge_code | String |  |

### line_item_matched_purchase_order_receipt

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| line_item_index | Int | PK |
| payment_request_id | String | PK, FK |
| goods_receipt_number | String |  |

### vendor_bank_status

| Column | Type | Keys |
| --- | --- | --- |
| record_number | Int | PK |
| account_number | String | PK, FK |
| address_code | String | PK, FK |
| vendor_code | String | PK, FK |
| code | Int |  |
| message | String |  |
| type | String |  |

### line_item_allocation

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| line_item_index | Int | PK |
| payment_request_id | String | PK, FK |
| allocation_account_code | String |  |
| custom_1 | String |  |
| custom_10 | String |  |
| custom_11 | String |  |
| custom_12 | String |  |
| custom_13 | String |  |
| custom_14 | String |  |
| custom_15 | String |  |
| custom_16 | String |  |
| custom_17 | String |  |
| custom_18 | String |  |
| custom_19 | String |  |
| custom_2 | String |  |
| custom_20 | String |  |
| custom_3 | String |  |
| custom_4 | String |  |
| custom_5 | String |  |
| custom_6 | String |  |
| custom_7 | String |  |
| custom_8 | String |  |
| custom_9 | String |  |
| is_test_user | String |  |
| percentage | String |  |

### expense_comment

| Column | Type | Keys |
| --- | --- | --- |
| expense_id | String | PK |
| index | Long | PK |
| report_id | String | PK, FK |
| author_id | String |  |
| comment | String |  |
| created_for_employee_id | String |  |
| creation_date | Instant |  |
| is_auditor_comment | Boolean |  |
| is_latest | Boolean |  |
| step_instance_id | String |  |

### spend_user_custom_data

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| spend_user_id | String | PK, FK |
| value | String |  |

### attendee_type

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| allow_attendee_count_editing | Boolean |  |
| allow_manually_entered_attendees | Boolean |  |
| attendee_form_id | String |  |
| code | String |  |
| connector_id | String |  |
| name | String |  |

### travel_agency

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| email_address | String |  |
| name | String |  |

### spend_user_role

| Column | Type | Keys |
| --- | --- | --- |
| role_name | String | PK |
| spend_user_id | String | PK, FK |
| role_groups | Json |  |

### parking

| Column | Type | Keys |
| --- | --- | --- |
| booking_id | String | PK |
| index | Int | PK |
| cancellation_number | String |  |
| class_of_service | String |  |
| confirmation_number | String |  |
| currency | String |  |
| date_cancelled_utc | Instant |  |
| date_created_utc | Instant |  |
| date_modified_utc | Instant |  |
| end_date_local | Instant |  |
| end_date_utc | Instant |  |
| frequent_traveler_id | String |  |
| is_preferred_vendor | Int |  |
| is_upgrade_allowed | Boolean |  |
| name | String |  |
| notes | String |  |
| operated_by_vendor | String |  |
| parking_location_id | String |  |
| phone_number | String |  |
| pin | String |  |
| rate_code | String |  |
| start_address | String |  |
| start_address_2 | String |  |
| start_city | String |  |
| start_city_code | String |  |
| start_country | String |  |
| start_date_local | Instant |  |
| start_date_utc | Instant |  |
| start_location | String |  |
| start_postal_code | String |  |
| start_state | String |  |
| status | String |  |
| time_zone | String |  |
| total_rate | Double |  |
| upgraded_date_time | Instant |  |
| vendor | String |  |
| vendor_flags | String |  |

### trip

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| booked_by_first_name | String |  |
| booked_by_last_name | String |  |
| booked_via | String |  |
| client_locator | String |  |
| comments | String |  |
| date_booked_local | String |  |
| date_created_utc | Instant |  |
| date_modified_utc | Instant |  |
| end_date_local | Instant |  |
| end_date_utc | Instant |  |
| is_personal | Boolean |  |
| itin_locator | String |  |
| itin_source_name | String |  |
| project_name | String |  |
| start_date_local | Instant |  |
| start_date_utc | Instant |  |
| trip_name | String |  |
| trip_status | Int |  |
| user_id | String |  |

### duplicate_search_field

| Column | Type | Keys |
| --- | --- | --- |
| field | String | PK |
| attendee_type_id | String | PK, FK |

### report_approver

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| spend_user_id | String | PK, FK |
| primary | Boolean |  |
| value | String |  |

### list_item

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| list_id | String | PK, FK |
| parent_id | String | FK |
| code | String |  |
| is_deleted | Boolean |  |
| level | Int |  |
| short_code | String |  |
| value | String |  |

### policy

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| is_default | Boolean |  |
| is_inheritable | Boolean |  |
| name | String |  |

### vendor_group

| Column | Type | Keys |
| --- | --- | --- |
| name | String | PK |
| vendor_code | String | PK, FK |

### payment_type

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| is_default | Boolean |  |
| name | String |  |

### passenger

| Column | Type | Keys |
| --- | --- | --- |
| booking_id | String | PK |
| index | Int | PK |
| name_first | String |  |
| name_last | String |  |
| name_middle | String |  |
| name_prefix | String |  |
| name_remark | String |  |
| name_suffix | String |  |
| name_title | String |  |
| text_name | String |  |

### expense_type

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| policy_id | String | PK |
| expense_code | String |  |
| name | String |  |

### attendee_v_4

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| attendee_type_code | String | FK |
| company | String |  |
| currency_code | String |  |
| external_id | String |  |
| first_name | String |  |
| has_exceptions_prev_year | Boolean |  |
| has_exceptions_ytd | Boolean |  |
| last_name | String |  |
| middle_initial | String |  |
| owner_name | String |  |
| owner_user_id | String |  |
| preferred_name | String |  |
| suffix | String |  |
| title | String |  |
| total_amount_prev_year | Double |  |
| total_amount_ytd | Double |  |
| uri | String |  |
| version_number | Int |  |

### ride

| Column | Type | Keys |
| --- | --- | --- |
| booking_id | String | PK |
| index | Int | PK |
| cancellation_number | String |  |
| cancellation_policy | String |  |
| confirmation_number | String |  |
| credit_card_last_four | String |  |
| credit_card_type | String |  |
| currency | String |  |
| date_cancelled_utc | String |  |
| date_created_utc | String |  |
| date_modified_utc | String |  |
| dropoff_instructions | String |  |
| duration | String |  |
| end_address | String |  |
| end_address_2 | String |  |
| end_city | String |  |
| end_city_code | String |  |
| end_country | String |  |
| end_date_local | String |  |
| end_date_utc | String |  |
| end_latitude | String |  |
| end_location | String |  |
| end_location_code | String |  |
| end_location_name | String |  |
| end_longitude | String |  |
| end_postal_code | String |  |
| end_state | String |  |
| is_ghost_card | String |  |
| is_preferred_vendor | String |  |
| is_upgrade_allowed | String |  |
| meeting_instructions | String |  |
| miles | String |  |
| name | String |  |
| notes | String |  |
| num_persons | String |  |
| number_of_hours | String |  |
| operated_by_vendor | String |  |
| passive_city_code | String |  |
| phone_number | String |  |
| pickup_instructions | String |  |
| provider_feedback | String |  |
| rate | String |  |
| rate_description | String |  |
| rate_notes | String |  |
| rate_type | String |  |
| reservation_id | String |  |
| special_instructions | String |  |
| start_address | String |  |
| start_address_2 | String |  |
| start_city | String |  |
| start_city_code | String |  |
| start_country | String |  |
| start_date_local | String |  |
| start_date_utc | Instant |  |
| start_latitude | String |  |
| start_location | String |  |
| start_location_code | String |  |
| start_location_name | String |  |
| start_longitude | String |  |
| start_postal_code | String |  |
| start_state | String |  |
| status | String |  |
| time_zone | String |  |
| time_zone_id | String |  |
| total_rate | String |  |
| upgraded_date_time | String |  |
| vendor | String |  |
| vendor_flags | String |  |
| vendor_name | String |  |

### line_item

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| payment_request_id | String | PK, FK |
| allocation_status | String |  |
| amount_without_vat | Double |  |
| approved_line_item_amount | Double |  |
| custom_1 | String |  |
| custom_10 | String |  |
| custom_11 | String |  |
| custom_12 | String |  |
| custom_13 | String |  |
| custom_14 | String |  |
| custom_15 | String |  |
| custom_16 | String |  |
| custom_17 | String |  |
| custom_18 | String |  |
| custom_19 | String |  |
| custom_2 | String |  |
| custom_20 | String |  |
| custom_3 | String |  |
| custom_4 | String |  |
| custom_5 | String |  |
| custom_6 | String |  |
| custom_7 | String |  |
| custom_8 | String |  |
| custom_9 | String |  |
| delivery_slip_number | String |  |
| description | String |  |
| expense_type_code | String |  |
| is_matched | String |  |
| item_code | String |  |
| line_item_id | String |  |
| line_item_is_test_user | String |  |
| matched_purchase_order_line_item_id | String |  |
| purchase_order_number | String |  |
| quantity | Double |  |
| request_line_item_number | String |  |
| requested_line_item_amount | Double |  |
| ship_from_postal_code | String |  |
| ship_to_postal_code | String |  |
| supplier_part_id | String |  |
| tax | Double |  |
| tax_code | String |  |
| tax_code_2 | String |  |
| tax_code_3 | String |  |
| tax_code_4 | String |  |
| total_price | Double |  |
| unit_of_measure | String |  |
| unit_price | Double |  |
| vat_amount | Double |  |
| vat_amount_four | Double |  |
| vat_amount_three | Double |  |
| vat_amount_two | Double |  |
| vat_rate | Double |  |
| vat_rate_four | Double |  |
| vat_rate_three | Double |  |
| vat_rate_two | Double |  |

### list_item_member_list

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| list_id | String | PK, FK |
| list_item_id | String | PK, FK |
| has_children | Boolean |  |

### payment_request_digest

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| approval_status_code | String |  |
| create_date | Instant |  |
| currency_code | String |  |
| extracted_date | Instant |  |
| invoice_number | String |  |
| is_deleted | Boolean |  |
| last_modified | Instant |  |
| owner_login_id | String |  |
| owner_name | String |  |
| paid_date | Instant |  |
| payment_method | String |  |
| payment_request_id | String |  |
| payment_request_uri | String |  |
| payment_status_code | String |  |
| purchase_order_number | String |  |
| total | Double |  |
| uri | String |  |
| user_defined_date | Instant |  |
| vendor_code | String |  |
| vendor_name | String |  |

### delegator

| Column | Type | Keys |
| --- | --- | --- |
| concur_user_id | String | PK |
| can_approve | String |  |
| can_prepare | String |  |
| can_submit | String |  |
| can_temporary_approve | String |  |
| can_view_receipts | String |  |
| delegator_xuser_id | String |  |
| receive_approval_emails | String |  |
| receives_emails | String |  |

### hotel

| Column | Type | Keys |
| --- | --- | --- |
| booking_id | String | PK |
| index | Int | PK |
| cancellation_number | String |  |
| cancellation_policy | String |  |
| checkin_time | String |  |
| checkout_time | String |  |
| confirmation_number | String |  |
| credit_card_last_four | String |  |
| credit_card_type | String |  |
| currency | String |  |
| daily_rate | Double |  |
| date_cancelled_utc | Instant |  |
| date_created_utc | Instant |  |
| date_modified_utc | Instant |  |
| discount_code | String |  |
| end_date_local | Instant |  |
| end_date_utc | Instant |  |
| equipment_code | String |  |
| frequent_traveler_id | String |  |
| had_deposit | Boolean |  |
| hotel_property_id | String |  |
| hotel_service_localized_vendor_name | String |  |
| hotel_service_vendor_name | String |  |
| is_ghost_card | Boolean |  |
| is_preferred_vendor | Int |  |
| is_upgrade_allowed | Boolean |  |
| modification_code | String |  |
| name | String |  |
| notes | String |  |
| num_persons | Int |  |
| num_rooms | Int |  |
| partner_membership_id | String |  |
| passive_type | String |  |
| phone_number | String |  |
| rate_access | String |  |
| rate_code | String |  |
| rate_type | String |  |
| room_description | String |  |
| room_type | String |  |
| search_location_latitude | Double |  |
| search_location_longitude | Double |  |
| special_instructions | String |  |
| start_address | String |  |
| start_address_2 | String |  |
| start_city | String |  |
| start_city_code | String |  |
| start_country | String |  |
| start_date_local | Instant |  |
| start_date_utc | Instant |  |
| start_latitude | Double |  |
| start_longitude | Double |  |
| start_postal_code | String |  |
| start_state | String |  |
| status | String |  |
| time_zone | String |  |
| total_rate | Double |  |
| upgraded_date_time | Instant |  |
| vendor | String |  |
| vendor_flags | String |  |
| vendor_name | String |  |

### list

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| category_id | String |  |
| category_type | String |  |
| display_format | String |  |
| is_deleted | Boolean |  |
| is_read_only | Boolean |  |
| level_count | Long |  |
| managed_by | String |  |
| search_criteria | String |  |
| value | String |  |

### vendor

| Column | Type | Keys |
| --- | --- | --- |
| vendor_code | String | PK |
| account_number | String |  |
| address_1 | String |  |
| address_2 | String |  |
| address_3 | String |  |
| address_code | String |  |
| address_import_sync_id | String |  |
| approved | String |  |
| city | String |  |
| contact_email | String |  |
| contact_first_name | String |  |
| contact_last_name | String |  |
| contact_phone_number | String |  |
| country | String |  |
| country_code | String |  |
| currency_code | String |  |
| custom_1 | String |  |
| custom_10 | String |  |
| custom_11 | String |  |
| custom_12 | String |  |
| custom_13 | String |  |
| custom_14 | String |  |
| custom_15 | String |  |
| custom_16 | String |  |
| custom_17 | String |  |
| custom_18 | String |  |
| custom_19 | String |  |
| custom_2 | String |  |
| custom_20 | String |  |
| custom_3 | String |  |
| custom_4 | String |  |
| custom_5 | String |  |
| custom_6 | String |  |
| custom_7 | String |  |
| custom_8 | String |  |
| custom_9 | String |  |
| default_employee_id | String |  |
| default_expense_type_name | String |  |
| discount_percentage | String |  |
| discount_terms_days | String |  |
| id | String |  |
| is_line_item_vat_incld | String |  |
| is_visible_for_content_extraction | String |  |
| payment_method_type | String |  |
| payment_terms | Int |  |
| postal_code | String |  |
| provincial_tax_id | String |  |
| purchase_order_contact_email | String |  |
| purchase_order_contact_first_name | String |  |
| purchase_order_contact_last_name | String |  |
| purchase_order_contact_phone_number | String |  |
| shipping_method | String |  |
| shipping_terms | String |  |
| state | String |  |
| tax_id | String |  |
| tax_type | String |  |
| uri | String |  |
| vendor_form_name | String |  |
| vendor_name | String |  |
| voucher_notes | String |  |

### travel_request_comment

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| travel_request_id | String | PK |
| author_name | String |  |
| creation_date_time | Instant |  |
| is_latest | Boolean |  |
| value | String |  |

### spend_user_expense_delegate

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| spend_user_id | String | PK, FK |
| value | String | FK |
| can_approve | Boolean |  |
| can_prepare | Boolean |  |
| can_prepare_for_approval | Boolean |  |
| can_receive_approval_email | Boolean |  |
| can_receive_email | Boolean |  |
| can_submit | Boolean |  |
| can_submit_travel_request | Boolean |  |
| can_use_bi | Boolean |  |
| can_view_receipt | Boolean |  |
| temporary_delegation_from_date | Instant |  |
| temporary_delegation_to_date | Instant |  |

### charge_percent

| Column | Type | Keys |
| --- | --- | --- |
| index | Int | PK |
| segment_index | Int | PK |
| amount | String |  |
| currency | String |  |
| description | String |  |
| is_paid | Boolean |  |
| is_primary | Boolean |  |
| semantics_code | String |  |
| semantics_vendor_type | String |  |
| start_date_local | Instant |  |
| vendor | String |  |
| vendor_charge_code | String |  |

### attendee_type_v_4

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| allow_attendee_count_editing | Boolean |  |
| allow_manually_entered_attendees | Boolean |  |
| code | String |  |
| external_connector_id | String |  |
| form_id | String |  |
| form_name | String |  |
| is_active | Boolean |  |
| is_deleted | Boolean |  |
| is_public | Boolean |  |
| name | String |  |
| permit_adds | Boolean |  |
| search_preference | String |  |
| system_record | Boolean |  |

### event

| Column | Type | Keys |
| --- | --- | --- |
| booking_id | String | PK |
| index | Int | PK |
| cancellation_number | String |  |
| ces_id | Int |  |
| cliqbook_id | Int |  |
| confirmation_number | String |  |
| currency | String |  |
| date_cancelled_utc | Instant |  |
| date_created_utc | Instant |  |
| date_modified_utc | Instant |  |
| end_date_local | Instant |  |
| end_date_utc | Instant |  |
| ereceipt_status | Int |  |
| is_preferred_vendor | Int |  |
| is_upgrade_allowed | Boolean |  |
| name | String |  |
| notes | String |  |
| num_persons | Int |  |
| phone_number | String |  |
| segment_key | String |  |
| segment_locator | Long |  |
| sent_to_airplus | Boolean |  |
| start_address | String |  |
| start_address_2 | String |  |
| start_city | String |  |
| start_country | String |  |
| start_date_local | Instant |  |
| start_date_utc | Instant |  |
| start_latitude | Double |  |
| start_longitude | Double |  |
| start_postal_code | String |  |
| start_state | String |  |
| status | String |  |
| time_zone | String |  |
| total_rate | Double |  |
| transient_segment_number | Int |  |
| type | String |  |
| upgraded_date_time | Instant |  |
| vendor | String |  |
| vendor_flags | String |  |

### travel

| Column | Type | Keys |
| --- | --- | --- |
| booking_id | String | PK |
| index | Int | PK |
| cancellation_number | String |  |
| confirmation_number | String |  |
| credit_card_last_four | String |  |
| credit_card_type | String |  |
| currency | String |  |
| daily_rate | Double |  |
| date_cancelled_utc | Instant |  |
| date_created_utc | Instant |  |
| date_modified_utc | Instant |  |
| end_address | String |  |
| end_address_2 | String |  |
| end_city | String |  |
| end_city_code | String |  |
| end_country | String |  |
| end_date_local | Instant |  |
| end_date_utc | Instant |  |
| end_latitude | Double |  |
| end_location | String |  |
| end_longitude | Double |  |
| end_postal_code | String |  |
| end_state | String |  |
| is_ghost_card | Boolean |  |
| notes | String |  |
| num_persons | Int |  |
| phone_number | String |  |
| special_instructions | String |  |
| start_address | String |  |
| start_address_2 | String |  |
| start_city | String |  |
| start_city_code | String |  |
| start_country | String |  |
| start_date_local | Instant |  |
| start_date_utc | Instant |  |
| start_latitude | Double |  |
| start_location | String |  |
| start_longitude | Double |  |
| start_postal_code | String |  |
| start_state | String |  |
| status | String |  |
| time_zone | String |  |
| total_rate | Double |  |
| transport_mode | String |  |
| vendor | String |  |
| vendor_name | String |  |

## Relationships

- spend_user_authorized_approver(spend_user_id) → spend_user(spend_user_id)
- vendor_status(vendor_code) → vendor(vendor_code)
- payment_request(payment_request_digest_id) → payment_request_digest(id)
- user(user_id) → spend_user(spend_user_id)
- expense_entry(trip_id) → trip(id)
- expense_entry(location_id) → location(id)
- vendor_bank(vendor_code) → vendor(vendor_code)
- line_item_matched_purchase_order_receipt(payment_request_id) → line_item(payment_request_id)
- vendor_bank_status(vendor_code) → vendor(vendor_code)
- vendor_bank_status(account_number) → vendor_bank(vendor_code)
- vendor_bank_status(address_code) → vendor_bank(vendor_code)
- line_item_allocation(payment_request_id) → line_item(payment_request_id)
- expense_comment(report_id) → report(id)
- spend_user_custom_data(spend_user_id) → spend_user(spend_user_id)
- spend_user_role(spend_user_id) → spend_user(spend_user_id)
- duplicate_search_field(attendee_type_id) → attendee_type_v_4(id)
- report_approver(spend_user_id) → spend_user(spend_user_id)
- list_item(list_id) → list(id)
- list_item(parent_id) → list_item(list_id)
- vendor_group(vendor_code) → vendor(vendor_code)
- attendee_v_4(attendee_type_code) → attendee_type_v_4(code)
- line_item(payment_request_id) → payment_request(id)
- list_item_member_list(list_item_id) → list_item(list_id)
- list_item_member_list(list_id) → list(id)
- spend_user_expense_delegate(value) → spend_user(spend_user_id)
- spend_user_expense_delegate(spend_user_id) → spend_user(spend_user_id)