JDBC Driver for SAP Concur

Build 24.0.9062

FinancialTransactions

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

For example, the 本製品 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
TO:
SELECT * FROM FinancialTransactions WHERE DocType IN ('expense','invoice','cashadvance','payroll','requestobligation','reportobligation')

To avoid performance issues always apply the DocType filter.

Columns

Name Type Description
Id [KEY] String The unique identifier for the document.
DocType String Transaction type
CompanyId String Unique identifier for the company in SAP Concur. Maximum 32 characters.
EntityId String Unique identifier for the entity in SAP Concur. Maximum 32 characters.
CompanyUuid String UUID for the company in SAP Concur. Maximum 36 characters.
ErpSystemId String The external System ID that processed the document. Maximum 50 characters.
Document String The JSON financial document.
DocStatus String The financial document status. Supported values: READY, ACKNOWLEDGED, POSTING_CONFIRMED_SUCCESS, POSTING_CONFIRMED_FAILURE.
DocId String The transaction unique identifier, it could be expense report ID, payment request ID or cash advance ID. If specified, a single document that matches docId is returned.
IgnoreDocumentStatus String Ignores the financial documents status. If yes, a document is returned regardless of status. If no, only documents that have not been acknowledged/confirmed are returned. Supported values: yes, no.
SystemId String The external system ID that processed the document. Maximum 50 characters.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062