ビュー
ビューは、データを示すという点でテーブルに似ていますが、ビューは読み取り専用です。
クエリは、ビューに対して通常のテーブルと同様に実行することができます。
CData JDBC Driver for SAP Concur ビュー
Name | Description |
Allocations | Lists all allocations per entry or report. |
CompanyCardTransactions | Retrieves corporate or credit card charges that are available for use in expense reports. |
DigitalTaxInvoices | Gets all digital tax invoices that can be validated by the user based on the search criteria. |
ExpenseDelegators | Retrieves the list of users that have granted delegate permissions to you. |
ExpenseDetails | Read the details of an expense by specifying an ExpenseId. |
ExpenseGroupConfigurationAttendeeTypes | Lists the Attendee Types of the Expense Group Configurations. |
ExpenseGroupConfigurationPaymentTypes | Lists the payment types of the Expense Group Configurations. |
ExpenseGroupConfigurationPolicies | Lists the policies of Expense Group Configurations. |
ExpenseGroupConfigurationPolicyExpenseTypes | Lists the expense types for the Expense Group Configuration Policies. |
ExpenseGroupConfigurations | Lists the configurations of expense groups. |
Expenses | Read the expenses that belong to a specific expense report and modify an expense on an existing expense report. |
FormFields | Query expense form fields. |
Forms | Query expense forms. |
Invoice | Gets all relevant information (Payment Request Header, Payment Request Line Item and Payment Request Allocation) of a Payment Request. |
ListItemsV4 | Lists list items based on the search criteria. |
ListV4 | Lists list items based on the search criteria. |
Locations | Retrieve details of locations that are used by Concur and that are valid at the company of the user. |
Notifications | Lists notifications that have failed. |
Opportunities | Gets opportunities for a specified trip or for all trips that fall within a date range. |
PaymentBatches | Lists all the payment batches. |
PaymentRequestDigests | A payment request digest is a collection of summarized payment requests to invoice vendors. |
ReportComments | Read the comments entered on the expense report header, or expenses of an existing expense report. |
ReportDetails | Retrieves the full set of information for the report. |
ReportDetailsExpenseEntry | Lists all expense entries |
ReportDetailsExpenseEntryItemization | Lists all itemizations of an expense entry |
ReportDetailsExpenseEntryItemizationAllocation | Lists all allocations of an itemization |
ReportDetailsExpenseEntryItemizationAllocationJournalEntry | Lists all allocations of an itemization |
ReportDetailsExpenseEntryItemizationAllocationVATData | Lists all allocations of an itemization |
ReportDetailsExpenseEntryItemizationAttendee | Lists all allocations of an itemization |
Suppliers | Lists Suppliers based on the search criteria. |
TripBookingPassengers | Lists the passengers for a trip booking. |
TripBookings | Query all the bookings for a trip. |
TripBookingSegmentCharges | Query all the charges for a trip. |
TripBookingSegments | Query all the bookings for a trip. |
TripBookingSegmentSeats | Query all the seats for a trip. |
Trips | Query all the trips. |
Users | Lists user data based on the search criteria. |
UsersDetails | Lists all users based on the search criteria. |
UsersV4 | Read user's core identity profile. |