Tables
The driver models the data in SAP Concur as a list of tables in a relational database that can be queried using standard SQL statements.
CData JDBC Driver for SAP Concur Tables
Name | Description |
Attendees | Create, update, delete, and query all attendees owned by the specified user. |
AttendeeTypes | Create, update, delete, and query all active attendee types for the company. |
BudgetCategories | Retrieve a list of all budget categories. |
Entries | Create, update, delete, and query all expense entries owned by the user. |
EntryAttendeeAssociations | Create, update, delete, and query all entry-attendee associations owned by the user. These are the associations between an expense entry and an attendee. |
FiscalYears | Retrieve a list of all fiscal years. |
Invoice | Gets all relevant information (Payment Request Header, Payment Request Line Item and Payment Request Allocation) of a Payment Request. |
Itemizations | Create, update, delete, and query all expense itemizations owned by the user. |
Items | Lists list items based on the search criteria. |
ListItems | Lists list items based on the search criteria. |
Lists | The driver uses the SAP Concur APIs to view your configured lists within SAP Concur products. |
ReceiptImages | Create, update, delete, and query all receipt Ids owned by the user. |
Reports | Create, update, delete, and query all reports owned by the user. |
UsersV4 | Read the user's core identity profile. |