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

POST

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)

SAP Concur connector specifications