SAP Concur connector specifications

Integrate with SAP Concur to submit requests and receive notifications about the status of requests.

Version details

Citrix microapps supports the latest SAP Concur APIs.

Endpoints

Note:

Custom endpoints are not supported.

GET

• Expense https://developer.concur.com/api-reference/expense/expense-report/expense-entry.html
• Allocations https://developer.concur.com/api-reference/expense/allocations/expense-allocations.html
• Payment Type https://developer.concur.com/api-reference/expense/expense-report/expense-group-configurations.html#paymenttype
• Policy https://developer.concur.com/api-reference/expense/expense-report/expense-group-configurations.html#policy
• Expense Type https://developer.concur.com/api-reference/expense/expense-report/expense-group-configurations.html#expensetype
• Itemizations https://developer.concur.com/api-reference/expense/expense-report/expense-itemization.html
• Reports https://developer.concur.com/api-reference/expense/expense-report/reports.html
• Receipt Images https://developer.concur.com/api-reference/image/
• Payment Request https://developer.concur.com/api-reference/invoice/payment-request.html#schema
• Purchase Orders https://developer.concur.com/api-reference/invoice/purchase-order.html#schema
• Vendors https://developer.concur.com/api-reference/invoice/vendor.html#schema
• Users https://developer.concur.com/api-reference/user/company-notification-subscription-resource/user.html

POST

• Submit a report https://developer.concur.com/api-reference/expense/expense-report/post-report-submission.html
• Approve, Send Back to Employee, or Recall to Employee https://developer.concur.com/api-reference/expense/expense-report/post-report-workflow-action.html
• Request an expense https://developer.concur.com/api-reference/request/request.html

Service Actions

• Create user - new user is created
• Approve report - chosen report is approved
• Send Report Back - chosen report id sent back
• Add Travel Notification - notification is created for chosen itinerary
• Create Quick Expense - new quick expense is created

Key Entities

The following are the main business entities that this connector addresses:

• Expense
• Quick Expense
• Reports
• Itinerary
• Delegate

Entities with Attributes

The following is a full list of entities and their attributes (SAP Concur v.0.7.4)

Allocations (List of Concur expense allocations)

• id: STRING(60), PK
• entry_id: STRING(60), FK(Expenses.id)
• percentage: STRING(500)
• percent_edited: BOOLEAN
• hidden: BOOLEAN
• account_code_1: STRING(500)
• account_code_2: STRING(500)

Delegate (List of Concur users which delegated some rights to service account)

• delegator_user_id: STRING(100), PK, FK(Users.login_id)
• can_prepare: BOOLEAN
• can_submit: BOOLEAN
• can_view_receipts: BOOLEAN
• receives_emails: BOOLEAN
• can_approve: BOOLEAN
• can_temporary_approve: BOOLEAN
• receive_approval_emails: BOOLEAN

Expense Types (List of Concur expense types)

• code: STRING(100), PK
• name: STRING(100)
• expense_code: STRING(100)
• policy_id: STRING(60), PK, FK(Policies.id)

Expenses (List of Concur expense entries)

• id: STRING(60), PK
• report_id: STRING(60), FK(Reports.id)
• report_owner_id: STRING(60), FK(Users.login_id)
• expense_type_code: STRING(40)
• expense_type_name: STRING(100)
• spend_category_code: STRING(40)
• spend_category_name: STRING(100)
• payment_type_id: STRING(60), FK(Payment Types.id)
• payment_type_name: STRING(100)
• transaction_date: DATETIME
• transaction_currency_code: STRING(40)
• transaction_amount: FLOAT(prec=24, scale=4)
• exchange_rate: FLOAT(prec=24, scale=4)
• posted_amount: FLOAT(prec=24, scale=4)
• approved_amount: FLOAT(prec=24, scale=4)
• vendor_description: STRING(500)
• vendor_list_item_id: STRING(60)
• vendor_list_item_name: STRING(100)
• location_id: STRING(60)
• location_name: STRING(100)
• location_subdivision: STRING(100)
• location_country: STRING(100)
• description: STRING(500)
• personal: BOOLEAN
• billable: BOOLEAN
• personal_card_charge: BOOLEAN
• has_image: BOOLEAN
• image_required: BOOLEAN
• receipt_received: BOOLEAN
• tax_receipt_type: STRING(40)
• electronic_receipt_id: STRING(60)
• company_card_transaction_id: STRING(60)
• trip_id: STRING(60)
• has_itemizations: BOOLEAN
• allocation_type: STRING(* 1)
• has_attendees: BOOLEAN
• has_vat: BOOLEAN
• has_applied_cash_advance: BOOLEAN
• has_comments: BOOLEAN
• has_exceptions: BOOLEAN
• paid_by_expense_pay: BOOLEAN
• employee_bank_account_id: STRING(60)
• journey: STRING(100)
• last_modified: DATETIME
• form_id: STRING(60)
• uri: STRING(1000)

