Establishing a Connection

Create a connection to SAP Concur by navigating to the Connections page in the Sync App application and selecting the corresponding icon in the Add Connections panel. If the SAP Concur icon is not available, click the Add More icon to download and install the SAP Concur connector from the CData site.

Required properties are listed under the Settings tab. The Advanced tab lists connection properties that are not typically required.

Authenticating to SAP Concur

SAP Concur uses the OAuth authentication standard. To authenticate using OAuth, you will need to create an app to obtain the OAuthClientId, OAuthClientSecret, and CallbackURL connection properties. See Using OAuth Authentication for an authentication guide.

Important connection property: LoginId

Login ID of the user. Can be used if the user account associated with the OAuth 2.0 access token has a Concur account with one of these roles: Web Services Administrator for Professional or Can Administer for Standard. Setting the Login ID to "ALL" will retrieve information for all accounts at the expense of certain tables that do not support this argument.

Advanced Features

This section details a selection of advanced features of the SAP Concur Sync App.

User Defined Views

The Sync App allows you to define virtual tables, called user defined views, whose contents are decided by a pre-configured query. These views are useful when you cannot directly control queries being issued to the drivers. See User Defined Views for an overview of creating and configuring custom views.

Firewall and Proxy

Configure the Sync App for compliance with Firewall and Proxy, including Windows proxies and HTTP proxies. You can also set up tunnel connections.

Query Processing

The Sync App offloads as much of the SELECT statement processing as possible to SAP Concur and then processes the rest of the query in memory (client-side).

See Query Processing for more information.

Logging

See Logging for an overview of configuration settings that can be used to refine CData logging. For basic logging, you only need to set two connection properties, but there are numerous features that support more refined logging, where you can select subsets of information to be logged using the LogModules connection property.

Firewall and Proxy

Connecting Through a Firewall or Proxy

HTTP Proxies

To connect through the Windows system proxy, you do not need to set any additional connection properties. To connect to other proxies, set ProxyAutoDetect to false.

In addition, to authenticate to an HTTP proxy, set ProxyAuthScheme, ProxyUser, and ProxyPassword, in addition to ProxyServer and ProxyPort.

Other Proxies

Set the following properties:

To use a proxy-based firewall, set FirewallType, FirewallServer, and FirewallPort.
To tunnel the connection, set FirewallType to TUNNEL.
To authenticate, specify FirewallUser and FirewallPassword.
To authenticate to a SOCKS proxy, additionally set FirewallType to SOCKS5.

Data Model

The Sync App models the Travel/Itinerary API and the Expense API as a relational database, enabling access to Tables and Views like Reports, Entries, and Attendees. Stored Procedures are function-like interfaces to the data source. They can be used to search, update, and modify information in the data source -- for example, CancelTrip.

Customizing Schemas

The database objects are defined in schema files, which are simple, text-based configuration files that make schemas easy to customize and extend.

By default the schemas are located in the db subfolder of the installation directory. Set the Location to use a different folder. Call the CreateSchema stored procedure to save a schema file.

Using Query Processing

The Sync App offloads as much of the SELECT statement processing as possible to the SAP Concur APIs and then processes the rest of the query within the Sync App. The following sections document API limitations and requirements. See SupportEnhancedSQL for more information on how the Sync App circumvents API limitations with in-memory client-side processing.

Tables

The Sync App models the data in SAP Concur into a list of tables that can be queried using standard SQL statements.

Generally, querying SAP Concur tables is the same as querying a table in a relational database. Sometimes there are special cases, for example, including a certain column in the WHERE clause might be required to get data for certain columns in the table. This is typically needed for situations where a separate request must be made for each row to get certain columns. These types of situations are clearly documented at the top of the table page linked below.

SAP Concur Connector for CData Sync Tables


Name	Description
Attendees	Create, update, delete, and query all attendees owned by the specified user.
AttendeeTypes	Create, update, delete, and query all active attendee types for the company.
Entries	Create, update, delete, and query all expense entries owned by the user.
EntryAttendeeAssociations	Create, update, delete, and query all entry-attendee associations owned by the user. These are the associations between an expense entry and an attendee.
Itemizations	Create, update, delete, and query all expense itemizations owned by the user.
ListItems	Create, update, delete, and query all list items based on the search criteria.
Lists	Create, update, delete, and query all lists based on the search criteria.
ReceiptImages	Create, update, delete, and query all receipt Ids owned by the user.
Reports	Create, update, delete, and query all reports owned by the user.

Attendees

Create, update, delete, and query all attendees owned by the specified user.

Table Specific Information

Select

The Sync App uses the SAP Concur APIs to process filters that refer to Id or to AttendeeTypeId and LoginId. The Sync App processes other filters client-side within the Sync App.

For example, the Sync App will offload the processing of the following queries to the SAP Concur APIs:

SELECT * FROM Attendees WHERE Id = 'attendeeId'
SELECT * FROM Attendees WHERE AttendeeTypeId = 'attendeeTypeId' AND LoginId = 'loginID'

Insert

To insert an attendee the following columns are required: AttendeeTypeId and LastName.

INSERT INTO Attendees (AttendeeTypeId, FirstName, LastName, Company, CurrencyCode, MiddleInitial, Suffix, Title, TotalAmountYTD) VALUES ('IdValue', 'John', 'Doe', 'CDATA', 'USD', 'C', 'SuffixValue', 'TitleValue', 1000);

Update

To update an attendee the following column is required: Id.

UPDATE Attendees SET LastName = 'newlastname' WHERE ID = '123456'

Delete

Deletes are not supported for this table.

Columns


Name	Type	ReadOnly	References	Description
ID [KEY]	String	True		The unique identifier of the resource.
Custom10ListItemID	String	True		For list fields, this is the list item ID.
AttendeeTypeID	String	False		The ID of the attendee type.
Custom11ListItemID	String	True		For list fields, this is the list item ID.
Custom12ListItemID	String	True		For list fields, this is the list item ID.
Custom13ListItemID	String	True		For list fields, this is the list item ID.
Custom14ListItemID	String	True		For list fields, this is the list item ID.
Custom15ListItemID	String	True		For list fields, this is the list item ID.
Custom16ListItemID	String	True		For list fields, this is the list item ID.
Custom17ListItemID	String	True		For list fields, this is the list item ID.
Custom18ListItemID	String	True		For list fields, this is the list item ID.
Custom19ListItemID	String	True		For list fields, this is the list item ID.
Custom1ListItemID	String	True		For list fields, this is the list item ID.
Custom20ListItemID	String	True		For list fields, this is the list item ID.
Custom21ListItemID	String	True		For list fields, this is the list item ID.
Custom22ListItemID	String	True		For list fields, this is the list item ID.
Custom23ListItemID	String	True		For list fields, this is the list item ID.
Custom24ListItemID	String	True		For list fields, this is the list item ID.
Custom25ListItemID	String	True		For list fields, this is the list item ID.
Custom2ListItemID	String	True		For list fields, this is the list item ID.
Custom3ListItemID	String	True		For list fields, this is the list item ID.
Custom4ListItemID	String	True		For list fields, this is the list item ID.
Custom5ListItemID	String	True		For list fields, this is the list item ID.
Custom6ListItemID	String	True		For list fields, this is the list item ID.
Custom7ListItemID	String	True		For list fields, this is the list item ID.
Custom8ListItemID	String	True		For list fields, this is the list item ID.
Custom9ListItemID	String	True		For list fields, this is the list item ID.
ExternalID	String	False		A unique identifier for the attendee, assigned outside of Concur. Maximum length: 48 characters
MiddleInitial	String	False		The attendee's middle initial. Maximum length: 1 character
OwnerLoginID	String	True		The login ID of the user who owns the attendee record.
AttendeeTypeCode	String	True		A code that indicates the type of attendee. Examples: EMPLOYEE, SPOUSE, BUSGUEST. Maximum length: 40 characters
Company	String	False		The name of the attendee's company. Maximum length: 150 characters
CurrencyCode	String	False		The ISO 4217 currency code for monetary amounts related to an attendee.
Custom10Code	String	True		For list fields, this is the list item code.
Custom10Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom10Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom11Code	String	True		For list fields, this is the list item code.
Custom11Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom11Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom12Code	String	True		For list fields, this is the list item code.
Custom12Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom12Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom13Code	String	True		For list fields, this is the list item code.
Custom13Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom13Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom14Code	String	True		For list fields, this is the list item code.
Custom14Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom14Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom15Code	String	True		For list fields, this is the list item code.
Custom15Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom15Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom16Code	String	True		For list fields, this is the list item code.
Custom16Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom16Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom17Code	String	True		For list fields, this is the list item code.
Custom17Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom17Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom18Code	String	True		For list fields, this is the list item code.
Custom18Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom18Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom19Code	String	True		For list fields, this is the list item code.
Custom19Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom19Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom1Code	String	True		For list fields, this is the list item code.
Custom1Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom1Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom20Code	String	True		For list fields, this is the list item code.
Custom20Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom20Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom21Code	String	True		For list fields, this is the list item code.
Custom21Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom21Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom22Code	String	True		For list fields, this is the list item code.
Custom22Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom22Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom23Code	String	True		For list fields, this is the list item code.
Custom23Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom23Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom24Code	String	True		For list fields, this is the list item code.
Custom24Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom24Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom25Code	String	True		For list fields, this is the list item code.
Custom25Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom25Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom2Code	String	True		For list fields, this is the list item code.
Custom2Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom2Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom3Code	String	True		For list fields, this is the list item code.
Custom3Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom3Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom4Code	String	True		For list fields, this is the list item code.
Custom4Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom4Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom5Code	String	True		For list fields, this is the list item code.
Custom5Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom5Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom6Code	String	True		For list fields, this is the list item code.
Custom6Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom6Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom7Code	String	True		For list fields, this is the list item code.
Custom7Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom7Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom8Code	String	True		For list fields, this is the list item code.
Custom8Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom8Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom9Code	String	True		For list fields, this is the list item code.
Custom9Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom9Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
FirstName	String	False		The attendee's first name. Maximum length: 50 characters
HasExceptionsPrevYear	Bool	True		Determines whether the attendee had exceptions in the previous year, based on yearly total limits for attendees. Format: true or false
HasExceptionsYTD	Bool	True		Determines whether the attendee has exceptions in the current year, based on yearly total limits for attendees. Format: true or false
LastName	String	False		The attendee's last name. Maximum length: 132 characters
OwnerName	String	True		The name of the user who owns the attendee record.
Suffix	String	False		The attendee's name suffix. Maximum length: 32 characters
Title	String	False		The attendee's title. Maximum length: 32 characters
TotalAmountPrevYear	Decimal	True		The total amount spent on the attendee in the previous calendar year.
TotalAmountYTD	Decimal	False		The total amount spent on the attendee in the current calendar year.
URI	String	True		The URI to the resource.
VersionNumber	Int	True		The attendee's version number.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
LoginId	String	The login ID of the user that has added the attendee to an expense. The user who is performing this API request must have the Web Services Admin (Professional) or Can Administer (Standard) user role to use this parameter.

AttendeeTypes

Create, update, delete, and query all active attendee types for the company.

Table Specific Information

Select

The Sync App uses the SAP Concur APIs to process a filter that refers to Id. The Sync App processes other filters client-side within the Sync App.

For example, the Sync App will offload the processing of the following query to the SAP Concur APIs:

SELECT * FROM AttendeeTypes WHERE Id = '123456'

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false.

Insert

To insert an attendee type the following columns are required: Name, Code, AttendeeFormId, and DuplicateSearchFields.

INSERT INTO AttendeeTypes (Name, Code, AttendeeFormId, DuplicateSearchFields) VALUES ('AttendeeTypeName','01234', '123456', 'Title,Company')

Update

Updates are not supported for this table.

Delete

Deletes are not supported for this table.

Columns


Name	Type	ReadOnly	References	Description
ID [KEY]	String	True		The URI of the next page of results, if any.
AttendeeFormID	String	False		The unique identifier for the attendee form for this attendee type.
ConnectorID	String	False		The unique identifier for the Application Connector that is the data source for this attendee type. When this field is empty, the Expense database is the data source.
AllowAttendeeCountEditing	Bool	False		Determines whether users are allowed to edit the count for this attendee type. Format: true or false
AllowManuallyEnteredAttendees	Bool	False		Determines whether users are allowed to add attendees for this attendee type. Format: true or false
Code	String	False		A code that indicates the type of attendee. Examples: EMPLOYEE, SPOUSE, BUSGUEST. Maximum length: 40 characters
DuplicateSearchFields	String	False		The list of Attendee field IDs used by the Add Attendee user interface to alert users that the attendee they want to add is a possible duplicate. This parent element has a DuplicateSearchField child element for each field ID.
Name	String	False		The name for the attendee type. This name must be unique. Maximum length: 40 characters
URI	String	True		The URI of the next page of results, if any.

Entries

Create, update, delete, and query all expense entries owned by the user.

Table Specific Information

Select

The Sync App uses the SAP Concur APIs to process filters that refer to ReportID, PaymentTypeID, BatchID_p, IsBillable, AttendeeTypeCode_p, HasAttendees, HasVAT, ExpenseTypeCode, or AttendeeID_p. The Sync App processes other filters client-side within the Sync App.

For example, the Sync App will offload the processing of the following query to the SAP Concur APIs:

SELECT * FROM Entries WHERE ReportID = 'IdReport' AND PaymentTypeID = 'IdPaymentType' AND BatchID_p = 'IdBatch' AND IsBillable = 'true' AND AttendeeTypeCode_p = '123' AND HasAttendees = 'true' AND HasVAT = 'false' AND ExpenseTypeCode = 'code' AND AttendeeID_p='IdAttendee'

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false.

Insert

To insert an entry the following columns are required: ReportId, ExpenseTypeCode, TransactionDate, PaymentTypeId, TransactionCurrencyCode, and TransactionAmount.

INSERT INTO Entries (ReportId, ExpenseTypeCode, PaymentTypeId, TransactionCurrencyCode, TransactionAmount, TransactionDate) VALUES ('ReportIdValue', 'TAXIX', 'PaymentTypeIdValue', 'USD', 1000, '01-01-2017')

Update

To update an entry the following column is required: Id.

UPDATE Entries SET  ReportId='ReportIdValue', ExpenseTypeCode='TAXIX', PaymentTypeId='PaymentTypeIdValue', TransactionCurrencyCode='USD', TransactionAmount=100 WHERE Id='12334'

Delete

To delete an entry the following column is required: Id.

DELETE FROM Entries WHERE Id = '12345'

Columns


Name	Type	ReadOnly	References	Description
ID [KEY]	String	True		The unique identifier of the resource.
CompanyCardTransactionID	String	True		The unique identifier for a company card transaction that is associated with this expense. Concur Expense uses the Credit Card Import job to import company card transactions. Use the GET CommpanyCardTransactions function to get information about these card transactions. This element is null when there is no company card transaction associated with this expense.
Custom10ListItemID	String	True		For list fields, this is the list item ID.
Custom11ListItemID	String	True		For list fields, this is the list item ID.
Custom12ListItemID	String	True		For list fields, this is the list item ID.
Custom13ListItemID	String	True		For list fields, this is the list item ID.
Custom14ListItemID	String	True		For list fields, this is the list item ID.
Custom15ListItemID	String	True		For list fields, this is the list item ID.
Custom16ListItemID	String	True		For list fields, this is the list item ID.
Custom17ListItemID	String	True		For list fields, this is the list item ID.
Custom18ListItemID	String	True		For list fields, this is the list item ID.
Custom19ListItemID	String	True		For list fields, this is the list item ID.
Custom1ListItemID	String	True		For list fields, this is the list item ID.
Custom20ListItemID	String	True		For list fields, this is the list item ID.
Custom21ListItemID	String	True		For list fields, this is the list item ID.
Custom22ListItemID	String	True		For list fields, this is the list item ID.
Custom23ListItemID	String	True		For list fields, this is the list item ID.
Custom24ListItemID	String	True		For list fields, this is the list item ID.
Custom25ListItemID	String	True		For list fields, this is the list item ID.
Custom26ListItemID	String	True		For list fields, this is the list item ID.
Custom27ListItemID	String	True		For list fields, this is the list item ID.
Custom28ListItemID	String	True		For list fields, this is the list item ID.
Custom29ListItemID	String	True		For list fields, this is the list item ID.
Custom2ListItemID	String	True		For list fields, this is the list item ID.
Custom30ListItemID	String	True		For list fields, this is the list item ID.
Custom31ListItemID	String	True		For list fields, this is the list item ID.
Custom32ListItemID	String	True		For list fields, this is the list item ID.
Custom33ListItemID	String	True		For list fields, this is the list item ID.
Custom34ListItemID	String	True		For list fields, this is the list item ID.
Custom35ListItemID	String	True		For list fields, this is the list item ID.
Custom36ListItemID	String	True		For list fields, this is the list item ID.
Custom37ListItemID	String	True		For list fields, this is the list item ID.
Custom38ListItemID	String	True		For list fields, this is the list item ID.
Custom39ListItemID	String	True		For list fields, this is the list item ID.
Custom3ListItemID	String	True		For list fields, this is the list item ID.
Custom40ListItemID	String	True		For list fields, this is the list item ID.
Custom4ListItemID	String	True		For list fields, this is the list item ID.
Custom5ListItemID	String	True		For list fields, this is the list item ID.
Custom6ListItemID	String	True		For list fields, this is the list item ID.
Custom7ListItemID	String	True		For list fields, this is the list item ID.
Custom8ListItemID	String	True		For list fields, this is the list item ID.
Custom9ListItemID	String	True		For list fields, this is the list item ID.
ElectronicReceiptID	String	True		The unique identifier for an eReceipt that is associated with this expense. Use the GET eReceipts function to get information about this eReceipt. This element is null when there is no eReceipt associated with this expense.
EmployeeBankAccountID	String	True		The unique identifier of an employee bank account that is associated with this expense. Typically, this element is used when Expense Pay reimburses the employee for this expense. Use the GET BankAccounts function to get information about this bank account.
FormID	String	True		The ID of the form used by this expense entry.
IsPaidByExpensePay	Bool	True		Whether the entry is paid using the Expense Pay service. This element has a value if the report has reached the Processing Payment workflow step, because this is when Concur Expense determines whether it will be paid by Expense Pay. Format: true or false
JourneyVehicleID	String	False		The unique identifier for the vehicle used for this journey. This element is used only with Company Car configuration types. Use the GET Vehicles function to learn the Vehicle ID.
LocationID	String	False		The unique identifier for the location where the expense was incurred.
OrgUnit1ListItemID	String	True		For list fields, this is the list item ID.
OrgUnit2ListItemID	String	True		For list fields, this is the list item ID.
OrgUnit3ListItemID	String	True		For list fields, this is the list item ID.
OrgUnit4ListItemID	String	True		For list fields, this is the list item ID.
OrgUnit5ListItemID	String	True		For list fields, this is the list item ID.
OrgUnit6ListItemID	String	True		For list fields, this is the list item ID.
PaymentTypeID	String	False		The ID of the payment type for the entry. For mileage expenses, use the Cash payment type. For expense types with an expense code that uses a transaction amount instead of a distance, this element is required. This element should not be used for expense types with an expense code for Company Car or Personal Car, because these two expense codes always use the Cash payment type.
ReportID	String	False		The report ID of the report where the entry will be added.
ReportOwnerID	String	True		The login ID of the report owner. Use the GET User Information function to learn details about this user.
TripID	String	True		The unique identifier of a trip in the Itinerary Service that includes a travel booking associated with this expense. Use GET ItineraryDetails to get information about this trip and the travel booking. This element is null when there is no trip associated with the expense.
VendorListItemID	String	False		The unique identifier for a vendor list item.
AllocationType	String	True		The type of allocations for the expense. Possible values: P - partial allocation, F - full allocation, N - no allocation.
ApprovedAmount	Decimal	True		The approved amount of the expense entry, in the report currency.
Custom10Code	String	True		For list fields, this is the list item code.
Custom10Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom10Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom11Code	String	True		For list fields, this is the list item code.
Custom11Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom11Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom12Code	String	True		For list fields, this is the list item code.
Custom12Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom12Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom13Code	String	True		For list fields, this is the list item code.
Custom13Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom13Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom14Code	String	True		For list fields, this is the list item code.
Custom14Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom14Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom15Code	String	True		For list fields, this is the list item code.
Custom15Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom15Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom16Code	String	True		For list fields, this is the list item code.
Custom16Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom16Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom17Code	String	True		For list fields, this is the list item code.
Custom17Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom17Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom18Code	String	True		For list fields, this is the list item code.
Custom18Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom18Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom19Code	String	True		For list fields, this is the list item code.
Custom19Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom19Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom1Code	String	True		For list fields, this is the list item code.
Custom1Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom1Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom20Code	String	True		For list fields, this is the list item code.
Custom20Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom20Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom21Code	String	True		For list fields, this is the list item code.
Custom21Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom21Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom22Code	String	True		For list fields, this is the list item code.
Custom22Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom22Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom23Code	String	True		For list fields, this is the list item code.
Custom23Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom23Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom24Code	String	True		For list fields, this is the list item code.
Custom24Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom24Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom25Code	String	True		For list fields, this is the list item code.
Custom25Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom25Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom26Code	String	True		For list fields, this is the list item code.
Custom26Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom26Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom27Code	String	True		For list fields, this is the list item code.
Custom27Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom27Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom28Code	String	True		For list fields, this is the list item code.
Custom28Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom28Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom29Code	String	True		For list fields, this is the list item code.
Custom29Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom29Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom2Code	String	True		For list fields, this is the list item code.
Custom2Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom2Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom30Code	String	True		For list fields, this is the list item code.
Custom30Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom30Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom31Code	String	True		For list fields, this is the list item code.
Custom31Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom31Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom32Code	String	True		For list fields, this is the list item code.
Custom32Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom32Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom33Code	String	True		For list fields, this is the list item code.
Custom33Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom33Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom34Code	String	True		For list fields, this is the list item code.
Custom34Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom34Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom35Code	String	True		For list fields, this is the list item code.
Custom35Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom35Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom36Code	String	True		For list fields, this is the list item code.
Custom36Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom36Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom37Code	String	True		For list fields, this is the list item code.
Custom37Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom37Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom38Code	String	True		For list fields, this is the list item code.
Custom38Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom38Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom39Code	String	True		For list fields, this is the list item code.
Custom39Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom39Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom3Code	String	True		For list fields, this is the list item code.
Custom3Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom3Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom40Code	String	True		For list fields, this is the list item code.
Custom40Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom40Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom4Code	String	True		For list fields, this is the list item code.
Custom4Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom4Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom5Code	String	True		For list fields, this is the list item code.
Custom5Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom5Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom6Code	String	True		For list fields, this is the list item code.
Custom6Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom6Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom7Code	String	True		For list fields, this is the list item code.
Custom7Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom7Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom8Code	String	True		For list fields, this is the list item code.
Custom8Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom8Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom9Code	String	True		For list fields, this is the list item code.
Custom9Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom9Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Description	String	False		The description of the expense. Maximum length: 64 characters
ExchangeRate	Decimal	False		The currency conversion rate that converts the transaction amount that is in the transaction currency into the posted amount that is in the report currency. This element is typically not provided. If this element is empty for transactions in a currency different than the user's reimbursement currency, Expense will use the company's configured exchange rates to determine the posted amount for the transaction. If the system is not able to determine the exchange rate, a value of 1.0 will be used.
ExpenseTypeCode	String	False		The code for the expense type.
ExpenseTypeName	String	True		The name of the expense type, localized to the user's language.
HasAppliedCashAdvance	Bool	True		Whether the entry has a cash advance applied to it. Use the GET ExpenseEntryAccountingCalculations function to get cash advance application information for this entry. Format: true or false
HasAttendees	Bool	True		Indicates whether the expense has attendees. Format: true or false
HasComments	Bool	True		Whether the expense has comments. Use the GET ExpenseEntryComments function to get information about this entry's comments. Format: true or false
HasExceptions	Bool	True		Whether the expense has exceptions. Use the GET ExpenseEntryExceptions function to get information about this entry's exceptions. Format: true or false
HasImage	Bool	True		Indicates whether there is an entry image attached to the entry. Use the GET Entry Images function to get this entry image. Format: true or false
HasItemizations	Bool	True		Indicates whether the expense has itemizations. Use the Format: true or false
HasVAT	Bool	True		Indicates whether the entry has VAT data. Use the GET ExpenseEntryAccountingCalculations function to get VAT information for this entry. Format: true or false
IsBillable	Bool	False		Indicates whether the expense is billable. Format: true or false
IsImageRequired	Bool	True		Indicates whether an entry image is required for the entry. Format: true or false
IsPersonal	Bool	False		Indicates whether the expense is personal (that is, non-reimbursable). Format: true or false
IsPersonalCardCharge	Bool	True		Indicates whether the expense entry was imported from a personal card feed. Concur Expense uses the Yodlee API to import these card transactions. Format: true or false
JourneyBusinessDistance	Int	False		The portion of the journey for business use, in the report owner's unit of measure for distances. This element is required in order to post a personal car mileage expense entry, or to post a company car mileage expense when there is no PersonalDistance value. Format: positive integer. When using the Odometer elements, the sum of PersonalDistance and BusinessDistance must equal the difference between OdometerEnd and OdometerStart.
JourneyEndLocation	String	False		Indicates where the journey ended. This is also known as the
JourneyNumberOfPassengers	Int	False		The number of people in the vehicle during the journey. Positive Integer. Used with Variable-Rate, Personal or Company Car.
JourneyOdometerEnd	Int	False		The odometer reading at the end of the journey. Format: positive integer that must be greater than the OdometerStart value. This element is used with Variable-Rate and Company Car configuration types.
JourneyOdometerStart	Int	False		The odometer reading at the start of the journey. Format: positive integer. This element is used with Variable-Rate and Company Car configuration types.
JourneyPersonalDistance	Int	False		The portion of the journey for personal use. This element is required in order to post a company car mileage expense when there is no BusinessDistance value. Format: positive integer. When using the Odometer elements, the sum of PersonalDistance and BusinessDistance must equal the difference between OdometerEnd and OdometerStart. Used with Company Car configuration types.
JourneyStartLocation	String	False		Indicates where the journey started. This is also known as the
JourneyUnitOfMeasure	String	False		The unit of measure for distance and odometer values. Possible values: M - miles, K - kilometers
LastModified	Datetime	True		The UTC date when the entry was last modified.
LocationCountry	String	True		The country where the expense was incurred. Format: 2-letter ISO 3166-1 country code
LocationName	String	True		The location where the expense was incurred, usually the city name.
LocationSubdivision	String	True		The state, province, or other country subdivision where the expense was incurred. Format: ISO 3166-2:2007 country subdivision
OrgUnit1Code	String	True		For list fields, this is the list item code.
OrgUnit1Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
OrgUnit1Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
OrgUnit2Code	String	True		For list fields, this is the list item code.
OrgUnit2Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
OrgUnit2Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
OrgUnit3Code	String	True		For list fields, this is the list item code.
OrgUnit3Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
OrgUnit3Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
OrgUnit4Code	String	True		For list fields, this is the list item code.
OrgUnit4Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
OrgUnit4Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
OrgUnit5Code	String	True		For list fields, this is the list item code.
OrgUnit5Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
OrgUnit5Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
OrgUnit6Code	String	True		For list fields, this is the list item code.
OrgUnit6Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
OrgUnit6Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
PaymentTypeName	String	True		The name of the payment type, localized to the user's language.
PostedAmount	Decimal	True		The amount of the expense entry, in the report currency.
ReceiptReceived	Bool	True		Indicates whether this entry has been reviewed by a processor. Format: true or false
SpendCategoryCode	String	True		The ID of the spending category that is specified for this expense entry.
SpendCategoryName	String	True		The name of the spending category that is specified for this expense entry, localized to the user's language.
TaxReceiptType	String	False		The receipt type for this entry. Possible values: T - tax receipt, R - regular receipt, N - no receipt
TransactionAmount	Decimal	False		The amount of the expense entry, in the transaction currency paid to the vendor. For expense types with an expense code that uses a transaction amount instead of a distance, this element is required. This element should not be used for expense types with an expense code for Company Car or Personal Car, because these two expense codes use a distance instead of a transaction amount.
TransactionCurrencyCode	String	False		The 3-letter ISO 4217 currency code for the expense entry transaction amount. This is the currency in which the vendor was paid. For expense types with an expense code that uses a transaction amount instead of a distance, this element is required. This element should not be used for expense types with an expense code for Company Car or Personal Car, because for these two expense codes the currency is always the Report Currency.
TransactionDate	Datetime	False		The date when the good or service associated with this expense entry was provided. Format: YYYY-MM-DD
URI	String	True		The URI to the resource.
VendorDescription	String	False		The name of the vendor for the expense entry. Maximum length: 64 characters
VendorListItemName	String	True		The name of an item from a vendor list.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
AttendeeID_p	String	The attendee associated with the entries to be retrieved.
AttendeeTypeCode_p	String	The ID of the attendee type for the entries to be retrieved.
LoginId	String	The login ID of the user who owns the entries. The user must have the Web Services Admin role to use this parameter.
BatchID_p	String	The batch ID for the entries to be retrieved. The batch ID identifies the batch that contains the report payee associated with the entries. Use the GET Payment Batch function to learn the Payment Type ID for the desired Payment Type.

