Skip to content
English
Contact us
  • There are no suggestions because the search field is empty.

Concur Collectors

Overview

DataBlend currently collects the following Concur data types:

  • Allocation
  • Attendee
  • Budget Categories
  • Budget Items
  • Budget Tracking
  • Expense Comments
  • Expense Entries
  • Expense Group Configuration
  • Expense Report
  • Extract
  • Financial Integration Service
  • Fiscal Year
  • Integration Status
  • Invoice Digest
  • Invoice
  • Invoice Payment Confirmation
  • Itemization
  • List
  • List Item
  • Localized Data
  • Location
  • Payment Batch
  • Purchase Order
  • Purchase Order Receipt
  • Purchase Request
  • Receipt Image
  • User
  • Vendor

Note: SAP Concur versions

SAP Concur is available in multiple editions (Standard Edition, Professional Edition) and may include different module configurations depending on what your organization has licensed. The fields returned when collecting data may vary depending on which version and modules are active on your account.

If you are collecting unexpected fields or missing expected fields, confirm with your Concur administrator which version and modules are enabled.


Configuration
 
Field Required/Optional Comments
Name Required Descriptive free-text name for the collector.
Data Source Required Choose a pre-configured data source from the drop down or click Create New to create a new data source.
Schema Name Required Enter a name for the schema where the collected data will be stored. This can be a pre-configured schema or a new schema which will be created the first time the collector is run.
Credential Required Choose a pre-configured Concur credential from the drop-down.
Object Type Required Utilize the pre-populated Object Type drop-down menu.

To learn more about Concur API requirements, please visit SAP Concur Developer Center | Swagger API Explorer.

 

Collector Type Parameters

When a Collector Type is selected, additional fields may appear depending on the object type. These fields allow you to filter or scope the data collected.

Date format for all date parameters

All date parameters across all object types are recommended to be entered in MM/DD/YYYY format. This applies to all Start Date and End Date fields listed below.

Allocation

  • Expense Report IDs*

  • Entry ID*

  • Itemization ID*

Attendee

  • External ID

  • Attendee Type ID

  • User

Expense Comments

  • Report IDs

  • Context Types

  • User

  • Active Users Only (toggle)

  • Include All Comments (toggle)

  • Created Start Date*

  • Created End Date*

  • Modified Start Date*

  • Modified End Date*

Expense Entries

  • Report ID

  • Context Type*

  • User*

  • Expense ID

Expense Group Configuration

  • User

Expense Report

  • Approval Status

  • Payment Status

  • Has Billable Expenses (toggle)

  • Get Receipt Image (toggle)

  • Include Entries (toggle)

  • Get User (toggle)

  • Created Start Date

  • Created End Date

  • Entry Transaction Start Date

  • Entry Transaction End Date

  • User Defined Start Date

  • User Defined End Date

  • Submit Start Date

  • Submit End Date

  • Processing Payment Start Date

  • Processing Payment End Date

  • Paid Start Date

  • Paid End Date

  • Modified Start Date

  • Modified End Date

Extract

  • Extract Mode

  • Definition*

Financial Integration Service

  • Doc Type*

  • Doc ID

  • System ID

  • Ignore Document Status (toggle)

Integration Status

  • Report ID*

Invoice Digest

How date parameters work for Invoice Digest

The Invoice Digest date parameters use a before/after convention that maps directly to the Concur v3 API query parameters:

  • Start Date fields map to *DateAfter - results are invoices where the date is after the value entered.
  • End Date fields map to *DateBefore - results are invoices where the date is before the value entered.

All date parameters are optional. You may specify only a Start Date, only an End Date, or both. Leaving all date fields blank returns all available records regardless of date.

For more information, see the SAP Concur Developer Center | Retrieve Invoice Digests v3.

Invoice

  • Invoice ID*

Invoice Payment Configuration

  • Pay Status Start Date

  • Pay Status End Date

  • Invoice Start Date

  • Invoice End Date

  • Vendor Name

  • Vendor Code

  • Address Code

  • Invoice Number

Itemization

  • Report ID

  • Expense ID

  • Expense Type Code

  • User ID

List

  • List ID

  • Category ID

List Item

  • Item ID

  • List ID

  • Retrieve Children (toggle)

  • Retrieve Levels (toggle)

Localized Data

  • Data Type*

Location

  • Name

  • City

  • Country Subdivision

  • Country

  • Administrative Region

Payment Batch

  • Mode*

Purchase Order

  • Purchase Order ID*

Purchase Order Receipt

  • Purchase Order Number

  • Line Item External ID

  • Goods Receipt Number

Purchase Request

  • Request ID*

Receipt Image

  • Receipt ID*

User

  • Username

  • Company ID

  • Employee Number

  • External ID

  • Get Spend User (toggle)

  • Get Travel User (toggle)

Vendor

  • Vendor Code

  • Vendor Name

  • Tax ID

  • Buyer Account Number

  • Payment Method Type