ODBC Driver for Xero

Build 22.0.8479

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 ReadOnly Filterable Description
Id [KEY] String True

The earnings line-item combined with the unique Xero identifier of the payslip

PayslipID String True

The unique identifier of the payslip. This field is assigned by Xero.

EmployeeID String True

The unique identifier of the payslip's employee.

SuperannuationLine_SuperMembershipId String False

The unique identifier of the line-item's super fund.

SuperannuationLine_ContributionType String False

The super contribution type

SuperannuationLine_CalculationType String False

The super calculation type

SuperannuationLine_MinimumMonthlyEarnings Decimal False

The super minimum monthly earnings

SuperannuationLine_ExpenseAccountCode String False

The super expense account code

SuperannuationLine_LiabilityAccountCode String False

The super liability account code

SuperannuationLine_PaymentDateForThisPeriod Date False

The super payment date for this period

SuperannuationLine_Percentage Double False

The super percentage

SuperannuationLine_Amount Decimal False

The super amount

TenantId String False

The ID of the tenant to query instead of the connection tenant

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