はじめに

このページでは、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 はサーバーの証明書をシステムの信頼できる証明書ストアと照合してSSL / TLS のネゴシエーションを試みます。

別の証明書を指定するには、利用可能なフォーマットについてSSLServerCert プロパティを参照してください。

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

Firewall またはProxy 経由の接続

HTTP プロキシ

Windows のシステムプロキシ経由の接続では、接続プロパティを追加で設定する必要はありません。他のプロキシに接続するには、ProxyAutoDetect をfalse に設定します。

さらにHTTP プロキシへの認証には、ProxyServer とProxyPort に加えてProxyAuthScheme、ProxyUser、およびProxyPassword を設定します。

その他のプロキシ

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

プロキシベースのファイヤーウォールを使用するには、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.
Entries	Create, update, delete, and query all expense entries owned by the user.
EntryAttendeeAssociations	Create, update, delete, and query all entry-attendee associations owned by the user. These are the associations between an expense entry and an attendee.
Itemizations	Create, update, delete, and query all expense itemizations owned by the user.
ListItems	Create, update, delete, and query all list items based on the search criteria.
Lists	Create, update, delete, and query all lists based on the search criteria.
ReceiptImages	Create, update, delete, and query all receipt Ids owned by the user.
Reports	Create, update, delete, and query all reports owned by the user.

Attendees

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

テーブル固有の情報

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

Pseudo-Columns

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


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

AttendeeTypes

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

テーブル固有の情報

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

Entries

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

テーブル固有の情報

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

Pseudo-Columns

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


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

EntryAttendeeAssociations

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

テーブル固有の情報

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

Pseudo-Columns

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


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

Itemizations

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

テーブル固有の情報

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

Pseudo-Columns

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


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

ListItems

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

テーブル固有の情報

Select

Cloud はSAP Concur API を使用して、Id フィルタ、またはListId、Name、ParentId、Level1Code - Level10Code の任意の組み合わせのフィルタを処理します。Cloud はクライアント側でCloud 内で他のフィルタを処理します。

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

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

Insert

リストアイテムを挿入するには、次のカラムが必要です：ListId、Name、およびLevel1Code。

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

Update

UPDATE は、リストアイテムではサポートされていません。

Delete

削除は、リストアイテムではサポートされていません。

Columns


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

Lists

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

テーブル固有の情報

Select

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

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

SELECT * FROM Lists WHERE Id = '123456'

Insert

リストアイテムを挿入するには、次のカラムが必要です：Name、DisplayCodeFirst、IsVendorList、およびSearchCriteriaCode。

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

Update

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

Delete

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

Columns


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

ReceiptImages

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

テーブル固有の情報

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.

Pseudo-Columns

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


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

Reports

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

テーブル固有の情報

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

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

ビュー

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

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

CData Cloud - SAP Concur ビュー


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

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

Pseudo-Columns

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


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

CompanyCardTransactions

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

テーブル固有の情報

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.

Pseudo-Columns

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


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

ExpenseDelegators

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

テーブル固有の情報

Select

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

Columns


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

ExpenseDetails

Read the details of an 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		The unique identifier for the expense.
AllocationSetId	String		The identifier of the allocation set associated with the expense. Allocations which 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		The unique identifier of the report that is being read.
UserId	String		The unique identifier of the SAP Concur user. Query the Identity table to retrieve this value.
ContextType	String		The access level of the SAP Concur user, which determines the form fields they can view/modify. Supported values: TRAVELER, PROXY. Default value is TRAVELER.

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		The unique identifier of the Expense Group Configuration.
Name	String		The name of the attendee type.

Pseudo-Columns

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


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

ExpenseGroupConfigurationPaymentTypes

Lists the payment types of the Expense Group Configurations.

テーブル固有の情報

Select

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

Columns


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

Pseudo-Columns

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


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

ExpenseGroupConfigurationPolicies

Lists the policies of Expense Group Configurations.

テーブル固有の情報

Select

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

Columns


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

Pseudo-Columns

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


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

ExpenseGroupConfigurationPolicyExpenseTypes

Lists the expense types for the Expense Group Configuration Policies.

テーブル固有の情報

Select

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

Columns


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

Pseudo-Columns

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


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

ExpenseGroupConfigurations

