Contacts

Columns

Name

Type

ReadOnly

Description

ContactId [KEY]

String

True

The unique Xero identifier for the contact.

Name

String

False

The contact name.

AccountNumber

String

False

The account number associated with the contact.

ContactNumber

String

False

An identifier from an external system. Although this field is read-only on the Xero contact screen, it can be updated via the API.

ContactStatus

String

False

The status of the contact. Available status types are ACTIVE or ARCHIVED.

FirstName

String

False

The first name of the contact. The maximum length of this field is 255 characters.

LastName

String

False

The last name of the contact. The maximum length of this field is 255 characters.

EmailAddress

String

False

The email address of the contact. The maximum length of this field is 500 characters.

SkypeUserName

String

False

The Skype username of the contact.

ContactPerson1_FirstName

String

False

First name of contact person.

ContactPerson1_LastName

String

False

Last name of contact person.

ContactPerson1_EmailAddress

String

False

Email address name of contact person.

ContactPerson1_IncludeInEmails

Boolean

False

Whether to include contact person in emails.

ContactPerson2_FirstName

String

False

First name of contact person.

ContactPerson2_LastName

String

False

Last name of contact person.

ContactPerson2_EmailAddress

String

False

Email address name of contact person.

ContactPerson2_IncludeInEmails

Boolean

False

Whether to include contact person in emails.

ContactPerson3_FirstName

String

False

First name of contact person.

ContactPerson3_LastName

String

False

Last name of contact person.

ContactPerson3_EmailAddress

String

False

Email address name of contact person.

ContactPerson3_IncludeInEmails

Boolean

False

Whether to include contact person in emails.

ContactPerson4_FirstName

String

False

First name of contact person.

ContactPerson4_LastName

String

False

Last name of contact person.

ContactPerson4_EmailAddress

String

False

Email address name of contact person.

ContactPerson4_IncludeInEmails

Boolean

False

Whether to include contact person in emails.

BankAccountDetails

String

False

The bank account number of the contact.

TaxNumber

String

False

The region-specific tax number of the contact: the ABN (Australia), GST (New Zealand), VAT (UK), or Tax Id Number (US and global).

AccountsReceivableTaxType

String

False

The default tax type used for the contact on accounts-receivable invoices.

AccountsPayableTaxType

String

False

The default tax type used for the contact on accounts-payable invoices.

Street_AddressLine1

String

False

Line 1 of the address.

Street_AddressLine2

String

False

Line 2 of the address.

Street_AddressLine3

String

False

Line 3 of the address.

Street_AddressLine4

String

False

Line 4 of the address.

Street_City

String

False

The city.

Street_Region

String

False

The region.

Street_PostalCode

String

False

The postal code.

Street_Country

String

False

The country.

Street_AttentionTo

String

False

The attention-to line of the address.

POBox_AddressLine1

String

False

Line 1 of the address.

POBox_AddressLine2

String

False

Line 2 of the address.

POBox_AddressLine3

String

False

Line 3 of the address.

POBox_AddressLine4

String

False

Line 4 of the address.

POBox_City

String

False

The city.

POBox_Region

String

False

The region.

POBox_PostalCode

String

False

The postal code.

POBox_Country

String

False

The country.

POBox_AttentionTo

String

False

The attention-to line of the address.

DDI_PhoneNumber

String

False

The phone number without area or country code.

DDI_PhoneAreaCode

String

False

The area code.

DDI_PhoneCountryCode

String

False

The country code.

Default_PhoneNumber

String

False

The phone number without area or country code.

Default_PhoneAreaCode

String

False

The area code.

Default_PhoneCountryCode

String

False

The country code.

Fax_PhoneNumber

String

False

The phone number without area or country code.

Fax_PhoneAreaCode

String

False

The area code.

Fax_PhoneCountryCode

String

False

The country code.

Mobile_PhoneNumber

String

False

The phone number without area or country code.

Mobile_PhoneAreaCode

String

False

The area code.

Mobile_PhoneCountryCode

String

False

The country code.

UpdatedDateUTC

Datetime

True

The timestamp of when the contact was last updated.

ContactGroupId

String

True

Displays which contact groups a contact is included in.

IsSupplier

Boolean

True

This field shows whether a contact has any accounts-payable (AP) invoices. This field is set automatically when an AP invoice is generated for a contact.

IsCustomer

Boolean

True

This field shows whether a contact has any accounts-receivable (AR) invoices. This field is set automatically when an AR invoice is generated for a contact.

DefaultCurrency

String

False

The default currency for the contact.

Website

String

True

The website of the contact.

BrandingThemeId

String

True

The Id of the branding theme.

BrandingThemeName

String

True

The Name of the branding theme.

PurchasesDefaultAccountCode

String

False

The default purchases account code for contacts.

SalesDefaultAccountCode

String

False

The default sales account code for contacts.

BatchPayments_BankAccountNumber

String

True

Batch payment bank account number for the contact.

BatchPayments_BankAccountName

String

True

Batch payment bank account name for the contact.

BatchPayments_Details

String

True

Batch payment details for the contact.

Discount

Decimal

True

The default discount rate for the contact.

Balances_AccountsReceivable_Outstanding

Decimal

True

The outstanding and overdue amounts for sales invoices (accounts receivable).

Balances_AccountsReceivable_Overdue

Decimal

True

The outstanding and overdue amounts for bills (accounts payable).

Balances_AccountsPayable_Outstanding

Decimal

True

The outstanding and overdue amounts for sales invoices (accounts receivable).

Balances_AccountsPayable_Overdue

Decimal

True

The outstanding and overdue amounts for bills (accounts payable).

PaymentTerms_Bills_Day

Int

True

The default payment terms for the contact.

PaymentTerms_Bills_Type

String

True

The default payment terms for the contact.

PaymentTerms_Sales_Day

Int

True

The default payment terms for the contact.

PaymentTerms_Sales_Type

String

True

The default payment terms for the contact.

SalesTrackingCategory1_Name

String

False

The default sales tracking category name for contacts.

SalesTrackingOption1_Name

String

False

The default sales tracking option name for contacts.

SalesTrackingCategory2_Name

String

False

The default sales tracking category name for contacts.

SalesTrackingOption2_Name

String

False

The default sales tracking option name for contacts.

PurchaseTrackingCategory1_Name

String

False

The default purchase tracking category name for contacts.

PurchaseTrackingOption1_Name

String

False

The default purchase tracking option name for contacts.

PurchaseTrackingCategory2_Name

String

False

The default purchase tracking category name for contacts.

PurchaseTrackingOption2_Name

String

False

The default purchase tracking option name for contacts.

HasAttachments

Boolean

True

This field indicates whether the invoice has an attachment.

TenantId

String

False

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

Last updated