はじめに

このページでは、CData Cloud でのSAP Concur への接続の確立のガイド、利用可能なリソースに関する情報、および使用可能な接続プロパティのリファレンスについて説明します。

SAP Concur への接続

接続の確立は、CData Cloud にデータベースを作成するためのSAP Concur への認証方法と必要な接続プロパティの設定方法について示します。

CData Cloud サービスからデータにアクセス

利用可能な標準サービスを経由してSAP Concur からデータにアクセスする方法と、CData Cloud の管理については、CData Cloud ドキュメントで詳しく説明します。

接続の確立

Database タブで対応するアイコンを選択して、SAP Concur に接続します。必須プロパティはSettings にリストされています。Advanced タブには、通常は必要ない接続プロパティが表示されます。

SAP Concur への認証

SAP Concur はOAuth 認証のみサポートします。この認証を有効にするには、すべてのOAuth フローでAuthScheme をOAuth に設定し、カスタムOAuth アプリケーションを作成する必要があります。

デスクトップ認証グラント種別

トークンを取得するには、クライアントアプリケーションは、必要な認証シナリオに応じ、さまざまなグラントを使用してOauth2 エンドポイントを呼び出す必要があります。CData のドライバーがサポートするシナリオは、CODE とPASSWORD グラント種別です。

CODE

CODE はデフォルトのOAuthGrantType です。前述の設定に加え、CODE グラント種別を使用するには、次の追加設定が必要です。

UseSandbox：実装サーバーを経由して認証している場合は、これをTrue に設定します。
Region：他の資格情報とともに受信した地理位置情報のリージョン。利用可能な値は、EU（ヨーロッパ）、CN（中国）、およびUS（デフォルト）です。

PASSWORD

PASSWORD グラントは、ユーザーとアプリケーションの間に信頼関係がある場合に、デスクトップアプリケーションで使用することができます。

前述の設定に加え、PASSWORD グラント種別を使用するには、次の追加設定が必要です。

AuthScheme：OAuthPassword。
Username：ユーザーネームまたはユーザーId。
Password：ユーザーのパスワード。
UseSandbox：実装サーバーを使用して認証している場合は、これをTrue に設定します。

Company-Level 認証

Company はSAP Concur プラットフォームの最上位プリンシパルです。アクセストークンとリフレッシュトークンは、ユーザーの場合と同じように、Company に代わって取得することができます。

カスタムOAuth アプリケーションの作成の説明に従ってカスタムOAuth アプリケーションを作成したのち、Company Request Token を生成する必要があります。Company Request Token Tool が利用できる場合は、それを使うことができます。そうでない場合は、SAP Concur サポートチームに連絡して、Company Request Token を生成してもらう必要があります。

Company Request Token が正常に生成されると、リクエストトークンツールにCompany UUID とCompany Request Token が表示されます。これらの値は、後で使用するために保存しておきます。

Company-Level 認証を使用する場合、CODE グラント種別を使用するには、前述の設定に加えて次の追加設定が必要です。

AuthScheme：CompanyLevelAuth。
CompanyId：会社固有の識別子。
CompanyRequestToken：生成されたCompany Request Token。
UseSandbox：実装サーバーを使用して認証している場合は、これをTrue に設定します。

SAP Concur ログインID 変数の使用

ログインID（ユーザーのログインID）は、OAuth 2.0 アクセストークンに関連付けられたユーザーアカウントが、以下のロールのいずれかを持つConcur アカウントを持っている場合に使用できます。

Web Services Administrator for Professional
Can Administer for Standard

ログインID をALL に設定すると、Login ID 引数をサポートするすべてのアカウントの情報が取得されます。

カスタムOAuth アプリケーションの作成

SAP Concur は、認証するユーザーにブラウザでSAP Concur との通信を要求するOAuth 認証標準を使用します。Cloud はさまざまな方法でOAuth 交換をサポートします。

以下の手順では、SAP Concur の管理コンソールでカスタムOAuth アプリケーションを作成して登録し、OAuth クライアントクレデンシャルであるOAuthClientId とOAuthClientSecret を取得します。

プロシージャ

アクセストークンを取得するには、カスタムOAuth アプリケーションをSAP Concur で作成および登録する必要があります。 SAP Concur でOAuth 2.0 Application Management Tool アプリケーションにアクセスできる場合は、自身で作成することもできます。そのツールが利用できない場合は、自身のSAP Concur のPartner Enablement Manager またはPartner Account Manager に連絡してください。

アプリケーションを登録すると、OAuthClientId となるclientId、OAuthClientSecret となるclientSecret、およびgeolocation の情報を受け取ります。

アプリがアクセスするAPI を選択します。ドライバーの全機能を使用するには、以下のすべてを選択する必要があります。

ATTEND
EXPRPT
LIST
IMAGE
RCTIMG
CCARD
TAXINV
CONFIG
INVPMT
SUPSVC
ITINER
USER
expense.report.read
spend.list.read
spend.listitem.read
user.read
identity.user.core.read
identity.user.coresensitive.read
identity.user.enterprise.read
identity.user.ids.read
company.read

SSL の設定

SSL 設定のカスタマイズ

デフォルトでは、Cloud はサーバーとのTLS のネゴシエーションを試みます。サーバー証明書は、デフォルトのシステム信頼済み証明書ストアで検証されます。SSLServerCert 接続プロパティを使用して、証明書の検証方法をオーバーライドできます。

別の証明書を指定するには、SSLServerCert 接続プロパティを参照してください。

ファイアウォールとプロキシ

Firewall またはProxy 経由の接続

HTTP プロキシ

HTTP プロキシへの認証には、以下のように設定します。

ProxyServer：HTTP トラフィックをルートするプロキシサーバーのホストネームもしくはIP アドレス。
ProxyPort：プロキシサーバーが起動しているTCP ポート。
ProxyAuthScheme：プロキシサーバーに対して認証する際にCloud が使用する認証方法。
ProxyUser：プロキシサーバーに登録されているユーザーアカウントのユーザー名。
ProxyPassword：ProxyUser に紐付けられたパスワード。

その他のプロキシ

次のプロパティを設定します。

プロキシベースのファイヤーウォールを使用するには、FirewallType、FirewallServer、およびFirewallPort を設定します。
接続をトンネルするには、FirewallType をTUNNEL に設定します。
認証するには、FirewallUser とFirewallPassword を設定します。
SOCKS プロキシへの認証には、さらにFirewallType をSOCKS5 に設定します。

データモデル

Cloud は、Travel/Itinerary API およびExpense API をリレーショナルデータベースとしてモデル化し、Reports、Entries、Attendees のようなテーブルやビューへのアクセスを可能にします。ストアドプロシージャはデータソースへのファンクションライクなインターフェースです。これらを使用して、データソース内の情報を検索、更新、および変更できます。例えばCancelTrip。

スキーマのカスタマイズ

データベースオブジェクトはスキーマファイルにて定義されます。スキーマファイルは、スキーマを簡単にカスタマイズおよび拡張できるシンプルなテキストベースのコンフィギュレーションファイルです。

デフォルトでは、スキーマはインストールディレクトリのdb サブフォルダにあります。別のフォルダを使用するには、Location を設定します。CreateSchema ストアドプロシージャを呼び出してスキーマファイルを保存します。

クエリ処理の使用

Cloud は、SAP Concur API にできるだけ多くのSELECT 構文処理をオフロードし、残りのクエリをCloud 内で処理します。次のセクションでは、API の制限と要件を説明します。

テーブル

Cloud はSAP Concur のデータを、標準のSQL ステートメントを使用してクエリできるリレーショナルデータベースのテーブルのリストとしてモデル化します。

CData Cloud - SAP Concur テーブル


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.
BudgetCategories	Retrieve a list of all budget categories.
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.
FiscalYears	Retrieve a list of all fiscal years.
Invoice	Gets all relevant information (Payment Request Header, Payment Request Line Item and Payment Request Allocation) of a Payment Request.
Itemizations	Create, update, delete, and query all expense itemizations owned by the user.
Items	Lists list items based on the search criteria.
ListItems	Lists list items based on the search criteria.
Lists	The driver uses the SAP Concur APIs to view your configured lists within SAP Concur products.
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.
TravelRequests	Retrieve a list of all budget categories.
UsersV4	Read the user's core identity profile.

Attendees

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

テーブル固有の情報

Select

Cloud はSAP Concur API を使用して、Id を参照するフィルタ、またはAttendeeTypeId とLoginId を参照するフィルタを処理します。Cloud はクライアント側でCloud 内で他のフィルタを処理します。

例えば、Cloud はSAP Concur API に次のクエリの処理をオフロードします。

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

Insert

出席者を挿入するには、次のカラムが必要です：AttendeeTypeId およびLastName。

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

Update

出席者を更新するには、次のカラムが必要です：Id。

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

Delete

削除は、このテーブルではサポートされていません。

Columns


Name	Type	ReadOnly	References	Description
ID [KEY]	String	False		The unique identifier of the resource.
Custom10ListItemID	String	False		For list fields, this is the list item ID.
AttendeeTypeID	String	False		The ID of the attendee type.
Custom11ListItemID	String	False		For list fields, this is the list item ID.
Custom12ListItemID	String	False		For list fields, this is the list item ID.
Custom13ListItemID	String	False		For list fields, this is the list item ID.
Custom14ListItemID	String	False		For list fields, this is the list item ID.
Custom15ListItemID	String	False		For list fields, this is the list item ID.
Custom16ListItemID	String	False		For list fields, this is the list item ID.
Custom17ListItemID	String	False		For list fields, this is the list item ID.
Custom18ListItemID	String	False		For list fields, this is the list item ID.
Custom19ListItemID	String	False		For list fields, this is the list item ID.
Custom1ListItemID	String	False		For list fields, this is the list item ID.
Custom20ListItemID	String	False		For list fields, this is the list item ID.
Custom21ListItemID	String	False		For list fields, this is the list item ID.
Custom22ListItemID	String	False		For list fields, this is the list item ID.
Custom23ListItemID	String	False		For list fields, this is the list item ID.
Custom24ListItemID	String	False		For list fields, this is the list item ID.
Custom25ListItemID	String	False		For list fields, this is the list item ID.
Custom2ListItemID	String	False		For list fields, this is the list item ID.
Custom3ListItemID	String	False		For list fields, this is the list item ID.
Custom4ListItemID	String	False		For list fields, this is the list item ID.
Custom5ListItemID	String	False		For list fields, this is the list item ID.
Custom6ListItemID	String	False		For list fields, this is the list item ID.
Custom7ListItemID	String	False		For list fields, this is the list item ID.
Custom8ListItemID	String	False		For list fields, this is the list item ID.
Custom9ListItemID	String	False		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
LoginId	String	False	UsersV4.UserName	The login ID of the user that is making the request (this must also be the owner if the attendee type is private) . 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.
AttendeeTypeCode	String	False		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	False		For list fields, this is the list item code.
Custom10Type	String	False		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	False		For list fields, this is the list item code.
Custom11Type	String	False		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	False		For list fields, this is the list item code.
Custom12Type	String	False		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	False		For list fields, this is the list item code.
Custom13Type	String	False		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	False		For list fields, this is the list item code.
Custom14Type	String	False		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	False		For list fields, this is the list item code.
Custom15Type	String	False		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	False		For list fields, this is the list item code.
Custom16Type	String	False		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	False		For list fields, this is the list item code.
Custom17Type	String	False		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	False		For list fields, this is the list item code.
Custom18Type	String	False		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	False		For list fields, this is the list item code.
Custom19Type	String	False		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	False		For list fields, this is the list item code.
Custom1Type	String	False		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	False		For list fields, this is the list item code.
Custom20Type	String	False		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	False		For list fields, this is the list item code.
Custom21Type	String	False		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	False		For list fields, this is the list item code.
Custom22Type	String	False		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	False		For list fields, this is the list item code.
Custom23Type	String	False		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	False		For list fields, this is the list item code.
Custom24Type	String	False		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	False		For list fields, this is the list item code.
Custom25Type	String	False		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	False		For list fields, this is the list item code.
Custom2Type	String	False		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	False		For list fields, this is the list item code.
Custom3Type	String	False		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	False		For list fields, this is the list item code.
Custom4Type	String	False		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	False		For list fields, this is the list item code.
Custom5Type	String	False		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	False		For list fields, this is the list item code.
Custom6Type	String	False		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	False		For list fields, this is the list item code.
Custom7Type	String	False		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	False		For list fields, this is the list item code.
Custom8Type	String	False		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	False		For list fields, this is the list item code.
Custom9Type	String	False		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	False		Determines whether the attendee had exceptions in the previous year, based on yearly total limits for attendees. Format: true or false
HasExceptionsYTD	Bool	False		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	False		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	False		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	False		The URI to the resource.
VersionNumber	Int	False		The attendee's version number.
OwnerLoginID	String	False		The login ID of the user who owns the attendee record.

AttendeeTypes

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

テーブル固有の情報

Select

Cloud はSAP Concur API を使用して、Id を参照するフィルタを処理します。Cloud はクライアント側でCloud 内で他のフィルタを処理します。

例えば、Cloud はSAP Concur API に次のクエリの処理をオフロードします。

SELECT * FROM AttendeeTypes WHERE Id = '123456'

Insert

出席者の種類を挿入するには、次のカラムが必要です：Name、Code、AttendeeFormId、およびDuplicateSearchFields。

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

Update

出席者の種類を更新するには、以下のカラムが必要です： Id。

UPDATE AttendeeTypes SET Code = 'BUSGUEST' WHERE Id = 'gWjEPiokzJTpMsdq34zvJEM$ptCXpT'

Delete

削除は、このテーブルではサポートされていません。

Columns


Name	Type	ReadOnly	References	Description
ID [KEY]	String	True		The unique identifier of the resource.
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 to the resource.

BudgetCategories

Retrieve a list of all budget categories.

Table Specific Information

Select

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

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

SELECT * FROM BudgetCategories
SELECT * FROM BudgetCategories WHERE Id = 'c891b0fb-ae64-45dc-84e4-a43d2adf4332'

Insert

To create a budget category the following columns are required: Name, Description, and ExpenseTypes ExpenseTypes can either be an aggregate object containing the full list of expense types or the name of a temp table. You can use the 'ValidExpenseTypes' table to retrieve the list of all vali ExpenseTypes to use.

Insert using a temp table:

INSERT INTO BudgetCategoriesExpenseTypes#TEMP (FeatureTypeCode, ExpenseTypeCode) VALUES ('EXPENSE','ADVT')
INSERT INTO BudgetCategoriesExpenseTypes#TEMP (FeatureTypeCode, ExpenseTypeCode) VALUES ('PAYMENT_REQUEST','ADVT')

INSERT INTO BudgetCategories (Name, StatusType, Description, ExpenseTypes) VALUES ('My BudgetCategory','OPEN', 'This is a sample BudgetCategory', 'BudgetCategoriesExpenseTypes#TEMP')

Insert using a Json aggregate:

INSERT INTO BudgetCategories (Name, StatusType, Description, ExpenseTypes) VALUES ('My BudgetCategory','OPEN', 'This is a sample BudgetCategory', '[{"featureTypeCode": "EXPENSE","expenseTypeCode": "ADVT"}]')

Update

The API treats update operations as a replace. The flow is the same as the Insert operation with the difference that the Id of the budget category to be updated needs to be specified in the query

INSERT INTO BudgetCategoriesExpenseTypes#TEMP (expenseTypeCode,featureTypeCode) VALUES ('AIRFC', 'EXPENSE')
INSERT INTO BudgetCategoriesExpenseTypes#TEMP (expenseTypeCode,featureTypeCode) VALUES ('BLDGMA', 'PAYMENT_REQUEST')
INSERT INTO BudgetCategoriesExpenseTypes#TEMP (expenseTypeCode,featureTypeCode) VALUES ('CONFSE', 'PAYMENT_REQUEST')

UPDATE BudgetCategories SET StatusType='OPEN', Name = 'Sampe Category', ExpenseTypes='BudgetCategoriesExpenseTypes#TEMP'  WHERE Id = '4bb52d58-81ea-48b3-8eeb-754b601b2cc5'

