Skip to main content

Customers

Written by Nick Maxwell

Data Dictionary

Your business customer records with contact details, delivery addresses, and payment terms.Useful for sales reporting, identifying top buyers, tracking credit limits, and managing relationships — e.g., finding which customers are overdue on outstanding balances or grouping revenue by customer segment.

Field

Type

Notes

Addresses

JSON

API: Array of Customer.Addresses

Bank Account

Text

API: Customer.BankAccount

Bank Branch

Text

API: Customer.BankBranch

Bank Name

Text

API: Customer.BankName

Connection ID

Integer

The Connectorly Connection ID. If you group Connectorly's together, then you will see a Connection ID for each one. Organisations has the corresponding Connection Name for each Connection ID.

Contact Name

Text

Derived from combining Customer.ContactFirstName and Customer.ContactLastName

Created

Datetime

Derived from datetime with timezone conversion of Created

Created By

Text

API: Customer.CreatedBy

Currency

Text

The ISO Currency Code, API: Currency.CurrencyCode

Customer Code

Text

API: Customer.CustomerCode

Customer GUID

Text

Unique ID for a Customer, API: Customer.Guid

Customer Name

Text

Derived from cleaning Customer.CustomerName

Customer Type

Text

API: Customer.CustomerType

DDI Number

Text

API: Customer.DDINumber

Data current as of

Datetime

Gives the date and time that this record was taken from Unleashed.

Discount Rate

Number

API: Customer.DiscountRate

Email

Text

API: Customer.Email

Email cc

Text

API: Customer.EmailCC

Fax Number

Text

API: Customer.FaxNumber

First Name

Text

API: Customer.ContactFirstName

Last Name

Text

API: Customer.ContactLastName

Mobile Number

Text

API: Customer.MobileNumber

Notes

Text

API: Customer.Notes

Obsolete

Boolean

API: Customer.Obsolete

Payment Term

Text

API: Customer.PaymentTerm

Phone Number

Text

API: Customer.PhoneNumber

Print Invoice

Boolean

API: Customer.PrintInvoice

Print Packing Slip Instead Of Invoice

Boolean

API: Customer.PrintPackingSlipInsteadOfInvoice

Sales Person

Text

API: Customer.Salesperson

Sell Price Tier

Text

API: Customer.SellPriceTier

Sell Price Tier Reference

Text

API: Customer.SellPriceTierReference

Stop Credit

Boolean

API: Customer.StopCredit

Tax Code

Text

API: Customer.TaxCode

Tax Number

Text

Tax Number e.g. VAT or GST Number, API: Customer.GSTVATNumber

Tax Rate

Text

API: Customer.TaxRate

Taxable

Boolean

API: Customer.Taxable

Toll Free Number

Text

API: Customer.TollFreeNumber

Updated

Datetime

Derived from datetime with timezone conversion of Updated

Updated By

Text

API: Customer.LastModifiedBy

Website

Text

API: Customer.Website

Xero Cost Of Goods Account

Text

API: Customer.XeroCostOfGoodsAccount

Xero Sales Account

Text

API: Customer.XeroSalesAccount

Did this answer your question?