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