JDBC Driver for Xero

Build 22.0.8462

PaySlipSuperannuations

Query payslip superannuation line-items for a Xero organisation.

Table Specific Information

Queries

Equal operator

The equal operator is supported on the server side:

SELECT * FROM PaySlipTaxeSuperannuations WHERE PayslipID ='218db321-b72e-4aa1-9067-477d63705f95' 

IN operator

The IN operator is supported on the client side:

SELECT * FROM PaySlipSuperAnnuations WHERE PayslipID IN ('1843c739-aa8b-4d58-956a-3e097708cd84','218db321-b72e-4aa1-9067-477d63705f95') 

Columns

Name Type Filterable Description
Id [KEY] String The earnings line-item combined with the unique Xero identifier of the payslip
PayslipID String The unique identifier of the payslip. This field is assigned by Xero.
EmployeeID String The unique identifier of the payslip's employee.
SuperannuationLine_SuperMembershipId String The unique identifier of the line-item's super fund.
SuperannuationLine_ContributionType String The super contribution type
SuperannuationLine_CalculationType String The super calculation type
SuperannuationLine_MinimumMonthlyEarnings Decimal The super minimum monthly earnings
SuperannuationLine_ExpenseAccountCode String The super expense account code
SuperannuationLine_LiabilityAccountCode String The super liability account code
SuperannuationLine_PaymentDateForThisPeriod Date The super payment date for this period
SuperannuationLine_Percentage Double The super percentage
SuperannuationLine_Amount Decimal The super amount
TenantId String The ID of the tenant to query instead of the connection tenant

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462