PaySlipSuperannuations
Manages payslip superannuation line items. Superannuation refers to the employer's contribution to an employee's retirement fund.
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 identifier that combines the specific payslip's unique Xero identifier with the earnings line details, helping to uniquely identify each line item within a payslip. | |
| PayslipID | String | False |
The unique identifier for a specific payslip, assigned by Xero. This identifier ensures each payslip is distinctly recognized and can be individually processed or queried in payroll systems. | |
| EmployeeID | String | True |
The unique identifier assigned to the employee associated with the payslip. This links the payslip to the employee, ensuring the payroll information is correctly attributed. | |
| SuperannuationLine_SuperMembershipId | String | False |
The unique identifier for the superannuation membership tied to this line item. It links the employee's superannuation details, including their super fund, to the respective payslip entry. | |
| SuperannuationLine_ContributionType | String | False |
The type of superannuation contribution for the employee, such as the mandatory super contribution or any additional contributions made by the employer. | |
| SuperannuationLine_CalculationType | String | False |
The method used to calculate the superannuation contribution, such as a percentage of the employee's earnings or a fixed amount based on predefined rules. | |
| SuperannuationLine_MinimumMonthlyEarnings | Decimal | False |
The minimum earnings threshold required for the employee to be eligible for superannuation contributions in a given month. This ensures that contributions are only made if the employee meets the earnings threshold. | |
| SuperannuationLine_ExpenseAccountCode | String | False |
The account code assigned to the superannuation expense. This code corresponds to the account in the chart of accounts where the superannuation contribution is recorded. | |
| SuperannuationLine_LiabilityAccountCode | String | False |
The account code assigned to the superannuation liability. This code corresponds to the liability account where the employer's superannuation obligations are tracked until paid. | |
| SuperannuationLine_PaymentDateForThisPeriod | Date | False |
The date on which the superannuation payment for the current period is due or was made. This ensures accurate tracking of payment dates for superannuation contributions. | |
| SuperannuationLine_Percentage | Double | False |
The percentage rate of the employee's salary that is contributed to their superannuation fund. This percentage is typically governed by government regulations or company policy. | |
| SuperannuationLine_Amount | Decimal | False |
The actual dollar amount of superannuation contributed to the employee's super fund for this specific period. This is calculated based on the percentage or fixed amount contribution type. | |
| TenantId | String | False |
The unique identifier for the tenant (organization) in Xero. This ensures the payslip's superannuation details are linked to the correct organization and payroll system. |