SAP Concur

Explore the interactive ERD

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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`goods_receipt_number`	String

vendor_bank_status

Column	Type	Keys
`record_number`	Int	PK
`account_number`	String	PKFK
`address_code`	String	PKFK
`vendor_code`	String	PKFK
`code`	Int
`message`	String
`type`	String

line_item_allocation

Column	Type	Keys
`index`	Int	PK
`line_item_index`	Int	PK
`payment_request_id`	String	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK

report_approver

Column	Type	Keys
`index`	Int	PK
`spend_user_id`	String	PKFK
`primary`	Boolean
`value`	String

list_item

Column	Type	Keys
`id`	String	PK
`list_id`	String	PKFK
`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	PKFK

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	PKFK
`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	PKFK
`list_item_id`	String	PKFK
`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	PKFK
`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