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 connector 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')

Superannuation lines can also be added in bulk by specifying multiple items in the VALUES clause.

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'),
	('ea5aaaa7-c330-41d8-bfae-98ddc1f37680', '045ef1ba-1399-4b49-b324-8c8b70d05607', 'SGC', 'PERCENTAGEOFEARNINGS', 12, '512', '904', 11.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