EntryAttendeeAssociations

Create, update, delete, and query all entry-attendee associations owned by the user. These are the associations between an expense entry and an attendee.

Table Specific Information

Select

The Sync App uses the SAP Concur APIs to process filters that refer to Id or to EntryId and LoginId. The Sync App processes other filters client-side within the Sync App.

For example, the Sync App will offload the processing of the following queries to the SAP Concur APIs:

SELECT * FROM EntryAttendeeAssociations WHERE Id = 'sampleId'
SELECT * FROM EntryAttendeeAssociations WHERE EntryId = 'sampleEntryId' AND LoginId = 'LoginId'

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false.

Insert

To insert a new record in EntryAttendeeAssociations the following columns are required: EntryId and AttendeeId.

INSERT INTO EntryAttendeeAssociations (EntryId, AttendeeId) VALUES ('EntryIdValue', 'AttendeeIdValue')

Update

To update a record in EntryAttendeeAssociations the following column is required: Id. The EntryId and AttendeeId columns cannot be updated.

UPDATE EntryAttendeeAssociations SET Custom='Custom' WHERE Id='12345'

Delete

To delete a department, the following column is required: Id.

DELETE FROM EntryAttendeeAssociations WHERE Id = '123456'

Columns


Name	Type	ReadOnly	References	Description
ID [KEY]	String	True		The primary key.
AttendeeID	String	False		The unique identifier of the associated attendee. To obtain the attendee ID value, use the GET /expense/attendees endpoint. The value of the ID element in the response is the attendee ID.
EntryID	String	False		The unique identifier of the associated entry. To obtain the attendee ID value, use the GET /expense/entries endpoint. The value of the ID element in the response is the entry ID.
Amount	Decimal	False		The portion of the entry transaction amount assigned to this attendee.
AssociatedAttendeeCount	Int	False		The count of additional attendees associated with this attendee. A count greater than 1 means there are unnamed attendees associated with this attendee.
Custom1	String	False		The details from the Custom fields. These fields may not have data, depending on the configuration.
Custom2	String	False		The details from the Custom fields. These fields may not have data, depending on the configuration.
Custom3	String	False		The details from the Custom fields. These fields may not have data, depending on the configuration.
Custom4	String	False		The details from the Custom fields. These fields may not have data, depending on the configuration.
Custom5	String	False		The details from the Custom fields. These fields may not have data, depending on the configuration.
URI	String	True		null

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
LoginId	String	The login ID of the user who owns this entry-attendee association. The user must have the Web Services Admin role to use this parameter.

Itemizations

Create, update, delete, and query all expense itemizations owned by the user.

Table Specific Information

Select

The Sync App uses the SAP Concur APIs to process filters that refer to Id or to any combination of ReportID, EntryID, ExpenseTypeCode, and LoginId, as in the following queries. The Sync App processes other filters client-side within the Sync App.

For example, the following queries are processed server side:

SELECT * FROM Itemizations WHERE Id = 'sampleId'
SELECT * FROM Itemizations WHERE ReportID = 'sampleReportID' AND EntryId = 'sampleEntryId' AND ExpenseTypeCode = 'code' AND LoginId = 'LoginId'

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false.

Insert

To insert an itemization the following columns are required: EntryId, ExpenseTypeCode, TransactionDate, and TransactionAmount.

INSERT INTO Itemizations (EntryId, ExpenseTypeCode, TransactionDate, TransactionAmount, IsBillable, IsPersonal, Custom1Value) VALUES ('EntryId', 'TAXIX', '01-01-2017', 1000, true, true, 'Custom1Value')

Update

To update an itemization, the following column is required: Id.

UPDATE Itemizations SET TransactionDate='01-02-2017', TransactionAmount=2000, IsBillable=false, IsPersonal=false, Custom1Value='Custom1Value' WHERE Id='12345'

Delete

To delete an itemization, the following column is required: Id.

DELETE FROM Itemizations WHERE Id = '123456'

Columns


Name	Type	ReadOnly	References	Description
ID [KEY]	String	True		The primary key.
Custom10ListItemID	String	True		For list fields, this is the list item ID.
Custom11ListItemID	String	True		For list fields, this is the list item ID.
Custom12ListItemID	String	True		For list fields, this is the list item ID.
Custom13ListItemID	String	True		For list fields, this is the list item ID.
Custom14ListItemID	String	True		For list fields, this is the list item ID.
Custom15ListItemID	String	True		For list fields, this is the list item ID.
Custom16ListItemID	String	True		For list fields, this is the list item ID.
Custom17ListItemID	String	True		For list fields, this is the list item ID.
Custom18ListItemID	String	True		For list fields, this is the list item ID.
Custom19ListItemID	String	True		For list fields, this is the list item ID.
Custom1ListItemID	String	True		For list fields, this is the list item ID.
Custom20ListItemID	String	True		For list fields, this is the list item ID.
Custom21ListItemID	String	True		For list fields, this is the list item ID.
Custom22ListItemID	String	True		For list fields, this is the list item ID.
Custom23ListItemID	String	True		For list fields, this is the list item ID.
Custom24ListItemID	String	True		For list fields, this is the list item ID.
Custom25ListItemID	String	True		For list fields, this is the list item ID.
Custom26ListItemID	String	True		For list fields, this is the list item ID.
Custom27ListItemID	String	True		For list fields, this is the list item ID.
Custom28ListItemID	String	True		For list fields, this is the list item ID.
Custom29ListItemID	String	True		For list fields, this is the list item ID.
Custom2ListItemID	String	True		For list fields, this is the list item ID.
Custom30ListItemID	String	True		For list fields, this is the list item ID.
Custom31ListItemID	String	True		For list fields, this is the list item ID.
Custom32ListItemID	String	True		For list fields, this is the list item ID.
Custom33ListItemID	String	True		For list fields, this is the list item ID.
Custom34ListItemID	String	True		For list fields, this is the list item ID.
Custom35ListItemID	String	True		For list fields, this is the list item ID.
Custom36ListItemID	String	True		For list fields, this is the list item ID.
Custom37ListItemID	String	True		For list fields, this is the list item ID.
Custom38ListItemID	String	True		For list fields, this is the list item ID.
Custom39ListItemID	String	True		For list fields, this is the list item ID.
Custom3ListItemID	String	True		For list fields, this is the list item ID.
Custom40ListItemID	String	True		For list fields, this is the list item ID.
Custom4ListItemID	String	True		For list fields, this is the list item ID.
Custom5ListItemID	String	True		For list fields, this is the list item ID.
Custom6ListItemID	String	True		For list fields, this is the list item ID.
Custom7ListItemID	String	True		For list fields, this is the list item ID.
Custom8ListItemID	String	True		For list fields, this is the list item ID.
Custom9ListItemID	String	True		For list fields, this is the list item ID.
EntryID	String	False		The ID of the expense entry that is the parent for the itemization.
LocationID	String	True		The unique identifier for the location where the expense was incurred.
OrgUnit1ListItemID	String	True		For list fields, this is the list item ID.
OrgUnit2ListItemID	String	True		For list fields, this is the list item ID.
OrgUnit3ListItemID	String	True		For list fields, this is the list item ID.
OrgUnit4ListItemID	String	True		For list fields, this is the list item ID.
OrgUnit5ListItemID	String	True		For list fields, this is the list item ID.
OrgUnit6ListItemID	String	True		For list fields, this is the list item ID.
ReportID	String	True		The ID of the report that is the parent for the itemization.
ReportOwnerID	String	True		The login ID for the report owner. Use the GET User endpoint to learn details about this user.
AllocationType	String	True		The type of allocation for the itemization. Possible values: P - partial allocation, F - full allocation, N - no allocation.
ApprovedAmount	Decimal	True		The approved amount of the expense itemization, in the report currency.
Custom10Code	String	True		For list fields, this is the list item code.
Custom10Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom10Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom11Code	String	True		For list fields, this is the list item code.
Custom11Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom11Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom12Code	String	True		For list fields, this is the list item code.
Custom12Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom12Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom13Code	String	True		For list fields, this is the list item code.
Custom13Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom13Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom14Code	String	True		For list fields, this is the list item code.
Custom14Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom14Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom15Code	String	True		For list fields, this is the list item code.
Custom15Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom15Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom16Code	String	True		For list fields, this is the list item code.
Custom16Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom16Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom17Code	String	True		For list fields, this is the list item code.
Custom17Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom17Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom18Code	String	True		For list fields, this is the list item code.
Custom18Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom18Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom19Code	String	True		For list fields, this is the list item code.
Custom19Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom19Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom1Code	String	True		For list fields, this is the list item code.
Custom1Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom1Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom20Code	String	True		For list fields, this is the list item code.
Custom20Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom20Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom21Code	String	True		For list fields, this is the list item code.
Custom21Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom21Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom22Code	String	True		For list fields, this is the list item code.
Custom22Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom22Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom23Code	String	True		For list fields, this is the list item code.
Custom23Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom23Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom24Code	String	True		For list fields, this is the list item code.
Custom24Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom24Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom25Code	String	True		For list fields, this is the list item code.
Custom25Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom25Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom26Code	String	True		For list fields, this is the list item code.
Custom26Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom26Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom27Code	String	True		For list fields, this is the list item code.
Custom27Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom27Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom28Code	String	True		For list fields, this is the list item code.
Custom28Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom28Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom29Code	String	True		For list fields, this is the list item code.
Custom29Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom29Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom2Code	String	True		For list fields, this is the list item code.
Custom2Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom2Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom30Code	String	True		For list fields, this is the list item code.
Custom30Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom30Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom31Code	String	True		For list fields, this is the list item code.
Custom31Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom31Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom32Code	String	True		For list fields, this is the list item code.
Custom32Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom32Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom33Code	String	True		For list fields, this is the list item code.
Custom33Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom33Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom34Code	String	True		For list fields, this is the list item code.
Custom34Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom34Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom35Code	String	True		For list fields, this is the list item code.
Custom35Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom35Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom36Code	String	True		For list fields, this is the list item code.
Custom36Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom36Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom37Code	String	True		For list fields, this is the list item code.
Custom37Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom37Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom38Code	String	True		For list fields, this is the list item code.
Custom38Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom38Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom39Code	String	True		For list fields, this is the list item code.
Custom39Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom39Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom3Code	String	True		For list fields, this is the list item code.
Custom3Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom3Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom40Code	String	True		For list fields, this is the list item code.
Custom40Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom40Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom4Code	String	True		For list fields, this is the list item code.
Custom4Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom4Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom5Code	String	True		For list fields, this is the list item code.
Custom5Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom5Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom6Code	String	True		For list fields, this is the list item code.
Custom6Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom6Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom7Code	String	True		For list fields, this is the list item code.
Custom7Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom7Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom8Code	String	True		For list fields, this is the list item code.
Custom8Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom8Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom9Code	String	True		For list fields, this is the list item code.
Custom9Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom9Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Description	String	False		The description of the expense. Maximum length: 64 characters
ExpenseTypeCode	String	False		The code for the expense type. Use the GET ExpenseGroupConfigurations endpoint to learn the expense type code for expense types that are active for this report's policy.
ExpenseTypeName	String	True		The name of the expense type, localized to the user's language.
HasComments	Bool	True		Indicates whether the expense has comments. Use the GET ExpenseEntryComments endpoint to get information about this entry's comments. Format: true or false
HasExceptions	Bool	True		Indicates whether the expense has exceptions. Format: true or false
IsBillable	Bool	False		Indicates whether the itemization is billable. Format: true or false
IsImageRequired	Bool	True		Indicates whether a receipt image is required for the entry. Format: true or false
IsPersonal	Bool	False		Indicates whether the itemization is personal (that is, non-reimbursable). Format: true or false
LastModified	Datetime	True		The UTC date when the itemization was last modified.
LocationCountry	String	True		The country where the expense was incurred. Format: 2-letter ISO 3166-1 country code
LocationName	String	True		The location where the expense was incurred, usually the city name.
LocationSubdivision	String	True		The state, province, or other country subdivision where the expense was incurred. Format: ISO 3166-2:2007 country subdivision
OrgUnit1Code	String	True		For list fields, this is the list item code.
OrgUnit1Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
OrgUnit1Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
OrgUnit2Code	String	True		For list fields, this is the list item code.
OrgUnit2Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
OrgUnit2Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
OrgUnit3Code	String	True		For list fields, this is the list item code.
OrgUnit3Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
OrgUnit3Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
OrgUnit4Code	String	True		For list fields, this is the list item code.
OrgUnit4Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
OrgUnit4Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
OrgUnit5Code	String	True		For list fields, this is the list item code.
OrgUnit5Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
OrgUnit5Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
OrgUnit6Code	String	True		For list fields, this is the list item code.
OrgUnit6Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
OrgUnit6Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
PostedAmount	Decimal	True		The amount of the expense itemization, in the report currency.
SpendCategoryCode	String	True		The code for the spending category that is specified for this itemization.
SpendCategoryName	String	True		The name of the spending category that is specified for this itemization, localized to the user's language.
TransactionAmount	Decimal	False		The amount of the expense itemization, in the transaction currency of the parent expense entry.
TransactionDate	Datetime	False		The date when the good or service associated with this itemization was provided. Format: YYYY-MM-DD
URI	String	True		null

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
LoginId	String	The login ID of the user who owns the itemizations. The user must have the Web Services Admin role to use this parameter.

ListItems

Create, update, delete, and query all list items based on the search criteria.

Table Specific Information

Select

The Sync App uses the SAP Concur APIs to process filters on Id or on any combination of ListId, Name, ParentId, and Level1Code - Level10Code. The Sync App processes other filters client-side within the Sync App.

For example, the Sync App will offload processing of the following queries to the SAP Concur APIs:

SELECT * FROM ListItems WHERE Id = 'ListItemId'
SELECT * FROM ListItems WHERE ListId = 'sampleListId' AND Name = 'sampleName' AND Level5Code = 'code5' AND Level10Code = 'code10'

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false.

Insert

To insert a list item the following columns are required: ListId, Name, and Level1Code.

INSERT INTO ListItems (ListId, Name, Level1Code) VALUES ('ListIdValue','ListItemName', 'Level1CodValue')

Update

Updates are not supported for list items.

Delete

Deletes are not supported for list items.

Columns


Name	Type	ReadOnly	References	Description
ID [KEY]	String	True		The unique identifier of the resource.
ListID	String	False		The unique identifier for the list this item is a member.
ParentID	String	True		The unique identifier of this item's parent. Is empty when there is no parent.
Level10Code	String	False		The item code for the tenth level of the list. Empty when this level doesn't exist in the list. Text maximum 32 characters
Level1Code	String	False		The item code for the first level of the list. All lists have at least a Level1Code. Text maximum 32 characters
Level2Code	String	False		The item code for the second level of the list. Empty when this level doesn't exist in the list. Text maximum 32 characters
Level3Code	String	False		The item code for the third level of the list. Empty when this level doesn't exist in the list. Text maximum 32 characters
Level4Code	String	False		The item code for the fourth level of the list. Empty when this level doesn't exist in the list. Text maximum 32 characters
Level5Code	String	False		The item code for the fifth level of the list. Empty when this level doesn't exist in the list. Text maximum 32 characters
Level6Code	String	False		The item code for the sixth level of the list. Empty when this level doesn't exist in the list. Text maximum 32 characters
Level7Code	String	False		The item code for the seventh level of the list. Empty when this level doesn't exist in the list. Text maximum 32 characters
Level8Code	String	False		The item code for the eighth level of the list. Empty when this level doesn't exist in the list. Text maximum 32 characters
Level9Code	String	False		The item code for the ninth level of the list. Empty when this level doesn't exist in the list. Text maximum 32 characters
Name	String	False		The name of item. Text maximum 64 characters
URI	String	True		The URI to the resource.

Lists

Create, update, delete, and query all lists based on the search criteria.

Table Specific Information

Select

The Sync App uses the SAP Concur APIs to process filters that refer to Id. The Sync App processes other filters client-side within the Sync App.

For example, the Sync App will offload the processing of the following query to the SAP Concur APIs:

SELECT * FROM Lists WHERE Id = '123456'

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false.

Insert