Lists the configurations of expense groups.

テーブル固有の情報

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		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

Read the expenses that belong to a specific expense report and modify 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'

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 which belong to the same set were 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		The unique identifier of the report that is being read.
UserId	String		The unique identifier of the SAP Concur user. Query the Identity table to retrieve this value.
ContextType	String		The access level of the SAP Concur user, which determines the form fields they can view/modify. Supported values: TRAVELER, PROXY. Default value is TRAVELER.

FormFields

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

テーブル固有の情報

Select

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

Columns


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

Invoice

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

Table Specific Information

Select

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

SELECT * FROM Invoice WHERE Id = 'sampleInvoiceId'

Columns


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

ListItemsV4

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.

Searching list items by listId retrieves the first level of list items. In order to get all children recursively, you must set the RecursionDepth connection property to the desired depth of list. This retrieves a list that includes children up to the specified depth automaticaly.

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

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

Columns


Name	Type	References	Description
Id [KEY]	String		The unique identifier of the list item.
Code	String		List item long code.
ShortCode	String		List item short code.
Value	String		List item value.
ParentId	String		The unique identifier of the parent list item.
ListId	String		The unique identifier of the list that contains the list item.
Level	Int		Level of the list item within the list.
HasChildren	Boolean		If true, the list item has children in this particular list.
Lists	String		The unique identifiers of the lists that contains the list item. The list item may exist under one or more lists.
IsDeleted	Boolean		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.

ListV4

Lists list items based on the search criteria.

Table Specific Information

Select

This API is only available to partners who have been granted access by the SAP Concur team.

Columns


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

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

Pseudo-Columns

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


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

Notifications

Lists 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	Datetime		The URL that needs to be called to delete a failed notification.
ObjectType	Datetime		The type of object that triggered the notification.
ObjectURI	Datetime		The type of the event.

Opportunities

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

テーブル固有の情報

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	String		The trip id of the associated itinerary
EndCityCode	String		The city code of the destination city where the opportunity is offered
EndDateLocal	Datetime		The local end date of the location where the opportunity is offered
EndPostalCode	String		The postal code of the destination location where the opportunity is offered
IsActive	Bool		Indicates that the opportunity is currently active
StartCityCode	String		The city code of the originating city where the opportunity is offered
StartDateLocal	Datetime		The local start date of the location where the opportunity is offered
StartPostalCode	String		The postal code of the originating location where the opportunity is offered
Type	String		The type of opportunity
URI	String		The URI to the resource.

Pseudo-Columns

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


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

PaymentBatches

Lists all the payment batches.

テーブル固有の情報

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:

approvalStatus
paymentStatus
vendorInvoiceNumber
createDateBefore
createDateAfter
userDefinedDateBefore
userDefinedDateAfter
submitDateBefore
submitDateAfter
paidDateBefore
paidDateAfter

For example:

SELECT * FROM PaymentRequestDigests WHERE approvalStatus = 'sampleApprovalStatus'

Columns


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

ReportComments

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

Table Specific Information

Select

The 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		The unique identifier of the expense.
IsAuditorComment	Boolean		If true, this attribute represents whether this comment has been authored by an auditor.
IsLatest	Boolean		If true, this attribute represents the latest comment by the user.
StepInstanceId	String		The unique identifier of the step instance.
CreatedForEmployeeId	String		The unique identifier of the employee the comment was created on behalf of.
CreatedForEmployeeFirstName	String		The first name of the employee the comment was created on behalf of.
CreatedForEmployeeLastName	String		The last name of the employee the comment was created on behalf of.
CreatedForEmployeeMiddleInitial	String		The middle initial of the employee the comment was created on behalf of.
ReportId	String		The unique identifier of the report that is being read.
UserId	String		The unique identifier of the SAP Concur user. Query the Identity table to retrieve this value.

Pseudo-Columns

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


Name	Type	Description
ContextType	String		The access level of the SAP Concur user, which determines the form fields they can view/modify. Supported values: TRAVELER, PROXY. Default value is TRAVELER.

ReportDetails

Retrieves the full set of information for the report.

Columns


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

ReportDetailsExpenseEntry

Lists all expense entries

Columns


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

ReportDetailsExpenseEntryItemization

