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

Table Specific Information

Select

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

For example, the connector offloads 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