To insert a list item the following columns are required: Name, DisplayCodeFirst, IsVendorList, and SearchCriteriaCode.

INSERT INTO Lists (Name, DisplayCodeFirst, IsVendorList, SearchCriteriaCode) VALUES ('NameValue', true, true, 'CODE')

Update

Updates are not supported for this table.

Delete

Deletes are not supported for this table.

Columns


Name	Type	ReadOnly	References	Description
ID [KEY]	String	True		null
ConnectorID	String	False		Optional. Defines the encrypted ConnectorID. If not provided then the list isn't associated with a connector.
DisplayCodeFirst	Bool	False		Required. Defines whether CODE should appear before TEXT, or vice-versa.
ExternalThreshold	Int	False		Optional. Default value is 1. Defines the threshold from where the level starts being external. This value can only be set if a ConnectorID is provided.
IsVendorList	Bool	False		Required. Defines whether it is a vendor list.
Name	String	False		Required. Defines a name for the list. This name must be unique.
SearchCriteriaCode	String	False		Required. Defines whether the search criteria should apply to the CODE or to the TEXT.
URI	String	True		null

ReceiptImages

Create, update, delete, and query all receipt Ids owned by the user.

Table Specific Information

Select

The Sync App will use the SAP Concur APIs to process filters that refer to Id or LoginId. The Sync App processes other filters client-side within the Sync App.

For example, the Sync App will offload the processing of the following queries to the SAP Concur APIs:

SELECT * FROM ReceiptImages WHERE Id = '12345'
SELECT * FROM ReceiptImages WHERE LoginId = 'LoginId'

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false.

Insert

You cannot insert a new image by using INSERT queries, but you can upload one by using the UploadReceiptImage stored procedure.

Update

You cannot update an image by using UPDATE queries, but you can upload one by using the UploadReceiptImage stored procedure.

Delete

To delete a receipt image, the following column is required: Id.

DELETE FROM ReceiptImages WHERE Id = '12345'

Columns


Name	Type	ReadOnly	References	Description
ID [KEY]	String	True		The unique identifier of the resource.
URI	String	True		The URI to the resource.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
LoginId	String	The login ID of the user. Optional. The user must have the Web Services Admin (Professional) or Can Administer (Standard) user role to use this parameter.

Reports

Create, update, delete, and query all reports owned by the user.

Table Specific Information

Select

The Sync App uses the SAP Concur APIs to process almost all searches to this table -- you can use server-side processing to search on any pseudocolumn and almost any combination of the remaining columns. The Sync App processes any other filters client-side within the Sync App.

SELECT * FROM Reports WHERE Id = 'reportId'
SELECT * FROM Reports WHERE ApprovalStatusCode = 'code' AND PaymentType_p = 'PaymentTypeID' AND CreateDateBefore_p = '2018-01-01 10:00:00'

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false.

Insert

To insert a report the following column is required: Name.

INSERT INTO Reports (Name, Custom1Value) VALUES ('Name','Test');

Update

To update a report the following column is required: Id.

UPDATE Reports SET  Name='Name' WHERE Id='12334'

Delete

Deletes are not supported for this table.

Columns


Name	Type	ReadOnly	References	Description
ID [KEY]	String	True		null
ApproverLoginID	String	True		The Login ID of the report owner's expense approver.
Custom10ListItemID	String	True		For list fields, this is the list item ID.
Custom11ListItemID	String	True		For list fields, this is the list item ID.
Custom12ListItemID	String	True		For list fields, this is the list item ID.
Custom13ListItemID	String	True		For list fields, this is the list item ID.
Custom14ListItemID	String	True		For list fields, this is the list item ID.
Custom15ListItemID	String	True		For list fields, this is the list item ID.
Custom16ListItemID	String	True		For list fields, this is the list item ID.
Custom17ListItemID	String	True		For list fields, this is the list item ID.
Custom18ListItemID	String	True		For list fields, this is the list item ID.
Custom19ListItemID	String	True		For list fields, this is the list item ID.
Custom1ListItemID	String	True		For list fields, this is the list item ID.
Custom20ListItemID	String	True		For list fields, this is the list item ID.
Custom2ListItemID	String	True		For list fields, this is the list item ID.
Custom3ListItemID	String	True		For list fields, this is the list item ID.
Custom4ListItemID	String	True		For list fields, this is the list item ID.
Custom5ListItemID	String	True		For list fields, this is the list item ID.
Custom6ListItemID	String	True		For list fields, this is the list item ID.
Custom7ListItemID	String	True		For list fields, this is the list item ID.
Custom8ListItemID	String	True		For list fields, this is the list item ID.
Custom9ListItemID	String	True		For list fields, this is the list item ID.
OrgUnit1ListItemID	String	True		For list fields, this is the list item ID.
OrgUnit2ListItemID	String	True		For list fields, this is the list item ID.
OrgUnit3ListItemID	String	True		For list fields, this is the list item ID.
OrgUnit4ListItemID	String	True		For list fields, this is the list item ID.
OrgUnit5ListItemID	String	True		For list fields, this is the list item ID.
OrgUnit6ListItemID	String	True		For list fields, this is the list item ID.
OwnerLoginID	String	True		The Login ID of the user this report belongs to.
PaidDate	Datetime	True		The date when all journal entries in the report was integrated with or extracted to the financial system.
PolicyID	String	False		The unique identifier of the policy that applies to this report. Maximum 64 characters.
AmountDueCompanyCard	Decimal	True		The total amount due to the company card for the report. Maximum 23 characters.
AmountDueEmployee	Decimal	True		The total amount due to the employee for the report. Maximum 23 characters.
ApprovalStatusCode	String	True		The approval status code for the report.
ApprovalStatusName	String	True		The report's approval status, in the OAuth consumer's language.
ApproverName	String	True		The name of the report owner's expense approver.
Country	String	True		The report country. Maximum 2 characters. Format: The ISO 3166-1 alpha-2 country code. Example: United States is US.
CountrySubdivision	String	True		The report country subdivision. Format: ISO 3166-2:2007 country subdivision.
CreateDate	Datetime	True		The date the report was created.
CurrencyCode	String	True		The ISO 4217 currency code for the expense report currency. Examples: USD - US dollars; BRL - Brazilian real; CAD - Canadian dollar; CHF - Swiss franc; EUR - Euro; GBO - Pound sterling; HKD - Hong Kong dollar; INR - Indian rupee; MXN - Mexican peso; NOK - Norwegian krone; SEK - Swedish krona.
Custom10Code	String	True		For list fields, this is the list item code.
Custom10Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom10Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom11Code	String	True		For list fields, this is the list item code.
Custom11Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom11Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom12Code	String	True		For list fields, this is the list item code.
Custom12Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom12Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom13Code	String	True		For list fields, this is the list item code.
Custom13Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom13Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom14Code	String	True		For list fields, this is the list item code.
Custom14Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom14Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom15Code	String	True		For list fields, this is the list item code.
Custom15Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom15Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom16Code	String	True		For list fields, this is the list item code.
Custom16Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom16Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom17Code	String	True		For list fields, this is the list item code.
Custom17Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom17Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom18Code	String	True		For list fields, this is the list item code.
Custom18Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom18Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom19Code	String	True		For list fields, this is the list item code.
Custom19Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom19Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom1Code	String	True		For list fields, this is the list item code.
Custom1Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom1Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom20Code	String	True		For list fields, this is the list item code.
Custom20Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom20Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom2Code	String	True		For list fields, this is the list item code.
Custom2Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom2Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom3Code	String	True		For list fields, this is the list item code.
Custom3Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom3Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom4Code	String	True		For list fields, this is the list item code.
Custom4Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom4Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom5Code	String	True		For list fields, this is the list item code.
Custom5Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom5Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom6Code	String	True		For list fields, this is the list item code.
Custom6Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom6Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom7Code	String	True		For list fields, this is the list item code.
Custom7Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom7Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom8Code	String	True		For list fields, this is the list item code.
Custom8Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom8Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom9Code	String	True		For list fields, this is the list item code.
Custom9Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom9Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
EverSentBack	Bool	True		Whether the report has ever been sent back to the employee. Format: Y/N
HasException	Bool	True		Whether the report has exceptions. Format: Y/N
LastComment	String	True		The text of the most recent comment on the report.
LastModifiedDate	Datetime	True		The date the report header was last modified.
LedgerName	String	True		The name of the expense report ledger. Maximum 20 characters.
Name	String	False		The name of the report.
OrgUnit1Code	String	True		For list fields, this is the list item code.
OrgUnit1Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
OrgUnit1Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
OrgUnit2Code	String	True		For list fields, this is the list item code.
OrgUnit2Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
OrgUnit2Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
OrgUnit3Code	String	True		For list fields, this is the list item code.
OrgUnit3Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
OrgUnit3Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
OrgUnit4Code	String	True		For list fields, this is the list item code.
OrgUnit4Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
OrgUnit4Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
OrgUnit5Code	String	True		For list fields, this is the list item code.
OrgUnit5Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
OrgUnit5Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
OrgUnit6Code	String	True		For list fields, this is the list item code.
OrgUnit6Type	String	True		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
OrgUnit6Value	String	False		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
OwnerName	String	True		The name of the expense report owner.
PaymentStatusCode	String	True		The code for the payment status of the report.
PaymentStatusName	String	True		The report's payment status, in the OAuth consumer's language.
PersonalAmount	Decimal	True		The total amount of expenses marked as personal. Maximum 23 characters.
ProcessingPaymentDate	Datetime	True		The date that the report completed all approvals and was ready to be extracted for payment.
ReceiptsReceived	Bool	True		If Y, then this report has its receipt receipt confirmed by the Expense Processor. Format: Y/N
SubmitDate	Datetime	True		The date the report was submitted.
Total	Decimal	True		The total amount of the report.
TotalApprovedAmount	Decimal	True		The total amount of approved expenses in the report. Maximum 23 characters.
TotalClaimedAmount	Decimal	True		The total amount of all non-personal expenses in the report. Maximum 23 characters.
URI	String	True		null
UserDefinedDate	Datetime	False		The date of the report assigned by the user.
WorkflowActionUrl	String	True		The URL to post a workflow action to the report using the Post Report Workflow Action function.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
PaidDateBefore_p	String	The report paid date is before this date.Format: YYYY-MM-DD
CreateDateBefore_p	String	The report create date is before this date.Format: YYYY-MM-DD
HasImages_p	String	Determines if the report has at least one expense entry with an entry image or if there is a report image for this report. FORMAT: true or false.
CostObject_p	String	The list item code for an allocation field for at least allocation in the report.
ProcessingPaymentDateBefore_p	String	The report processing payment date is before this date.Format: YYYY-MM-DD
EntryTransactionDateBefore_p	String	The entry transaction date for at least one expense entry in the report is before this date.Format: YYYY-MM-DD
ExpenseTypeCode_p	String	The expense type code that is the expense type for at least one expense entry in the report. Use ExpenseTypeCode from Response of GET Expense Group Configurations V3.
SubmitDateAfter_p	String	The report submit date is after this date.Format: YYYY-MM-DD
LoginId	String	Optional. The login ID of the report owner(s) to use when searching for reports. If the value is set to LoginID, reports for the report owner with this login ID value are returned. If the value is set to ALL, reports for all report owners are returned. If this parameter is not specified, reports for the OAuth Consumer are returned. The access token owner (OAuth Consumer) must have the Web Services Admin role to use this parameter.
UserDefinedDateBefore_p	String	The report user defined date is before this date.Format: YYYY-MM-DD
BatchID_p	String	The unique identifier for a payment batch where there is at least one report payee within the report. Use the BatchID from Response of GET Payment Batch List.
ProcessingPaymentDateAfter_p	String	The report processing payment date is after this date. Format: YYYY-MM-DD
ModifiedDateBefore_p	String	The report modified date is before this date.Format: YYYY-MM-DD
PaymentType_p	String	The unique identifier for the payment type that is the payment type for at least one expense entry in the report. Use PaymentTypeID from Response of GET Expense Group Configurations V3 to obtain valid payment types.
UserDefinedDateAfter_p	String	The report user defined date is after this date.Format: YYYY-MM-DD
HasAttendees_p	String	Determines if the report has at least one expense entry with an attendee. FORMAT: true or false.
PaidDateAfter_p	String	The report paid date is after this date.Format: YYYY-MM-DD
ExpenseGroupConfigID_p	String	The unique identifier for the expense group configuration associated to the report's expense group. Use the ID from the Response of the Expense Group Configurations V3.
IsTestUser_p	String	The report owner is a test user using the report for testing purposes in a non-production envirnment. FORMAT: true or false.
HasBillableExpenses_p	String	The IsBillable flag for at least one expense entry in the report. FORMAT: true or false.
HasVAT_p	String	Determines if the report has at least one expense entry with VAT details. FORMAT: true or false.
ReimbursementMethod_p	String	The method the report owner will be reimbursed. VALUES: ADPPAYR - ADP Payroll; APCHECK - AP (Company Check); CNQRPAY - Expense Pay; PMTSERV - Other Payment Service. NOTE: PAY_PAL is NOT supported.
AttendeeTypeCode_p	String	The report contains expense entries that have attendees of the specified type.
ModifiedDateAfter_p	String	The report modified date is after this date.Format: YYYY-MM-DD
CreateDateAfter_p	String	The report create date is after this date.Format: YYYY-MM-DD
SubmitDateBefore_p	String	The report submit date is before this date.Format: YYYY-MM-DD
CountryCode_p	String	The report country. Maximum 2 characters. Format: The ISO 3166-1 alpha-2 country code. Example: United States is US.
EntryTransactionDateAfter_p	String	The entry transaction date for at least one expense entry in the report is after this date.Format: YYYY-MM-DD
VendorName_p	String	The Vendor Description that is the vendor for at least one expense entry in the report.

Views

Views are composed of columns and pseudo columns. Views are similar to tables in the way that data is represented; however, views do not support updates. Entities that are represented as views are typically read-only entities. Often, a stored procedure is available to update the data if such functionality is applicable to the data source.

Queries can be executed against a view as if it were a normal table, and the data that comes back is similar in that regard.

Dynamic views, such as queries exposed as views, and views for looking up specific combinations of project_team work items are supported.

SAP Concur Connector for CData Sync Views


Name	Description
Allocations	Lists all allocations per entry or report.
CompanyCardTransactions	Retrieves corporate or credit card charges that are available for use in expense reports.
DigitalTaxInvoices	Gets all digital tax invoices that can be validated by the user based on the search criteria.
ExpenseDelegators	Retrieves the list of users that have granted delegate permissions to you.
ExpenseGroupConfigurationAttendeeTypes	Lists the Attendee Types of the Expense Group Configurations.
ExpenseGroupConfigurationPaymentTypes	Lists the payment types of the Expense Group Configurations.
ExpenseGroupConfigurationPolicies	Lists the policies of Expense Group Configurations.
ExpenseGroupConfigurationPolicyExpenseTypes	Lists the expense types for the Expense Group Configuration Policies.
ExpenseGroupConfigurations	Lists the configurations of expense groups.
FormFields	Query expense form fields.
Forms	Query expense forms.
Identity	Read user's core identity profile.
Invoice	Gets all relevant information (Payment Request Header, Payment Request Line Item and Payment Request Allocation) of a Payment Request.
Locations	Retrieve details of locations that are used by Concur and that are valid at the company of the user.
Notifications	Lists notifications that have failed.
Opportunities	Gets opportunities for a specified trip or for all trips that fall within a date range.
PaymentBatches	Lists all the payment batches.
PaymentRequestDigests	A payment request digest is a collection of summarized payment requests to invoice vendors.
ReportComments	Read the comments entered on the expense report header, or expenses of an existing expense report.
ReportDetails	Retrieves the full set of information for the report.
ReportDetailsExpenseEntry	Lists all expense entries
ReportDetailsExpenseEntryItemization	Lists all itemizations of an expense entry
ReportDetailsExpenseEntryItemizationAllocation	Lists all allocations of an itemization
ReportDetailsExpenseEntryItemizationAllocationJournalEntry	Lists all allocations of an itemization
ReportDetailsExpenseEntryItemizationAllocationVATData	Lists all allocations of an itemization
ReportDetailsExpenseEntryItemizationAttendee	Lists all allocations of an itemization
Suppliers	Lists Suppliers based on the search criteria.
TripBookingPassengers	Lists the passengers for a trip booking.
TripBookings	Query all the bookings for a trip.
TripBookingSegmentCharges	Query all the charges for a trip.
TripBookingSegments	Query all the bookings for a trip.
TripBookingSegmentSeats	Query all the seats for a trip.
Trips	Query all the trips.
Users	Lists user data based on the search criteria.

Allocations

Lists all allocations per entry or report.

Table Specific Information

Select

The Sync App uses the SAP Concur APIs to process filters that refer to Id or to any combination of ReportId_p, ItemizationId_p, and EntryId. The Sync App processes other filters client-side within the Sync App.

For example, the Sync App will offload the processing of the following queries to the SAP Concur APIs:

SELECT * FROM Allocations WHERE Id = 'sampleAllocationsId'
SELECT * FROM Allocations WHERE ItemizationId_p = 'sampleItemizationId' AND  ReportId_p = 'sampleReportId' AND EntryId = 'sampleEntryId'

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false.

Columns


Name	Type	References	Description
ID [KEY]	String		The unique identifier of the resource.
Custom10ListItemID	String		For list fields, this is the list item ID.
Custom11ListItemID	String		For list fields, this is the list item ID.
Custom12ListItemID	String		For list fields, this is the list item ID.
Custom13ListItemID	String		For list fields, this is the list item ID.
Custom14ListItemID	String		For list fields, this is the list item ID.
Custom15ListItemID	String		For list fields, this is the list item ID.
Custom16ListItemID	String		For list fields, this is the list item ID.
Custom17ListItemID	String		For list fields, this is the list item ID.
Custom18ListItemID	String		For list fields, this is the list item ID.
Custom19ListItemID	String		For list fields, this is the list item ID.
Custom1ListItemID	String		For list fields, this is the list item ID.
Custom20ListItemID	String		For list fields, this is the list item ID.
Custom2ListItemID	String		For list fields, this is the list item ID.
Custom3ListItemID	String		For list fields, this is the list item ID.
Custom4ListItemID	String		For list fields, this is the list item ID.
Custom5ListItemID	String		For list fields, this is the list item ID.
Custom6ListItemID	String		For list fields, this is the list item ID.
Custom7ListItemID	String		For list fields, this is the list item ID.
Custom8ListItemID	String		For list fields, this is the list item ID.
Custom9ListItemID	String		For list fields, this is the list item ID.
EntryID	String		The unique identifier for the expense entry.
IsHidden	Bool		Indicates whether the allocation is hidden. Format: true or false
AccountCode1	String		The primary accounting code assigned to the expense type associated with this allocation. Typically, expense types have only a primary account code.
AccountCode2	String		The secondary or alternative accounting code assigned to the expense type associated with this allocation.
Custom10Code	String		For list fields, this is the list item code.
Custom10Label	String		The label value for the custom field.
Custom10Sequence	Int		The sequence value for this custom field i.e. the order in which this field appears on the form.
Custom10Type	String		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom10Value	String		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom11Code	String		For list fields, this is the list item code.
Custom11Label	String		The label value for the custom field.
Custom11Sequence	Int		The sequence value for this custom field i.e. the order in which this field appears on the form.
Custom11Type	String		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom11Value	String		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom12Code	String		For list fields, this is the list item code.
Custom12Label	String		The label value for the custom field.
Custom12Sequence	Int		The sequence value for this custom field i.e. the order in which this field appears on the form.
Custom12Type	String		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom12Value	String		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom13Code	String		For list fields, this is the list item code.
Custom13Label	String		The label value for the custom field.
Custom13Sequence	Int		The sequence value for this custom field i.e. the order in which this field appears on the form.
Custom13Type	String		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom13Value	String		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom14Code	String		For list fields, this is the list item code.
Custom14Label	String		The label value for the custom field.
Custom14Sequence	Int		The sequence value for this custom field i.e. the order in which this field appears on the form.
Custom14Type	String		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom14Value	String		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom15Code	String		For list fields, this is the list item code.
Custom15Label	String		The label value for the custom field.
Custom15Sequence	Int		The sequence value for this custom field i.e. the order in which this field appears on the form.
Custom15Type	String		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom15Value	String		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom16Code	String		For list fields, this is the list item code.
Custom16Label	String		The label value for the custom field.
Custom16Sequence	Int		The sequence value for this custom field i.e. the order in which this field appears on the form.
Custom16Type	String		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom16Value	String		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom17Code	String		For list fields, this is the list item code.
Custom17Label	String		The label value for the custom field.
Custom17Sequence	Int		The sequence value for this custom field i.e. the order in which this field appears on the form.
Custom17Type	String		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom17Value	String		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom18Code	String		For list fields, this is the list item code.
Custom18Label	String		The label value for the custom field.
Custom18Sequence	Int		The sequence value for this custom field i.e. the order in which this field appears on the form.
Custom18Type	String		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom18Value	String		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom19Code	String		For list fields, this is the list item code.
Custom19Label	String		The label value for the custom field.
Custom19Sequence	Int		The sequence value for this custom field i.e. the order in which this field appears on the form.
Custom19Type	String		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom19Value	String		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom1Code	String		For list fields, this is the list item code.
Custom1Label	String		The label value for the custom field.
Custom1Sequence	Int		The sequence value for this custom field i.e. the order in which this field appears on the form.
Custom1Type	String		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom1Value	String		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom20Code	String		For list fields, this is the list item code.
Custom20Label	String		The label value for the custom field.
Custom20Sequence	Int		The sequence value for this custom field i.e. the order in which this field appears on the form.
Custom20Type	String		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom20Value	String		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom2Code	String		For list fields, this is the list item code.
Custom2Label	String		The label value for the custom field.
Custom2Sequence	Int		The sequence value for this custom field i.e. the order in which this field appears on the form.
Custom2Type	String		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom2Value	String		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom3Code	String		For list fields, this is the list item code.
Custom3Label	String		The label value for the custom field.
Custom3Sequence	Int		The sequence value for this custom field i.e. the order in which this field appears on the form.
Custom3Type	String		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom3Value	String		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom4Code	String		For list fields, this is the list item code.
Custom4Label	String		The label value for the custom field.
Custom4Sequence	Int		The sequence value for this custom field i.e. the order in which this field appears on the form.
Custom4Type	String		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom4Value	String		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom5Code	String		For list fields, this is the list item code.
Custom5Label	String		The label value for the custom field.
Custom5Sequence	Int		The sequence value for this custom field i.e. the order in which this field appears on the form.
Custom5Type	String		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom5Value	String		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom6Code	String		For list fields, this is the list item code.
Custom6Label	String		The label value for the custom field.
Custom6Sequence	Int		The sequence value for this custom field i.e. the order in which this field appears on the form.
Custom6Type	String		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom6Value	String		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom7Code	String		For list fields, this is the list item code.
Custom7Label	String		The label value for the custom field.
Custom7Sequence	Int		The sequence value for this custom field i.e. the order in which this field appears on the form.
Custom7Type	String		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom7Value	String		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom8Code	String		For list fields, this is the list item code.
Custom8Label	String		The label value for the custom field.
Custom8Sequence	Int		The sequence value for this custom field i.e. the order in which this field appears on the form.
Custom8Type	String		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom8Value	String		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
Custom9Code	String		For list fields, this is the list item code.
Custom9Label	String		The label value for the custom field.
Custom9Sequence	Int		The sequence value for this custom field i.e. the order in which this field appears on the form.
Custom9Type	String		The custom field type. Possible values: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom9Value	String		The value in the Org Unit or Custom field. For list fields, this is the name of the list item. Maximum length: 48 characters
IsPercentEdited	Bool		Indicates whether the percentage has been edited. Format: true or false
Percentage	String		The percentage of the expense that is included in this allocation.
URI	String		The URI to the resource.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
ReportID_p	String		The unique identifier for the report as it appears in the Concur Expense UI. Format: A variable-length string. Maximum length: 32 characters.
ItemizationID_p	String		The unique identifier for the expense itemization.
LoginId	String		The login ID of the user who owns the allocation. The user must have the Web Services Admin role to use this parameter.