Lists all itemizations of an expense entry

Columns


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

ReportDetailsExpenseEntryItemizationAllocation

Lists all allocations of an itemization

Columns


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

ReportDetailsExpenseEntryItemizationAllocationJournalEntry

Lists all allocations of an itemization

Columns


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

ReportDetailsExpenseEntryItemizationAllocationVATData

Lists all allocations of an itemization

Columns


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

ReportDetailsExpenseEntryItemizationAttendee

Lists all allocations of an itemization

Columns


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

Suppliers

Lists Suppliers based on the search criteria.

テーブル固有の情報

Select

このテーブルをクエリするには、WHERE 句にId または次のカラムセットのいずれかを含める必要があります。

Name_p
Phone_p
Address_p、City_p、およびState_p

Cloud はSAP Concur API を使用して、Id、またはName_p、Address_p、Address2_p、City_p、State_p、Zip_p、Country_p、Phone_p、McCode_p、TaxId_p、MerchantType_p、MerchantID_p、IataCode_p、Relevance_p の任意の組み合わせのどちらかによりフィルタします。Cloud はクライアント側でCloud 内で他のフィルタを処理します。

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

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

Columns


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

Pseudo-Columns

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


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

TripBookingPassengers

Lists the passengers for a trip booking.

テーブル固有の情報

Select

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

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

SELECT * FROM TripBookingPassengers WHERE TripId = '123456'

Columns


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

TripBookings

Query all the bookings for a trip.

テーブル固有の情報

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		The id of the trip.
BookingOwner	String		The id of the trip.
Source	String		The name of the trip.
BookingSource	String		The record locator of the trip.
BookedDate	Datetime		The first name of the traveler.
CreatedDate	Datetime		The last name of the traveler.
ModifiedDate	Datetime		A comma separated list of passengers.
IsCanceled	Boolean		The status of the trip デフォルト値はfalseです。

Pseudo-Columns

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


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

TripBookingSegmentCharges

Query all the charges for a trip.

テーブル固有の情報

Select

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

SELECT * FROM TripBookingSegmentCharges WHERE TripId = 'sampleTripId'

Columns


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

TripBookingSegments

Query all the bookings for a trip.

