PaySlipSuperannuations

Query payslip superannuation line-items for a Xero organisation.

Table Specific Information

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

Name	Type	Filterable	Description
Id [KEY]	String		The earnings line-item combined with the unique Xero identifier of the payslip
PayslipID	String		The unique identifier of the payslip. This field is assigned by Xero.
EmployeeID	String		The unique identifier of the payslip's employee.
SuperannuationLine_SuperMembershipId	String		The unique identifier of the line-item's super fund.
SuperannuationLine_ContributionType	String		The super contribution type
SuperannuationLine_CalculationType	String		The super calculation type
SuperannuationLine_MinimumMonthlyEarnings	Decimal		The super minimum monthly earnings
SuperannuationLine_ExpenseAccountCode	String		The super expense account code
SuperannuationLine_LiabilityAccountCode	String		The super liability account code
SuperannuationLine_PaymentDateForThisPeriod	Date		The super payment date for this period
SuperannuationLine_Percentage	Double		The super percentage
SuperannuationLine_Amount	Decimal		The super amount
TenantId	String		The ID of the tenant to query instead of the connection tenant