Delete

In order to delete a budget category the Id is required. You can either specify the budget category Id in the query or the provider will resolve the Id internally by processing the criteria.

When Id is not specified an extra request will be issued to find the Id of all budget category with a name = 'TEST'.

DELETE FROM BudgetCategories WHERE name = 'TEST'

When Id is specified in the query the provider will issue a delete request directly with no extra processing:

DELETE FROM BudgetCategories WHERE Id = 'c891b0fb-ae64-45dc-84e4-a43d2adf4332'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	False		The unique identifier for the budget category.
Name	String	False		The admin-facing name for this category.
StatusType	String	False		The status of this budget category. Supported values: OPEN, REMOVED
Description	String	False		The friendly name for this category.
ExpenseTypes	String	False		The type of feature that this expense type applies to: Purchase Request, Payment Request (Invoice), Expense, or Travel Authorization. Supported values: PURCHASE_REQUEST, PAYMENT_REQUEST, EXPENSE, REQUEST

Entries

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

テーブル固有の情報

Select

Cloud はSAP Concur API を使用して、ReportID、PaymentTypeID、BatchID_p、IsBillable、AttendeeTypeCode_p、HasAttendees、HasVAT、ExpenseTypeCode、またはAttendeeID_p を参照するフィルタを処理します。Cloud はクライアント側でCloud 内で他のフィルタを処理します。

例えば、次のクエリでは、Cloud はSAP Concur API に処理をオフロードします。

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'

Insert

経費エントリを挿入するには、次のカラムが必要です：ReportId、ExpenseTypeCode、TransactionDate、PaymentTypeId、TransactionCurrencyCode、およびTransactionAmount。

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

Update

経費エントリを更新するには、次のカラムが必要です：Id。

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

Delete

経費エントリを削除するには、次のカラムが必要です：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	ReportsV4.Id	The report ID of the report where the entry will be added.
ReportOwnerID	String	True		The login ID of the report owner.
TripID	String	True	Trips.Id	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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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. Supported 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	Date	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.
LoginId	String	False	UsersV4.UserName	The login ID of the user who owns the entries. The user must have the Web Services Admin role to use this parameter.

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.

テーブル固有の情報

Select

Cloud はSAP Concur API を使用して、Id を参照するフィルタ、またはEntryId とLoginId を参照するフィルタを処理します。Cloud はクライアント側でCloud 内で他のフィルタを処理します。

例えば、Cloud はSAP Concur API に次のクエリの処理をオフロードします。

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

Insert

EntryAttendeeAssociations に新しいレコードを挿入するには、次のカラムが必要です：EntryId およびAttendeeId。

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

Update

EntryAttendeeAssociations のレコードを更新するには、次のカラムが必要です：Id。EntryId カラムとAttendeeId カラムは更新できません。

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

Delete

EntryAttendeeAssociations のレコードを削除するには、次のカラムが必要です：Id。

DELETE FROM EntryAttendeeAssociations WHERE Id = '123456'

Columns


Name	Type	ReadOnly	References	Description
ID [KEY]	String	True		The unique identifier of the resource.
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
LoginId	String	False	UsersV4.UserName	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.

FiscalYears

Retrieve a list of all fiscal years.

Table Specific Information

Select

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

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

SELECT * FROM FiscalYears
SELECT * FROM FiscalYears WHERE IncludeRemoved = 'True'
SELECT * FROM FiscalYears WHERE LastModified > '2024-02-20 09:51:20.0'
SELECT * FROM FiscalPeriod WHERE fiscalYearId = '7af8977c-d996-4ca7-834a-a8e5b719fa95'

Insert

To create a fiscal Year the following columns are required: Name, StartDate, EndDate, Status and MonthlyFiscalPeriods MonthlyFiscalPeriods can either be an aggregate object containing the full list of fiscal periods or the name of a temp table.

Insert using a temp table:

INSERT INTO FiscalPeriod#TEMP (Name, PeriodType,StartDate,EndDate,Status) VALUES ('JAN', 'MONTHLY',  '2023-01-01', '2023-01-31', 'OPEN')
INSERT INTO FiscalPeriod#TEMP (Name, PeriodType,StartDate,EndDate,Status) VALUES ('FEB', 'MONTHLY',  '2023-02-01', '2023-02-28', 'OPEN')
INSERT INTO FiscalPeriod#TEMP (Name, PeriodType,StartDate,EndDate,Status) VALUES ('MAR', 'MONTHLY',  '2023-03-01', '2023-03-31', 'OPEN')

INSERT INTO FiscalYears (name, startDate, endDate,Status, MonthlyFiscalPeriods) VALUES ('NewPeriod', '2023-01-01', '2023-03-31', 'OPEN', 'FiscalPeriod#TEMP')

Insert using a Json aggregate:

INSERT INTO FiscalYears (name, startDate, endDate,Status, MonthlyFiscalPeriods) VALUES ('NewPeriod', '2023-01-01', '2023-03-31', 'OPEN', '[{"name": "JAN","periodType": "MONTHLY","startDate": "2023-01-01","endDate": "2023-01-31","fiscalPeriodStatus": "OPEN"}]')

Update

The API treats update operations as a replace. The flow is the same as the Insert operation with the difference that the Id of the fiscal year to be updated needs to be specified in the query

INSERT INTO FiscalPeriod#TEMP (Name, PeriodType,StartDate,EndDate,Status) VALUES ('JAN', 'MONTHLY',  '2023-01-01', '2023-01-31', 'OPEN')
INSERT INTO FiscalPeriod#TEMP (Name, PeriodType,StartDate,EndDate,Status) VALUES ('FEB', 'MONTHLY',  '2023-02-01', '2023-02-28', 'OPEN')
INSERT INTO FiscalPeriod#TEMP (Name, PeriodType,StartDate,EndDate,Status) VALUES ('MAR', 'MONTHLY',  '2023-03-01', '2023-03-31', 'OPEN')

UPDATE FiscalYears SET startDate='2023-01-01',endDate='2023-03-31',Status = 'OPEN', Name = 'TEST' , MonthlyFiscalPeriods = 'FiscalPeriod#TEMP' WHERE id  = 'c891b0fb-ae64-45dc-84e4-a43d2adf4332'

Delete

In order to delete a fiscal year the Id is required. You can either specify the fiscal year Id in the query or the provider will resolve the Id internally by processing the criteria.

When Id is not specified an extra request will be issued to find the Id of all fiscal years with a name = 'TEST'.

DELETE FROM fiscalYears WHERE name = 'TEST'

When Id is specified in the query the provider will issue a delete request directly with no extra processing:

DELETE FROM fiscalYears WHERE Id = 'c891b0fb-ae64-45dc-84e4-a43d2adf4332'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	False		The budget service's key for this object.
Name	String	False		The name of this fiscal year. Must be unique for this entity.
Status	String	False		The status of this fiscal year. Supported values: OPEN, CLOSED, REMOVED
StartDate	Date	False		The start date for this fiscal year. The distance between start date and end date may not be more than two years.
EndDate	Date	False		The end date for this fiscal year. The distance between start date and end date may not be more than two years.
CurrentYear	Boolean	False		True if this the current fiscal year based on the current date and time, False otherwise.
LastModified	Datetime	False		The UTC date and time when this object was last changed.
DisplayName	String	False		Display name for fiscal year. For date range budget item we use this field to display.
MonthlyFiscalPeriods	String	False		If true, the service will return all Fiscal Years, including those that were previously removed. If not supplied, this field defaults to false.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


Name	Type	Description
IncludeRemoved	Boolean	If true, the service will return all Fiscal Years, including those that were previously removed. If not supplied, this field defaults to false.

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	ReadOnly	References	Description
AmountWithoutVat	String	False		The net amount of the invoice, excluding VAT.
Name	String	False		The Invoice name.
ApprovalStatus	String	False		A code which indicates the approval status of the payment request.
ApprovedByDelegate	String	False		Was the Payment Request approved by a delegate. Format: true/false.
AssignedByUsername	String	False		Username of the assigning employee.
AssignedDate	String	False		The date the payment request was assigned to the current owner.
BuyerCostCenter	String	False		The company defined center responsible for the payment request.
CalculatedAmount	String	False		The sum of all line item amounts plus shipping amount and tax amount for the payment request.
CheckNumber	String	False		Check number of the payment made to the vendor.
CompanyBillToAddress	String	False
CompanyShipToAddress	String	False
CountryCode	String	False		The country code.
CreatedByUsername	String	False		Username of the payment request creator.
CurrencyCode	String	False		The 3-letter ISO 4217 currency code for the expense report currency. Examples: USD - US dollars; BRL - Brazilian real;, etc.
Custom1	String	False		The details from the Custom fields. These may not have data, depending on configuration.
Custom10	String	False		The details from the Custom fields. These may not have data, depending on configuration.
Custom11	String	False		The details from the Custom fields. These may not have data, depending on configuration.
Custom12	String	False		The details from the Custom fields. These may not have data, depending on configuration.
Custom13	String	False		The details from the Custom fields. These may not have data, depending on configuration.
Custom14	String	False		The details from the Custom fields. These may not have data, depending on configuration.
Custom15	String	False		The details from the Custom fields. These may not have data, depending on configuration.
Custom16	String	False		The details from the Custom fields. These may not have data, depending on configuration.
Custom17	String	False		The details from the Custom fields. These may not have data, depending on configuration.
Custom18	String	False		The details from the Custom fields. These may not have data, depending on configuration.
Custom19	String	False		The details from the Custom fields. These may not have data, depending on configuration.
Custom2	String	False		The details from the Custom fields. These may not have data, depending on configuration.
Custom20	String	False		The details from the Custom fields. These may not have data, depending on configuration.
Custom21	String	False		The details from the Custom fields. These may not have data, depending on configuration.
Custom22	String	False		The details from the Custom fields. These may not have data, depending on configuration.
Custom23	String	False		The details from the Custom fields. These may not have data, depending on configuration.
Custom24	String	False		The details from the Custom fields. These may not have data, depending on configuration.
Custom3	String	False		The details from the Custom fields. These may not have data, depending on configuration.
Custom4	String	False		The details from the Custom fields. These may not have data, depending on configuration.
Custom5	String	False		The details from the Custom fields. These may not have data, depending on configuration.
Custom6	String	False		The details from the Custom fields. These may not have data, depending on configuration.
Custom7	String	False		The details from the Custom fields. These may not have data, depending on configuration.
Custom8	String	False		The details from the Custom fields. These may not have data, depending on configuration.
Custom9	String	False		The details from the Custom fields. These may not have data, depending on configuration.
DataSource	String	False		A code which indicates the method used to created the Payment Request. Use
DeletedDate	String	False		The date the user deleted the payment request.
DeliverySlipNumber	String	False		The delivery slip number associated with receiving receipt.
Description	String	False		User entered description of the Payment Request.
DiscountPercentage	String	False		The discount from the supplier if the discount terms are met.
DiscountTerms	String	False		The NET discount terms with a supplier when discounts apply.
EmployeeName	String	False		The owner of the Payment Request.
ExternalPolicyId	String	False		The external policy ID.
ExtractDate	String	False		The date the payment request was extracted, in order to import it into an accounts payable system and generate a payment.
FirstApprovalDate	String	False		The date the payment request received its first approval in its approval workflow.
FirstSubmitDate	String	False		The date the payment request was first submitted.
ID [KEY]	String	False		The unique identifier of the resource.
InvoiceAmount	String	False		User-entered value representing the total invoice amount, used to calculate amount remaining on the line item page.
InvoiceDate	String	False		The date the vendor issued the invoice.
InvoiceNumber	String	False		The invoice Number from the vendor for the payment request.
InvoiceReceivedDate	String	False		The date on which the invoice was received.
IsAssigned	String	False		Whether the payment request is assigned. Format: true/false.
IsInvoiceConfirmed	String	False		Indicates if the payment request invoice is confirmed or in a different status. Format: true/false.
IsPaymentRequestDeleted	String	False		Whether the payment request is deleted. Format: true/false.
IsPaymentRequestDuplicate	String	False		Whether the payment request identified as a duplicate of another existing request. Format:true/false.
IsTestTransaction	String	False		Is the payment request a test transaction (true/false).
LastSubmitDate	String	False		The date the payment request was last submitted.
LedgerCode	String	False		A code which indicates which company journal the payment request is assigned to. Use
EmployeeId	String	False		The company ID of the employee to whom the invoice should be assigned. Has precedence over EmployeeEmail; not evaluated if EmployeeLoginId matches an employee. This value is required if none of the following are provided: LedgerCode; EmployeeLoginId; EmployeeEmail; PurchaseOrderNumber; ExternalPolicyId.
EmployeeLoginId	String	False		The login ID of the employee to whom the invoice should be assigned. Has precedence over EmployeeId and EmployeeEmail. This value is required if none of the following are provided: LedgerCode; EmployeeId; EmployeeEmail; PurchaseOrderNumber; ExternalPolicyId.
LineItemsAggr	String	False		Aggregate information of line items
VendorRemitToIdentifierAgg	String	False		Used to identify the vendor location for payment remittance. At a minimum, the VendorCode or the combination of (VendorName, Address1, and PostalCode) are required. Use of as many fields as possible is encouraged to ensure a single vendor can be identified. If more than one vendor matches the information provided, the Invoice creation attempt will fail.

Itemizations

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

テーブル固有の情報

Select

Cloud はSAP Concur API を使用して、Id を参照するフィルタ、または以下のクエリのようにReportID、EntryID、ExpenseTypeCode、LoginId の任意の組み合わせを参照するフィルタを処理します。Cloud はクライアント側でCloud 内で他のフィルタを処理します。

例えば、次のクエリはサーバー側で処理されます。

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

Insert

経費明細を挿入するには、次のカラムが必要です：EntryId、ExpenseTypeCode、TransactionDate、およびTransactionAmount。

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

Update

経費明細を更新するには、次のカラムが必要です：Id。

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

Delete

経費明細を削除するには、次のカラムが必要です：Id。

DELETE FROM Itemizations WHERE Id = '123456'

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.
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	ReportsV4.Id	The ID of the report that is the parent for the itemization.
ReportOwnerID	String	True		The login ID for the report owner.
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
LoginId	String	False	UsersV4.UserName	The login ID of the user who owns the itemizations. The user must have the Web Services Admin role to use this parameter.

Items

Lists list items based on the search criteria.

Table Specific Information

Select

The Cloud uses the SAP Concur APIs to get list items based on the search criteria.

By default the provider will return only the first level of items for each list. Only unique items will be returned. If the item is present in multiple lists it will show only once.

In the following queries, the Cloud offloads the processing to the SAP Concur APIs:

SELECT * FROM Items where ListId = '665E58E7E1226346BC424861DEC93F30'
SELECT * FROM Items where ListId IN ( '3e5ce609-bcf7-7d49-884c-baf70588d4bc','241563a3-bf89-4842-a0fb-6cbd06c87c0c')

INSERT

In order to create an Item see ListItems

Update

UPDATE Items SET value = 'updatedListItem', ShortCode='VFAL1' WHERE ID = '54f19bfa-aef0-2645-b3a4-3b2f15749858'

DELETE

DELETE FROM Items WHERE Id = '54f19bfa-aef0-2645-b3a4-3b2f15749858'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	False		The unique identifier of the list item.
Code	String	False		List item long code.
ShortCode	String	False		List item short code.
Value	String	False		List item value.
ParentId	String	False		The unique identifier of the parent list item.
Level	Int	False		Level of the list item within the list.
HasChildren	Boolean	False		If true, the list item has children in this particular list.
Lists	String	False		The unique identifiers of the lists that contains the list item. The list item may exist under one or more lists.
IsDeleted	Boolean	False		Indicates the deleted state of the item in a particular list. If false, the list item is not deleted from one or more lists. The lists field will include only the lists that contain the list item in a not-deleted state. isDeleted will only be true when the list item is deleted from all lists. The lists field will include all lists that contain the list item. デフォルト値はfalseです。
ListId	String	False	Lists.Id	The unique identifier of the list that contains the list item.