Form Fields (List of required fields for creating a Concur user)

• id: STRING(60), PK
• list_name: STRING(100)
• label: STRING(100)
• control_type: STRING(40)
• data_type: STRING(40)
• max_length: INTEGER(x32)
• required: BOOLEAN
• rw: BOOLEAN
• custom: BOOLEAN

Itemizations (List of Concur expense items)

• id: STRING(60), PK
• entry_id: STRING(60), FK(Expenses.id)
• report_id: STRING(60), FK(Reports.id)
• report_owner_id: STRING(60)
• expense_type_code: STRING(40)
• expense_type_name: STRING(100)
• spend_category_code: STRING(40)
• spend_category_name: STRING(100)
• transaction_date: DATETIME
• transaction_amount: FLOAT(prec=24, scale=4)
• posted_amount: FLOAT(prec=24, scale=4)
• location_id: STRING(60)
• location_name: STRING(100)
• location_subdivision: STRING(100)
• location_country: STRING(100)
• description: STRING(500)
• personal: BOOLEAN
• billable: BOOLEAN
• image_required: BOOLEAN
• allocation_type: STRING(40)
• has_comments: BOOLEAN
• has_exceptions: BOOLEAN
• last_modified: DATETIME

List Items (List of values for Concur fields defined as lists)

• id: STRING(60), PK
• list_id: STRING(60), FK(Lists.id)
• name: STRING(100)
• level_1_code: STRING(40)
• level_2_code: STRING(40)
• level_3_code: STRING(40)
• level_4_code: STRING(40)
• level_5_code: STRING(40)
• level_6_code: STRING(40)
• level_7_code: STRING(40)
• level_8_code: STRING(40)
• level_9_code: STRING(40)
• level_10_code: STRING(40)

Lists (List of Concur fields defined as lists)

• id: STRING(60), PK
• name: STRING(100)

Payment Types (List of Concur payment types)

• id: STRING(60), PK
• default_payment_type: BOOLEAN
• name: STRING(100)

Policies (List of Concur expense policies)

• id: STRING(60), PK
• name: STRING(100)
• default_policy: BOOLEAN
• inheritable: BOOLEAN

Quick Expense (List of Concur quick expenses)

• id: STRING(60), PK
• expense_type_code: STRING(40), FK(Expense Types.code)
• expense_type_name: STRING(100), FK(Expense Types.name)
• payment_type_code: STRING(40)
• currency_code: STRING(3)
• transaction_amount: FLOAT(prec=24, scale=4)
• transaction_date: DATETIME
• owner_login_id: STRING(100)
• owner_name: STRING(100)
• location_name: STRING(500)
• receipt_image_id: STRING(60)
• comment: STRING(2000)
• vendor_description: STRING(500)
• uri: STRING(1000)

Reports (List of Concur reports)

