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 driver uses the SAP Concur APIs to process filters that refer to DocType, DocId, IgnoreDocumentStatus, and SystemId. The driver processes other filters client-side within the driver.

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