ListItems

Lists list items based on the search criteria.

Table Specific Information

Select

The Cloud uses the SAP Concur APIs to get list items based on the search criteria.

By default, the provider only returns the first level of items for each list.

In the following queries, the Cloud offloads the processing to the SAP Concur APIs:

SELECT * FROM ListItems WHERE id = '3e5ce609-bcf7-7d49-884c-baf70588d4bc'
SELECT * FROM ListItems WHERE id IN ( '665E58E7E1226346BC424861DEC93F30','3FB790E49CDC924F8B4BA29623B18D2D')
SELECT * FROM ListItems WHERE ListId = '665E58E7E1226346BC424861DEC93F30'
SELECT * FROM ListItems WHERE ListId IN ( '3e5ce609-bcf7-7d49-884c-baf70588d4bc','241563a3-bf89-4842-a0fb-6cbd06c87c0c')

INSERT

Insert query examples:

INSERT INTO ListItems (value, shortCode, listid) VALUES ('MyCustomListItem','VFAL1','4c392113-c827-4e9c-9b2f-80c473018081')

Update

ListItems cannot be updated, but the item itself can. See the table items.

DELETE

ListItems cannot be deleted, but the item itself can. See the table items.

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	False		The unique identifier of the list item.
Code	String	False		List item long code.
ShortCode	String	False		List item short code.
Value	String	False		List item value.
ParentId	String	False		The unique identifier of the parent list item.
Level	Int	False		Level of the list item within the list.
HasChildren	Boolean	False		If true, the list item has children in this particular list.
IsDeleted	Boolean	False		Indicates the deleted state of the item in a particular list. If false, the list item is not deleted from one or more lists. The lists field will include only the lists that contain the list item in a not-deleted state. isDeleted will only be true when the list item is deleted from all lists. The lists field will include all lists that contain the list item. デフォルト値はfalseです。
ListId [KEY]	String	False	Lists.Id	The unique identifier of the list that contains the list item.

Lists

The driver uses the SAP Concur APIs to view your configured lists within SAP Concur products.

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	False		Unique identifier of a list.
Value	String	False		Name of the list.
LevelCount	Int	False		Number of levels in the list.
SearchCriteria	String	False		What attribute to search by {TEXT, CODE}.
DisplayFormat	String	False		Whether the code or value is displayed first {(CODE) TEXT, TEXT (CODE)}
CategoryId	String	False		The category of the list.
CategoryType	String	False		The category of the list.
IsReadOnly	Boolean	False		If true, the list is read-only.
IsDeleted	Boolean	False		If true, the list has been deleted. デフォルト値はfalseです。

ReceiptImages

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

テーブル固有の情報

Select

Cloud はSAP Concur API を使用して、Id またはLoginId を参照するフィルタを処理します。Cloud はクライアント側でCloud 内で他のフィルタを処理します。

例えば、Cloud はSAP Concur API に次のクエリの処理をオフロードします。

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

Insert

新しい画像をINSERT クエリを使って挿入することはできませんが、UploadReceiptImage ストアドプロシージャを使用して画像をアップロードできます。

Update

画像をUPDATE クエリを使って更新することはできませんが、UploadReceiptImage ストアドプロシージャを使用して画像をアップロードできます。

Delete

領収書画像を削除するには、次のカラムが必要です：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.
LoginId	String	False	UsersV4.UserName	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.

テーブル固有の情報

Select

Cloud はSAP Concur API を使用して、このテーブルのほぼすべての検索を処理します。サーバー側の処理を使用して、任意の疑似カラム、および残りのカラムのほぼすべての組み合わせを検索できます。Cloud はクライアント側でCloud 内で他のフィルタを処理します。

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'

Insert

レポートを挿入するには、次のカラムが必要です：Name。

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

Update

レポートを更新するには、次のカラムが必要です：Id。

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

Delete

削除は、このテーブルではサポートされていません。

Columns


Name	Type	ReadOnly	References	Description
ID [KEY]	String	True		The unique identifier of the resource.
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.
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.
HasImages	Boolean	False		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.
ExpenseTypeCode	String	False		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.
LoginId	String	False	UsersV4.UserName	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.
PaymentType	String	False		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.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


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
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
SubmitDateAfter_p	String	The report submit date is after this date.Format: YYYY-MM-DD
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
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.

TravelRequests

Retrieve a list of all budget categories.

Table Specific Information

Select

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

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

SELECT * FROM TravelRequests WHERE View = 'ALL'
SELECT * FROM TravelRequests UserId = '1f710045-273d-40d2-aece-544ff49b0b1c'
SELECT * FROM TravelRequests WHERE Id = 'CFA425CD5EE71F44AD23F5067A3A944E'

INSERT

To insert an attendee the following columns are required:

Name: The name of the Request.

UserId: The userId of the Request owner for whom the Request will be created. The corresponding user name will be displayed in the audit trail of the Request. Required when using the AuthScheme CompanyLevelAuth.

INSERT INTO TravelRequests (name, userid) VALUES ('Test Request','1f710045-273d-40d2-aece-544ff49b0b1c')

UPDATE

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

NOTE: UserId is optional. Will be taken into account only if authenticating with AuthScheme CompanyLevelAuth. If not provided the update will be performed as "Concur System".

UPDATE TravelRequests SET Name = 'Event Request Updated' WHERE Id = '7B6026F14200AF45BF0EEEAB0893D6E0'

DELETE

To delete an TravelRequests the following column is required:

Id: The unique identifier of the Request.

UserId: The id of the User performing the operation. Required when authenticating with the AuthScheme CompanyLevelAuth.

DELETE FROM TravelRequests WHERE Id = '45520CE739E613418EBAD3888C92721E' AND UserId = '1f710045-273d-40d2-aece-544ff49b0b1c'

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	False		The unique identifier of the Request.
Name	String	False		The name of the Request.
Approved	Boolean	False		Indicates whether this Request is approved.
AllocationFormId	String	False		The unique identifier of the allocation form.
ApprovalLimitDate	Datetime	False		Limit approval date of the proposal. Past this date, the proposal will not be viable any more. Note: Offset MUST be in form YYYY-MM-DDThh:mm:ss.
AuthorizedDate	Datetime	False		For approved Request, the date at which the approval process was completed.
BusinessPurpose	String	False		The business purpose of the Request.
CanceledPostApproval	Boolean	False		Indicates whether this Request was canceledPostApproval.
Closed	Boolean	False		Indicates whether this Request is closed.
CreationDate	Datetime	False		The date the Request was created.
EndDate	Date	False		The end date of the Request.
EndTime	Time	False		The end time of the Request.
EverSentBack	Boolean	False		Indicates whether the Request has ever been sent back to the employee.
HighestExceptionLevel	String	False		The highest level of exception contained in this Request. Supported values: WARNING, ERROR, and NONE
Href	String	False		Hyperlink to the resource for this Request.
LastModified	Datetime	False		The date the Request was last modified.
PendingApproval	Boolean	False		Indicates whether this Request is pending approval.
PRN	String	False		The value of the pnr provided within the agency proposals by the travel agency.
RequestId	String	False		The public key of the Request (unique per customer).
StartDate	Date	False		The start date of the Request.
StartTime	Time	False		The end date of the Request.
SubmitDate	Datetime	False		The date the Request was submitted (last submit date in case of recall).
ApprovalStatusCode	String	False		The code for the approval status of the Request. Supported values: NOT_SUBMITTED, SUBMITTED, APPROVED, CANCELED, or SENTBACK
ApprovalStatusName	String	False		The approval status of the Request in the current user?s language.
ApproverId	String	False		Unique identifier of the related object.
ApproverFirstName	String	False		The first name of the employee.
ApproverLastName	String	False		The last name of the employee.
ApproverMiddleInitial	String	False		The middle initial of the employee.
MainDestinationId	String	False		The id of the location.
MainDestinationCity	String	False		Required for all city location type (not airport, or rail station - except for STD location type) The city name of the location.Note: STD location type for rail is considered as a city location type, city and countryCode fields are required in that case.
MainDestinationCountryCode	String	False		Required if city or name is used The ISO 3166-1 country code. Max length 2 characters.
MainDestinationCountrySubDivisionCode	String	False		The ISO 3166-2 country sub code.
MainDestinationiataCode	String	False		Required if air is used The IATA code of an airport location.
MainDestinationLatitude	Integer	False		The latitude of the location.
MainDestinationLongitude	Integer	False		The longitude of the location.
MainDestinationLocationCode	String	False		Required if rail is used with RAIL_xx locationType The code of the location. Optional for segments based on city locations, will be required in case of duplicate locations within database. If provided (with city and countryCode still required), it will be considered first, and if not found then city and countryCode will be considered.
MainDestinationType	String	False		Required if rail is used The type of the location.
MainDestinationName	String	False		The name of the location. Always provide the countryCode value in addition to the name.
OwnerId	String	False		Unique identifier of the related object.
OwnerFirstName	String	False		The first name of the employee.
OwnerLastName	String	False		The last name of the employee.
OwnerMiddleInitial	String	False		The middle initial of the employee.
TotalApprovedAmountValue	Integer	False		The amount in the defined currency.
TotalApprovedAmountCurrency	String	False		The 3-letter ISO 4217 code for the currency in which the amount is expressed. Max length 3 characters.
TotalPostedAmountValue	Integer	False		The amount in the defined currency.
TotalPostedAmountCurrency	String	False		The 3-letter ISO 4217 code for the currency in which the amount is expressed. Max length 3 characters.
TotalRemainingAmountValue	Integer	False		The amount in the defined currency.
TotalRemainingAmountCurrency	String	False		The 3-letter ISO 4217 code for the currency in which the amount is expressed. Max length 3 characters.
RequestTypeCode	String	False		The code of the type inherited from the Request Policy type. Possible values: Authorization, Cash Advance, Travel
RequestTypeLabel	String	False		The label of the type inherited from the Request Policy Type.
Custom1Code	String	False		The short code for the list item. For non-list fields, this value will be blank.
Custom1Value	String	False		The value of the non-list item. For list fields, this is the unique id of the list item.
Custom1Href	String	False		The link to get this list item on the list service. Empty for non-list items.
Custom2Code	String	False		The short code for the list item. For non-list fields, this value will be blank.
Custom2Value	String	False		The value of the non-list item. For list fields, this is the unique id of the list item.
Custom2Href	String	False		The link to get this list item on the list service. Empty for non-list items.
Custom3Code	String	False		The short code for the list item. For non-list fields, this value will be blank.
Custom3Value	String	False		The value of the non-list item. For list fields, this is the unique id of the list item.
Custom3Href	String	False		The link to get this list item on the list service. Empty for non-list items.
Custom4Code	String	False		The short code for the list item. For non-list fields, this value will be blank.
Custom4Value	String	False		The value of the non-list item. For list fields, this is the unique id of the list item.
Custom4Href	String	False		The link to get this list item on the list service. Empty for non-list items.
Custom5Code	String	False		The short code for the list item. For non-list fields, this value will be blank.
Custom5Value	String	False		The value of the non-list item. For list fields, this is the unique id of the list item.
Custom5Href	String	False		The link to get this list item on the list service. Empty for non-list items.
Custom6Code	String	False		The short code for the list item. For non-list fields, this value will be blank.
Custom6Value	String	False		The value of the non-list item. For list fields, this is the unique id of the list item.
Custom6Href	String	False		The link to get this list item on the list service. Empty for non-list items.
Custom7Code	String	False		The short code for the list item. For non-list fields, this value will be blank.
Custom7Value	String	False		The value of the non-list item. For list fields, this is the unique id of the list item.
Custom7Href	String	False		The link to get this list item on the list service. Empty for non-list items.
Custom8Code	String	False		The short code for the list item. For non-list fields, this value will be blank.
Custom8Value	String	False		The value of the non-list item. For list fields, this is the unique id of the list item.
Custom8Href	String	False		The link to get this list item on the list service. Empty for non-list items.
Custom9Code	String	False		The short code for the list item. For non-list fields, this value will be blank.
Custom9Value	String	False		The value of the non-list item. For list fields, this is the unique id of the list item.
Custom9Href	String	False		The link to get this list item on the list service. Empty for non-list items.
Custom10Code	String	False		The short code for the list item. For non-list fields, this value will be blank.
Custom10Value	String	False		The value of the non-list item. For list fields, this is the unique id of the list item.
Custom10Href	String	False		The link to get this list item on the list service. Empty for non-list items.
Custom12ode	String	False		The short code for the list item. For non-list fields, this value will be blank.
Custom11Value	String	False		The value of the non-list item. For list fields, this is the unique id of the list item.
Custom1Href	String	False		The link to get this list item on the list service. Empty for non-list items.
Custom12Code	String	False		The short code for the list item. For non-list fields, this value will be blank.
Custom12Value	String	False		The value of the non-list item. For list fields, this is the unique id of the list item.
Custom12Href	String	False		The link to get this list item on the list service. Empty for non-list items.
Custom13Code	String	False		The short code for the list item. For non-list fields, this value will be blank.
Custom13Value	String	False		The value of the non-list item. For list fields, this is the unique id of the list item.
Custom13Href	String	False		The link to get this list item on the list service. Empty for non-list items.
Custom14Code	String	False		The short code for the list item. For non-list fields, this value will be blank.
Custom14Value	String	False		The value of the non-list item. For list fields, this is the unique id of the list item.
Custom14Href	String	False		The link to get this list item on the list service. Empty for non-list items.
Custom15Code	String	False		The short code for the list item. For non-list fields, this value will be blank.
Custom15Value	String	False		The value of the non-list item. For list fields, this is the unique id of the list item.
Custom15Href	String	False		The link to get this list item on the list service. Empty for non-list items.
Custom16Code	String	False		The short code for the list item. For non-list fields, this value will be blank.
Custom16Value	String	False		The value of the non-list item. For list fields, this is the unique id of the list item.
Custom16Href	String	False		The link to get this list item on the list service. Empty for non-list items.
Custom17Code	String	False		The short code for the list item. For non-list fields, this value will be blank.
Custom17Value	String	False		The value of the non-list item. For list fields, this is the unique id of the list item.
Custom17Href	String	False		The link to get this list item on the list service. Empty for non-list items.
Custom18Code	String	False		The short code for the list item. For non-list fields, this value will be blank.
Custom18Value	String	False		The value of the non-list item. For list fields, this is the unique id of the list item.
Custom18Href	String	False		The link to get this list item on the list service. Empty for non-list items.
Custom19Code	String	False		The short code for the list item. For non-list fields, this value will be blank.
Custom19Value	String	False		The value of the non-list item. For list fields, this is the unique id of the list item.
Custom19Href	String	False		The link to get this list item on the list service. Empty for non-list items.
Custom20Code	String	False		The short code for the list item. For non-list fields, this value will be blank.
Custom20Value	String	False		The value of the non-list item. For list fields, this is the unique id of the list item.
Custom20Href	String	False		The link to get this list item on the list service. Empty for non-list items.
CashAdvances	String	False		The list of cash advances for this Request.
Comments	String	False		The list of comments for this Request.
Exceptions	String	False		The list of exceptions that have been raised to this Request.
Expenses	String	False		Expected expenses attached to this Request.
ExtensionOf	String	False		The Request for which this Request is an extension of, or addendum to.
EventRequest	String	False		The parent Event Request to which this child Request is related.
Policy	String	False		The policy that applies to the Request.
TravelAgency	String	False		The travel agency office that is managing the trip associated to this Request.
View	String	False		Name of the view defining the scope of the Requests to get. Supported values:ALL: Get all existing Requests for a user (relevant only for the traveler).ACTIVE Get all active Requests. Does not include cancelled Requests. Approved Requests included are aged less than three months based on current date and must not be in closed status.ACTIVEAPPROVED Get all active Requests at the Approved status. Those approved Requests are aged less than three months based on current date and must not be in closed status.UNSUBMITTED: Get all the unsubmitted Requests (relevant only for the traveler).PENDING: Get all the Requests that are submitted but not yet approved (relevant only for the traveler).VALIDATED: Get all the approved Requests for a user (relevant only for the traveler). Closed Requests are included in this view.APPROVED: Get all the approved Requests by a user (relevant only for the approver). Closed Requests are included in this view.CANCELED: Get all the cancelled Requests for a user (relevant only for the traveler). Cancelled could include closed/not closed Requests.CLOSED: Get all the closed Requests for a user (relevant only for the traveler). Includes canceled then closed Request as well as approved then closed Requests.SUBMITTED: Get all the submitted Requests for a user (relevant only for the traveler). Submitted does not include cancelled requests.TOAPPROVE: Get all Requests to be approved by the user (relevant only for the approver).PENDINGEBOOKING: Approved Requests awaiting Concur Travel booking(s).PENDINGPROPOSAL: Get all Requests submitted to a Travel Agency (TMC) step (relevant only for the TMC agent), userId is required.PROPOSALAPPROVED: Get all the approved Requests by a user (relevant only for the TMC agent), userId is required.PROPOSALCANCELED: Get all the cancelled Requests for a user (relevant only for the TMC agent), userId is required.If no view value is sent, the default view ALL will be used. デフォルト値はALLです。
UserId	String	False	UsersV4.Id	Associated with a traveler view: the unique identifier of the Request owner to use when searching for Requests.Associated with an approver view: the unique identifier of the approver to user when searching for Requests.Associated with a TMC agent view, Required, the unique identifier of the TMC agent to use. This TMC agent user must have a default Travel Agency assigned in its profile corresponding to the Travel Agency assigned to the Requests