• id: STRING(60), PK
• amount_due_company_card: FLOAT(prec=24, scale=4)
• amount_due_employee: FLOAT(prec=24, scale=4)
• approval_status_code: STRING(40)
• approval_status_name: STRING(100)
• approver_login_id: STRING(100), FK(Users.login_id)
• delegator_login_id: STRING(100), FK(Delegate.delegator_user_id)
• description: STRING(100)
• approver_name: STRING(100)
• country: STRING(40)
• country_subdivision: STRING(500)
• create_date: DATETIME
• currency_code: STRING(40)
• ever_sent_back: BOOLEAN
• has_exception: BOOLEAN
• last_comment: STRING(500)
• last_modified_date: DATETIME
• ledger_name: STRING(100)
• name: STRING(100)
• owner_login_id: STRING(100), FK(Users.login_id)
• owner_name: STRING(100)
• owner_email: STRING(100)
• paid_date: DATETIME
• payment_status_code: STRING(100)
• payment_status_name: STRING(100)
• pending: BOOLEAN
• personal_amount: FLOAT(prec=24, scale=4)
• policy_id: STRING(60), FK(Policies.id)
• processing_payment_date: STRING(100)
• receipts_received: BOOLEAN
• submit_date: DATETIME
• total: FLOAT(prec=24, scale=4)
• total_approved_amount: FLOAT(prec=24, scale=4)
• total_claimed_amount: FLOAT(prec=24, scale=4)
• uri: STRING(1000)
• user_defined_date: DATETIME
• workflow_action_url: STRING(500)

Travel Air (List of Concur Travel air booking details)

• id: STRING(40), PK
• booking_id: STRING(40), FK(Travel Bookings.unique_id)
• itinerary_trip_id: STRING(100), FK(Travel Itineraries.trip_id)
• aircraft_code: STRING(12)
• bags: STRING(32)
• cabin: STRING(5)
• cancellation_number: STRING(32)
• cancellation_policy: STRING(512)
• carbon_emission_lbs: FLOAT(prec=24, scale=4)
• carbon_model: INTEGER(x32)
• checked_baggage: STRING(100)
• class_of_service: STRING(5)
• confirmation_number: STRING(32)
• date_cancelled_utc: DATETIME
• date_created_utc: DATETIME
• date_modified_utc: DATETIME
• duration: INTEGER(x32)
• end_city_code: STRING(5)
• end_date_local: DATETIME
• end_gate: STRING(10)
• end_terminal: STRING(32)
• e_ticket: STRING(100)
• flight_number: STRING(10)
• frequent_traveler_id: STRING(32)
• isOpenSegment: BOOLEAN
• is_preferred_vendor: INTEGER(x32)
• is_upgrade_allowed: BOOLEAN
• leg_id: INTEGER(x32)
• meals: STRING(20)
• miles: INTEGER(x32)
• notes: STRING(* 1)
• num_stops: INTEGER(x32)
• open_segment: STRING(512)
• operated_by_flight_number: STRING(12)
• operated_by_vendor: STRING(128)
• operated_by_vendor_name: STRING(100)
• services: STRING(512)
• special_instructions: STRING(256)
• start_city_code: STRING(5)
• start_date_local: DATETIME
• start_gate: STRING(10)
• start_terminal: STRING(32)
• status: STRING(2)
• time_zone_id: INTEGER(x32)
• time_zone: STRING(100)
• upgraded_date_time: DATETIME
• vendor: STRING(100)
• vendor_name: STRING(100)
• vendor_flags: STRING(100)
• is_ghost_card: BOOLEAN
• credit_card_type: STRING(100)
• credit_card_last_four: STRING(4)

Travel Airfare Quotes (List of Concur Travel airfare quotes)

• id: LONG, PK
• booking_id: LONG, PK, FK(Travel Bookings.id)
• itinerary_trip_id: STRING(100), PK, FK(Travel Itineraries.trip_id)
• base_fare: FLOAT(prec=24, scale=4)
• base_fare_currency: STRING(3)
• date_created_utc: DATETIME
• date_modified_utc: DATETIME
• endorsements: STRING(512)
• issue_by_date: DATETIME
• total_fare: FLOAT(prec=24, scale=4)
• total_fare_currency: STRING(3)

Travel Airline Tickets (List of Concur Travel airline tickets)