テーブル固有の情報

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	String		The trip leg ID.
CheckinTime	String		The check in time for the hotel booking.
CheckoutTime	String		The check out time for the hotel booking.
HotelPropertyId	String		The hotel's property ID.
ParkingLocationId	String		The location of the parking booking.
NumRooms	Integer		The number of rooms the booking is for.
RoomDescription	String		The room description for the booking
RoomType	String		The room type for the booking.
RestaurantId	String		The booking vendor's restaurant ID.
AirCondition	String		The character code that indicates if car has air conditioner. R for AC, N for No AC
Body	String		The character code to indicate how many passengers the car can seat.
Class	String		Character code to indicate the class of the car e.g. if it is economy, full size, compact, etc. Varies by Vendor.
DiscountCode	String		The discount code for the booking.
DropoffCollectionAddress1	String		The AddressLine1 for the dropoff address when the rental service offers dropoff.
DropoffCollectionAddressType	String		The type of the dropoff address.
DropoffCollectionCategory	String		Thecategory of the dropoff collection.
DropoffCollectionCity	String		City for the dropoff address when the rental service offers dropoff.
DropoffCollectionCityCode	String		The IATA airport code for the dropoff address when the rental service offers dropoff.
DropoffCollectionCountry	String		The country for the dropoff address when the rental service offers dropoff.
DropoffCollectionLatitude	String		The latitude for the dropoff address when the rental service offers dropoff.
DropoffCollectionLongitude	String		The longitude for the dropoff address when the rental service offers dropoff.
DropoffCollectionNumber	String		the dropoff location number.
DropoffCollectionPhoneNumber	String		The phone number for the dropoff address when the rental service offers dropoff.
DropoffCollectionPostalCode	String		The postal code for the dropoff address when the rental service offers dropoff.
DropoffCollectionState	String		The state for the dropoff address when the rental service offers dropoff.
EndAddress	String		The ending address for the booking.
EndAddress2	String		The ending address for the booking.
EndCity	String		The ending address for the booking.
EndCloseTime	String		The closing time for the dropoff location.
EndCountry	String		The ending address for the booking.
EndLocation	String		The dropoff location.
EndOpenTime	String		The opening time of the dropoff location.
EndPhoneNumber	String		The phone number of the dropoff location.
EndPostalCode	String		The ending address for the booking.
EndState	String		The ending address for the booking.
FrequentTravelerId	String		The loyalty program ID for the user.
IsUpgradeAllowed	String		Whether the booking can be upgraded.
NumCars	Integer		The number of cars rented.
NumPersons	Integer		The number of people including the driver that the rental is for.
NumberOfHours	Integer		The number of hours of the booking.
PickupDeliveryAddress1	String		The AddressLine1 for the pickup address when the rental service offers pickup.
PickupDeliveryAddressType	String		The type of the pickup address when the rental service offers pickup.
PickupDeliveryCategory	String		The category of the pickup address when the rental service offers pickup.
PickupDeliveryCity	String		The city for the pickup address when the rental service offers pickup.
PickupDeliveryCityCode	String		The IATA airport code for the pickup address when the rental service offers pickup.
PickupDeliveryCountry	String		The country for the pickup address when the rental service offers pickup.
PickupDeliveryLatitude	String		The latitude for the pickup address when the rental service offers pickup.
PickupDeliveryLongitude	String		The longitude for the pickup address when the rental service offers pickup.
PickupDeliveryNumber	String		The number of the pickup delivery.
PickupDeliveryPhoneNumber	String		The phone number for the pickup address when the rental service offers pickup.
PickupDeliveryPostalCode	String		The postal code for the pickup address when the rental service offers pickup.
PickupDeliveryState	String		The state for the pickup address when the rental service offers pickup.
SpecialEquipment	String		Any special equipment required by the renter.
SpecialInstructions	String		Additional instructions regarding the booking.
MeetingInstructions	String		The instructions for the meeting location of the booking.
PickupInstructions	String		Instructions regarding the booking.
StartAddress	String		The starting address of the booking.
StartAddress2	String		The starting address of the booking.
StartCity	String		The starting city of the booking.
StartCloseTime	String		The closing time for the pickup location.
StartCountry	String		The starting country of the booking.
StartLocation	String		The starting location of the booking.
StartOpenTime	String		The opening time for the pickup location.
StartPostalCode	String		The starting postal code for the booking.
StartState	String		The starting state for the booking.
Transmission	String		The character code that indicates if the car has auto-transmission. A for Auto, M for Manual.
UpgradedDateTime	Datetime		The date and time the booking was upgraded.
AircraftCode	String		The code for the aircraft type.
Bags	String		The number of bags included in the booking.
Cabin	String		The cabin for the booking.
Amenities	String		The amenities for the seat.
TrainNumber	String		The number for the booked train.
TrainTypeCode	String		The code for the type of train used in the booking.
TrainTypeName	String		The name of the type of train used in the booking.
WagonNumber	String		The number of the wagon the seat is on.
TransportMode	String		The transport mode of the booking.
CarbonEmissionLbs	String		The pounds of carbon emission for this booking.
CarbonModel	String		The model used to calculate the carbon emissions.
CheckedBaggage	Boolean		Whether the booking includes checked baggage.
Duration	String		The duration of the booked flight.
ETicket	String		Whether the booking has an e-ticket.
IsPersonal	Boolean		Whether the segment is for personal travel.
IsOpenSegment	Boolean		Whether the segment is open.
IsPreferredVendor	Boolean		If the airline is marked as a preferred property by the company.
IsUpgradeAllowed	Boolean		Whether the booking can be upgraded.
Meals	String		The meals included in the booking.
Miles	String		The number of miles included in the booking.
OpenSegment	String		Additional information about the open segment.
OperatedByFlightNumber	String		Flight Number provided by the airline operating the flight on behalf of the booked airline.
OperatedByTrainNumber	String		The train identifier of the operating vendor of the booked trip.
OperatedByVendor	String		The operated by vendor for the booking.
OperatedByVendorName	String		The name of the airline operating the flight on behalf of the booked airline.
RouteRestrictCode	String		The code to restrict the route of the booking.
StartPlatform	String		The starting platform location of the booking.
StartRailStation	String		The code of the starting station of the booking.
StartRailStationName	String		The name of the starting station of the booking.
Services	String		The services included in the booking.
HadDeposit	Boolean		Whether the booking had a deposit.
ModificationCode	String		The code for the modification to the booking.
PartnerMembershipId	String		The membership ID of the partner associated with the booking.
PassiveType	String		The type of the booking.
PassiveCityCode	String		The passive city code of the booking.
VendorFlags	String		Semi-colon-delimited list of flags for free hotel service flags. E.g. free breakfast (FB), internet (FI), Parking (FP), etc. If they were all present they can be concatenated as - FB;FI;FP;

