JDBC Driver for Xero

Build 23.0.8839

ビュー

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

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

CData JDBC Driver for Xero ビュー

Name Description
EmployeeBankAccounts Query the bank accounts for an Employee in a Xero organisation.
EmployeePayTemplateDeductions Query the pay template deduction lines for an Employee in a Xero organisation.
EmployeePayTemplateEarnings Query the pay template earnings lines for an Employee in a Xero organisation.
EmployeePayTemplateLeave Query the pay template leave lines for an Employee in a Xero organisation.
EmployeePayTemplateReimbursements Query the pay template reimbursement lines for an Employee in a Xero organisation.
EmployeePayTemplateSupers Query the pay template super lines for an Employee in a Xero organisation.
LeaveBalances Query the Leave Balance for an Employee in a Xero organisation.
PaySlipLeaveEarnings Query payslip leave earnings line-items for a Xero organisation.
PaySlips Query payslips for a Xero organisation.
Tenants Query the list of organisations connected to your Xero account.

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