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

Table Specific Information

Select

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

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

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

Insert

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

Update

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

Delete

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

DELETE FROM ReceiptImages WHERE Id = '12345'

Columns

Pseudo-Columns

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