• id: STRING(40), PK
• booking_id: STRING(40), FK(Travel Bookings.unique_id)
• itinerary_trip_id: STRING(100), FK(Travel Itineraries.trip_id)
• add_collect_amount: FLOAT(prec=24, scale=4)
• base_fare: FLOAT(prec=24, scale=4)
• base_fare_currency: STRING(3)
• base_fare_nuc: FLOAT(prec=24, scale=4)
• base_fare_nuc_currency: STRING(3)
• date_created_utc: DATETIME
• date_modified_utc: DATETIME
• endorsements: STRING(500)
• invoice_number: STRING(20)
• issue_date_time: DATETIME
• issuing_iata_agency_number: INTEGER(x32)
• issuing_pseudo_city: STRING(9)
• linear_fare_constructor: STRING(500)
• master_ticket_number: STRING(13)
• name_reference: STRING(50)
• passenger_name: STRING(100)
• plating_carrier_numeric_code: STRING(3)
• plating_control_number: STRING(10)
• program_carrier_code: STRING(2)
• program_membership_number: STRING(50)
• record_locator: STRING(50)
• sabre_dk_number: STRING(10)
• ticketless: BOOLEAN
• ticket_type: STRING(1)
• total_fare: FLOAT(prec=24, scale=4)
• total_fare_currency: STRING(3)
• tour_identifier: STRING(50)

Travel Bookings (List of Concur Travel bookings)

• unique_id: STRING(40)
• id: LONG, PK
• itinerary_trip_id: STRING(100), PK, FK(Travel Itineraries.trip_id)
• booking_owner: STRING(100)
• booking_referrer: STRING(100)
• booking_source: STRING(32)
• date_booked_local: DATETIME
• date_created_utc: DATETIME
• date_modified_utc: DATETIME
• fare_expires_email_datetime_utc: DATETIME
• form_of_payment_name: STRING(100)
• form_of_payment_type: STRING(100)
• is_ghost_card: BOOLEAN
• credit_card_type: STRING(100)
• credit_card_last_four: STRING(4)
• last_ticket_date_utc: DATETIME
• passenger_count: INTEGER(x32)
• record_locator: STRING(50)
• retrieved_date_utc: DATETIME
• ticket_mailing_address: STRING(512)
• ticket_pickup_location: STRING(512)
• ticket_pickup_number: STRING(100)
• source: STRING(100)
• agency_name: STRING(100)
• agency_pcc: STRING(100)
• agency_number: STRING(100)
• passengers: STRING(* 1)

Travel Car (List of Concur Travel car booking details)

