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

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