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 provider 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 |