UsersV4

Read the user's core identity profile.

Table Specific Information

Select

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

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 Cloud will offload the processing of the following queries to the SAP Concur APIs:

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

ビュー

ビューは、データを示すという点でテーブルに似ていますが、ビューは読み取り専用です。

クエリは、ビューに対して通常のテーブルと同様に実行することができます。

CData Cloud - SAP Concur ビュー


Name	Description
Allocations	Lists all allocations per entry or report.
BudgetCategoriesExpenseTypes	Retrieve a list of all expense types belonging to a budget category.
BudgetItems	Retrieve all budget items
BudgetTrackingFields	Retrieve budget tracking fields information that is setup in budget configuration.
CompanyCardTransactions	Retrieves the list of 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.
ExpenseDetails	Retrieves the details of a Expense by specifying an ExpenseId
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.
Expenses	Retrieves the expenses that belong to a specific expense report or modifies an expense on an existing expense report.
FinancialTransactions	The request returns a list of financial documents that are ready to be processed. The request can include parameters to limit the results.
FiscalPeriod	Retrieve a list of all fiscal periods
FormCodes	Query the list of form codes.
FormFields	Query all expense form fields.
Forms	Query all expense forms.
LocalizedData	List the localized strings of various codes.
Locations	Retrieve details of locations that are used by Concur and that are valid at the company of the user.
Notifications	Query all the 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.
PurchaseRequests	Gets purchase request details. The supported mode is COMPACT, which returns basic info about the purchase request along with any exceptions.
ReportComments	Read the comments entered on the expense report header, or the expenses of an existing expense report.
ReportsV4	Retrieves the expenses that belong to a specific expense report or modifies an expense on an existing expense report.
TravelRequestComments	Get the list of comments for an existing Request
TripBookingPassengers	Query all the bookings passengers for a trip.
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.
ValidExpenseTypes	Retrieve a list of all possible expense types that may be used in a budget category.

Allocations

Lists all allocations per entry or report.

テーブル固有の情報

Select

Cloud はSAP Concur API を使用して、Id を参照するフィルタ、またはReportId_p、ItemizationId_p、EntryId の任意の組み合わせを参照するフィルタを処理します。Cloud はクライアント側でCloud 内で他のフィルタを処理します。

例えば、Cloud はSAP Concur API に次のクエリの処理をオフロードします。

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

Columns


Name	Type	References	Description
Id [KEY]	String		The unique identifier of the resource.
ContextType	String		The access level of the SAP Concur user, which determines the form fields they can view/modify. Supported value: TRAVELER デフォルト値はTRAVELERです。
ReportId	String	ReportsV4.Id	The unique identifier of the report to which the expense entry belongs whose allocations are being retrieved.
ExpenseId	String	Expenses.ExpenseId	The unique identifier of the expense entry whose allocations are being retrieved.
UserID	String	UsersV4.Id	The unique identifier of the SAP Concur user. Use UsersV4 to resolve the userId
AccountCode	String		The ledger account code associated with the allocation.
IsPercentEdited	Boolean		Whether the allocation percent has been edited.
IsSystemAllocation	Boolean		Whether the allocation is a system allocation, usually hidden from the user. If displayed to the user, should be read-only.
OverLimitAccountCode	String		The ledger account code associated with the allocation if it exceeds a pre-defined threshold, for example, the user's travel allowance limit.
Percentage	Double		The percentage of the total expense that this allocation represents.
ApprovedAmountCurrencyCode	String		The 3-letter ISO 4217 currency code for the expense report currency, based on the user?s assigned reimbursement currency when the report was created. 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
ApprovedAmountValue	Double		The amount in the defined currency.
ClaimedAmountCurrencyCode	String		The 3-letter ISO 4217 currency code for the expense report currency, based on the user?s assigned reimbursement currency when the report was created. 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
ClaimedAmountValue	Double		The amount in the defined currency.
CustomDataId [KEY]	String		The unique identifier of the custom field. Examples: custom1, orgUnit1
CustomDataIsValid	String		Whether the value returned is valid or not. This value is returned for custom fields of all data types and is specifically evaluated for list items to represent the current status. Default: true
CustomDataIsListItemUrl	String
CustomDataValue	String		The value of the custom field. This field can have values for all the supported data types such as text, integer, boolean and listItemId. Maximum length: 48 characters

BudgetCategoriesExpenseTypes

Retrieve a list of all expense types belonging to a budget category.

Columns


Name	Type	References	Description
Id	String		The budget service's key for this object. If this field is not supplied, the service will use an existing expense type entry if one exists.
BudgetCategoryId	String	BudgetCategories.Id	The unique identifier for the budget category.
Name	String		The name for this expense type if it maps to an expense type set up in SAP Concur.
ExpenseTypeCode	String		The alphanumeric code that describes an expense type (Example: MEALS, AC_CATER). Any string may be used, but only expense type codes returned by GET /budgetCategory/expenseType will behave properly in the SAP Concur UI.
FeatureTypeCode	String		The type of feature that this expense type applies to: Purchase Request, Payment Request (Invoice), Expense, or Travel Authorization. Supported values: PURCHASE_REQUEST, PAYMENT_REQUEST, EXPENSE, REQUEST
SyncGuid	String

BudgetItems

Retrieve all budget items

Columns


Name	Type	References	Description
Id [KEY]	String		The key for this object.
Active	Boolean		Indicates if this budget should be displayed on user screens.
AnnualBudget	Decimal		The total budget amount and accumulated balances for this budget header.
BudgetItemStatusType	String		The status of this budget item. Supported values: OPEN, CLOSED(no spending can be attached to this budget), REMOVED
BudgetType	String		The budget type indicates if the budget item is personal or not. Supported values: PERSONAL_USE, BUDGET, RESTRICTED, TEAM
CurrencyCode	String		The 3-letter ISO 4217 currency code for the budget currency. This is the currency code of the budget amount. Spending Items are converted using yesterday?s closing value. 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.
Description	String		The user-friendly name for this budget. This description is displayed to end users on desktop and mobile.
CreatedDate	Date		The time the budget item header was created. Date in UTC.
FiscalYear	String		The fiscal year for this budget. Only the ID of the fiscal year, which can be retrieved from the Fiscal Year service, is required for creating/updating a budget.
IsTest	Boolean		The test flag for the budget item. If true, this budget will only match spending submitted by test users.
Name	String		The admin-facing name for this budget.
Owned	String		A flag indicating if the current user is the owner of this budget.
PeriodType	String		The type of period within the fiscal year that this budget's details use.
UseAdminView	String		If true, returns all budgets for this entity, if false, returns only the budgets owned by the current user. Default: false
BudgetAmounts	String		The accumulated budget amounts for this budget.
BudgetManagers	String		If managers exist, spend items only matches this budget if one of the managers is in the manager hierarchy of the submitter or approver for the given spend item.
BudgetApprovers	String		The workflow approvers for this budget.
BudgetTeamMembers	String		The team members associated with this budget.
BudgetCategory	String		The budget category for this budget item. If a budget category is present, spending items must match one of the expense types in the budget category in order to match this budget.
BudgetItemDetails	String		Specify the budget information for each fiscal period in the fiscal year.
BudgetViewers	String		The users who can view this budget.
CostObjects	String		The cost object list for matching spending items.
Owner	String		The user who is ultimately responsible for this budget.

BudgetTrackingFields

Retrieve budget tracking fields information that is setup in budget configuration.

Columns


Name	Type	References	Description
FieldId [KEY]	String		The budget service's key for this object.
BudgetTrackingFieldName	String		The budget field tracking name.
FieldType	String		he data type of this field or field collection. Supported values: LIST, MLIST, VARCHAR
ListSyncGuid	String		If the dataType of this item is LIST or MLIST, this is the ID of the list definition from the SAP Concur list service.
BudgetSequenceNumber	Int		The sequence or the order in which the budget tracking field appears in the budget UI. This value can be used instead of fieldDefinitionId when importing budgets with POST resource. The budgetSequenceNumber is the the same as the code field when importing budgets.
ConnectedListSequenceNumber	Int		Indicates the level of the budget tracking field in a connected list.
FieldDefinitionId	String		The budget service's key for this object's field definition ID. This value is required when using the Budget Item POST Resource to create or update a new budget using budget tracking fields.

CompanyCardTransactions

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

テーブル固有の情報

Select

Cloud は、このテーブルのすべての検索をクライアント側でCloud 内で処理します。

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.

テーブル固有の情報

Select

Cloud はSAP Concur API を使用して、Id またはModifiedAfter_p を参照するフィルタを処理します。Cloud はクライアント側でCloud 内で他のフィルタを処理します。

例えば、Cloud はSAP Concur API に次のクエリの処理をオフロードします。

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

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.
Modifiedafter	Date		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.

テーブル固有の情報

Select

Cloud は、このテーブルのすべての検索をクライアント側でCloud 内で処理します。

Columns


Name	Type	References	Description
Id [KEY]	String	UsersV4.Id	Id of the user
DelegatorEmail	String	UsersV4.Username	Email of the delegate
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.

ExpenseDetails

Retrieves the details of a Expense by specifying an ExpenseId

Table Specific Information

Select

The Cloud uses the SAP Concur APIs to get the expense details by specifying the expenseId. We strongly recommend that the queries be as specific as possible.

The API requires the reportId, ExpenseId and in the case of CompanyLevelOAuth, UserId. The driver can resolve each one of these properties internally, but it needs to pull all records first. For example, for a query like:

SELECT * FROM ExpenseDetails

the driver:

Pulls all users (For CompanyLevelOAuth) to resolve the userId,
Pulls all Reports to resolve the reportId,
Pulls all Expenses to resolve the ExpenseId, and then
Generates valid combinations for each of them to pull the correct data.

Because this is a very costly operation, we strongly advise the use of specific queries.

For example, in the following queries the Cloud offloads the processing to the SAP Concur APIs:

SELECT * FROM ExpenseDetails WHERE UserId = '1f338d3-68e3-4a88-a760-f979ddef61dc' AND ReportId = '54CF09456D56445CBA37' AND ExpenseId = 'F4CFC3D027EE1548B6423A9BEDE039C7'
SELECT * FROM ExpenseDetails WHERE UserId = '1f338d3-68e3-4a88-a760-f979ddef61dc' AND ReportId = '277FC923845B4E5FB9CE' AND ContextType = 'TRAVELER' AND ExpenseId = 'F4CFC3D027EE1548B6423A9BEDE039C7'

Columns


Name	Type	References	Description
ExpenseId [KEY]	String	Expenses.ExpenseId	The unique identifier for the expense.
AllocationSetId	String		The identifier of the allocation set associated with the expense. Allocations that belong to the same set are created at the same time.
AllocationState	String		Allocation state for the expense. Supported values: FULLY_ALLOCATED, NOT_ALLOCATED, PARTIALLY_ALLOCATED
ApprovedAmount	Double		The value for the approved amount of the expense.
ApprovedAmountCurrencyCode	String		The currency for the approved amount of the expense.
ApproverAdjustedAmount	Double		The total amount value adjusted for the expense by the approver.
ApproverAdjustedAmountCurrencyCode	String		The currency code for the expense adjusted by the approver.
AttendeeCount	Int		The total number of attendees associated with the expense.
AuthorizationRequestExpenseId	String		The authorization request expense ID associated with the expense.
BudgetAccrualDate	Date		The budget accrual date of the expense.
BusinessPurpose	String		The text input for the business purpose by the user.
CanAllocate	Boolean
CanDelete	Boolean
ClaimedAmount	Double		The total non-personal amount claimed for reimbursement for the expense
ClaimedAmountCurrencyCode	String		The currency code for the claimed amount.
ERceiptImageId	String		The unique identifier of the eReceipt image associated with the expense.
ExchangeRateValue	Double		Exchange rate data for the expense.
ExchangeRateOperation	String		Currency code for the exchange rate
ExpenseSourceIdentifiers	String		The list of expense sources associated with the expense.
ExpenseTypeID	String		The expense type information for the expense.
ExpenseTypeCode	String		The expense type information for the expense.
ExpenseTypeIsDeleted	Boolean		The expense type information for the expense.
ExpenseTypeListItemId	String		The expense type information for the expense.
ExpenseTypeName	String		The expense type information for the expense.
FuelTypeListItem	String		The unique id of Fuel Type.
HasBlockingExceptions	Boolean		Whether the expense has any exceptions that blocks it from being submitted.
HasExceptions	Boolean		Whether the expense has any exceptions.
HasMissingReceiptDeclaration	Boolean		Whether the expense has an affidavit declaration for missing receipt.
ImageCertificationStatus	String		The final status of the receipt image associated with the expense. Supported values: ACCEPTED, PROCESSED, PROCESSING, PDF, FAILED, NO_PROCESSING_REQUIRED
IsAutoCreated	Boolean		Whether the expense is auto created.
IsImageRequired	Boolean		Whether the image is required for the expense.
IsPaperReceiptRequired	Boolean		Whether the paper receipt is required for the expense to be submitted.
IsPersonalExpense	Boolean		Whether the expense is marked as personal (non-reimbursable) by the user.
JptRouteId	String		The unique route ID to identify a Japan rail route.
LocationName	String		The location information of the expense.
LocationCity	String		The location information of the expense.
LocationCountryCode	String		The location information of the expense.
LocationCountrySubDivisionCode	String		The location information of the expense.
LocationId	String		The location information of the expense.
MerchantTaxId	String		Merchant tax ID for the expense.
Mileage	String		The mileage data associated with the expense.
ParentExpenseId	String		Expense ID of the parent expense.
PaymentTypeId	String		The payment type information for the expense.
PaymentTypeCode	String		The payment type information for the expense.
PostedAmount	Double		The PostedAmount value.
PostedAmountCode	String		The PostedAmount code.
ReceiptId	String		The id of the ReceiptType.
ReceiptStatus	String		The status of the ReceiptType
TaxRateLocation	String		Transaction location relative to the employee?s home location as defined by their user profile. Supported values: FOREIGN - The expense transaction took place in foreign currency, HOME - The expense transaction took place in the reimbursement currency, OUT_OF_PROVINCE - The expense transaction took place outside the state jurisdiction. Default: HOME.
TicketNumber	String		The ticket number associated with the travel.
TransactionAmount	Double		The amount of the expense, in the transaction currency paid to the vendor.
TransactionAmountCode	String		The currency code for the TransactionAmount.
TransactionDate	Date		The transaction date.
Travel	String		The travel data associated with the expense.
IsExpensePartOfTravelAllowance	Boolean		The travel allowance data associated with the expense.
TravelAllowanceDailyLimit	String		The travel allowance data associated with the expense.
DailyTravelAllowanceId	String		The travel allowance data associated with the expense.
VendorId	String		The unique identifier of the vendor.
VendorName	String		The name of the vendor.
VendorDescription	String		The description of the vendor. Maximum length: 64 characters
NetAdjustedTaxAmount	Double		Net adjusted tax amount.
NetAdjustedTaxAmountCurrencyCode	String		Currency code for the net adjusted tax amount.
NetReclaimAdjustedAmount	Double		Net reclaim adjusted amount.
NetReclaimAdjustedAmountCurrencyCode	String		Currency code for the net reclaim adjusted amount.
NetReclaimAmount	Double		Net reclaim amount.
NetReclaimAmountCurrencyCode	String		Currency code for the net reclaim amount.
NetTaxAmount	Double		Net tax amount.
NetTaxAmountCurrencyCode	String		Currency code for the net tax amount.
TotalReclaimAdjustedAmount	Double		Total reclaim adjusted amount.
TotalReclaimAdjustedAmountCurrencyCode	String		Currency code for the total reclaim adjusted amount.
TotalReclaimPostedAmount	Double		Total reclaim posted amount.
TotalReclaimPostedAmountCurrencyCode	String		Currency code for the total reclaim posted amount.
TotalTaxAdjustedAmount	Double		Total tax adjusted amount.
TotalTaxAdjustedAmountCurrencyCode	String		Currency code for the total tax adjusted amount.
TotalTaxPostedAmount	Double		Total tax posted amount.
TotalTaxPostedAmountCurrencyCode	String		Currency code for the total tax posted amount.
VatTaxTotal	Double		VAT tax total amount.
VatTaxTotalCurrencyCode	String		Currency code for the VAT tax total amount.
CustomDataId [KEY]	String		The unique identifier of the custom field. Examples: custom1, orgUnit1
CustomDataIsValid	Boolean		Whether the value returned is valid or not. This value is returned for custom fields of all data types and is specifically evaluated for list items to represent the current status. Default: true
CustomDataValue	String		The value of the custom field. This field can have values for all the supported data types such as text, integer, boolean and listItemId. Maximum length: 48 characters
CustomDataItemURL	String
ReportId	String	ReportsV4.Id	The unique identifier of the report that is being read.
UserId	String	UsersV4.Id	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. デフォルト値はTRAVELERです。