CompanyCardTransactions

Retrieves corporate or credit card charges that are available for use in expense reports.

Table Specific Information

Select

The Sync App processes all searches to this table client-side within the Sync App. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false.

Columns


Name	Type	References	Description
CardNumber	String		The number of the card, with all but the last four digits obscured.
ExpKey	String		The code for the expense type of the transaction
Merchant	String		The merchant name for the transaction.
ExpName	String		The name of the expense type of the transaction.
TransactionAmount	String		The amount of the card transaction.
TransactionCrnCode	String		The currency code of the transaction amount.
TransactionDate	String		The date of the transaction.

DigitalTaxInvoices

Gets all digital tax invoices that can be validated by the user based on the search criteria.

Table Specific Information

Select

The Sync App uses the SAP Concur APIs to process filters that refer to Id or to ModifiedAfter_p. The Sync App processes other filters client-side within the Sync App.

For example, the Sync App will offload the processing of the following queries to the SAP Concur APIs:

SELECT * FROM DigitalTaxInvoices WHERE Id = 'sampleDigitalTaxInvoicesId'
SELECT * FROM DigitalTaxInvoices WHERE ModifiedAfter_p = '2018-01-01 10:00:00'

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false.

Columns


Name	Type	References	Description
ID [KEY]	String		The unique identifier of the resource.
AccountID	String		The unique identifier assigned by the validation partner to the Concur client company that owns the digital tax invoices.
ConcurReceiptID	String		The ID of the digital tax invoice in plain text.
DocumentID	String		The ID of the report in plain text.
ReceiptData	String		The digital tax invoice data.
URI	String		The URI to the resource.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
Modifiedafter_p	String		A modification date for the queue record; this parameter can be used to limit the results of the GET request to the queue items that have been added since the last time the validation company queried the queue. The user must have the Web Services Admin role to use this parameter.

ExpenseDelegators

Retrieves the list of users that have granted delegate permissions to you.

Table Specific Information

Select

The Sync App processes all searches on this table client-side within the Sync App. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false.

Columns


Name	Type	References	Description
Id [KEY]	String		The id of the batch.
CanApprove	String		Whether the delegate is granted the right to approve expense reports on behalf of the delegator.
CanPrepare	String		Whether the delegate is granted the right to create expense reports on behalf of the delegator.
CanSubmit	String		Whether the delegate is granted the right to submit expense reports on behalf of the delegator.
CanTemporaryApprove	String		Whether the delegate is granted the same temporary approval rights as the delegator.
CanViewReceipts	String		Whether the delegate is granted the right to view receipts on behalf of the delegator.
ReceiveApprovalEmails	String		Whether the delegate also receives the approval emails sent to the delegator.
ReceivesEmails	String		Whether the delegate also receives the Concur emails sent to the delegator.

ExpenseGroupConfigurationAttendeeTypes

Lists the Attendee Types of the Expense Group Configurations.

Table Specific Information

Select

The Sync App processes all searches to this table client-side within the Sync App. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false.

Columns


Name	Type	References	Description
Code	String		The attendee type code.
ExpenseGroupConfigurationId	String		The unique identifier of the Expense Group Configuration.
Name	String		The name of the attendee type.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
LoginId	String		The login ID of the user who owns the expense group. The user must have the Web Services Admin role to use this parameter.

ExpenseGroupConfigurationPaymentTypes

Lists the payment types of the Expense Group Configurations.

Table Specific Information

Select

The Sync App processes all searches to this table client-side within the Sync App. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false.

Columns


Name	Type	References	Description
Id	String		The unique identifier of the payment type.
ExpenseGroupConfigurationId	String		The unique identifier of the Expense Group Configuration.
Name	String		The name of the payment type.
IsDefault	Boolean		Determines whether this payment type is the default

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
LoginId	String		The login ID of the user who owns the expense group. The user must have the Web Services Admin role to use this parameter.

ExpenseGroupConfigurationPolicies

Lists the policies of Expense Group Configurations.

Table Specific Information

Select

The Sync App processes all searches to this table client-side within the Sync App. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false.

Columns


Name	Type	References	Description
Id	String		The unique identifier of the policy.
ExpenseGroupConfigurationId	String		The unique identifier of the Expense Group Configuration.
Name	String		The name of the policy.
IsDefault	Boolean		Indicates whether this policy is the default.
IsInheritable	Boolean		Indicates whether the descendent nodes in the Expense Feature Hierarchy are covered by this policy.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
LoginId	String		The login ID of the user who owns the expense group. The user must have the Web Services Admin role to use this parameter.

ExpenseGroupConfigurationPolicyExpenseTypes

Lists the expense types for the Expense Group Configuration Policies.

Table Specific Information

Select

The Sync App processes all searches to this table client-side within the Sync App. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false.

Columns


Name	Type	References	Description
Code	String		The code of the expense type.
ExpenseGroupConfigurationId	String		The unique identifier of the Expense Group Configuration.
ExpenseCode	String		The code for the expense category.
Name	String		The name of the policy.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
LoginId	String		The login ID of the user who owns the expense group. The user must have the Web Services Admin role to use this parameter.

ExpenseGroupConfigurations

Lists the configurations of expense groups.

Table Specific Information

Select

The Sync App processes all searches to this table client-side within the Sync App. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false.

Columns


Name	Type	References	Description
Id [KEY]	String		The unique identifier of the resource.
Name	String		The name of the expense group configuration.
AttendeeListFormID	String		The unique identifier for the attendee list form.
AttendeeListFormName	String		The name of the attendee list form.
AllowUserRegisterYodlee	Boolean		Indicates whether users in the expense group are allowed to register Yodlee credit cards.
AllowUserDigitalTaxInvoice	Boolean		Indicates whether users are allowed to upload digital tax invoices.
URI	String		The URI to the resource.
LoginId	String		The login ID of the user who owns the expense group. The user must have the Web Services Admin role to use this parameter.

FormFields

Query expense form fields.

Table Specific Information

Select

The Sync App uses the SAP Concur APIs to process filters that are based on the FormId column. The Sync App processes other filters client-side within the Sync App. For example, the following query is processed server side:

SELECT * FROM FormFields WHERE FormId = '12345'

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false.

Columns


Name	Type	References	Description
Id [KEY]	String		The form field ID.
FormId [KEY]	String	Forms.Id	The ID of the form.
Label	String		The form field label..
ControlType	String		The type of field.
DataType	String		The type of data accepted by the field.
MaxLength	Integer		The maximum length of the field value.
IsRequired	String		Whether the field is required.
ColumnNumber	Integer		The number of columns the field contains.
Access	String		The access level the specified user has to the field.
Width	String		The width of the field.
IsCustom	String		Whether the field is custom.
Sequence	Integer		The field order on the form.

Forms

Query expense forms.

Table Specific Information

Select

The Sync App processes all searches to this table client-side within the Sync App. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false.

Columns


Name	Type	References	Description
Id [KEY]	String		The id of the form.
Code [KEY]	String		The code of the form.
Name	String		The name of the form.

Identity

Read user's core identity profile.

Table Specific Information

Select

The Sync App uses the SAP Concur APIs to process filters that refer to Id, UserName, and ExternalId. The Sync App processes other filters client-side within the Sync App.

Use the filters to retrieve data only for the authenticated user since SAP Concur requires Company Level Authentication for retrieving data for all users.

For example, the Sync App will offload the processing of the following queries to the SAP Concur APIs:

SELECT * FROM Identity WHERE UserName = '[email protected]'
SELECT * FROM Identity WHERE ExternalId = '1234_externalId'
SELECT * FROM Identity WHERE Id = '802546f7-52a4-4ce7-6380-d5a869af350f'

Use the Id value returned from these queries when working with tables that require a UserId.

Columns


Name	Type	References	Description
Id [KEY]	String		Unique identifier for the user, also known as the UUID.
Active	Boolean		If true, the user is active.
UserName	String		The name that can be used to login to Concur Travel and Expense.
DisplayName	String		The name of the user, suitable for public display.
GivenName	String		The given or first name of the user.
MiddleName	String		The middle name(s) of the user, if applicable.
FamilyName	String		The family or last name of the user.
FormattedName	String		The full name of the user, formatted for display.
NickName	String		The casual way to address the user.
AddressesAggregate	String		JSON aggregate of a physical mailing address for this user.
DateOfBirth	String		The user's date of birth.
EmailsAggregate	String		JSON aggregate of the user's email addresses.
EmergencyContactsAggregate	String		JSON aggregate of emergency contact information for the user.
Entitlements	String		The features enabled for the user. Supported values: Expense, Invoice, Locate, Request, Travel.
ExternalId	String		User identifier from the provisioning client.
Created	Datetime		The datetime the user was created.
LastModified	Datetime		The datetime the user was last modified.
PhoneNumbersAggregate	String		JSON aggregate of the user's phone numbers.
Timezone	String		The user's time zone in the Olson time zone database format.
Title	String		The user's job title in the company.
CompanyId	String		The SAP Concur ID of the company.
EmployeeNumber	String		Client supplied employee number within the company, unique for the company.
UserStartDate	Datetime		The user's start date.
UserTerminationDate	Datetime		The user's termination date.
CostCenter	String		The employee cost center for product.
PreferredLanguage	String		Indicates the user's preferred written or spoken language.
PreferenceEndDayViewHour	String		Preferred hour setting for the end of day.
PreferenceFirstDayOfWeek	String		Preferred first day of the week for the user.
PreferenceDateFormat	String		Preferred date format for the user.
PreferenceCurrencySymbolLocation	String		Preferred currency symbol location for the user. Supported values: BeforeAmount, AfterAmount.
PreferenceHourMinuteSeparator	String		Preferred separator between hour and minute.
PreferenceDistance	String		Preferred distance metric. Supported values: mile, km.
PreferenceDefaultCalView	String		Preferred default calendar view for the user. Supported values: day, week, month.
Preference24Hour	String		Preferred 24 hour format for the user.
PreferenceNumberFormat	String		Preferred number format for the user.
PreferenceStartDayViewHour	String		Preferred start of day for the user, from 1.
PreferenceNegativeCurrencyFormat	String		Preferred negative currency format for the user.
PreferenceNegativeNumberFormat	String		Preferred negative number format for the user.

Invoice

Gets all relevant information (Payment Request Header, Payment Request Line Item and Payment Request Allocation) of a Payment Request.

Table Specific Information

Select

The ID Column is required in the WHERE clause in order to access this view. For example:

SELECT * FROM Invoice WHERE Id = 'sampleInvoiceId'

Columns


Name	Type	References	Description
AmountWithoutVat	String		The net amount of the invoice, excluding VAT.
ApprovalStatus	String		A code which indicates the approval status of the payment request.
ApprovedByDelegate	String		Was the Payment Request approved by a delegate. Format: true/false.
AssignedByUsername	String		Username of the assigning employee.
AssignedDate	String		The date the payment request was assigned to the current owner.
BuyerCostCenter	String		The company defined center responsible for the payment request.
CalculatedAmount	String		The sum of all line item amounts plus shipping amount and tax amount for the payment request.
CheckNumber	String		Check number of the payment made to the vendor.
CompanyBillToAddress	String		The company billing address.
CompanyShipToAddress	String		The company shipping address.
CountryCode	String		The country code.
CreatedByUsername	String		Username of the payment request creator.
CurrencyCode	String		The 3-letter ISO 4217 currency code for the expense report currency. Examples: USD - US dollars; BRL - Brazilian real;, etc.
Custom1	String		The details from the Custom fields. These may not have data, depending on configuration.
Custom10	String		The details from the Custom fields. These may not have data, depending on configuration.
Custom11	String		The details from the Custom fields. These may not have data, depending on configuration.
Custom12	String		The details from the Custom fields. These may not have data, depending on configuration.
Custom13	String		The details from the Custom fields. These may not have data, depending on configuration.
Custom14	String		The details from the Custom fields. These may not have data, depending on configuration.
Custom15	String		The details from the Custom fields. These may not have data, depending on configuration.
Custom16	String		The details from the Custom fields. These may not have data, depending on configuration.
Custom17	String		The details from the Custom fields. These may not have data, depending on configuration.
Custom18	String		The details from the Custom fields. These may not have data, depending on configuration.
Custom19	String		The details from the Custom fields. These may not have data, depending on configuration.
Custom2	String		The details from the Custom fields. These may not have data, depending on configuration.
Custom20	String		The details from the Custom fields. These may not have data, depending on configuration.
Custom21	String		The details from the Custom fields. These may not have data, depending on configuration.
Custom22	String		The details from the Custom fields. These may not have data, depending on configuration.
Custom23	String		The details from the Custom fields. These may not have data, depending on configuration.
Custom24	String		The details from the Custom fields. These may not have data, depending on configuration.
Custom3	String		The details from the Custom fields. These may not have data, depending on configuration.
Custom4	String		The details from the Custom fields. These may not have data, depending on configuration.
Custom5	String		The details from the Custom fields. These may not have data, depending on configuration.
Custom6	String		The details from the Custom fields. These may not have data, depending on configuration.
Custom7	String		The details from the Custom fields. These may not have data, depending on configuration.
Custom8	String		The details from the Custom fields. These may not have data, depending on configuration.
Custom9	String		The details from the Custom fields. These may not have data, depending on configuration.
DataSource	String		A code which indicates the method used to created the Payment Request. Use
DeletedDate	String		The date the user deleted the payment request.
DeliverySlipNumber	String		The delivery slip number associated with receiving receipt.
Description	String		User entered description of the Payment Request.
DiscountPercentage	String		The discount from the supplier if the discount terms are met.
DiscountTerms	String		The NET discount terms with a supplier when discounts apply.
EmployeeName	String		The owner of the Payment Request.
ExternalPolicyId	String		The external policy ID.
ExtractDate	String		The date the payment request was extracted, in order to import it into an accounts payable system and generate a payment.
FirstApprovalDate	String		The date the payment request received its first approval in its approval workflow.
FirstSubmitDate	String		The date the payment request was first submitted.
ID	String		The unique identifier of the resource.
InvoiceAmount	String		User-entered value representing the total invoice amount, used to calculate amount remaining on the line item page.
InvoiceDate	String		The date the vendor issued the invoice.
InvoiceNumber	String		The invoice Number from the vendor for the payment request.
InvoiceReceivedDate	String		The date on which the invoice was received.
IsAssigned	String		Whether the payment request is assigned. Format: true/false.
IsInvoiceConfirmed	String		Indicates if the payment request invoice is confirmed or in a different status. Format: true/false.
IsPaymentRequestDeleted	String		Whether the payment request is deleted. Format: true/false.
IsPaymentRequestDuplicate	String		Whether the payment request identified as a duplicate of another existing request. Format:true/false.
IsTestTransaction	String		Is the payment request a test transaction (true/false).
LastSubmitDate	String		The date the payment request was last submitted.
LedgerCode	String		A code which indicates which company journal the payment request is assigned to. Use
LineItemsAggr	String		Aggregate information of line items

Locations

Retrieve details of locations that are used by Concur and that are valid at the company of the user.

Table Specific Information

Select

The Sync App uses the SAP Concur APIs to process filters that refer to Id or City_p. The Sync App processes other filters client-side within the Sync App. For example, the Sync App will offload the processing of the following queries to the SAP Concur APIs:

SELECT * FROM Locations WHERE Id = '123456'
SELECT * FROM Locations WHERE City_p = 'London'

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false.

Columns


Name	Type	References	Description
ID [KEY]	String		The unique identifier of the resource.
AdministrativeRegion	String		The administrative region of the location.
Country	String		The 2-letter ISO 3166-1 country code for the location.
CountrySubdivision	String		The ISO 3166-2:2007 country subdivision code for the location. Example: US-WA
IATACode	String		The International Air Transport Association (IATA) airport code of the location.
IsAirport	Bool		Indicates whether the location is an airport. Format: true or false
IsBookingTool	Bool		Indicates whether the location is used by the booking tool. Format: true or false
Latitude	Decimal		The latitude of the geocode for the location.
Longitude	Decimal		The longitude of the geocode for the location.
Name	String		The location name. Maximum length: 64 characters
URI	String		The URI to the resource.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
City_p	String		The city name of the location.

Notifications

Lists notifications that have failed.

Table Specific Information

Select

The Sync App processes all other searches to this table client-side within the Sync App. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false.

Columns


Name	Type	References	Description
Id [KEY]	String		The unique identifier of the resource.
Context	String		The context of the notification.
EventType	String		The type of the event that triggered the callout.
EventDateTime	Datetime		The date of the event.
NotificationURI	Datetime		The URL that needs to be called to delete a failed notification.
ObjectType	Datetime		The type of object that triggered the notification.
ObjectURI	Datetime		The type of the event.

Opportunities

Gets opportunities for a specified trip or for all trips that fall within a date range.

Table Specific Information

Select

The Sync App uses the SAP Concur APIs to process filters that refer to any combination of TripId_p, OpportunityType_p, FromUtc_p, and ToUtc_p. The Sync App processes other filters client-side within the Sync App.

For example, the following query is processed server side:

SELECT * FROM Opportunities WHERE TripId_p = 'sampleTripId' AND OpportunityType_p = 'Hotel' AND FROMUtc_p = '2018-01-01 13:00:00' AND ToUtc_p = '2018-01-01 13:00:00'

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false.

Columns


Name	Type	References	Description
ID [KEY]	String		The unique identifier of the resource.
TripId	String		The trip id of the associated itinerary
EndCityCode	String		The city code of the destination city where the opportunity is offered
EndDateLocal	Datetime		The local end date of the location where the opportunity is offered
EndPostalCode	String		The postal code of the destination location where the opportunity is offered
IsActive	Bool		Indicates that the opportunity is currently active
StartCityCode	String		The city code of the originating city where the opportunity is offered
StartDateLocal	Datetime		The local start date of the location where the opportunity is offered
StartPostalCode	String		The postal code of the originating location where the opportunity is offered
Type	String		The type of opportunity
URI	String		The URI to the resource.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
OpportunityType_p	String		Comma seperated list of opportunities (Hotel, Car, Air, Rail, Taxi and Service) to get. Do not specify any values to get all opportunities
TripId_p	String		The trip id
ToUtc_p	String		The To date in UTC for the date range
FromUtc_p	String		The From date in UTC for the date range

PaymentBatches

Lists all the payment batches.

Table Specific Information

Select

The Sync App processes all searches to this table client-side within the Sync App. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false.

Columns


Name	Type	References	Description
Id [KEY]	String		The id of the batch.
BatchName	String		The batch name, as it appears in Payment Manager.
BatchTotal	Decimal		The number of payment demands in the batch.
Count	Integer		The name of the form.
Currency	String		The 3-letter ISO 4217 currency code for the batch.
PaymentMethod	String		The reimbursement method for the batch. Either Expense Pay by Concur, Company Check (via Accounts Payable), ADP (via EPIP file), or Other Reimbursement Methods.
Type	String		The payee of the batch. Either Employee or Card Program.
BatchUrl	String		The URL to use as a basis for other actions, such as closing the batch.

PaymentRequestDigests

A payment request digest is a collection of summarized payment requests to invoice vendors.

Table Specific Information

Select

At least one of the following columns should be specified in the WHERE clause:

approvalStatus
paymentStatus
vendorInvoiceNumber
createDateBefore
createDateAfter
userDefinedDateBefore
userDefinedDateAfter
submitDateBefore
submitDateAfter
paidDateBefore
paidDateAfter

For example:

SELECT * FROM PaymentRequestDigests WHERE approvalStatus = 'sampleApprovalStatus'

Columns


Name	Type	References	Description
ApprovalStatusCode	String		A code indicating the request's approval status.
CreateDate	String		The date the request was created.
CurrencyCode	String		The 3-letter ISO 4217 currency code for the request currency. Examples: USD - US dollars; BRL - Brazilian real; etc.
ID	String		The unique identifier of the resource.
InvoiceNumber	String		The invoice number of the payment request.
IsDeleted	String		A true/false value which indicates whether the request has been deleted. Deleted requests are retained in the system for historical purposes.
OwnerLoginID	String		The login ID of the payment request owner.
OwnerName	String		The name of the payment request owner.
PaidDate	String		The date when all journal entries in the request were integrated with or extracted to the financial system.
PaymentRequestId	String		The unique identifier of the payment request summarized in this digest.
PaymentRequestUri	String		The URI of the payment request summarized in this digest.
PaymentStatusCode	String		A code indicating the request's payment status.
PurchaseOrderNumber	String		The purchase order number for the purchase order associated with the invoice.
Total	String		The total amount of the request.
URI	String		The URI to the resource.
UserDefinedDate	String		The invoice date as assigned by the user.
VendorName	String		The name of the vendor.
VendorCode	String		The code of the vendor.
approvalStatus	String		A code representing a payment request approval status.
paymentStatus	String		A code representing a Payment Request Payment Status.
vendorInvoiceNumber	String		Vendor invoice number tied to invoice.
createDateBefore	String		The payment request create date is before this date. Format: YYYY-MM-DD.
createDateAfter	String		The payment request user defined date is after this date. Format: YYYY-MM-DD
userDefinedDateBefore	String		The payment request user defined date is before this date. Format: YYYY-MM-DD
userDefinedDateAfter	String		The payment request user defined date is after this date. Format: YYYY-MM-DD
submitDateBefore	String		The payment request submit date is before this date. Format: YYYY-MM-DD
submitDateAfter	String		The payment request submit date is after this date. Format: YYYY-MM-DD
paidDateBefore	String		The payment request paid date is before this date. Format: YYYY-MM-DD
paidDateAfter	String		The payment request paid date is after this date. Format: YYYY-MM-DD