TripBookingSegmentSeats

Query all the seats for a trip.

テーブル固有の情報

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		The id of the trip.
BookingRecordLocator [KEY]	String		The record locator of the booking.
SegmentType [KEY]	String		The type of the segment.
PassengerRph	String		Which passenger the seat is assigned to.
Amenities	String		The amenities for the seat.
BerthPosition	String		The berth location of the seat.
Deck	String		Which deck the seat is on.
FacingForward	String		Whether the seat is facing forward.
FareSpaceComfort	String		The space around the seat.
SeatNumber	String		The number of the seat.
SeatPosition	String		The location of the seat.
SpaceType	String		The type of space around the seat.
Status	String		The status of the seat booking.
WagonNumber	String		The number of the wagon the seat is on.
WagonType	String		The type of wagon the seat is on.

Trips

Query all the trips.

テーブル固有の情報

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	Datetime		The start date of the trip.
TripEndDate	Datetime		The end date of the trip.
ModifiedDate	Datetime		The date when the trip was last modified.
RecordLocator	String		The record locator of the trip.
LoginId	String		The login ID of the user who owns the trip. The user must have the Web Services Admin role to use this parameter.
IsCanceled	Boolean		The status of the trip デフォルト値はfalseです。

Pseudo-Columns

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


Name	Type	Description
CreatedAfterDate	Datetime		Date for when the trip was created. The query string will return trips created on or after this date.
CreatedBeforeDate	Datetime		Date for when the trip was created. The query string will return trips created on or before this date.
BookingType	String		The trip includes at least one booking of this type. 使用できる値は次のとおりです。Air, Car, Dining, Hotel, Parking, Rail, Ride
IncludeVirtualTrip	Boolean		Show virtual trips. Virtual trips are segments booked offline through the Travel Request product.
IncludeGuestBookings	Boolean		Indicates whether to include guest bookings.

Users

Lists user data based on the search criteria.

テーブル固有の情報

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		The login ID of the user.
MiddleName	String		The middle name of the user.
Active	Bool		Indicates whether the user is currently active or not.
CellPhoneNumber	String		The cell phone number of the user.
FirstName	String		The first name of the user.
LastName	String		The last name of the user.
OrganizationUnit	String		The organization unit of the user.
PrimaryEmail	String		The primary email of the user.
URI	String		The URI to the resource.

UsersDetails

Lists all users based on the search criteria.

Table Specific Information

Select

By default, the provider gets the list of active users and retuns the details for each one of them.

SELECT * FROM [UsersDetails]

is transformed to:

SELECT * FROM [UsersDetails] WHERE [LoginId] IN (SELECT [Users].[LoginID] FROM [Users] WHERE [Active] = 'true')

Columns