ExpenseGroupConfigurationAttendeeTypes

Lists the Attendee Types of the Expense Group Configurations.

テーブル固有の情報

Select

Cloud は、このテーブルのすべての検索をクライアント側でCloud 内で処理します。

Columns


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

ExpenseGroupConfigurationPaymentTypes

Lists the payment types of the Expense Group Configurations.

テーブル固有の情報

Select

Cloud は、このテーブルのすべての検索をクライアント側でCloud 内で処理します。

Columns


Name	Type	References	Description
Id	String		The unique identifier of the payment type.
ExpenseGroupConfigurationId	String	ExpenseGroupConfigurations.Id	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

ExpenseGroupConfigurationPolicies

Lists the policies of Expense Group Configurations.

テーブル固有の情報

Select

Cloud は、このテーブルのすべての検索をクライアント側でCloud 内で処理します。

Columns


Name	Type	References	Description
Id	String		The unique identifier of the policy.
ExpenseGroupConfigurationId	String	ExpenseGroupConfigurations.Id	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.

ExpenseGroupConfigurationPolicyExpenseTypes

Lists the expense types for the Expense Group Configuration Policies.

テーブル固有の情報

Select

Cloud は、このテーブルのすべての検索をクライアント側でCloud 内で処理します。

Columns


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

ExpenseGroupConfigurations

Lists the configurations of expense groups.

テーブル固有の情報

Select

Cloud は、このテーブルのすべての検索をクライアント側でCloud 内で処理します。

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	UsersV4.UserName	The login ID of the user who owns the expense group. The user must have the Web Services Admin role to use this parameter.

Expenses

Retrieves the expenses that belong to a specific expense report or modifies an expense on an existing expense report.

Table Specific Information

Select

The Cloud uses the SAP Concur APIs to get the list of expenses for each report.

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

SELECT * FROM Expenses WHERE UserId = '1f338d3-68e3-4a88-a760-f979ddef61dc'
SELECT * FROM Expenses WHERE UserId = '1f338d3-68e3-4a88-a760-f979ddef61dc' AND ReportId IN ('54CF09456D56445CBA37','277FC923845B4E5FB9CE')
SELECT * FROM Expenses WHERE UserId = '1f338d3-68e3-4a88-a760-f979ddef61dc' AND ReportId IN ('54CF09456D56445CBA37','277FC923845B4E5FB9CE') AND ContextType = 'TRAVELER'
SELECT * FROM Expenses WHERE ExpenseId = '7207FA492E0BFF4AA72480F60752965E' AND userid = '1f710045-273d-40d2-aece-544ff49b0b1c' AND ContextType = 'TRAVELER' AND ReportId = '46864CD1C9894E1BBD47'

Columns


Name	Type	References	Description
ExpenseId [KEY]	String		The unique identifier for the expense.
AllocationSetId	String		The identifier of the allocation set associated with the expense. Allocations that belong to the same set are created at the same time.
AllocationState	String		Allocation state for the expense. Supported values: FULLY_ALLOCATED, NOT_ALLOCATED, PARTIALLY_ALLOCATED.
ApprovedAmount	Double		The approved amount of the expense, in the report currency.
ApprovedAmountCurrencyCode	String		The currency code for the approved amount of the expense.
ApproverAdjustedAmount	Double		The total amount adjusted for the expense by the approver.
ApproverAdjustedAmountCurrencyCode	String		The currency code for the total amount adjusted for the expense.
AttendeeCount	Int		The total number of attendees associated with the expense.
BusinessPurpose	String		The text input for the business purpose by the user.
ClaimedAmount	Double		The total non-personal amount value claimed for reimbursement for the expense.
ClaimedAmountCurrencyCode	String		The currency code for the claimed amount value.
EReceiptImageId	String		The unique identifier of the eReceipt image associated with the expense.
ExchangeRateValue	Double		Exchange rate data for the expense.
ExchangeRateOperation	String		Currency code for the exchange rate.
ExpenseSourceIdentifiers	String		The list of expense sources associated with the expense.
ExpenseTypeID	String		The expense type information for the expense.
ExpenseTypeCode	String		The expense type information for the expense.
ExpenseTypeIsDeleted	Boolean		The expense type information for the expense.
ExpenseTypeListItemId	String		The expense type information for the expense.
ExpenseTypeName	String		The expense type information for the expense.
FuelTypeListItem	String		The unique id of Fuel Type.
HasBlockingExceptions	Boolean		Whether the expense has any exceptions that block it from being submitted.
HasExceptions	Boolean		Whether the expense has any exceptions.
HasMissingReceiptDeclaration	Boolean		Whether the expense has an affidavit declaration for missing receipt.
ImageCertificationStatus	String		The final status of the receipt image associated with the expense.
IsAutoCreated	Boolean		Whether the expense is auto-created.
IsImageRequired	Boolean		Whether the image is required for the expense.
IsPaperReceiptRequired	Boolean		Whether the paper receipt is required for the expense to be submitted.
IsPersonalExpense	Boolean		Whether the expense is marked as personal (non-reimbursable) by the user.
JptRouteId	String		The unique route ID to identify a Japan rail route.
LocationName	String		The location information of the expense.
LocationCity	String		The location information of the expense
LocationCountryCode	String		The location information of the expense
LocationCountrySubDivisionCode	String		The location information of the expense
LocationId	String		The location information of the expense
PaymentTypeId	String		The payment type information for the expense.
PaymentTypeCode	String		The code for the payment type.
PostedAmount	Double		The amount of the expense, in the report currency.
PostedAmountCode	String		The code for the posted amount.
ReceiptImageId	String		The unique identifier of the image associated with the expense.
TicketNumber	String		The ticket number associated with the travel.
TransactionAmount	Double		The amount of the expense, in the transaction currency paid to the vendor.
TransactionAmountCode	String		Currency code for the transaction ammount
TransactionDate	Date		The transaction date.
IsExpensePartOfTravelAllowance	Boolean		The travel allowance data associated with the expense.
TravelAllowanceDailyLimit	String		The travel allowance data associated with the expense.
DailyTravelAllowanceId	String		The travel allowance data associated with the expense.
VendorId	String		The unique identifier of the vendor.
VendorName	String		The name of the vendor.
VendorDescription	String		The description of the vendor. Maximum length: 64 characters
ReportId	String	ReportsV4.Id	The unique identifier of the report that is being read.
UserId	String	UsersV4.Id	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. デフォルト値はTRAVELERです。

FinancialTransactions

The request returns a list of financial documents that are ready to be processed. The request can include parameters to limit the results.

Table Specific Information

Select

The Cloud uses the SAP Concur APIs to process filters that refer to DocType, DocId, IgnoreDocumentStatus, and SystemId. The Cloud processes other filters client-side within the Cloud.

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

SELECT * FROM FinancialTransactions WHERE DocType = 'expense'
SELECT * FROM FinancialTransactions WHERE DocType = 'expense' AND DocId = 'some doc id'
SELECT * FROM FinancialTransactions WHERE DocType = 'expense' AND IgnoreDocumentStatus = 'yes'
SELECT * FROM FinancialTransactions WHERE DocType = 'expense' AND SystemId = 'some system id'

Note DocType is always required by the API. If not specified the provider will transform:

SELECT * FROM FinancialTransactions

TO:

SELECT * FROM FinancialTransactions WHERE DocType IN ('expense','invoice','cashadvance','payroll','requestobligation','reportobligation')

To avoid performance issues always apply the DocType filter.

Columns


Name	Type	References	Description
Id [KEY]	String		The unique identifier for the document.
DocType	String		Transaction type
CompanyId	String		Unique identifier for the company in SAP Concur. Maximum 32 characters.
EntityId	String		Unique identifier for the entity in SAP Concur. Maximum 32 characters.
CompanyUuid	String		UUID for the company in SAP Concur. Maximum 36 characters.
ErpSystemId	String		The external System ID that processed the document. Maximum 50 characters.
Document	String		The JSON financial document.
DocStatus	String		The financial document status. Supported values: READY, ACKNOWLEDGED, POSTING_CONFIRMED_SUCCESS, POSTING_CONFIRMED_FAILURE.
DocId	String		The transaction unique identifier, it could be expense report ID, payment request ID or cash advance ID. If specified, a single document that matches docId is returned.
IgnoreDocumentStatus	String		Ignores the financial documents status. If yes, a document is returned regardless of status. If no, only documents that have not been acknowledged/confirmed are returned. Supported values: yes, no.
SystemId	String		The external system ID that processed the document. Maximum 50 characters.

FiscalPeriod

Retrieve a list of all fiscal periods

Columns


Name	Type	References	Description
Id [KEY]	String		The budget service's key for this object.
Name	String		The name of this fiscal period. Must be unique for this entity.
StartDate	Date		The start date for this fiscal period. Must be within the parent fiscal year.
EndDate	Date		The end date for this fiscal period. Must be within the parent fiscal year.
Status	String		The status of this fiscal period. Supported values: OPEN, CLOSED, REMOVED
CurrentPeriod	Boolean		True if this the current fiscal period based on the current date and time, False otherwise.
PeriodType	String		The type of fiscal period. Supported values: MONTHLY
FiscalYearId [KEY]	String	FiscalYears.Id	The key of the parent fiscal year for this fiscal period.
SpendDate	Date		If the current date is after this fiscal period's start date, this field shows the current date.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


Name	Type	Description
IncludeRemoved	Boolean		If true, the service will return all Fiscal Years, including those that were previously removed. If not supplied, this field defaults to false.

FormCodes

Query the list of form codes.

Columns


Name	Type	References	Description
FormCode [KEY]	String		The code for the form.
Name	String		The name of the form code.

FormFields

Query all expense form fields.

テーブル固有の情報

Select

Cloud はSAP Concur API を使用して、FormId カラムに基づくフィルタを処理します。Cloud はクライアント側でCloud 内で他のフィルタを処理します。例えば、次のクエリはサーバー側で処理されます。

SELECT * FROM FormFields WHERE FormId = '12345'

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 all expense forms.

テーブル固有の情報

Select

Cloud は、このテーブルのすべての検索をクライアント側でCloud 内で処理します。

Columns


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

LocalizedData

List the localized strings of various codes.

Columns


Name	Type	References	Description
Code [KEY]	String		Localized data code.
LocalizedValue	String		The localized value.
Type [KEY]	String		The type of attribute to request localized info.
LangCode [KEY]	String		Optional. The language code requested. lang codes examples - de, en, es, fr, fr_CA, hu, it, ja, pl, pt_BR. Default is en. Set to '' (empty) to retrieve information for all language codes.

Locations

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

テーブル固有の情報

Select

Cloud はSAP Concur API を使用して、Id またはCity_p を参照するフィルタを処理します。Cloud はクライアント側でCloud 内で他のフィルタを処理します。例えば、Cloud はSAP Concur API に次のクエリの処理をオフロードします。

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

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	Boolean		Indicates whether the location is an airport. Format: true or false
IsBookingTool	Boolean		Indicates whether the location is used by the booking tool. Format: true or false
Latitude	String		The latitude of the geocode for the location.
Longitude	String		The longitude of the geocode for the location.
Name	String		The location name. Maximum length: 64 characters
URI	String		The URI to the resource.

Notifications

Query all the notifications that have failed.

テーブル固有の情報

Select

Cloud は、このテーブルの他のすべての検索をクライアント側でCloud 内で処理します。

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	String		The URL that needs to be called to delete a failed notification.
ObjectType	String		The type of object that triggered the notification.
ObjectURI	String		The type of the event.
Status	String		The status of the notification デフォルト値はFAILEDです。

Opportunities

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

テーブル固有の情報

Select

Cloud はSAP Concur API を使用して、TripId_p、OpportunityType_p、FromUtc_p、ToUtc_p の任意の組み合わせを参照するフィルタを処理します。Cloud はクライアント側でCloud 内で他のフィルタを処理します。

例えば、次のクエリはサーバー側で処理されます。

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'

Columns


Name	Type	References	Description
ID [KEY]	String		The unique identifier of the resource.
TripId [KEY]	String	Trips.Id	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.

PaymentBatches

Lists all the payment batches.

テーブル固有の情報

Select

Cloud は、このテーブルのすべての検索をクライアント側でCloud 内で処理します。

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:

ApprovalStatusCode
PaymentStatusCode
VendorInvoiceNumber
CreateDate
UserDefinedDate
SubmitDate
PaidDate

You can use any combination of these filters but the following columns support only semi intervals createDate,userDefinedDate,submitDate,paidDate (Refere to the examples) These columns can not be used to define intervals. For example:

SELECT * FROM PaymentRequestDigests WHERE CreateDate > '2024-01-01' AND CreateDate < '2024-01-01'
SELECT * FROM PaymentRequestDigests WHERE CreateDate = '2024-01-01'

The above examples will produce 0 results. Supported queries:

SELECT * FROM PaymentRequestDigests WHERE ApprovalStatusCode = 'R_NOTF'
SELECT * FROM PaymentRequestDigests WHERE PaymentStatusCode = 'R_NOTP'
SELECT * FROM PaymentRequestDigests WHERE VendorInvoiceNumber = '2000'
SELECT * FROM PaymentRequestDigests WHERE CreateDate > '2024-01-01'
SELECT * FROM PaymentRequestDigests WHERE CreateDate < '2024-01-01'
SELECT * FROM PaymentRequestDigests WHERE UserDefinedDate > '2024-01-01'
SELECT * FROM PaymentRequestDigests WHERE UserDefinedDate < '2024-01-01'
SELECT * FROM PaymentRequestDigests WHERE SubmitDate > '2024-01-01'
SELECT * FROM PaymentRequestDigests WHERE SubmitDate < '2024-01-01'
SELECT * FROM PaymentRequestDigests WHERE PaidDate > '2024-01-01'
SELECT * FROM PaymentRequestDigests WHERE PaidDate < '2024-01-01'
SELECT * FROM PaymentRequestDigests WHERE UserDefinedDate > '2024-01-01' AND ApprovalStatusCode='R_ACCO' AND CreateDate > '2024-03-06'