ReportComments

Read the comments entered on the expense report header, or expenses of an existing expense report.

Table Specific Information

Select

The Sync App uses the SAP Concur APIs to process filters that refer to ReportId, UserId, and ContextType. The Sync App processes other filters client-side within the Sync App.

All 3 filters are required to query ReportComments. If ReportId is not specified, the Sync App will query the Reports table to retrieve the Id values. If ContextType is not specified, the default value will be TRAVELER. The UserId value should either be specified in the query or in the UserId connection property.

These are some example queries:

SELECT * FROM ReportComments
SELECT * FROM ReportComments WHERE UserId = '4b32882d-29t3-3f88-a738-c299ae3212'
SELECT * FROM ReportComments WHERE UserId = '4b32882d-29t3-3f88-a738-c299ae3212' AND ReportId IN ('288DG832423A4E5B6C4', '177DG832635A4E5B6D5')
SELECT * FROM ReportComments WHERE UserId = '4b32882d-29t3-3f88-a738-c299ae3212' AND ReportId IN ('288DG832423A4E5B6C4', '177DG832635A4E5B6D5') AND ContextType = 'PROXY'

Columns


Name	Type	References	Description
Comment	String		The comments input on the report by all users.
AuthorFirstName	String		The comment author's first name.
AuthorLastName	String		The comment author's last name.
AuthorMiddleInitial	String		The comment author's middle initial.
CreationDate	Datetime		The UTC datetime when the comment was created on the report or expense.
ExpenseId	String		The unique identifier of the expense.
IsAuditorComment	Boolean		If true, this attribute represents whether this comment has been authored by an auditor.
IsLatest	Boolean		If true, this attribute represents the latest comment by the user.
StepInstanceId	String		The unique identifier of the step instance.
CreatedForEmployeeId	String		The unique identifier of the employee the comment was created on behalf of.
CreatedForEmployeeFirstName	String		The first name of the employee the comment was created on behalf of.
CreatedForEmployeeLastName	String		The last name of the employee the comment was created on behalf of.
CreatedForEmployeeMiddleInitial	String		The middle initial of the employee the comment was created on behalf of.
ReportId	String		The unique identifier of the report that is being read.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
UserId	String		The unique identifier of the SAP Concur user. Query the Identity table to retrieve this value.
ContextType	String		The access level of the SAP Concur user, which determines the form fields they can view/modify. Supported values: TRAVELER, PROXY. Default value is TRAVELER.

ReportDetails

Retrieves the full set of information for the report.

Columns


Name	Type	References	Description
ReportID [KEY]	String		The unique identifier for the report, which appears in the Concur Expense UI. Maximum 32 character varchar.
UserLoginID	String		The user ID of the report owner. Maximum 128 characters.
EmployeeName	String		The name of the employee who created the report. Maximum 66 characters.
ReportKey	String		The unencrypted unique identifier for the report, that appears on the report header. The element appears only if the OAuth consumer has the Web Services Admin role in SAP Concur. Maximum 48 characters.
ReportName	String		The name of the report. Maximum 40 characters.
Purpose	String		The information from the Business Purpose field.
ReportDate	Datetime		The date from the report header. Format: YYYY-MM-DDThh:mm:ss
CreationDate	Datetime		The date the report was created. Format: YYYY-MM-DDThh:mm:ss
SubmitDate	Date		The date the report was submitted. Maximum 10 characters.
PaidDate	Datetime		The date the report was extracted for payment. Format: YYYY-MM-DDThh:mm:ss
CurrencyCode	String		The 3-letter ISO 4217 currency code for the expense report currency. The expense report currency is defined as the report creator's default reimbursement currency.
ReportTotal	Decimal		The total amount of the report. Maximum 23 characters.
PersonalExpenses	Decimal		The total amount of expenses marked as personal. Maximum 23 characters.
AmountDueEmployee	Decimal		The total amount due to the employee for the report. Maximum 23 characters.
AmountDueCompanyCard	Decimal		The total amount due to the company card for the report. Maximum 23 characters.
TotalClaimedAmount	Decimal		The total amount of all non-personal expenses in the report. Maximum 23 characters.
TotalApprovedAmount	Decimal		The total amount of approved expenses in the report. Maximum 23 characters.
ApprovalStatusCode	String		The approval status code for the report.
ApprovalStatusName	String		The approval status name for the report.
PaymentStatusCode	String		The unique identifier for the payment status of the report.
PaymentStatusName	String		The payment status of the report.
OrgUnit1	String		The details from the Org Unit custom fields. These may not have data, depending on configuration. Maximum 48 characters for each field.
OrgUnit2	String		The details from the Org Unit custom fields. These may not have data, depending on configuration. Maximum 48 characters for each field.
OrgUnit3	String		The details from the Org Unit custom fields. These may not have data, depending on configuration. Maximum 48 characters for each field.
OrgUnit4	String		The details from the Org Unit custom fields. These may not have data, depending on configuration. Maximum 48 characters for each field.
OrgUnit5	String		The details from the Org Unit custom fields. These may not have data, depending on configuration. Maximum 48 characters for each field.
OrgUnit6	String		The details from the Org Unit custom fields. These may not have data, depending on configuration. Maximum 48 characters for each field.
Custom1Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom1Value	String		The value in the custom field. Maximum 48 characters.
Custom1Code	String		Custom list fields will include the list item code in this element.
Custom2Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom2Value	String		The value in the custom field. Maximum 48 characters.
Custom2Code	String		Custom list fields will include the list item code in this element.
Custom3Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom3Value	String		The value in the custom field. Maximum 48 characters.
Custom3Code	String		Custom list fields will include the list item code in this element.
Custom4Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom4Value	String		The value in the custom field. Maximum 48 characters.
Custom4Code	String		Custom list fields will include the list item code in this element.
Custom5Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom5Value	String		The value in the custom field. Maximum 48 characters.
Custom5Code	String		Custom list fields will include the list item code in this element.
Custom6Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom6Value	String		The value in the custom field. Maximum 48 characters.
Custom6Code	String		Custom list fields will include the list item code in this element.
Custom7Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom7Value	String		The value in the custom field. Maximum 48 characters.
Custom7Code	String		Custom list fields will include the list item code in this element.
Custom8Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom8Value	String		The value in the custom field. Maximum 48 characters.
Custom8Code	String		Custom list fields will include the list item code in this element.
Custom9Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom9Value	String		The value in the custom field. Maximum 48 characters.
Custom9Code	String		Custom list fields will include the list item code in this element.
Custom10Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom10Value	String		The value in the custom field. Maximum 48 characters.
Custom10Code	String		Custom list fields will include the list item code in this element.
Custom11Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom11Value	String		The value in the custom field. Maximum 48 characters.
Custom11Code	String		Custom list fields will include the list item code in this element.
Custom12Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom12Value	String		The value in the custom field. Maximum 48 characters.
Custom12Code	String		Custom list fields will include the list item code in this element.
Custom13Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom13Value	String		The value in the custom field. Maximum 48 characters.
Custom13Code	String		Custom list fields will include the list item code in this element.
Custom14Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom14Value	String		The value in the custom field. Maximum 48 characters.
Custom14Code	String		Custom list fields will include the list item code in this element.
Custom15Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom15Value	String		The value in the custom field. Maximum 48 characters.
Custom15Code	String		Custom list fields will include the list item code in this element.
Custom16Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom16Value	String		The value in the custom field. Maximum 48 characters.
Custom16Code	String		Custom list fields will include the list item code in this element.
Custom17Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom17Value	String		The value in the custom field. Maximum 48 characters.
Custom17Code	String		Custom list fields will include the list item code in this element.
Custom18Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom18Value	String		The value in the custom field. Maximum 48 characters.
Custom18Code	String		Custom list fields will include the list item code in this element.
Custom19Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom19Value	String		The value in the custom field. Maximum 48 characters.
Custom19Code	String		Custom list fields will include the list item code in this element.
Custom20Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom20Value	String		The value in the custom field. Maximum 48 characters.
Custom20Code	String		Custom list fields will include the list item code in this element.
LedgerName	String		The name of the expense report ledger. Maximum 20 characters.
PolicyID	String		The unique identifier of the policy that applies to this report. Maximum 64 characters.
EverSentBack	String		Whether the report has ever been sent back to the employee. Format: Y/N
HasException	String		Whether the report has exceptions. Format: Y/N
WorkflowActionURL	String		The URL to post a workflow action to the report using the Post Report Workflow Action function.
Country	String		The report country. Maximum 2 characters. Format: The ISO 3166-1 alpha-2 country code. Example: United States is US.
CountrySubdivision	String		The report country subdivision. Format: ISO 3166-2:2007 country subdivision.
ProcessingPaymentDate	Date		The date that the report completed all approvals and was ready to be extracted for payment. Format: YYYY-MM-DD
ReceiptsReceived	String		If Y, then this report has its receipt receipt confirmed by the Expense Processor. Format: Y/N
ReportOwnerEmployeeCustom21	String		The report owner's group ID. Maximum 48 characters.
ReportOwnerEmployeeID	String		Employee ID often also serves as the employee's Vendor ID for AP system integrations or Payroll ID for Payroll integrations. Maximum 48 characters.
ReportOwnerEmployeeOrgUnit1	String		The report owner's organizational unit information. Maximum 48 characters for each field.
ReportOwnerEmployeeOrgUnit2	String		The report owner's organizational unit information. Maximum 48 characters for each field.
ReportOwnerEmployeeOrgUnit3	String		The report owner's organizational unit information. Maximum 48 characters for each field.
ReportOwnerEmployeeOrgUnit4	String		The report owner's organizational unit information. Maximum 48 characters for each field.
ReportOwnerEmployeeOrgUnit5	String		The report owner's organizational unit information. Maximum 48 characters for each field.
ReportOwnerEmployeeOrgUnit6	String		The report owner's organizational unit information. Maximum 48 characters for each field.
ReportOwnerFirstName	String		The report owner's first name. Maximum 32 characters.
ReportOwnerLastName	String		The report owner's last name. Maximum 32 characters.
ReportOwnerMiddleInitial	String		The report owner's middle initial. Maximum 1 character.
ReportOwnerReimbursementMethodCode	String		The report owner's reimbursement method code, as defined in the employee's Profile.
EmployeeBankAccountBankNumber	String		The bank identification number entered on the Bank Information page. Maximum 11 characters.
EmployeeBankAccountBankName	String		The bank name entered on the Bank Information page. Maximum 48 characters.
EmployeeBankAccountBranchLocation	String		The branch location entered on the Bank Information page. Maximum 30 characters.
EmployeeBankAccountAccountNumber	String		The bank account number entered on the Bank Information page. Maximum 100 characters.
EmployeeBankAccountAccountName	String		The name on the account entered on the Bank Information page.
EmployeeBankAccountPostalAddressLine1	String		The postal address line 1 entered on the Bank Information page. Maximum 48 characters.
EmployeeBankAccountPostalAddressLine2	String		The postal address line 2 entered on the Bank Information page. Maximum 48 characters.
EmployeeBankAccountPostalAddressCity	String		The postal address city entered on the Bank Information page. Maximum 24 characters.
EmployeeBankAccountPostalAddressRegion	String		The postal address region entered on the Bank Information page. Maximum 24 characters.
EmployeeBankAccountPostalAddressCode	String		The postal address code entered on the Bank Information page. Maximum 20 characters.
EmployeeBankAccountPostalAddressCountry	String		The postal address country entered on the Bank Information page. Maximum 2 characters. Format: The ISO 3166-1 alpha-2 country code. Example: United States is US.

ReportDetailsExpenseEntry

Lists all expense entries

Columns


Name	Type	References	Description
ReportID	String		The unique identifier for the report, which appears in the Concur Expense UI. Maximum 32 character varchar.
ReportEntryID [KEY]	String		The ID of the report entry. Maximum 13 characters.
ExpenseTypeID	String		The expense type ID for the expense entry. Expense Type IDs are returned in the ExpKey element by the Get Expense Group Configuration endpoint.
ExpenseTypeName	String		The expense type name. Maximum 64 characters.
SpendCategory	String		The spend category specified for this expense type. Varies by client, used in reporting.
PaymentTypeCode	String		The code for the payment type. Maximum 4 characters.
PaymentTypeName	String		The name for the payment type. Maximum 80 characters.
TransactionDate	Date		The date of the expense entry. Maximum 10 characters. Format: YYYY-MM-DD
TransactionCurrencyName	String		The name of the transaction currency. Example: US, Dollar
ExchangeRate	String		The exchange rate that applies to the entry. Maximum 23 characters.
TransactionAmount	String		The amount of the expense entry in the original transaction currency. Maximum 23 characters.
PostedAmount	String		The amount of the expense entry in the user's reimbursement currency. The user's reimbursement currency is returned in the CrnCode element for the report. Maximum 23 characters.
ApprovedAmount	String		The approved amount of the expense entry in the user's reimbursement currency.The user's reimbursement currency is returned in the CrnCode element for the report. Maximum 23 characters.
BusinessPurpose	String		The text from the Business Purpose field of the entry. Maximum 64 characters.
VendorDescription	String		The vendor name of the expense entry, which can be entered manually by the user or imported from the card transaction Merchant Name field. Maximum 64 characters.
LocationName	String		The location for the expense entry, usually the city name.
LocationSubdivision	String		The location's State, Province, or Country Subdivision. Maximum 6 characters.
LocationCountry	String		The location's Country. Maximum 2 characters.
OrgUnit1	String		The details from the Org Unit custom fields. These may not have data, depending on configuration. Maximum 48 characters for each field.
OrgUnit2	String		The details from the Org Unit custom fields. These may not have data, depending on configuration. Maximum 48 characters for each field.
OrgUnit3	String		The details from the Org Unit custom fields. These may not have data, depending on configuration. Maximum 48 characters for each field.
OrgUnit4	String		The details from the Org Unit custom fields. These may not have data, depending on configuration. Maximum 48 characters for each field.
OrgUnit5	String		The details from the Org Unit custom fields. These may not have data, depending on configuration. Maximum 48 characters for each field.
OrgUnit6	String		The details from the Org Unit custom fields. These may not have data, depending on configuration. Maximum 48 characters for each field.
Custom1Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom1Value	String		The value in the custom field. Maximum 48 characters.
Custom1Code	String		Custom list fields will include the list item code in this element.
Custom2Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom2Value	String		The value in the custom field. Maximum 48 characters.
Custom2Code	String		Custom list fields will include the list item code in this element.
Custom3Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom3Value	String		The value in the custom field. Maximum 48 characters.
Custom3Code	String		Custom list fields will include the list item code in this element.
Custom4Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom4Value	String		The value in the custom field. Maximum 48 characters.
Custom4Code	String		Custom list fields will include the list item code in this element.
Custom5Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom5Value	String		The value in the custom field. Maximum 48 characters.
Custom5Code	String		Custom list fields will include the list item code in this element.
Custom6Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom6Value	String		The value in the custom field. Maximum 48 characters.
Custom6Code	String		Custom list fields will include the list item code in this element.
Custom7Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom7Value	String		The value in the custom field. Maximum 48 characters.
Custom7Code	String		Custom list fields will include the list item code in this element.
Custom8Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom8Value	String		The value in the custom field. Maximum 48 characters.
Custom8Code	String		Custom list fields will include the list item code in this element.
Custom9Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom9Value	String		The value in the custom field. Maximum 48 characters.
Custom9Code	String		Custom list fields will include the list item code in this element.
Custom10Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom10Value	String		The value in the custom field. Maximum 48 characters.
Custom10Code	String		Custom list fields will include the list item code in this element.
Custom11Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom11Value	String		The value in the custom field. Maximum 48 characters.
Custom11Code	String		Custom list fields will include the list item code in this element.
Custom12Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom12Value	String		The value in the custom field. Maximum 48 characters.
Custom12Code	String		Custom list fields will include the list item code in this element.
Custom13Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom13Value	String		The value in the custom field. Maximum 48 characters.
Custom13Code	String		Custom list fields will include the list item code in this element.
Custom14Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom14Value	String		The value in the custom field. Maximum 48 characters.
Custom14Code	String		Custom list fields will include the list item code in this element.
Custom15Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom15Value	String		The value in the custom field. Maximum 48 characters.
Custom15Code	String		Custom list fields will include the list item code in this element.
Custom16Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom16Value	String		The value in the custom field. Maximum 48 characters.
Custom16Code	String		Custom list fields will include the list item code in this element.
Custom17Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom17Value	String		The value in the custom field. Maximum 48 characters.
Custom17Code	String		Custom list fields will include the list item code in this element.
Custom18Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom18Value	String		The value in the custom field. Maximum 48 characters.
Custom18Code	String		Custom list fields will include the list item code in this element.
Custom19Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom19Value	String		The value in the custom field. Maximum 48 characters.
Custom19Code	String		Custom list fields will include the list item code in this element.
Custom20Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom20Value	String		The value in the custom field. Maximum 48 characters.
Custom20Code	String		Custom list fields will include the list item code in this element.
Custom21Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom21Value	String		The value in the custom field. Maximum 48 characters.
Custom21Code	String		Custom list fields will include the list item code in this element.
Custom22Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom22Value	String		The value in the custom field. Maximum 48 characters.
Custom22Code	String		Custom list fields will include the list item code in this element.
Custom23Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom23Value	String		The value in the custom field. Maximum 48 characters.
Custom23Code	String		Custom list fields will include the list item code in this element.
Custom24Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom24Value	String		The value in the custom field. Maximum 48 characters.
Custom24Code	String		Custom list fields will include the list item code in this element.
Custom25Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom25Value	String		The value in the custom field. Maximum 48 characters.
Custom25Code	String		Custom list fields will include the list item code in this element.
Custom26Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom26Value	String		The value in the custom field. Maximum 48 characters.
Custom26Code	String		Custom list fields will include the list item code in this element.
Custom27Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom27Value	String		The value in the custom field. Maximum 48 characters.
Custom27Code	String		Custom list fields will include the list item code in this element.
Custom28Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom28Value	String		The value in the custom field. Maximum 48 characters.
Custom28Code	String		Custom list fields will include the list item code in this element.
Custom29Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom29Value	String		The value in the custom field. Maximum 48 characters.
Custom29Code	String		Custom list fields will include the list item code in this element.
Custom30Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom30Value	String		The value in the custom field. Maximum 48 characters.
Custom30Code	String		Custom list fields will include the list item code in this element.
Custom31Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom31Value	String		The value in the custom field. Maximum 48 characters.
Custom31Code	String		Custom list fields will include the list item code in this element.
Custom32Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom32Value	String		The value in the custom field. Maximum 48 characters.
Custom32Code	String		Custom list fields will include the list item code in this element.
Custom33Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom33Value	String		The value in the custom field. Maximum 48 characters.
Custom33Code	String		Custom list fields will include the list item code in this element.
Custom34Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom34Value	String		The value in the custom field. Maximum 48 characters.
Custom34Code	String		Custom list fields will include the list item code in this element.
Custom35Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom35Value	String		The value in the custom field. Maximum 48 characters.
Custom35Code	String		Custom list fields will include the list item code in this element.
Custom36Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom36Value	String		The value in the custom field. Maximum 48 characters.
Custom36Code	String		Custom list fields will include the list item code in this element.
Custom37Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom37Value	String		The value in the custom field. Maximum 48 characters.
Custom37Code	String		Custom list fields will include the list item code in this element.
Custom38Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom38Value	String		The value in the custom field. Maximum 48 characters.
Custom38Code	String		Custom list fields will include the list item code in this element.
Custom39Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom39Value	String		The value in the custom field. Maximum 48 characters.
Custom39Code	String		Custom list fields will include the list item code in this element.
Custom40Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom40Value	String		The value in the custom field. Maximum 48 characters.
Custom40Code	String		Custom list fields will include the list item code in this element.
FormID	String		The ID for the expense entry form.
EntryImageID	String		The unique identifier for the image associated with the entry.
HasVat	String		Whether the entry contains VAT data. Maximum 1 character. Format: Y/N
HasComments	String		Whether the expense entry has comments. Maximum 1 character. Format: Y/N
CommentCount	String		The number of comments associated with the expense entry.
IsItemized	String		Whether the expense entry is itemized. Maximum 1 character. Format: Y/N
HasExceptions	String		Whether the expense entry has exceptions. Maximum 1 character. Format: Y/N
IsPersonal	String		Whether the expense entry is marked as personal. Maximum 1 character. Format: Y/N
HasAttendees	String		Whether the expense entry has attendees. Maximum 1 character. Format: Y/N
HasAllocation	String		Defines the amount of allocations for the expense. Maximum 1 character. Possible values are: P, for partial allocation, F, for full allocation, or N, for no allocation.
IsCreditCardCharge	String		Whether the expense came from a credit card feed. Maximum 1 character. Format: Y/N
IsPersonalCardCharge	String		Whether the expense came from a personal card feed. Maximum 1 character. Format: Y/N
ReceiptRequired	String		Whether the original receipt is required for the entry. Maximum 1 character. Format: Y/N
ImageRequired	String		Whether a receipt image is required for the entry. Maximum 1 character. Format: Y/N
EReceiptID	String		The ID for the attached e-receipt, if available.
LastModifiedDate	Datetime		The date the expense entry was last changed. Maximum 19 characters. Format: YYYY-MM-DDThh:mm:ss
ReportEntryVendorName	String		Vendor name the employee selected from the Vendor list field. Maximum 64 characters.
ReportEntryReceiptReceived	String		If Y, then this entry has been marked as reviewed by a processor. Maximum 1 character. Format: Y/N
ReportEntryReceiptType	String		Maximum 1 character. One of these: T = tax receipt, R= regular receipt, N = no receipt
CardTransactionAccountNumber	String		Credit card number used for this expense. This value is encrypted in the response. Maximum 255 characters.
CardTransactionCardDescription	String		The name on the credit card used for this expense. Maximum 255 characters.
CardTransactionCardTypeCode	String		Type of credit card.
CardTransactionTransactionReferenceNumber	String		Reference number from the credit card vendor. Maximum 64 characters.
CardTransactionTransactionCCTType	String		Transaction type supplied by card vendor. Maximum 3 characters. One of these: ANF = Annual Fees, CAV = Cash Advance, CCF = Cash and Check Fees, CHG = Other Bank Charges and Fees, FNC = Finance Charges, LAF = Late Fees, NSF = Insufficient Funds Check Fees, PAY = Payment, RPE = Credit Card Transaction
CardTransactionTransactionID	String		Calculated value assigned to this card entry during the import process. Maximum 32 characters.
CardTransactionTransactionAmount	String		Amount of the charge in the spend currency. Maximum 23 characters.
CardTransactionTaxAmount	String		Amount of tax on the transaction amount (if provided by card vendor). Maximum 23 characters.
CardTransactionTransactionAlphaCode	String		Currency code for the spend currency. Maximum 3 characters. Format: ISO 4217 3 digit alpha code
CardTransactionPostedAmount	String		Amount of the charge in the billing currency of the card. Maximum 23 characters.
CardTransactionPostedAlphaCode	String		Currency code for the card billing currency. Maximum 3 characters. Format: ISO 4217 3 digit alpha code
CardTransactionTransactionDate	Date		Date the charge was made at the merchant. Maximum 10 characters.
CardTransactionPostedDate	Date		Date the charge was posted to the credit card account. Maximum 10 characters.
CardTransactionDescription	String		Description of the charge from the merchant. Maximum 42 characters.
CardTransactionMasterCardCode	String		Merchant code sent from the credit card vendor. Maximum 5 characters.
CardTransactionTransactionMerchantName	String		Name of the merchant. Maximum 50 characters.
CardTransactionMerchantCity	String		Merchant city. Maximum 40 characters.
CardTransactionMerchantState	String		Merchant State/Province. Maximum 32 characters.
CardTransactionMerchantCountryCode	String		Merchant country location code. Format: 2 digit alpha code
CardTransactionMerchantReferenceNumber	String		Merchant reference number passed from the merchant to the card. Maximum 15 characters.
CardTransactionExchangeRateFromBillingToEmployeeCurrency	String		Currency exchange rate used between the credit card billing currency and the employee's reimbursement currency. Maximum 23 characters.
CardTransactionBillingAmount	String		Amount due to the company card from the employee or company (depending on who is responsible for the bill) for this detail row. Maximum 23 characters.
CardTransactionAccountNumberLastSegment	String		The last 4 digits of the Card Account.
ExpensePay	String		Whether the entry was paid using the Expense Pay service. This element has a value if the report has reached the Processing Payment workflow step. Format: Yes/No