• id: STRING(40), PK
• booking_id: STRING(40), FK(Travel Bookings.unique_id)
• itinerary_trip_id: STRING(100), FK(Travel Itineraries.trip_id)
• air_condition: STRING(100)
• body: STRING(100)
• cancellation_number: STRING(32)
• Class: STRING(100)
• confirmation_number: STRING(32)
• currency: STRING(3)
• daily_rate: FLOAT(prec=24, scale=4)
• date_cancelled_utc: DATETIME
• date_created_utc: DATETIME
• date_modified_utc: DATETIME
• discount_code: STRING(20)
• dropoff_coll_address_1: STRING(100)
• dropoff_coll_address_type: STRING(100)
• dropoff_coll_category: STRING(100)
• dropoff_coll_city: STRING(100)
• dropoff_coll_city_code: STRING(100)
• dropoff_coll_country: STRING(100)
• dropoff_coll_latitude: STRING(100)
• dropoff_coll_longitude: STRING(100)
• dropoff_coll_number: STRING(100)
• dropoff_coll_phone_number: STRING(100)
• dropoff_coll_postal_code: STRING(100)
• dropoff_coll_state: STRING(100)
• end_address: STRING(60)
• end_address_2: STRING(60)
• end_city: STRING(50)
• end_city_code: STRING(12)
• end_close_time: STRING(100)
• end_country: STRING(2)
• end_date_local: DATETIME
• end_latitude: FLOAT(prec=11, scale=8)
• end_location: STRING(10)
• end_longitude: FLOAT(prec=11, scale=8)
• end_open_time: STRING(100)
• end_phone_number: STRING(30)
• end_postal_code: STRING(24)
• end_state: STRING(50)
• frequent_traveler_id: STRING(32)
• is_ghost_card: BOOLEAN
• credit_card_type: STRING(100)
• credit_card_last_four: STRING(4)
• is_preferred_vendor: INTEGER(x32)
• is_upgrade_allowed: BOOLEAN
• notes: STRING(512)
• num_cars: INTEGER(x32)
• num_persons: INTEGER(x32)
• phone_number: STRING(30)
• pickup_delivery_address_1: STRING(100)
• pickup_delivery_address_type: STRING(100)
• pickup_delivery_category: STRING(100)
• pickup_delivery_city: STRING(100)
• pickup_delivery_city_code: STRING(12)
• pickup_delivery_country: STRING(100)
• pickup_delivery_latitude: STRING(100)
• pickup_delivery_longitude: STRING(100)
• pickup_delivery_number: STRING(100)
• pickup_delivery_phone_number: STRING(100)
• pickup_delivery_postal_code: STRING(100)
• pickup_delivery_state: STRING(100)
• rate_code: STRING(24)
• rate_type: STRING(2)
• special_equipment: STRING(512)
• special_instructions: STRING(256)
• start_address: STRING(60)
• start_address_2: STRING(60)
• start_city: STRING(50)
• start_city_code: STRING(12)
• start_close_time: STRING(100)
• start_country: STRING(2)
• start_date_local: DATETIME
• start_latitude: FLOAT(prec=11, scale=8)
• start_location: STRING(32)
• start_longitude: FLOAT(prec=11, scale=8)
• start_open_time: STRING(100)
• start_postal_code: STRING(24)
• start_state: STRING(50)
• status: STRING(2)
• time_zone_id: INTEGER(x32)
• time_zone: STRING(60)
• total_rate: FLOAT(prec=24, scale=4)
• transmission: STRING(100)
• upgraded_date_time: DATETIME
• vendor: STRING(100)
• vendor_name: STRING(100)
• vendor_flags: STRING(100)

Travel Dining (List of Concur Travel dining booking details)

• id: STRING(40), PK
• booking_id: STRING(40), FK(Travel Bookings.unique_id)
• itinerary_trip_id: STRING(100), FK(Travel Itineraries.trip_id)
• cancellation_number: STRING(32)
• confirmation_number: STRING(32)
• date_cancelled_utc: DATETIME
• date_created_utc: DATETIME
• date_modified_utc: DATETIME
• end_date_local: DATETIME
• frequent_traveler_id: STRING(32)
• is_preferred_vendor: INTEGER(x32)
• is_upgrade_allowed: BOOLEAN
• name: STRING(80)
• notes: STRING(512)
• num_persons: INTEGER(x32)
• phone_number: STRING(30)
• reservation_id: STRING(100)
• restaurant_id: STRING(50)
• start_address: STRING(80)
• start_address_2: STRING(80)
• start_city: STRING(50)
• start_country: STRING(2)
• start_date_local: DATETIME
• start_latitude: FLOAT(prec=11, scale=8)
• start_longitude: FLOAT(prec=11, scale=8)
• start_postal_code: STRING(24)
• start_state: STRING(50)
• status: STRING(2)
• time_zone_id: INTEGER(x32)
• time_zone: STRING(100)
• upgraded_date_time: DATETIME
• vendor: STRING(100)
• vendor_name: STRING(100)
• vendor_flags: STRING(100)

Travel Event (List of Concur Travel event booking details)

