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

Table Specific Information

Select

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

For example, the add-in 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