ReportDetailsExpenseEntryItemization

Lists all itemizations of an expense entry

Columns


Name	Type	References	Description
ReportID	String		The unique identifier for the report, which appears in the Concur Expense UI. Maximum 32 character varchar.
ReportEntryID	String		The ID of the report entry. Maximum 13 characters.
ItemizationID [KEY]	String		The unique identifier for the itemization. Maximum 19 characters.
ItemType	String		The type of itemization. If the expense entry does not have any itemizations, this will be set to Regular. If the expense entry contains itemizations, each one will be set to Child.
ExpenseTypeID	String		The expense type ID for the itemization.
ExpenseTypeName	String		The expense type for the itemization. Maximum 64 characters.
TransactionDate	Date		The date of the transaction. Maximum 10 characters. Format: YYYY-MM-DD
TransactionAmount	String		The amount for the itemization in the expense currency. Maximum 23 characters.
PostedAmount	String		The amount for the itemization in the user's reimbursement currency. The user's reimbursement currency is returned in the CrnCode element for the report. Maximum 23 characters.
ApprovedAmount	String		The approved amount of the itemization in the user's reimbursement currency. The user's reimbursement currency is returned in the CrnCode element for the report. Maximum 23 characters.
BusinessPurpose	String		The business purpose field from the report header.
OrgUnit1	String		The details from the Org Unit custom fields. These may not have data, depending on configuration. Maximum 48 characters for each field.
OrgUnit2	String		The details from the Org Unit custom fields. These may not have data, depending on configuration. Maximum 48 characters for each field.
OrgUnit3	String		The details from the Org Unit custom fields. These may not have data, depending on configuration. Maximum 48 characters for each field.
OrgUnit4	String		The details from the Org Unit custom fields. These may not have data, depending on configuration. Maximum 48 characters for each field.
OrgUnit5	String		The details from the Org Unit custom fields. These may not have data, depending on configuration. Maximum 48 characters for each field.
OrgUnit6	String		The details from the Org Unit custom fields. These may not have data, depending on configuration. Maximum 48 characters for each field.
Custom1Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom1Value	String		The value in the custom field. Maximum 48 characters.
Custom1Code	String		Custom list fields will include the list item code in this element.
Custom2Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom2Value	String		The value in the custom field. Maximum 48 characters.
Custom2Code	String		Custom list fields will include the list item code in this element.
Custom3Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom3Value	String		The value in the custom field. Maximum 48 characters.
Custom3Code	String		Custom list fields will include the list item code in this element.
Custom4Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom4Value	String		The value in the custom field. Maximum 48 characters.
Custom4Code	String		Custom list fields will include the list item code in this element.
Custom5Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom5Value	String		The value in the custom field. Maximum 48 characters.
Custom5Code	String		Custom list fields will include the list item code in this element.
Custom6Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom6Value	String		The value in the custom field. Maximum 48 characters.
Custom6Code	String		Custom list fields will include the list item code in this element.
Custom7Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom7Value	String		The value in the custom field. Maximum 48 characters.
Custom7Code	String		Custom list fields will include the list item code in this element.
Custom8Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom8Value	String		The value in the custom field. Maximum 48 characters.
Custom8Code	String		Custom list fields will include the list item code in this element.
Custom9Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom9Value	String		The value in the custom field. Maximum 48 characters.
Custom9Code	String		Custom list fields will include the list item code in this element.
Custom10Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom10Value	String		The value in the custom field. Maximum 48 characters.
Custom10Code	String		Custom list fields will include the list item code in this element.
Custom11Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom11Value	String		The value in the custom field. Maximum 48 characters.
Custom11Code	String		Custom list fields will include the list item code in this element.
Custom12Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom12Value	String		The value in the custom field. Maximum 48 characters.
Custom12Code	String		Custom list fields will include the list item code in this element.
Custom13Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom13Value	String		The value in the custom field. Maximum 48 characters.
Custom13Code	String		Custom list fields will include the list item code in this element.
Custom14Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom14Value	String		The value in the custom field. Maximum 48 characters.
Custom14Code	String		Custom list fields will include the list item code in this element.
Custom15Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom15Value	String		The value in the custom field. Maximum 48 characters.
Custom15Code	String		Custom list fields will include the list item code in this element.
Custom16Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom16Value	String		The value in the custom field. Maximum 48 characters.
Custom16Code	String		Custom list fields will include the list item code in this element.
Custom17Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom17Value	String		The value in the custom field. Maximum 48 characters.
Custom17Code	String		Custom list fields will include the list item code in this element.
Custom18Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom18Value	String		The value in the custom field. Maximum 48 characters.
Custom18Code	String		Custom list fields will include the list item code in this element.
Custom19Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom19Value	String		The value in the custom field. Maximum 48 characters.
Custom19Code	String		Custom list fields will include the list item code in this element.
Custom20Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom20Value	String		The value in the custom field. Maximum 48 characters.
Custom20Code	String		Custom list fields will include the list item code in this element.
Custom21Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom21Value	String		The value in the custom field. Maximum 48 characters.
Custom21Code	String		Custom list fields will include the list item code in this element.
Custom22Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom22Value	String		The value in the custom field. Maximum 48 characters.
Custom22Code	String		Custom list fields will include the list item code in this element.
Custom23Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom23Value	String		The value in the custom field. Maximum 48 characters.
Custom23Code	String		Custom list fields will include the list item code in this element.
Custom24Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom24Value	String		The value in the custom field. Maximum 48 characters.
Custom24Code	String		Custom list fields will include the list item code in this element.
Custom25Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom25Value	String		The value in the custom field. Maximum 48 characters.
Custom25Code	String		Custom list fields will include the list item code in this element.
Custom26Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom26Value	String		The value in the custom field. Maximum 48 characters.
Custom26Code	String		Custom list fields will include the list item code in this element.
Custom27Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom27Value	String		The value in the custom field. Maximum 48 characters.
Custom27Code	String		Custom list fields will include the list item code in this element.
Custom28Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom28Value	String		The value in the custom field. Maximum 48 characters.
Custom28Code	String		Custom list fields will include the list item code in this element.
Custom29Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom29Value	String		The value in the custom field. Maximum 48 characters.
Custom29Code	String		Custom list fields will include the list item code in this element.
Custom30Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom30Value	String		The value in the custom field. Maximum 48 characters.
Custom30Code	String		Custom list fields will include the list item code in this element.
Custom31Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom31Value	String		The value in the custom field. Maximum 48 characters.
Custom31Code	String		Custom list fields will include the list item code in this element.
Custom32Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom32Value	String		The value in the custom field. Maximum 48 characters.
Custom32Code	String		Custom list fields will include the list item code in this element.
Custom33Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom33Value	String		The value in the custom field. Maximum 48 characters.
Custom33Code	String		Custom list fields will include the list item code in this element.
Custom34Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom34Value	String		The value in the custom field. Maximum 48 characters.
Custom34Code	String		Custom list fields will include the list item code in this element.
Custom35Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom35Value	String		The value in the custom field. Maximum 48 characters.
Custom35Code	String		Custom list fields will include the list item code in this element.
Custom36Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom36Value	String		The value in the custom field. Maximum 48 characters.
Custom36Code	String		Custom list fields will include the list item code in this element.
Custom37Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom37Value	String		The value in the custom field. Maximum 48 characters.
Custom37Code	String		Custom list fields will include the list item code in this element.
Custom38Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom38Value	String		The value in the custom field. Maximum 48 characters.
Custom38Code	String		Custom list fields will include the list item code in this element.
Custom39Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom39Value	String		The value in the custom field. Maximum 48 characters.
Custom39Code	String		Custom list fields will include the list item code in this element.
Custom40Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom40Value	String		The value in the custom field. Maximum 48 characters.
Custom40Code	String		Custom list fields will include the list item code in this element.
Value	String		The value in the custom field. Maximum 48 characters.
Code	String		Custom list fields will include the list item code in this element.
HasComments	String		Whether the itemization has comments. Maximum 1 character. Format: Y/N
CommentCount	String		The number of comments associated with the itemization.
IsPersonal	String		Whether the itemization is personal. Maximum 1 character. Format: Y/N
LastModified	Datetime		The UTC date when the itemization was last modified. Maximum 19 characters. Format: YYYY-MM-DDThh:mm:ss

ReportDetailsExpenseEntryItemizationAllocation

Lists all allocations of an itemization

Columns


Name	Type	References	Description
ReportID	String		The unique identifier for the report, which appears in the Concur Expense UI. Maximum 32 character varchar.
ReportEntryID	String		The ID of the report entry. Maximum 13 characters.
ItemizationID	String		The unique identifier for the itemization. Maximum 19 characters.
AllocationID [KEY]	String		The unique alphanumeric identifier for the allocation. Maximum 13 characters.
Percentage	String		The percentage of the expense that is included in this allocation. Maximum 11 characters.
AccountCode1	String		The primary accounting code assigned to the expense type associated with this allocation. Typically, expense types have only this primary account code.
AccountCode2	String		The secondary or alternative accounting code assigned to the expense type associated with this allocation. In rare cases some expense types include this accounting code to handle special cases. One example of these special cases is when using travel allowance, where one expense would use the primary account code for the allowed amount, and the alternative account code for the overage. Another example is personal use of a company car. Refer to the Expense: Account Codes Setup Guide for more information on how Concur Expense determines which accounting codes to use.
Custom1Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom1Value	String		The value in the custom field. Maximum 48 characters.
Custom1Code	String		Custom list fields will include the list item code in this element.
Custom2Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom2Value	String		The value in the custom field. Maximum 48 characters.
Custom2Code	String		Custom list fields will include the list item code in this element.
Custom3Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom3Value	String		The value in the custom field. Maximum 48 characters.
Custom3Code	String		Custom list fields will include the list item code in this element.
Custom4Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom4Value	String		The value in the custom field. Maximum 48 characters.
Custom4Code	String		Custom list fields will include the list item code in this element.
Custom5Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom5Value	String		The value in the custom field. Maximum 48 characters.
Custom5Code	String		Custom list fields will include the list item code in this element.
Custom6Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom6Value	String		The value in the custom field. Maximum 48 characters.
Custom6Code	String		Custom list fields will include the list item code in this element.
Custom7Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom7Value	String		The value in the custom field. Maximum 48 characters.
Custom7Code	String		Custom list fields will include the list item code in this element.
Custom8Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom8Value	String		The value in the custom field. Maximum 48 characters.
Custom8Code	String		Custom list fields will include the list item code in this element.
Custom9Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom9Value	String		The value in the custom field. Maximum 48 characters.
Custom9Code	String		Custom list fields will include the list item code in this element.
Custom10Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom10Value	String		The value in the custom field. Maximum 48 characters.
Custom10Code	String		Custom list fields will include the list item code in this element.
Custom11Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom11Value	String		The value in the custom field. Maximum 48 characters.
Custom11Code	String		Custom list fields will include the list item code in this element.
Custom12Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom12Value	String		The value in the custom field. Maximum 48 characters.
Custom12Code	String		Custom list fields will include the list item code in this element.
Custom13Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom13Value	String		The value in the custom field. Maximum 48 characters.
Custom13Code	String		Custom list fields will include the list item code in this element.
Custom14Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom14Value	String		The value in the custom field. Maximum 48 characters.
Custom14Code	String		Custom list fields will include the list item code in this element.
Custom15Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom15Value	String		The value in the custom field. Maximum 48 characters.
Custom15Code	String		Custom list fields will include the list item code in this element.
Custom16Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom16Value	String		The value in the custom field. Maximum 48 characters.
Custom16Code	String		Custom list fields will include the list item code in this element.
Custom17Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom17Value	String		The value in the custom field. Maximum 48 characters.
Custom17Code	String		Custom list fields will include the list item code in this element.
Custom18Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom18Value	String		The value in the custom field. Maximum 48 characters.
Custom18Code	String		Custom list fields will include the list item code in this element.
Custom19Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom19Value	String		The value in the custom field. Maximum 48 characters.
Custom19Code	String		Custom list fields will include the list item code in this element.
Custom20Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom20Value	String		The value in the custom field. Maximum 48 characters.
Custom20Code	String		Custom list fields will include the list item code in this element.

ReportDetailsExpenseEntryItemizationAllocationJournalEntry

Lists all allocations of an itemization

Columns


Name	Type	References	Description
ReportID	String		The unique identifier for the report, which appears in the Concur Expense UI. Maximum 32 character varchar.
ReportEntryID	String		The ID of the report entry. Maximum 13 characters.
ItemizationID	String		The unique identifier for the itemization. Maximum 19 characters.
AllocationID	String		The unique alphanumeric identifier for the allocation. Maximum 13 characters.
JournalID [KEY]	String		Unique identifier for the journal entry.
PayerPaymentTypeName	String		Payer payment type. Maximum 64 characters. One of these:, Company = Company, Employee = Employee, Payment Type for the Credit Card Payment Type
PayerPaymentTypeCode	String		Payment code name for the payer. Maximum 80 characters.
PayeePaymentTypeName	String		Payee payment type. Maximum 64 characters. One of these:, Company = Company, Employee = Employee, Payment Type for the Credit Card Payment Type
PayeePaymentCode	String		Payment code name for the payee. Maximum 80 characters.
AccountCode	String		The account code Concur Expense determines should apply to this journal entry. For journal entries associated to an allocation, Concur Expense uses the business logic described in the Expense: Account Codes Setup Guide to determine whether the primary or secondary account code should apply. When there is no allocation associated to the journal entry, Concur Expense uses clearing account codes for Credit Card and Cash Advance for personal use of a company paid expense or a cash advance issued to an employee respectively. Maximum 48 characters. NOTE: The developer should almost always use this accounting code when creating financial transactions in financial systems. In some situations a developer may need to use the accounting codes in the Allocation parent element.
DebitOrCredit	String		Maximum 2 characters. Either: DR = Debit, CR = Credit
Amount	String		Value, as credit or debit, of the amount to be exchanged between the payer and payee for this expense account code (not an absolute value) Maximum 23 characters.
JobRunKey	String		Either the unique identifier for job run for the accounting extract that processed this journal, or a static value indicating the journal was processed by Manual Pay, Expense Pay, or some other system.

ReportDetailsExpenseEntryItemizationAllocationVATData

Lists all allocations of an itemization

Columns


Name	Type	References	Description
ReportID	String		The unique identifier for the report, which appears in the Concur Expense UI. Maximum 32 character varchar.
ReportEntryID	String		The ID of the report entry. Maximum 13 characters.
ItemizationID	String		The unique identifier for the itemization. Maximum 19 characters.
AllocationID	String		The unique alphanumeric identifier for the allocation. Maximum 13 characters.
TaxName	String		Tax authority name. Maximum 50 characters.
TaxAuthorityLabel	String		5-digit code that appears on the expense entry pages. Maximum 5 characters.
TaxTransactionAmount	String		Calculated tax amount for this expense in the spend currency. Maximum 23 characters.
TaxPostedAmount	String		Calculated tax amount for this expense entry in the reimbursement currency. Maximum 23 characters.
Source	String		Specifies how the tax data was derived. Maximum 4 characters. One of these: CARD = Provided from company card, USER = Entered by employee, SYST = Calculated by system, PROC = Entered by processor
TaxReclaimTransactionAmount	String		Calculated amount of tax eligible for reclaim in the spend currency. Maximum 23 characters.
TaxReclaimPostedAmount	String		Calculated amount of tax eligible for reclaim in the reimbursement currency. Maximum 23 characters.

ReportDetailsExpenseEntryItemizationAttendee

Lists all allocations of an itemization

Columns


Name	Type	References	Description
ReportID	String		The unique identifier for the report, which appears in the Concur Expense UI. Maximum 32 character varchar.
ReportEntryID	String		The ID of the report entry. Maximum 13 characters.
ItemizationID	String		The unique identifier for the itemization. Maximum 19 characters.
AttendeeID [KEY]	String		Attendee unique identifier within SAP Concur.
AttendeeType	String		The type of attendee. Maximum 40 characters.
FirstName	String		The attendee's first name. Maximum 50 characters.
LastName	String		The attendee's last name. Maximum 132 characters.
Company	String		The attendee's company name. Maximum 150 characters.
Title	String		The attendee's title. Maximum 32 characters.
ExternalID	String		The unique identifier for the attendee, managed outside SAP Concur. Maximum 48 characters.
Custom1Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom1Value	String		The value in the custom field. Maximum 48 characters.
Custom1Code	String		Custom list fields will include the list item code in this element.
Custom2Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom2Value	String		The value in the custom field. Maximum 48 characters.
Custom2Code	String		Custom list fields will include the list item code in this element.
Custom3Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom3Value	String		The value in the custom field. Maximum 48 characters.
Custom3Code	String		Custom list fields will include the list item code in this element.
Custom4Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom4Value	String		The value in the custom field. Maximum 48 characters.
Custom4Code	String		Custom list fields will include the list item code in this element.
Custom5Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom5Value	String		The value in the custom field. Maximum 48 characters.
Custom5Code	String		Custom list fields will include the list item code in this element.
Custom6Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom6Value	String		The value in the custom field. Maximum 48 characters.
Custom6Code	String		Custom list fields will include the list item code in this element.
Custom7Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom7Value	String		The value in the custom field. Maximum 48 characters.
Custom7Code	String		Custom list fields will include the list item code in this element.
Custom8Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom8Value	String		The value in the custom field. Maximum 48 characters.
Custom8Code	String		Custom list fields will include the list item code in this element.
Custom9Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom9Value	String		The value in the custom field. Maximum 48 characters.
Custom9Code	String		Custom list fields will include the list item code in this element.
Custom10Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom10Value	String		The value in the custom field. Maximum 48 characters.
Custom10Code	String		Custom list fields will include the list item code in this element.
Custom11Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom11Value	String		The value in the custom field. Maximum 48 characters.
Custom11Code	String		Custom list fields will include the list item code in this element.
Custom12Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom12Value	String		The value in the custom field. Maximum 48 characters.
Custom12Code	String		Custom list fields will include the list item code in this element.
Custom13Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom13Value	String		The value in the custom field. Maximum 48 characters.
Custom13Code	String		Custom list fields will include the list item code in this element.
Custom14Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom14Value	String		The value in the custom field. Maximum 48 characters.
Custom14Code	String		Custom list fields will include the list item code in this element.
Custom15Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom15Value	String		The value in the custom field. Maximum 48 characters.
Custom15Code	String		Custom list fields will include the list item code in this element.
Custom16Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom16Value	String		The value in the custom field. Maximum 48 characters.
Custom16Code	String		Custom list fields will include the list item code in this element.
Custom17Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom17Value	String		The value in the custom field. Maximum 48 characters.
Custom17Code	String		Custom list fields will include the list item code in this element.
Custom18Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom18Value	String		The value in the custom field. Maximum 48 characters.
Custom18Code	String		Custom list fields will include the list item code in this element.
Custom19Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom19Value	String		The value in the custom field. Maximum 48 characters.
Custom19Code	String		Custom list fields will include the list item code in this element.
Custom20Type	String		The custom field type. Will be one of the following: Amount, Boolean, ConnectedList, Date, Integer, List, Number, Text
Custom20Value	String		The value in the custom field. Maximum 48 characters.
Custom20Code	String		Custom list fields will include the list item code in this element.
HasExceptionsPrevYear	String		Whether the attendee has exceptions in the previous year, based on yearly total limits for attendees. Maximum 1 character. Format: Y/N
HasExceptionsYTD	String		Whether the attendee has exceptions in the current year, based on yearly total limits for attendees. Maximum 1 character. Format: Y/N
IsDeleted	String		Whether the attendee is marked as deleted. Maximum 1 character. Format: Y/N
OwnerName	String		The name of the employee that owns the attendee record.
TotalAmountPrevYear	String		The total amount spent on the attendee in the previous calendar year.
TotalAmountYTD	String		The total amount spent on the attendee in the current calendar year.
VersionNumber	String		The attendee's version number.
AttendeeTypeCode	String		The unique identifier for the attendee type.
AttendeeOwnerID	String		The unique identifier for the person or system that owns the attendee.
CurrencyCode	String		The 3-letter ISO 4217 currency code for attendee related amounts.

Suppliers