• id: STRING(40), PK
• booking_id: STRING(40), FK(Travel Bookings.unique_id)
• itinerary_trip_id: STRING(100), FK(Travel Itineraries.trip_id)
• cancellation_number: STRING(32)
• ces_id: INTEGER(x32)
• cliqbook_id: INTEGER(x32)
• confirmation_number: STRING(32)
• currency: STRING(3)
• date_cancelled_utc: DATETIME
• date_created_utc: DATETIME
• date_modified_utc: DATETIME
• end_date_local: DATETIME
• e_receipt_status: INTEGER(x32)
• is_preferred_vendor: INTEGER(x32)
• is_upgrade_allowed: BOOLEAN
• name: STRING(80)
• notes: STRING(512)
• num_persons: INTEGER(x32)
• phone_number: STRING(30)
• segment_key: STRING(100)
• segment_locator: LONG
• sent_to_airplus: BOOLEAN
• start_address: STRING(80)
• start_address_2: STRING(80)
• start_city: STRING(50)
• start_country: STRING(2)
• start_date_local: DATETIME
• start_latitude: FLOAT(prec=11, scale=8)
• start_longitude: FLOAT(prec=11, scale=8)
• start_postal_code: STRING(24)
• start_state: STRING(50)
• status: STRING(2)
• time_zone_id: INTEGER(x32)
• time_zone: STRING(100)
• total_rate: FLOAT(prec=24, scale=4)
• transient_segment_number: INTEGER(x32)
• type: STRING(100)
• upgraded_date_time: DATETIME
• vendor: STRING(100)
• vendor_flags: STRING(100)

Travel Hotels (List of Concur Travel hotel booking details)

• id: STRING(40), PK
• booking_id: STRING(40), FK(Travel Bookings.unique_id)
• itinerary_trip_id: STRING(100), FK(Travel Itineraries.trip_id)
• cancellation_number: STRING(32)
• cancellation_policy: STRING(512)
• checkin_time: STRING(100)
• checkout_time: STRING(100)
• confirmation_number: STRING(32)
• currency: STRING(3)
• daily_rate: FLOAT(prec=24, scale=4)
• date_cancelled_utc: DATETIME
• date_created_utc: DATETIME
• date_modified_utc: DATETIME
• discount_code: STRING(20)
• end_date_local: DATETIME
• equipment_code: STRING(100)
• frequent_traveler_id: STRING(32)
• had_deposit: BOOLEAN
• hotel_property_id: STRING(50)
• is_ghost_card: BOOLEAN
• credit_card_type: STRING(100)
• credit_card_last_four: STRING(4)
• is_preferred_vendor: INTEGER(x32)
• is_upgrade_allowed: BOOLEAN
• modification_code: STRING(100)
• name: STRING(80)
• notes: STRING(512)
• num_persons: INTEGER(x32)
• num_rooms: INTEGER(x32)
• partner_membership_id: STRING(20)
• passive_type: STRING(100)
• phone_number: STRING(30)
• rate_access: STRING(100)
• rate_code: STRING(24)
• rate_type: STRING(1)
• room_description: STRING(200)
• room_type: STRING(24)
• special_instructions: STRING(256)
• start_address: STRING(80)
• start_address_2: STRING(80)
• start_city: STRING(50)
• start_city_code: STRING(12)
• start_country: STRING(2)
• start_date_local: DATETIME
• start_latitude: FLOAT(prec=11, scale=8)
• start_longitude: FLOAT(prec=11, scale=8)
• search_location_latitude: FLOAT(prec=11, scale=8)
• search_location_longitude: FLOAT(prec=11, scale=8)
• start_postal_code: STRING(24)
• start_state: STRING(50)
• status: STRING(2)
• time_zone_id: INTEGER(x32)
• time_zone: STRING(100)
• total_rate: FLOAT(prec=24, scale=4)
• upgraded_date_time: DATETIME
• vendor: STRING(100)
• vendor_name: STRING(100)
• vendor_flags: STRING(100)
• hotel_service_vendor_name: STRING(100)
• hotel_service_localized_vendor_name: STRING(100)

Travel Itineraries (List of Concur Travel itineraries)

