JDBC Driver for Xero

Build 22.0.8462

SuperFunds

Query, insert and update add and update Payroll Super Funds in a Xero organisation.

Columns

Name Type ReadOnly Filterable Description
SuperFundID [KEY] String True

Xero Identifier.

Type String True

REGULATED, or SMSF.

Name String False

Name of the Super fund.

ABN String False

ABN of the Super Fund.

USI String False

USI of the Regulated Super Fund.

BSB String False

BSB of the Self Managed Super Fund.

AccountNumber String False

The account number for the self managed super fund.

AccountName String False

The account name for the self managed super fund.

ElectronicServiceAddress String False

The electronic service address for the self managed super fund.

EmployerNumber String False

Some funds assign a unique number to each employer.

SPIN String False

The SPIN of the Regulated SuperFund (deprecated).

UpdatedDateUTC String False

The date of the last update to this row

TenantId String False

The ID of the tenant to query instead of the connection tenant

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462