JDBC Driver for SAP Concur

Build 23.0.8839

ビュー

ビューは、データを示すという点でテーブルに似ていますが、ビューは読み取り専用です。

クエリは、ビューに対して通常のテーブルと同様に実行することができます。

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.

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