• trip_id: STRING(60), PK, FK(Expenses.trip_id)
• id: STRING(1000)
• trip_status: INTEGER(x32)
• trip_name: STRING(500)
• booked_via: STRING(100)
• booked_by_first_name: STRING(100)
• booked_by_last_name: STRING(100)
• has_open_booking_passive: STRING(100)
• user_login_id: STRING(100), FK(Users.login_id)
• client_locator: STRING(100)
• trip_link_locator: STRING(100)
• comments: STRING(512)
• date_booked_local: DATETIME
• date_created_utc: DATETIME
• date_modified_utc: DATETIME
• description: STRING(512)
• end_date_local: DATETIME
• travel_request_id: STRING(100)
• is_personal: BOOLEAN
• project_name: STRING(255)
• start_date_local: DATETIME
• passengers: STRING(* 1)

Travel Notifications (List of Concur travel notifications)

• id: STRING(40), PK
• itinerary_trip_id: STRING(100), FK(Travel Itineraries.trip_id)
• created_by: STRING(100), FK(Users.login_id)
• notify_user: STRING(100), FK(Users.login_id)
• creation_time: DATETIME

Travel Parking (List of Concur Travel parking booking details)

• id: STRING(40), PK
• booking_id: STRING(40), FK(Travel Bookings.unique_id)
• itinerary_trip_id: STRING(100), FK(Travel Itineraries.trip_id)
• cancellation_number: STRING(32)
• class_of_service: STRING(5)
• confirmation_number: STRING(32)
• currency: STRING(3)
• date_cancelled_utc: DATETIME
• date_created_utc: DATETIME
• date_modified_utc: DATETIME
• end_date_local: DATETIME
• frequent_traveler_id: STRING(32)
• is_preferred_vendor: INTEGER(x32)
• is_upgrade_allowed: BOOLEAN
• name: STRING(80)
• notes: STRING(512)
• operated_by_vendor: STRING(128)
• parking_location_id: STRING(50)
• phone_number: STRING(30)
• pin: STRING(10)
• rate_code: STRING(24)
• start_address: STRING(80)
• start_address_2: STRING(80)
• start_city: STRING(50)
• start_city_code: STRING(12)
• start_country: STRING(2)
• start_date_local: DATETIME
• start_location: STRING(10)
• start_postal_code: STRING(24)
• start_state: STRING(50)
• status: STRING(2)
• time_zone_id: INTEGER(x32)
• time_zone: STRING(60)
• total_rate: FLOAT(prec=24, scale=4)
• upgraded_date_time: DATETIME
• vendor: STRING(100)
• vendor_flags: STRING(100)

Travel Rail (List of Concur Travel rail booking details)

• id: STRING(40), PK
• booking_id: STRING(40), FK(Travel Bookings.unique_id)
• itinerary_trip_id: STRING(100), FK(Travel Itineraries.trip_id)
• amenities: STRING(10)
• cabin: STRING(5)
• cancellation_number: STRING(32)
• carbon_emission_lbs: FLOAT(prec=24, scale=4)
• carbon_model: INTEGER(x32)
• class_of_service: STRING(16)
• confirmation_number: STRING(32)
• currency: STRING(3)
• date_cancelled_utc: DATETIME
• date_created_utc: DATETIME
• date_modified_utc: DATETIME
• discount_code: STRING(20)
• duration: INTEGER(x32)
• end_city: STRING(50)
• end_city_code: STRING(12)
• end_country: STRING(2)
• end_date_local: DATETIME
• end_latitude: FLOAT(prec=11, scale=8)
• end_longitude: FLOAT(prec=11, scale=8)
• end_platform: STRING(10)
• end_rail_station: STRING(10)
• end_rail_station_name: STRING(60)
• end_state: STRING(50)
• e_ticket: STRING(100)
• fare_type: STRING(100)
• frequent_traveler_id: STRING(32)
• is_ghost_card: BOOLEAN
• credit_card_type: STRING(100)
• credit_card_last_four: STRING(4)
• is_preferred_vendor: INTEGER(x32)
• is_upgrade_allowed: BOOLEAN
• leg_id: INTEGER(x32)
• meals: STRING(20)
• miles: INTEGER(x32)
• notes: STRING(512)
• num_persons: INTEGER(x32)
• num_stops: INTEGER(x32)
• operated_by_train_number: STRING(12)
• operated_by_vendor: STRING(128)
• rate_code: STRING(24)
• route_restrict_code: STRING(100)
• special_instructions: STRING(128)
• start_city: STRING(50)
• start_city_code: STRING(12)
• start_country: STRING(2)
• start_date_local: DATETIME
• start_latitude: FLOAT(prec=11, scale=8)
• start_longitude: FLOAT(prec=11, scale=8)
• start_platform: STRING(10)
• start_rail_station: STRING(10)
• start_rail_station_name: STRING(60)
• start_state: STRING(50)
• status: STRING(2)
• time_zone_id: INTEGER(x32)
• time_zone: STRING(100)
• total_rate: FLOAT(prec=24, scale=4)
• train_number: STRING(50)
• train_type_code: STRING(12)
• train_type_name: STRING(100)
• transport_mode: STRING(100)
• upgraded_date_time: DATETIME
• vendor: STRING(100)
• vendor_name: STRING(100)
• vendor_flags: STRING(100)
• wagon_number: STRING(10)

