ODBC Driver for SAP Concur

Build 23.0.8791

ListItems

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

テーブル固有の情報

Select

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

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

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