Lists Suppliers based on the search criteria.

Table Specific Information

Select

To query this table, the WHERE clause must contain the Id or one of the following sets of columns:

Name_p
Phone_p
Address_p, City_p, and State_p

The Sync App will use the SAP Concur APIs to filter by either Id or by any combination of Name_p, Address_p, Address2_p, City_p, State_p, Zip_p, Country_p, Phone_p, McCode_p, TaxId_p, MerchantType_p, MerchantID_p, IataCode_p, and Relevance_p. The Sync App processes other filters client-side within the Sync App.

For example, the following queries are processed server side:

SELECT * FROM Suppliers WHERE Id = 'sampleSuppliersId'
SELECT * FROM Suppliers WHERE Name_p = 'sampleName' AND Address_p = 'exampleAddress' AND Address2_p = 'exampleAddress2' AND City_p = 'exampleCity' AND State_p = 'exampleState' AND Zip_p = 'exampleZip' AND Country_p = 'exampleCountry' AND Phone_p = '123456789' AND McCode_p = 'exampleMcCode' AND TaxId_p = 'exampleTaxId' AND MerchantType_p = 'Visa' AND MerchantID_p = 'exampleMerchantID' AND IataCode_p = 'code' AND Relevance_p = 5

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false.

Columns


Name	Type	References	Description
ID [KEY]	String		The unique identifier of the resource.
AmadeusId	String		Amadeus Id
CreditCardVendorId	String		Creditcard Vendor Id
GalileoId	String		Galileo Id
NorthstarId	String		Northstar Id
PegasusId	String		Pegasus Id
SabreId	String		Sabre Id
TaxId	String		Tax Id
WorldspanId	String		Worldspan Id
AustinTetra	String		Austin Tetra
BusinessName	String		Name
ChainCode	String		Chain Code
ChainName	String		Chain Name
City	String		City
CountryCode	String		Country Code
DunsNumber	String		Duns Number
Email	String		Email
Fax	String		Fax
MccCode	String		MCC Code (Ex: Delta Airline - 3058)
Phone	String		Phone
PostalCode	String		Zip
PrimaryNaics	String		Primary Naics Code
PrimarySic	String		Primary Sic Code
PropertyCode	String		undefined:ConnectSwaggerDocs-SUP_PARAM_PROPERTY_CODE
SecondaryNaics	String		Secondary Naics Code
SecondarySic	String		Secondary Sic Code
State	String		State
StreetAddress	String		Address
StreetAddress2	String		Address2
TollFree	String		Toll Free
URI	String		The URI to the resource.
WebUrl	String		Web Address

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
IataCode_p	String		IATA Code
MerchantType_p	String		Merchant Type Code(Ex: Visa - VI, Amex - AX)
MerchantID_p	String		Merchant Id
Zip_p	String		Zip
Relevance_p	String		Relevance of the Search results
Name_p	String		Name
Address_p	String		Address
McCode_p	String		MCC Code (Ex: Delta Airline - 3058)
TaxId_p	String		Tax Id
Address2_p	String		Address
Country_p	String		Country Code

TripBookingPassengers

Lists the passengers for a trip booking.

Table Specific Information

Select

The Sync App uses the SAP Concur APIs to process filters that refer to TripId. The Sync App processes other filters client-side within the Sync App.

For example, the following query is processed server side:

SELECT * FROM TripBookingPassengers WHERE TripId = '123456'

Columns


Name	Type	References	Description
TripId [KEY]	String		The id of the trip.
FirstName	String		The first name of the passenger.
LastName	String		The last name of the passenger.

TripBookings

Query all the bookings for a trip.

Table Specific Information

Select

The Sync App uses the SAP Concur APIs to process filters that refer to TripId. The Sync App processes other filters client-side within the Sync App. For example, the following queries are processed server side:

SELECT * FROM TripBookings WHERE TripId ='sampleTripId'

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false.

Columns


Name	Type	References	Description
RecordLocator [KEY]	String		The record locator of the booking.
TripId [KEY]	String		The id of the trip.
BookingOwner	String		The id of the trip.
Source	String		The name of the trip.
BookingSource	String		The record locator of the trip.
BookedDate	Datetime		The first name of the traveler.
CreatedDate	Datetime		The last name of the traveler.
ModifiedDate	Datetime		A comma separated list of passengers.
IsCanceled	Boolean		The status of the trip The default value is false.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
CreatedAfterDate	Datetime		Date for when the trip was created. The query string will return trips created on or after this date.
CreatedBeforeDate	Datetime		Date for when the trip was created. The query string will return trips created on or before this date.
BookingType	String		The trip includes at least one booking of this type. The allowed values are Air, Car, Dining, Hotel, Parking, Rail, Ride.
IncludeVirtualTrip	Boolean		Show virtual trips. Virtual trips are segments booked offline through the Travel Request product.
IncludeGuestBookings	Boolean		Indicates whether to include guest bookings.
LoginId	String		The login ID of the user who owns the trip. The user must have the Web Services Admin role to use this parameter.

TripBookingSegmentCharges

Query all the charges for a trip.

Table Specific Information

Select

The Sync App uses the SAP Concur APIs to process filters that refer to TripId. The Sync App processes other filters client-side within the Sync App. For example, the following query is processed server side:

SELECT * FROM TripBookingSegmentCharges WHERE TripId ='sampleTripId'

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false.

Columns


Name	Type	References	Description
TripId [KEY]	String		The id of the trip.
BookingRecordLocator [KEY]	String		The record locator of the booking.
SegmentType [KEY]	String		The type of the segment.
ChargeType	String		The type of the charge.
Amount	String		The total amount for the rate for the booking.
AllowanceAmount	String		The cost of overage fees when the allowance is exceeded.
Currency	String		The 3-letter ISO 4217 currency code for the total amount.
Description	String		The description for the rate.
IsPaid	Boolean		Whether the rate has been paid.
AllowanceIsUnlimited	Boolean		Whether the allowance is unlimited.
IsPrimary	Boolean		Indicates whether the charge is the Primary or Main rate.
NumUnits	Integer		The number of units expected for the charge. For instance, 3 days.
AllowanceNumUnits	Integer		The number of units for the allowance associated with the charge.
PerUnit	String		The unit of measure for the charge. Values represent rates like per DAY, WEEK, or MONTH.
AllowanceUnit	String		The unit of measure for the allowance associated with the charge.
SemanticsCode	String		Indicates the charge category for the line item.
SemanticsVendorType	String		The vendor type: H=Hotel, C=Car, A=Air, G=Ground, R=Rail
StartDateLocal	Datetime		The start date of the booking, in the user's local time.
Vendor	String		The vendor for the booking charge.
VendorChargeCode	String		The vendor's code for the charge

TripBookingSegments

Query all the bookings for a trip.

Table Specific Information

Select

The Sync App uses the SAP Concur APIs to process filters that refer to TripId. The Sync App processes other filters client-side within the Sync App. For example, the following queries are processed server side:

SELECT * FROM TripBookingSegments WHERE TripId ='sampleTripId'

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false.

Columns


Name	Type	References	Description
TripId [KEY]	String	Trips.Id	The id of the trip.
SegmentType [KEY]	String		The type of the segment.
BookingRecordLocator [KEY]	String		The record locator of the booking.
ConfirmationNumber	String		The record locator or confirmation number for the segment.
ClassOfService	String		The class of the booking.
FlightNumber	String		The flight number for the booking.
StartDateLocal	Datetime		The booking starting time and date
EndDateLocal	Datetime		The booking ending time and date.
Vendor	String		The vendor for the booking charge.
Name	String		The name on the booking.
CancellationNumber	String		The cancellation number from the vendor.
CancellationPolicy	String		The cancellation policy from the vendor.
Currency	String		The 3-letter ISO 4217 currency code for the booking.
DailyRate	Decimal		The daily rate for the booking.
EndCityCode	String		The IATA airport code for the end city of the booking.
StartLongitude	String		The longitude of the starting point of the booking.
StartLatitude	String		The latitude of the starting point of the booking.
EndLongitude	String		The longitude of the ending point of the booking.
EndLatitude	String		The latitude of the ending point of the booking.
Notes	String		Additional information about the booking.
PhoneNumber	String		The ride vendor phone number.
Rate	String		The rate for the booking.
RateType	String		The rate type for the booking.
RateCode	String		The rate code for the booking.
RateNotes	String		The rate notes for the booking.
RateDescription	String		The rate description for the booking.
StartCityCode	String		The starting IATA airport code of the booking.
Status	String		The status of the segment.
TimeZone	String		The time zone of the booking.
TotalRate	String		The total rate amount of the booking.
VendorName	String		The name of the vendor.
DateCancelledUtc	Datetime		The date the booking was cancelled, in UTC.
DateCreatedUtc	Datetime		The date the booking was created, in UTC.
DateModifiedUtc	Datetime		The date the booking was last modified, in UTC.
EndDateUtc	Datetime		The booking ending time and date, in UTC.
StartDateUtc	Datetime		The booking starting time and date, in UTC.
StartGate	String		The departure gate for the booking.
EndGate	String		The arrival gate for the booking.
StartTerminal	String		The departure terminal for the booking.
EndTerminal	String		The arrival terminal for the booking.
LegId	String		The trip leg ID.
CheckinTime	String		The check in time for the hotel booking.
CheckoutTime	String		The check out time for the hotel booking.
HotelPropertyId	String		The hotel's property ID.
ParkingLocationId	String		The location of the parking booking.
NumRooms	Integer		The number of rooms the booking is for.
RoomDescription	String		The room description for the booking
RoomType	String		The room type for the booking.
RestaurantId	String		The booking vendor's restaurant ID.
AirCondition	String		The character code that indicates if car has air conditioner. R for AC, N for No AC
Body	String		The character code to indicate how many passengers the car can seat.
Class	String		Character code to indicate the class of the car e.g. if it is economy, full size, compact, etc. Varies by Vendor.
DiscountCode	String		The discount code for the booking.
DropoffCollectionAddress1	String		The AddressLine1 for the dropoff address when the rental service offers dropoff.
DropoffCollectionAddressType	String		The type of the dropoff address.
DropoffCollectionCategory	String		Thecategory of the dropoff collection.
DropoffCollectionCity	String		City for the dropoff address when the rental service offers dropoff.
DropoffCollectionCityCode	String		The IATA airport code for the dropoff address when the rental service offers dropoff.
DropoffCollectionCountry	String		The country for the dropoff address when the rental service offers dropoff.
DropoffCollectionLatitude	String		The latitude for the dropoff address when the rental service offers dropoff.
DropoffCollectionLongitude	String		The longitude for the dropoff address when the rental service offers dropoff.
DropoffCollectionNumber	String		the dropoff location number.
DropoffCollectionPhoneNumber	String		The phone number for the dropoff address when the rental service offers dropoff.
DropoffCollectionPostalCode	String		The postal code for the dropoff address when the rental service offers dropoff.
DropoffCollectionState	String		The state for the dropoff address when the rental service offers dropoff.
EndAddress	String		The ending address for the booking.
EndAddress2	String		The ending address for the booking.
EndCity	String		The ending address for the booking.
EndCloseTime	String		The closing time for the dropoff location.
EndCountry	String		The ending address for the booking.
EndLocation	String		The dropoff location.
EndOpenTime	String		The opening time of the dropoff location.
EndPhoneNumber	String		The phone number of the dropoff location.
EndPostalCode	String		The ending address for the booking.
EndState	String		The ending address for the booking.
FrequentTravelerId	String		The loyalty program ID for the user.
IsUpgradeAllowed	String		Whether the booking can be upgraded.
NumCars	Integer		The number of cars rented.
NumPersons	Integer		The number of people including the driver that the rental is for.
NumberOfHours	Integer		The number of hours of the booking.
PickupDeliveryAddress1	String		The AddressLine1 for the pickup address when the rental service offers pickup.
PickupDeliveryAddressType	String		The type of the pickup address when the rental service offers pickup.
PickupDeliveryCategory	String		The category of the pickup address when the rental service offers pickup.
PickupDeliveryCity	String		The city for the pickup address when the rental service offers pickup.
PickupDeliveryCityCode	String		The IATA airport code for the pickup address when the rental service offers pickup.
PickupDeliveryCountry	String		The country for the pickup address when the rental service offers pickup.
PickupDeliveryLatitude	String		The latitude for the pickup address when the rental service offers pickup.
PickupDeliveryLongitude	String		The longitude for the pickup address when the rental service offers pickup.
PickupDeliveryNumber	String		The number of the pickup delivery.
PickupDeliveryPhoneNumber	String		The phone number for the pickup address when the rental service offers pickup.
PickupDeliveryPostalCode	String		The postal code for the pickup address when the rental service offers pickup.
PickupDeliveryState	String		The state for the pickup address when the rental service offers pickup.
SpecialEquipment	String		Any special equipment required by the renter.
SpecialInstructions	String		Additional instructions regarding the booking.
MeetingInstructions	String		The instructions for the meeting location of the booking.
PickupInstructions	String		Instructions regarding the booking.
StartAddress	String		The starting address of the booking.
StartAddress2	String		The starting address of the booking.
StartCity	String		The starting city of the booking.
StartCloseTime	String		The closing time for the pickup location.
StartCountry	String		The starting country of the booking.
StartLocation	String		The starting location of the booking.
StartOpenTime	String		The opening time for the pickup location.
StartPostalCode	String		The starting postal code for the booking.
StartState	String		The starting state for the booking.
Transmission	String		The character code that indicates if the car has auto-transmission. A for Auto, M for Manual.
UpgradedDateTime	Datetime		The date and time the booking was upgraded.
AircraftCode	String		The code for the aircraft type.
Bags	String		The number of bags included in the booking.
Cabin	String		The cabin for the booking.
Amenities	String		The amenities for the seat.
TrainNumber	String		The number for the booked train.
TrainTypeCode	String		The code for the type of train used in the booking.
TrainTypeName	String		The name of the type of train used in the booking.
WagonNumber	String		The number of the wagon the seat is on.
TransportMode	String		The transport mode of the booking.
CarbonEmissionLbs	String		The pounds of carbon emission for this booking.
CarbonModel	String		The model used to calculate the carbon emissions.
CheckedBaggage	Boolean		Whether the booking includes checked baggage.
Duration	String		The duration of the booked flight.
ETicket	String		Whether the booking has an e-ticket.
IsPersonal	Boolean		Whether the segment is for personal travel.
IsOpenSegment	Boolean		Whether the segment is open.
IsPreferredVendor	Boolean		If the airline is marked as a preferred property by the company.
IsUpgradeAllowed	Boolean		Whether the booking can be upgraded.
Meals	String		The meals included in the booking.
Miles	String		The number of miles included in the booking.
OpenSegment	String		Additional information about the open segment.
OperatedByFlightNumber	String		Flight Number provided by the airline operating the flight on behalf of the booked airline.
OperatedByTrainNumber	String		The train identifier of the operating vendor of the booked trip.
OperatedByVendor	String		The operated by vendor for the booking.
OperatedByVendorName	String		The name of the airline operating the flight on behalf of the booked airline.
RouteRestrictCode	String		The code to restrict the route of the booking.
StartPlatform	String		The starting platform location of the booking.
StartRailStation	String		The code of the starting station of the booking.
StartRailStationName	String		The name of the starting station of the booking.
Services	String		The services included in the booking.
HadDeposit	Boolean		Whether the booking had a deposit.
ModificationCode	String		The code for the modification to the booking.
PartnerMembershipId	String		The membership ID of the partner associated with the booking.
PassiveType	String		The type of the booking.
PassiveCityCode	String		The passive city code of the booking.
VendorFlags	String		Semi-colon-delimited list of flags for free hotel service flags. E.g. free breakfast (FB), internet (FI), Parking (FP), etc. If they were all present they can be concatenated as - FB;FI;FP;

TripBookingSegmentSeats

Query all the seats for a trip.

Table Specific Information

Select

The Sync App uses the SAP Concur APIs to process filters that refer to TripId and BookingRecordLocator. The Sync App processes other filters client-side within the Sync App. For example, the following queries are processed server side:

SELECT * FROM TripBookingSegmentSeats WHERE TripId ='sampleTripId' AND BookingRecordLocator = 'sampleBookingRecordLocator'

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false.

Columns


Name	Type	References	Description
TripId [KEY]	String		The id of the trip.
BookingRecordLocator [KEY]	String		The record locator of the booking.
SegmentType [KEY]	String		The type of the segment.
PassengerRph	String		Which passenger the seat is assigned to.
Amenities	String		The amenities for the seat.
BerthPosition	String		The berth location of the seat.
Deck	String		Which deck the seat is on.
FacingForward	String		Whether the seat is facing forward.
FareSpaceComfort	String		The space around the seat.
SeatNumber	String		The number of the seat.
SeatPosition	String		The location of the seat.
SpaceType	String		The type of space around the seat.
Status	String		The status of the seat booking.
WagonNumber	String		The number of the wagon the seat is on.
WagonType	String		The type of wagon the seat is on.

Trips

Query all the trips.

Table Specific Information

Select

The Sync App uses the SAP Concur APIs to process filters that refer to any combination of TripStartDate, TripEndDate, and ModifiedDate. The Sync App processes other filters client-side within the Sync App.

SELECT * FROM Trips WHERE TripStartDate='2018-01-01 10:00:00'  AND TripEndDate ='2018-03-01 10:00:00'  AND ModifiedDate = '2018-02-01 10:00:00'

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false.

Columns


Name	Type	References	Description
Id [KEY]	String		The id of the trip.
TripName	String		The name of the trip.
TravelerFirstName	String		The first name of the traveler.
TravelerLastName	String		The last name of the traveler.
Passengers	String		A comma separated list of passengers.
TripStartDate	Datetime		The start date of the trip.
TripEndDate	Datetime		The end date of the trip.
ModifiedDate	Datetime		The date when the trip was last modified.
RecordLocator	String		The record locator of the trip.
LoginId	String		The login ID of the user who owns the trip. The user must have the Web Services Admin role to use this parameter.
IsCanceled	Boolean		The status of the trip The default value is false.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
CreatedAfterDate	Datetime		Date for when the trip was created. The query string will return trips created on or after this date.
CreatedBeforeDate	Datetime		Date for when the trip was created. The query string will return trips created on or before this date.
BookingType	String		The trip includes at least one booking of this type. The allowed values are Air, Car, Dining, Hotel, Parking, Rail, Ride.
IncludeVirtualTrip	Boolean		Show virtual trips. Virtual trips are segments booked offline through the Travel Request product.
IncludeGuestBookings	Boolean		Indicates whether to include guest bookings.

Users

Lists user data based on the search criteria.

Table Specific Information

Select

The Sync App uses the SAP Concur APIs to process filters that refer either to LoginId or to any combination of PrimaryEmail, EmployeeID, LastName, and Active. The Sync App processes other filters client-side within the Sync App. For example, the following queries are processed server side:

SELECT * FROM Users  WHERE LoginId='[email protected]'  
SELECT * FROM Users  WHERE PrimaryEmail='[email protected]' AND  EmployeeID = 'sampleEmployeeID' AND LastName='sampleLastName' AND Active = 'true'

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false.

Columns


Name	Type	References	Description
ID [KEY]	String		The unique identifier of the resource.
EmployeeID	String		The employee ID of the user.
LoginId	String		The login ID of the user.
MiddleName	String		The middle name of the user.
Active	Bool		Indicates whether the user is currently active or not.
CellPhoneNumber	String		The cell phone number of the user.
FirstName	String		The first name of the user.
LastName	String		The last name of the user.
OrganizationUnit	String		The organization unit of the user.
PrimaryEmail	String		The primary email of the user.
URI	String		The URI to the resource.

Connection String Options

The connection string properties are the various options that can be used to establish a connection. This section provides a complete list of the options you can configure in the connection string for this provider. Click the links for further details.

For more information on establishing a connection, see Establishing a Connection.

Authentication

Property	Description
AuthScheme	The scheme used for authentication. Accepted entries are OAuth, OAuthPassword, and CompanyLevelAuth.
UseSandbox	A boolean indicating if you are using a Sandbox account. The provider makes requests to the production environment by default.
Username	The user account used to authenticate to SAP Concur.
Password	The password used to authenticate the user.
CompanyId	Unique identifier of your company. This is required for Company Level Authentication.
CompanyRequestToken	The Company Request Token generated from the Company Request Token tool or retrieved from SAP Concur support.
UseNewOAuthVersion	A boolean indicating wether the new authentication version should be used.
ConcurInstanceURL	The server URL to use. The new server URLs are backwards compatible with the legacy authentication methods, so set this only if necessary. For example https://concursolutions.com for some production accounts and https://implementation.concursolutions.com for sandbox accounts.

Connection

Property	Description
Region	The region where the server is located. Valid values are US, EU and CN.
LoginId	Login ID of the user. Can be used if the user account associated with the OAuth 2.0 access token has a Concur account with one of these roles: Web Services Administrator for Professional or Can Administer for Standard.
UserId	The unique identifier of the SAP Concur user. Used only for tables that expose V4 endpoints of the SAP Concur API.

OAuth

Property	Description
OAuthClientId	The client Id assigned when you register your application with an OAuth authorization server.
OAuthClientSecret	The client secret assigned when you register your application with an OAuth authorization server.
GeoLocation	The GeoLocation of the account instance.
OAuthGrantType	The grant type for the OAuth flow.

Firewall

Property	Description
FirewallType	The protocol used by a proxy-based firewall.
FirewallServer	The name or IP address of a proxy-based firewall.
FirewallPort	The TCP port for a proxy-based firewall.
FirewallUser	The user name to use to authenticate with a proxy-based firewall.
FirewallPassword	A password used to authenticate to a proxy-based firewall.

Proxy

Property	Description
ProxyAutoDetect	This indicates whether to use the system proxy settings or not. This takes precedence over other proxy settings, so you'll need to set ProxyAutoDetect to FALSE in order use custom proxy settings.
ProxyServer	The hostname or IP address of a proxy to route HTTP traffic through.
ProxyPort	The TCP port the ProxyServer proxy is running on.
ProxyAuthScheme	The authentication type to use to authenticate to the ProxyServer proxy.
ProxyUser	A user name to be used to authenticate to the ProxyServer proxy.
ProxyPassword	A password to be used to authenticate to the ProxyServer proxy.
ProxySSLType	The SSL type to use when connecting to the ProxyServer proxy.
ProxyExceptions	A semicolon separated list of destination hostnames or IPs that are exempt from connecting through the ProxyServer .

Logging