Travel Rides (List of Concur Travel rides booking details)

• id: STRING(40), PK
• booking_id: STRING(40), FK(Travel Bookings.unique_id)
• itinerary_trip_id: STRING(100), FK(Travel Itineraries.trip_id)
• cancellation_number: STRING(32)
• cancellation_policy: STRING(512)
• confirmation_number: STRING(32)
• currency: STRING(3)
• date_cancelled_utc: DATETIME
• date_created_utc: DATETIME
• date_modified_utc: DATETIME
• dropoff_instructions: STRING(300)
• duration: INTEGER(x32)
• end_address: STRING(60)
• end_address_2: STRING(60)
• end_city: STRING(50)
• end_city_code: STRING(12)
• end_country: STRING(2)
• end_date_local: DATETIME
• end_latitude: FLOAT(prec=11, scale=8)
• end_location: STRING(60)
• end_location_code: STRING(10)
• end_location_name: STRING(60)
• end_longitude: FLOAT(prec=11, scale=8)
• end_postal_code: STRING(24)
• end_state: STRING(50)
• is_preferred_vendor: INTEGER(x32)
• is_upgrade_allowed: BOOLEAN
• meeting_instructions: STRING(300)
• miles: INTEGER(x32)
• name: STRING(80)
• notes: STRING(512)
• number_of_hours: FLOAT(prec=24, scale=8)
• num_persons: INTEGER(x32)
• operated_by_vendor: STRING(128)
• passive_city_code: STRING(3)
• phone_number: STRING(30)
• pickup_instructions: STRING(300)
• provider_feedback: STRING(300)
• rate: FLOAT(prec=24, scale=4)
• rate_description: STRING(300)
• rate_notes: STRING(512)
• rate_type: STRING(100)
• reservation_id: STRING(50)
• special_instructions: STRING(256)
• start_address: STRING(80)
• start_address_2: STRING(80)
• start_city: STRING(50)
• start_city_code: STRING(12)
• start_country: STRING(2)
• start_date_local: DATETIME
• start_latitude: FLOAT(prec=11, scale=8)
• start_location: STRING(60)
• start_location_code: STRING(10)
• start_location_name: STRING(60)
• start_longitude: FLOAT(prec=11, scale=8)
• start_postal_code: STRING(24)
• start_state: STRING(50)
• status: STRING(2)
• time_zone_id: INTEGER(x32)
• time_zone: STRING(100)
• total_rate: FLOAT(prec=24, scale=4)
• upgraded_date_time: DATETIME
• vendor: STRING(100)
• vendor_name: STRING(100)
• vendor_flags: STRING(100)
• is_ghost_card: BOOLEAN
• credit_card_type: STRING(100)
• credit_card_last_four: STRING(4)

Users (List of Concur users with synchronized reports and/or travel itineraries)

• login_id: STRING(100), PK
• employee_id: STRING(60)
• first_name: STRING(100)
• last_name: STRING(100)
• middle_name: STRING(100)
• primary_email: STRING(500)
• active: BOOLEAN
• cell_phone_number: STRING(500)