Organisation

Columns

Name

Type

Description

ShortCode [KEY]

String

A unique identifier for the organisation.

APIKey

String

Unique APIKey for Xero-to-Xero transactions.

Name

String

Display name of the organisation shown in Xero.

LegalName

String

Organisation name shown on reports.

PaysTax

Boolean

Whether the organisation is registered with a local tax authority.

Version

String

The version of Xero used by the organisation.

BaseCurrency

String

Default currency for the organisation.

CountryCode

String

Country code for the organisation.

IsDemoCompany

String

Whether the organisation is a demo company.

OrganisationStatus

String

Will be set to ACTIVE if you can connect to the organisation via the Xero API.

RegistrationNumber

String

The registration number for NZ, AU, and UK organisations.

TaxNumber

String

Tax number of the organisation.

FinancialYearEndDay

String

Financial year end day of the organisation. For example, 1-31.

FinancialYearEndMonth

String

Financial year end month of the organisation. For example, 1-12.

PeriodLockDate

Date

Period lock date of the organisation.

EndOfYearLockDate

Date

End of year lock date of the organisation.

CreatedDateUTC

Datetime

Timestamp of when the organisation was created in Xero.

UpdatedDateUTC

Datetime

Timestamp of the last change to the user record.

OrganisationEntityType

String

The entity type of the organisation. For example, COMPANY.

Timezone

String

The time zone for the organisation.

Edition

String

BUSINESS or PARTNER. Parnter edition organizations have restricted functionality.

Class

String

One of: DEMO, TRIAL, STARTER, STANDARD, PREMIUM, PREMIUM_20, PREMIUM_50, PREMIUM_100, LEDGER, GST_CASHBOOK, NON_GST_CASHBOOK.

LineOfBusiness

String

Description of business type of the organisation.

Street_AddressLine1

String

The street address line 1.

Street_AddressLine2

String

The street address line 2.

Street_AddressLine3

String

The street address line 3.

Street_AddressLine4

String

The street address line 4.

Street_City

String

The street address city.

Street_PostalCode

String

The street address postal code.

Street_Country

String

The street address country.

Street_Region

String

The street address region.

Street_AttentionTo

String

The street address attention-to line.

POBox_AddressLine1

String

The PO box address line 1.

POBox_AddressLine2

String

The PO box address line 2.

POBox_AddressLine3

String

The PO box address line 3.

POBox_AddressLine4

String

The PO box address line 4.

POBox_City

String

The PO box address city.

POBox_PostalCode

String

The PO box address postal code.

POBox_Country

String

The PO box address country.

POBox_Region

String

The PO box address region.

POBox_AttentionTo

String

The PO box address attention-to line.

DDI_PhoneNumber

String

The DDI phone number.

DDI_PhoneAreaCode

String

The DDI area code.

DDI_PhoneCountryCode

String

The DDI country code.

Default_PhoneNumber

String

The default phone number.

Default_PhoneAreaCode

String

The default area code.

Default_PhoneCountryCode

String

The default country code.

Fax_PhoneNumber

String

The fax phone number.

Fax_PhoneAreaCode

String

The fax area code.

Fax_PhoneCountryCode

String

The fax country code.

Mobile_PhoneNumber

String

The mobile phone number.

Mobile_PhoneAreaCode

String

The mobile area code.

Mobile_PhoneCountryCode

String

The mobile country code.

Facebook_URL

String

The URL to the Facebook page of the organisation.

Twitter_URL

String

The URL to the Twitter page of the organisation.

GooglePlus_URL

String

The URL to the Google Plus page of the organisation.

LinkedIn_URL

String

The URL to the LinkedIn page of the organisation.

Website_URL

String

A URL to the website of the organisation.

PaymentTerms_Bills_Day

String

Default payment terms for bills (days).

PaymentTerms_Bills_Type

String

Default payment terms for bills (type).

PaymentTerms_Sales_Day

String

Default payment terms for sales (days).

PaymentTerms_Sales_Type

String

Default payment terms for sales (type).

TenantId

String

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

Last updated