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 FinancialTransactionsTO:
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. |