Name	Type	References	Description
ID [KEY]	String		The unique identifier of the resource.
LoginID [KEY]	String		The user's login ID.
Active	Bool		Whether the user is currently active.
FirstName	String		The user's first name.
LastName	String		The user's last name.
MiddleName	String		The middle name of the user.
EmailAddress	String		The user's email address.
EmployeeID	String		The employee ID of the user.
LedgerName	String		The user's assigned account code ledger.
LocaleName	String		The user's language locale code.
OrgUnit1	String		Organization Unit
OrgUnit2	String		Organization Unit
OrgUnit3	String		Organization Unit
OrgUnit4	String		Organization Unit
OrgUnit5	String		Organization Unit
OrgUnit6	String		Organization Unit
Custom1	String		CustomField
Custom2	String		CustomField
Custom3	String		CustomField
Custom4	String		CustomField
Custom5	String		CustomField
Custom6	String		CustomField
Custom7	String		CustomField
Custom8	String		CustomField
Custom9	String		CustomField
Custom10	String		CustomField
Custom11	String		CustomField
Custom12	String		CustomField
Custom13	String		CustomField
Custom14	String		CustomField
Custom15	String		CustomField
Custom16	String		CustomField
Custom17	String		CustomField
Custom18	String		CustomField
Custom19	String		CustomField
Custom20	String		CustomField
Custom21	String		CustomField
CountryCode	String		The user's two-digit country code..
CashAdvanceAccountCode	String		The user's account code for cash advances.
CurrencyCode	String		The user's three character reimbursement currency.
CountrySubCode	String		The user's two-digit country code and two-digit state or province code.
ExpenseUser	Bool		Whether the user has access to Expense.
ExpenseApprover	Bool		Whether the user is an Expense approver.
TripUser	Bool		Whether the user has access to Travel. Format: Y/N.
InvoiceUser	Bool		Whether the user has access to Invoice. Format: Y/N.
InvoiceApprover	Bool		Whether the user is an Invoice approver. Format: Y/N.
ExpenseApproverEmployeeID	String		The employee ID of the user's Expense approver.
IsTestUser	Bool		Whether the user is a test user. Format: Y/N.

UsersV4

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

ストアドプロシージャ

ストアドプロシージャはファンクションライクなインターフェースで、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.
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.
UpdateTripApprovalStatus	Update the approval status for the specified trip.
UpdateTripFromFile	Use an XML file to update the specified trip.

CancelTrip

Cancel the specified trip.

Input


Name	Type	Required	Description
TripId	String	True	The Id of the trip you want to delete.
LoginId	String	False	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	Required	Description
Index	String	True	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	True	The Id of the report you want to create an exception for.
ObjectType	String	True	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	False	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	True	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.

CreateTripFromFile

Create a new trip from an XML file.

Input


Name	Type	Required	Description
FileLocation	String	False	The location of your trip XML file.
LoginId	String	False	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	Required	Description
WorkflowId	String	True	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	True	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	True	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	Required	Description
ReportId	String	True	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	Required	Description
NotificationType	String	False	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	Required	Description
NotificationType	String	False	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.

UpdateTripApprovalStatus

Update the approval status for the specified trip.

Input


Name	Type	Required	Description
TransactionId	String	True	A value used to identify request and response pairs. This value can contain any alphanumeric string that does not contain special characters.
Version	String	True	The version of the web service. デフォルト値は1.0です。
ItinLocator	String	False	The Itinerary Services Record Locator (also known as Itin Locator or Trip Locator). NOT the GDS record locator. If value of the ItinLocator is unknown, the RecordLocator element should be passed instead.
RecordLocator	String	False	The GDS record locator. Should be passed only if the ItinLocator is unknown.
ApproverLogin	String	True	The login ID of the Travel approver.
Action	String	True	The workflow action to take. Supported values are approve, reject. 使用できる値は次のとおりです。approve, reject

Result Set Columns


Name	Type	Description
Success	Boolean	Indicates if the status of the trip was updated successfully.

UpdateTripFromFile

Use an XML file to update the specified trip.

Input


Name	Type	Required	Description
TripId	String	True	The Id of the trip you want to update.
FileLocation	String	False	The location of your trip XML file.
LoginId	String	False	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

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

このテーブルをクエリする際は、config 接続文字列を使用する必要があります。

jdbc:cdata:sapconcur:config:

この接続文字列を使用すると、有効な接続がなくてもこのテーブルをクエリできます。

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

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、またはバッチ内の更新が失敗した場合のエラーメッセージ。

接続文字列オプション

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

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.
UseNewOAuthVersion	A boolean indicating wether the new authentication version should be used.
ConcurInstanceURL	The server URL to use. The new server URLs are backwards compatible with the legacy authentication methods, so set this only if necessary. For example https://concursolutions.com for some production accounts and https://implementation.concursolutions.com for sandbox accounts.

Connection

プロパティ	説明
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。
OAuthClientSecret	OAuth 認証サーバーにアプリケーションを登録する場合に割り当てられたクライアントシークレット。
GeoLocation	The GeoLocation of the account instance.
OAuthGrantType	OAuth フローのグラント種別。