Property	Description
LogModules	Core modules to be included in the log file.

Schema

Property	Description
Location	A path to the directory that contains the schema files defining tables, views, and stored procedures.
BrowsableSchemas	This property restricts the schemas reported to a subset of the available schemas. For example, BrowsableSchemas=SchemaA,SchemaB,SchemaC.
Tables	This property restricts the tables reported to a subset of the available tables. For example, Tables=TableA,TableB,TableC.
Views	Restricts the views reported to a subset of the available tables. For example, Views=ViewA,ViewB,ViewC.

Miscellaneous

Property	Description
ReportLimit	Limit the API requests sent to the server.
MaxRows	Limits the number of rows returned rows when no aggregation or group by is used in the query. This helps avoid performance issues at design time.
Other	These hidden properties are used only in specific use cases.
Pagesize	The maximum number of results to return per page from SAP Concur.
PseudoColumns	This property indicates whether or not to include pseudo columns as columns to the table.
Timeout	The value in seconds until the timeout error is thrown, canceling the operation.
UserDefinedViews	A filepath pointing to the JSON configuration file containing your custom views.

Authentication

This section provides a complete list of the Authentication properties you can configure in the connection string for this provider.

Property	Description
AuthScheme	The scheme used for authentication. Accepted entries are OAuth, OAuthPassword, and CompanyLevelAuth.
UseSandbox	A boolean indicating if you are using a Sandbox account. The provider makes requests to the production environment by default.
Username	The user account used to authenticate to SAP Concur.
Password	The password used to authenticate the user.
CompanyId	Unique identifier of your company. This is required for Company Level Authentication.
CompanyRequestToken	The Company Request Token generated from the Company Request Token tool or retrieved from SAP Concur support.
UseNewOAuthVersion	A boolean indicating wether the new authentication version should be used.
ConcurInstanceURL	The server URL to use. The new server URLs are backwards compatible with the legacy authentication methods, so set this only if necessary. For example https://concursolutions.com for some production accounts and https://implementation.concursolutions.com for sandbox accounts.

AuthScheme

The scheme used for authentication. Accepted entries are OAuth, OAuthPassword, and CompanyLevelAuth.

Remarks

OAuth: Set to this to perform OAuth authentication with the code grant type.
OAuthPassword: Set to this to perform OAuth with the password grant type.
CompanyLevelAuth: Set to this to perform Company Level Authentication with password grant type OAuth.

UseSandbox

A boolean indicating if you are using a Sandbox account. The provider makes requests to the production environment by default.

Remarks

The SAP Concur API to be used to process transactions. If you are using a production account, this property can be left blank. If you are using an implementation server, set this to 'TRUE'.

Username

The user account used to authenticate to SAP Concur.

Remarks

Together with Password, this field is used to authenticate to SAP Concur.

Password

The password used to authenticate the user.

Remarks

The password used to authenticate the user.

CompanyId

Unique identifier of your company. This is required for Company Level Authentication.

Remarks

Unique identifier of your company. This is required for Company Level Authentication.

CompanyRequestToken

The Company Request Token generated from the Company Request Token tool or retrieved from SAP Concur support.

Remarks

The Company Request Token generated from the Company Request Token tool or retrieved from SAP Concur support. Admins with the required permissions will have a link to the Company Request Token tool on the Administration > Company > Authentication Administration page.

UseNewOAuthVersion

A boolean indicating wether the new authentication version should be used.

Remarks

A boolean indicating wether the new authentication version should be used.

ConcurInstanceURL

The server URL to use. The new server URLs are backwards compatible with the legacy authentication methods, so set this only if necessary. For example https://concursolutions.com for some production accounts and https://implementation.concursolutions.com for sandbox accounts.

Remarks

The server URL to use. The new server URLs are backwards compatible with the legacy authentication methods, so set this only if necessary. For example https://concursolutions.com for some production accounts and https://implementation.concursolutions.com for sandbox accounts. Set this connection property if you are using V1-V3 API version and the server does not accept the Base Url with region information.

Connection

This section provides a complete list of the Connection properties you can configure in the connection string for this provider.

Property	Description
Region	The region where the server is located. Valid values are US, EU and CN.
LoginId	Login ID of the user. Can be used if the user account associated with the OAuth 2.0 access token has a Concur account with one of these roles: Web Services Administrator for Professional or Can Administer for Standard.
UserId	The unique identifier of the SAP Concur user. Used only for tables that expose V4 endpoints of the SAP Concur API.

Region

The region where the server is located. Valid values are US, EU and CN.

Remarks

The region where the server is located. Valid values are US, EU and CN.

LoginId

Login ID of the user. Can be used if the user account associated with the OAuth 2.0 access token has a Concur account with one of these roles: Web Services Administrator for Professional or Can Administer for Standard.

Remarks

Login ID of the user. Can be used if the user account associated with the OAuth 2.0 access token has a Concur account with one of these roles: Web Services Administrator for Professional or Can Administer for Standard. Setting the Login ID to "ALL" will retrieve information for all accounts at the expense of certain tables that do not support this argument.

UserId

The unique identifier of the SAP Concur user. Used only for tables that expose V4 endpoints of the SAP Concur API.

Remarks

The unique identifier of the SAP Concur user. Used only for tables that expose V4 endpoints of the SAP Concur API. Query the Identity table to retrieve this value.

OAuth

This section provides a complete list of the OAuth properties you can configure in the connection string for this provider.

Property	Description
OAuthClientId	The client Id assigned when you register your application with an OAuth authorization server.
OAuthClientSecret	The client secret assigned when you register your application with an OAuth authorization server.
GeoLocation	The GeoLocation of the account instance.
OAuthGrantType	The grant type for the OAuth flow.

OAuthClientId

The client Id assigned when you register your application with an OAuth authorization server.

Remarks

As part of registering an OAuth application, you will receive the OAuthClientId value, sometimes also called a consumer key, and a client secret, the OAuthClientSecret.

OAuthClientSecret

The client secret assigned when you register your application with an OAuth authorization server.

Remarks

As part of registering an OAuth application, you will receive the OAuthClientId, also called a consumer key. You will also receive a client secret, also called a consumer secret. Set the client secret in the OAuthClientSecret property.

GeoLocation

The GeoLocation of the account instance.

Remarks

The GeoLocation of the account instance. Set this property when InitiateOAuth is set to OFF. Get the value as an ouput of the GetOAuthAccessToken stored procedure.

OAuthGrantType

The grant type for the OAuth flow.

Remarks

The following options are available: CODE,PASSWORD

Firewall

This section provides a complete list of the Firewall properties you can configure in the connection string for this provider.

Property	Description
FirewallType	The protocol used by a proxy-based firewall.
FirewallServer	The name or IP address of a proxy-based firewall.
FirewallPort	The TCP port for a proxy-based firewall.
FirewallUser	The user name to use to authenticate with a proxy-based firewall.
FirewallPassword	A password used to authenticate to a proxy-based firewall.

FirewallType

The protocol used by a proxy-based firewall.

Remarks

This property specifies the protocol that the Sync App will use to tunnel traffic through the FirewallServer proxy. Note that by default, the Sync App connects to the system proxy; to disable this behavior and connect to one of the following proxy types, set ProxyAutoDetect to false.


Type	Default Port	Description
TUNNEL	80	When this is set, the Sync App opens a connection to SAP Concur and traffic flows back and forth through the proxy.
SOCKS4	1080	When this is set, the Sync App sends data through the SOCKS 4 proxy specified by FirewallServer and FirewallPort and passes the FirewallUser value to the proxy, which determines if the connection request should be granted.
SOCKS5	1080	When this is set, the Sync App sends data through the SOCKS 5 proxy specified by FirewallServer and FirewallPort. If your proxy requires authentication, set FirewallUser and FirewallPassword to credentials the proxy recognizes.

To connect to HTTP proxies, use ProxyServer and ProxyPort. To authenticate to HTTP proxies, use ProxyAuthScheme, ProxyUser, and ProxyPassword.

FirewallServer

The name or IP address of a proxy-based firewall.

Remarks

This property specifies the IP address, DNS name, or host name of a proxy allowing traversal of a firewall. The protocol is specified by FirewallType: Use FirewallServer with this property to connect through SOCKS or do tunneling. Use ProxyServer to connect to an HTTP proxy.

Note that the Sync App uses the system proxy by default. To use a different proxy, set ProxyAutoDetect to false.

FirewallPort

The TCP port for a proxy-based firewall.

Remarks

This specifies the TCP port for a proxy allowing traversal of a firewall. Use FirewallServer to specify the name or IP address. Specify the protocol with FirewallType.

FirewallUser

The user name to use to authenticate with a proxy-based firewall.

Remarks

The FirewallUser and FirewallPassword properties are used to authenticate against the proxy specified in FirewallServer and FirewallPort, following the authentication method specified in FirewallType.

FirewallPassword

A password used to authenticate to a proxy-based firewall.

Remarks

This property is passed to the proxy specified by FirewallServer and FirewallPort, following the authentication method specified by FirewallType.

Proxy

This section provides a complete list of the Proxy properties you can configure in the connection string for this provider.

Property	Description
ProxyAutoDetect	This indicates whether to use the system proxy settings or not. This takes precedence over other proxy settings, so you'll need to set ProxyAutoDetect to FALSE in order use custom proxy settings.
ProxyServer	The hostname or IP address of a proxy to route HTTP traffic through.
ProxyPort	The TCP port the ProxyServer proxy is running on.
ProxyAuthScheme	The authentication type to use to authenticate to the ProxyServer proxy.
ProxyUser	A user name to be used to authenticate to the ProxyServer proxy.
ProxyPassword	A password to be used to authenticate to the ProxyServer proxy.
ProxySSLType	The SSL type to use when connecting to the ProxyServer proxy.
ProxyExceptions	A semicolon separated list of destination hostnames or IPs that are exempt from connecting through the ProxyServer .

ProxyAutoDetect

This indicates whether to use the system proxy settings or not. This takes precedence over other proxy settings, so you'll need to set ProxyAutoDetect to FALSE in order use custom proxy settings.

Remarks

This takes precedence over other proxy settings, so you'll need to set ProxyAutoDetect to FALSE in order use custom proxy settings.

To connect to an HTTP proxy, see ProxyServer. For other proxies, such as SOCKS or tunneling, see FirewallType.

ProxyServer

The hostname or IP address of a proxy to route HTTP traffic through.

Remarks

The hostname or IP address of a proxy to route HTTP traffic through. The Sync App can use the HTTP, Windows (NTLM), or Kerberos authentication types to authenticate to an HTTP proxy.

If you need to connect through a SOCKS proxy or tunnel the connection, see FirewallType.

By default, the Sync App uses the system proxy. If you need to use another proxy, set ProxyAutoDetect to false.

ProxyPort

The TCP port the ProxyServer proxy is running on.

Remarks

The port the HTTP proxy is running on that you want to redirect HTTP traffic through. Specify the HTTP proxy in ProxyServer. For other proxy types, see FirewallType.

ProxyAuthScheme

The authentication type to use to authenticate to the ProxyServer proxy.

Remarks

This value specifies the authentication type to use to authenticate to the HTTP proxy specified by ProxyServer and ProxyPort.

Note that the Sync App will use the system proxy settings by default, without further configuration needed; if you want to connect to another proxy, you will need to set ProxyAutoDetect to false, in addition to ProxyServer and ProxyPort. To authenticate, set ProxyAuthScheme and set ProxyUser and ProxyPassword, if needed.

The authentication type can be one of the following:

BASIC: The Sync App performs HTTP BASIC authentication.
DIGEST: The Sync App performs HTTP DIGEST authentication.
NEGOTIATE: The Sync App retrieves an NTLM or Kerberos token based on the applicable protocol for authentication.
PROPRIETARY: The Sync App does not generate an NTLM or Kerberos token. You must supply this token in the Authorization header of the HTTP request.

If you need to use another authentication type, such as SOCKS 5 authentication, see FirewallType.

ProxyUser

A user name to be used to authenticate to the ProxyServer proxy.

Remarks

The ProxyUser and ProxyPassword options are used to connect and authenticate against the HTTP proxy specified in ProxyServer.

You can select one of the available authentication types in ProxyAuthScheme. If you are using HTTP authentication, set this to the user name of a user recognized by the HTTP proxy. If you are using Windows or Kerberos authentication, set this property to a user name in one of the following formats:

user@domain
domain\user

ProxyPassword

A password to be used to authenticate to the ProxyServer proxy.

Remarks

This property is used to authenticate to an HTTP proxy server that supports NTLM (Windows), Kerberos, or HTTP authentication. To specify the HTTP proxy, you can set ProxyServer and ProxyPort. To specify the authentication type, set ProxyAuthScheme.

If you are using HTTP authentication, additionally set ProxyUser and ProxyPassword to HTTP proxy.

If you are using NTLM authentication, set ProxyUser and ProxyPassword to your Windows password. You may also need these to complete Kerberos authentication.

For SOCKS 5 authentication or tunneling, see FirewallType.

By default, the Sync App uses the system proxy. If you want to connect to another proxy, set ProxyAutoDetect to false.

ProxySSLType

The SSL type to use when connecting to the ProxyServer proxy.

Remarks

This property determines when to use SSL for the connection to an HTTP proxy specified by ProxyServer. This value can be AUTO, ALWAYS, NEVER, or TUNNEL. The applicable values are the following:


AUTO	Default setting. If the URL is an HTTPS URL, the Sync App will use the TUNNEL option. If the URL is an HTTP URL, the component will use the NEVER option.
ALWAYS	The connection is always SSL enabled.
NEVER	The connection is not SSL enabled.
TUNNEL	The connection is through a tunneling proxy. The proxy server opens a connection to the remote host and traffic flows back and forth through the proxy.

ProxyExceptions

A semicolon separated list of destination hostnames or IPs that are exempt from connecting through the ProxyServer .

Remarks

The ProxyServer is used for all addresses, except for addresses defined in this property. Use semicolons to separate entries.

Note that the Sync App uses the system proxy settings by default, without further configuration needed; if you want to explicitly configure proxy exceptions for this connection, you need to set ProxyAutoDetect = false, and configure ProxyServer and ProxyPort. To authenticate, set ProxyAuthScheme and set ProxyUser and ProxyPassword, if needed.

Logging

This section provides a complete list of the Logging properties you can configure in the connection string for this provider.

Property	Description
LogModules	Core modules to be included in the log file.

LogModules

Core modules to be included in the log file.

Remarks

Only the modules specified (separated by ';') will be included in the log file. By default all modules are included.

See the Logging page for an overview.

Schema

This section provides a complete list of the Schema properties you can configure in the connection string for this provider.

Property	Description
Location	A path to the directory that contains the schema files defining tables, views, and stored procedures.
BrowsableSchemas	This property restricts the schemas reported to a subset of the available schemas. For example, BrowsableSchemas=SchemaA,SchemaB,SchemaC.
Tables	This property restricts the tables reported to a subset of the available tables. For example, Tables=TableA,TableB,TableC.
Views	Restricts the views reported to a subset of the available tables. For example, Views=ViewA,ViewB,ViewC.

Location

A path to the directory that contains the schema files defining tables, views, and stored procedures.

Remarks

The path to a directory which contains the schema files for the Sync App (.rsd files for tables and views, .rsb files for stored procedures). The folder location can be a relative path from the location of the executable. The Location property is only needed if you want to customize definitions (for example, change a column name, ignore a column, and so on) or extend the data model with new tables, views, or stored procedures.

If left unspecified, the default location is "%APPDATA%\\CData\\SAPConcur Data Provider\\Schema" with %APPDATA% being set to the user's configuration directory:

BrowsableSchemas

This property restricts the schemas reported to a subset of the available schemas. For example, BrowsableSchemas=SchemaA,SchemaB,SchemaC.

Remarks

Listing the schemas from databases can be expensive. Providing a list of schemas in the connection string improves the performance.

Tables

This property restricts the tables reported to a subset of the available tables. For example, Tables=TableA,TableB,TableC.

Remarks

Listing the tables from some databases can be expensive. Providing a list of tables in the connection string improves the performance of the Sync App.

This property can also be used as an alternative to automatically listing views if you already know which ones you want to work with and there would otherwise be too many to work with.

Specify the tables you want in a comma-separated list. Each table should be a valid SQL identifier with any special characters escaped using square brackets, double-quotes or backticks. For example, Tables=TableA,[TableB/WithSlash],WithCatalog.WithSchema.`TableC With Space`.

Note that when connecting to a data source with multiple schemas or catalogs, you will need to provide the fully qualified name of the table in this property, as in the last example here, to avoid ambiguity between tables that exist in multiple catalogs or schemas.

Views

Restricts the views reported to a subset of the available tables. For example, Views=ViewA,ViewB,ViewC.

Remarks

Listing the views from some databases can be expensive. Providing a list of views in the connection string improves the performance of the Sync App.

This property can also be used as an alternative to automatically listing views if you already know which ones you want to work with and there would otherwise be too many to work with.

Specify the views you want in a comma-separated list. Each view should be a valid SQL identifier with any special characters escaped using square brackets, double-quotes or backticks. For example, Views=ViewA,[ViewB/WithSlash],WithCatalog.WithSchema.`ViewC With Space`.

Note that when connecting to a data source with multiple schemas or catalogs, you will need to provide the fully qualified name of the table in this property, as in the last example here, to avoid ambiguity between tables that exist in multiple catalogs or schemas.

Miscellaneous

This section provides a complete list of the Miscellaneous properties you can configure in the connection string for this provider.

Property	Description
ReportLimit	Limit the API requests sent to the server.
MaxRows	Limits the number of rows returned rows when no aggregation or group by is used in the query. This helps avoid performance issues at design time.
Other	These hidden properties are used only in specific use cases.
Pagesize	The maximum number of results to return per page from SAP Concur.
PseudoColumns	This property indicates whether or not to include pseudo columns as columns to the table.
Timeout	The value in seconds until the timeout error is thrown, canceling the operation.
UserDefinedViews	A filepath pointing to the JSON configuration file containing your custom views.

ReportLimit

Limit the API requests sent to the server.

Remarks

Set this property to -1 or an empty string to remove the limit.

For the ReportDetails table, LIMIT will overwrite this value.

This connection property is best used when using LIMIT on ReportDetailsExpenseEntry and similar tables: SELECT * FROM [ReportDetailsExpenseEntry] LIMIT 10.

If ReportLimit is 25, then the driver will send a single request to the Reports endpoint to get 25 report IDs, which is the pagination of the Reports endpoint. After this request, the driver will send requests to the ReportDetails endpoint until 10 expense entries are found. It may happen that less than 10 expense entries are found, in which case you will need to increase the ReportLimit.

If ReportLimit is set too high, such as 1000, then there will be 40 requests (if there are more than 1000 reports). After these requests, then the driver will send requests to the ReportDetails endpoint until 10 expense entries are found.

MaxRows

Limits the number of rows returned rows when no aggregation or group by is used in the query. This helps avoid performance issues at design time.

Remarks

Limits the number of rows returned rows when no aggregation or group by is used in the query. This helps avoid performance issues at design time.

Other

These hidden properties are used only in specific use cases.

Remarks

The properties listed below are available for specific use cases. Normal driver use cases and functionality should not require these properties.

Specify multiple properties in a semicolon-separated list.

Integration and Formatting


DefaultColumnSize	Sets the default length of string fields when the data source does not provide column length in the metadata. The default value is 2000.
ConvertDateTimeToGMT	Determines whether to convert date-time values to GMT, instead of the local time of the machine.
RecordToFile=filename	Records the underlying socket data transfer to the specified file.

Pagesize

The maximum number of results to return per page from SAP Concur.

Remarks

The Pagesize property affects the maximum number of results to return per page from SAP Concur. Setting a higher value may result in better performance at the cost of additional memory allocated per page consumed.

PseudoColumns

This property indicates whether or not to include pseudo columns as columns to the table.

Remarks

This setting is particularly helpful in Entity Framework, which does not allow you to set a value for a pseudo column unless it is a table column. The value of this connection setting is of the format "Table1=Column1, Table1=Column2, Table2=Column3". You can use the "*" character to include all tables and all columns; for example, "*=*".

Timeout

The value in seconds until the timeout error is thrown, canceling the operation.

Remarks

If Timeout = 0, operations do not time out. The operations run until they complete successfully or until they encounter an error condition.

If Timeout expires and the operation is not yet complete, the Sync App throws an exception.

UserDefinedViews

A filepath pointing to the JSON configuration file containing your custom views.

Remarks

User Defined Views are defined in a JSON-formatted configuration file called UserDefinedViews.json. The Sync App automatically detects the views specified in this file.

You can also have multiple view definitions and control them using the UserDefinedViews connection property. When you use this property, only the specified views are seen by the Sync App.

This User Defined View configuration file is formatted as follows:

Each root element defines the name of a view.
Each root element contains a child element, called query, which contains the custom SQL query for the view.

For example:

{
	"MyView": {
		"query": "SELECT * FROM Departments WHERE MyColumn = 'value'"
	},
	"MyView2": {
		"query": "SELECT * FROM MyTable WHERE Id IN (1,2,3)"
	}
}

Use the UserDefinedViews connection property to specify the location of your JSON configuration file. For example:

"UserDefinedViews", "C:\\Users\\yourusername\\Desktop\\tmp\\UserDefinedViews.json"

SAP Concur Connector for CData Sync

SAP Concur Connector for CData Sync

Overview

Establishing a Connection

Authenticating to SAP Concur

Important connection property: LoginId

Advanced Features

User Defined Views

Firewall and Proxy

Query Processing

Logging

Firewall and Proxy

Connecting Through a Firewall or Proxy

HTTP Proxies

Other Proxies

Data Model

Customizing Schemas

Using Query Processing

Tables

SAP Concur Connector for CData Sync Tables

Attendees

Table Specific Information

Select

Insert

Update

Delete

Columns

Pseudo-Columns

AttendeeTypes

Table Specific Information

Select

Insert

Update

Delete

Columns

Entries

Table Specific Information

Select

Insert

Update

Delete

Columns

Pseudo-Columns

EntryAttendeeAssociations

Table Specific Information

Select

Insert

Update

Delete

Columns

Pseudo-Columns

Itemizations

Table Specific Information

Select

Insert

Update

Delete

Columns

Pseudo-Columns

ListItems

Table Specific Information

Select

Insert

Update

Delete

Columns

Lists

Table Specific Information

Select

Insert

Update

Delete

Columns

ReceiptImages

Table Specific Information

Select

Insert

Update

Delete

Columns