Columns


Name	Type	References	Description
ID	String		The unique identifier of the resource.
ApprovalStatusCode	String		A code indicating the request's approval status.
CreateDate	Date		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.
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	Date		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	Date		The invoice date as assigned by the user.
VendorName	String		The name of the vendor.
VendorCode	String		The name of the vendor.
VendorInvoiceNumber	String		Vendor invoice number tied to invoice.
SubmitDate	Date		The payment request submit date is before this date. Format: YYYY-MM-DD

PurchaseRequests

Gets purchase request details. The supported mode is COMPACT, which returns basic info about the purchase request along with any exceptions.

Columns


Name	Type	References	Description
Id [KEY]	String		The unique purchase request reference Id. Returned by the Create Purchase Request API call.
PurchaseRequestNumber	String		The unique purchase request identifier which can be used to uniquely identify a purchase request in SAP Concur products.
PurchaseRequestQueueStatus	String		The creation status of the purchase request. Possible values are: PENDING_CREATION, CREATED, CREATE_FAILED.
PurchaseRequestWorkflowStatus	String		The workflow status of the purchase request. Possible values are: Approved, Pending Approval, Pending Cost Object Approval, Sent Back To Employee, Not Submitted, Submitted, Pending Processor Review, Vendor Approval, Approval Time Expired.
PurchaseOrders	String		If the purchase request has been approved and a purchase order generated, this array contains the purchase order details. If empty, this element will not be returned.
PurchaseRequestExceptions	String		An aggregate json object containing all exceptions, if present on the purchase request. If empty, this element will not be returned.
Mode	String		Specifies mode for Get Purchase Request Details. Supported value: COMPACT デフォルト値はCOMPACTです。

ReportComments

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

Table Specific Information

Select

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

All three filters are required to query ReportComments. If ReportId is not specified, the Cloud queries the Reports table to retrieve the Id values. If ContextType is not specified, the default value is TRAVELER.

The UserId value should be specified either in the query or in the UserId connection property. If CompanyLevelOAuth is active, all report comments for all users are pulled by default. This may result in a very large number of server requests.

Example queries:

SELECT * FROM ReportComments WHERE UserId = '4b32882d-29t3-3f88-a738-c299ae3212'
SELECT * FROM ReportComments WHERE ReportId IN ('288DG832423A4E5B6C4', '177DG832635A4E5B6D5')
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	Expenses.ExpenseId	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	ReportsV4.Id	The unique identifier of the report that is being read.
UserId	String	UsersV4.Id	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. デフォルト値はTRAVELERです。
IncludeAllComments	String		Return all the comments that are present on the report at all levels. Default value: true デフォルト値はtrueです。

ReportsV4

Retrieves the expenses that belong to a specific expense report or modifies an expense on an existing expense report.

Columns


Name	Type	References	Description
Id [KEY]	String		The unique identifier of the report that is being read.
UserID	String	UsersV4.Id	The unique identifier of the SAP Concur user.
ContextType	String		The access level of the SAP Concur user, which determines the form fields they can view/modify. デフォルト値はTRAVELERです。
Name	String
ApprovalStatus	String
ApprovalStatusId	String
Approver	String
CanAddExpense	Booolean
CardProgramStatementPeriodId	Booolean
EndDate	Date
HasBlockingExceptions	Boolean
IsApproved	Boolean
IsEnabledForFinancialIntegration	Boolean
IsEnabledForReopen	Boolean
IsPaymentConfirmed	Boolean
IsPendingApproval	Boolean
IsPendingDelegatorReview	Boolean
IsPendingProcessor	Boolean
IsReopened	Boolean
IsReportEverSentBack	Boolean
IsSentBack	Boolean
IsSentForPayment	Boolean
IsSubmitted	Boolean
PaidDate	Datetime
PaymentStatus	String
PaymentStatusId	String
ReportDate	Date
ReportNumber	String
ReportType	String
SentBackDate	Datetime
SponsorId	String
StartDate	Date
SubmitDate	Datetime

TravelRequestComments

Get the list of comments for an existing Request

Columns


Name	Type	References	Description
TravelRequestId [KEY]	String	TravelRequests.Id	The id of the travel request. Can be found by querying TravelRequests.
Value [KEY]	String		The value of the comment.
AuthorFirstName	String		The first name of the employee.
AuthorLastName	String		The last name of the employee.
CreationDateTime	Datetime		Creation date of the comment.
IsLatest	Boolean		If true, the comment has been edited since the last workflow transition.

TripBookingPassengers

Query all the bookings passengers for a trip.

テーブル固有の情報

Select

Cloud はSAP Concur API を使用して、TripId を参照するフィルタを処理します。Cloud はクライアント側でCloud 内で他のフィルタを処理します。

例えば、次のクエリはサーバー側で処理されます。

SELECT * FROM TripBookingPassengers WHERE TripId = '123456'

Columns


Name	Type	References	Description
TripId [KEY]	String	Trips.Id	The id of the trip.
BookingRecordLocator [KEY]	String		The record locator of the booking.
FirstName	String		The first name of the passenger.
LastName	String		The last name of the passenger.
LoginId	String	UsersV4.UserName	The login ID of the user who owns the trip. The user must have the Web Services Admin role to use this parameter.

TripBookings

Query all the bookings for a trip.

テーブル固有の情報

Select

Cloud はSAP Concur API を使用して、TripId を参照するフィルタを処理します。Cloud はクライアント側でCloud 内で他のフィルタを処理します。例えば、次のクエリはサーバー側で処理されます。

SELECT * FROM TripBookings WHERE TripId = 'sampleTripId'

Columns


Name	Type	References	Description
RecordLocator [KEY]	String		The record locator of the booking.
TripId [KEY]	String	Trips.Id	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.
LoginId	String	UsersV4.UserName	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.

テーブル固有の情報

Select

Cloud はSAP Concur API を使用して、TripId を参照するフィルタを処理します。Cloud はクライアント側でCloud 内で他のフィルタを処理します。例えば、次のクエリはサーバー側で処理されます。

SELECT * FROM TripBookingSegmentCharges WHERE TripId = 'sampleTripId'

Columns


Name	Type	References	Description
TripId [KEY]	String	Trips.Id	The id of the trip.
BookingRecordLocator [KEY]	String		The record locator of the booking.
SegmentType [KEY]	String		The type of the segment.
ChargeType [KEY]	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
LoginId	String	UsersV4.UserName	The login ID of the user who owns the trip. The user must have the Web Services Admin role to use this parameter.

TripBookingSegments

Query all the bookings for a trip.

テーブル固有の情報

Select

Cloud はSAP Concur API を使用して、TripId を参照するフィルタを処理します。Cloud はクライアント側でCloud 内で他のフィルタを処理します。例えば、次のクエリはサーバー側で処理されます。

SELECT * FROM TripBookingSegments WHERE TripId = 'sampleTripId'

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	Integer		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.
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;
LoginId	String	UsersV4.UserName	The login ID of the user who owns the trip. The user must have the Web Services Admin role to use this parameter.

TripBookingSegmentSeats

Query all the seats for a trip.

テーブル固有の情報

Select

Cloud はSAP Concur API を使用して、TripId とBookingRecordLocator を参照するフィルタを処理します。Cloud はクライアント側でCloud 内で他のフィルタを処理します。例えば、次のクエリはサーバー側で処理されます。

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

Columns


Name	Type	References	Description
TripId [KEY]	String	Trips.Id	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.
LoginId	String	UsersV4.UserName	The login ID of the user who owns the trip. The user must have the Web Services Admin role to use this parameter.

Trips

Query all the trips.

テーブル固有の情報

Select

Cloud はSAP Concur API を使用して、TripStartDate、TripEndDate、ModifiedDate の任意の組み合わせを参照するフィルタを処理します。Cloud はクライアント側でCloud 内で他のフィルタを処理します。

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'

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	Date		The URL-encoded start date (in Coordinated Universal Time, or UTC) for the trip. Format: YYYY-MM-DD. If no query parameters are provided, the start date is set to today?s date - 30 days. The request will only return trips that are ongoing during the provided dates, either starting on the date, or starting before the date and ongoing during the provided date.
TripEndDate	Date		The URL-encoded UTC end date for the trip. Format: YYYY-MM-DD. If no query parameters are provided, the end date is set to today?s date + 12 months. The request will only return trips that are ongoing during the provided dates, either ending on the date, or starting before the date and ongoing during the provided date.
ModifiedDate	Date		The last modified UTC date of the trips and their associated bookings. This query string will return only the trips where the trip or any of its associated bookings have a last modified date that is greater or equal to the supplied time. The provided date/time can be anytime between now and the first date of trip creation in the database. The format is either the date or the date and time combined.
TripStatus	String		The status of the trip. One of the following: Confirmed; Ticketed; Canceled; Proposal; Booked Proposal.
LoginId	String	UsersV4.UserName	The login ID of the user who owns the trip. The user must have the Web Services Admin role to use this parameter.
IncludeCancelledTrips	Boolean		Whether or not the canceled trips should be included in the response デフォルト値はfalseです。
BookingType	String		The trip includes at least one booking of this type.
IncludeVirtualTrip	Boolean		Show virtual trips. Virtual trips are segments booked offline through the Travel Request product.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


Name	Type	Description
CreatedAfterDate	Date		Date for when the trip was created. The query string will return trips created on or after this date.
CreatedBeforeDate	Date		Date for when the trip was created. The query string will return trips created on or before this date.

Users

Lists user data based on the search criteria.

テーブル固有の情報

Select

Cloud はSAP Concur API を使用して、LoginId を参照するフィルタ、またはPrimaryEmail、EmployeeID、LastName、Active の任意の組み合わせのいずれかを参照するフィルタを処理します。Cloud はクライアント側でCloud 内で他のフィルタを処理します。例えば、次のクエリはサーバー側で処理されます。

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

Columns


Name	Type	References	Description
ID [KEY]	String		The unique identifier of the resource.
EmployeeID	String		The employee ID of the user.
LoginId	String	UsersV4.UserName	The login ID of the user.
MiddleName	String		The middle name of the user.
Active	Boolean		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.

ValidExpenseTypes

Retrieve a list of all possible expense types that may be used in a budget category.

Columns


Name	Type	References	Description
Id	String		The budget service'ss key for this object. If this field is not supplied, the service will use an existing expense type entry if one exists.
Name	String		The name for this expense type if it maps to an expense type set up in SAP Concur.
ExpenseTypeCode	String		The alphanumeric code that describes an expense type (Example: MEALS, AC_CATER). Any string may be used, but only expense type codes returned by GET /budgetCategory/expenseType will behave properly in the SAP Concur UI.
FeatureTypeCode	String		The type of feature that this expense type applies to: Purchase Request, Payment Request (Invoice), Expense, or Travel Authorization. Supported values: PURCHASE_REQUEST, PAYMENT_REQUEST, EXPENSE, REQUEST
SyncGuid	String

ストアドプロシージャ

ストアドプロシージャはファンクションライクなインターフェースで、SAP Concur の単純なSELECT/INSERT/UPDATE/DELETE 処理にとどまらずCloud の機能を拡張します。

ストアドプロシージャは、パラメータのリストを受け取り、目的の機能を実行し、プロシージャが成功したか失敗したかを示すとともにSAP Concur から関連するレスポンスデータを返します。

CData Cloud - SAP Concur ストアドプロシージャ


Name	Description
CancelTrip	Cancel the specified trip.
CreateExceptionToReport	Posts an exception to the report and associates it with one of the following data levels: Report Header, Entry, Itemization, Allocation.
CreatePurchaseRequest	Create a Purchase Request based on provided header and line item details. If the request is valid it creates a purchase request and returns back a unique identifier to get the purchase request details.
CreateTripFromFile	Create a new trip from an XML file.
PostExpenseReportWorkFlowAction	Posts a workflow action for the supplied expense report. The workflow action moves the expense report through the workflow process.
SubmitExpenseReport	Submits an expense report.
SubscribeToCompanyNotifications	Subscribe from the specified notification type, or all notifications.
UnsubscribeFromCompanyNotifications	Unsubscribe from the specified notification type, or all notifications.
UpdateTripFromFile	Use an XML file to update the specified trip.

CancelTrip

Cancel the specified trip.

Input


Name	Type	Description
TripId	String	The Id of the trip you want to delete.
LoginId	String	The Id of the user you want to impersonate.

Result Set Columns


Name	Type	Description
Success	Boolean	Indicates if the trip was cancelled successfully.

CreateExceptionToReport

Posts an exception to the report and associates it with one of the following data levels: Report Header, Entry, Itemization, Allocation.

Input


Name	Type	Description
Index	String	The exception's location in a batch of exceptions. Should start at 1 and increment sequentially. This value is used to identify the record if there is an error.
ReportId	String	The Id of the report you want to create an exception for.
ObjectType	String	The type of object to assign the exception to. Format: Report, Entry, or Allocation. When sending a Report level exception, the ObjectType and ObjectId can be null, as the report key is supplied in the URI. 使用できる値は次のとおりです。Report, Entry, Allocation
ObjectId	String	The unique identifier for the object to associate with the exception. For Entry or Itemization object types use the respective ReportId; for Allocation object type use AllocationId. For a Report object type, this parameter is required.
ExceptionCode	String	The exception code for the exception to assign to the object. Must be a configured exception code in Expense. Example: NODATE.

Result Set Columns


Name	Type	Description
Success	Boolean	Indicates if the exception was created successfully.

CreatePurchaseRequest

Create a Purchase Request based on provided header and line item details. If the request is valid it creates a purchase request and returns back a unique identifier to get the purchase request details.

Input


Name	Type	Description
LoginId	String	The employee that is requesting the items. This is the employee’s Login Id. Either UserId or UserEmail or UserLoginId is required to identify the employee.
Description	String	A description of the purchase request.
PolicyExternalId	String	The external identifier of the policy that should be associated with the purchase request. If not supplied, the API will use the default policy set up for the user group assigned to the requesting employee. This is the External Id from the Invoice Policy configuration. Clients will need to get these Ids from their SAP Concur contact if they need to assign policies other than the group default.
CurrencyCode	String	The 3-letter ISO 4217 currency code of the currency that is associated with the purchase request. This code will be used for all items on this request. Example: USD
NotesToSupplier	String	Notes to print on the transmitted purchase order PDF sent to the supplier.
Comments	String	Internal comments related to this record.
ShipToAddressCode	String	The shipping address of the Purchase Request. The accepted value is the address code from ShipTo record. If not supplied, the API will use the requesting user’s default shipping address.
BillToAddressCode	String	The billing address of the Purchase Request to be used for invoicing. The accepted value is the address code from the BillTo record. If not supplied the API will use the policy’s default BillTo address.
LineItems	String	The json aggregate containing listItems

Result Set Columns


Name	Type	Description
Success	Boolean	Indicates if the report was submitted successfully.
Id	String	The Id of the generated purchase request

CreateTripFromFile

Create a new trip from an XML file.

Input


Name	Type	Description
FileLocation	String	The location of your trip XML file.
LoginId	String	The Id of the user you want to impersonate.

Result Set Columns


Name	Type	Description
Content	String	The details of the newly created trip.

PostExpenseReportWorkFlowAction

Posts a workflow action for the supplied expense report. The workflow action moves the expense report through the workflow process.

Input


Name	Type	Description
WorkflowId	String	The identifier for the desired workflow step and the workflowaction keyword. The URI is returned in the WorkflowActionURL column of the Reports table.
Action	String	The name of the workflow action. Possible values are: Approve, Send Back to Employee, or Recall to Employee. Must be one of the workflow actions available for the workflow step. 使用できる値は次のとおりです。Approve, Send Back to Employee, Recall to Employee
Comment	String	Must be used with the Send Back to Employee workflow action. This comment is visible wherever report comments are available to the employee, approver, authorization request administrator, and/or processor. Max length: 2000.

