ODBC Driver for SAP Concur

Build 23.0.8839

Allocations

Lists all allocations per entry or report.

テーブル固有の情報

Select

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

例えば、本製品 は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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839