JDBC Driver for Xero

Build 23.0.8839

PaySlipSuperannuations

Query payslip superannuation line-items for a Xero organisation.

Table Specific Information

This table supports the following operators server-side: =,IN

INSERT

To insert a single row, set the required fields. The driver adds a new superannuation line to the payslip.

  INSERT INTO PaySlipSuperannuations (PayslipID, SuperannuationLine_SuperMembershipId, SuperannuationLine_ContributionType, SuperannuationLine_CalculationType, SuperannuationLine_Amount, SuperannuationLine_ExpenseAccountCode, SuperannuationLine_LiabilityAccountCode, SuperannuationLine_Percentage, SuperannuationLine_PaymentDateForThisPeriod) VALUES ('ea5aaaa7-c330-41d8-bfae-98ddc1f37680', '045ef1ba-1399-4b49-b324-8c8b70d05607', 'SGC', 'PERCENTAGEOFEARNINGS', 9, '478', '826', 9.0, '2023-06-28')

UPDATE

You can update any field that is not read-only.

Note: UPDATE operations will count as two operations against the Xero API. One is required to retrieve the existing record, and another to update the record with new data.

UPDATE PaySlipSuperannuations SET SuperannuationLine_Percentage = 10 WHERE Id = '2|ea5aaaa7-c330-41d8-bfae-98ddc1f37680'

DELETE

Supply the Id to delete payslip superannuation lines.

 DELETE FROM PaySlipSuperannuations WHERE Id = '2|ea5aaaa7-c330-41d8-bfae-98ddc1f37680'

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 False

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) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839