Result Set Columns


Name	Type	Description
Success	Boolean	Indicates if the workflow action was created successfully.

SubmitExpenseReport

Submits an expense report.

Input


Name	Type	Description
ReportId	String	The Id of the report.

Result Set Columns


Name	Type	Description
Success	Boolean	Indicates if the report was submitted successfully.

SubscribeToCompanyNotifications

Subscribe from the specified notification type, or all notifications.

Input


Name	Type	Description
NotificationType	String	The type of notification you want to subscribe to. If not specified you will be subscribed to all notification types. 使用できる値は次のとおりです。Itinerary, Profile, FOP

Result Set Columns


Name	Type	Description
Success	Boolean	Indicates if subscribing to the company was successful.

UnsubscribeFromCompanyNotifications

Unsubscribe from the specified notification type, or all notifications.

Input


Name	Type	Description
NotificationType	String	The type of notification you want to unsubscribe from. If not specified you will get unsubscribed from all the notification types. 使用できる値は次のとおりです。Itinerary, Profile, FOP

Result Set Columns


Name	Type	Description
Success	Boolean	Indicates if unsubscribing from the company was successful.

UpdateTripFromFile

Use an XML file to update the specified trip.

Input


Name	Type	Description
TripId	String	The Id of the trip you want to update.
FileLocation	String	The location of your trip XML file.
LoginId	String	The Id of the user you want to impersonate.

Result Set Columns


Name	Type	Description
Content	String	The details of the newly created trip.

システムテーブル

このセクションで説明されているシステムテーブルをクエリして、スキーマ情報、データソース機能に関する情報、およびバッチ操作の統計にアクセスできます。

スキーマテーブル

以下のテーブルは、SAP Concur のデータベースメタデータを返します。

sys_catalogs：利用可能なデータベースをリスト。
sys_schemas：利用可能なスキーマをリスト。
sys_tables：利用可能なテーブルおよびビューをリスト。
sys_tablecolumns：利用可能なテーブルおよびビューのカラムについて説明。
sys_procedures：利用可能なストアドプロシージャについて説明。
sys_procedureparameters：ストアドプロシージャパラメータについて説明。
sys_keycolumns：主キーおよび外部キーについて説明。
sys_indexes：利用可能なインデックスについて説明。

データソーステーブル

以下のテーブルは、データソースへの接続方法およびクエリ方法についての情報を返します。

sys_connection_props：利用可能な接続プロパティについての情報を返す。
sys_sqlinfo：Cloud がデータソースにオフロードできるSELECT クエリについて説明。

クエリ情報テーブル

次のテーブルは、データ変更クエリのクエリ統計を返します。

sys_identity：バッチ処理または単一の更新に関する情報を返す。

sys_catalogs

利用可能なデータベースをリストします。

次のクエリは、接続文字列で決定されるすべてのデータベースを取得します。

SELECT * FROM sys_catalogs

Columns


Name	Type	Description
CatalogName	String	データベース名。

sys_schemas

利用可能なスキーマをリストします。

次のクエリは、すべての利用可能なスキーマを取得します。

          SELECT * FROM sys_schemas

Columns


Name	Type	Description
CatalogName	String	データベース名。
SchemaName	String	スキーマ名。

sys_tables

利用可能なテーブルをリストします。

次のクエリは、利用可能なテーブルおよびビューを取得します。

          SELECT * FROM sys_tables

Columns


Name	Type	Description
CatalogName	String	テーブルまたはビューを含むデータベース。
SchemaName	String	テーブルまたはビューを含むスキーマ。
TableName	String	テーブル名またはビュー名。
TableType	String	テーブルの種類（テーブルまたはビュー）。
Description	String	テーブルまたはビューの説明。
IsUpdateable	Boolean	テーブルが更新可能かどうか。

sys_tablecolumns

利用可能なテーブルおよびビューのカラムについて説明します。

次のクエリは、Departments テーブルのカラムとデータ型を返します。

SELECT ColumnName, DataTypeName FROM sys_tablecolumns WHERE TableName='Departments'

Columns


Name	Type	Description
CatalogName	String	テーブルまたはビューを含むデータベースの名前。
SchemaName	String	テーブルまたはビューを含むスキーマ。
TableName	String	カラムを含むテーブルまたはビューの名前。
ColumnName	String	カラム名。
DataTypeName	String	データ型の名前。
DataType	Int32	データ型を示す整数値。この値は、実行時に環境に基づいて決定されます。
Length	Int32	カラムのストレージサイズ。
DisplaySize	Int32	指定されたカラムの通常の最大幅（文字数）。
NumericPrecision	Int32	数値データの最大桁数。文字データおよび日時データの場合は、カラムの長さ（文字数）。
NumericScale	Int32	カラムのスケール（小数点以下の桁数）。
IsNullable	Boolean	カラムがNull を含められるかどうか。
Description	String	カラムの簡単な説明。
Ordinal	Int32	カラムのシーケンスナンバー。
IsAutoIncrement	String	カラムに固定増分値が割り当てられるかどうか。
IsGeneratedColumn	String	生成されたカラムであるかどうか。
IsHidden	Boolean	カラムが非表示かどうか。
IsArray	Boolean	カラムが配列かどうか。
IsReadOnly	Boolean	カラムが読み取り専用かどうか。
IsKey	Boolean	sys_tablecolumns から返されたフィールドがテーブルの主キーであるかどうか。

sys_procedures

利用可能なストアドプロシージャをリストします。

次のクエリは、利用可能なストアドプロシージャを取得します。

          SELECT * FROM sys_procedures

Columns


Name	Type	Description
CatalogName	String	ストアドプロシージャを含むデータベース。
SchemaName	String	ストアドプロシージャを含むスキーマ。
ProcedureName	String	ストアドプロシージャの名前。
Description	String	ストアドプロシージャの説明。
ProcedureType	String	PROCEDURE やFUNCTION などのプロシージャのタイプ。

sys_procedureparameters

ストアドプロシージャパラメータについて説明します。

次のクエリは、SelectEntries ストアドプロシージャのすべての入力パラメータについての情報を返します。

SELECT * FROM sys_procedureparameters WHERE ProcedureName='SelectEntries' AND Direction=1 OR Direction=2

Columns


Name	Type	Description
CatalogName	String	ストアドプロシージャを含むデータベースの名前。
SchemaName	String	ストアドプロシージャを含むスキーマの名前。
ProcedureName	String	パラメータを含むストアドプロシージャの名前。
ColumnName	String	ストアドプロシージャパラメータの名前。
Direction	Int32	パラメータのタイプに対応する整数値：input (1)。input/output (2)、またはoutput(4)。input/output タイプパラメータは、入力パラメータと出力パラメータの両方になれます。
DataTypeName	String	データ型の名前。
DataType	Int32	データ型を示す整数値。この値は、実行時に環境に基づいて決定されます。
Length	Int32	文字データの場合は、許可される文字数。数値データの場合は、許可される桁数。
NumericPrecision	Int32	数値データの場合は最大精度。文字データおよび日時データの場合は、カラムの長さ（文字数）。
NumericScale	Int32	数値データの小数点以下の桁数。
IsNullable	Boolean	パラメータがNull を含められるかどうか。
IsRequired	Boolean	プロシージャの実行にパラメータが必要かどうか。
IsArray	Boolean	パラメータが配列かどうか。
Description	String	パラメータの説明。
Ordinal	Int32	パラメータのインデックス。

sys_keycolumns

主キーおよび外部キーについて説明します。

次のクエリは、Departments テーブルの主キーを取得します。

         SELECT * FROM sys_keycolumns WHERE IsKey='True' AND TableName='Departments'

Columns


Name	Type	Description
CatalogName	String	キーを含むデータベースの名前。
SchemaName	String	キーを含むスキーマの名前。
TableName	String	キーを含むテーブルの名前。
ColumnName	String	キーカラムの名前
IsKey	Boolean	カラムがTableName フィールドで参照されるテーブル内の主キーかどうか。
IsForeignKey	Boolean	カラムがTableName フィールドで参照される外部キーかどうか。
PrimaryKeyName	String	主キーの名前。
ForeignKeyName	String	外部キーの名前。
ReferencedCatalogName	String	主キーを含むデータベース。
ReferencedSchemaName	String	主キーを含むスキーマ。
ReferencedTableName	String	主キーを含むテーブル。
ReferencedColumnName	String	主キーのカラム名。

sys_foreignkeys

外部キーについて説明します。

次のクエリは、他のテーブルを参照するすべての外部キーを取得します。

         SELECT * FROM sys_foreignkeys WHERE ForeignKeyType = 'FOREIGNKEY_TYPE_IMPORT'

カラム


名前	タイプ	説明
CatalogName	String	キーを含むデータベースの名前。
SchemaName	String	キーを含むスキーマの名前。
TableName	String	キーを含むテーブルの名前。
ColumnName	String	キーカラムの名前
PrimaryKeyName	String	主キーの名前。
ForeignKeyName	String	外部キーの名前。
ReferencedCatalogName	String	主キーを含むデータベース。
ReferencedSchemaName	String	主キーを含むスキーマ。
ReferencedTableName	String	主キーを含むテーブル。
ReferencedColumnName	String	主キーのカラム名。
ForeignKeyType	String	外部キーがインポート（他のテーブルを指す）キーかエクスポート（他のテーブルから参照される）キーかを指定します。

sys_primarykeys

主キーについて説明します。

次のクエリは、すべてのテーブルとビューから主キーを取得します。

         SELECT * FROM sys_primarykeys

Columns


Name	Type	Description
CatalogName	String	キーを含むデータベースの名前。
SchemaName	String	キーを含むスキーマの名前。
TableName	String	キーを含むテーブルの名前。
ColumnName	String	キーカラムの名前。
KeySeq	String	主キーのシーケンス番号。
KeyName	String	主キーの名前。

sys_indexes

利用可能なインデックスについて説明します。インデックスをフィルタリングすることで、より高速なクエリ応答時間でセレクティブクエリを記述できます。

次のクエリは、主キーでないすべてのインデックスを取得します。

          SELECT * FROM sys_indexes WHERE IsPrimary='false'

Columns


Name	Type	Description
CatalogName	String	インデックスを含むデータベースの名前。
SchemaName	String	インデックスを含むスキーマの名前。
TableName	String	インデックスを含むテーブルの名前。
IndexName	String	インデックス名。
ColumnName	String	インデックスに関連付けられたカラムの名前。
IsUnique	Boolean	インデックスが固有の場合はTrue。そうでない場合はFalse。
IsPrimary	Boolean	インデックスが主キーの場合はTrue。そうでない場合はFalse。
Type	Int16	インデックスタイプに対応する整数値：statistic (0)、clustered (1)、hashed (2)、またはother (3)。
SortOrder	String	並べ替え順序：A が昇順、D が降順。
OrdinalPosition	Int16	インデックスのカラムのシーケンスナンバー。

sys_connection_props

利用可能な接続プロパティと、接続文字列に設定されている接続プロパティに関する情報を返します。

次のクエリは、接続文字列に設定されている、あるいはデフォルト値で設定されているすべての接続プロパティを取得します。

SELECT * FROM sys_connection_props WHERE Value <> ''

Columns


Name	Type	Description
Name	String	接続プロパティ名。
ShortDescription	String	簡単な説明。
Type	String	接続プロパティのデータ型。
Default	String	明示的に設定されていない場合のデフォルト値。
Values	String	可能な値のカンマ区切りリスト。別な値が指定されていると、検証エラーがスローされます。
Value	String	設定した値またはあらかじめ設定されたデフォルト。
Required	Boolean	プロパティが接続に必要かどうか。
Category	String	接続プロパティのカテゴリ。
IsSessionProperty	String	プロパティが、現在の接続に関する情報を保存するために使用されるセッションプロパティかどうか。
Sensitivity	String	プロパティの機密度。これは、プロパティがロギングおよび認証フォームで難読化されているかどうかを通知します。
PropertyName	String	キャメルケースの短縮形の接続プロパティ名。
Ordinal	Int32	パラメータのインデックス。
CatOrdinal	Int32	パラメータカテゴリのインデックス。
Hierarchy	String	このプロパティと一緒に設定する必要がある、関連のある依存プロパティを表示します。
Visible	Boolean	プロパティが接続UI に表示されるかどうかを通知します。
ETC	String	プロパティに関するその他のさまざまな情報。

sys_sqlinfo

Cloud がデータソースにオフロードできるSELECT クエリ処理について説明します。

SQL 構文の詳細については、SQL 準拠を参照してください。

データソースのSELECT 機能

以下はSQL 機能のサンプルデータセットです。 SELECT 機能のいくつかの側面がサポートされている場合には、カンマ区切りのリストで返されます。サポートされていない場合、カラムにはNO が入ります。


