The request returns a list of financial documents that are ready to be processed. The request can include parameters to limit the results.

Table Specific Information

Select

The add-in uses the SAP Concur APIs to process filters that refer to DocType, DocId, IgnoreDocumentStatus, and SystemId. 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 FinancialTransactions WHERE DocType = 'expense'
SELECT * FROM FinancialTransactions WHERE DocType = 'expense' AND DocId = 'some doc id'
SELECT * FROM FinancialTransactions WHERE DocType = 'expense' AND IgnoreDocumentStatus = 'yes'
SELECT * FROM FinancialTransactions WHERE DocType = 'expense' AND SystemId = 'some system id'

Note DocType is always required by the API. If not specified the provider will transform:

SELECT * FROM FinancialTransactions

SELECT * FROM FinancialTransactions WHERE DocType IN ('expense','invoice','cashadvance','payroll','requestobligation','reportobligation')

To avoid performance issues always apply the DocType filter.

Columns