SSL

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

Logging

プロパティ	説明
Verbosity	ログファイルの記述をどの程度の詳細さで記載するかを決定するverbosity レベル。

Schema

プロパティ	説明
BrowsableSchemas	このプロパティは、使用可能なスキーマのサブセットにレポートされるスキーマを制限します。例えば、BrowsableSchemas=SchemaA,SchemaB,SchemaC です。

Miscellaneous

プロパティ	説明
ReportLimit	Limit the API requests sent to the server.
MaxRows	クエリで集計またはGROUP BY を使用しない場合に返される行数を制限します。これはLIMIT 句よりも優先されます。
Pagesize	SAP Concur から返されるページあたりの結果の最大数。
PseudoColumns	このプロパティは、テーブルのカラムとして疑似カラムが含まれているかどうかを示します。
Timeout	タイムアウトエラーがスローされ、処理をキャンセルするまでの秒数。

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.
UseNewOAuthVersion	A boolean indicating wether the new authentication version should be used.
ConcurInstanceURL	The server URL to use. The new server URLs are backwards compatible with the legacy authentication methods, so set this only if necessary. For example https://concursolutions.com for some production accounts and https://implementation.concursolutions.com for sandbox accounts.

解説

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

Connection

このセクションでは、本プロバイダーの接続文字列で設定可能な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.

解説

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。
OAuthClientSecret	OAuth 認証サーバーにアプリケーションを登録する場合に割り当てられたクライアントシークレット。
GeoLocation	The GeoLocation of the account instance.
OAuthGrantType	OAuth フローのグラント種別。

解説

次のオプションが利用可能です：CODE,PASSWORD

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 レベル。

Verbosity

ログファイルの記述をどの程度の詳細さで記載するかを決定するverbosity レベル。

データ型

string

デフォルト値

"1"

解説

Verbosity レベルは、Cloud がLogfile にどの程度の詳細さで記載するかを決定します。1 から5 までのVerbosity レベルがサポートされています。より詳しい説明は、ログページに記載されています。

Schema

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

プロパティ	説明
BrowsableSchemas	このプロパティは、使用可能なスキーマのサブセットにレポートされるスキーマを制限します。例えば、BrowsableSchemas=SchemaA,SchemaB,SchemaC です。

BrowsableSchemas

このプロパティは、使用可能なスキーマのサブセットにレポートされるスキーマを制限します。例えば、BrowsableSchemas=SchemaA,SchemaB,SchemaC です。

データ型

string

デフォルト値

""

解説

スキーマをデータベースからリストすると、負荷がかかる可能性があります。接続文字列でスキーマのリストを提供すると、パフォーマンスが向上します。

Miscellaneous

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

プロパティ	説明
ReportLimit	Limit the API requests sent to the server.
MaxRows	クエリで集計またはGROUP BY を使用しない場合に返される行数を制限します。これはLIMIT 句よりも優先されます。
Pagesize	SAP Concur から返されるページあたりの結果の最大数。
PseudoColumns	このプロパティは、テーブルのカラムとして疑似カラムが含まれているかどうかを示します。
Timeout	タイムアウトエラーがスローされ、処理をキャンセルするまでの秒数。

ReportLimit

Limit the API requests sent to the server.

データ型

string

デフォルト値

"25"

解説

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

For the ReportDetails table, LIMIT will overwrite this value.

60

解説

Timeout が0に設定されている場合は、操作がタイムアウトしません。処理が正常に完了するか、エラー状態になるまで実行されます。

Timeout の有効期限が切れても処理が完了していない場合は、Cloud は例外をスローします。

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

Pseudo-Columns

AttendeeTypes

テーブル固有の情報

Select

Insert

Update

Delete

Columns

Entries

テーブル固有の情報

Select

Insert

Update

Delete

Columns

Pseudo-Columns

EntryAttendeeAssociations

テーブル固有の情報

Select

Insert

Update

Delete

Columns

Pseudo-Columns

Itemizations

テーブル固有の情報

Select

Insert

Update

Delete

Columns

Pseudo-Columns

ListItems

テーブル固有の情報

Select

Insert

Update

Delete

Columns

Lists

テーブル固有の情報

Select

Insert

Update

Delete

Columns