名前	説明	有効な値
AGGREGATE_FUNCTIONS	サポートされている集計関数。	AVG, COUNT, MAX, MIN, SUM, DISTINCT
COUNT	COUNT 関数がサポートされているかどうか。	YES, NO
IDENTIFIER_QUOTE_OPEN_CHAR	識別子をエスケープするための開始文字。	[
IDENTIFIER_QUOTE_CLOSE_CHAR	識別子をエスケープするための終了文字。	]
SUPPORTED_OPERATORS	サポートされているSQL 演算子。	=, >, <, >=, <=, <>, !=, LIKE, NOT LIKE, IN, NOT IN, IS NULL, IS NOT NULL, AND, OR
GROUP_BY	GROUP BY がサポートされているかどうか。サポートされている場合、どのレベルでサポートされているか。	NO, NO_RELATION, EQUALS_SELECT, SQL_GB_COLLATE
OJ_CAPABILITIES	サポートされている外部結合の種類。	NO, LEFT, RIGHT, FULL, INNER, NOT_ORDERED, ALL_COMPARISON_OPS
OUTER_JOINS	外部結合がサポートされているかどうか。	YES, NO
SUBQUERIES	サブクエリがサポートされているかどうか。サポートされていれば、どのレベルでサポートされているか。	NO, COMPARISON, EXISTS, IN, CORRELATED_SUBQUERIES, QUANTIFIED
STRING_FUNCTIONS	サポートされている文字列関数。	LENGTH, CHAR, LOCATE, REPLACE, SUBSTRING, RTRIM, LTRIM, RIGHT, LEFT, UCASE, SPACE, SOUNDEX, LCASE, CONCAT, ASCII, REPEAT, OCTET, BIT, POSITION, INSERT, TRIM, UPPER, REGEXP, LOWER, DIFFERENCE, CHARACTER, SUBSTR, STR, REVERSE, PLAN, UUIDTOSTR, TRANSLATE, TRAILING, TO, STUFF, STRTOUUID, STRING, SPLIT, SORTKEY, SIMILAR, REPLICATE, PATINDEX, LPAD, LEN, LEADING, KEY, INSTR, INSERTSTR, HTML, GRAPHICAL, CONVERT, COLLATION, CHARINDEX, BYTE
NUMERIC_FUNCTIONS	サポートされている数値関数。	ABS, ACOS, ASIN, ATAN, ATAN2, CEILING, COS, COT, EXP, FLOOR, LOG, MOD, SIGN, SIN, SQRT, TAN, PI, RAND, DEGREES, LOG10, POWER, RADIANS, ROUND, TRUNCATE
TIMEDATE_FUNCTIONS	サポートされている日付および時刻関数。	NOW, CURDATE, DAYOFMONTH, DAYOFWEEK, DAYOFYEAR, MONTH, QUARTER, WEEK, YEAR, CURTIME, HOUR, MINUTE, SECOND, TIMESTAMPADD, TIMESTAMPDIFF, DAYNAME, MONTHNAME, CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP, EXTRACT
REPLICATION_SKIP_TABLES	レプリケーション中にスキップされたテーブルを示します。
REPLICATION_TIMECHECK_COLUMNS	レプリケーション中に更新判断のカラムとして使用するかどうかを、（指定された順に）チェックするカラムのリストを含む文字列の配列。
IDENTIFIER_PATTERN	識別子としてどの文字列が有効かを示す文字列値。
SUPPORT_TRANSACTION	プロバイダーが、コミットやロールバックなどのトランザクションをサポートしているかどうかを示します。	YES, NO
DIALECT	使用するSQL ダイアレクトを示します。
KEY_PROPERTIES	Uniform データベースを特定するプロパティを示します。
SUPPORTS_MULTIPLE_SCHEMAS	プロバイダー用に複数のスキームが存在するかどうかを示します。	YES, NO
SUPPORTS_MULTIPLE_CATALOGS	プロバイダー用に複数のカタログが存在するかどうかを示します。	YES, NO
DATASYNCVERSION	このドライバーにアクセスするために必要な、CData Sync のバージョン。	Standard, Starter, Professional, Enterprise
DATASYNCCATEGORY	このドライバーのCData Sync カテゴリ。	Source, Destination, Cloud Destination
SUPPORTSENHANCEDSQL	API で提供されている以上の、追加SQL 機能がサポートされているかどうか。	TRUE, FALSE
SUPPORTS_BATCH_OPERATIONS	バッチ操作がサポートされているかどうか。	YES, NO
SQL_CAP	このドライバーでサポートされているすべてのSQL 機能。	SELECT, INSERT, DELETE, UPDATE, TRANSACTIONS, ORDERBY, OAUTH, ASSIGNEDID, LIMIT, LIKE, BULKINSERT, COUNT, BULKDELETE, BULKUPDATE, GROUPBY, HAVING, AGGS, OFFSET, REPLICATE, COUNTDISTINCT, JOINS, DROP, CREATE, DISTINCT, INNERJOINS, SUBQUERIES, ALTER, MULTIPLESCHEMAS, GROUPBYNORELATION, OUTERJOINS, UNIONALL, UNION, UPSERT, GETDELETED, CROSSJOINS, GROUPBYCOLLATE, MULTIPLECATS, FULLOUTERJOIN, MERGE, JSONEXTRACT, BULKUPSERT, SUM, SUBQUERIESFULL, MIN, MAX, JOINSFULL, XMLEXTRACT, AVG, MULTISTATEMENTS, FOREIGNKEYS, CASE, LEFTJOINS, COMMAJOINS, WITH, LITERALS, RENAME, NESTEDTABLES, EXECUTE, BATCH, BASIC, INDEX
PREFERRED_CACHE_OPTIONS	使用したいcacheOptions を指定する文字列値。
ENABLE_EF_ADVANCED_QUERY	ドライバーがEntity Framework の高度なクエリをサポートしているかどうかを示します。サポートしていなければ、クエリはクライアントサイドで処理されます。	YES, NO
PSEUDO_COLUMNS	利用可能な疑似カラムを示す文字列の配列。
MERGE_ALWAYS	値がtrue であれば、CData Sync 内でMerge Model が強制的に実行されます。	TRUE, FALSE
REPLICATION_MIN_DATE_QUERY	レプリケート開始日時を返すSELECT クエリ。
REPLICATION_MIN_FUNCTION	サーバーサイドでmin を実行するために使用する式名を、プロバイダーが指定できるようになります。
REPLICATION_START_DATE	レプリケート開始日を、プロバイダーが指定できるようになります。
REPLICATION_MAX_DATE_QUERY	レプリケート終了日時を返すSELECT クエリ。
REPLICATION_MAX_FUNCTION	サーバーサイドでmax を実行するために使用する式名を、プロバイダーが指定できるようになります。
IGNORE_INTERVALS_ON_INITIAL_REPLICATE	初回のレプリケートで、レプリケートをチャンクに分割しないテーブルのリスト。
CHECKCACHE_USE_PARENTID	CheckCache 構文を親キーカラムに対して実行するかどうかを示します。	TRUE, FALSE
CREATE_SCHEMA_PROCEDURES	スキーマファイルの生成に使用できる、ストアドプロシージャを示します。

次のクエリは、WHERE 句で使用できる演算子を取得します。

SELECT * FROM sys_sqlinfo WHERE Name = 'SUPPORTED_OPERATORS'

WHERE 句では、個々のテーブルの制限や要件が異なる場合がありますので注意してください。詳しくは、データモデルセクションを参照してください。

Columns


Name	Type	Description
NAME	String	SQL 構文のコンポーネント、またはサーバー上で処理できる機能。
VALUE	String	サポートされるSQL またはSQL 構文の詳細。

sys_identity

試行された変更に関する情報を返します。

次のクエリは、バッチ処理で変更された行のId を取得します。

         SELECT * FROM sys_identity

Columns


Name	Type	Description
Id	String	データ変更処理から返された、データベース生成Id。
Batch	String	バッチの識別子。1 は単一処理。
Operation	String	バッチ内の処理の結果：INSERTED、UPDATED、またはDELETED。
Message	String	SUCCESS、またはバッチ内の更新が失敗した場合のエラーメッセージ。

sys_information

利用可能なシステム情報を説明します。

次のクエリは、すべてのカラムを取得します。

SELECT * FROM sys_information

Columns


Name	Type	Description
Product	String	製品名。
Version	String	製品のバージョン番号。
Datasource	String	製品が接続するデータソースの名前。
NodeId	String	製品がインストールされているマシンの固有識別子。
HelpURL	String	製品のヘルプドキュメントのURL。
License	String	製品のライセンス情報。（この情報が利用できない場合、この項目は空白のままか「N/A」と表示されます。）
Location	String	製品のライブラリが格納されているファイルパスの場所。
Environment	String	製品が現在稼働している環境またはランタイムのバージョン。
DataSyncVersion	String	本コネクタを使用するために必要なCData Sync のティア。
DataSyncCategory	String	CData Sync 機能のカテゴリ（例：Source、Destination）。

接続文字列オプション

接続文字列プロパティは、接続を確立するために使用できるさまざまなオプションです。このセクションでは、本プロバイダーの接続文字列で設定できるオプションの一覧を示します。詳細については各リンクをクリックしてください。

Authentication

プロパティ	説明
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.
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://us2.api.concursolutions.com for some production accounts and https://us-impl.api.concursolutions.com for sandbox accounts.

Connection

プロパティ	説明
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

プロパティ	説明
OAuthClientId	カスタムOAuth アプリケーションの作成時に割り当てられたクライアントId を指定します。（コンシューマーキーとも呼ばれます。）このID は、カスタムアプリケーションをOAuth 認可サーバーに登録します。
OAuthClientSecret	カスタムOAuth アプリケーションの作成時に割り当てられたクライアントシークレットを指定します。（コンシューマーシークレットとも呼ばれます。）このシークレットは、カスタムアプリケーションをOAuth 認可サーバーに登録します。
GeoLocation	The GeoLocation of the account instance.
OAuthGrantType	選択したOAuth フローのグラント種別を指定します。この値は、OAuth カスタムアプリケーション作成時に設定されたグラント種別と同じである必要があります。

SSL

プロパティ	説明
SSLServerCert	TLS/SSL を使用して接続する際に、サーバーが受け入れ可能な証明書を指定します。

Logging

プロパティ	説明
Verbosity	ログファイルのVerbosity レベルを指定し、記録される情報の詳細度を制御します。サポートされる値の範囲は1から5までです。

Schema

プロパティ	説明
BrowsableSchemas	レポートされるスキーマを利用可能なすべてのスキーマのサブセットに制限するオプション設定。例えば、 BrowsableSchemas=SchemaA,SchemaB,SchemaC です。

Miscellaneous

プロパティ	説明
MaxRows	集計やGROUP BY を使用しないクエリで返される最大行数を指定します。
Pagesize	The maximum number of results to return per page from SAP Concur.
PseudoColumns	テーブルカラムとして公開する擬似カラムを指定します。'TableName=ColumnName;TableName=ColumnName' という形式を使用します。デフォルトは空の文字列で、このプロパティを無効にします。
Timeout	provider がタイムアウトエラーを返すまでにサーバーからの応答を待機する最大時間を秒単位で指定します。デフォルトは60秒です。タイムアウトを無効にするには0を設定します。

Authentication

このセクションでは、本プロバイダーの接続文字列で設定可能なAuthentication プロパティの全リストを提供します。

プロパティ	説明
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.
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://us2.api.concursolutions.com for some production accounts and https://us-impl.api.concursolutions.com for sandbox accounts.

プロパティ	説明
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.

解説

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. Some V4 tables allow UserId to be set as query parameter. If not set in either the query or in the conection string, the driver tries to automaticaly get the user id either by parsing the authentication info or by making an extra request. In case of CompanyLevelOAuth, only user input is considered.

OAuth

このセクションでは、本プロバイダーの接続文字列で設定可能なOAuth プロパティの全リストを提供します。

プロパティ	説明
OAuthClientId	カスタムOAuth アプリケーションの作成時に割り当てられたクライアントId を指定します。（コンシューマーキーとも呼ばれます。）このID は、カスタムアプリケーションをOAuth 認可サーバーに登録します。
OAuthClientSecret	カスタムOAuth アプリケーションの作成時に割り当てられたクライアントシークレットを指定します。（コンシューマーシークレットとも呼ばれます。）このシークレットは、カスタムアプリケーションをOAuth 認可サーバーに登録します。
GeoLocation	The GeoLocation of the account instance.
OAuthGrantType	選択したOAuth フローのグラント種別を指定します。この値は、OAuth カスタムアプリケーション作成時に設定されたグラント種別と同じである必要があります。

解説

ほとんどの場合、デフォルトのグラント種別は変更すべきではありません。最も一般的なOAuth グラント種別とそれぞれのメリット・デメリットについては、https://oauth.net/2/grant-types/ を参照してください。

SSL

このセクションでは、本プロバイダーの接続文字列で設定可能なSSL プロパティの全リストを提供します。

プロパティ	説明
SSLServerCert	TLS/SSL を使用して接続する際に、サーバーが受け入れ可能な証明書を指定します。

SSLServerCert

TLS/SSL を使用して接続する際に、サーバーが受け入れ可能な証明書を指定します。

データ型

string

デフォルト値

""

解説

TLS/SSL 接続を使用する場合は、このプロパティを使用して、サーバーが受け入れるTLS/SSL 証明書を指定できます。コンピュータによって信頼されていない他の証明書はすべて拒否されます。

このプロパティは、次のフォームを取ります：


説明	例
フルPEM 証明書（例では省略されています）	-----BEGIN CERTIFICATE----- MIIChTCCAe4CAQAwDQYJKoZIhv......Qw== -----END CERTIFICATE-----
証明書を保有するローカルファイルへのパス。	C:\cert.cer
公開鍵（例では省略されています）	-----BEGIN RSA PUBLIC KEY----- MIGfMA0GCSq......AQAB -----END RSA PUBLIC KEY-----
MD5 Thumbprint （hex 値はスペースおよびコロン区切り）	ecadbdda5a1529c58a1e9e09828d70e4
SHA1 Thumbprint （hex 値はスペースおよびコロン区切り）	34a929226ae0819f2ec14b4a3d904f801cbb150d

これを指定しない場合は、マシンが信用するすべての証明書が受け入れられます。

すべての証明書の受け入れを示すには、'*'を使用します。セキュリティ上の理由から、これはお勧めできません。

Logging

このセクションでは、本プロバイダーの接続文字列で設定可能なLogging プロパティの全リストを提供します。

プロパティ	説明
Verbosity	ログファイルのVerbosity レベルを指定し、記録される情報の詳細度を制御します。サポートされる値の範囲は1から5までです。

Verbosity

ログファイルのVerbosity レベルを指定し、記録される情報の詳細度を制御します。サポートされる値の範囲は1から5までです。

データ型

string

デフォルト値

"1"

解説

このプロパティは、Cloud がログファイルに含める詳細レベルを定義します。 Verbosity レベルを高くするとログに記録される情報の詳細が増えますが、ログファイルが大きくなり取り込まれるデータが増えるためパフォーマンスが低下する可能性があります。

デフォルトのVerbosity レベルは1で、通常の運用にはこれが推奨されます。より高いVerbosity レベルは主にデバッグを目的としています。各レベルの詳細については、ログを参照してください。

LogModules プロパティと組み合わせることで、Verbosity は特定の情報カテゴリに対するログの詳細度を調整できます。

Schema

このセクションでは、本プロバイダーの接続文字列で設定可能なSchema プロパティの全リストを提供します。

プロパティ	説明
BrowsableSchemas	レポートされるスキーマを利用可能なすべてのスキーマのサブセットに制限するオプション設定。例えば、 BrowsableSchemas=SchemaA,SchemaB,SchemaC です。

BrowsableSchemas

レポートされるスキーマを利用可能なすべてのスキーマのサブセットに制限するオプション設定。例えば、 BrowsableSchemas=SchemaA,SchemaB,SchemaC です。

データ型

string

デフォルト値

""

解説

利用可能なデータベーススキーマをすべてリストすると余分な時間がかかり、パフォーマンスが低下します。接続文字列にスキーマのリストを指定することで、時間を節約しパフォーマンスを向上させることができます。

Miscellaneous

このセクションでは、本プロバイダーの接続文字列で設定可能なMiscellaneous プロパティの全リストを提供します。

プロパティ	説明
MaxRows	集計やGROUP BY を使用しないクエリで返される最大行数を指定します。
Pagesize	The maximum number of results to return per page from SAP Concur.
PseudoColumns	テーブルカラムとして公開する擬似カラムを指定します。'TableName=ColumnName;TableName=ColumnName' という形式を使用します。デフォルトは空の文字列で、このプロパティを無効にします。
Timeout	provider がタイムアウトエラーを返すまでにサーバーからの応答を待機する最大時間を秒単位で指定します。デフォルトは60秒です。タイムアウトを無効にするには0を設定します。

デフォルト値

60

解説

このプロパティは、Cloud が操作をキャンセルする前に操作の完了を待機する最大時間を秒単位で制御します。操作の完了前にタイムアウト時間が経過すると、Cloud は操作をキャンセルして例外をスローします。

タイムアウトは、クエリや操作全体ではなくサーバーとの個々の通信に適用されます。例えば、各ページング呼び出しがタイムアウト制限内に完了する場合、クエリは60秒を超えて実行を続けることができます。

このプロパティを0に設定するとタイムアウトが無効になり、操作が成功するか、サーバー側のタイムアウト、ネットワークの中断、またはサーバーのリソース制限などの他の条件で失敗するまで無期限に実行されます。このプロパティは慎重に使用してください。長時間実行される操作がパフォーマンスを低下させたり、応答しなくなる可能性があるためです。

Cloud

SAP Concur - CData Cloud

概要

主要機能

はじめに

SAP Concur への接続

CData Cloud サービスからデータにアクセス

接続の確立

SAP Concur への認証

デスクトップ認証グラント種別

CODE

PASSWORD

Company-Level 認証

SAP Concur ログインID 変数の使用

カスタムOAuth アプリケーションの作成

プロシージャ

SSL の設定

SSL 設定のカスタマイズ

ファイアウォールとプロキシ

Firewall またはProxy 経由の接続

HTTP プロキシ

その他のプロキシ

データモデル

スキーマのカスタマイズ

クエリ処理の使用

テーブル

CData Cloud - SAP Concur テーブル

Attendees

テーブル固有の情報

Select

Insert

Update

Delete

Columns

AttendeeTypes

テーブル固有の情報

Select

Insert

Update

Delete

Columns

BudgetCategories

Table Specific Information

Select

Insert

Update

Delete

Columns

Entries

テーブル固有の情報

Select

Insert

Update

Delete

Columns

EntryAttendeeAssociations

テーブル固有の情報

Select

Insert

Update

Delete

Columns

FiscalYears

Table Specific Information

Select

Insert

Update

Delete

Columns

Pseudo-Columns

Invoice

Table Specific Information

Select

Columns

Itemizations

テーブル固有の情報

Select

Insert

Update

Delete